https://www.growthbook.io/ logo
#announcements
Title
# announcements
s

swift-traffic-3201

02/07/2023, 7:06 AM
Hey, I am trying to create an experiment with google analytics v4 datasource. I setup the query to get the data from bigquery in the metrics and it is working fine. But inside the experiment, in the query generated it is showing
event_*
instead of the source dataset path like in the screenshot. This is causing an error saying
Table "events_*" must be qualified with a dataset (e.g. dataset.table).
Any idea whats causing this ?
In another experiment I created, when I keep refreshing the dataset source is changing but with the wrong big query project name.
f

fresh-football-47124

02/07/2023, 1:17 PM
Were you able to edit the queries?
If you go to analysis -> data source and you can edit the experiment query
s

swift-traffic-3201

02/07/2023, 2:03 PM
No. I am unable to edit the table
event_*
in the query that create
Copy code
__rawExperiment
By option to edit experiment query, did you mean
Experiment Assignment Queries
?
f

fresh-football-47124

02/07/2023, 6:40 PM
yes
s

swift-traffic-3201

02/08/2023, 7:34 AM
Thanks @fresh-football-47124. It worked. But now the data from metrics is not showing up in the experiment. Both are using same table and same experiment id. I tried changing the settings.
f

fresh-football-47124

02/08/2023, 2:46 PM
You may have to look into that metric and make sure that when we join to the experiments the user ids are the same - the common table expressions in the view queries should make it straightforward to debug
153 Views