https://www.growthbook.io/ logo
w

worried-yacht-64692

06/21/2023, 4:25 PM
Hi folks, 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. https://www.diffchecker.com/ML544aWs/
f

fresh-football-47124

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?
w

worried-yacht-64692

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
f

fresh-football-47124

06/27/2023, 4:34 AM
might be easier to book some time with us to help you figure it out
w

worried-yacht-64692

06/27/2023, 1:51 PM
That's super generous, thank you. Just booked it now 😉
2 Views