
#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.
Google Ads campaigns, optimization, and advertising analytics (100 posts)

Johan van de Werken joins The Measure Pod to discuss GA4Dataform, BigQuery, and the future of analytics engineering and automation.

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.

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.
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.
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.
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.
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.
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.
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.
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.
In this week's episode of The Measure Pod, Dan and Bhav dive into the intricate world of product analytics.
In this episode of The Measure Pod, Dan and Bhav welcome back Adam Greco from Amplitude.
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.
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."
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.
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.
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.
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.
In this week's episode of The Measure Pod we spoke with Tim Ceuppens, a creative thinker in the field of data and marketing.
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.
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.
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.
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.
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.
In this episode Dan, Dara and Bhav had the pleasure of chatting with Alex, Head of SEO & Marketing Technology at ASOS.
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
Join Dan, Dara and Bhav discuss the future of product analytics tools and the intersection between product analytics and marketing analytics.
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).
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.
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.
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?
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
This week Dan and Dara are joined by Rasmus Houlind - author of the book Hello $FirstName and CXO at Agillic.
This week Dan and Dara chat about the slow but steady move in Google Analytics 4 (GA4) towards reintroducing older session-based metrics.
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.
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.
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.
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.
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.
Google Analytics 360 (GA360) is worth knowing about, especially if you’re using Google Analytics 4 (GA4) to report on a business that gets a lot of daily traffic; has multiple analytics projects dependent on the BigQuery extract; operates on a lot of different sites and/or apps or has a particularly
How do you structure a GA4 property and data stream, what considerations do you have to watch out for, and what are the options?
This week Dan and Dara talk about their experiences in building automated dashboards.
This week Dan and Dara talk about the very recent announcement that Google Optimize will be sunset on 30th September 2023.
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.
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.
This week Dan and Dara are chatting about what they think will change in the analytics industry in 2023.
This week Dan and Dara are joined by Luisa from Jellyfish to help make sense of the recent SKAdNetwork 4.0 release from Apple.
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.
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.
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.
This week Dan and Dara react and discuss the recent announcement of the schema changes in the Google Analytics 4 (GA4) Data API.
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.
This week Dan and Dara chat with Jim Sterne and chat about the Digital Analytics Association and his long and illustrious career in digital.
This week Dan and Dara chat with Rick Dronkers to talk everything privacy - from compliance and GDPR, to Schrems and Google's stance.
This week Dan and Dara chat about assessing the need for Google Analytics 360 in a GA4 world.
This week Dan and Dara chat about some new cookie settings released in Google Analytics 4.
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.
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.
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!
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.
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.
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.
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.
This week Dan and Dara are joined by Bhavik Patel to talk about the differences and similarities between product and marketing 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.
This week Dan and Dara chat through how attribution works in Universal Analytics and Google Analytics 4, and the differences between them.
Learn how to track scroll depth conversion on specific pages in GA4 without coding or tagging in Google Tag Manager.
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.
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.
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.
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?
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.
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.
How will Google’s machine learning conversion modelling and other models change analytics? Is this the end of real data?
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.
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.
This week Dan and Dara are joined by Derek Ooi to talk about app attribution, and why an MMP is essential.
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.
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.
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.
This week Dan is joined by George Mendham to discuss what features Google Analytics 4 needs to reach parity with Universal Analytics (and surpass).
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.
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.
This week Dan and Dara discuss Segments in GA. They discuss some good use cases, lesser-known hacks and applications.
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.
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.
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.
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.
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.
This week Dan and Dara chat attribution modelling and how/where/if/when it's useful and important to invest in.
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.
This week Dan and Dara discuss the PIVOT framework they've been working on to help people 'pivot' to GA4. Clever, very clever...
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.
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.
This week Dan and Dara discuss the four things analytics practitioners should consider before rolling out Google Analytics 4 (GA4).
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
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
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
<h1>Day One</h1> Upon alighting from the bus as I arrived for my first day of work, I found myself crossing the road next to a group with whom I immediately felt a degree of kinship – casually dressed (but not overly so), a scattering of black-plastic-rimmed glasses – the sort of people who, upon immediate visual inspection, you might peg as the employees of some kind of dotcom, web 2.0 startup. Such proved to be the case, in fact, as they all funneled into the shared office space where I w
<blockquote>Please note that this app is no longer relevant as Google have provided their own cost uploader tool!</blockquote> GA has long since allowed you to import AdWords cost data with a few simple button clicks. However other cost data - Bing/Yahoo paid search activity, affiliate marketing, email, Facebook advertising, etc. - were not catered for until about 18 months ago when GA released the Cost Data Import tool in beta. This Cost Data Import tool, which feeds data into a new repor