Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
Normal
Hi, for anyone with a similar question, the custom definitions set in GA4 will come through to the BigQuery export in the event_params field.To extract these you can use a query like below, where you have a sub-query within the main query that extracts the specified parameter from the event_params - just update the name_of_parameter below with the custom definition you wish to extract.SELECT(SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'name_of_parameter')FROM `<project>.<dataset>.<table>`For more info, I've found this guide really useful: extracting ga4 event parameters in bigquery
Hi, for anyone with a similar question, the custom definitions set in GA4 will come through to the BigQuery export in the event_params field.
To extract these you can use a query like below, where you have a sub-query within the main query that extracts the specified parameter from the event_params - just update the name_of_parameter below with the custom definition you wish to extract.
SELECT
(SELECT value.string_value FROM UNNEST(event_params) WHERE key = 'name_of_parameter')
FROM `<project>.<dataset>.<table>`
For more info, I've found this guide really useful: extracting ga4 event parameters in bigquery
