Blog

GA4 BigQuery export schema

Scott Hellmund10 March 20221 min read

I've always found the GA360 interactive schema from E-Nor (now Merkle - Cardinal Path) by Justin Marciszewski to be a handy way to find out where different elements can be found in the BigQuery schema.

GA4 has a new schema, different to that of the Universal Analytics schema you may have become familiar with using GA360. I hope this proves to be a useful visual reference for new and old GA4/BigQuery users alike!

You can explore the GA4 BigQuery export schema by clicking on the tree map below. Or you can open it full-screen in a new tab (and maybe bookmark the page for future reference).

If you're wondering if or why you should be exporting your GA4 data to BigQuery in the first place, Lace gives 10 very good reasons in her blog.

I've also written up a full guide on how to build this yourself using R should you want to have a go and to use your own GA4 event schema to generate the tree map.

Need to connect your data?

Join marketing, customer and product data with tested models and documentation your team can use. Start with the sources needed for your question.

Explore data engineering

Have a question or project in mind?

Bring data to connect, a question to investigate or something to fix or build. We can agree a focused scope directly.

Talk through your question

Suggested content

Blog

How to make an AI agent accurate in BigQuery

A year ago, I wrote about getting a BigQuery warehouse ready for AI ( Easy ways to prepare your BigQuery warehouse for AI) , but didn't look properly into Knowledge Catalog (known as Dataplex at the time). We decided to go back and look through Google's Knowledge Catalog properly: what's actually in there, how it works and what it relates to. What Knowledge Catalog is Knowledge Catalog is Google's metadata layer for BigQuery data (and a few other sources). It sits alongside your tables rather

Katie Kaczmarek15 Sept 2026

Blog

What's actually in Google's Knowledge Catalog

Google's Knowledge Catalog has been renamed four times. Data Catalog, then Dataplex Catalog, then BigQuery universal catalog, then Dataplex Universal Catalog, and now Knowledge Catalog, as of 10 April 2026. The API, gcloud and IAM roles still all say "dataplex". If you land on a page that mentions Dataplex and wonder whether you're reading something out of date, you're probably not. That's just the product's fifth name in four years. I spent some time looking through the different sections of K

Katie Kaczmarek15 Sept 2026

Blog

BigQuery Tips: When your query is technically correct but BigQuery won't run it

There is a particular kind of frustration that comes from staring at a query you know is correct and watching it fail. No syntax error. No logic problem. Just a wall. We hit two of them on the same project. What we were building The job was to migrate ga4_daily_snapshot for a large enterprise client from a BigQuery scheduled query into a proper Dataform pipeline. The scheduled query had been added to over time until it was too large to maintain with any confidence. Moving it to Dataform w

Katie Kaczmarek17 Aug 2026