Analytics2KML: Visualize Google Analytics data in Google Earth

Quick quiz: Where else is geospatial data lurking on Google’s server farms, ready for visualizing in Google Earth? If you answered Google Analytics, you get a prize, and it’s the online Analytics2KML converter, developed by Jacob Cord.

I feel Ogle Earth is suffering a little from superlative-inflation of late, and I need to do something about it, but not until the next post: This converter is extremely cool, and works exactly as advertised. By way of example, here is a KMZ file of all the locations of all the georeferenced visits to Ogle Earth on June 14, 2006.

analy2kml.jpg

Jacob also posts the source code and a Linux binary here.

If Google were to do this instead of Jacob, they could automate the process, providing URLs to KML network links that update automatically — a little like how the personal iCal links work in Google Calendar. They could also prettify the visualization, for example by using sized 3D models to indicate the number of visitors from a location. Google is quite possibly already working on all this, as it is an obvious mashup candidate (with hindsight, okay), but if they’re not, I think I know somebody just right for the job:-)

[Update 00:02 2006-06-16: It just occurred to me to wonder where all this international geocoding was being done. It turns out it's done by Google Analytics, and the coordinates are exported along with the rest of the data.]

6 thoughts on “Analytics2KML: Visualize Google Analytics data in Google Earth”

  1. You know what would be even sweeter. A small thumbnail of the data that has gone to each location. I have a number of images that are constantly being found in Google Image searches. I’d like to see if the one of Hadrian’s Wall is going to Scotland, or the ones of Boulder are going to America.

  2. Some weeks ago I sent a suggestion to Google to do this. I said to them that would be good if they could integrate the GMail account in Google Earth so you could see your Analytics results in Google Earth, and maybe even more with some of the other services.

    I hope they do it. Would be very useful.

Comments are closed.