In this post, I am going to show you how you can recreate standard GA4 metrics in BigQuery. Views: In addition to the Views metrics, GA4 also has “Views per session” and “Views per user” metrics. More details at https://bigquery.optizent.com/p/page-view-related-metrics-ga4-bigquery Sessions There are three ways to get the “Session” metrics in GA4 and each one tells…
Why are the numbers reported in the GA4 interface and those calculated in BigQuery different? This is a question I recently received from one of the subscribers of this newsletter, and it comes up often. Note: You can submit your GA4 + BigQuery questions on the “Ask a GA4 BigQuery Question” page. Google Analytics 4…
When you enable GA4 BigQuery data integration, you only get the data in BigQuery from the data for which the integration was enabled. GA4 does not automatically backfill historical data into BigQuery. So if you connected BigQuery today, your data starts today and not from when your GA4 started collecting the data. But that does…
In this post, we’ll walk through how GA4 data is organized inside BigQuery, so you know exactly where everything lives and how to navigate it. To get started, open BigQuery here:https://console.cloud.google.com/bigquery This takes you to the BigQuery interface (often called the BigQuery console). Understanding the BigQuery Structure At the top of the console, you’ll see…
If you haven’t yet started with BigQuery, this is a great time to get started so you can follow along as the new GA4 BigQuery content is released. Below are the five short lessons that will get you started with BigQuery and SQL with GA4 data in just a few minutes. Each of the following…
From GA4 events to analytics-ready BigQuery tables GA4BigQuery helps teams turn raw GA4 event data into clean, flattened, and analysis-ready BigQuery tables — with backfills, fixes, and future-proof modeling built in. Stop wrestling with nested events. Start answering questions. If you use GA4 + BigQuery, you already know the problem: GA4BigQuery exists to fix that….