GA4 & BigQuery: A SQL Model for a Base Events Table (How to Unnest Fields)
Introduction to GA4 Public Dataset in BigQuery In this post, we’ll be using the GA4 public dataset in BigQuery. You will need a Google Cloud Platform account to access this. Using the sample dataset, you’ll see date sharded tables that look like this: Each day’s worth of data exists in its own date sharded table. […]