MeasureFest 2022: why GA4 means you should get on board with BigQuery

Katie Kaczmarek•26 October 2022•2 min read
MeasureFest 2022: why GA4 means you should get on board with BigQuery

This is my first time speaking at any analyics conference, let alone MeasureFest, and I'm looking forward to sharing my passion for SQL and BigQuery. I've been a data analyst for over 10 years, I've used SQL with Oracle, Microsoft and now Google BigQuery, and I can honestly say that Google has been my favourite so far! They are constantly thinking of new ways to improve the user experience, and the speed of the code is amazing. Plus they have a suite of products which have been made to speak to one another with ease.

I love extracting data using SQL, the control you have is amazing. Lots of people can code SQL to extract data, but only the best ones will be checking their outputs and ensuring the data you are looking at is correct. All you need to get started is a little imagination for what you want to extract and how you are going to use that data, a question to ask your data is a good start. From there it's just a case of building up your code and testing along the way. This article I wrote will help with what you should think about when testing your SQL code.

Before you start using BigQuery with your GA4 data, you'll need to get the exports all set up. Here's a guide I wrote on how to do it step by step:

https://www.measurelab.co.uk/insights/set-up-ga4-bigquery-export/

Here's some resources related to the talk to help get started and utilising BigQuery now:

And here's some handy free resources for learning SQL (and beyond):

For other people to follow, podcasts to listen to, newsletters to subscribe to, websites to visit, and other things that we recommend, see our full recommended list that we pulled together.

Slides

Below are my slides from my MeasureFest talk. Here is the link to Google Slides in case that doesn't work.

Recording

Need help with your data platform?

We build intelligence platforms on BigQuery, Dataform and Google Cloud - from setup to ongoing optimisation.

See how we can help

How ready is your data?

Take our short assessment to find out where your data stack stands and what to prioritise next.

Take the assessment

Suggested content

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 Kaczmarek•17 Aug 2026

BigQuery Tips: The subquery in your WHERE clause that's scanning your entire table

There is a pattern that appears in a lot of BigQuery pipelines and looks completely reasonable. You have a control table that stores the latest processed date. Rather than hardcoding a date into your query, you pull it dynamically: SELECT * FROM `project.dataset.events` WHERE event_date = ( SELECT latest FROM `project.dataset.control_table` ); The query returns the right results. The logic is clean. And if your events table is large and date-partitioned, you might be scanning the entire

Katie Kaczmarek•13 Aug 2026

BigQuery Tips: Arrays in BigQuery - what they are and how to get data out of them

If you have ever opened a GA4 export in BigQuery for the first time and found yourself looking at a column called event_params that seemed to contain an entire table inside each row, this post is for you. Arrays are not trying to make your life harder. Once you understand why they exist and what to do with them, they stop being intimidating. Why BigQuery uses arrays GA4 tracks events. Each event can have many parameters. A purchase event might have a transaction ID, a value, a currency an

Katie Kaczmarek•10 Aug 2026