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.

\ \ Podcast - Latest #142 Google's agentic era: Next '26 and I/O '26 unpacked \ \ Dara and Matthew unpack Google Cloud Next '26 and I/O '26: the Gemini Enterprise Agent Platform, Gemini 3.5 Flash, Omni, Antigravity 2.0 and generative AI search. Plus a breaking-news bulletin on Anthropic's new Fable model, and why agents are the headline but governance is the subplot.\ \ Dara Fitzgerald-12 Jun 2026](/content/insights/podcast/google-agentic-era-next-26-and-i-o-26-unpacked/index.html)

\ Podcast #141 Introducing SEAM: Siloed Data, Central Intelligence \ Dara Fitzgerald-26 May 2026](/content/insights/podcast/introducing-seam-siloed-data-central-intelligence/index.html)\ Blog Whose stack is it anyway? \ Mark Rochefort-22 May 2026](/content/insights/blog/whose-stack-is-it-anyway/index.html)\ Video Webinar: We tried talking to our data - here’s what’s actually working (and what’s not) \ Will Hayes-30 Jan 2026](/content/insights/video/webinar-we-tried-talking-to-our-data/index.html)

Filter by topic

Google Analytics(273) BigQuery(177) Looker Studio(148) Data Analysis(134) SQL(133) Google Tag Manager(131) Privacy(130) AI & ML(122) Marketing(120) How-to(117)

Show more

Company news

\ \ Measurelab awarded Google Cloud Marketing Analytics Specialisation 11 Sept 2025](/content/insights/blog/measurelab-google-cloud-marketing-analytics-specialisation/index.html) \ \ Measurelab makes the IPA Beacon List 2025 14 Jun 2025](/content/insights/blog/measurelab-makes-the-ipa-beacon-list-2025/index.html)

\ \ #142 Google's agentic era: Next '26 and I/O '26 unpacked \ \ Dara and Matthew unpack Google Cloud Next '26 and I/O '26: the Gemini Enterprise Agent Platform, Gemini 3.5 Flash, Omni, Antigravity 2.0 and generative AI search. Plus a breaking-news bulletin on Anthropic's new Fable model, and why agents are the headline but governance is the subplot.\ \ Dara Fitzgerald-12 Jun 2026](/content/insights/podcast/google-agentic-era-next-26-and-i-o-26-unpacked/index.html)\ \ #141 Introducing SEAM: Siloed Data, Central Intelligence \ \ Dara and Matthew cover frontier model updates, Mythos, Google I/O, and AI design tools before officially introducing SEAM - Measurelab's semantic governance layer that sits between LLMs and data sources to deliver consistent, audited answers.\ \ Dara Fitzgerald-26 May 2026](/content/insights/podcast/introducing-seam-siloed-data-central-intelligence/index.html)\ \ Whose stack is it anyway? \ \ Google's running two in parallel - Marketing and Cloud. You'll likely still be using both for the next few years. So here's how to work with them and make them your own.\ \ Three Google announcement events recently - Cloud Next in April, I/O on May 19-20, Google Marketing Live on May 20. The Marketing Live keynote actually overlapped with the second day of I/O, which struck me as not accidental - Gemini is running under all of it. And, in doing so, rebuilding your measurement stack.\ \ What Google \ \ Mark Rochefort-22 May 2026](/content/insights/blog/whose-stack-is-it-anyway/index.html)\ \ #140 Taming BigQuery costs with Alvin.ai (with Martin Sahlen) \ \ Martin Sahlen, CEO of Alvin AI, joins the Measure Pod to discuss automating BigQuery cost optimisation through billing model arbitrage, with no AI in the engine.\ \ Dara Fitzgerald-2 May 2026](/content/insights/podcast/taming-bigquery-costs-alvin-martin-sahlen/index.html)\ \ Siloed data, central intelligence \ \ Someone in your organisation has already connected an AI agent to a live data source. Probably several people have. They've pointed Claude at HubSpot, asked it to pull numbers from Google Analytics, had it read a Jira board or reconcile figures across two systems. The data never moved. Nobody waited for a pipeline. Nobody asked the data team.\ \ They did this because it was easy. And people will always go where the friction is least.\ \ This is happening everywhere, across every function, in organis\ \ Matthew Hooson-9 Apr 2026](/content/insights/blog/siloed-data-central-intelligence/index.html)\ \ What we learned building AI agents for clients (and ourselves) \ \ From internal experiments to client-facing data products\ \ Eighteen months ago, we started building AI agents internally. Not as a product play - as a way to stop doing repetitive work. Documentation, QA checklists, data validation. The kind of tasks that every analytics consultancy does hundreds of times a year and nobody enjoys.\ \ That experiment became our first internal AI assistant. And what we learned building it changed how we think about data products for clients.\ \ Here's what we know now \ \ Mark Rochefort-8 Apr 2026](/content/insights/blog/what-we-learned-building-ai-agents-for-clients-and-ourselves/index.html)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\ \ Mark Rochefort-7 Apr 2026#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.\ \ Will Hayes-27 Mar 2026#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.\ \ Will Hayes-13 Mar 2026The 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. \ \ Matthew Hooson-10 Mar 2026Your 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.\ \ Steven Elliott-10 Mar 2026What 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\ \ Mark Rochefort-7 Mar 2026#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.\ \ Will Hayes-20 Feb 2026We'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.\ \ Steven Elliott-10 Feb 2026Clearing 2026: why UK universities need recruitment intelligence \ \ UK universities face a deficit crisis. Student Recruitment Intelligence can transform Clearing from chaos to precision.\ \ Steven Elliott-6 Feb 2026#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.\ \ Will Hayes-6 Feb 2026Webinar: 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.\ \ Will Hayes-30 Jan 2026The 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.\ \ Matthew Hooson-28 Jan 2026#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.\ \ Will Hayes-19 Dec 2025Unifying 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.\ \ Will Hayes-11 Dec 2025Ask 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.\ \ Matthew Hooson-28 Nov 2025#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.\ \ Will Hayes-28 Nov 2025Integrating 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.\ \ Nasima Khatun-27 Nov 2025#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.\ \ Will Hayes-13 Nov 2025#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.\ \ Will Hayes-30 Oct 2025#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.\ \ Will Hayes-17 Oct 2025#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.\ \ Will Hayes-3 Oct 2025#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.\ \ Will Hayes-19 Sept 2025Webinar: 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\ \ Will Hayes-12 Sept 2025Measurelab 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\ \ Will Hayes-11 Sept 2025#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.\ \ Will Hayes-5 Sept 2025BigQuery 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\ \ Katie Kaczmarek-3 Sept 2025GA4 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\ \ Steven Elliott-28 Aug 2025The 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.\ \ Will Hayes-27 Aug 2025#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.\ \ Will Hayes-22 Aug 2025#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.\ \ Will Hayes-8 Aug 2025#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.\ \ Will Hayes-25 Jul 2025How 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\ \ Katie Kaczmarek-14 Jul 2025#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.\ \ Will Hayes-11 Jul 2025Webinar: 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 \ \ Will Hayes-8 Jul 2025#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.\ \ Will Hayes-20 Jun 2025Measurelab 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. \ \ Steven Elliott-14 Jun 2025#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.\ \ Will Hayes-6 Jun 2025#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.\ \ Will Hayes-23 May 2025The 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.\ \ Will Hayes-7 May 2025#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.\ \ Will Hayes-2 May 2025Behind 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\ \ Matthew Hooson-24 Apr 2025Easy ways to prepare your BigQuery warehouse for AI \ \ You’ve probably heard that AI is coming to make our lives easier, especially in tools like BigQuery. But here’s the thing: AI isn't magic. If you want it to be accurate and useful, you need to set it up for success.\ \ One of the best ways to do that? Improve the metadata in your BigQuery warehouse.\ \ Metadata is like the index or contents page in a book, it quickly tells you exactly what’s inside and where to find it. Creating clear metadata means AI can more easily understand your data warehouse \ \ Katie Kaczmarek-23 Apr 2025Data 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\ \ Prasanna Venkatesan-22 Apr 2025#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.\ \ Will Hayes-18 Apr 2025The 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.\ \ Will Hayes-16 Apr 2025Dataform 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\ \ Prasanna Venkatesan-18 Mar 2025#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.\ \ Will Hayes-14 Mar 2025Behind the Cloud – Releases and scheduling in Dataform \ \ In this episode of Behind the Cloud, Matthew dives into the details of releases and scheduling in Dataform. He breaks down how to manage different versions of your codebase in GitHub. From taking snapshots, to scheduling executions at various intervals daily, hourly, or monthly.\ \ By the end of the episode, you’ll have the know-how to confidently release and schedule your code, making it easier to build robust tables and models with Dataform.\ \ Video transcript\ \ Introduction to releases and sche\ \ Matthew Hooson-7 Mar 2025#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.\ \ Will Hayes-28 Feb 2025How to extract GA4's event sequencing in BigQuery using the new batch fields \ \ Google Analytics 4 (GA4) exports event data to BigQuery, enabling detailed user behavior analysis. However, GA4 batches events before sending them, making GA4 event sequencing in BigQuery more complex. Fortunately, three fields—batch_event_index, batch_ordering_id, and batch_page_id—help provide precise sequencing information.\ \ For a full schema of the GA4 export, head over to google documentation.\ \ This article breaks down these fields in a clear, practical way and shows how to use them togethe\ \ Katie Kaczmarek-24 Feb 2025Automating BigQuery workflows with conditional logic and data readiness checks \ \ BigQuery offers powerful scripting capabilities that can simplify complex workflows. In this post, we’ll explore two essential techniques: using IF...THEN...END IF for procedural control and leveraging the metadata in project.dataset.__TABLES__ to ensure your Google Analytics 4 (GA4) data is ready before running queries. These strategies help you avoid unnecessary processing, reduce costs, and improve efficiency in your data pipelines.\ \ 1. Leveraging IF...THEN...END IF for procedural logic\ \ Whi\ \ Katie Kaczmarek-20 Feb 2025#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.\ \ Will Hayes-14 Feb 2025Mastering 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\ \ Prasanna Venkatesan-7 Feb 2025#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.\ \ Will Hayes-31 Jan 2025#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.\ \ Will Hayes-17 Jan 20252024: Measurelab's year in review \ \ Same same but different\ \ At the beginning of the year, I wasn't quite sure what Measurelab would look like by the end of 2024. Altman's assistants had just been unleashed. The robots were on the march. Would the analytics arena be conquered by AI? Would we all be replaced by intelligent agents?\ \ As it turns out, no. Things are pretty much the same - on the surface at least. And that's no bad thing. After the tumultuous ups and downs of a rollercoaster 2023, I'll take steady, deliberate progress \ \ Steven Elliott-27 Dec 2024#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.\ \ Will Hayes-13 Dec 2024#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.\ \ Will Hayes-29 Nov 2024A 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 \ \ Katie Kaczmarek-27 Nov 2024How 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\ \ Katie Kaczmarek-27 Nov 2024What is offline event data import in GA4? \ \ Offline event data import in Google Analytics 4 allows you to upload event data that was acquired outside of your website or app, such as in-store purchases, contact centre interactions, or CRM data. This can be critical for businesses seeking to bridge the gap between online and offline user actions, resulting in a more complete picture of customer behaviour.\ \ How to import offline event data into GA4\ \ You can upload event data into GA4 through a process called Data Import. This can be done ma\ \ Nasima Khatun-22 Nov 2024#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.\ \ Will Hayes-15 Nov 2024Behind 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\ \ Matthew Hooson-5 Nov 2024The 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.\ \ Matthew Hooson-29 Oct 2024#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.\ \ Will Hayes-25 Oct 2024You’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.\ \ Matthew Hooson-23 Oct 2024#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.\ \ Will Hayes-11 Oct 2024#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."\ \ Will Hayes-27 Sept 2024#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.\ \ Will Hayes-13 Sept 2024#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.\ \ Daniel Perry-Reed-30 Aug 2024#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.\ \ Will Hayes-16 Aug 2024Integrating 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\ \ Mark Rochefort-7 Aug 2024Behind 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\ \ Matthew Hooson-30 Jul 2024Firing 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.\ \ Steven Elliott-30 Jul 2024The 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\ \ Daniel Perry-Reed-19 Jul 2024#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. \ \ Will Hayes-19 Jul 2024Elevate 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?\ \ Hugo Jones-16 Jul 2024The 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\ \ Matthew Hooson-9 Jul 2024The 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.\ \ Daniel Perry-Reed-5 Jul 2024#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.\ \ Will Hayes-5 Jul 2024Behind 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\ \ Matthew Hooson-27 Jun 2024Measurelab'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.\ \ Hugo Jones-8 May 2024Behind 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 \ \ Matthew Hooson-4 Apr 2024Sound 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\ \ Will Hayes-3 Apr 2024Sound 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\ \ Will Hayes-27 Mar 2024Customer 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\ \ Matthew Hooson-14 Mar 2024Behind 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\ \ Matthew Hooson-14 Mar 2024Grand 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\ \ Steven Elliott-14 Mar 2024#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.\ \ Will Hayes-8 Mar 2024Sound 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\ \ Will Hayes-6 Mar 2024#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.\ \ Will Hayes-1 Mar 2024Behind 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 \ \ Matthew Hooson-26 Feb 2024#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.\ \ Will Hayes-23 Feb 2024Sound 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 \ \ Will Hayes-21 Feb 2024#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.\ \ Will Hayes-16 Feb 2024#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.\ \ Will Hayes-9 Feb 2024Behind 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\ \ Matthew Hooson-7 Feb 2024GA4 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\ \ Mark Rochefort-7 Feb 2024#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.\ \ Will Hayes-2 Feb 2024Sound 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\ \ Will Hayes-31 Jan 2024#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.\ \ Will Hayes-19 Jan 2024Sound 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\ \ Will Hayes-17 Jan 2024Behind 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\ \ Matthew Hooson-13 Jan 2024#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.\ \ Will Hayes-12 Jan 2024Sound 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\ \ Will Hayes-10 Jan 2024#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.\ \ Will Hayes-5 Jan 2024Sound 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\ \ Will Hayes-3 Jan 20242023: 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\ \ Steven Elliott-22 Dec 2023#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.\ \ Will Hayes-22 Dec 2023Sound 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\ \ Will Hayes-20 Dec 2023#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.\ \ Will Hayes-15 Dec 2023Sound 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\ \ Will Hayes-13 Dec 2023Measurelab 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.\ \ Steven Elliott-6 Dec 2023Sound 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\ \ Will Hayes-6 Dec 2023How 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.\ \ Mark Rochefort-1 Dec 2023Sound 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\ \ Will Hayes-29 Nov 2023Sound 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\ \ Will Hayes-22 Nov 2023Connecting 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.\ \ Matthew Hooson-20 Nov 2023What 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.\ \ George Mendham-6 Nov 2023How 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.\ \ Katie Kaczmarek-3 Nov 2023The 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.\ \ Matthew Hooson-2 Nov 2023GA4 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\ \ Mark Rochefort-1 Nov 2023Gathering 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:\ \ Will Hayes-25 Oct 2023#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.\ \ Daniel Perry-Reed-13 Oct 2023Core 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\ \ Mark Rochefort-9 Oct 2023#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.\ \ Daniel Perry-Reed-6 Oct 2023Call 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\ \ Mark Rochefort-5 Oct 2023BigQuery 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 \ \ Mark Rochefort-5 Oct 2023#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.\ \ Daniel Perry-Reed-29 Sept 2023#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.\ \ Daniel Perry-Reed-22 Sept 2023#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.\ \ Daniel Perry-Reed-15 Sept 2023GTM’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\ \ Nick Roberts-8 Sept 2023#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.\ \ Daniel Perry-Reed-8 Sept 2023#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.\ \ Daniel Perry-Reed-1 Sept 2023Customising 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\ \ George Mendham-29 Aug 2023#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). \ \ Daniel Perry-Reed-25 Aug 2023The 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 \ \ Matthew Hooson-24 Aug 2023Getting 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\ \ Natalia Rizzi-22 Aug 2023#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.\ \ Daniel Perry-Reed-18 Aug 2023#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.\ \ Daniel Perry-Reed-11 Aug 2023The 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\ \ Daniel Perry-Reed-3 Aug 2023How 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\ \ Olade Honvo-21 Jul 2023What 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?\ \ James Humphreys-20 Jul 2023Measuring 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\ \ Gary Moore-19 Jul 2023Backing 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.\ \ Matthew Hooson-6 Jul 2023#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.\ \ Daniel Perry-Reed-12 May 2023#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.\ \ Daniel Perry-Reed-5 May 2023#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.\ \ Daniel Perry-Reed-28 Apr 2023Why 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.\ \ Matthew Hooson-26 Apr 2023#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.\ \ Daniel Perry-Reed-21 Apr 2023How 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 \ \ Timothy Gorringe-17 Apr 2023#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. \ \ Daniel Perry-Reed-14 Apr 2023How 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\ \ Olade Honvo-11 Apr 2023#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. \ \ Daniel Perry-Reed-31 Mar 2023#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.\ \ Daniel Perry-Reed-24 Mar 2023#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.\ \ Daniel Perry-Reed-17 Mar 2023What 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?\ \ Nasima Khatun-16 Mar 2023#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.\ \ Daniel Perry-Reed-10 Mar 2023Using 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.\ \ George Mendham-6 Mar 2023#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.\ \ Daniel Perry-Reed-3 Mar 2023What 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\ \ James Humphreys-1 Mar 2023How 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.\ \ Daniel Perry-Reed-16 Feb 2023GA4 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?\ \ Daniel Perry-Reed-15 Feb 2023How 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.\ \ Daniel Perry-Reed-14 Feb 2023Understanding 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.\ \ Daniel Perry-Reed-14 Feb 2023#70 Building dashboards like a pro \ \ This week Dan and Dara talk about their experiences in building automated dashboards.\ \ Daniel Perry-Reed-10 Feb 2023#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.\ \ Daniel Perry-Reed-3 Feb 2023How 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!\ \ Timothy Gorringe-31 Jan 2023How 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.\ \ Magdalena Pajak-31 Jan 2023UPDATE: 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.\ \ Matthew Hooson-31 Jan 2023#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.\ \ Daniel Perry-Reed-27 Jan 2023#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.\ \ Daniel Perry-Reed-13 Jan 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.\ \ Daniel Perry-Reed-6 Jan 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.\ \ Daniel Perry-Reed-30 Dec 2022#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.\ \ Daniel Perry-Reed-23 Dec 20222022: 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.\ \ Dara Fitzgerald-20 Dec 2022#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.\ \ Daniel Perry-Reed-16 Dec 2022Why 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.\ \ Matthew Hooson-13 Dec 2022#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.\ \ Daniel Perry-Reed-9 Dec 2022#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. \ \ Daniel Perry-Reed-2 Dec 2022GA4'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.\ \ Dara Fitzgerald-1 Dec 2022Dream 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.\ \ Steven Elliott-30 Nov 2022What 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’.\ \ Matthew Hooson-22 Nov 2022#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.\ \ Daniel Perry-Reed-11 Nov 2022#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.\ \ Daniel Perry-Reed-4 Nov 2022#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.\ \ Daniel Perry-Reed-28 Oct 2022MeasureFest 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!\ \ Katie Kaczmarek-26 Oct 2022How 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.\ \ Katie Kaczmarek-26 Oct 2022#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. \ \ Daniel Perry-Reed-21 Oct 2022#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.\ \ Daniel Perry-Reed-14 Oct 2022#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.\ \ Daniel Perry-Reed-7 Oct 2022#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.\ \ Daniel Perry-Reed-30 Sept 2022#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.\ \ Daniel Perry-Reed-23 Sept 2022#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.\ \ Daniel Perry-Reed-16 Sept 2022#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.\ \ Daniel Perry-Reed-9 Sept 2022Change 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.\ \ Rajeev Gill-31 Aug 2022#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.\ \ Daniel Perry-Reed-19 Aug 2022Doom: 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!\ \ Victor Sarker-18 Aug 2022#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.\ \ Daniel Perry-Reed-12 Aug 2022How 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.\ \ George Mendham-10 Aug 2022#48 Cookies and consent in Google Analytics \ \ This week Dan and Dara chat about some new cookie settings released in Google Analytics 4.\ \ Daniel Perry-Reed-5 Aug 2022#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.\ \ Daniel Perry-Reed-29 Jul 2022Can 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?\ \ Dara Fitzgerald-26 Jul 2022#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.\ \ Daniel Perry-Reed-22 Jul 2022How 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.\ \ Matthew Hooson-20 Jul 2022How 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.\ \ Steven Elliott-18 Jul 2022#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.\ \ Daniel Perry-Reed-15 Jul 2022#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. \ \ Daniel Perry-Reed-8 Jul 2022#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. \ \ Daniel Perry-Reed-1 Jul 2022#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!\ \ Daniel Perry-Reed-24 Jun 2022MeasureCamp 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!\ \ Daniel Perry-Reed-17 Jun 2022#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.\ \ Daniel Perry-Reed-17 Jun 2022What 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.\ \ Daniel Perry-Reed-16 Jun 2022GA4 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.\ \ Daniel Perry-Reed-15 Jun 2022Measuring 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.\ \ Dara Fitzgerald-31 May 2022#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.\ \ Daniel Perry-Reed-27 May 2022#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.\ \ Daniel Perry-Reed-20 May 2022brightonSEO 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.\ \ Daniel Perry-Reed-17 May 2022#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.\ \ Daniel Perry-Reed-13 May 2022Calculating 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.\ \ Daniel Perry-Reed-9 May 2022Screen 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.\ \ Daniel Perry-Reed-6 May 2022#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. \ \ Daniel Perry-Reed-6 May 2022How 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.\ \ Daniel Perry-Reed-29 Apr 2022#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.\ \ Daniel Perry-Reed-29 Apr 2022Defining 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.\ \ Daniel Perry-Reed-28 Apr 2022#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.\ \ Daniel Perry-Reed-22 Apr 2022#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.\ \ Daniel Perry-Reed-15 Apr 2022#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.\ \ Daniel Perry-Reed-8 Apr 2022Running 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?\ \ Nick Roberts-29 Mar 2022#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.\ \ Daniel Perry-Reed-25 Mar 2022How 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\ \ Scott Hellmund-23 Mar 2022#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.\ \ Daniel Perry-Reed-18 Mar 2022The 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’\ \ Dara Fitzgerald-16 Mar 2022(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\ \ Daniel Perry-Reed-16 Mar 2022#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.\ \ Daniel Perry-Reed-11 Mar 2022GA4 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.\ \ Scott Hellmund-10 Mar 2022#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.\ \ Daniel Perry-Reed-4 Mar 2022#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.\ \ Daniel Perry-Reed-25 Feb 2022From 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?\ \ George Mendham-24 Feb 2022How 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.\ \ Natalia Rizzi-22 Feb 2022Google 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.\ \ Vanessa Fitarelli-18 Feb 2022#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.\ \ Daniel Perry-Reed-18 Feb 2022How 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.\ \ Dara Fitzgerald-15 Feb 2022#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.\ \ Daniel Perry-Reed-11 Feb 2022#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.\ \ Daniel Perry-Reed-4 Feb 20225 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.\ \ George Mendham-28 Jan 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.\ \ Daniel Perry-Reed-28 Jan 2022Keep 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.\ \ Daniel Perry-Reed-26 Jan 2022How 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.\ \ Steven Elliott-25 Jan 2022#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.\ \ Daniel Perry-Reed-21 Jan 2022#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.\ \ Daniel Perry-Reed-14 Jan 2022#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).\ \ Daniel Perry-Reed-7 Jan 2022The 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.\ \ Steven Elliott-20 Dec 20212021: 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.\ \ Dara Fitzgerald-17 Dec 2021How 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.\ \ Mark Rochefort-16 Dec 2021#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. \ \ Daniel Perry-Reed-10 Dec 2021#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. \ \ Daniel Perry-Reed-3 Dec 2021#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.\ \ Daniel Perry-Reed-26 Nov 202110 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.\ \ Lace Rogers-25 Nov 2021#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.\ \ Daniel Perry-Reed-19 Nov 2021#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. \ \ Daniel Perry-Reed-12 Nov 2021How 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.\ \ Victor Sarker-10 Nov 2021The 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.\ \ Dave Beatty-8 Nov 2021#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.\ \ Daniel Perry-Reed-5 Nov 2021#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.\ \ Daniel Perry-Reed-29 Oct 2021#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.\ \ Daniel Perry-Reed-22 Oct 2021#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\ \ Daniel Perry-Reed-15 Oct 2021#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. \ \ Daniel Perry-Reed-8 Oct 2021Key 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.\ \ Daniel Perry-Reed-6 Oct 2021How 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.\ \ Dara Fitzgerald-28 Sept 2021Measured 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.\ \ Daniel Perry-Reed-24 Sept 2021Everything’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.\ \ Steven Elliott-21 Sept 2021Measured 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.\ \ Daniel Perry-Reed-17 Sept 2021Measured 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.\ \ Daniel Perry-Reed-10 Sept 2021PIVOT: 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.\ \ George Mendham-3 Sept 2021Measured 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...\ \ Daniel Perry-Reed-3 Sept 2021Measured 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).\ \ Daniel Perry-Reed-27 Aug 2021Measured 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.\ \ Daniel Perry-Reed-20 Aug 2021GA4 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.\ \ George Mendham-19 Aug 2021Getting 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.\ \ Lace Rogers-18 Aug 2021Measured 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!\ \ Daniel Perry-Reed-13 Aug 2021How 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.\ \ Lace Rogers-12 Aug 2021The 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.\ \ Daniel Perry-Reed-11 Aug 2021Measured 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).\ \ Daniel Perry-Reed-6 Aug 2021How 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.\ \ Liam Grant-5 Aug 2021Measured 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. \ \ Daniel Perry-Reed-30 Jul 2021A 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?\ \ Mark Rochefort-26 Jul 2021Measured 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.\ \ Daniel Perry-Reed-22 Jul 2021Data 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.\ \ Steven Elliott-9 Jul 2021Why 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.\ \ Steven Elliott-29 Mar 2021Data 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\ \ Lace Rogers-8 Mar 2021How 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.\ \ Daniel Perry-Reed-29 Jan 2021Customer 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\ \ Oli Paterson-22 Jan 2021Data 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 \ \ Lace Rogers-21 Dec 2020How 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\ \ Katy Beckett-15 Dec 202030 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\ \ Mark Rochefort-25 Nov 2020Google 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\ \ Victor Sarker-16 Nov 2020Google 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\ \ Mark Rochefort-14 Oct 2020[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\ \ Adam Englebright-23 Sept 2020](/content/insights/blog/three-popular-gtm-server-side-tagging-misconceptions/index.html)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\ \ Jacob Birch-3 Jul 2020We 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 -\ \ Mark Rochefort-29 Jun 2020Google 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\ \ Victor Sarker-22 Jun 2020Emergency 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. \ \ Steven Elliott-2 Apr 2020Life 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\ \ Mark Rochefort-22 Mar 2020Allowed 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\ \ Adam Englebright-20 Mar 2020Working 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 \ \ Victor Sarker-20 Mar 2020Google 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\ \ Adam Englebright-7 Feb 2020Audience 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 \ \ Aimée Hart-4 Feb 2020Capturing 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\ \ Adam Englebright-29 Jan 2020Google 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\ \ Adam Englebright-24 Jan 2020Google 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\ \ Adam Englebright-17 Jan 2020Turning 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\ \ Adam Englebright-9 Jan 2020A 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\ \ Aimée Hart-6 Jan 2020How 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\ \ Dave Beatty-6 Dec 2019Team 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\ \ Mark Rochefort-11 Nov 2019A 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 \ \ Aimée Hart-6 Nov 2019Product 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 \ \ Katy Beckett-11 Oct 2019Three 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\ \ Adam Englebright-20 Sept 2019Expanding 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\ \ Aimée Hart-17 Sept 2019How 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\ \ Adam Englebright-12 Sept 2019Next‑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\ \ Mark Rochefort-2 Aug 2019GTM 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\ \ Adam Englebright-2 Apr 2019Google 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\ \ Alex Cirstea-21 Jan 2019It'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\ \ Mark Rochefort-20 Dec 2018What 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\ \ Mark Rochefort-13 Dec 2018Overcoming 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\ \ David Kane-5 Nov 2018Knead 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\ \ Aimée Hart-29 Oct 2018Toot 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\ \ Mark Rochefort-16 Oct 2018GTM 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 \ \ Adam Englebright-1 Oct 2018Goodbye 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\ \ Mark Rochefort-17 Jul 2018Chat about analytics and drink beer\ \ Last night's #BrightonAnalytics meetup 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\ \ Mark Rochefort-20 Jun 2018Adding Firebase Analytics to your React Native app\ \ This article describes how to integrate Google Analytics for Firebase (formerly Firebase Analytics) to a React Native app. In order to do this, you need to use a JavaScript bridge called RNFirebase.  \ \ This is lightweight layer sitting on top of native Firebase librarie\ \ Alex Cirstea-23 May 2018Firebase Analytics demystified\ \ 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.\ \ 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 \ \ Alex Cirstea-5 Feb 2018The 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\ \ Adam Englebright-18 Jan 2018Measurelab 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\ \ Dara Fitzgerald-26 Oct 2017Activist 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.\ \ Adam Englebright-26 Jul 2017Data Studio new countries availability\ \ 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. \ \ 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\ \ Magdalena Pajak-7 Mar 2017Free 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 \ \ Juan Barros-17 Feb 2017Google 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\ \ Magdalena Pajak-2 Feb 2017Google 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\ \ Magdalena Pajak-7 Dec 2016When GA just isn't enough - my #measurefest talk\ \ I spoke at #Measurefest 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. \ \ 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\ \ Dara Fitzgerald-24 Nov 2016How 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\ \ Steven Elliott-16 Sept 2016Understanding 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,\ \ Magdalena Pajak-15 Sept 2016Bounce rate vs. Exit rate part one\ \ 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.\ \ 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\ \ Alex Cirstea-12 Sept 2016GTM 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\ \ Alex Cirstea-31 Aug 2016Learn With Measurelab beta launch!\ \ Measurelab already offers some of the best in-person training around, with monthly courses on Google Tag Manager and Google Analytics in London and custom in-house training available on request, but w\ \ Adam Englebright-8 Jul 2016The 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 GA Training&n\ \ Daniel Perry-Reed-27 May 2016Data Visualisation with Power BI\ \ Since the recent(ish) announcement of Google Data Studio 360 (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 \ \ Daniel Perry-Reed-6 May 2016[Core Reporting API v4\ \

    Core Reporting API update” doesn’t sound like the most exciting thing in the world, but trust me: it is. Well, maybe not the most exciting thing, but certainly getting on that way. So what’s new?

    \\ \\* 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 \\ \\ Adam Englebright-14 Apr 2016](/content/insights/blog/core-reporting-api-v4/index.html)[**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\\ \\ Daniel Perry-Reed-15 Mar 2016](/content/insights/blog/google-analytics-360-suite/index.html)[**Cafe Analytique... 2**\\ \\ Skandinaviska\_konstnärernas\_frukost\_i\_Café\_Ledoyen\_-\_Fernissningsdagen\_1886\\ \\ 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\\ \\ Adam Englebright-4 Mar 2016](/content/insights/blog/cafe-analytique-2/index.html)[**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, \\ \\ Adam Englebright-26 Nov 2015](/content/insights/blog/google-analytics-minus-google-analytics-my-measurefest-2015-talk/index.html)[**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\\ \\ Mark Rochefort-10 Nov 2015](/content/insights/blog/we-are-google-tag-manager-certified/index.html)[**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\\ \\ Juan Barros-2 Oct 2015](/content/insights/blog/google-tag-manager-training-courses-measurelab-team-now-available/index.html)[**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\\ \\ Adam Englebright-21 Jul 2015](/content/insights/video/top-5-gtmv2-features/index.html)[**fun with balance balls**\\ \\ \\ \\ 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.\\ \\ Adam Englebright-9 Jul 2015](/content/insights/blog/fun-with-balance-balls/index.html)[**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\\ \\ Adam Englebright-3 Jun 2015](/content/insights/blog/extract/index.html)[**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 \\ \\ Steven Elliott-24 Apr 2015](/content/insights/blog/dara-fitzgerald-international-super-star/index.html)[**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\\ \\ Adam Englebright-19 Feb 2015](/content/insights/blog/r-analytics-beginners-guide-part-4/index.html)[**R For Analytics: A Beginner’s Guide, Part 3**\\ \\ IMPORTANT: THE PACKAGE HAS BEEN UPDATED BUT ADAM HASN'T HAD TIME TO UPDATE THIS YET! PROCEED AT YOUR PERIL!\\ \\ 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\\ \\ Adam Englebright-4 Feb 2015](/content/insights/blog/r-analytics-beginners-guide-part-3/index.html)[**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\\ \\ Adam Englebright-29 Jan 2015](/content/insights/blog/r-analytics-beginners-guide-part-2/index.html)[**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 \\ \\ Adam Englebright-22 Jan 2015](/content/insights/blog/r-analytics-beginners-guide-part-1/index.html)[**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\\ \\ Mark Rochefort-6 Jan 2015](/content/insights/blog/google-analytics-training-2015/index.html)[**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\\ \\ Juan Barros-2 Dec 2014](/content/insights/blog/gaiq-prepared-passed/index.html)[**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\\ \\ Juan Barros-24 Nov 2014](/content/insights/blog/google-analytics-health-check-part-2-third-week-measurelab/index.html)[**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\\ \\ Juan Barros-17 Nov 2014](/content/insights/blog/google-analytics-health-check-part-1-second-week-measurelab/index.html)[**Floods, Scroll Depth, Bonfire and lots of coffee: My first week at Measurelab**\\ \\

    It’s been, without a doubt, an unusual first week. Upon arrival to the mind-blowing Old Candlemakers 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\\ \\ Juan Barros-10 Nov 2014](/content/insights/blog/scroll-depth-floods-lots-coffee-first-week-measurelab/index.html)[**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\\ \\ Mark Rochefort-15 Oct 2014](/content/insights/blog/google-tag-manager-overhaul-released-public-beta-new-interface-features-api/index.html)[**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\\ \\ Adam Englebright-1 Oct 2014](/content/insights/blog/google-analytics-embed-api/index.html)[**Enhanced Ecommerce & Data Import - \#BrightonSEO slides**\\ \\ On Friday the Measurelab team attended BrightonSEO 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\\ \\ Dara Fitzgerald-15 Sept 2014](/content/insights/blog/enhanced-ecommerce-data-import-brightonseo-slides/index.html)[**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\\ \\ Adam Englebright-11 Sept 2014](/content/insights/blog/better-living-universal-analytics/index.html)[**Measurelab has moved!**\\ \\ Last Friday afternoon, instead of the usual slacking off hard work right up to the end of the day, Measurelab (and our good friends at Brightlocal) 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 Englebright-1 Sept 2014](/content/insights/blog/measurelab-moved/index.html)[**Adam's Analytics Adventure: Week 5**\\ \\

    View from the hill, 1 month ago.
    View from the castle, 1 month ago.
    \\ \\ 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 Englebright-1 Aug 2014](/content/insights/blog/adams-analytics-adventure-week-5/index.html)[**Adam's Analytics Adventure: Week 4**\\ \\
    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.
    Went for a wander around Lewes itself over the weekend. The images aren't super-relevant, but they're quite nice. This on\\ \\ Adam Englebright-25 Jul 2014](/content/insights/blog/adams-analytics-adventure-week-4/index.html)[**Adam's Analytics Adventure: Week 3**\\ \\

    New Laptop!

    \\ \\ 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 Englebright-18 Jul 2014](/content/insights/blog/adams-analytics-adventure-week-3/index.html)[**Adam's Analytics Adventure: Week 2**\\ \\ 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.\\ \\ 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 Englebright-11 Jul 2014](/content/insights/blog/adams-analytics-adventure-week-2/index.html)[**Adam's Analytics Adventure: Week 1**\\ \\

    Day One

    \\ \\ 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\\ \\ Adam Englebright-4 Jul 2014](/content/insights/blog/adams-analytics-adventure-week-1/index.html)[**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\\ \\ Mark Rochefort-30 Jun 2014](/content/insights/blog/migrating-analytics-enhanced-e-commerce-reports-5-easy-steps/index.html)[**Universal Analytics is out of Beta... So What Now? \#brightonseo talk slides**\\ \\ Yesterday, at BrightonSEO, Dara (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 Slideshare) from the presentation in case you missed it or wanted to view them\\ \\ Mark Rochefort-25 Apr 2014](/content/insights/blog/universal-analytics-beta-now-brightonseo-talk-slides/index.html)[**Universal Analytics is out of Beta...BrightonSEO talk (coming up)**\\ \\ In line with the announcement on Wednesday that Universal Analytics is coming out of Beta, I changed my upcoming talk at BrightonSEO to focus entirely on this.\\ \\ When I spoke at events previously about Universal Analytics, there was still a lack of parity with Class\\ \\ Dara Fitzgerald-4 Apr 2014](/content/insights/blog/universal-analytics-beta-brightonseo-talk/index.html)[**Import your Cost Data to GA with our new (Free!) Uploader**\\ \\
    Please note that this app is no longer relevant as Google have provided their own cost uploader tool!
    \\ \\ 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\\ \\ Dara Fitzgerald-4 Apr 2014](/content/insights/blog/import-cost-data-ga-new-free-uploader/index.html)[**\#brightonanalytics**\\ \\