November 11, 2007

File Power

Folks who've been around the block a few times know that executives want to surround themselves with database marketing wizards who can predict the future.

With many businesses now struggling to post increases, executives are going to look to analytical folks, hoping to see evidence of a "turnaround".

A tool that is readily available to you is called "file power". It's not terribly hard to calculate, and should be run on a monthly basis. Let's calculate "file power" for an online business for November 2007.

Step 1: Identify all customers who purchased online from 11/1/2005 to 10/31/2006. Example: 100,000 customers.

Step 2: Calculate the average online spend, per customer, for this audience from 11/1/2006 to 10/31/2007. Many customers will have a value of $0, because they did not purchase. Example: $75.55 per customer.

Step 3: Identify all customers who purchased online from 11/1/2006 to 10/31/2007. Example: 110,000 customers.

Step 4: Multiply Step 2 by Step 3. This is called "file power". Example: 110,000 * $75,55 = $8,310,500.

This metric is re-run, every month, using the four steps listed above. The dates used in the analysis move forward by one month.

There are many ways to complicate this measure, to make the measure more accurate. Feel free to experiment.

Looking at this simple metric on a monthly basis will be telling.

At the end of my tenure at Nordstrom, this metric pointed south, month after month. In other words, the metric suggested we were running out of "file power". Comps were still increasing, year-over-year, but the customer file was running out of gas.

The metric is reasonably good at suggesting that a downturn will occur. The metric occasionally struggles to predict future upswings --- typically, great merchandise will inspire customers to purchase, fueling the customer file, causing "file power" to increase a month or two later.

Ok, your turn. What does your "file power" look like? Did you see this business downturn coming?


  1. Anonymous6:13 PM

    Like I tell my clients whether in the direct marketing business or otherwise. The value of their companies lies 100% with their customer database.

    If you don't grow it, then you are essentially going out of business.

    Retailers often have the notion that everybody is their customer. So they really don't focus on their database. It's a wonder that any of them still survive to this day.

    So the sad truth is that many major retailers still have not invested in a true relational database. So even the simple analysis you propose here cannot be done in a reliable fashion.

  2. another great post, sir.

    you make the complex simple.




  3. Thanks for the comments, folks.

    There are companies that do a good job of measuring "file power", if you will, with no customer file! I am aware of one major (and I mean major) retailer that has an equation that predicts future comp store sales ... in lieu of any actual customer data, and does it accurately.


Note: Only a member of this blog may post a comment.

Cost Differences

Do you remember Bernie Mac in Oceans Eleven ... negotiating van prices? Muttering nonsense about Aloe Vera while squeezing the sales dude...