April 27, 2008

How Many Customers Should Receive My Retail Catalog?

If you are lucky enough to work in a retail environment that gives the database marketing professional the autonomy to determine retail circulation depth, you're probably using mail and holdout groups to aid your decision.

Here's how many folks approach the subject.


Step 1: Review last year's mail and holdout results. Let's assume you had a holdout group of 100,000 (yup, I said a big number like 100,000 ... if your customer buy more than three times a year, you'll end up needing a big holdout group). Compare performance between the mailed group and the holdout group.
  • Mailed Group: Total = $15.00. Retail = $9.00, Online = $4.00, Phone = $2.00.
  • Control Group: Total = $12.00. Retail = $7.00, Online = $3.00, Phone = $2.00.
  • Incremental Lift: Total = $3.00. Retail = $2.00, Online = $1.00, Phone = $0.00.
We usually look at the incremental lift, in dollars, to decide if the mailing made sense or not. This time, we're going to look at the fractional change, and apply the fractional change to each of our segments.
  • Fractional Change = $15.00 / $12.00 = 1.25.

Step 2: Apply the fractional change to each segment. Now, you're likely to have a half dozen statisticians tell you the twenty-nine assumptions you're violating. And they're right. But we're not managing clinical trials for Vioxx, are we? No, we're dealing with something less serious. So, we jump into Excel, and we look at what each segment is expected to spend during the three weeks this retail catalog is active. Once we have the estimate, we apply the fractional change to each segment. Then, we subtract the difference, yielding our expectation for the mailing.
  • Segment 1 Expected Spend = $20.00.
    • Fractional Change = $20.00 * 1.25 = $25.00.
    • Expected Catalog Performance = $25.00 - $20.00 = $5.00.
  • Segment 2 Expected Spend = $12.00.
    • Fractional Change = $12.00 * 1.25 = $15.00.
    • Expected Catalog Performance = $15.00 - $12.00 = $3.00.
  • Segment 3 Expected Spend = $4.00.
    • Fractional Change = $4.00 * 1.25 = $5.00.
    • Expected Catalog Performance = $5.00 - $4.00 = $1.00.

Step 3: Run a profit and loss statement against each segment. Depending upon the cost of the catalog, and your flow-through rate from sales to profit, it is likely that only segment one, and maybe segment two, will be profitable.


Step 4: Apply your file forecast to each segment. Multiply performance by file counts. Now, you have a sales and profit forecast for your retail catalog!


Step 5: You can use the relationships in Step 1 to allocate expected sales by channel.


Again, statisticians will have your hide for using such a sloppy sales forecasting process. They'll criticize your assumption that each segment performs at the same level of fractional change. If you and your statistician disagree, go ahead and test within individual segments --- though my experience suggests this strategy isn't fruitful.

3 comments:

  1. Anonymous11:24 AM

    Hey Kevin:

    I don't know what a holdout group is? I tried looking on Google but couldn't find any info. Please help.

    ReplyDelete
  2. Let's say you were going to mail a catalog to 500,000 loyal retail customers.

    Many retailers sample a percentage of this audience (maybe 50,000), and put them in a "holdout" or "control" group. In other words, these customers are not allowed to receive the catalog.

    The Database Marketer compares the performance of the 450,000 who received the catalog to the 50,000 who were "held out". The difference in performance represents the incremental sales generated by the catalog mailing.

    ReplyDelete
  3. Anonymous2:54 PM

    Very cool! thanks for educating.

    ReplyDelete

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

A Post-Tropical Cyclone

A tropical system doesn't stay a tropical system forever. Take Milton for instance. A Category 5 hurricane at two different periods earl...