GA4 | reports

It can be hard to make sense of the data in the Google Analytics 4 BigQuery export tables. These example queries for GA4 enable you to replicate the reports you're familiar with.

How to replicate the 'Life cycle | Acquisition | Traffic acquisition' report (GA4)

A query to generate the Google Analytics 4 traffic acquisition report in BigQuery. In this report you'll find data about acquisition at session level: users, (engaged) sessions, engagement time and rate, segmented by default channel grouping, medium, source and campaign.

How to replicate the 'Life cycle | Acquisition | User acquisition' report (GA4)

A query to generate the Google Analytics 4 user acquisition report in BigQuery. In this report you'll find data about your new users, engaged sessions, engagement time and rate, segmented by medium, source and campaign.