
Insights
Debugging
Troubleshooting and fixes (32 posts)
Browse the archive
Explore a topic across our insights
32 results · Page 1 of 2

#130 GenAI in action: Cloud DevOps and Tagassistant.ai (with Mark Edmondson)
In this episode of The Measure Pod, Dara and Matthew sit down with Mark Edmondson, AI Engineer, founder of Sunholo, Aitana, and board member at 8-bit-sheep.

#128 MCP servers in digital analytics (with Gunnar Griese at 8-bit-sheep)
In this episode of The Measure Pod, Dara and Matthew sit down with Gunnar Griese from 8-bit-sheep to discuss MCPs and their growing role in digital analytics.

GA4 Dataform integration: how Springer Nature modernised analytics with Measurelab
The Springer Nature Group is an academic publishing company, with brands dating back to 1842, that advances scientific discovery by publishing robust and insightful research, supporting the development of new areas of knowledge, making ideas and information accessible around the world, and leading the way on open access. The challenge Springer Nature needed to migrate their Universal Analytics dashboards to GA4 data. Their reporting relied on multiple stacked scheduled queries in BigQuery tha

#123 Why teams are turning to warehouse-native analytics (with István Mészáros at Mitzu)
In this episode of The Measure Pod, Dara and Matt are joined by István Mészáros, founder and CEO of Mitzu - a company who have built a warehouse-native product analytics solution.

#121 Using Dataform and DBT in modern analytics (with Verónica Delgado-Benito at Springer Nature)
In this episode of The Measure Pod, Dara and Matt are joined by Verónica Delgado-Benito to chat through her journey from molecular biology PhD to data analyst at Springer Nature.

Data pipeline optimisation with Google Cloud and Dataform
In our recent engagement with a client, we went on a journey to transform their data pipelines, tackling inefficiencies in performance and cost within their Google Cloud BigQuery environment. Our efforts culminated in a comprehensive optimisation strategy that used Dataform, improved SQL practices, and implemented tailored solutions for significant performance gains and cost savings. Here’s a deep dive into the highlights of our project. Identifying inefficiencies in BigQuery workflows We beg

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
You’re sitting on a SQL time bomb: defuse it with Dataform
Learn how Dataform can solve the challenges of outdated SQL, improving data reliability, scalability, and efficiency for marketing teams.

#108 The death of accuracy: an obituary
In this week's episode of The Measure Pod, Dan and Bhav reflect on insights gained from MeasureCamp London, and dive into the thought-provoking topic of "the death of accuracy."

Elevate your data analytics game with BigQuery
There’s a lot of advice right now on why you should adopt and use Google BigQuery for data analytics. But what is SQL? Is it for you? And how can you convince budget holders that it is a good idea?

2023: Measurelab's year in review
2023 was a momentous year for Measurelab. It marked a decade of delivering analytics excellence to the world, a year when we were named one of the UK’s best places to work and became a fully-certified GCP partner, a summer that saw the sunsetting of Universal Analytics, followed by the new dawn of generative AI and the beginning of an augmented analytics era. Into the sunset From the very beginning of January, right up to the deprecation deadline of July 1st, we were swamped with GA4 migratio

How to set up an SFTP Server on Google Cloud (for Google Analytics data import)
How to set up an SFTP server on Google Cloud platform – with the necessary steps for public key authentication required by the Google Analytics Data Import.
How to debug your SQL in BigQuery
Discover how to efficiently troubleshoot and find missing data in your code. Dive deep into the step-by-step process of querying code segments in BigQuery, leveraging CTEs, and ensuring you understand the flow of your data. Master the art of debugging with hands-on examples.

Getting started with Plotly Dash
This blog post is a brief introduction to Plotly Dash and a short tutorial to learn how to build a custom visualisation. For this tutorial, you will need some basic knowledge of Python, HTML and JavaScript. This article will focus on locally building and visualising your graph. What is Plotly Dash? Let’s start with the basics: what is Plotly Dash? Dash is a Python framework created by Plotly to render interactive dashboards which can also be hosted online, by using just Python. Dash has both

Why you should consider Server-Side GTM
It can be daunting and frustrating to add another piece of technology and complexity to your analytics stack. Still, we explain why server-side GTM may be worth the migration.

How to use the real-time report in GA4
The real-time report in GA4 is not without its merits. Here's what it is, how it works and how to use it and all of it's features.

How to modify events in GA4
How to use the event modification feature in Google Analytics 4 (GA4) to change details about the event without touching the implementation. No coding, no Google Tag Manager, no developers, all done from within the GA4 user interface!

What to consider when considering Consent Mode
Google's Consent Mode is quickly becomming an essential part of any GTM setup. Here are some questions you need to answer before you decide to ‘turn it on’.

