
Analytics insights
Expert perspectives from our team of data and cloud specialists. Read our latest articles, watch videos, listen to our podcast, and dive into some customer case studies.
Filter by topic
What is a semantic layer and why your AI agents need one
Companion piece to Measure Pod #139 with Colin Zima and #98 with David Jayatillake Your warehouse is full of tables. Your agents can query them. The question is whether they'll get the same answer. Ask three different agents "what's our monthly revenue?" and you'll get three different numbers. Not because the data is wrong - because nobody defined what "revenue" means in a way machines can consistently resolve. Is it gross or net? Recognised or invoiced? Including refunds or not? Each agent ma

#139 The role of AI and semantic layers in BI (with Colin Zima at Omni)
Colin Zima, CEO of Omni & Looker veteran, joins the Measure Pod to discuss revolutionising analytics by integrating AI into modern data tools.

#138 Is Claude the future of agentic AI
Pentagon drama, Google updates and a deep dive into why Claude keeps winning. Agentic AI is here and it's for everyone.

The derelict data warehouse, revisited: why this problem just became existential
AI doesn't fix bad data; it scales it. In 2026, a derelict data warehouse isn't just a nuisance, it’s an existential risk.

Your analytics stack is dying. Here's what's going to replace it
The monolithic martech stack is collapsing. An open source, warehouse-first intelligence platform is cheaper, more honest, and actually yours.
What 70% more data actually means for your ad performance
Server-side GTM is usually sold on technical grounds. Better data quality. Reduced client-side load. Privacy compliance. All true, all important, and all completely abstract to the person signing off the budget. Here's what they actually want to know: what does it do for my numbers? We can answer that. When we deployed server-side GTM for Unily, they recovered 70% of previously lost session data. That's not a rounding error. That's a step change in what you can see, what you can attribute, and
#137 Which LLMs stand the test of time?
Dara & Matthew explore AI competition, developer tools, enterprise SaaS governance, and Google's AI strategy and TPU infrastructure edge.
We've stopped patching. And started building.
Measurelab has a new website. It reflects a shift toward building intelligence platforms, not just solving technical problems. Here's what's changed.
Clearing 2026: why UK universities need recruitment intelligence
UK universities face a deficit crisis. Student Recruitment Intelligence can transform Clearing from chaos to precision.
#136 Agents, swarms, and the AI awakening
In this episode of The Measure Pod, Dara and Matthew ease into the new year, shake off the podcasting rust, and dive into big-picture ideas about AI’s potential to guide humanity toward a more optimistic, almost Star Trek like future.
Webinar: We tried talking to our data - here’s what’s actually working (and what’s not)
In this 30-minute session, we unpacked what we had been experimenting with using Google’s conversational AI to spend less time wrangling data and more time actually learning from it.
The AI revolution already happened
AI's revolution is already here. We're too busy debating its future to harness the transformational power of today's models.
#135 Twelve highlights of 2025 and future predictions
Dara and Matthew recap 2025 with 12 top highlights, AI, analytics, and the best moments on The Measure Pod.
Unifying student data to drive smarter recruitment for The University of Exeter
How we helped the University of Exeter connect student data end-to-end to measure marketing ROI and optimise recruitment.
Ask your data a question: the promise (and reality) of natural language to SQL
NL-SQL tools can transform how you query data - but only if your foundations are solid. Here's an honest look at what works and what doesn't.
#134 Building AI agents, from consciousness to collaboration (with Daniel Hulme at WPP)
AI expert Daniel Hulme, founder of Satalia, shares his journey from UCL PhD to entrepreneur, discussing AI, consciousness & deep tech.
Integrating web analytics with CRM for Charles Stanley
How Charles Stanley unified customer data with a Google Cloud solution, improving journey visibility, data reliability, and personalised marketing.
#133 The role of AI in analytics (with Juliana Jackson at Jellyfish)
Dara and Matthew chat with Juliana Jackson on her journey, product mindset, and how AI is shaping modern analytics.
#132 The impact of AI on digital experience (with Yali Sassoon at Snowplow)
Yali Sassoon joins The Measure Pod to discuss Snowplow’s growth, AI innovation, data challenges, and the future of user experience.
#131 From raw export to insight-ready data (with Johan van de Werken at GA4Dataform)
Johan van de Werken joins The Measure Pod to discuss GA4Dataform, BigQuery, and the future of analytics engineering and automation.
#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.
#129 The impact of AI on digital analytics and user privacy (with Brian Clifton)
In this episode of The Measure Pod, Dara and Matthew sit down with Brian Clifton, the former Head of Web Analytics at Google (EMEA), author, and founder of Verified-Data.com and Advisor to Piwik PRO.
Webinar: Meet Dataform, the smart solution to fragile SQL setups
In this 30-minute webinar, learn how to bring structure and sanity to your SQL workflows, without adding complexity. We cover practical
Measurelab awarded Google Cloud Marketing Analytics Specialisation
At the start of the year, if you’d asked us whether Measurelab would be standing shoulder to shoulder with Europe’s biggest consultancies by September, we would've been surprised. Not because we don't believe in ourselves, but because these things feel so distant - until suddenly, they’re not. So, here it is: we’ve been awarded the Marketing Analytics Services Partner Specialisation in Google Cloud Partner Advantage. What’s the big deal? In Google’s own words (with the obligatory Zs): “Spec
#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.
BigQuery AI.GENERATE tutorial: turn SQL queries into AI-powered insights
BigQuery just got a major upgrade, you can now plug directly into Vertex AI using the new AI.GENERATE function. Translation: your analytics data and generative AI are now best friends, and they’re hanging out right inside SQL. That opens up a whole world of new analysis options for GA4 data, but it also raises some questions: * How do you actually set it up? * What’s it good for (and when should you avoid it)? * Why would you batch the query? Let’s walk through it step by step. Step 1: H
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
The Data Intervention - why first-party data matters
In this episode of The Data Intervention, Mac delves into the significance of first-party data in modern marketing.
#127 Ensuring robust data collection - lessons from Trackingplan (with Josele Perez)
In this episode of The Measure Pod, Dara and Matt welcome Josele Perez, co-founder of Trackingplan, to dive into the evolving challenges and opportunities in data collection.
#126 First-party data strategy - a client side perspective (with Roman Petrochenkov at Carwow)
In this episode of The Measure Pod, Dara and Matt sit down with Roman Petrochenkov, a seasoned marketing analytics leader with deep expertise in data strategy and measurement.
#125 Proactive pipelines - the power of shifting left (with Chad Sanderson at Gable)
In this episode of The Measure Pod, Dara and Matt are joined by Chad Sanderson from Gable.ai, a seasoned expert in the data space with a diverse background ranging from journalism to data science.
How to start forecasting in BigQuery with zero training
If you’d told me five years ago that I’d be forecasting product demand using a model trained on 100 billion time points… without writing a single line of ML code… I probably would’ve asked how many coffees you’d had that day ☕️ But its a brand new world. And it’s possible. Let me explain What is TimesFM? TimesFM is a new foundation model from Google, built specifically for time-series forecasting. Think of it like GPT for time, instead of predicting the next word in a sentence, it predicts t
#124 Transforming tag management with server-side GTM (with Denis Golubovskyi at Stape)
In this episode of The Measure Pod, Dara and Matt are joined by Denis Golubovsky from Stape.io, the team making server-side Google Tag Manager implementation as simple as the click of a button.
Webinar: Stop the martech madness! Go composable. Deliver value faster.
In this 30-minute webinar, we use three real-world examples to demonstrate how a composable approach can help you do more with the data and tech you already have - delivering value at speed. We cover three practical examples of how your marketing data warehouse can support better insights and experiences - without the need for more martech. Learn how you can: * Score wins quickly and regularly * Streamline your martech stack * Stop planning and start building Have questions? Reach out to
#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.
Measurelab makes the IPA Beacon List 2025
Given in recognition of how we are “Shaping growth, innovation and competition in the modern agency world” - along with 24 other companies in the UK; shaking it up, doing it that little bit better every time. We are honoured to be part of this initiative at the IPA (Institute of Practitioners in Advertising) to recognise the efforts of smaller UK independents - who are redefining what it means to be an agency in today’s fast-evolving media and technology environment.
#122 Digital transformation in the age of AI (with Antony Mayfield at Brilliant Noise)
In this episode of The Measure Pod, Dara and Mattew are joined by Antony Mayfield to talk about what 15+ years of digital transformation work actually looks like and how it’s changed.
#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.
The Data Intervention - Climbing the analytics maturity curve
In this episode of The Data Intervention, Mac talks analytics maturity - what it is, why it matters, and how to move from “just getting by” to actually getting value from your data.
#120 Marketing analytics updates and a BigQuery health check
In this episode of The Measure Pod, Dara and Matt dive into a whole mix of marketing analytics news and musings. From new BigQuery features and GA4 updates to ChatGPT integrations and data quality best practices.
Behind the Cloud – Data Preparations in BigQuery
In this episode of Behind the Cloud, Matt explores BigQuery’s new Data Preparation feature, an AI-powered, point-and-click tool for transforming data with ease. From natural language transformations using Gemini to automated workflows and scheduled outputs, learn how Google is simplifying data prep for analytics and machine learning. Video transcript [00:00:00] Hello and welcome to another episode of Behind the Cloud. Today we are gonna look at a feature or a service, or whatever you wanna ca
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
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
#119 Google Cloud Next 25 roundup
In this episode of The Measure Pod, Dara and Matthew take the reins and dive into the biggest takeaways from Google Cloud Next 2025.
The Data Intervention - Why most marketers are drowning in bad data
In this episode of The Data Intervention, Mac gets into why so many teams end up drowning in unreliable data, and what can be done to fix it before it becomes an expensive mess.
Dataform for BigQuery: A basic end-to-end guide
Dataform is a powerful tool for managing your data workflows in a structured, version-controlled, and automated way. Whether you're a beginner or an experienced data engineer, Dataform simplifies SQL-based transformations while integrating seamlessly with Google BigQuery. Although this blog offers a basic introduction to Dataform's functionality, users can achieve significantly more with Dataform. From advanced scheduling, parameterised queries, and dependency management to complex data modelli
#118 Dan & Bhav’s farewell, best moments & a game of guess who
In this special episode of The Measure Pod, Dan and Bhav bid farewell as they step back from the show, making way for Dara to take the helm as a familiar voice returning to the podcast.
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
#117 Marketing incrementality, attribution & ROI optimisation (with Jorge Roberto Ahumada Garcia @ Coppel)
In this week's episode of The Measure Pod, Dan and Bhav are joined by Jorge Ahumada Garcia from Coppel, one of Mexico’s largest retailers and banks.
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
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
#116 Highlights from Superweek 2025!
In this week's episode of The Measure Pod, Dan catches up with attendees at Superweek 2025 in Hungary, a conference dedicated to data analytics.
Mastering data loading in BigQuery using Dataform
Efficient data loading is crucial for managing and updating tables in Dataform. Various strategies exist to handle different use cases, including truncate and load, appending data, and leveraging incremental tables with unique keys. This blog explores these primary methods and more: Truncate and Load In this method, all existing records in the target table are deleted and replaced with a fresh table. This approach works well when a full table refresh is necessary or if managing slowly changin
#115 Lessons from a data science content creator (with Egor Howell @ Deliveroo)
In this week's episode of The Measure Pod, Dan and Bhav are joined by Egor Howell, a rising voice in data science and content creation.
#114 Sanity over vanity - focusing on metrics that matter (with Ole Bossdorf @ Project A)
In this episode of The Measure Pod, Dan and Bhav are joined by Ole Bossdorf, an analytics expert at venture capital firm Project A, which boasts a portfolio of over 120 companies.
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
#113 MMM, MTA and the future of marketing measurement (with János Moldvay @ Funnel)
In this week's episode of The Measure Pod, Dan and Bhav are joined by János Moldvay from Funnel to dive into the intricacies of Marketing Mix Modeling (MMM), Multi-Touch Attribution (MTA), and the future of marketing measurement.
#112 Product analytics tool assessment
In this week's episode of The Measure Pod, Dan and Bhav dive into the intricate world of product analytics.
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 difficult. If you’ve ever wondered how to make SQL workflows smoother, Dataform is your answer. In this post, I’ll show you how I migrated a BigQuery scheduled query to Dataform and how it transformed the way I manage my data pipelines. After all, we all want to know who’s been touching our queries, don’t we? Getting started in Dataform First thing you need to
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 optimise your workflow, this guide will show you how to seamlessly connect it with GitHub and Google Cloud (GC). What is Dataform and why use it? Dataform is a powerful tool for managing version-controlled SQL workflows in a collaborative way. GC incorporates BigQuery and GitHub integration, providing an efficient way to organise and maintain complex data pipelines. Let’s bre
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
#111 ROI of analytics and GA’s gravy train (with Adam Greco @ Amplitude)
In this episode of The Measure Pod, Dan and Bhav welcome back Adam Greco from Amplitude.
Behind the Cloud – IAM roles in Google Cloud
In this episode of Behind the Cloud, Matthew dives into Identity and Access Management (IAM) on Google Cloud. He discusses the common frustrations users face, and the significance of assigning specific, granular permissions to mitigate potential risks. Video transcript Introduction to IAM roles [00:00:00] Matt: Hello and welcome to another episode of Behind the Cloud. I’m afraid today isn’t going to be the most glamorous of episodes because what we’re here to talk about today is IAMs on GCP
The complexity paradox: why your spreadsheet is complex and BigQuery is simple
Discover 'The Complexity Paradox': why seemingly simple tools like spreadsheets can lead to hidden complexity, while learning powerful tools like BigQuery and SQL can bring true simplicity and scalability to your data workflows.
#110 Live from MeasureCamp London 2024: analytics in 2034
This week's episode of The Measure Pod was recorded live at MeasureCamp London, where Dan and Bhav discussed the future of analytics, specifically what it could look like in the next decade.
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.
#109 The analytics of PlayStation (with Gabor Mester @ Sony)
In this week's episode of The Measure Pod, Dan and Bhav had the pleasure of speaking with Gabor Mester, a seasoned analytics professional who has spent over 13 years at Sony, specifically with PlayStation.
#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."
#107 Analytics: from cost to profit centre (with Steen Rasmussen @ IIH Nordic)
In this week's episode of The Measure Pod, Dan and Bhav welcome back Steen Rasmussen from IIH Nordic, a previous guest known for his insightful perspectives.
#106 What an ideal expert analyst looks like
In this week's episode of The Measure Pod, Dan and Bhav explore the concept of what a senior analyst looks like and how to reach that level in your career.
#105 A web analyst’s guide to app analytics (with Juliana Jackson @ Monks)
In this week's episode of The Measure Pod, Dan and Bhav are joined by Juliana Jackson, who has a diverse background in sales, product, training, and analytics.
Integrating siloed data: Springer Nature marketing and sales case study
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 The sales and marketing teams depended on incomplete data, which didn’t capture the entire customer journey due to different systems in use. Transactions and re
Behind the Cloud: Using Generative AI in the GCP
In this episode of Behind the Cloud, Matthew delves into the world of generative AI in the Google Cloud Platform, highlighting how Google has integrated generative AI features into its various services. Matthew explores the ways generative AI can be used within BigQuery, such as generating SQL queries and Python notebooks! Video transcript Introduction to Generative AI in Google Cloud [00:00:00] Matt: Hello and welcome to another episode of Behind the Cloud. Uh, today we’re going to cover g
Firing up some remote feedback with My Three Things
Most people want more of it (even if they don’t always like it). Few would claim to be very good at it: asking for it, giving it, receiving it, or applying it. Yes, we're talking about remote feedback.
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 analysts
#103 Modern marketing (with Ken Williams @ DiveTeam)
In this week's episode of The Measure Pod, Dan and Bhav are joined by Ken Williams from DiveTeam to discuss modern marketing and measurement strategy.
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?
The life of Brian: Measurelab's generative AI journey
How Measurelab put our structures and policies in place around generative AI and how our exploration of the technology led us to the create Brian, our very own generative AI assistant
The data road trip: enjoying the journey
Data is a journey, not a destination. Learn how to navigate the complexities of data work by embracing flexibility and continuous improvement. Dive into practical insights on leveraging existing tools, investing in people, and appreciating partial data.
#102 Data is a road trip, not a destination
In this week's episode of The Measure Pod, Dan and Bhav discuss the concept of treating data as a journey, not just a destination.
Behind the Cloud: GCP foundational best practice
In this episode of Behind the Cloud, Matt explains how to organise GCP projects by specific use cases, how to automate processes, establish clear naming conventions, and follow best practices around security, tagging, and more. Video transcript Introduction [00:00:00] Matthew: Hello and welcome to another episode of Behind the Cloud. We’ve had a little bit of a brief hiatus but now we’re back and we’re going to do another series of videos. Today we’re going to kick off with what arguably sh
Measurelab's Madchester Spring Break Unconference
What connects Alexander von Humboldt, a tech stack originally called Urchin, and a TV show first aired in 2009? Obviously, the answer is the Measurelab Madchester Spring Break Unconference.
Behind the Cloud: Setting up a Dataform project within BigQuery
In this episode of Behind the Cloud, Matthew demonstrates how to enable and set up a Dataform project within BigQuery, connect it to GitHub, and initialise the workspace for building a Dataform project. Matt walks us through enabling BigQuery, creating a repository, setting up the region, and using service accounts. Video transcript Introduction to Dataform in BigQuery [00:00:00] Matt: Hello and welcome to this week’s behind the cloud sticking with the practical theme today. We’re going to
Sound Bite: The future of attribution modelling in Google Analytics
Episode Summary: In this weeks sound bite (from the archive) Dan discussed the end of rules-based attribution in Google Analytics 4. He reflects on the shift from Universal Analytics to GA4, highlighting the focus on data-driven attribution and the removal of other attribution models. He also explo
Sound Bite: How to approach building a dashboard
Episode Summary: In this weeks sound bite (from the archive) Dara discusses the process of building out automated dashboards. This includes everything from the initial wire-framing, the creation, and potential iterations you might need to make a long the way. Check out the full episode on how to b
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 tech trend as it travels the hype cycle. Right now, Customer Data Platforms (CDPs) are reaching the peak of inflated expectations - and are at risk of descending into the trough of disillusionment. Measurelab doesn’t resell technology licences and we don’t rake in money from vendor kick-backs. So we’re happy to tell it like it is. If you haven’t already got a CDP, you may not
Behind the Cloud: Connecting GA4 to BigQuery
In this episode of Behind the Cloud, Matt explores the practical side of Google Analytics 4 (GA4) and its free export feature to BigQuery. We learn about export limits, batch exports, and streaming options for GA4 data. The episode also touches on setting up BigQuery within a Google Cloud project. Video transcript Introduction to GA4 and BigQuery Export [00:00:00] Matt: Hello and welcome back to Behind the Cloud. This week we’re going to delve into something a little bit more practical. Whe
Grand Designs: "The Warehouse to CDP conversion"
Opening scene: A large meeting room at BigCorp. A systems architecture diagram with lots of boxes and arrows flowing from left to right fills a large whiteboard. Kelvin joins Jan (marketing director) and Joe (head of data) at the table, earnest expression, hands clasped in front of him. Kelvin: So, Jan, Joe, tell me a bit about the history of the warehouse. Joe: Well, going way back, it was originally an on-prem system, which was replaced back in 2019 with an Oracle data warehouse as part of a
#101 Daralytics (with Dara Fitzgerald @ Measurelab)
In this week's episode of The Measure Pod it's the end of an era as we bid farewell to our fellow co-host, Dara Fitzgerald.
Sound Bite: Building deeper relationships through personalisation
Episode Summary: In this weeks sound bite (from the archive) we revisit a conversation with David Mannheim from August 2023, diving into the topic of personalisation. David discusses how personalisation goes beyond just a recommendation engine, emphasising its role in building deeper connections wi
#100 ROI positive MarTech: is it possible? (with Glenn Vanderlinden @ Human37)
In this week's episode of The Measure Pod we spoke with Glenn Vanderlinden, co-founder of Human37. We spoke about CDP implementations, and whether or not they are ROI positive.
Behind the Cloud: Dataform, what is it and why does it matter?
In this episode of Behind the Cloud, Matt discusses Dataform, what it is, and why it matters. Video transcript Cloud Data Warehousing [00:00:00] Matt: Welcome to Behind the Cloud. Today we’re exploring data form, but first a little bit of scene setting. Over the past number of years, cloud computing, specifically cloud data warehousing, has advanced significantly. Huge amounts of data can be queried in seconds. The scalability of the platforms is near infinite from both a performance and a
#99 AI in Self-Serve Analytics (with Gaurav Tiwari @ Spotify)
In this week's episode of The Measure Pod we spoke with Gaurav Tiwari, ex-Meta, currently working as an Engineering Manager at Spotify.
Sound Bite: How can personalisation drive lasting value?
Episode Summary: In this weeks sound bite (from the archive) Dan & Dara spoke with Rasmus Houlind from Agillic. They chat about what personalisation entails, the distinctions between implicit and explicit personalisation, the ownership of the customer journey by the customer, and the adaptation of
#98 What on earth is a semantic layer?! (with David Jayatillake @ Delphi)
In this week's episode of The Measure Pod we spoke with David Jayatillake, co-founder of Delphi and organiser of the London Analytics Meetup.
#97 The future of event data (with Timo Dechau @ deepskydata)
In this week's episode of The Measure Pod we spoke with Timo Dechau, a product manager and analyst with a unique perspective on event tracking.
Behind the Cloud: The essentials of Google BigQuery
In this episode of Behind the Cloud, Matt discusses the essentials of Google Cloud’s BigQuery. Everything from project structure, data handling, to understanding the costs involved. Video transcript [00:00:00] Matt: Hello and welcome to Behind the Cloud. Today we’re going to be diving into the nuts and bolts of Google Cloud’s BigQuery and how it can help to revolutionise your marketing analytics. Whether you’re really familiar with the cloud or this is all new to you, this episode aims to gui
GA4 content performance reporting: Howard Kennedy success story
Howard Kennedy LLP is a London based, full-service law firm with nearly 200 lawyers in one location. They specialise in providing straightforward advice to entrepreneurial businesses and individuals on domestic and international matters. The challenge Howard Kennedy creates various ‘Hot Topic’ campaign pages featuring videos, podcasts, and articles. Despite tracking these pages with Google Analytics 4, the performance data was not directly available to campaign managers or lawyers. The object
#96 The Psychology of Data (with Tim Ceuppens @ Pit&Pit)
In this week's episode of The Measure Pod we spoke with Tim Ceuppens, a creative thinker in the field of data and marketing.
Sound Bite: How has the role of data changed over time?
Episode Summary: In this weeks sound bite (from the archive) Dan & Dara spoke with Jim Sterne from Target Marketing. He specifically discusses the changes in online marketing and data since the 1990s. Full episode here: https://shorturl.at/euwI1 ----- About The Measure Pod: The Measure Pod is a
#95 Analytics on form (with Alun Lucas @ Zuko Analytics)
In this week's episode of The Measure Pod we spoke with Alun Lucas, the Managing Director at Zuko Analytics. We spoke specifically about webforms, and the optimisation tool Zuko has built to help businesses.
Sound Bite: How can we improve accessibility on the web?
Episode Summary: In this weeks sound bite (from the archive) Dan & Dara spoke with Ellen Cole from Little Seed Group. Ellen shared insights on working with invisible differences and offers tips for businesses to enhance inclusivity in their social media and marketing efforts. Full episode here: ht
Behind the Cloud: What Google Cloud tools should you be familiar with?
In this episode of Behind the Cloud, Matthew aims to answer the question: what are the Google Cloud Platform tools of the marketing analytics trade? And more specifically, what are the tools that you should care about in Google Cloud. For a more in-depth write up on Google Cloud tools, check out Matt’s blog post. Video transcript [00:00:00] Matt: Hello and welcome to today’s episode of Behind the Cloud. We’re going to try and answer the question, what are the GCP tools of the marketing analyt
#94 Why don't people understand tech SEO and analytics? (with Matt Jones @ Freelancing Friends)
In this week's episode of The Measure Pod we spoke with Matt Jones, a Technical SEO freelancer, and creator of the Freelancing Friends community and podcast.
Sound Bite: Costs and considerations when migrating to server-side GTM
Episode Summary: In this weeks sound bite (from the archive) Dan & Dara spoke with our very own Matt Hooson, the Data Engineering Lead here at Measurelab. In this clip taken from episode 74 we discuss the update framework he's developed, and the costs and considerations when migrating to server-sid
#93 GA4, the CDP of the future you didn’t know you had (With Rick Dronkers @ Data to Value)
In this week's episode of The Measure Pod we welcomed Rick Dronkers back from Data to Value. We talked about all things CDP and GA4.
Sound Bite: GA4 vs BigQuery data, what are the use cases?
Episode Summary: In this weeks sound bite (from the archive) Dan & Dara spoke with Johan van de Werken from GA4BigQuery.com. In this clip taken from episode 72 we discuss the use cases for using the GA4 interface over BigQuery data, and some thoughts around where that's going in the future. Full e
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
#92 Christmas Special: Year in review and predictions for 2024
In this week's episode of The Measure Pod, it's our Christmas special! Dan and Bhav discuss the highs and lows of the past year, and predictions for 2024.
Sound Bite: Neurodiversity in data, technology and IT
Episode Summary: In this weeks sound bite (from the archive) Dan & Dara spoke with Marc Crawley from Diversita, a recruitment company that specialises in advising and empowering neurodivergent data, technology and IT professionals. Full episode here: https://shorturl.at/fsyHQ ----- About The Mea
#91 Warehouse native analytics (with Adam Greco @ Amplitude)
In this week's episode of The Measure Pod we spoke to Adam Greco from Amplitude. We talked specifically around warehouse native analytics, and whether it's a passing trend or an integral part of the future.
Sound Bite: What are the differences between ePrivacy and GDPR?
Episode Summary: In this weeks sound bite (from the archive) Dan & Dara spoke with Rowenna Fielding, a data privacy expert. She discusses the difference between ePrivacy and GDPR, as well as debunking cookie consent. Full episode here: https://shorturl.at/mxTW5 ----- About The Measure Pod: The
Measurelab and AI: welcome to the augmented era
There’s nowhere you can hide from AI at the moment. And the Measured Opinions blog is no exception. Here’s what’s changing at Measurelab. And what’s going to remain reassuringly familiar.
Sound Bite: Building effective learning experiences in analytics
Episode Summary: In this weeks sound bite (from the archive) Dan & Dara spoke with Phil Gomm and Tony Reeves from Ding, a learning design consultancy. They discussed with us what learning design is, and how it can be applied to the analytics industry to create positive experiences. Full episode h
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.
Sound Bite: Unraveling the meaning of personalisation with David Mannheim
Episode Summary: In this weeks sound bite (from the archive) Dan & Dara spoke with David Mannheim about personalisation, and the meaning behind it. Full episode here: https://shorturl.at/yAU37 ----- About The Measure Pod: The Measure Pod is a weekly podcast hosted by veteran practitioners of th
Sound Bite: Rick Dronkers discusses data privacy and GDPR
Episode Summary: This is the first of our weekly sound bites (from the archive). In this clip from September 2022, Dan & Dara spoke with Rick Dronkers about GDPR and data privacy. Full episode here: https://shorturl.at/cIKSU ----- About The Measure Pod: The Measure Pod is a weekly podcast hoste
Connecting GPT to BigQuery: Zapier AI actions
Using Zapier AI automation, we aim to build our very own GPT capable of grabbing data from BigQuery for analysis.
What is GA4's Measurement Protocol?
We're looking to delve into the depths of the Measurement Protocol - a powerful tool that can transform how you collect and analyse data.
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.
The Google Cloud tools of the marketing analytics trade
The GCP is vast and overwhelming. We aim to sort through the clutter and help highlight what you need to know as a digital marketing professional.
GA4 app attribution case study: Pret + Adjust integration
Pret a Manger is a brick and mortar chain of coffee shops serving freshly made food and good organic coffee. They have 600+ stores distributed globally and their analytics team is responsible for over 30 million events every month collected across both web and app. “Measurelab have been a key partner to us as we’ve undertaken a complete overhaul of our app and web analytics. Having access to the wide range of skillsets within the organisation has been invaluable as we’ve embarked on this journ
Gathering insights at MeasureCamp London 2023 (BONUS)
Full show notes, transcript and (NEW!) AI chatbot - https://bit.ly/3tEDQL8. 00:00 Start 00:15 Intro 00:40 Main topic 00:40 What’s the biggest challenge today which will be gone in five years time? 03:42 What will be the biggest challenge in the next five years? 07:53 Outro ----- Episode Summary:
#90 Self-serve analytics: yay or nay
In this week's episode of The Measure Pod, Bhav reflects on his biggest career failure: self-serve analytics. They discuss the challenges and complexities of implementing self-serve analytics in organisations, highlighting the factors that contribute to its success or failure.
Core Web Vitals optimisation case study: UAL reduces container size & improves performance
The University of the Arts London (UAL) is the largest specialist Art and Design institution in Europe with over 18,000 undergraduate and postgraduate students. It comprises six specialist art and design colleges: Camberwell College of Arts, Central St Martins, Chelsea College of Arts, London College of Communication, London College of Fashion and Wimbledon College of Arts. The UAL Digital Public Platforms team manages data from across 10+ sites and over 250,000 users a month. The challenge
#89 Integrating analytics into product teams (with Barry Pace @ Penfold)
In this week's episode, Dara, Bhav, and Barry dive into the world of product management and analytics. They discuss the importance of integrating analytics into the product development process and how it can enhance decision-making.
Call propensity analysis for Sanderson – bridging online data and call centre insight
Sanderson Design Group designs and manufactures wallpaper and fabrics, with a history stretching back more than a century. It trades under several brands including Arthur Sanderson & Sons, Morris & Co., Zoffany and Harlequin. The analytics team manages 5+ sites and over 20,000 digital transactions per month. The challenge Sanderson has recently launched a new B2B ordering system, aiming to streamline order generation and reduce customer service calls. Following the implementation, call volum
BigQuery optimisation case study: EDF Energy saves 250 GB a day
EDF Energy is the UK division of EDF, the multinational energy company. Their services span electricity generation and the sale of natural gas and electricity to homes and businesses throughout the United Kingdom. Their analytics and insight team manage data from 15+ websites and apps totalling 65 million events every month. We helped reduce their data query volume by an astonishing 250GB per day! The challenge During the migration to Google Analytics 4 (GA4), EDF aimed to streamline their
#88 Analytics as a data product (with Weiting Xu @ Cazoo)
In this week's episode, we dive into the fascinating world of analytics as a data product. Our guest, Weiting Xu, shares their insights and experiences as the head of data at Cazoo.
#87 A/B testing controversies and generative AI (with Shaun McGirr @ Dataiku)
In this week's episode of The Measure Pod, we speak with Shaun McGirr from Dataiku. We explore the world of A/B testing, experimentation, and the future of analysts' roles as generative AI becomes more prevalent.
#86 The evolving challenge of SEO measurement (with Alex Harvey @ ASOS)
In this episode Dan, Dara and Bhav had the pleasure of chatting with Alex, Head of SEO & Marketing Technology at ASOS.
GTM’s new Google tag: one tag to rule them all
Goodbye to the GA4 Config Tag Anyone who’s spent any time implementing the Google Analytics 4 (GA4) tracking in Google Tag Manager (GTM) over the past few years will be familiar with the GA4 Configuration tag. Essentially the top level of tracking within GTM for configuring GA4, this is where you would specify your Measurement ID, configure server requests and specify things like event parameters and user properties. The GA4 Config tag would then typically act as a reference point for all your
#85 Who cares about data literacy?
Join Dan, Dara and Bhav dive into the topic of data literacy, discussing the importance of data curiosity, data storytelling, and effective data communication.
#84 The future of product analytics tools
Join Dan, Dara and Bhav discuss the future of product analytics tools and the intersection between product analytics and marketing analytics.
Customising GA4's reports menu using the report library
By now you’ll all have GA4 up and running (I hope!) but now the realisation is kicking in that you have to actually start using the UI and I don’t know about you all but for me, it didn’t quite feel right. Let’s talk about the UI, where the hell did all my reports go?! I miss Universal Analytics UI! There I said it. GA4 is fantastic and I love some of the new features they have brought out like creating and modifying events from within the UI and the additional layer of user acquisition; howev
#83 GA is dead, long live GA!
In this week's episode of The Measure Pod, Dan, Dara and Bhav delve deep into the transition from Universal Analytics (UA) to Google Analytics 4 (GA4).
The Derelict Data Warehouse
A well-maintained and utilised data warehouse is a thing of beauty. Imagine all your data from disparate sources autonomously extracted, loaded and transformed into nice neat reporting tables. Picture, if you can, impactful analysis, company-wide data-driven decision-making, a true understanding of return on ad spend. It’s enough to make anyone weak at the knees. But therein lies the problem. Companies (or ambitious individuals) can be too desperate to reach the promised land and rush headlong
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
#82 The person in personalisation (with David Mannheim @ Made With Intent)
Dan, Dara and Bhav are joined by David Mannheim (founder of Made With Intent and author of The Person In Personalisation) to talk about the world of personalisation.
#81 Marketing vs. product analytics
Dan and Dara kick off a new season of The Measure Pod by introducing Bhav Patel as a guest co-host and discussing all things marketing and product analytics.
The Measure Pod: 2 years of podcasting
If you also work in an industry like analytics, there's generally very few people who you can really talk to about work stuff. I bet most of us have had something like "do you have Chandler Bing's job?" said to us at some point. Or is that just me? Anyway, to the point. Almost to the day two years ago I wrote about how we set up and launched The Measure Pod - wow, doesn't time really fly! If you've never come across the podcast The Measure Pod, you'd be forgiven. Like a lot of things, it was b
How to create new events in GA4 (using the UI)
Google Analytics 4 (GA4) gives users the ability to create new events or modify existing events through the use of the GA4 user interface. This is a fantastic add-on available to all and will be welcomed by those who are not familiar with their existing tag management system or do not have the relev
What is bounce and engagement rate in GA4?
What is “engagement” in Google Analytics 4 (GA4)? How does Google Analytics define and measure engaged sessions vs. ‘Bounced’ sessions? And what happened to Bounce Rate?
Measuring marketing ROI with GA4's acquisition reports
For any data-driven business, understanding where website visitors come from is a crucial component of optimising marketing campaigns and improving ROI. Acquisition reports in Google Analytics 4 (GA4) provide valuable insights into visitor acquisition and can help businesses make informed decisions
Backing up Universal Analytics data in BigQuery
Saying goodbye to UA hurts, especially when you need your historical data out before Google deletes the lot. We at Measurelab built our own tool to soothe this pain for our clients.
#80 A chat about $PodcastSubject with $GuestName (with Rasmus Houlind @ Agillic)
This week Dan and Dara are joined by Rasmus Houlind - author of the book Hello $FirstName and CXO at Agillic.
#79 Quant and qual data, different but complementary
This week Dan and Dara chat about quantitative and qualitative data, the merits of each type, and how they need to be used together and not siloed away in different teams.
#78 Sessionization is back baby!
This week Dan and Dara chat about the slow but steady move in Google Analytics 4 (GA4) towards reintroducing older session-based metrics.
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.
#77 All things SA360, DV360, CM360 and GA4 (with Alexis Nicolas @ brīt klik)
This week Dan and Dara are joined by Alexis Nicolas from brīt klik. They discuss the reasons why companies would want to move beyond just using Google Ads to use the GMP, and where GA fits into this.
How to set up GA4’s custom insights and email alerts
What are custom insights? Sometimes the data available in Google Analytics 4 (GA4) can seem a bit overwhelming especially if you have a complex site with lots of users coming and going every day. It can often seem difficult to quickly identify the most important trends or anomalies. Thankfully GA4’s Analytics Intelligence is here to help bring some much needed clarity. This is a group of features that uses modelling to help you understand your data. Insights is one such feature and it comes in
#76 The end of rules-based attribution is nigh!
This week Dan and Dara are back solo this week to talk about the recent news from Google that they are removing most of the rules-based attribution models from GA and Google Ads.
How to create events in GA4 using the UI
Google Analytics 4 (GA4) now gives users the ability to create new events or modify existing events through the use of the GA4 user interface. This is a fantastic add-on available to all and will be welcomed by those who are not familiar with their existing tag management system or do not have the relevant tech resources available to make some changes in a timely manner. Why would you create an event? First of all, creating a new event keeps you safe from interacting with existing events that
#75 Learning design in analytics (with Phil Gomm and Tony Reeves @ Ding)
This week Dan and Dara are joined by Phil Gomm and Tony Reeves from Ding, a learning design consultancy.
#74 The UPDATE framework for server-side GTM migrations (with Matthew Hooson @ Measurelab)
This week Dan and Dara are joined by Matthew Hooson from Measurelab to talk about server-side Google Tag Manager (sGTM) and the UPDATE framework for migrating over.
#73 Starting a product analytics consultancy (with Bhavik Patel @ CAUSL)
This week Dan and Dara are joined by their first returning guest Bhav Patel! Hear from Bhav what it's like starting a consultancy and whether Google Analytics 4 (GA4) is disrupting the product analytics space.
What is a 'User' in GA4?
GA4 doesn’t track people, it tracks users. But users are the closest proxy we have to counting people, so we end up just using it anyway, but do you know what it means?
#72 A conversation on BigQuery and GA4 (with Johan van de Werken @ GA4BigQuery.com and New10)
This week Dan and Dara are joined by Johan van de Werken, creator of GA4BigQuery.com. They chat about how GA4BigQuery started and where it's going, how Johan moved from letters to numbers.
Using UTM parameters for tracking campaigns in GA4 (properly)
UTM parameters are essential to be able to measure your marketing links and campaigns effectively in GA4. In this guide, I show you what they are and how to use them properly. There's also a free Google Sheet to use yourself to manage the link building process.
#71 The Universal Analytics demise timeline and GA4’s latest updates
This week Dan and Dara are once again running solo, to discuss the Universal Analytics (UA) sunset timeline and when you should have Google Analytics 4 in place.
What is Google Analytics 360 (GA360) for GA4?
Google Analytics 360 (GA360) is worth knowing about, especially if you’re using Google Analytics 4 (GA4) to report on a business that gets a lot of daily traffic; has multiple analytics projects dependent on the BigQuery extract; operates on a lot of different sites and/or apps or has a particularly
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.
GA4 property and data stream setup best practices
How do you structure a GA4 property and data stream, what considerations do you have to watch out for, and what are the options?
How to filter and compare data in GA4's reports
GA4's default reports are fine, but we need to be able to filter, compare and manipulate the data to fit specific needs, here's how.
Understanding and using GA4’s default reports
The reports section in GA4 is where you will do your day-to-day reporting. Here's how each of the default reports can be used effectively.
#70 Building dashboards like a pro
This week Dan and Dara talk about their experiences in building automated dashboards.
#69 Dry your eyes, say your goodbyes, another one dies, it’s Google Optimize!
This week Dan and Dara talk about the very recent announcement that Google Optimize will be sunset on 30th September 2023.
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!
How to deal with the GA4 Data API quota limitations in Looker Studio
Still struggling with Google Looker Studio breaking due to the GA4 Data API quota limits? We have tested some of the available solutions for you to help get around the issues and get a working dashboard up and running.
UPDATE: a six-step framework to server-side GTM migrations
If you’re ready to make the leap to a server-side Google Tag Manager (sGTM) container, we developed the UPDATE framework to help you maximise your chances of a successful switch.
#68 The untapped potential of neurodiverse talent in data and tech (with Marc Crawley @ Diversita)
This week Dan and Dara are joined by Marc Crawley from Diversita, a recruitment organisation that specialises in advising and empowering neurodivergent data, technology and IT professionals.
#67 GA4 features we need to see in 2023 (with Usman Qureshi @ Spiralyze)
This week Dan is joined by Usman Qureshi from the CRO agency Spiralyze to discuss all the GA4 features that they need to see in 2023.
#66 Our 2023 predictions for the analytics industry
This week Dan and Dara are chatting about what they think will change in the analytics industry in 2023.
#65 Apple rolls out SKAdNetwork 4.0 (with Luisa Del Maschio @ Jellyfish)
This week Dan and Dara are joined by Luisa from Jellyfish to help make sense of the recent SKAdNetwork 4.0 release from Apple.
#64 The Measure Pod 2022 in review
This week Dan and Dara take a look back across The Measure Pod in 2022 and share some numbers and statistics of how it's been going. They also each share their top 5 episodes of the year, and compare notes.
2022: Measurelab’s year in review
A reflection on the year gone by and how far we’ve come as a company and team. From taking over the north, growing the team, and an ever growing GA4 and sGTM appetite, this is the time to give ourselves a big pat on the back.
#63 Safari is at it again - capping 1P cookie lifetimes and redefining 3rd party!
This week Dan and Dara discuss the recent changes announces from Apple on the way they will be copping 1st party cookie lifetimes - even if being being set via server-side GTM.
Why you should consider Cloud Run for server-side GTM
Why is exploring Cloud Run as an alternative to App Engine for sGTM instance provision now recommended? And what we found in terms of cost and stability.
#62 Debunking common cookie consent, GDPR and ePrivacy myths (with Rowenna Fielding @ Miss IG Geek)
This week Dan and Dara are joined by Rowenna Fielding "a warrior on the front line of the fight to defend humanity's rights and freedoms in an increasingly tech dystopia", and helps organisations stitch together technology, law and humanity to make stuff work the way they want it to.
#61 WTF Google?! GA4’s Data API quotas are breaking things!
Dan and Dara are back, and this week are discussing the recent update from Google Analytics where they are now enforcing their Data API quotas.
GA4's Data API quotas are breaking Looker Studio reports
If you've been using Looker Studio (formerly Data Studio) to build GA4-based reports and dashboards, you might have noticed that they have started to break. Here's some information about a recent change Google Analytics has made that has caused these errors.
Dream team: the 4 people you need on your digital analytics team
There’s no one-size-fits-all approach to building an analytics team, but there are four types of people you should look for to advance your in-house analytics capabilities.
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’.
#60 The inevitable… Google postpones sunsetting GA360
This week Dan and Dara discuss the recent announcement that the sunsetting of GA360 has been pushed back 9 months to the 1st July 2024.
#59 Digital accessibility in social media and analytics (with Ellen Cole @ Little Seed Group)
This week Dan and Dara are joined by Ellen Cole - an award-winning Marketing, PR and Social Media marketer with a focus on inclusivity and accessibility in digital.
#58 In the GA4 trenches (with Stacey Harper @ Sharper Digital)
This week Dan and Dara are joined by Stacey Harper, a fellow GA4 expert and trainer! They discuss war stories, hidden features and the huge importance of a migration strategy/plan for migrating to GA4.
MeasureFest 2022: why GA4 means you should get on board with BigQuery
MeasureFest is an analytics conference, part of brightonSEO. Katie ran a talk this year all about how BigQuery should be your friend when migrating over to Google Analytics 4, like it or not!
How to review SQL code in BigQuery for duplication and errors
Just because your SQL has run without any errors, it does not mean it's error free! Here's some tips on how to aviod the most common to make mistakes and issues.
#57 Who you Lookering at? (with JJ Reynolds @ LookerStudio.VIP)
This week Dan and Dara are joined by JJ Reynolds to chat about the recent rebranding of Data Studio to Looker Studio and what it means for the rest of us.
#56 Why GA4 means you need to get on board with BigQuery - MeasureFest (with Katie Kaczmarek @ Measurelab)
This week Dara is joined by fellow Measurelabber Katie to discuss her recent talk at MeasureFest (part of brightonSEO). They run through the talk content around why everyone using GA4 should get onboard with BigQuery.
#55 BREAKING changes in the GA4 Data API
This week Dan and Dara react and discuss the recent announcement of the schema changes in the Google Analytics 4 (GA4) Data API.
#54 The current state of play with GA4
This week Dan and Dara reflect on the current state of play with Google Analytics 4 (GA4), with migrations being a hot topic at the moment for Measurelab.
#53 A conversation with the one and only Jim Sterne (with Jim Sterne @ Target Marketing)
This week Dan and Dara chat with Jim Sterne and chat about the Digital Analytics Association and his long and illustrious career in digital.
#52 Talking privacy, GDPR and GA4 (with Rick Dronkers @ Data to Value)
This week Dan and Dara chat with Rick Dronkers to talk everything privacy - from compliance and GDPR, to Schrems and Google's stance.
#51 From marketing to milk (with Bastien Eymery @ Lilk)
This week Dan and Dara catch up with Bastien Eymery on his journey from data science, to growth marketer to plant-based milk founder.
Change your Google Analytics data retention settings
Did you know the default data retention period in GA4 is set to 2 months? Don't lose the ability to report and explore - change your data retention settings today.
#50 Who wants to be an analyticsionaire!
This week Dan puts Dara in the hot seat for a Who Wants to Be a Millionaire special! Dara is raising money for charity, and Dan has curated 15 challenging questions.
Doom: GTM edition!
For 30 years Doom has been ported onto every device imaginable, now it's time to be able to play it on any website with the help of GTM!
#49 Will you still need GA360 in a GA4 world?
This week Dan and Dara chat about assessing the need for Google Analytics 360 in a GA4 world.
How to delete events in Google Analytics 4
You can't fully delete event in GA4, which is a problem. See how to work around the limitations and fully delete events for good.
#48 Cookies and consent in Google Analytics
This week Dan and Dara chat about some new cookie settings released in Google Analytics 4.
#47 Digging into Snowplow (with Jordan Peck)
This week Dan and Dara are joined by Snowplow's Jordan Peck to chat shop about what Snowplow is, how and where it's used, and the differences between Google Analytics.
Can you measure the return on analytics?
Is it possible to show a return on analytics or is seeking ROI a futile folly? If you can't point to directly-attributable revenue, how else might you quantify the contribution of an analytics team?
#46 Google Analytics for apps (i.e. Firebase) vs. websites
This week Dan and Dara discuss the differences in setting up and using the data from Google Analytics on apps versus websites.
How to access BigQuery data from server-side GTM (via Firestore)
This guide details the steps to be able to augment server-side GTM tags with data stored in BigQuery before they are sent to their endpoints.
How to set up the GA4 BigQuery export
Setting up the Google Cloud Platform (GCP) so that you can export the data from Google Analytics 4 (GA4) can often be confusing, and the documentation from Google can be a bit vague. This guide walks through all the steps to get it set up correctly, and enable the GA4 exports.
#45 Forecasting analytics with machine learning (with Richard Fergie)
This week Dan and Dara are joined by Richard Fergie to chat all about forecasting with machine learning models, and the flaws in Google Analytics 4's machine learning approach to watch out for.
#44 What we’ve learned from teaching analytics
This week Dan and Dara talk about what they've learned training analytics over the last 10 years.
#43 What is data retention in GA?
This week Dan and Dara dive into the world of data retention and the somewhat secret setting that is in Google Analytics 4 and Universal Analytics alike.
#42 Consent Mode and behavioral modelling in GA4
This week Dan and Dara discuss the latest Google Analytics 4 release of behavioural modelling with consent mode - possibly the biggest single update to Google Analytics ever!
MeasureCamp London 2022: our top highlights & lessons
In May 2022, it was the 10th anniversary of MeasureCamp London and a few of us Measurelabbers headed out for a Saturday of analytics discussions, debates and fun!
#41 Littledata's GA4 journey (with Edward Upton)
This week Dan and Dara are joined by Edward Upton to talk about how Littledata are approaching GA4 with all of their ecommerce clients across Shopify and BigCommerce.
What is Consent Mode for GA4?
Consent Mode is used in Google Analytics 4 to model unconsented user data into the reports, but what is it? This guide will explore what Consent Mode is, and how GA4 and GTM utilises it.
GA4 event types guide
There are a lot of different types of events in Google Analytics 4 that are not obvious when getting started. This guide details all the different event types and where and when they should be used.
Measuring offline marketing efforts with Google Analytics
Tracking digital marketing campaigns in Google Analytics is easy - in theory at least. Can the efficacy of offline campaigns be measured in GA? The short answer is yes, but proceed with caution.
#40 What is the modern data stack? (with Mark Rittman)
This week Dan and Dara are joined by Mark Rittman to talk about the 'modern data stack' and how the danger with all analytics implementations is the ‘so what’ factor.
#39 Product analytics and CRAP Talks (with Bhavik Patel)
This week Dan and Dara are joined by Bhavik Patel to talk about the differences and similarities between product and marketing analytics.
brightonSEO and MeasureFest April 2022: our favourite talks
In April 2022, a few Measurelabbers got together for three days to attend brightonSEO and MeasureFest (an analytics-themed fringe event). After the three days, we all got together to discuss our favourite stand-out talks of the event on The Measure Pod podcast which you can listen to below.
#38 How do you measure the return on analytics?
This week Dan and Dara discuss how to measure the return on analytics and the different ways that analytics specialists can measure a tangible return for their hard work.
Calculating Session Days in Google Data Studio
Google's game streaming service Stadia introduced the concept of Session Days, something we can use in the digital analytics world too using Data Studio and Google Analytics 4.
Screen orientation calculation in Google Data Studio
Here's a Data Studio CASE formula to work out the screen orientation (portrait or landscape) from the resolution.
#37 How attribution works in Google Analytics 3 and 4
This week Dan and Dara chat through how attribution works in Universal Analytics and Google Analytics 4, and the differences between them.
How to track scroll depth conversions in GA4
Learn how to track scroll depth conversion on specific pages in GA4 without coding or tagging in Google Tag Manager.
#36 Events, events, events - explaining the various GA4 event types
This week Dan and Dara chat through all of the event types Google Analytics 4 has to offer - from automatically collected, to enhanced measurement, to customised.
Defining the Campaign Timeout in Universal Analytics
The Campaign Timeout setting in Universal Analytics is hard to understand, and often misunderstood. Here we explain what it is and how it effects pretty much all of your data in GA.
#35 Is tracking too much a bad thing?
This week Dan and Dara chat about the troubles of tracking too much in Google Analytics, especially when migrating from Universal Analytics to Google Analytics 4.
#34 MeasureFest and brightonSEO - April 2022 debrief (with Liam Grant and Matthew Hooson)
This week Dan and Dara are joined by Liam Grant and Matthew Hooson to chat about their experiences at MeasureFest and brightonSEO.
#33 What to do as the sun is setting on Universal Analytics
This week Dan and Dara discuss the sunsetting of Universal Analytics in 2023. They discuss what the timeframes really mean, and what you'd need to be doing at each stage.
Running Adobe Analytics and Google Analytics in parallel
Why would you run both Adobe Analytics and Google Analytics on your website? Won’t you end up with two parallel running tools reporting different figures?
#32 Measuring SEO (with Jenni Stacey)
This week Dan and Dara are joined by Jenni Stacey to chat SEO measurement and how Google Analytics is (if at all) useful.
How to build an interactive GA4 BigQuery data schema
What and why? One of the great features of Google Analytics 4 (GA4) is the ability to pass data into BigQuery (BQ). There are many benefits to this which have already been covered in some of our previous blogs (i.e. 10 reasons to export your GA4 data to BigQuery). Passing data to BigQuery is no longer just available to enterprise GA360 customers, but to anyone using GA4 for free. What I wanted to create was a simple interactive way to explore how GA4 data is saved in BigQuery. I found the GA36
#31 The brightonSEO and MeasureFest story (with Kelvin Newman)
This week Dan and Dara are joined by Kelvin Newman to chat all things brightonSEO and MeasureFest.
The sun is setting on Universal Analytics
It’s finally happening. Google has announced the sunsetting of Universal Analytics, or more specifically, the date when UA will stop processing new hits. The 1st of July, 2023. For those without a calendar to hand, that’s fifteen and a half months from now. So plenty of time still to think about migrating to Google Analytics 4, right? Wrong. Well, wrong if on 1st July 2023 you want to be able to compare your latest GA4 data with comparable data from the previous year. And what analyst wouldn’
(BONUS pod) Google is sunsetting Universal Analytics!
Dan and Dara react to the big news (bombshell) from Google about them sunsetting Universal Analytics in 2023. The announcement from Google can be read in full at https://bit.ly/3thHJDq. Check out on LinkedIn: - Dan - https://bit.ly/3JQKHEb - Dara - https://bit.ly/3vzV0bO - Measurelab - https://bit
#30 Why use both GA and AA? (with Liam Galliers)
This week Dan and Dara are joined by Liam Galliers to discuss why you'd have both Adobe Analytics and Google Analytics on your website. They chat about the differences, and who they think the target audiences are for each.
GA4 BigQuery export schema
In BigQuery, the Google Analytics 4 schema is completely different to the (Universal) Google Analytics 360 schema. This tree map is a simple interactive way to explore the new schema for new and old GA/BigQuery users alike.
#29 Can you track offline marketing in GA?
This week Dan and Dara discuss the intricacies of measuring offline marketing activities in Google Analytics. What the various methods are, and what to look out for when analysing the performance of the offline channels.
#28 The MeasureCamp story (with Peter O'Neill)
This week Dan and Dara are joined by Peter O'Neill to talk about how he founded MeasureCamp and what the journey was like from the very first one, through COVID, to what the future holds for the analytics unconference.
From the wild west of data collection to conversion modelling
How will Google’s machine learning conversion modelling and other models change analytics? Is this the end of real data?
How to use the BigQuery Data Transfer Service for Google Ads
To perform advanced data analysis, you need a powerful data warehouse like BigQuery. Here’s how to extract Google Ads data using the BigQuery Data Transfer Service.
Google Analytics limitations: where GA falls short
It’s an uncomfortable truth for Analytics specialists: GA is not always the answer. Google Analytics' limitations mean it won’t always be the right solution for you.
#27 Common Google Analytics mistakes to avoid
This week Dan and Dara talk about common Google Analytics mistakes they see time and time again. From using UTMs incorrectly to having analytics siloed away.
How to force a hit-level segment in Universal Analytics
In Universal Analytics, you can build a user-level or session-level segment. Here’s a nifty little hack to force a hit-level condition to get the data that you want.
#26 App attribution for dummies, and web analysts (with Derek Ooi)
This week Dan and Dara are joined by Derek Ooi to talk about app attribution, and why an MMP is essential.
#25 Dan and Dara’s analytics journey
This week Dan and Dara take a walk down memory lane and chat about how they got into the weird and wonderful world of analytics.
5 new GA4 features we want Google to introduce in 2022
Whether GA4 is the ‘new and improved’ version of Universal Analytics remains to be seen. There are some GA4 features and functionality we’d like to see in 2022.
#24 What will the role of GA be in the future?
This week Dan and Dara discuss where they think the future of Google Analytics is heading. Spoiler alert - like it or not, it's all GA4.
Keep up! - the ultimate analytics resource round-up
Keeping up with the analytics industry is a daunting task. This list is a good starting point for anyone wanting to get caught up - or stay one step ahead.
How to reduce the cost of BigQuery data processing
BigQuery cost optimisation tips to reduce the number of bytes processed and the cost of running queries.
#23 How to keep up with analytics
This week Dan and Dara are back together for the first time in 2022 to discuss how they like to keep up to date with the analytics technology, legislation and industry in general.
#22 Data-driven attribution - the past, present and future (with Tom Woods)
This week Dan is joined by Tom Woods to discuss all things data-driven attribution off the back of Google Analytics 4 launching DDA as their go-to model.
#21 GA4 features we need to see in 2022 (with George Mendham)
This week Dan is joined by George Mendham to discuss what features Google Analytics 4 needs to reach parity with Universal Analytics (and surpass).
The nine signs of analytics maturity
How do you measure up when it comes to analytics maturity? Forget all those finicky frameworks. If you're displaying one of these nine signs then chances are, you're on the right track.
2021: Measurelab’s year in review
A reflection on the year gone by and how far we’ve come as a company and team. From remote working to co-working, finding time for fun, and a growing appetite for GA4, we only mention Covid a few times.
How to enable the GA4/Firebase DebugView for Android apps
How to enable analytics debug mode on an Android device, using the GA4/Firebase DebugView to monitor app event data.
#20 Why you should link GA4 to BigQuery today (with Lace-Chantelle Rogers)
This week Dan and Dara are joined by Lace-Chantelle Rogers to discuss why it's important to link GA4 to BigQuery as soon as possible.
#19 Sheets, the unsung hero of GA
This week Dan and Dara discuss the relevance of the Google Sheets connector for GA, and if GA4 not having one will be a big deal or not.
#18 What is analytics maturity today? (with Steen Rasmussen)
This week Dan and Dara are joined by Steen Rasmussen from IIH Nordic to discuss how to approach and access analytics maturity in the modern era since COVID-19.
10 reasons to export your GA4 data to BigQuery
There are a lot of benefits to linking your GA4 data to BigQuery – we’ve got ten good reasons for you to take your analytics to the next level today.
#17 Why you should be using Segments in Universal Analytics
This week Dan and Dara discuss Segments in GA. They discuss some good use cases, lesser-known hacks and applications.
#16 The quantified self: Whoopcast (with Steven Elliott)
This week Dan and Dara are joined by Steven Elliott, our Managing Director. Steve discusses how tracking data about his body and exercise has enabled him to run experiments that have optimised his sleep and recovery.
How to write a value to a cookie using GTM
Learn how to create and set cookies using Google Tag Manager using this simple script and a Custom HTML tag.
The superpower of objectivity
The do-it-yourself approach to data-driven organisational change can be daunting – an objective consultant, removed from the day-to-day operations of the business, can take more risks.
#15 When is GA not the answer?
This week Dan and Dara discuss various situations when GA is not the answer. Whether it's navigating gaps in data collection, or forcing types of data analysis that don't quite work.
#14 How COVID-19 impacts data analysis (with Jake Birch)
This week Dan and Dara are joined by Jake Birch, Lead Analytics Consultant at Measurelab. They discuss how COVID-19 has affected how he has analysed data for his clients over the last 18+ months.
#13 Server-side GTM, what is it?
This week Dan and Dara talk about server-side GTM. It's come out of beta, so they discuss what it is, why it's important and where it's going.
#12 Why impartiality is important in marketing analytics (with Mark Rochefort)
This week Dan and Dara have guest Mark Rochefort, Technology and Operations Director at Measurelab. They discuss why being impartial is vital in marketing analytics and the skills becoming more important to spot unconscious and conscious biases when working with data. The article from G
#11 Is this the end of real data in analytics?
This week Dan and Dara discuss how the access to 'real' data in Google Analytics is becoming more limited due to technology and legislation changes.
Key KPIs, ATM machines and other such nonsense
All KPIs are metrics, but not all metrics are KPIs. Are they key to the business’ success? Or do they contribute to it? When it comes to analytics, not all performance indicators are critical.
How core values define a company
At Measurelab, we look to our company values to drive the company culture. The whole company has to feel connected to these core values; they have to mean something to everyone.
Measured Opinions #10: Better metrics for web measurement
This week Dan and Dara dig deep into the ABCs of Google Analytics metrics. Defining what they actually mean and their relevance and/or place in the modern technological age.
Everything’s an experiment
Everyone in the team has ideas for how we can optimise the organisation. Here’s how we use an Experiment Canvas and Experiment Board to prioritise and manage change at Measurelab.
Measured Opinions #9: Is attribution modelling important?
This week Dan and Dara chat attribution modelling and how/where/if/when it's useful and important to invest in.
Measured Opinions #8: The 15 minute GA audit
This week Dan and Dara run through an audit for Universal Analytics properties in 15 minutes. They touch on common issues when looking at GA and how to fix them.
PIVOT: a five-step process for your GA4 migration
If you’re migrating from Universal Analytics to Google Analytics 4, our PIVOT framework provides guidance on what you’ll need to consider at each stage of the process. See our GA4 migration guide.
Measured Opinions #7: The GA4 PIVOT framework
This week Dan and Dara discuss the PIVOT framework they've been working on to help people 'pivot' to GA4. Clever, very clever...
Measured Opinions #6: Do you really need GA360?
This week Dan and Dara discuss the questions you can ask yourself to see if you need to consider upgrading to Google Analytics 360 (GA360).
Measured Opinions #5: What is a UTM and why is it so important?
This week Dan and Dara discuss Google Analytics' infamous UTMs. They talk about what they are and why they're important in having good, reliable and clean data.
GA4 event parameters - now with extra pickles!
Google Analytics offers unlimited options for customising your event parameters. George explains how you can get yours made to order.
Getting started with Google BigQuery
BigQuery is literally the next “Big” thing (with a capital B) in analytics. We explain what it is, how some of our clients are already using it, how much it costs and where you can start.
Measured Opinions #4: What makes a good analytics consultant?
This week Dan and Dara discuss what makes a good analytics consultant. In other news, Dara is running and Dan is still harking on about skateboarding in the Olympics!
How to flatten tables with user-defined functions in BigQuery
Flattening tables in Google BigQuery can be painful when doing multiple fields with UNNEST. User-defined functions (UDFs) make life easier and this one will do it for you automatically.
The Measure Pod: a podcast from Measurelab
We’re so obsessed with analytics that we started a podcast! Here’s how we turned our passion into The Measure Pod.
Measured Opinions #3: What to know before you start with GA4
This week Dan and Dara discuss the four things analytics practitioners should consider before rolling out Google Analytics 4 (GA4).
How to share access to a single BigQuery dataset with GCP IAM
Sometimes less is more; especially when it comes to security access. This simple walkthrough will show you how to use GCP IAM to surface just the parts of your data warehouse to just the right people.
Measured Opinions #2: Is the Session dead?
This week Dan and Dara debate the usefulness of the Google Analytics (GA/GA4) Session, and try to see if there is an alternative.
A shake-up at the top
As the Measurelab family expands and evolves, our team at the top has decided to switch up roles and use their talents where they fit best. You can't have growth without change, right?
Measured Opinions #1: Why should I care about GA4?
This week Dan and Dara chat about the three key reasons they think we should care about GA4 right now.
Data privacy in GA4: ensuring compliance & user trust
We all need to play our part in promoting a more responsible, ethical approach to collecting and using customer data. If we don’t, there’s a risk we’ll be left with nothing to measure.
Why migrate to GA4? Your data may not be as good as you think
Be warned: the risk of sticking with your current Google Analytics implementation may well be greater than any costs associated with the "migration" to GA4.
Data warehouse: Repair broken tables in BigQuery
At Measurelab, we love a bit of data warehousing using BigQuery; in fact, we are obsessed with finding the best approach to managing data warehouses in the most optimal way possible. So in this series, we want to share with you our knowledge and expertise to show what a fantastic and dynamic tool BigQuery is. As you may know, BigQuery has some super powerful features, which allow us to build, manipulate and even run machine learning algorithms within the interface. However, we’re all human, an
How data moves between Google Analytics 4, BigQuery and Data Studio
There's a surprising number of data feeds and transfers for Google Analytics 4, BigQuery, Data Studio and all its connected accounts and platforms. We set out to map them all to assist with your architecting.
Customer segmentation: how to get to know your customers better
In marketing, it’s vital to know your customers and how they interact with your brand. You need to know what they buy, when they buy, how often, how much... But why? Because if you know their habits and behaviours, you can tailor your marketing tactics and even personalise your customers’ journey. In doing so, you can maintain and even raise engagement between your customers and your brand. So how do we do this? Before thinking about any targeting strategies, you need to get to know your cus
Data warehousing: What is BigQuery and how do I get started?
At Measurelab we live and breathe the Google Cloud Platform, so our specialists are experts in Bigquery. We have decided in this series to share our knowledge and take you through some great techniques to maintain your BigQuery data warehouse. So firstly-what is BigQuery? BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. ...and that means? Simply put, BigQuery is a fantastic cloud-based data warehouse in which you can store huge
How recognising images works - when you're an algorithm
There are many different types of image recognition. The main aim of such practises is to correctly match a new picture to an existing group of pictures. In some instances it is not dissimilar to how a clustering algorithm works, in that common features are identified and grouped together (Moosmann et al., 2008). Although several methods of image recognition exist, this blog post will give an overview of the method of facial image recognition that has been patented by Tsai (2004). This inventio
30 sleeps ’til Christmas: our reflections on 2020
Reflecting on a challenging year What a year. I don't think I'm alone in wishing this particular year away and wanting to start Christmas ASAFP! 2020 has certainly thrown up a few challenges that we could never have predicted this time last year. The global pandemic has affected our lives collectively and individually on so many levels. Adapting to remote work For us at Measurelab we have all been working remotely now for just over 8 months. We were thrown into a situation that on one hand w
Google Analytics data import: automate data import with Python & Cloud functions
Why automate data import into Google Analytics A few months back I was granted access to a Google Cloud Source Repository (private Git repositories hosted on Google Cloud part of Google’s Cloud developer tools) that contained Python code and configuration details for automating the extraction of data from a BigQuery table and uploading to Google Analytics as a custom dimension via the Management API on a desired schedule. Choosing the right approach for blog word counts Being primarily a Jav
Google Analytics 4
The new future version of Google Analytics has been announced - now branded as Google Analytics 4. Building on the "App + Web" property that was released last year, this sets the direction for Google Analytics going forwards. It is now the default experiences for all new properties and is where all product developments will be focussed. Google Analytics 3, commonly known as Universal Analytics, was released in October 2012. This next product iteration for Google Analytics is a major step on fro
Three popular GTM server-side tagging misconceptions
With the recent release of server-side tagging for Google Tag Manager, a whole new woooooorld of possibilities has opened up. But on that, some people have got the wrong idea, so with that in mind, here's three popular (but wrong!) things people believe about server-side GTM. 1) You still need client-side GTM to make it work This is slightly unfair, as I can see why this misconception arose. You do need something to send your hits to the GTM server, and in many cases the easiest and best thin
Life as a new starter: remote edition
In the analytics industry, everyone I have had the opportunity to work with is so passionate about their role and always thrives on learning and sharing techniques. So when you're starting a new job at an analytics agency you know you'll have the opportunity to learn lots of new tricks and experiment with new types of datasets, which is very exciting. Excitement is one of the two feelings you experience when starting a new job. Then comes the unknown, the nerves - What if I'm not what they expe
We are going BIG on DATA
See what we did there? Okay, so maybe a tad too much on the title. It is catchy, so hey. Firstly - we are pretty chuffed to welcome Lace to our team. She joins us to spearhead our offering in all things DATA science and data engineering, which (to be completely frank) is where all roads point in this analytics game. With the advent of App plus Web (from Google Analytics), and particularly the opportunity to access raw data through BigQuery, this is an exciting place to be right now. Secondly -
Google Tag Manager form field tracking: capture pre-populated form changes
This is part 5 (and my first contribution, so bear with me) to this "semi-regular" series, dedicated to reusable GTM solutions for scenarios or issues we’ve encountered more than once. Last time, we looked at how to capture existing classic Google Analytics calls with GTM, and this time we'll be exploring how to track changes in pre-populated HTML form fields. Why I did it I was recently approached with a request from a client who wanted to know which fields were updated in a form that was pa
Emergency Analytics Support
It can be tricky judging how to pitch a new offer in times of crisis. There’s a fine line between being genuinely helpful and appearing exploitative. Sometimes you have to just jump in and try things, knowing they may be misinterpreted by the minority. In business, indecision can be crippling. While people’s lives are undoubtedly the most precious thing, livelihoods are worth saving too. A number of our clients - particularly those in the retail sector - have been hit hard by recent events.
Life moves pretty fast: navigating the remote work transition
Realising change was coming On Thursday, 12 March, advice about the coronavirus was still unclear. We did what we do best, we looked at the numbers. The modelling made it clear that, for the health of our team and community, we should move to remote work and begin social distancing. Adapting to remote work overnight It was a sudden change. Yet, being a digital (and people) business meant that this transition was a relatively easy one. We don't exactly have a factory to dismantle and move. Ou
Allowed to recommended: Week 1 – Remote work challenges in the UK
Last week the government's coronavirus advice moved from "contain" to "delay", and Measurelab moved from "allowing" to "recommending" that we work from home. As people left the office, one at a time, I couldn't help but feeling that I was saying goodbye to people for what would probably be quite a while. It's been a week since I've seen any of my colleagues in person and while we've been trying our best to continue to foster office camaraderie remotely, it's been a bit of a learning curve for al
Working From Home: An Alternative Blog Post
I wouldn't really consider myself a writer and to my knowledge I've only ever written one blog post in my entire lifetime (which was more like a sarcastic Dry January Facebook post). But when Adam said he was writing a blog post about their experience of Working From Home during this Covid-19 pandemic and was asking for input from others - it sort of turned into it's own blog post anyway, so here goes: Every day I wake up and I'm full of energy. In fact, I find myself with enough extra energy
Google Tag Manager setup: how to create your first tag
Creating your first GTM tag This is the third of a series dedicated to introducing you, faithful reader, to the wonders and delights of Google Tag Manager. Last time, we took a high-level look at GTM and how it works, and today we'll be looking at how to set up a simple tag. Setting up a Google Analytics pageview tag We're going to set up a Google Analytics pageview tag. This replaces the old hardcoded GA that you'd used to have to put on every page of the site. We start by going to tags and
Audience activation in 5 simple steps
Amidst news of cookies crumbling and third party cookies eventually becoming obsolete, there is even more emphasis on identifying visitors who arrive on websites and providing users with a reason to remain loyal to your brand. Here is a simple user case on how to effectively personalise your customer experience using the Google Marketing Platform. According to Econsultancy: “50% of consumers are likely to engage with a brand when they receive an interesting offer.” So how can you demonstrate
Capturing existing classic GA calls with GTM – Solutions Corner #4
This is part 4 of a semi-regular series, dedicated to reusable GTM solutions for scenarios or issues we’ve encountered more than once. The challenge with pre-GTM classic calls Last time, we looked at how to turn on-page classic Google Analytics calls to data layer pushes, and this time we'll be looking at a supplement to that—what if the classic GA call you're looking to capture is before GTM loads? This pretty much only matters for ecommerce, so that's what the solution focuses on. We start
Google Tag Manager basics: a closer look at GTM’s core concepts
Exploring GTM core concepts This is the second of a series dedicated to introducing you, faithful reader, to the wonders and delights of Google Tag Manager. Last time, we were looking at just what a tag manager is anyway? This time, we'll be taking a look at GTM itself. We're going to go through the three key components of GTM: tags, triggers and variables. We're not going to touch on the other things in the GTM sidebar, folders and templates, for the time being—they're useful extensions but n
Google Tag Manager Basics #1 - What Is A Tag Manager?
This is the first of a new series dedicated to introducing the uninitiated to the wonders and delights of Google Tag Manager. Before we start thinking too closely about GTM itself, though, we'll pull back a bit and ask: What is a tag manager? A tag manager is a service that allows you to remotely insert and manage small pieces of code, or “tags”, onto a site by means of a Javascript snippet placed across the whole site. There are a number of different tag managers out there—Tealium, Ensighte
Turning classic GA calls into dataLayer pushes with GTM
This is part 3 of a semi-regular series, dedicated to reusable GTM solutions for scenarios or issues we’ve encountered more than once. Last time we looked at how to track clicks on iframes using GTM, and this time we’re looking at how to turn on-page classic Google Analytics calls to data layer pushes. The problem with hard-coded GA calls Say you still have hard-coded calls to classic GA on the page, but the library code itself was being delivered via GTM. It's now been removed, but there are
A day in the shoes of an Insight manager: Andrew Fowkes at EDF
For our regular "A Day In The Shoes" feature, Andy - Senior Research Executive at EDF - talks about delivering a fresh insights perspective and tells us about the skills he needs to be effective in his role. Here’s what his day-to-day looks like. Aimée: Can you start by telling me your job title and responsibilities Andy: I manage Customer Insight projects of all types at EDF . My view is that the role of an insight manager in a big organisation has changed massively. It’s moved away from jus
How to Conduct an Exceptional Training Session
So… you’ve been asked to conduct a training session and you don’t know where to start. Or, you’re looking for a way to take your current training process to the next level. Whatever your level of experience, the following tips will help you make your next training session exceptional. 1. Know the subject The first step in giving an exceptional training session is being deeply familiar with the subject matter. In the words of Albert Einstein: You may think you know a subject through and throu
Team weekend outing: Measurelab’s Dorset adventure
Measurelab hits the Dorset coast for a team weekend Last Friday we all put our "out of office" notifications on our email, ditched the computers and headed off to Bournemouth and the beautiful Dorset coast for a couple of days. It was time to reflect on how the company is evolving and a chance for us all to get to know each other a little bit better. Reflecting on our journey together It was really lovely for us to all be able to get around the same table and share our thoughts. Throughout t
A day in the shoes of a Senior Analyst: Will Deschene at EDF
Our first launch into a ‘day in the shoes’ series is spent with Will Deschene, Senior Digital Analyst at EDF. In this interview, he tells us about managing stakeholders and a team, brands that have inspired him lately, and shares some valuable advice for new analysts. Aimée: Please describe your job: what do you do? Will: The majority of my work is stakeholder management, less of the 'doing' in the analytics world, as I now have two analysts in the team. It's more about stakeholder engagement
Product affinity analysis: discovering what items customers buy together
Understanding what customers buy together Being able to answer the question ‘which of my products do people regularly buy together’ with ease and simplicity can be invaluable. Market Basket Analysis, also known as association analysis, is a way of mining shopping data to establish a set of rules that describe purchasing patterns. This analysis can be conducted using a wide variety of software such as SAS, Python and R. Why association rules matter The reason for investigating association is
Three Small Recent GA/GTM Improvements
Google are always making small unannounced tweaks and improvements to their products—here are a few of the more noteworthy ones we've spotted recently! Scroll Depth Tracking I gave out at length last year about the fact that you can't specify the trigger conditions for the listener dropping on the scroll depth trigger—meaning the page length couldn't be calculated accurately and causing scroll depth events to fire early. I suggested that they might want to let you select the listener conditio
Expanding on optimisation: effective strategies for digital success
Recently I ran a workshop with a leading International luxury fashion retailer. The purpose was to structure thoughts between disparate teams around purpose and definition of an optimisation workstream. Initially we talked about short term imminent goals, with the festive season fast approaching these were not surprisingly highly tactical and focused around maximising peak performance. Setting the scene At this stage I introduced more broader notions around decoupling the shopping journey or
How to use BigQuery without GA360: insights from Measurefest 2019
Speaking at Measurefest For the first time in a few years, I took to the stage at Measurefest to talk about how to get your data from Google Analytics into BigQuery, and what you can do with it when you get there. Affordable BigQuery solutions Obviously, Analytics 360 can do this, but it costs $$$ per year. I outlined some more affordable methods, including third-party connector solutions, and provided a detailed example of how we would use our own Pipelines solution and what we could achiev
Next‑Generation measurement with Google Analytics 4
Why GA4 has us excited This announcement has us rather excited at Measurelab. It has been a long time coming and represents the beginning of a completely new shift in how we use and think about digital measurement with Google Analytics. Leaving the old pageview model behind What we are effectively looking at here is a move away from Google Analytics as we know it, which inherited its underlying data collection schema and methods from Urchin Analytics; the analytics software product Google bo
GTM iframe tracking – Solutions Corner #2
This is part 2 of a semi-regular series, dedicated to reusable GTM solutions for scenarios or issues we've encountered more than once. Last time we looked at how to fire Google Analytics event to keep track of your Google Optimize experiments in GA, and this time we're looking at tracking clicks on iframes. We have encountered, several times, the situation of a client wanting to track clicks on an iframe. While we can't do much about interactions with stuff within the iframe without having GTM a
Google Analytics Enhanced Ecommerce tracking with Adobe DTM
Here at Measurelab, we work predominantly with the Google stack but that doesn't stop us using other tools. As there's not much documentation available in the public forum on how to implement Enhanced Ecommerce in Google Analytics using Adobe Dynamic Tag Manager (DTM) formerly know as Satellite, I think this blog post would be useful. As good introduction to the tools itself, below there’s a useful overview of Adobe’s Dynamic Tag Management architecture, which is from their learning resource pa
It's nearly the end of term
As we countdown the last few days to the Christmas break, I wanted to share a few moments from what's been a busy and fun-packed couple of weeks at Measurelab. Besides all the great work everyone has been doing (which is de rigeur, of course), there's been much going on. First up to report is our little Christmas outing to Brighton; we went ice-skating at the beautifully picturesque outdoor ice rink at Brighton Pavilion. Some of us were a little more proficient than others (ahem). Gladly no bon
What is a Data Strategy and do I need one?
Let’s assume you’ve been using Google Analytics in your organisation for some time and your digital marketing endeavours at least are data-driven. More and more people are starting to see the benefit in using data to get their jobs done and now everyone’s talking about Data Science or Big Data or whatever. To be clear - when we say “data” we are not talking about just Google Analytics but the proliferation of this tool means that it is very likely a starting point for your data analytics. Alongs
Overcoming the limitations of Google Analytics
Google Analytics and Google Tag Manager are used by around 30 to 50 million companies worldwide. The tools are great for basic web analytics but restrict the user to aggregated data unless a substantial fee is paid (reported to be £90K per annum). This presents a large obstacle for small to medium sized businesses who want to develop a data-driven strategy. Let’s imagine a small retailer wants to implement a recommendation engine. Not a bad idea given that Amazon estimates that around 35% of sal
Knead that CRO dough into shape, ‘tis the season for the perfect prove
Whether you’re starting on your CRO journey or have been at it for years, chances are you’re after opportunities to give your bottom line a boost during the festive season. Taking some time to plan and carefully curate those optimisation journeys will not only go some way to making sure the additional traffic works better for you, it’ll result in a meaningful set of results and maximise learnings for the post-Christmas wash ups. Having worked 5 years for a well-known UK health and beauty re
Toot toot... All aboard the Measurelab train!
In the last couple of months we've had three new starters and I'd like to give them a little nod of recognition, if I may. First up is (Doctor) Dave, who joined us as a Data Scientist in the Summer; he popped along to one of our Brighton Analytics meetups and it just went from there. Dave's background is in terribly clever machine vision stuff - he was recently working in Barcelona (at Universitat Pompeu Fabra) doing Postdoctoral Research involving adaptive image processing algorithms (wher
GTM event tracking best practices – Solutions Corner #1
This is part 1 of what I hope will become a semi-frequent series on here, dedicated to reusable GTM solutions for scenarios or issues we've encountered more than once. This particular entry is a companion to Mark's piece from a couple of years back, but for Google Optimize rather that Optimizely. In short, it sends data layer pushes so you can fire Google Analytics events when there are Optimize experiments running, which saves you from using custom dimension slots etc in the course of ordinary
Goodbye DoubleClick, hello Google Marketing Platform!
Last week, Google announced they were unifying their analytics and advertising platforms under a single new name: Google Marketing Platform. The Google Analytics 360 Suite and DoubleClick brands are being replaced with this single name. What does this mean for DoubleClick? If anything this is a change that has needed to happen for years. DoubleClick always sat rather clumsily alongside other tools from Google and this shift heralds the beginning of a more unified approach. Search Ads 360 wil
Chat about analytics and drink beer
Last night's #BrightonAnalytics <a href="https://www.meetup.com/BrightonAnalytics-Meetup/events/251264167/">meetup</a> was a great success - thanks to all who made it along to the Evening Star pub to chat about analytics and drink beer! The next one will be Tuesday July 17th - again at 6pm-9pm in the Evening Star, Brighton. See you there! [ngg_images source="galleries" container_ids="1" display_type="photocrati-nextgen_basic_thumbnails" override_thumbnail_settings="1" thumbnail_width
Adding Firebase Analytics to your React Native app
<span style="font-weight: 400;">This article describes how to integrate Google Analytics for Firebase (formerly Firebase Analytics) to a React Native app. </span><span style="font-weight: 400;">In order to do this, you need to use a JavaScript bridge called </span><a href="https://github.com/invertase/react-native-firebase"><span style="font-weight: 400;">RNFirebase</span></a><span style="font-weight: 400;">. </span> This is lightweight layer sitting on top of native Firebase librarie
Firebase Analytics demystified
<span style="font-weight: 400;">After a steep learning curve into the world of Firebase Analytics or Google Analytics for Firebase, it seems that a blog post about it would be much valued and appreciated. I’ve compiled a list of the most frequently asked questions.</span> 1. How does Firebase Analytics define a session? Firebase Analytics defines a session as a user engaging with your app for a minimum amount of time (10 seconds by default) followed by your user not engaging with your app
The Problem With Google Tag Manager Triggers: Those Shiny New Built-In Options (And a Possible Solution)
Hey folks. The shiny new Built-In Triggers for things we used to have to use big old Custom HTML tags to track before—Youtube tracking! Scroll depth! Element visibility!—have had a bit of time to bed in now. We had a look at changing over to the new built-in solutions everywhere we were using Custom HTML—if it's being done by Tag Manager itself, it has to be better, right? Right? Wrong. This issue is related to a fact that I've discovered through experience but not seen actually documented exc
Measurelab turns 4: celebrating our anniversary & journey
Our fourth birthday in Paris Measurelab turned 4 in September and to celebrate we all shut our laptops (except Mark, who got very excited about the organisations announcement from Google) and took the Eurostar to Paris for some well deserved and much needed rest, relaxation and culture. First taste of Parisian adventure The trip was unofficially sponsored by Heineken (no craft ales or even Harvey’s best for sale on Eurostar unfortunately) and we toasted the start of our trip in style with pe
Activist analytics: using digital analytics to drive change
Hey folks, Adam here. I had quite a busy weekend last week - one that has now been documented in the national press! - and thought I'd share some thoughts about it on here. My journey into activist analytics I've been a member of the Labour Party and the related grassroots movement Momentum for several years now, but beyond a bit of leafleting here and there social anxiety has kept me away from the phonebanking, street stands and doorknocking that lie at the heart of party political activity.
Data Studio new countries availability
<span style="font-weight: 400;">The time has come for more of you to enjoy the benefits of Data Studio reports! Today, Google has announced long-awaited expansion of its product availability to more than 180 countries. </span> More and more people will now be able to enjoy the benefits of this powerful tool - you can now create, share and edit reports, and impress your boss and clients with your skilful dashboard creation skills. But that's not all! With that great news come other useful f
Free Google Analytics Health Check Template by Measurelab
Hey Folks, It's been a while since the last time I wrote anything on the blog so I thought I'd make it up to you with a little freebie. Why GA health checks are important One of the most common tasks at Measurelab (and I'm sure in many other analytics agencies) is to run a "health check" of the main features and configurations of the Google Analytics user interface. How the template works This varies in depth and level of detail depending on various factors but we do find it quite helpful
Google Data Studio: just getting better & better
We have some great news for all those of you who live and breathe Data Studio! Google has just announced two big changes to the tool: 1. The 5 report limit for the free version has been removed 2. What is even more exciting, Data Studio is now free for both basic and 360 (enterprise) version users! Up till now, the only real downside of the free version of the tool, was its limitation in the number of reports you could create per account. So if you are a free version user, you won’t be reall
Google Data Studio tips: tricks and best practices
Getting started with Google Data Studio Since its release back in May 2016, Data Studio (a free version of Data Studio 360) has made quite a lot of progress on improving its functionality. Of course, it is still in beta, so you might come across some system bugs and limitations, but the Google team is working hard to add new features and fix any issues the user may face, with at least two new releases per month (so far). I won't go into details as what you can do with the tool, as you can chec
When GA just isn't enough - my #measurefest talk
<span style="font-weight: 400;">I spoke at <a href="http://www.measurefest.com/" target="_blank" rel="noopener noreferrer">#Measurefest</a> in the Barbican last Friday. Here are the slides from my talk but I wanted to write a quick summary to give a bit more context as the slides on their own don’t tell the story. </span> When GA just isn't enough from darafitzgerald The title of the talk was "When GA just isn't enough". For some that know me this might sound like an unexpected title. I sp
How to integrate Optimizely with GTM & Universal Analytics
If you want to integrate your Optimizely experiment and variation data with Google’s Universal Analytics via Google Tag Manager, you will soon see that the official documentation assumes a custom‑coded implementation. It then instructs you to edit your GA pageview tag directly. If you are using Google Tag Manager, then you obviously will not want to follow this guidance as you probably have the Google Analytics pageview tag in a tag template. It is always advisable to keep custom JavaScript an
Understanding GA non-interactive events: month 1 insights
Starting a new adventure in analytics When I first decided to quit my ohh-so-lucrative job in the investment banking, most of my friends and family thought I was going bonkers! Neither were they impressed with my idea to start a new career in Web Analytics, working for some small start-up based in Lewes (wait why exactly do you want to work in Loos?!?). I must say that I had my doubts as well - will I be able to adapt to a totally new working environment? Will I ever learn what all the cookies,
Bounce rate vs. Exit rate part one
<span style="font-weight: 400;">Many companies consider a high bounce rate an issue that needs to be addressed quickly. Others support a high bounce rate. The truth is that most people don’t understand what “bounce rate” really means.</span> So what is a Bounce rate? According to Google: Bounce Rate is the percentage of single-page sessions (i.e. sessions in which the person left your site from the entrance page without interacting with the page). A better definition would be: Bounce Ra
GTM workspaces: how to manage multiple workspaces in Google Tag Manager
Exciting news in the world of analytics! Recently, Google has launched a new feature called Workspaces for both GTM and GTM 360 users. The goal of this new feature is to solve workflow challenges for multi-user teams working within the same container. Workspaces allow you to make changes in a specific instance of GTM, while others can work in a separate instance of the same container. Basically, when a Workspace is created, a new Container Draft is separated from the latest GTM container versi
Learn With Measurelab beta launch!
Measurelab already offers some of the <a href="https://www.measurelab.co.uk/training/">best in-person training around</a>, with monthly courses on <a href="https://www.measurelab.co.uk/training/google-tag-manager-training/">Google Tag Manager</a> and <a href="https://www.measurelab.co.uk/training/google-analytics-training/">Google Analytics</a> in London and <a href="https://www.measurelab.co.uk/training/google-analytics-training/">custom in-house training available on request</a>, but w
The Measurelab Year of Self Betterment
As Measurelab, we have been running bi-monthly Google Analytics and Google Tag Manager training sessions up in London for nearly 18 months now. We like to keep the groups small enough (under 10) to be personable and really help each attendee out with their questions and unique requirements. Due to the success of these training events, we are now running them every month (see all the dates for <a href="https://www.measurelab.co.uktraining/google-analytics-training/">GA Training</a>&n
Data Visualisation with Power BI
Since the recent(ish) announcement of <a href="https://www.google.co.uk/analytics/360-suite/data-studio/" target="_blank" rel="noopener noreferrer">Google Data Studio 360</a> (Google's answer to Tableau), we wanted to see where Data Studio 360 will fit into the mix by trying to compare what little we currently know about it with other data visualisation tools that are already on the market. Fast forward a few weeks, and to cut a long story short, Microsoft Power BI
Core Reporting API v4
<p class="p1">“<a href="https://developers.google.com/analytics/devguides/reporting/core/v4/changelog#header">Core Reporting API update</a>” doesn’t sound like the most exciting thing in the world, but trust me: it is. Well, maybe not <i>the</i> most exciting thing, but certainly getting on that way. So what’s new?</p> * Metric Expressions Are you sick of having to do post-processing on metrics in a separate sheet before you pipe them to your presentation layer? Well, guess what – you can
Google Analytics 360 Suite: what it is & why it matters
So it's finally happened, Google has brought their enterprise-level analytics offerings together in one neat package: the Google Analytics 360 Suite! What they have done is re-branded Google Analytics Premium as Google Analytics 360 and Adometry as Google Attribution 360, and released 4 all new tools. What’s included in the suite: Google Audience Center 360 (beta) A data management platform (DMP) that helps understand and identify customers across channels, devices, campaigns, etc. Google
Cafe Analytique... 2
<img class="wp-image-3615 size-medium alignleft" src="https://measurelab.ghost.io/content/images/2025/07/skandinaviska_konstnarernas_frukost_i_cafe_ledoyen_-_fernissningsdagen_1886-300x300.jpg" alt="Skandinaviska_konstnärernas_frukost_i_Café_Ledoyen_-_Fernissningsdagen_1886" width="300" height="300"> After the rousing success of the first Cafe Analytique back in November, we thought we'd have another one on Wednesday the 16th of March from 6pm, and immediately make the name redundant by h
When GA isn’t enough: beyond Google Analytics & better analytics tools
My Measurefest talk After a few nerve-wracking weeks of preparation, I did my talk about Google Analytics, the API and R yesterday afternoon at Measurefest in Brighton. I must admit, the whole thing is a bit of a blur, but I've been assured by several people (not just my friends!) that it went well, so I'll take their word for it. I was even approached by people afterwards and asked questions! (and if you were one of those people: apologies, I didn't quite get back to normal for several hours,
We are Google Tag Manager Certified!
Measurelab is officially Google Tag Manager certified We are proud to announce that, following a rigorous testing process, Google have approved Measurelab to be certified partners for Google Tag Manager – re-affirming our position as one of the UK’s top Google Analytics consultancies, specifically when it comes to using Google Tag Manager. Why this certification matters As well as demonstrable advanced technical skills with Google Tag Manager implementations, a pre-requisite of the certifica
Google Tag Manager training course now available from Measurelab
Google Tag Manager training is now live Right, folks, it’s happening! Our new Google Tag Manager training workshops are now live and ready to be booked! Thank you! Thank you! It has taken a bit of thinking and planning but we’ve finally decided to go ahead with it and we’re pretty pleased with the end results. What the workshop covers We’ll take you from the very basics - what’s a tag management system and how it works - to the more techy stuff such as how to deploy different vendors and c
Top 5 GTMv2 Features
If you’re anything like me, you saw the GTM v2 update coming with an impending sense of dread. You thought “oh no, another interface that I’m going to have to get familiar with” or “oh no, a slightly different system that’ll have slightly different quirks and tics and I’ll have to spend months relearning how to use it properly, argh (╯°□°)╯︵ ┻━┻”. Back in June when everything got auto-updated, I sent an email to one of our clients apologising for the change. But guess what? As with pretty muc
fun with balance balls
<iframe src="https://vine.co/v/enV3IZqxQ1a/embed/simple" width="600" height="600" frameborder="0"></iframe> Brightlocal, the company with whom we share an office, are very keen on balance balls. This has now spread to us, with Juan and Dara both abandoning their chairs for them (Mark and I both tried and decided against). Balance balls, though, are by nature quite bouncy. This leads to a lot of... the kind of thing in the vine above.
Extract conference highlights: key takeaways & insights
Heading to extract conference It was a bit miserable last Friday morning; the kind of day when you don’t want to get out of bed. Not only did I get up, I got up early, as bringing me from Brighton, downcast under slate-grey skies, to London, land of steel and glass, and in particular the dull purple glow of the trendy The Brewery’s rave-lit interior, was Extract, a conference by web data company import.io, billed as “data stories worth sharing”. First impressions of The Brewery The Br
Dara Fitzgerald: international analytics conference speaker
Dara at ADWorld experience Last week Dara was speaking at ADWorld Experience, in Bologna, about Enhanced Ecommerce in Google Analytics. On his return, Dara rather sheepishly let slip that he was awarded "Most Voted Speech" for the event. Well done, Dara! @measurelab @darafitzgerald demonstrating the wonders of enhanced ecommerce analytics #adwexp pic.twitter.com/NmwydFPqmV — Alan Coleman (@AlanCWolfgang) April 17, 2015 If you would like to book the internationally acclaimed Dara Fitzgerald
R for analytics beginners: part 4 – building graphs and analysing data
Earlier in this series we reviewed several R libraries for Google Analytics. Then we started using RGA. Next we pulled data from Google Analytics using RGA. What now? I’m reaching for my university notes, because we’re getting into proper R territory. Diving into graphs with R Let’s start with graphs! Who doesn’t love a good graph? It just so happens there’s a lovely R library called ggplot2 that does really excellent graphs of all shapes and sizes1. We’re probably best looking at a few speci
R For Analytics: A Beginner’s Guide, Part 3
<strong>IMPORTANT: THE PACKAGE HAS BEEN UPDATED BUT ADAM HASN'T HAD TIME TO UPDATE THIS YET! PROCEED AT YOUR PERIL!</strong> Last time, we had a look at how we could use RGA to pull in account details and suchlike. It’s not essential, but I’d suggest you go back and read through it, as it might make some of what we do next a little easier – and, of course, if you haven’t done so already, read the first piece too and follow the instructions enumerated therein to allow you to do, well, any of
R for analytics beginners: part 2 – authorizing GA access
In Part 1 of this series, I discussed R briefly and explained why it might be useful for people doing analytics work. I also introduced the libraries that allow you to interface R with Google Analytics. At this point, you should have R and RStudio installed on your computer, along with the RGA package. If you have not done this yet, please return to Part 1 and complete these steps first. Next, we need to authorise the package to access our GA data. You have to go to the Google Developers Consol
R for analytics beginners: part 1 – getting started
Two years ago, or thereabouts: I was introduced in my statistics lectures to a programming language and software environment called R. I took to it immediately, preferring it by far to the simpler software we’d used before, and also to the proprietary software (SAS, SPSS) we used in addition. Flash forward to: A couple of months ago, sitting in the audience for the talks at MeasureFest, and then we had what was, I think, by broad agreement, the best talk by Ela Osterberger, about using R with
Google Analytics training 2015 – master your analytics skills
Join our Google Analytics training If you have ever attended one of Dara's talks or workshops, you know the allure of his beard and Irish accent. Now you can spend a full day learning from Dara (aka “Data”, yes, that name’s courtesy of predictive text). Register now for one of our Google Analytics Training days in Covent Garden, London. Google Analytics training course dates - 2015 (until June) Description Date Time Location Price Book online Standard Google Analytics Training Course
GAIQ: How I prepared...and passed it!
It’s been exactly a month since I started to work at Measurelab, and so far it has been an amazing experience. Much of the industry jargon and tools are starting to sound familiar and I can make tea or coffee for almost anyone in the team without having to ask how they take it. In order to celebrate the fact that I had survived for a whole month, Mark suggested me to have a go at the Google Analytics Individual Qualification, (which I did..and passed!) For those of you that are not familia
Google Analytics health check: Part 2: third week guide
Continuing the GA health check Last week, I covered the first few steps of our Google Analytics Health Check, as one of the first, and most important steps when putting together a measurement plan. To recap a bit, the main aim of a Health Check is to ensure that we are collecting the right information, filtering out any undesired data, to allow us to create actionable reports for the stakeholders that, at the same time, help them to make informed business decisions. Checking goals and funnels
Google Analytics health check – Part 1: second week guide
Diving into GA health checks Right, now that some of the basic concepts and industry jargon are starting to sound a bit more familiar, things are starting to get interesting – not that last week was boring but this week I’ve been having a go at one of the most important parts of a piece of “initial discovery” for a client: A Google Analytics Health Check. Our approach to health checks In this document, which the team creates for every single one of our clients, we run a detailed audit of the
Floods, Scroll Depth, Bonfire and lots of coffee: My first week at Measurelab
<p class="p1"><span class="s1">It’s been, without a doubt, an unusual first week. Upon arrival to the mind-blowing <a href="https://www.measurelab.co.ukcontact/"><span class="s2">Old Candlemakers</span></a> building in central Lewes, I walked into the office to see the team running up and down trying to clean up the mess: one of the roof windows was left open during the weekend and we ended up with a meeting room that looked more like a fish pond than a place to catch-up or meet clients. Fort
GTM’s new interface: public‑beta update, API & feature changes
Things move fast in the digital world. Even more so when the might of Google is behind a product. Even so, a complete overhaul of the Google Tag Manager interface is quite a leap - considering how accustomed we have become to seeing incremental changes in product development. This morning I was using Google Tag Manager as usual, this afternoon I noticed that an import/export feature had become available. That was great news in itself, as it opens up all sorts of possibilities - for example, link
How to use the Google Analytics Embed API: guide & examples
When I started at Measurelab, way back in July, one of the items on my List Of Things To Do was to look into new and exciting ways of visualising data for clients. A few weeks ago I spent some time experimenting with dc.js but then, Mark and Dara went to MeasureCamp in London (I was going to go but I had other commitments) and came back bearing glad tidings of great joy for all analytics consultants, because unto Google, in the town of Mountain View, was born an API, and the angel Justin C
Enhanced Ecommerce & Data Import - #BrightonSEO slides
On Friday the Measurelab team attended <a href="http://www.brightonseo.com/">BrightonSEO</a> and I did a talk on two exciting features of GA: Enhanced Ecommerce and Data Import. Here is the deck for those who are interested, as well as the Twitter feed that followed the talk. Enhanced Ecommerce & Data Import for GA - #BrightonSEO Sept 2014 from darafitzgerald The advanced Google Analytics training course was an eye opener and really helpful! thanks @darafitzgerald #BrightonSEO — Man
Key universal analytics insights: lessons for a GA transition
The conference bit of BrightonSEO is happening tomorrow, and for those who aren't going along we thought it might be nice to post the little piece I wrote for the newspapers they're distributing at the conference this year. If you are going, look out for us and say hi, and make sure to come along to Dara's talk in the afternoon! When Universal Analytics came out of beta earlier this year, many were overwhelmed by the plethora of new features. Not a day goes by without a client asking us "how do
Measurelab has moved!
Last Friday afternoon, instead of the usual <del datetime="2014-09-01T09:27:54+00:00">slacking off</del> hard work right up to the end of the day, Measurelab (and our good friends at <a href="http://www.brightlocal.com/">Brightlocal</a>) were emptying cupboards and bookshelves, taking the legs off desks and disposing of never-watered plants, in preparation to load all the gear into cars and bus it down the road to the new office! Measurelab Manor has served well for the first year of so
Adam's Analytics Adventure: Week 5
<figure class="kg-card kg-image-card kg-card-hascaption"><img src="http://measurelab2.wpengine.com/wp-content/uploads/2014-07-01-14.30.281-1024x768.jpg" class="kg-image" alt="View from the hill, 1 month ago." loading="lazy" width="1024" height="768"><figcaption>View from the castle, 1 month ago.</figcaption></figure> I started working for Measurelab a month ago today (has it really been that long?) and fortunately I'm still really enjoying myself. However, it's no longer the urgent exciteme
Adam's Analytics Adventure: Week 4
<figure class="kg-card kg-image-card kg-card-hascaption"><img src="http://measurelab2.wpengine.com/wp-content/uploads/2014-07-19-15.22.35-1024x768.jpg" class="kg-image" alt="Went for a wander around Lewes itself over the weekend. The images aren't super-relevant, but they're quite nice. This one is down near the Priory." loading="lazy" width="1024" height="768"><figcaption>Went for a wander around Lewes itself over the weekend. The images aren't super-relevant, but they're quite nice. This on
Adam's Analytics Adventure: Week 3
<h1 style="color: #141412;">New Laptop!</h1> New laptop finally arrived! It’s so shiny! aaaaaaaaaahhhhhh ahem. Bit shorter than usual this week, as the time I’d usually use for blogging has been spent installing/configuring the laptop which just arrived. On top of that, it's been a busy week, but not one in which the majority of my activities lend themselves to interesting anecdotes – I spent Monday just looking at spreadsheets. Fun for me, but not very interesting for you to read about
Adam's Analytics Adventure: Week 2
<em>Because of the way events transpired this week, I’m going to go through a few notable things rather than a day-by-day (because that would be boring) and give them all pithy-ish subheads, like I’m a newspaper columnist or something.</em> Coffee habit Now that I work in a hip web 2.0 dotcom startup dealie, I clearly need to develop a coffee habit. I had my first cup from the office Nespresso machine (nary a burr grinder in sight - a disgrace) this afternoon – a purple pod marked ‘Arpegg
Adam's Analytics Adventure: Week 1
<h1>Day One</h1> Upon alighting from the bus as I arrived for my first day of work, I found myself crossing the road next to a group with whom I immediately felt a degree of kinship – casually dressed (but not overly so), a scattering of black-plastic-rimmed glasses – the sort of people who, upon immediate visual inspection, you might peg as the employees of some kind of dotcom, web 2.0 startup. Such proved to be the case, in fact, as they all funneled into the shared office space where I w
How to set up Google Analytics Enhanced Ecommerce (5 easy steps)
If you are anything like me, you will have seen the fandangled new “enhanced” e-commerce reports that are starting to become available in Google Analytics accounts (N.B. - Universal web properties only) and thought “yes, I’ll have some of that”. The reports allow for much deeper analysis of shopping behaviour - to understand things like influence of product impressions on conversion - as well as providing much anticipated refund and voucher/ affiliate code support. In the spirit of catchy blog
Universal Analytics is out of Beta... So What Now? #brightonseo talk slides
Yesterday, at BrightonSEO, <a href="http://measurelab2.wpengine.com/blog/author/dara/">Dara</a> (our Analytics Director) gave a talk on the state of Universal Analytics now that it is out of beta. It was well received by all (see Twitter feed below). Here's the slides (on <a href="http://www.slideshare.net/darafitzgerald/universal-analytics-out-of-beta-brightonseo" target="_blank" rel="noopener noreferrer">Slideshare</a>) from the presentation in case you missed it or wanted to view them
Universal Analytics is out of Beta...BrightonSEO talk (coming up)
In line with the announcement on Wednesday that Universal Analytics is <a href="http://analytics.blogspot.co.uk/2014/04/universal-analytics-out-of-beta-into.html" target="_blank" rel="noopener noreferrer">coming out of Beta</a>, I changed my upcoming talk at <a href="http://www.brightonseo.com/agenda-2/" target="_blank" rel="noopener noreferrer">BrightonSEO</a> to focus entirely on this. When I spoke at events previously about Universal Analytics, there was still a lack of parity with Class
Import your Cost Data to GA with our new (Free!) Uploader
<blockquote>Please note that this app is no longer relevant as Google have provided their own cost uploader tool!</blockquote> GA has long since allowed you to import AdWords cost data with a few simple button clicks. However other cost data - Bing/Yahoo paid search activity, affiliate marketing, email, Facebook advertising, etc. - were not catered for until about 18 months ago when GA released the Cost Data Import tool in beta. This Cost Data Import tool, which feeds data into a new repor
#brightonanalytics
<blockquote class="twitter-tweet" lang="en">We're kicking off <a href="https://twitter.com/search?q=%23brightonanalytics&src=hash">#brightonanalytics</a> again - Thurs 3rd April from 6.30pm in the Evening Star. Pass it on all you <a href="https://twitter.com/search?q=%23measure&src=hash">#measure</a> types in <a href="https://twitter.com/search?q=%23brighton&src=hash">#brighton</a> — measurelab (@measurelab) March 25, 2014 More at Brighton Analytics
Creating an effective Measurement Plan
When helping clients with their analytics implementations, we often run Measurement Planning workshops - bringing together stakeholders to better understand their measurement requirements. This video (part of the excellent <a href="https://analyticsacademy.withgoogle.com/">Analytics Academy</a> series) demonstrates a typical measurement planning and implementation process - closely aligned to the <a href="http://measurelab2.wpengine.com/blog/analytics-planning-is-at-the-heart-of-a-truly-measu
Google Tag Manager auto-event tracking - useful Tags, Macros and Rules for Google Analytics events
The recent introduction of <a href="http://analytics.blogspot.co.uk/2013/10/no-code-required-auto-event-tracking.html" target="_blank" rel="noopener noreferrer">auto-event tracking</a> for <a href="http://www.google.com/tagmanager/" target="_blank" rel="noopener noreferrer">Google Tag Manager</a> was a welcome piece of news for many of us keen to remove custom jQuery from within the container. But it quickly became apparent that, to make real use of the auto-event tracking feature,
Analytics planning: the heart of a truly measurable digital strategy
Google Analytics is free and that’s a wonderful thing. But it does mean people can often undervalue the reports and the benefits that a truly structured approach to analytics brings to a business. Sadly, more often than not, a developer or webmaster adds the default Google Analytics tracking code to a website and leaves it at that. Trawling through the reports to find any kind of insight is left up to an analyst or marketing executive – who, later, attempts to find some kind of meaning in this
Cart Abandonment Segments - GA Screencast
The new segment builder in GA (available to all users now!) offers one major improvement to the previous Advanced Segments feature. It was previously possible to segment based on visit data only, which made cross-session segmentation and analysis impossible by default. The new segment builder allows conditions and sequences to be defined based on both visit and user data. This takes segmentation in GA from being an underused and limited feature to being a swiss army knife for intelligent
Migrate jQuery event listeners to GTM auto‑event listeners: a better way
Tag Containers are great. In a former life I was developer and I can really appreciate how much help they can be to people wanting to just add a "bit of code" to a website. But, as said former developer, I can also appreciate what a potential disaster it is to give the marketing guys the ability to add code to a website - outside of your carefully considered source control mechanisms and deployment routines. So - the recent announcement (there's quite a few on that link) from the team at Google
GA Summit 2013: Key Google Analytics updates & insights
The theme of this years summit is a focus on helping customers in three areas: Access, Empower, Act. The slide above was shown by the GA team to summarise the 3 part theme. Babak Pahlavan (Director of Product Management, Google Analytics) let the crowd know that GA have made 70+ releases in 2013 so far, which makes sense on reflection given how busy the year has been. This has included major updates such as the global roll out of Universal Analytics, the introduction of the Attribution Modellin

