#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-
Insights
BigQuery
Google BigQuery data warehouse, SQL queries, and analytics data processing (185 posts)
Browse the archive
Explore a topic across our insights
185 results · Page 5 of 11
#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-
Connecting GPT to BigQuery: Zapier AI actions
Using Zapier AI automation, we aim to build our very own GPT capable of grabbing data from BigQuery for analysis.
Matthew Hooson-
How to debug your SQL in BigQuery
Discover how to efficiently troubleshoot and find missing data in your code. Dive deep into the step-by-step process of querying code segments in BigQuery, leveraging CTEs, and ensuring you understand the flow of your data. Master the art of debugging with hands-on examples.
Katie Kaczmarek-
The Google Cloud tools of the marketing analytics trade
The GCP is vast and overwhelming. We aim to sort through the clutter and help highlight what you need to know as a digital marketing professional.
Matthew Hooson-
GA4 app attribution case study: Pret + Adjust integration
Pret a Manger is a brick and mortar chain of coffee shops serving freshly made food and good organic coffee. They have 600+ stores distributed globally and their analytics team is responsible for over 30 million events every month collected across both web and app. “Measurelab have been a key partner to us as we’ve undertaken a complete overhaul of our app and web analytics. Having access to the wide range of skillsets within the organisation has been invaluable as we’ve embarked on this journ
Mark Rochefort-
Gathering insights at MeasureCamp London 2023 (BONUS)
Full show notes, transcript and (NEW!) AI chatbot - https://bit.ly/3tEDQL8. 00:00 Start 00:15 Intro 00:40 Main topic 00:40 What’s the biggest challenge today which will be gone in five years time? 03:42 What will be the biggest challenge in the next five years? 07:53 Outro ----- Episode Summary:
Will Hayes-
#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-
Call propensity analysis for Sanderson – bridging online data and call centre insight
Sanderson Design Group designs and manufactures wallpaper and fabrics, with a history stretching back more than a century. It trades under several brands including Arthur Sanderson & Sons, Morris & Co., Zoffany and Harlequin. The analytics team manages 5+ sites and over 20,000 digital transactions per month. The challenge Sanderson has recently launched a new B2B ordering system, aiming to streamline order generation and reduce customer service calls. Following the implementation, call volum
Mark Rochefort-
BigQuery optimisation case study: EDF Energy saves 250 GB a day
EDF Energy is the UK division of EDF, the multinational energy company. Their services span electricity generation and the sale of natural gas and electricity to homes and businesses throughout the United Kingdom. Their analytics and insight team manage data from 15+ websites and apps totalling 65 million events every month. We helped reduce their data query volume by an astonishing 250GB per day! The challenge During the migration to Google Analytics 4 (GA4), EDF aimed to streamline their
Mark Rochefort-
#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-
#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-
#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-
#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-
The Derelict Data Warehouse
A well-maintained and utilised data warehouse is a thing of beauty. Imagine all your data from disparate sources autonomously extracted, loaded and transformed into nice neat reporting tables. Picture, if you can, impactful analysis, company-wide data-driven decision-making, a true understanding of return on ad spend. It’s enough to make anyone weak at the knees. But therein lies the problem. Companies (or ambitious individuals) can be too desperate to reach the promised land and rush headlong
Matthew Hooson-
#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-
The Measure Pod: 2 years of podcasting
If you also work in an industry like analytics, there's generally very few people who you can really talk to about work stuff. I bet most of us have had something like "do you have Chandler Bing's job?" said to us at some point. Or is that just me? Anyway, to the point. Almost to the day two years ago I wrote about how we set up and launched The Measure Pod - wow, doesn't time really fly! If you've never come across the podcast The Measure Pod, you'd be forgiven. Like a lot of things, it was b
Daniel Perry-Reed-
Backing up Universal Analytics data in BigQuery
Saying goodbye to UA hurts, especially when you need your historical data out before Google deletes the lot. We at Measurelab built our own tool to soothe this pain for our clients.
Matthew Hooson-