Blog

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

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

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

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

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