GA4 and BigQuery: how to match the Console traffic grouping metrics

Lace Chantelle Rogers
3 min readSep 4, 2023

Google Analytics 4 offers excellent functionality with its GA4 BigQuery dataset. However, you might find it challenging to align your GA4 UI figures with the unnested sources, mediums, and campaigns in BigQuery.

The GA4 demo account

So what happens in BigQuery compared to GA4?



Lace Chantelle Rogers leading data and analytics . GCP, BigQuery and GA4 expert specialising in data engineering, data science and Brighton cloud events.