The Digital Strategy Blog @SeanMcColgan

Presenting your monthly SEO campaign results to the Board at the end of the week?
In need of some killer data visualisations to break up the excel charts and make your audience super excited about their companies search marketing campaigns?

Say Hello to your new friend Google Fusion Tables.

Fusion tables released in pre alpha earlier this month lets you import your own data sets. Its an experimental system for data management in the cloud. Google’s answer to Amazons EC2/public data sets. It’s a handy tool for search professionals to help create interactive visualisations of web traffic. Lets view our analytics “map data” like never before…

Exporting Map Data into Fusion Tables

• Login to your analytics account and select the account you want to visualise.
• On the dashboard you should see “Map Overlay” (depending on how you have account setup).
• At the footer of the “Map Overlay” page click the “show rows” drop down and select “500″.
• Scroll to the top of the page and hit “Export” selecting .CSV.
• Login to Fusion Tables http://tables.googlelabs.com.
• Choose “New Table” & Select the .CSV file you exported from your Analytics account.
• Identify the header row (usually row 9) “Country/Territory + Visits” etc.
• Name your Data Set and click “Finish”.
• Hit up “Visualise” on the top navigation and select “Maps”.

Example Fusion Tables Analytics Map – US States Visitor Traffic

That’s it you’re saying? Well no… did I mention this is an interactive map that your audience can click on and view all the important data – conversion rates, per visit goal value, average time on site etc. Having this data to play with instead of just presenting it makes it a lot more real for your audience (it can help your job of increasing search spend organic/paid a whole lot easier).

Example Fusion Tables Analytics Map Showing Visits, Page Views, Time on Site etc

Fusion Tables – The World is Yours…

As well as being able to visualise your web sites visitors on google maps, you can create scatter charts, motion charts, time-lines and more in Fusion. The sky is the limit – you can fuse multiple sets of data, use filters and aggregate tools for more selective visualizations, import data sets up to 100 MB, and collaborate with other researchers (geeks). With this being a pre alpha release – I’m really excited to see what the developer team roll out in the future – this could be another smash for Google – a plug n play business intelligence tool for the enterprise.

Ask any questions you may have in the comments…would love to know how you visualise your websites data…

Related posts:

1. Exquisite Analytics Visualisation Excel App Mikael Thuneberg has created a lovely google analytics > excel...