Cafe Analytique... 2

Adam Englebright•4 March 2016•1 min read
Cafe Analytique... 2
			<img class="wp-image-3615 size-medium alignleft" src="https://measurelab.ghost.io/content/images/2025/07/skandinaviska_konstnarernas_frukost_i_cafe_ledoyen_-_fernissningsdagen_1886-300x300.jpg" alt="Skandinaviska_konstnärernas_frukost_i_Café_Ledoyen_-_Fernissningsdagen_1886" width="300" height="300">

After the rousing success of the first Cafe Analytique back in November, we thought we'd have another one on Wednesday the 16th of March from 6pm, and immediately make the name redundant by having it in a pub – specifically the Hare and Hounds on London Road. A bit more informal this time – no talk at the beginning, just sitting down and chatting about #analytics. If that sounds like something you'd be interested in, let us know you're coming by signing up here.

Ready to talk?

Book a free discovery call to discuss how we can help with your data and analytics challenges.

Book a discovery call

Check your setup for free

Our instant analytics audit scans your GA4 configuration and flags what's missing, broken or misconfigured.

Run a free audit

Suggested content

BigQuery Tips: When your query is technically correct but BigQuery won't run it

There is a particular kind of frustration that comes from staring at a query you know is correct and watching it fail. No syntax error. No logic problem. Just a wall. We hit two of them on the same project. What we were building The job was to migrate ga4_daily_snapshot for a large enterprise client from a BigQuery scheduled query into a proper Dataform pipeline. The scheduled query had been added to over time until it was too large to maintain with any confidence. Moving it to Dataform w

Katie Kaczmarek•17 Aug 2026

BigQuery Tips: The subquery in your WHERE clause that's scanning your entire table

There is a pattern that appears in a lot of BigQuery pipelines and looks completely reasonable. You have a control table that stores the latest processed date. Rather than hardcoding a date into your query, you pull it dynamically: SELECT * FROM `project.dataset.events` WHERE event_date = ( SELECT latest FROM `project.dataset.control_table` ); The query returns the right results. The logic is clean. And if your events table is large and date-partitioned, you might be scanning the entire

Katie Kaczmarek•13 Aug 2026