7 Jul 2025 · 7 min read
Stale Opportunity Thresholds — When to Remove Deals from Coverage
Open deals with no activity in 90 days inflate coverage ratios and distort quarter-end planning. Setting a defensible threshold requires segment-specific analysis, not a universal rule.
Coverage ratio—pipeline value divided by remaining quota—is a standard commercial metric. When stale deals remain open, coverage looks healthy while active pipeline is thin. The question is not whether to remove stale deals, but what "stale" means for your sales cycle.
Segment-specific thresholds
Enterprise deals with six-month cycles may legitimately show no activity for 45 days during legal review. SMB deals with 30-day cycles should not sit untouched for 60 days. We calculate the 75th percentile of days-between-activity for closed-won deals in each segment, then use 1.5× that value as the stale threshold.
For a recent industrial components client, enterprise threshold landed at 62 days; mid-market at 38 days. Applying a universal 90-day rule would have kept 180 false-positive "active" deals in enterprise while prematurely flagging 40 legitimate mid-market opportunities.
What happens after flagging
Flagged deals do not auto-close. Reps receive a weekly list and must either log a dated next step or move the deal to closed-lost with a reason code. Sales ops tracks rep response rate. Most teams see coverage ratio drop 15–25% after the first cleanup— which is the point.
Finance appreciates the honesty. Boards prefer a lower coverage number backed by verified activity over a inflated figure that collapses in the final two weeks.