Google Analytics

The two steps in Dataform execution: Javascript, then SQL statements

Understanding SQLX and Javascript in Dataform

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 …

Understanding SQLX and Javascript in Dataform Read More »

Writing Custom Dimension to Google Analytics from Snowflake DB

Like many data geeks, Google Analytics was the thing that 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 Snoflake data warehouse but I’ve been swirling around one that I find particularly interesting. Here’s what …

Writing Custom Dimension to Google Analytics from Snowflake DB Read More »

9 Pro Tips for GTM Auto Event Tracking and the Click Element Variable

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 »

Google Analytics to Google Spreadsheets is Data to Insights

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 »

Track REST APIs with the Google Analytics Measurement Protocol

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 »

Product Scope Custom Dimension & Metrics in Google Analytics

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 »

Data-Driven Marketing Starts With the Data Layer

The term “digital marketing “ should describe the marketing methods as much as it describes the marketing medium.   Too often, marketers are satisfied with their “digital marketing” efforts when they send a tweet, “blast” an email or run a search ad because their message is transmitted over a digital medium.  Unfortunately, this misunderstanding so vastly …

Data-Driven Marketing Starts With the Data Layer Read More »

Event Tracking on Squarespace Using Google Tag Manager

I like Google Tag Manager and Squarespace for the same reason: they simplify and streamline the processes website design and Google Analytics implementation while maintaining power and functionality of the product.  For the old sliced bread analogy, they are the greatest things to come along since the knife. Squarespace is a great plug-and-play, drag-and-drop Content Management System (CMS). It …

Event Tracking on Squarespace Using Google Tag Manager Read More »