Katie

A visual depiction of cloud computing, illustrating clouds connected by lines, symbolising data transfer and technology.

How to extract GA4's event sequencing in BigQuery using the new batch fields

Google Analytics 4 (GA4) exports event data to BigQuery, enabling detailed user behavior analysis. However, GA4 batches events before sending…
Illustration of a crystal ball connected to various data and automation symbols, including gears, a pie chart, a computer, and a magic wand, representing analytics and automation.

Automating BigQuery workflows with conditional logic and data readiness checks

BigQuery offers powerful scripting capabilities that can simplify complex workflows. In this post, we’ll explore two essential techniques: using IF...THEN...END…

A step-by-step guide to migrating scheduled queries to Dataform

Managing scheduled queries in BigQuery often feels limiting — there’s no version control, no easy collaboration, and scaling can be…

How to set up a Dataform repository with GitHub & Google Cloud integration

Setting up a Dataform repository can be challenging without the right steps. Whether you’re new to Dataform or want to…

How to debug your SQL in BigQuery

How often have you run your code in BigQuery only to find a bit of data missing that you KNOW…

MeasureFest October 2022: Why GA4 means you need to 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…
Changing a GA4 Data Stream name

How to review SQL code in BigQuery for duplication and errors

Sometimes we can spend hours, days or even weeks writing SQL in BigQuery. Hopefully what you have ended up with…
Changing a GA4 Data Stream name

How to set up the GA4 BigQuery export

The act of enabling the export from Google Analytics 4 (GA4) to BigQuery is actually a relatively simple process. However…
Reducing BigQuery processing costs

How to reduce the cost of BigQuery data processing

Every Google BigQuery code you run costs money – the amount you pay can vary hugely based on different factors.…