Define Staleness by Change, Not by Contact
The definition decides whether the metric works. Meaningful activity means a change in stage, close date, or amount. Those are the fields a forecast reads. Everything else describes effort.
This matters because activity logging is easy to satisfy without moving a deal. A rep can log twelve calls against an opportunity that has held the same stage and the same close date for eight months, and an activity-based staleness rule will mark that deal as healthy.
ORM applies a twelve-month rule across most of its customer accounts, and it works well as the outer boundary. Across those accounts, 10% or more of open pipeline has gone untouched for twelve months. That share is not forecastable value. It is a reporting artifact sitting in the coverage denominator.
Building the Per-Rep View
For each rep, calculate stale value as a percentage of their total open pipeline, then again as a percentage of the pipeline they have dated inside the current quarter. The second figure is the urgent one.
| Rep | Open pipeline | Stale value | Stale share |
|---|---|---|---|
| Rep A | $3.2M | $1.28M | 40% |
| Rep B | $2.8M | $0.14M | 5% |
Silence Is the Earliest Warning
The strongest single predictor of a deal moving out is the rep changing the close date. A deal that slips from one quarter to the next is less likely to close, and that remains true even when it sits in commit.
Staleness catches the problem earlier than that. The first warning is the absence of any signal at all: no activity, no field changes, no notes. From the rep's side, it looks like a buyer who stopped returning email. From the pipeline's side, it looks like nothing happening, which is easy to miss precisely because nothing is happening. Tracking it per rep turns that silence into a reviewable list rather than a feeling. Treat it as a leading input to deal slippage rather than a hygiene chore.
Running the Cleanup
Review stale value monthly by rep. Close or re-date every stale opportunity carrying a close date in the current quarter, and require a specific buyer commitment to keep any of them in period. Then rebuild the sales forecast on the cleaned pipeline. The number will drop, and the drop is information rather than a setback.
Frequently Asked Questions
What counts as meaningful activity on an opportunity?
A change in stage, close date, or amount. Emails and logged calls show effort but not movement. An opportunity can accumulate activity records for months while none of the three fields that matter to a forecast ever change.
How much stale pipeline is normal?
It varies by company, and 10% or more of open pipeline untouched for twelve months is common in ORM customer accounts. The number matters less than its distribution, since stale value concentrated in two reps is a coaching problem while stale value spread evenly is a process problem.
Should stale opportunities be closed out?
Close them or move their close dates out of the current period. Leaving them in inflates coverage, distorts average deal size in the open pipeline, and lets a rep meet a coverage target with opportunities that have not moved in a year.
Why measure staleness per rep instead of per team?
Team-level staleness averages away the reps who need attention. One rep at 40% stale and four reps at 5% produce the same team figure as five reps at 12%, and the two situations require completely different management responses.
Put these metrics to work
ORM builds custom revenue forecast models that turn concepts like stale pipeline per rep into prescriptive action for your team.
Schedule a Demo