Hi you all.
I just discovered GrowthBook and have tried creating a demo A/B test to test it out.
Unfortunately im running into problems viewing the experiments results - it keeps saying "No data yet".
I'm using Google Analytics as the data source and have done everything stated in the docs, BigQuery link... The events was automatically found and does in fact return results. However using the events inside an experiment I never get anything. I'm not so strong in SQL so I find it difficult debugging the query.
Can any of you guys point me in a direction or tell me what you need from me to be able to help?
Thanks so much. I really look forward to experiencing GrowthBook working!
f
fresh-football-47124
10/22/2024, 8:00 AM
Do you see the experiment viewed events in ga?
s
straight-mechanic-50025
10/22/2024, 8:06 AM
Yes, experiment_viewed shows in GA
f
fresh-football-47124
10/22/2024, 8:16 AM
Okay
fresh-football-47124
10/22/2024, 8:17 AM
If you click on the three dots on the experiment results, and click on view queries- do you see any data?
s
straight-mechanic-50025
10/22/2024, 8:24 AM
"No rows returned"
straight-mechanic-50025
10/23/2024, 8:29 AM
I'm back again as I think i've narrowed down the issue.
I grabbed the query for one of the metrics by being in experiment/3 dots/view queries/view_cart. This I plugged into BigQuery directly and removed stuff until it returned anything.
The query (pastebin):
https://hastebin.skyra.pw/lasebifasi.pgsql
I uncommented these two in line 27-28
-- AND experiment_id_param.key = 'experiment_id'
-- AND variation_id_param.key = 'variation_id'
And after that I atleast got something
variation | dimension | users | main_sum | main_sum_squares
___multiple___ | empty | 22726 | 33 | 33.0