Christopher Bridges “Do not confuse things that are hard with things that are valuable.” ~ James Clear It’s a common fallacy that monitoring data pipelines, and other key performance data, is complicated or costly. Most of the time, it’s usually just not a priority… until something happens to make it vital. The problem is that […]
Uncategorized
Prevent Shopify App and Custom Pixels from firing without consent
As we worked on updating our consent management logic to align with Shopify’s recent checkout extensibility release for one of our main client (read our previous article on the topic if you are not familiar with it and want to understand this article!) we found out that : Customer events (App and Pixels) are fired even […]
Reducing BigQuery Costs – Clustering the GA4 events table
Anyone who works with Google Analytics should be using BigQuery for their analysis and reporting. There, I said it. Hit level, raw event data is your best source for whatever you want to report, if you want any accuracy at all. Want to exclude employee traffic? Easy. Found some bots? They’re gone. But this isn’t […]
Google Analytics Backup & Archiving
Today is a very auspicious day. In less than 24 hours, Google Analytics will stop processing data from tens of millions of websites. Sites that have been using Google Analytics for a very long time. Getting data out of Google Analytics is hard. It’s tenuous. It’s frustrating. And there are a number of services […]
Apple’s Safari 15.5: Impact on Geolocation Analytics
[EDIT: This post has been edited to share new findings. All edits are clearly noted]. Yesterday I was asked an interesting question by one of my clients. The organization, which provides services in the United States, wanted to know if a greater percentage of people were booking appointments in a state different from where […]
Customer “Journeys” and “Tries”
Using SQL-modeling to tell different stories about user behavior A bit over 7 months ago, Jules (our Head of Data Analysis and Conversion Optimization) sent me a message in Slack letting me know that he just published a blog post: “Session modeling in BigQuery SQL“. It’s a really fine post, and I recommend that you […]