The Measure Channel

Watch our webinars, dive into Behind the Cloud for technical deep-dives, and catch The Data Intervention series where we tackle common analytics challenges head-on.
Webinar: Stop the martech madness! Go composable. Deliver value faster.

Webinar: Stop the martech madness! Go composable. Deliver value faster.

In this 30-minute webinar, we use three real-world examples to demonstrate how a composable approach can help you do more with the data and tech you already have - delivering value at speed. We cover three practical examples of how your marketing data warehouse can support better insights and experiences - without the need for more martech. Learn how you can: * Score wins quickly and regularly * Streamline your martech stack * Stop planning and start building Watch the replay 👇 Have que

Will Hayes•8 Jul 2025

Behind the Cloud – Data Preparations in BigQuery

In this episode of Behind the Cloud, Matt explores BigQuery’s new Data Preparation feature, an AI-powered, point-and-click tool for transforming data with ease. From natural language transformations using Gemini to automated workflows and scheduled outputs, learn how Google is simplifying data prep for analytics and machine learning. Watch below 👇 on Youtube, or catch more from the series here. Transcript [00:00:00] Hello and welcome to another episode of Behind the Cloud. Today we are gonn

Matthew Hooson•24 Apr 2025

Data pipeline optimisation with Google Cloud and Dataform

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

Prasanna Venkatesan•22 Apr 2025

Behind the Cloud – Releases and scheduling in Dataform

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

Matthew Hooson•7 Mar 2025

Behind the Cloud – IAM roles in Google Cloud

In this episode of Behind the Cloud, Matthew dives into Identity and Access Management (IAM) on Google Cloud. He discusses the common frustrations users face, and the significance of assigning specific, granular permissions to mitigate potential risks. Watch below 👇 or head over to our YouTube channel 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

Matthew Hooson•5 Nov 2024

Behind the Cloud: Using Generative AI in the GCP

In this episode of Behind the Cloud, Matthew delves into the world of generative AI in the Google Cloud Platform, highlighting how Google has integrated generative AI features into its various services. Matthew explores the ways generative AI can be used within BigQuery, such as generating SQL queries and Python notebooks! Watch below 👇 or head over to our YouTube channel Transcript Introduction to Generative AI in Google Cloud [00:00:00] Matt: Hello and welcome to another episode of Behi

Matthew Hooson•30 Jul 2024

Behind the Cloud: GCP foundational best practice

In this episode of Behind the Cloud, Matt explains how to organise GCP projects by specific use cases, how to automate processes, establish clear naming conventions, and follow best practices around security, tagging, and more. Watch below 👇 or head over to our YouTube channel 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

Matthew Hooson•27 Jun 2024

Behind the Cloud: Setting up a Dataform project within BigQuery

In this episode of Behind the Cloud, Matthew demonstrates how to enable and set up a Dataform project within BigQuery, connect it to GitHub, and initialise the workspace for building a Dataform project. Matt walks us through enabling BigQuery, creating a repository, setting up the region, and using service accounts. Watch below 👇 or head over to our YouTube channel Transcript Introduction to Dataform in BigQuery [00:00:00] Matt: Hello and welcome to this week’s behind the cloud sticking w

Matthew Hooson•4 Apr 2024

Behind the Cloud: Connecting GA4 to BigQuery

In this episode of Behind the Cloud, Matt explores the practical side of Google Analytics 4 (GA4) and its free export feature to BigQuery. We learn about export limits, batch exports, and streaming options for GA4 data. The episode also touches on setting up BigQuery within a GCP project. Watch below 👇 or head over to our YouTube channel 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 somet

Matthew Hooson•14 Mar 2024

Behind the Cloud: Dataform, what is it and why does it matter?

Watch below 👇 or head over to our YouTube channel In this episode of Behind the Cloud, Matt discusses Dataform, what it is, and why it matters? 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 i

Matthew Hooson•26 Feb 2024

Behind the Cloud: The essentials of Google BigQuery

In this episode of Behind the Cloud, Matt discusses the essentials of Google Cloud’s BigQuery. Everything from project structure, data handling, to understanding the costs involved. Watch below 👇 or head over to our YouTube channel 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 th

Matthew Hooson•7 Feb 2024

Behind the Cloud: What GCP 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 (GCP) tools of the marketing analytics trade? And more specifically, what are the tools that you should care about in Google Cloud Platform. For a more in-depth write up on GCP tools, check out Matt’s blog post. Watch below 👇 or head over to our YouTube channel Transcript [00:00:00] Matt: Hello and welcome to today’s episode of Behind the Cloud. We’re going to try and answer the ques

Matthew Hooson•13 Jan 2024

Getting started with Plotly Dash

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

Natalia Rizzi•22 Aug 2023

How to build an interactive GA4 BigQuery data schema

What and why? One of the great features of Google Analytics 4 (GA4) is the ability to pass data into BigQuery (BQ). There are many benefits to this which have already been covered in some of our previous blogs (i.e. 10 reasons to export your GA4 data to BigQuery). Passing data to BigQuery is no longer just available to enterprise GA360 customers, but to anyone using GA4 for free. What I wanted to create was a simple interactive way to explore how GA4 data is saved in BigQuery. I found the GA36

Scott Hellmund•23 Mar 2022

When GA just isn't enough - my #measurefest talk

<span style="font-weight: 400;">I spoke at <a href="http://www.measurefest.com/" target="_blank" rel="noopener noreferrer">#Measurefest</a> in the Barbican last Friday. Here are the slides from my talk but I wanted to write a quick summary to give a bit more context as the slides on their own don’t tell the story. </span> When GA just isn't enough from darafitzgerald The title of the talk was "When GA just isn't enough". For some that know me this might sound like an unexpected title. I sp

Dara Fitzgerald•24 Nov 2016

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

Adam's Analytics Adventure: Week 3

<h1 style="color: #141412;">New Laptop!</h1> New laptop finally arrived! It’s so shiny! aaaaaaaaaahhhhhh ahem. Bit shorter than usual this week, as the time I’d usually use for blogging has been spent installing/configuring the laptop which just arrived. On top of that, it's been a busy week, but not one in which the majority of my activities lend themselves to interesting anecdotes – I spent Monday just looking at spreadsheets. Fun for me, but not very interesting for you to read about

Adam Englebright•18 Jul 2014

Creating an effective Measurement Plan

When helping clients with their analytics implementations, we often run Measurement Planning workshops - bringing together stakeholders to better understand their measurement requirements. This video (part of the excellent <a href="https://analyticsacademy.withgoogle.com/">Analytics Academy</a> series) demonstrates a typical measurement planning and implementation process - closely aligned to the <a href="http://measurelab2.wpengine.com/blog/analytics-planning-is-at-the-heart-of-a-truly-measu

Mark Rochefort•17 Jan 2014

Cart Abandonment Segments - GA Screencast

The new segment builder in GA (available to all users now!) offers one major improvement to the previous Advanced Segments feature. It was previously possible to segment based on visit data only, which made cross-session segmentation and analysis impossible by default. The new segment builder allows conditions and sequences to be defined based on both visit and user data. This takes segmentation in GA from being an underused and limited feature to being a swiss army knife for intelligent

Dara Fitzgerald•14 Nov 2013