Skip to main content

Insights

Google Analytics, Google Tag Manager, Server-side Tagging and Privacy

301 posts on Google Analytics, Google Tag Manager, Server-side Tagging and Privacy

Browse the archive

301 results · Page 2 of 17

Easy ways to prepare your BigQuery warehouse for AI

You’ve probably heard that AI is coming to make our lives easier, especially in tools like BigQuery. But here’s the thing: AI isn't magic. If you want it to be accurate and useful, you need to set it up for success. One of the best ways to do that? Improve the metadata in your BigQuery warehouse. Metadata is like the index or contents page in a book, it quickly tells you exactly what’s inside and where to find it. Creating clear metadata means AI can more easily understand your data warehouse

Katie Kaczmarek-

Behind the Cloud – Releases and scheduling in Dataform

In this episode of Behind the Cloud, Matthew dives into the details of releases and scheduling in Dataform. He breaks down how to manage different versions of your codebase in GitHub. From taking snapshots, to scheduling executions at various intervals daily, hourly, or monthly. By the end of the episode, you’ll have the know-how to confidently release and schedule your code, making it easier to build robust tables and models with Dataform. Video transcript Introduction to releases and sche

Matthew Hooson-

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-