Depending on how carefully you read automated emails from Google Cloud Platform, you may be preparing for the change to Strict Act-As enforcement in Dataform, or you might be looking to resolve an issue caused by it. Depending on when you read this post, you might also just want to know how to set up […]
Making Analytics Useful: Align to Business Goals
We want️ ️our ️work to have an impact. Along with personal fulfillment, analytics that don’t have an impact are less likely to lead to more trust or budget, and by extension, career safety and growth. One of the main ways people expend effort on analytics without having an impact, or at least, having less of […]
Slash Your GA4 BigQuery Bills By Only Overwriting Recent Data
Are your BigQuery costs starting to creep up now that you’ve had Google Analytics 4 connected for a while? Do you have scheduled queries that overwrite the destination table on every run? This post will look at a relatively easy way to run scheduled queries on GA4 data without having to query all the way […]
Partition Tables for Lower GA4 BigQuery and Looker Studio Costs
With many of us only getting used to BigQuery in the last year or two, getting it to work with Looker Studio and Google Analytics 4 was a learning experience in many ways. A lot of introductory resources rightly focused on getting things up and running, leaving finer details of how to have them run […]
Bayesian AB Testing in Marketing Reading List
If you came here from the related talk, thanks for watching! If not, thanks all the same, and you’ll probably be able to use this as a starting point to do more reading about whatever part of AB testing piques your curiosity. There was a lot of info I wasn’t able to squeeze into my […]
The Five Ws of Analytics Business Requirements
If analytics thrives on accuracy and storytelling, maybe borrowing a time honored method from journalism will help us improve both. Instead of treating an analytics business requirement or ad hoc request as a cut and dry task to execute, what if we investigate the story that drives it? Mix in a couple Radical Analytics principals […]