New version of the Google Analytics visualization tool

Update: this tool is no longer being developed. For another tool that can do everything this tool can and much more, see GA Data Grabber: GA Data Grabber

I’ve created a new version of my data visualization tool, MT Google Analytics Visualizer. With this tool you can visualize Google Analytics data in many ways not possible through the GA user interface or with other tools using the GA API. The sophisticated analysis capabilities give you a much deeper understanding on what’s happening on your sites.

A demo version of tool (restricted to three GA profiles, and to data from January-March 2009) can be downloaded here. The full version can be purchased for 59 USD per GA user account here:
(Before buying, test your network connection with the demo version – proxy or firewall settings may prevent the app from making queries)
The biggest change to the first version is the option to plot any dimension on the category axis, instead of just day, week or month. You can also now plot calculated metrics like bounce rates and conversion rates. Advanced segments are also supported. Works in Windows Excel 2003, 2007 and 2010; macros need to be enabled.
The tool is based on my GA Excel functions, the most versatile method of importing Google Analytics data into Excel and other MS Office applications.
With the added metrics and the ability to cross-tabulate dimensions, there’s a large range of interesting analyses that can be done using the tool. Here are a few examples.

Browser and browser version by week: readability of the chart is not that great, but still it’s quite interesting (click to enlarge).

Landing page vs source of new visitors: summarizes on which pages traffic coming from various sources lands.

Average visit length by visit count and connection speed: visitors who have visited the site before stay longer than first-timers, but the average session lengths don’t increase much after the 6th or 7th visit. Visitors with dialup connections have the same pattern but on a lower level.

8 Responses to “New version of the Google Analytics visualization tool”

  1. Maurik van den Heuvel

    Hi Michael,

    I used your (extremely cool) data import procedure to create a web analytics dashboard. Thanks very much for making this available to all of us.

    However, as of this new year, it does not work anymore. The matrix always gives back “no data found”. It worked perfectly until now. I cannot find what the problem is. Does this have anything to do with the change in year? Do you have any idea.

    Also, my earlier back ups don’t work anymore either. So either I have to look into this deeper in my google account, or it might be something structural in the data import function.

    Thanks! Maurik

  2. Mikael Thuneberg

    Hi Maurik,

    Everything works fine on my machine, so it’s probably something related to your account or settings. Are you sure you’ve typed the dates correctly? Have you tried downloading the latest files from my sites, to check if they work?

  3. Maurik

    Hi Mikael,
    Thanks for taking the time to reply. I looked further after your comment and noticed that the GetGAAuthentication function did not update automatically. That is sorted now.

    I am going to study your newest files as well. I really appreciate the work you are doing. Thanks again.


  4. Obidey

    Hi Michael, it seems that there is a problem when I chose visits as a metrix and region as category axis. Displayed datas are not correct regarding GA

  5. Mikael Thuneberg

    Hi Obidey,

    Which dimension do you split by? Note that to get the numbers per region correctly, you need to split by “country”, or to use an advanced segment that limits the query to one country. Otherwise, regions by the same name in different countries will be summed (for example, there’s a “Montana” in both the US and Bulgaria).


Leave a Comment to Obidey

  • (will not be published)