A Web Analyst's Perspective
It's Not METRICS!
Archives
« November 2009
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
     
       
Today

Click me to subscribe Subscribe!

Search

Links
 

Today's Page Hits: 27

« del.icio.us Data,... | Main | Bounce Rates Again »
Friday Sep 12, 2008
Look Good With Moving Averages

I introduce you to the moving average.  The concept is simple, replace each data point with the average of the last X data points (including that data point).  No more looking at graphs like the following and trying to understand the overall trend...

monthly trend

Instead, use a moving average graph like the following twelve-month moving average to filter out seasonal noise and get a clear picture of what is going on...

moving average graph

Omniture SiteCatalyst has a built in feature to do this.

I have a strong warning to give about an ugly mistake you can only make once - Make sure you have enough data points preceding your starting point.  For example, in the above graph, the first data point with a calculated moving average is September.  For this graph to be correct, the preceding eleven months need to have complete data.  For this data set, the month preceding the first October is when tracking began, so the twelve-month moving average can only be calculated twelve months from October..  If I had started my moving average at the first June, then the moving average would be very low because I am missing three months of data in my computation (Jul-Sep).

Posted at 02:51PM Sep 12, 2008 by dustinwallace in Concepts  |  Comments[0]

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed