Skip to main content

Insights

Google Analytics

Google Analytics platform, including GA4, Universal Analytics, and GA360 (274 posts)

Browse the archive

274 results · Page 2 of 16

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 them, making GA4 event sequencing in BigQuery more complex. Fortunately, three fields—batch_event_index, batch_ordering_id, and batch_page_id—help provide precise sequencing information. For a full schema of the GA4 export, head over to google documentation. This article breaks down these fields in a clear, practical way and shows how to use them togethe

Katie Kaczmarek-

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 IF for procedural control and leveraging the metadata in project.dataset.__TABLES__ to ensure your Google Analytics 4 (GA4) data is ready before running queries. These strategies help you avoid unnecessary processing, reduce costs, and improve efficiency in your data pipelines. 1. Leveraging IF...THEN...END IF for procedural logic Whi

Katie Kaczmarek-

2024: Measurelab's year in review

Same same but different At the beginning of the year, I wasn't quite sure what Measurelab would look like by the end of 2024. Altman's assistants had just been unleashed. The robots were on the march. Would the analytics arena be conquered by AI? Would we all be replaced by intelligent agents? As it turns out, no. Things are pretty much the same - on the surface at least. And that's no bad thing. After the tumultuous ups and downs of a rollercoaster 2023, I'll take steady, deliberate progress

Steven Elliott-

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 website or app, such as in-store purchases, contact centre interactions, or CRM data. This can be critical for businesses seeking to bridge the gap between online and offline user actions, resulting in a more complete picture of customer behaviour. How to import offline event data into GA4 You can upload event data into GA4 through a process called Data Import. This can be done ma

Nasima Khatun-

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 always been easy. Years ago, as a humble web analyst, the lines weren't as blurred. However, with the advent of tools like Google Analytics 4 (GA4), stringent privacy laws such as GDPR, and changing browser policies like those of Safari, the role of a web analyst has transformed significantly. In the old world - us web anal

Daniel Perry-Reed-