Google Analytics Premium + Fusion Tables = Awesome Data

It's Saturday afternoon, and what better to be doing than enjoying a mocha, watching by littlest kid so my wife can take a nap, and… geeking out on Google Analytics!

So, here's what I've come up with – a really nifty chart visualizing the relationship between dimensions and various metrics of interest.


How I Did It

The process was "fairly" simple.  I'm using a combination of:

  • Google Analytics (Premium, in this case)
  • Google Spreadsheets
  • Google Fusion Tables

Step 1: Find and Export your GA Data

To start, I determined the GA data I wanted to export.  This really started with figuring out what the business question(s) were to answer.  Once I had my questions in mind, I determined the data that I thought would be relevant and queued up reports.  

In this case I was fortunate enough to be working with data coming out of Google Analytics Premium which meant it afforded a large data set that was unsampled – yum!  So, using GA Premium I queued up an unsampled report extract and had a sip of my mocha.

Step 2: Sanitize the data and move it into Google Spreadsheets

Next I imported the data into Google Spreadsheets and sanitized it by converting Flash Version into an integer (by default, it uses a format with verison number + release number).  Once in a happy place, the data can be imported into a Fusion Table.

Step 3: Visualize with a Network Map

Once I have the data into a Fusion Table, making a Network Map out of it is quite easy – a click of a button.

Beauty, and Meaning, in Data

And there you have it, a format in which data is so much more explorable, and interesting! Now, just imagine what we could do with Google Analytics data in something like Tableau Software!

Hope you're having a great weekend too!



Leave a Comment