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:

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

Go to Data Sources on the left side and find your datasource. Then fix the Experiment Assignment Query on the data source page

Thanks Luke It worked You're a legend 🙂

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?

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

Thanks I'll check it out

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.

Ok, thanks for responding