Locate Conversions Data in GA4 BigQuery Export

FAQ: How do I find key events (aka conversions) data in GA4 BigQuery Export?

In the GA4 BigQuery export schema, there is no corresponding field indicating whether an event has been designated a key event. 😟 

The concept of a “key event” is more of an analytical distinction made within the GA4 user interface, where certain events can be marked as key events for analysis and reporting.

However, this designation does not translate into a distinct field in the BigQuery export.

The formula provided for the “Is key event” dimension in the table below assumes that you have a custom event parameter named ‘is_key_event’ set up in your GA4 configuration.

To handle this situation in BigQuery, you must manually specify which events are considered key events based on your analysis needs.

You could do this by creating a list of event names that you have designated as key events within your GA4 configuration and then using this list in your SQL queries to filter or flag these events accordingly.

For example,

If you consider ‘purchase’ and ‘add_to_cart’ as key events, you could write an SQL query like the one below to identify them in your BigQuery data.