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 […]
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 […]