ga4-bigquery-schema

To query event_params in the GA4 BigQuery export schema, you must unnest the repeated record using UNNEST(event_params) in your SQL. This flattens the nested key-value structure so analysts can extract specific parameters like page_location or ga_session_id efficiently.

User_properties in GA4 BigQuery exports are stored as nested, repeated records within the events table. Querying them requires unnesting the user_properties array to access the value fields, enabling analysts to segment users based on custom attributes.

Calculating ecommerce revenue from GA4 BigQuery data involves querying the ecommerce events, unnesting event_params for items, and summing the purchase_revenue field. The schema reference provides common query examples to accurately aggregate this revenue data.

Best practices for performant GA4 BigQuery queries include filtering by event_date or event_timestamp early to reduce data scanned, and carefully structuring UNNEST operations. The schema reference highlights these performance best practices for efficient data modeling.

Yes, you need foundational BigQuery SQL knowledge, particularly understanding nested and repeated records, to use the GA4 export schema reference effectively. It is designed for data analysts and engineers who model data and build queries across projects.