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/

That diff is from the time, which is usually a template variable and pulled from the experiment date window

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

might be easier to book some time with us to help you figure it out

That's super generous, thank you. Just booked it now 😉