Google Sheets + Google Analytics = Powerful dashboard tool

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

tweetgooglesheet

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

<future content ;)>

I work for:

Companylogos

Is your site too deep? Bad designed link structure? Test it!

One of the things I look at when I get a fresh new site to analyse is the linkstructure. All sites, and I repeat: all sites, should have a basic structure that looks like a simple tree diagram:

treestructure

All pages link to one or more pages below them. This is the basis of your site's structure. I don't say it's the only structure, you could also interlink between different categories or products, but it's the main structure. It has the following advantages:

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:

realtimewidgets

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

<future content ;)>