When you think of “programming languages for data,” Javascript probably doesn’t even make the list. Yet, if you’re using Dataform, it’s almost impossible to avoid. As you’ll learn in this article, Dataform is Javascript all the way down. Even SQLX files that you write are pretty much just Javascript files under the covers. So shed […]
Like many data geeks, Google Analytics first sparked my curiosity. Last week, Census released our Google Analytics integration. I could write a long list of game-changing applications for creating custom dimensions in Google Analytics from data in a Snowflake data warehouse, but I’ve been swirling around one that I find particularly interesting. Here’s what I’m thinking. Census, as
Writing Custom Dimension to Google Analytics from Snowflake DB Read More »
I decided it’s time I’d learn GA4 so I figured I’d implement it net new and figure it out along the way. A couple of things I rely on heavily on my sites are Content Groupings and Custom Dimensions. Luckily, GA4 handles these a lot better than UA—even if they are still a bit cumbersome.
Google Analytics 4 Pageview Custom Dimensions and Content Groupings Read More »
The market for website chatbots is growing steadily and with it, there have been a lot of entrants since Intercom lead the way. From Hubspot to Whisbi, each has their own take on it. What I found especially impressive is how Drift has opened up the tech side of their platform. This makes it a really fun marketing technology. Building chatbots
Drift Chat Event Tracking with Google Tag Manager – Less Code, More Analytics Read More »
This week I did a Google Tag Manager implementation where I had no control over the site’s source code and no access to the site’s developers. It’s an imperfect situation but luckily, GTM Auto Event Tracking affords a solution that is very effective considering these constraints. This post is meant share a few tips on
9 Pro Tips for GTM Auto Event Tracking and the Click Element Variable Read More »
If you can remember your elementary school English lessons, you might recall learning how to format postal addresses so you could send a letter or navigate yourself to a particular destination. Today, most of us navigate to Web addresses far more often than street addresses and yet we no sense about how web addresses work, what
Web Addresses Explained: What Every Human Should Know About URLs Read More »
When you reach the limits of Google Analytics custom reports and you still need more, Google Spreadsheets and the Google Analytics Add-On can take you past sampling, data consistency and dimension challenges. This post is all about the Google Analytics + Google Spreadsheets workflow. It is an end-to-end example of how you can extract more
Google Analytics to Google Spreadsheets is Data to Insights Read More »
Google Analytics got a whole lot more interesting when the Measurement Protocol was introduced. We already knew GA was the industry standard for web analytics but with the Measurement Protocol it has become the analytics platform of anything and everything that can be made digital. With some clever instrumentation, we can now use it to
Track REST APIs with the Google Analytics Measurement Protocol Read More »
Google Analytics Enhanced Ecommerce provides insight into Ecommerce performance in detail that was impossible using standard Google Analytics methods. To get the most out of Enhanced Ecommerce, you must understand the breadth of Enhanced Ecommerce data collection capabilities. This tutorial will take you from Ecommerce product page to Enhanced Ecommerce Product Data. Product Data Problem and Solution The new
Product Scope Custom Dimension & Metrics in Google Analytics Read More »
If you are like most people doing business online, it seems like there is always a long list of digital to-dos that are somewhere between “that will happen in Q4” and “that should have happened by Q4 last year.” Aside from the constant stream of daily hiccups that arise due to the asynchronous nature of
Agile Strategy for Data Collection and Analytics Read More »
