I can see experiment data in BigQuery, but in Grow...
# ask-questionsw
wide-cartoon-5349
09/05/2025, 4:17 PMI can see experiment data in BigQuery, but in Growthbook I get "No data yet. Make sure your Experiment is tracking properly."
I'm using the Script Tag SDK with GA4 (hardcoded).
Any ideas on how to fix this?
Thanks!!
wide-cartoon-5349
09/05/2025, 4:31 PMThis is the Anonymous Visitors query that Growthbook generated, but when I test it, it gives me the error "No rows returned, could not verify result"
Copy code
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
`learning-heroes-bq`.`analytics_372696867`.`events_*`,
UNNEST(event_params) AS experiment_id_param,
UNNEST(event_params) AS variation_id_param
WHERE
((_TABLE_SUFFIX BETWEEN '{{date startDateISO "yyyyMMdd"}}' AND '{{date endDateISO "yyyyMMdd"}}') OR
(_TABLE_SUFFIX BETWEEN 'intraday_{{date startDateISO "yyyyMMdd"}}' AND 'intraday_{{date endDateISO "yyyyMMdd"}}'))
AND event_name = 'experiment_viewed'
AND experiment_id_param.key = 'experiment_id'
AND variation_id_param.key = 'variation_id'
AND user_pseudo_id is not nullwide-cartoon-5349
09/05/2025, 4:57 PMKapa solved it 🙂
wide-cartoon-5349
09/05/2025, 4:57 PMamazing AI!
b
brief-honey-45610
09/05/2025, 5:38 PMHi Luan, that's great to hear!
brief-honey-45610
09/05/2025, 5:39 PMWas it something wrong with the Experiment Assignment query of the Metric SQL?
brief-honey-45610
09/05/2025, 5:39 PMOne or the other of those is usually the culprit if the data is showing up in BigQuery but not in GrowthBook.
w
wide-cartoon-5349
09/05/2025, 5:39 PMI used the query kapa suggested: https://growthbookusers.slack.com/archives/C06JQ8WNQVA/p1757090246480999?thread_ts=1757089114.473779&cid=C06JQ8WNQVA
wide-cartoon-5349
09/05/2025, 5:40 PMthe last line of the query that GB created seems to be the issue
b
brief-honey-45610
09/05/2025, 5:40 PMAhhh that's great!
w
wide-cartoon-5349
09/09/2025, 4:11 PM@brief-honey-45610 I can see the table with the metrics in the "results" tab but the metrics are all in 0. How could I fix this?
Also, for some reason I have activated the streaming feature with GA4 and BQ but data updates once per hour, any idea on how to make it so data updates every few minutes?
23 Views