GA4 BigQuery export schema

Scott Hellmund•10 March 2022•1 min read
GA4 BigQuery export schema

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.

Suggested content

Measurelab awarded Google Cloud Marketing Analytics Specialisation

At the start of the year, if you’d asked us whether Measurelab would be standing shoulder to shoulder with Europe’s biggest consultancies by September, we would've been surprised. Not because we don't believe in ourselves, but because these things feel so distant - until suddenly, they’re not. So, here it is: we’ve been awarded the Marketing Analytics Services Partner Specialisation in Google Cloud Partner Advantage. What’s the big deal? In Google’s own words (with the obligatory Zs): “Spec

Will Hayes•11 Sept 2025

BigQuery AI.GENERATE tutorial: turn SQL queries into AI-powered insights

BigQuery just got a major upgrade, you can now plug directly into Vertex AI using the new AI.GENERATE function. Translation: your analytics data and generative AI are now best friends, and they’re hanging out right inside SQL. That opens up a whole world of new analysis options for GA4 data, but it also raises some questions: * How do you actually set it up? * What’s it good for (and when should you avoid it)? * Why would you batch the query? Let’s walk through it step by step. Step 1: H

Katie Kaczmarek•3 Sept 2025

How to start forecasting in BigQuery with zero training

If you’d told me five years ago that I’d be forecasting product demand using a model trained on 100 billion time points… without writing a single line of ML code… I probably would’ve asked how many coffees you’d had that day ☕️ But its a brand new world. And it’s possible. Let me explain What is TimesFM? TimesFM is a new foundation model from Google, built specifically for time-series forecasting. Think of it like GPT for time, instead of predicting the next word in a sentence, it predicts t

Katie Kaczmarek•14 Jul 2025