Google Analytics 4 (GA4) exports event data to BigQuery, enabling detailed user behavior analysis. However, GA4 batches events before sending…

BigQuery offers powerful scripting capabilities that can simplify complex workflows. In this post, we’ll explore two essential techniques: using IF...THEN...END…

Efficient data loading is crucial for managing and updating tables in Dataform. Various strategies exist to handle different use cases,…

Same same but different At the beginning of the year, I wasn't quite sure what Measurelab would look like by…

Managing scheduled queries in BigQuery often feels limiting — there’s no version control, no easy collaboration, and scaling can be…

Setting up a Dataform repository can be challenging without the right steps. Whether you’re new to Dataform or want to…

Offline event data import in Google Analytics 4 allows you to upload event data that was acquired outside of your…

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.

Learn how Dataform can solve the challenges of outdated SQL, improving data reliability, scalability, and efficiency for marketing teams.

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.