Google Analytics

Google Analytics Premium + Fusion Tables = Awesome Data

Posted at April 28, 2012 | By : | Categories : Google Analytics | 2 Comments

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!

-Caleb

 

Share

Comment

  • Gunjan Amit

    April 30, 2012 at 12:30 am

    Nice!!! Thanks for sharing!

  • Martijn van Vreeden

    April 29, 2012 at 8:20 am

    Cool stuff! I love Fusion Tables. I mostly use the mapping functionality to learn more about local effectiveness of online efforts. Thanks for sharing!

Leave a Comment