Hey Growthbook team, I have a question regarding metrics which I hope you can help me understand. Just to clarify a few details of our setup, we have both the JS and PHP SDK setup successfully with

experiment_viewed

event setup and pushing through the DL into GA4 and into BigQuery. We also have the

gb_user_id

in the event pushing successfully for each unique session. -- My question is, when we have an experiment setup and the

experiment_viewed

successfully firing with the correct experiment_id, variation_id and gb_user_id, do all the metrics for that experiment that are triggered based on GA4 events - e.g. add to cart, purchase need to have matching

gb_user_id

within the metric setup in GB? For example this is our current add_to_cart metric.

SELECT
  (select value.string_value from unnest(user_properties) where key = 'gb_user_id') as consumer,
  (select value.string_value from unnest(event_params) where key = 'page_location') as page_location,
  event_name,
  TIMESTAMP_MICROS(event_timestamp) as timestamp,
  1 as value
FROM
  `growthbook-377317`.`analytics_320607085`.`events_*`
WHERE
  event_name = 'add_to_cart'
  AND (select value.string_value from unnest(user_properties) where key = 'gb_user_id') is not null
  AND ((_TABLE_SUFFIX BETWEEN '{{date startDateISO "yyyyMMdd"}}' AND '{{date endDateISO "yyyyMMdd"}}') OR
       (_TABLE_SUFFIX BETWEEN 'intraday_{{date startDateISO "yyyyMMdd"}}' AND 'intraday_{{date endDateISO "yyyyMMdd"}}'))

⭐ Our official support hours are 6:30am - 5pm Pacific Time, Monday through Friday. You may occasionally hear from us outside of these hours. Your support request has been logged in our system. Our support team will get back to you very soon!

Hi Myles, thanks for reaching out! I’ve added your support request to the queue and we’ll follow up as soon as we can 😀

I just want to confirm some further notes on this. So we are pushing

gb_user_id

into

user_properties

- we are seeing sporadically that on multiple events we are missing gb_user_id from say add_to_cart, view_item, purchase etc… I don’t know GA4 and Bigquery connection well enough but could it be pushing into the user_properties that is causing the issues? Would we be safer pushing into event_params?

Hi Myles, I spent some time trying to figure this out for you but need to speak with one of our BigQuery specialists in order to say for sure what the best approach is. I'll update you here once I have more info.

I’m not sure if that is the issue - but there are some ways to check