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 16 posts
July 2025

Recover deleted tables in BigQuery using time travel

June 2025

Using the STRING_AGG function: Analyzing Full User Paths Before Conversion

June 2024

Navigating consent mode in the GA4 BigQuery export

January 2024

How to create a fully automated BigQuery ecommerce data warehouse with Eyk: get pre-built marketing insights in minutes

December 2023

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

October 2023

Unofficial 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

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

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