Category Archives: Webanalytics

Google Sheets + Google Analytics = Powerful dashboard tool

Last week I did a tweet with this image in it:


It shows a Google Sheet with some data per AdWords campaign and a little sparkline next to the numbers. It got much attention, and I got many requests to explain what I did there. So here it goes, I will explain some things about the Google Analytics API, how you use it in a Google Sheet and how to extract and query data from it. And last but not least: how to create the little sparklines.

Continue reading

Create a real time error monitoring Google Analytics dashboard

Today Google officially launched the real-time widgets for use on the Google Analytics dashboards. Awesome feature that can make real-time analytics a bit more useful than it was before. These are the new widgets (the second row) you can use to visualize real-time stuff:


The great news is: you are able to put filters on these widgets... really awesome. Google has a more extensive description about all new possibilities, but here's an example I would use these features for.

Continue reading

Google Analytics introduces a Change History log

Great news, my buddy Tim Bakker told me Google introduced a new Change History feature. And when you login to your analytics account you will see this message:


With this new feature you will be able to see which account changed what to your account. This includes:

  • Accounts: created, deleted
  • Users: added, deleted, changed
  • Goals: created, deleted, changed
  • Filters: created, deleted, changed

In one word: awesome. From now on you can see if the requested goal changes are processed by your Web Analytics consultant. Or who applied a filter that blocked all data from a specific profile.

Continue reading

Google Analytics Retargeting for AdWords and AdBlock software

Just a quick post about the retargeting (remarketing) option in Google Analytics. July '12 Google launched a new feature in Google Analytics that made it possible to retarget a specific group of visitors. You only need to change this line in the Google Analytics Tracking Script from:

ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '';


ga.src = ('https:' == document.location.protocol ? 'https://' : 'http://') + '';

The script will be loaded from the doubleclick domain and a third party cookie is set. That cookie can be used to target visitors on other sites that have been on your site.

Continue reading

How to work with multiple currencies in Google Analytics

Google launched a new feature in their ecommerce module that helps international sites in tracking their worldwide revenues. Until now every single site that worked with multiple currencies had to implement some sort of curreny-converter script to get all revenues in the same currency. This is a very time consuming and expensive action that needs constant attention. As of today this is all history.

Google implemented a new feature that can convert the local currency to the currency you specified in your profile settings:


Continue reading

Google Analytics updates interface and adds some new features

It looks like Google is rolling out some new features in Google Analytics. There isn't an official statement/blog about it, but after some digging I found these new features:

New graph formats on the dashboards

There are 2 new types of graphs you can choose on your dashboard:


The Geomap and Bar are new. The Geomap is a known report that was available for quit a while in the normal reports. But on the dashboard it's a welcome addition. The Bar is new and looks like this:

Continue reading

Windows 8 visible since December 11th, 2012 in Google Analytics

Just a small update from here (haven't been blogging for a while). If you're looking at the Windows 8 stats in your Google Analytics account you will see this graph:

windows 8

Last October I tweeted that Google Analytics was reporting "Windows 8" as "Windows NT". I like to think they read my tweet and changed this on December 11th ;) Since the launch of Windows 8 on October 25th you see traffic for "Windows NT" suddenly rising until they changed it to "Windows 8".

Continue reading

Hitting the Google Analytics sampling treshold? Can you trust your numbers?

For a while I wanted to write this post about the Google Analytics sampling. You know, the dreaded message that appears on top of your reports:

This message shows up when you work with a dataset that contains more than 500.000 visits or more than 1.000.000 items (keywords/url's/etc). Above that Google takes a sample of all those visits to calculate the numbers for your reports. But what is acceptable? In this example Google uses 30.62% of all visits to guess what the other 70% did on my site...

Continue reading

Running a Content Experiment but not seeing any data?

Last months I had quite some clients that started a content experiment but didn't see data comming in:

In almost all those cases the solution was pretty easy: they had a custom Google Analytics code for multiple domain tracking. And that means you need to make some changes to the Content Experiments script also. This is an example of a changed Google Analytics tracking code:

Continue reading

5 Google Analytics reports you should check to verify your numbers tell the truth!

In this case an image says it all:

Looks familiar? No? I certainly hope this wouldn't happen to you. What happened in all these 3 examples is the start of a well implemented Google Analytics account. Before that the site's owner thought he had a lot of visitors that did a lot of small visits. While the real situation showed him there where a lot less visits, that lasted longer and had more pageviews. But he sold his advertising based on the skewed numbers...

Continue reading