Active, At Risk, Inactive, Lost: A Simple Lifecycle for Retail Accounts

Most CPG teams can tell you their total door count. Almost none can tell you how many of those doors actually ordered in the last 30 days. That gap is where revenue quietly leaks — not through big dramatic account losses, but through hundreds of small ones nobody's tracking because there's no shared definition of what "at risk" even means.

Here's the fix: a four-stage lifecycle, defined by days since last order, with one clear action per stage. No scoring models, no guesswork. If you can pull order dates by store, you can run this today.

Active: Last Order Within 30 Days

Adjust to 45 days if your category has a longer natural reorder cycle — think shelf-stable vs. perishable. This is your base. The action here isn't "do nothing" — it's protect velocity. Make sure secondary placement, promo compliance, and planogram adherence are holding. Active accounts are where you defend share of shelf, not where you spend rep time chasing.

At Risk: 31 to 60 Days Since Last Order

This is the stage that matters most and gets ignored most, because the account still looks fine on a quarterly report. It isn't. A store that normally reorders every 3 weeks and hasn't in 6 is telling you something — an out-of-stock, a broker who dropped the ball, a category review that didn't go your way. The action: a same-week check-in call or visit, not a generic "checking in" email. Ask three questions — is the product on shelf, is it selling, did anything change on the account side (new buyer, reset, DC issue). At Risk is a diagnostic window. Miss it and the account moves to the next stage on its own.

Inactive: 61 to 90 Days

No order in two full reorder cycles. At this point it's not a check-in, it's a recovery play. You need a reason to re-enter the conversation — a new item, a trade deal, a seasonal reset — because "just following up" won't work twice. The action: escalate to a named owner (key account manager or regional rep, not a broker email blast) with a specific offer and a deadline to close it out one way or another. Inactive accounts should never sit unassigned. Every week without ownership drops your odds of winning it back.

Lost: 90+ Days with No Order and No Active Recovery Plan

This is a formal status, not a resignation. Moving an account to Lost does two things: it stops you from counting phantom doors in your distribution numbers, and it forces a decision — reactivate through a structured win-back (new buyer outreach, category captain angle, fresh promo) or drop it from active territory planning so reps stop wasting visits on dead doors.

Why the Thresholds Matter More Than People Think

Say you've got 800 doors and no lifecycle tracking. Your team assumes maybe 5–10% are soft. Run the actual order-date pull and it's common to find 15–20% sitting in At Risk or Inactive — accounts still counted as "distribution" in your board deck that haven't bought anything in two months. That's not a rounding error, that's your growth number being fiction.

The reason this framework gets quoted whole is that it removes the ambiguity that kills follow-through. "Check on underperforming accounts" is not a workflow. "Call every account at 31–60 days with these three questions this week" is. Define the days-since-last-order thresholds for your category, assign one action per stage, and make it a standing report your KAMs review weekly — not a quarterly deep-dive that finds the problem three months too late.

Retail execution isn't won by finding new doors. It's won by not losing the ones you already have without noticing.