Posts Tagged ‘Google Analytics’
I’m continuing on this week’s big meme, the FREE debate, and looking at the obvious parallel that we have in the world of Web Analytics today: Google Analytics vs. Omniture/Webtrends and all the other tools.
It’s a debate that’s been done to death in the Web Analytics universe. A simple search throws up 452,000 results on the phrase ‘Google Analytics vs. Omniture’. I used Omniture because it’s arguably the biggest and most popular paid Web Analytics tool around right now. Some links to the salient points of the debate, in case you need to catch up: Web Expectations/Conversion Works, Jonny Longden, Eric Hansen, Four Digital, Bawaal…
As it stands now, ‘Paid’ and ‘Free’ coexist – both the Google Analytics free package as well as the host of paid-for products and services. And I don’t expect things to change drastically. While Google is free, delightfully simple to use, and easy to set-up, Omniture has some functions like segmentation, live support, etc. which are useful for a full-service online firm or website. Google itself provides additional services and support if you pay them for it, and then there’s the bunch of Google Authorized Analytics Consultants who can step in when things get hairy. This model works well because those who really need an indepth understanding of what’s happening on their website will probably be willing to pay for the solution (and Omniture provides a truckload of additional stuff in their costlier implementations). The rest will be happy with GA because it’s effective and functional. The market is currently in a well developed Freemium phase – and this is where I see a lot of services going. And as for coexistence, an increasing number of folks are putting both on their website. Check this out!
Coming back to the debate, this is where I see that Anderson predicts a Freemium for the newspaper industry, since that seems to be one of the focal points of the debate.
Mark Red and Dropit have put together a useful plugin that helps query Google Analytics using Microsoft Excel. Considering that these are among the more commonly used tools/apps, this is a welcome plugin. What’s more, it’s even Open-Source.
Excellent Analytics is a simple Excel plug in that lets you import web analytics data from Google Analytics in to an Excel spreadsheet.
- Build queries with all dimensions and metrics available in Google Analytics
- Apply filters to create advanced queries
- All queries are stored in the spreadsheet
Imported data is stored in the spreadsheet so you can sort, manipulate and distribute the data to anyone using Microsoft Excel.
Use Microsoft Excel to combine web analytics data from Google Analytics with offline data from any other source. Excellent Analytics makes this easy!
I’m yet to use it, because I don’t have any Google Analytics work going on at the moment, but will give it a spin when I can.
Update: From some discussions on mailing lists and forums, I think one has to fiddle with the date-format settings in Excel to make it work. Just in case any of you were having trouble.