Google Fusion Tables Visualization

Google has published an experimental¬†tool called ‘Fusion Tables’. This tool allows us to gather, visualize and share data tables. I decided to give it a try and check out the Map Visualization feature of this tool. The tool is fairly simple and easy to use (lot of tutorials are available on the internet based on what you plan to do). Following is the description of what I achieved through Fusion Tables.

Introduction:- THIS is my blog. I analyze it on Google Analytics to find out how my users are interacting with it and the ways I can make the UX, content of the blog better and appealing. I assigned 5 types of goals on Google Analytics to analyze how many of the users are taking actions which I want them to take (Setting goals on Google Analytics is a very useful feature and you should start using it if you have not already!).

The Problem:- Using in built visualization tools in Google Analytics I could not visualize the exact locations of the users who completed these goals.

Solution: – Using Google Fusion Tables I achieved the solution to above problem using an approach as mentioned below:-

  1. Created a CSV file of the latitude and longitude of the users who completed the assigned goals using Google Query Feed Explorer.
  2. Loaded these numbers on Google Fusion Table

And there we go! Came up with following visualization

The pin drop in the above visualization shows the locations of the users who completed goals on my website.

Conclusion:- Although Fusion Tables is in an experimental tool, it is a very robust tool for data analysis. It allowed me to create such an insightful visualization easily. Also it allows easy API integration with your data!

I will definitely keep my eye on it for the future updates and enhancements.