Skip to main content

GA4 | tips & tricks

Articles aiming at showing beginners and intermediates the power of SQL functions and BigQuery specific tips & tricks in the context of the GA4 export data.

— A collection of 15 posts
December 2023

How to create and maintain a Dataform powered GA4 export SQL workflow in BigQuery

October 2023

How to set up the Google Ads data transfer to BigQuery

October 2023

GA4 BigQuery export schema change log (or how to generate your own)

August 2023

How to set up Google 'Connected' Sheets to access GA4 BigQuery export data without learning SQL

August 2023

How (and why) to activate the GA4 user activity data export to BigQuery

February 2023

How to sync your marketing data with BigQuery using Fivetran's free plan

January 2023

How to query streaming GA4 export data and combine it with historical data in BigQuery

January 2023

How to explore GA4 event data with the sample ecommerce data set in BigQuery

January 2023

How to filter events in your GA4 BigQuery export to avoid exceeding daily 1 million event limit

December 2022

How to create a pivot table with GA4 data in BigQuery

July 2022

Let's build together: towards an open-source community-driven dbt package for the GA4 BigQuery export

February 2021

Why your BigQuery results don't (exactly) match with Google Analytics reports (GA4)

January 2021

How to query multiple GA4 'events_' tables with '_table_suffix' in BigQuery

November 2020

Introduction to Google Analytics 4 (GA4) export data in BigQuery

October 2020

How to set up BigQuery linking in your Google Analytics 4 property