方言を話すおしゃべり猫型ロボット『ミーア』をリリースしました(こちらをクリック)

data analysis

Marketing

[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.