Hey guys,
I'm trying to use GA4 with BQ as databa...
# announcementss
some-fireman-7578
08/30/2023, 7:03 PMHey guys,
I'm trying to use GA4 with BQ as database in Growthbook, but I'm having this error before start the experiment. I think that the error could be the table events* we use a wildcard, so it's different, but I do not know how to change this.
Anyone knows how could I fix this?
f
fresh-football-47124
08/30/2023, 7:04 PM
is this a new data source?
fresh-football-47124
08/30/2023, 7:04 PM
did you add the project id and dataset id?
fresh-football-47124
08/30/2023, 7:05 PM
you can edit that query from metrics & data -> data sources
s
some-fireman-7578
08/31/2023, 10:10 PMSorry my late, Graham!
I solved the last problem with your help, but now, I got this message when I try to run an experiment again.
Maybe this could be set in a different part of our project, but I didn't realize where.
some-fireman-7578
08/31/2023, 10:10 PMwhere 'my_dataset' is defined?
some-fireman-7578
08/31/2023, 10:11 PMI'm setting both fields in dataset screen.
f
fresh-football-47124
08/31/2023, 10:12 PM
editing them after you’ve created the data source, won’t udate the sql queries
fresh-football-47124
08/31/2023, 10:12 PM
so you’ll have to edit it in the assignment query sections
s
some-fireman-7578
08/31/2023, 10:19 PMSo I need to create the metrics from 0 or a new experment?
some-fireman-7578
08/31/2023, 10:20 PMI create the metrics again, but still get this message
f
fresh-football-47124
08/31/2023, 10:21 PM
yes, that doesnt look right
fresh-football-47124
08/31/2023, 10:21 PM
what is the query?
s
some-fireman-7578
08/31/2023, 10:21 PMimage.png
f
fresh-football-47124
08/31/2023, 10:21 PM
the project id and dataset id usually have numbers
fresh-football-47124
08/31/2023, 10:21 PM
do you have access to bigQuery?
s
some-fireman-7578
08/31/2023, 10:31 PMYes. When I click to see the schema, I can see without problems
some-fireman-7578
08/31/2023, 10:32 PMI create my experiment and when I go to see the results with the metrics choosed, I got this
f
fresh-football-47124
09/01/2023, 8:12 AM
correct
fresh-football-47124
09/01/2023, 8:12 AM
the schema browser uses the settings in the connection info
fresh-football-47124
09/01/2023, 8:13 AM
but each query will have <project id>.<dataset id>.events_* in it
fresh-football-47124
09/01/2023, 8:13 AM
and in your case, those values are wrong either in the metric query, or the assignment query
fresh-football-47124
09/01/2023, 8:13 AM
(or both)
72 Views