I'm trying to figure out why is it that when I set up an experiment previously using a particular metric it pulled the data just fine but when I use that same metric in a new experiment it returns no results. My set up is using the GA4 / Big Query integration. I tried to diff the SQL queries it was using in both instances and noticed a number of unexpected differences towards the bottom that I wasn't sure how to explain (we have upgraded to the latest version in the meantime is the only clue I could think of compared to using a self hosted version from Jan 2023 originally).
But I wanted to ask if this looked normal to anyone or if they could provide any insights at all.
06/23/2023, 5:07 PM
That diff is from the time, which is usually a template variable and pulled from the experiment date window
If you run just that rawExperiment query itself, do you get results for the new SQL query?
06/26/2023, 9:30 AM
Hmm was that also true from line 93 onwards? I'm not great with SQL so I apologise if it's a silly question but that was what looked off to me
06/27/2023, 4:34 AM
might be easier to book some time with us to help you figure it out