As you might have already experienced, GA4 reporting continues to get worse. To get any meaningful reporting and insights from data collected by GA4, you have to use BigQuery.

In this newsletter series, so far I have covered BigQuery and SQL fundamentals. Now, I will be diving into SQL queries that you can use to duplicate GA4 reports as well as get insights that are not possible in the GA4 interface.

If you haven’t yet started learning BigQuery and SQL then here are quick lessons for you to get started.

1. What is BigQuery?

2. 9 Reasons Why You Should Turn On GA4 BigQuery Integration

3. How to Connect GA4 with BigQuery

4. GA4 Data Organization in BigQuery

5. GA4 Events Table Schema in BigQuery

If you are not interested in BigQuery, you can unsubscribe from this newsletter and subscribe to the Digital Analytics Insights weekly newsletter.

Thank you,

Anil Batra
Founder Optizent Academy