Check Your Spreadsheet

Yesterday I posted about liberating your data from your analytics application. In that post I mentioned that Microsoft Excel is a great data analysis tool to use when exporting information out of your web analytics application. Just now I sat down and read yesterday’s Wall Street Journal and the Talking Tech column by Lee Gomes […]

Set Your Data Free

One of my rants is about web analytics data. Not how accurate it is, but where it belongs. For the majority of people the default reports in a given web analytics package are completely adequate. New visitors, returning visitors, campaign tracking, click path analysis… they’re all very helpful and can be used to optimize your […]

What is $Index?

Alex had a very interesting post yesterday about optimizing your site using Google Analytics. He explained how to evaluate the value of certain pages on your site using the page $Index value. But what is $Index and how is it calculated? Here’s what the Google Analytics help documents say about $Index: In addition, the $Index […]

Google Analytics Installation Guide

Today Google Analytics posted a Google Analytics Installation guide on their help site. This nine-step document provides an organized process you should follow when planning a Google Analytics installation. To further demystify the installation and configuration process I’ll post more information about each step mentioned in the guide. My goal is to help everyone grasp […]

It’s The Trending

Clients often ask me to validate or reconcile the statisitcs that Google Analytics or Urchin Software provide. This is an almost impossible task that can take weeks to accomplish and usually provides inconclusive results. I advise clients to begin by focusing on trend in the data over time rather than laboring over the details of […]