wide-cartoon-5349
09/05/2025, 4:18 PMbrash-pillow-71627
09/05/2025, 4:18 PMbrash-pillow-71627
09/05/2025, 4:18 PMwide-cartoon-5349
09/05/2025, 4:36 PMSELECT
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 null
brash-pillow-71627
09/05/2025, 4:37 PMbrash-pillow-71627
09/05/2025, 4:37 PMsql 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.string_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 null
If this still returns no rows, test by removing the two key filters to verify events exist, then re-check dataset/table names and the GA4→BQ export timing. ([GA4 common issues](https://docs.growthbook.io/kb/google-analytics/google-analytics-ga4-troubleshooting#common-issues-when-integrating-ga4-with-growthbook))wide-cartoon-5349
09/09/2025, 1:50 PMbrash-pillow-71627
09/09/2025, 1:50 PMbrash-pillow-71627
09/09/2025, 1:51 PMsql 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.string_value AS variation_id 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 null
If this still returns no rows, it almost always points to either a variation_id type mismatch or querying the wrong dataset/tables. Once the EAQ test returns rows, GrowthBook results should populate after refresh. [[GA4 common issues](https://docs.growthbook.io/kb/google-analytics/google-analytics-ga4-troubleshooting#common-issues-when-integrating-ga4-with-growthbook); [BQ timing](https://docs.growthbook.io/kb/google-analytics/google-big-query-bq-troubleshooting)]