August 23, 2011

A Great Predictive Metric: "Power"

You've probably heard about all of the geeky metrics that folks compute ... and you're probably saying "PRODUCE SOMETHING LESS NERDY, NOW!"

If you want something less geeky, something that tells you where your business is headed in the next year, calculate a metric called "Power".

Simply put, "Power" is the sales expected from your twelve-month buyer file in the next year.  Here's how you calculate it.
  • Step 1:  Segment your 12-month buyer file however you wish.  We do this as of a year ago, say 2010.08.23.  Let's pretend that you have five segments ... A / B / C / D / F.  Let's pretend that you have 100,000 customers per segment.
  • Step 2:  For each segment, calculate the average amount a customer in that segment spent from 2010.08.24 to 2011.08.23.  Let's pretend that As spent $100, Bs spent $50, Cs spent $30, Ds spent $20, and Fs spent $10.
  • Step 3:  Count the number of customers in each segment as of today.  Let's pretend that today you have 80,000 As, 100,000 Bs, 120,000 Cs, 120,000 Ds, and 120,000 Fs.
  • Step 4:  Multiply last year's value by this year's file counts, yielding file "Power"!
At this time last year, you had 500,000 customers who generated 100,000*100 + 100,000*50 + 100,000*30 + 100,000*20 + 100,000*10 = $21,000,000.  At this time last year, your twelve-month buyer file was capable of $2,100,000 of "Power".

As of today, you have 540,000 customers who are expected to generate 80,000*100 + 100,000*50 + 120,000* 30 + 120,000*20 + 120,000*10 = $20,200,000.  You have more customers, however, your customers aren't capable of generating as much "Power" as customers were capable of generating last year.

This is a particularly important concept for online / e-commerce folks, because your web analytics tools make it really hard for you to see how powerful your customer file is.

Best of all, this metric is predictive in nature, it doesn't tell you what happened in the past, it tells you what is likely to happen in the future.

Retailers tend to run this metric on a monthly basis (some weekly), so that they can understand key inflection points.

Power --- a metric you need to calculate!!

Page Counts When Bifurcation Hurts All Other Customers

Yesterday we talked about the fact that best catalog customers (a minority of your file) deserve MANY catalogs that are merchandised with...