![](https://kazulog.fun/wp-content/uploads/2024/04/bigquery-expansion-and-analysis-of-ga4-752x423.jpg)
[BigQuery] Expansion and analysis of GA4 event_params with UNNEST: Bad and right queries
When setting up an Export of GA4 to BigQuery and analysing GA4 data on BigQuery, a common stumbling block is how to parse GA4 event_params, as the data is nested in event_params in a further key-value format array,When tabulating the data, the UNNEST operator in SQL is used to expand the elements in the data and convert them into a single row before tabulating.