Analytics

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 scientist in a lab coat holding a phone, standing next to a large glowing lightbulb connected by a cord to a foot pedal. The background features laboratory glassware filled with green liquid, symbolising innovation or experimentation.

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…

What is offline event data import in GA4?

Offline event data import in Google Analytics 4 allows you to upload event data that was acquired outside of your…

The complexity paradox: why your spreadsheet is complex and BigQuery is simple

Understanding complexity Everything is complex until you understand it. And yet, not all complexities are created equal. This is the…

You’re sitting on a SQL time bomb: defuse it with Dataform

As a marketing team's maturity evolves, disparate data sources centralise, increasingly sophisticated SQL queries begin to pull together insights and…
An AI generated image of modern marketing - Measurelab

The modernisation of marketing and the role of marketing analytics

Navigating the ever-evolving landscape of marketing technology, I've come to terms with a key realisation: marketing analytics is marketing. This acknowledgment hasn't…
Elevate your data and analytics game using BigQuery - Measurelab

Elevate your data analytics game with BigQuery

What is BigQuery? What is BigQuery? BigQuery is a powerful data warehousing tool within the Google Cloud Platform designed to…
Gerative AI image of a car on a data road trip, with many destinations.

The data road trip: enjoying the journey

In the dynamic world of analytics, it's easy for us to get caught up in the chase for the next…

Customer Data Platforms (CDPs)

Our take on CDPs We’ve been around long enough to have seen the bandwagon-jumping that inevitably happens with any new…