A number of people need to keep track of multiple web properties – their blog, support site, maybe a social media presence and their main web site. They may even have a series of related websites that they want to track independently. This week’s free Excel dashboard shows just how easily Next Analytics lets you [...]

I was looking at a report from a customer intelligence vendor last week and got thinking that a lot of the same data was available in Google Analytics, but it wasn’t very accessible in the normal reports that people use. Now I wouldn’t suggest we can replace the paid service entirely, but the value of [...]

With all the online reports provided by Google Analytics, the one that seems to be missing, years after it was pointed out, is the What’s Changed Report. Way back in 2007, Avinash Kaushik wrote in his blog (Occam’s Razor) and his book (Web Analytics, An Hour a Day) about the wonderful value of [...]

Stephane Hamel of Immeria created a sample dashboard in Excel (link) that took off virally, becoming a popular starting point for others (link) (link) to create their own solutions. I applaud his work and his creativity. In the comments to his blog, though, a number of people found the complexity daunting. I am a strong [...]

Using the unique capabilities of the Nextanalytics add-in for Excel 2007 (2003 version also available), we whipped up a quick dashboard that combines many of the key visitor-tracking metrics from Google Analytics all on one page, and it’s all yours, in a Microsoft Excel workbook. Use it as-is or customize to suit your distinctive needs. [...]

Have you ever wanted your Google Analytics reports in Excel, so you can share them with your boss? Maybe add a tweak or two to reflect your (or ‘Her’) unique needs? Well, now you can, and you don’t have to be an Excel whiz to do it! Start with our XLS file, and simply enter [...]