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!