Hi all, we just started implementing Growthbook and our setup basically works, but I have a question around tracking Click Through Rate. We are a news publisher and our frontpage has many modules containing news articles. What we mainly test is different module versions (personalized vs. curated for example). All these module boxes have view and click tracking, so we are able to calculate a click through rate. However, what I don't understand is, how we would be able to create a general click through rate metric, that works for the exact module box that is in the specific experiment. We can manually create separate click through rates for each module, but that seems exhaustive. Any tips and tricks? Can I use some kind of variable in the SQL, that filters for an experiment id? Other workarounds? Thanks for your help!

Hi @flat-park-58308. I may need some more info, but here's what I'd try first. I think you should be able to use this SQL variable

{{experimentId}}

for your use case. https://docs.growthbook.io/app/datasources#sql-templates

Thank you @strong-mouse-55694, that's exactly what I was looking for! I've seen this before, with a limited number of template variables and without experimentId: https://docs.growthbook.io/app/query-optimization#sql-template-variables

Great. Let me know how it works.