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 […]
Google Webmaster Tools Setup and Analytics Integration
Webmaster Tools is a phenomenally useful and free diagnostic suite that no website should be without. In addition to telling you a lot about your website, it’s the only shot you have at getting information about how Google sees your website. It integrates easily with Google Analytics, which is also free and incredibly useful. I’ve […]
First Steps in Google Analytics Configuration
The previous post covered how to create a Google Analytics account, but there are several things we should do to configure the account before we even log out, or add the tracking code to our site. Because we made a Google account separate from any personal or other business accounts to create the Analytics account, […]