https://www.growthbook.io/ logo
Join Slack
Powered by
Hi. Have trouble retrieving data from GA4 for expe...
# ask-questions
a
Hi. Have trouble retrieving data from GA4 for experiment I've setup. The data seems to be logged in GA4 (see screenshot). I've followed the wizard to set up the visual experiment and it does flip between a and b variants on the web but I can't seem to figure out why the data is not being retrieved (its been over a week). Any pointers?
f
can you share the screen shot of the experiment results page? are you using any activation metrics?
how about a conversion window?
a
I'm not sure about "activation metrics", it's my first experiment on growthbook, so I have not much clue what im doing
f
one thing to test, is to go to the data source page, and edit the assignment query for your anonymous visitors - click 'test query' and see if it returns results
a
somehwere here?
f
ya, three dots menu -> edit query - > customize SQL -> test query
a
Screenshot 2025-05-29 at 09.17.55.png
f
okay, cool - so either its not syncing to BigQuery (or not syncing yet) or the query is wrong
can you see any experiment_viewed events in BigQuery?
a
I have to check that in google cloud console?
f
yes
based on how many event tables you have, it looks like have that set up for days
a
trying to figure out how to that, one sec
f
do you know SQL?
a
Normal SQL yes, this big query not at all
f
heh
a
especially on google cloud
f
you can do it with a simple query
a
but if i understand correctly there is no data past april
f
SELECT user_pseudo_id as anonymous_id, TIMESTAMP_MICROS(event_timestamp) as timestamp, experiment_id_param.value.string_value AS experiment_id, variation_id_param.value.int_value AS variation_id, geo.country as country, traffic_source.source as source, traffic_source.medium as medium, device.category as device, device.web_info.browser as browser, device.operating_system as os FROM 
growthbook-ga4
.
analytics_285015456
.
events_*
, UNNEST(event_params) AS experiment_id_param, UNNEST(event_params) AS variation_id_param WHERE event_name = 'experiment_viewed' LIMIT 20;
a
Looks like i don't have enough permissions (im not a project owner)
but to be fair, its exactly the same issue in growthbook as well:
f
oh
a
there is no newer data than april
f
growthbook is spelled wrong - should be growtbook
you can edit the query
SELECT user_pseudo_id as anonymous_id, TIMESTAMP_MICROS(event_timestamp) as timestamp, experiment_id_param.value.string_value AS experiment_id, variation_id_param.value.int_value AS variation_id, geo.country as country, traffic_source.source as source, traffic_source.medium as medium, device.category as device, device.web_info.browser as browser, device.operating_system as os FROM 
growtbook-ga4
.
analytics_285015456
.
events_*
, UNNEST(event_params) AS experiment_id_param, UNNEST(event_params) AS variation_id_param WHERE event_name = 'experiment_viewed' LIMIT 20;
ya, that is a bit odd - it looks like it was date partitioning every 1 to 2 days - I wonder if something changed- are there any logs in BigQuery or the data sync showing its not working?
a
sorted DESC myself, but this is old data
I'm not entirely sure, we did one dummy experiment in april (no variants nothing), and it collected the data and it was working, now first proper experiment and no data
should i just remove and re-add ga4 data source or smth?
f
I'd check the BigQuery link in GA4
see if it tells you anything
a
in google analytics itself?
this place?
I think the issue is related to billing account / 60 day history. Working sorting billing.
f
ok
a
Thanks for your help figuring this out. After sorting the billing / 60 day limit on google cloud data came through. 🙏
👍 2
3 Views
Open in Slack
PreviousNext
Powered by