How to Export Your Universal Analytics (GA3) Data the Fastest & Easiest Way [w/ Free Templates Included]
The Announcement Google has announced that all customers will lose access to Universal Analytics properties and API starting on July 1, 2024. Here is what Google says will happen: What you should know: So with that, I have spent the last couple of months reverse-engineering the Universal Analytics platform reports and found a way to […]
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. […]
GA4 & BigQuery: Benefits, Drawbacks, and Cost
In this post, we’ll provide a primer on BigQuery and GA4, why it’s beneficial, what are its drawbacks, and costs to use it. What is BigQuery in GA4? BigQuery is a type of data warehouse solution running in the cloud, specifically on the Google Cloud Platform. With the new Google Analytics 4, Google is now […]
5 Learnings From Creating a Sessions Fact Table From GA4 Data in BigQuery SQL
With the new Google Analytics and Google’s decision to allow a direct integration between GA4 and BigQuery, a new world of possibilities has opened up for us. The direct integration allows us to export GA4 raw data into a BigQuery dataset, and from there, we can use SQL to model the data into a usable […]
BigQuery SQL & GA4: How to Query Multiple Tables Using _TABLE_SUFFIX
Select From All Tables Select From Specific Dates Select Only Yesterday’s Data Note: sometimes yesterday’s data may not always be fully exported yet from GA4 and loaded into your raw table. So you can do a “2 day delay load” by selecting only the data from 2 days ago: Select Data From 2 Days Ago