Hi, I can’t get GrowthBook to find metric or experiment results from BigQuery (using GA4). I would b...
s

Shelagh Lewins

over 2 years ago
Hi, I can’t get GrowthBook to find metric or experiment results from BigQuery (using GA4). I would be very grateful for any help as I’ve been struggling with this all week and can’t see what I’m doing wrong! I have a webpage with a button that sends an event “Main CTA” when clicked, and a feature “new-main-panel” which determines which version of the UI the user sees (both have the button). GA4 events are logged as per GrowthBook instructions and connected to BigQuery. I can see the events in BigQuery and they look correct. GrowthBook can connect to BigQuery; but my metric, after a brief blip, is showing nothing and my experiment has no data. BigQuery table: my onclick event that I’m measuring is “Main CTA”, and on login I’m setting user_id. I’m also sending the experiment_viewed event and that looks OK too. I can’t see anything wrong in the BigQuery data, see an example below: Metric: the SQL looks OK, it’s looking for the event “Main CTA”, see screenshot. But when I run the metric query, it only goes to 15 March and shows no data for the last few days, see screenshot. This is the full metric query:
SELECT
user_id,
user_pseudo_id as anonymous_id,
TIMESTAMP_MICROS(event_timestamp) as timestamp
FROM
``analytics_xxxxxx.events_*``
WHERE
event_name = 'Main CTA'
AND _TABLE_SUFFIX BETWEEN '{{startYear}}{{startMonth}}{{startDay}}' AND '{{endYear}}{{endMonth}}{{endDay}}'
My experiment based on this metric is running without error but showing no data. I must be missing something really simple…it’s so close to working! But I can’t think of anything else to check.