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.

For My Catalog Readers: Catalog Keynote Presentation #1

Here's the link to Keynote #1 ... tomorrow we focus on Keynote #2. It's lunchtime at NEMOA, so it's a good opportunity for you ...