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

big-breakfast-90296

09/15/2023, 12:00 AM
Hi team Not sure if here is the right place to ask. Like many of you I am also new to GrowthBook trying to run my first test and encountered a problem I am connected to my GA4 through Bigquery have a problem in defining metrics they all have been auto discovered and queries seem to be working when tested in metric section (I click on refresh data and it retrieves data) However when running the experiment I receive this error on all my metrics:
Copy code
Table "events_*" must be qualified with a dataset (e.g. dataset.table).
the error makes sense as "event_*" is not preceded by a dataset it seems that the query I see here in experiment has got additional lines. I don't know how to edit this final query as the query in Metric section is all fine Thanks everyone for looking into it
h

helpful-application-7107

09/15/2023, 12:32 AM
Go to Data Sources on the left side and find your datasource. Then fix the Experiment Assignment Query on the data source page
b

big-breakfast-90296

09/15/2023, 12:39 AM
Thanks Luke It worked You're a legend 🙂
🎉 1
g

green-tomato-52360

09/21/2023, 9:31 PM
Thanks, We had the same error, we can now execute the query. But it shows us "No rows returned". We are also connected to GA4 through Bigquery. We have a question, is it necessary to send the "experiment_viewed" as an event to be able to obtain metrics in the experiment?
b

big-breakfast-90296

09/22/2023, 12:21 AM
Not sure Robert, but I think it is. I did it and created a tag in GTM as well. the part at the bottom of this page should help: https://docs.growthbook.io/guide/GA4-google-analytics
g

green-tomato-52360

09/22/2023, 3:46 PM
Thanks I'll check it out
b

brief-honey-45610

09/22/2023, 7:14 PM
Hi Robert, that’s correct, you’ll need to send experiment_viewed so that the analysis can differentiate between users who did and didn’t see the experiment.
g

green-tomato-52360

09/22/2023, 10:57 PM
Ok, thanks for responding