Hey, I am trying to create an experiment with goog...
# announcements
s
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
Were you able to edit the queries?
If you go to analysis -> data source and you can edit the experiment query
s
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
yes
s
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
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
211 Views