When you connect Google Analytics with Google BigQuery, you unlock access to raw event-level data that can be analyzed far…
If you’ve ever connected GA4 to BigQuery, you’ve probably had this realization at some point: “Wait… where is my historical…
Marketers and product teams often want the best of both worlds: the rich event-level data available in Google Analytics 4…
If you are transitioning from GA4 to Amplitude, then you might want to bring all your historical GA4 data into…
When you export GA4 data to BigQuery, you will find several source, medium, and other data fields related to traffic. …
In the past several posts, I have shown you how to recreate various GA4 standard metrics in BigQuery. In this…
Using RegEx in SQL opens up a lot of possibilities for you to find the right content using a query…
If you want to derive the full value of GA4 then you will have to send GA4 data to BigQuery…
GA4 data allows you to send the raw event data to BigQuery, a cloud data warehouse. Having the data allows…
Gemini is a Google AI model that you can now use in BigQuery to assist you in writing SQL queries…
BigQuery offers a powerful Table Explorer feature that allows users to visually navigate data tables and create SQL queries without…
Recently a lot of Universal Analytics clients were scrambling to backup there old data. Some of them learned that they…
events_intraday and events tables are two sets of tables that get created in BigQuery by GA4 when you enable…
GA4 has a direct integration with BigQuery, which means you can send all your GA4 data to BigQuery with just…
In this post, we will go over the BigQuery organization of GA4 data in BigQuery. To open BigQuery, go to https://console.cloud.google.com/bigquery…
In this post, I will share how you can recreate the “Session” metrics in BigQuery. There are three ways to…
Why are the numbers reported in the GA4 interface and those calculated in BigQuery different? This is a question asked…
Why are the numbers reported in the GA4 interface and those calculated in BigQuery different? If you have this or…
When you export GA4 data to BigQuery, you will see one or two user tables, depending on your GA4 implementation.…
Here are all the links to Black Friday offers on our online courses: Digital Analytics Implementation Mastery (Nov…