In wholesale distribution, most problems with client retention are visible in the data before they are visible in reality. An account does not just disappear — it sends signals for weeks or months before it goes dark. Order frequency drops. Average order size shrinks. Response to outreach slows. The problem is that most distributors are not monitoring these signals at the account level, so they only notice the pattern after it has become a crisis.
What RFM Means in a Wholesale Context
RFM stands for Recency, Frequency, and Monetary value. Originally developed for direct-to-consumer retail, the framework applies even more powerfully to wholesale distribution because B2B relationships are longer-term and account-level data is richer.
Recency (R): How long ago did this account place their last order? An account that ordered yesterday has a strong Recency score. An account that last ordered 90 days ago has a poor one. Recency is the most predictive signal for churn — declining recency is usually the first indicator that something is wrong.
Frequency (F): How many orders has this account placed in the last 90 days, relative to their historical baseline? An account that typically orders 8 times per month and placed 3 orders this month has declining frequency — a red flag.
Monetary (M): What is the account's average order value or total 90-day spend, relative to their historical baseline? An account whose order sizes are shrinking may be testing a competitor for some of their volume.
Each dimension gets scored, and the combination produces a health tier for every account.
Calculating a Simple Account Health Score
You do not need a complex algorithm. A workable score uses three inputs:
- Days since last order — scored against a threshold for that account's typical ordering frequency
- Orders in last 90 days vs. prior 90 days — percentage change in frequency
- Average order value last 90 days vs. prior 90 days — percentage change in spend per order
Example scoring (each dimension scored 1-3, higher is better):
- Recency: Ordered in last 7 days = 3, last 30 days = 2, last 60+ days = 1
- Frequency: No change or increase = 3, down 10-30% = 2, down 30%+ = 1
- Monetary: No change or increase = 3, down 10-30% = 2, down 30%+ = 1
Total score ranges from 3 to 9. This maps to health tiers.
What the Score Tiers Mean
Champion (8-9): Ordering frequently, recently, and spending at or above their baseline. These accounts are the core of your business. Your focus here is relationship maintenance and identifying cross-sell opportunities — introducing new products, deeper volume discounts, loyalty program enrollment.
Healthy (6-7): Solid accounts with no major red flags. Normal cadence, stable spend. These accounts need regular check-ins but no urgent intervention. Watch for any movement downward.
At-Risk (4-5): One or more dimensions declining meaningfully. These accounts need proactive outreach — a direct call or message from their rep to check in and identify if there is an issue. At-Risk accounts can usually be recovered with the right intervention. Ignored, they become Dormant.
Dormant (3): Recency, frequency, and spend have all dropped significantly. This account may have moved to a competitor, reduced their operations, or have a relationship issue. Re-engagement sequences are the appropriate response here, but recovery rates are lower than for At-Risk accounts.
How Automated Alerts Change Rep Behavior
The operational value of RFM scoring comes from automation. Instead of asking reps to manually monitor account health — which they will not do consistently — automated alerts push the right information to them at the right time.
When an account moves from Healthy to At-Risk, the rep gets a notification: "Account [Name] has dropped from Healthy to At-Risk — their orders are down 35% this month and they have not ordered in 18 days. Recommended action: check-in call."
This changes the rep's behavior in two important ways. First, they are not discovering problems by accident — they are being informed proactively. Second, they have the context they need to have a productive conversation: "I noticed your orders have been lighter this month — is everything okay on your end?"
What to Do With Each Tier
Having a health score is only useful if it drives action. The playbook for each tier:
- Champions: Quarterly check-in, loyalty program enrollment, first access to new products or product drops
- Healthy: Regular cadence maintained, watch for score movement
- At-Risk: Rep outreach within 3 business days, identify root cause, address if possible
- Dormant: Automated re-engagement sequence (email + SMS), rep follow-up if sequence gets a response, move to inactive if no response in 30 days