Welcome to GA4BigQuery!

Our goal is to provide valuable content to data analysts, online marketers and engineers, who seek guidance on how to use and analyze the GA4 BigQuery export data set (and data from other online & digital platforms). This includes a knowledge base to jump-start beginners on their journey to leverage BigQuery, but also articles and further material to help seasoned experts to stay up-to-date and help them venture into more sophisticated or niche areas. And, of course, everything in between.

A few ways to get started:

• Read the FAQ
• Discover example queries for GA4 dimensions & metrics
• Enjoy all kinds of tips & tricks
• Subscribe as a free member to receive our thoughtfully curated newsletter (just like 6,600+ other professionals), delivered on a flexible schedule.
• Subscribe or upgrade to the premium membership to gain immediate access to the full archive of tutorials and out-of-the-box reports.
• Not sure what to expect? Subscribe as free member and get access to this premium tutorial).

Our team consists of two main contributors:

• Balazs Vajna: Head of Analytics in a digital marketing and analytics services agency. MarketingLens provides expert digital advertising services led by ex-Googlers, and data analytics services to enhance digital advertising, usually with BigQuery at the core.
• Johan van de Werken: freelance data analyst & analytics engineer with a decade of hands-on experience in marketing, web & data analytics; thriving best at the sweet spot between data, business & tech. Johan is the original founder of this platform and will stay involved to ensure the high quality set out originally and maintained ever since.

To understand the recent transition and the nature of our collaboration, you can read our announcement here.

If you are very new to this topic and want to get a jump-start, definitely check out Johan’s other resources:

• this popular video course co-created with Simo Ahava, focusing on learning SQL in the context of Google BigQuery and Google Analytics 4
• GA4Dataform.com, co-created with four other recognized analytics engineers: a solution that offers a faster and more efficient way to utilize your GA4 data in BigQuery. Tap within minutes into pre-built SQL models designed by industry experts, enabling you to start at a level of sophistication that usually takes years to achieve. Also recommended for seasoned experts, as it provides a solid, open-sourced foundation that frees up time to build the parts that actually matter and delivers value to your company or clients.

Don't feel like using GA4Dataform or learning SQL yourself? Here are a few other ways you could try to start analyzing GA4 data in BigQuery:

• Generate out-of-the-box queries at GA4SQL.com.
• Try the GA4BQ browser extension.
• Pick from previously written SQL code from this repository for specific analysis tasks (other, paid code libraries exist as well)
• Use a Large Language Model that is pre-trained on dealing with the GA4 raw export schema, for example here: https://gpt4o.so/tools/ga4-sql-ZxWyYju1

If you know of any other great ways or resources to get up to speed, or would like to see certain topics covered on this platform, let us know!