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
It's not actually the custom definitions from GA4 being pushed into the event_params field; it's whatever was being pushed into GA4 is being sent to BigQuery. Even if you don't have an attribute setup as a custom dimension or metric in GA4, it will still be available in BigQuery.Also keep in mind that event parameters are not always strings. For example, in the ASC specification, the vehicle year is pushed as an integer, so the way that would be queried is like this:(SELECT value.int_value FROM UNNEST(event_params) WHERE key = 'item_year') AS vehicle_year,int_value versus string_value. There's also other data types as well.
It's not actually the custom definitions from GA4 being pushed into the event_params field; it's whatever was being pushed into GA4 is being sent to BigQuery. Even if you don't have an attribute setup as a custom dimension or metric in GA4, it will still be available in BigQuery.
Also keep in mind that event parameters are not always strings. For example, in the ASC specification, the vehicle year is pushed as an integer, so the way that would be queried is like this:
(SELECT value.int_value FROM UNNEST(event_params) WHERE key = 'item_year') AS vehicle_year,
int_value versus string_value. There's also other data types as well.