Google Analytics 4 replaces the concept of a “goal” with “conversion events”. In this short post I will explain the difference and provide a few…
This is a quick post to highlight how you can simplify your SQL using the WITH clause. I’ve used this technique a lot lately to…
When working with Google Analytics 4 data in BigQuery, it is common to analyze the first or most recent activity for a user. For example:…
It is time to start planning how and when you will migrate from the legacy version of Google Analytics to the new Google Analytics 4. …
Digital Analytics platforms have been around for about 15 years now, and in early 2020 they all basically share the same functionality and features. However,…
Google Analytics 4 (or GA4) is a completely new version of Google Analytics that uses Firebase Analytics on the backend. In this post I will…
Custom definitions (also known as custom dimensions and metrics) are critical to any business that relies on Google Analytics, and they have been completely overhauled…
Analysts have relied on the metric “Bounce Rate” to understand how well users are engaging with a website for a decade, but it does not…
In this post I will share the best practices that I have gathered when setting up events and parameters so that you can avoid common mistakes.
In this post I will explain how to use the Over clause to create a moving average, and provide a tutorial for visualizing COVID-19 cases in your area.