January 29, 2020

Advanced File Power

Instead of weighting transactions (which I've done many times), one can build a regression model that predicts twelve-month top-line volume. An equation allows us to compare the relative value of File Power attributes.

I typically build four Logistic Regression response models, and four Ordinary Least Squares Regression spend models.
  • Logistic Regression Response Models = 1x Buyers, 2x Buyers, 3x-5x Buyers, 6x+ Buyers, within 12 month file, 36 months of purchase history.
  • Ordinary Least Squares Regression Spend Models = 1x Buyers, 2x Buyers, 3x-5x Buyers, 6x+ Buyers, within 12 month file, 36 months of purchase history.
I use classic RFM variables (square root of months since last purchase, frequency, average order value, historical demand used in spend models) ... and I use 1/0 indicators for key channel-based attributes and key merchandise categories.

The result? A measure of File Power for each of your twelve-month buyers.

Tomorrow? I'll show you how one can use File Power to quantify the impact of a marketing and/or merchandising strategy.

No comments:

Post a Comment

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

Strategy or Tactic?

You ask your staff to come up with a "Discount Strategy" for your August email campaigns. Is this a strategy, or is this a tactic ...