Uncategorized

Data Studio Hack – Connecting to the WordPress mySQL Database

I am amazed at how little attention the new Google Data Studio has gotten. I’ve been working with complex systems out there; There are a ton of “data studios” which are extremely complex and need trained people to operate and deliver something, usually not that pretty, on the screen. The Google Data Studio is simple and offers great integration of the default data sources, especially Google Analytics. However, it’s not limited to Google data. And…

Continue reading

Uncategorized

GTM Hack – Mouseflow Tag in Google Tag Manager and Experiment Data

I’ve already covered one third-party tag in Google Tag Manager and today I’d like to cover the second one. It’s the Mouseflow Tag. Mouseflow basically records and evaluate the actual mouse & click flow of your website visitors. It immensely useful in evaluating user experience on a qualitative level. But the tag isn’t as straightforward to implement as I thought at first; at least not, if you want to have the tag, push some data…

Continue reading

Uncategorized

Brand Residue – Google Just Changed My Title Tag

“Help! Google changes my title tag.” Sounds familiar? To me it does. I got that call a bunch of times already, and I got it just yesterday in a new and interesting situation, namely in a rebranding. I’d like to focus on this specific situation because in a company rebranding, this topic is pretty important. After all, how do you want to rebrand, if Google won’t let you? Companies change their name, not often, but…

Continue reading

Uncategorized

GTM Hack – Assigning UA IDs Based on Subdirectories using RegEx Tables in GTM

There’s a new cool feature in GTM called a RegEx Table variable. Here’s a simple use case. Suppose your website has subdirectories for each language version. So you’d have website.com/en/with English content website.com/fr/with French content website.com/zh/with Chinese content. For many purposes it’s useful to track those websites in different Google Analytics properties. Now using a RegEx Table variable this has become pretty simple. Where you’d previously either had to create many multiple tags (copies of…

Continue reading

Uncategorized

GTM Hack – Passing Hidden Form Fields to GTM

Passing the value of a form field into Google Tag Manager is pretty straight forward with the dataLayer and the dataLayer variable. But since things vary a bit case to case, I’d like to show one example which you can adapt. The basics are: If you have any formSubmit trigger present in your container, then on submit of any form, a gtm.form object will be passed into the dataLayer. This object contains all the information,…

Continue reading

Uncategorized

Getting Google Optimize Data into Google Analytics and GTM

Google Optimize is a pretty cool product, it’s a free A/B tester and it integrates pretty well with Google Analytics via your Google account. But only one way. Google Optimize uses your goals and your traffic data to determine the outcomes of your experiments but you are not able to see which visitor visited variant A/B of your experiment in your Google Analytics data. Or at least I couldn’t find the option. Here is a…

Continue reading

Uncategorized

Quantcast Advertise Tag in Google Tag Manager

Implementing Quantcast tags is super easy with Google Tag Manager as they now offer direct support in the form of two custom Quantcast tags, one for Quantcast Advertise, one for Quantcast Measurement. No need for custom HTML tags. Those custom tags are much easier to maintain, they are less prone to mistakes, easier to debug and more flexible in a sense. Of course, custom HTML can do essentially the same things, but custom tags make…

Continue reading

Uncategorized

Data Studio Hack – Filter Controls on Multiple Data Sources

I was ready to publish a short piece on copying filters & in general components from one report to another in Google Data Studio, the free reporting & dashboarding tool from Google, when I came across a curious phenomenon, which kind of explains how filters work when you copy them from one data source and apply it to the other. So, here’s something about Filter Controls in Data Studio, what they are, how to copy…

Continue reading

Uncategorized

How IKEA Localizes Content

Say you want to produce two different versions of your website, localized for visitors from two different countries, which speak the same language. For instance one site for Canada and for the US. How would you go about it, without running into duplicate content? In my opinion, IKEA does a great job at that, so we’ll examine this case in detail. But all of the lessons can be transported to most other websites, to B2C and…

Continue reading

Uncategorized

GTM Hack – Combining Lookup Tables in GTM to Serve the Right GA ID

Today I’ll share a cool way to combine multiples lookup tables to serve more complex “look up problems”, namely one with more than one type of input. Of course, any lookup table can map 10 hostnames to their Google Analytics ID, but we can’t map a combination of hostnames AND environment names to the right ID. I’ll explain the use case in detail further down. Basic Look Up Tables A lookup table is a great…

Continue reading