New High Score

Analytics. Visualization. Data. Design. Marketing.

Archive for the ‘Google Analytics’ Category

Average Time on Site & Page

leave a comment »

I learnt today, that when Google Analytics calculates Average Time on Page, it excludes bounces (0 second page views) from the calculation. However, when it calculates Average Time on Site, it does not exclude bounces.

This might seem like a trivial point, but is important in certain cases. Usually, when the website is having far more bounces on particular pages, than on others, these metrics might give different results for the high-bounce pages.

Just making a note of it, that’s all.

Written by newhighscore

July 6, 2009 at 2:23 pm

Excellent Analytics

leave a comment »

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!

Download Excellent Analytics now!

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.

Written by newhighscore

June 18, 2009 at 2:13 pm