Key takeaways
- Opportunity age in sales pipeline reveals whether deals reflect genuine buyer intent or simply occupy space in the CRM.
- A nine-month average applies to most enterprise B2B deals, but the right benchmark depends on deal size and type.
- Comparing deal age against deal amount quickly exposes which opportunities no longer make commercial sense.
- Sales reps routinely use open opportunities as reminders or activity trackers. This distorts the forecast for everyone above them.
- Closing stale deals as lost, and re-opening them when buyer activity returns, is cleaner and more accurate than leaving them open indefinitely.
Why opportunity age in sales pipeline matters more than total deal count
Every sales leader who joins a new organization finds a full pipeline. The team explains that market fit is strong, inbound is healthy, and deals are moving. Yet the organization keeps missing its revenue targets. The disconnect often lies not in deal volume but in opportunity age.
Old deals look just like new ones in a pipeline view. They show an amount, a stage, and a close date. However, a deal that has been open for 400 days with no recent activity is not a pipeline asset. It is noise. And noise distorts the forecast that finance, leadership, and investors rely on to make decisions.
The nine-month benchmark for enterprise B2B
In enterprise B2B, the average sales cycle runs around nine months. That figure works well as a starting point when evaluating pipeline quality. Smaller deals and renewals close faster. Large, multi-stakeholder deals with complex procurement processes often take longer.
Nine months is an average, not a rule. Still, it gives you a useful filter. Any deal that has sat open significantly beyond that benchmark deserves a close look. The question is not whether the deal could theoretically close. The question is whether there is real, current buying activity behind it.
How to quickly evaluate opportunity age in sales pipeline
You do not need a sophisticated BI tool to run this analysis. A simple export from your CRM is enough. Follow these steps:
- Export all open opportunities with two fields: deal amount and opportunity age in days.
- Place both columns side by side in a spreadsheet.
- Sort by age from oldest to newest.
- Ask yourself whether the age makes sense given the deal size.
Here are some examples to guide your judgment:
- A 10,000 EUR deal open for 30 days: completely normal. No action needed.
- A 10,000 EUR deal open for 450 days: almost certainly dead. Close it as lost.
- A 250,000 EUR deal open for 300 days: within the normal range. Review the activity log but do not panic.
- A 250,000 EUR deal open for 600 days: possible but worth a careful look. Is there documented recent activity?
- A 90,000 EUR deal open for 270 days: borderline. Compare it to how similar deals typically perform.
In most pipelines, this exercise reveals that up to 50 percent of open deals need to be closed as lost. The customer became unresponsive, lost budget, or never had a real project in the first place.
Pro tip: Run the age-versus-amount analysis every quarter. Set a simple rule: any deal open beyond two times your average sales cycle with no activity in the last 30 days goes to “Closed Lost” immediately. You can always re-open it when the buyer re-engages. Clean pipeline produces better forecasts and better conversations.
Why sales reps keep old deals open
Sales reps have good reasons to hold onto open opportunities, or at least the reasons feel good in the moment. Here are the three most common excuses and what to do instead.
“The customer said to call back in a year”
This is the most common one. The buyer is polite, the topic is real, but there is no active project right now. Keeping the opportunity open does not help anyone. Instead, close it as lost and set a follow-up task on the account or contact record. When the time comes, you re-open the opportunity with a fresh start date. The history stays in the account. The forecast stays clean.
“I feel they will have a project soon”
Feeling is not a forecast. If there is no confirmed project, budget, or stakeholder engagement, the deal does not belong in the active pipeline. Close it as lost and move the account into a nurture campaign. Call regularly. When a project materializes, you open a new opportunity.
“I created it as a reminder so nothing gets lost”
This is a CRM usage problem. An opportunity record is not a task or a reminder. Your CRM has activity records, tasks, and follow-up fields for exactly this purpose. Opportunities exist to track real buying situations. When reps use them as reminders, the pipeline fills with phantom deals that produce phantom forecasts.
The real cost of aged deals in your pipeline
Stale deals do more damage than they appear to. The most immediate problem is forecast distortion. When a sales leader reports pipeline to the CFO or board, stale deals make the number look healthier than it is. Finance teams use those numbers to approve headcount, plan marketing spend, and set growth expectations. An inflated pipeline leads to decisions built on false assumptions.
The second problem is focus. When reps manage large numbers of aging opportunities, they lose time that should go toward active deals or new prospecting. The mental load of tracking dead deals crowds out productive selling activity.
Third, stale deals mask real performance issues. If 40 percent of your pipeline is older than your average sales cycle, the actual coverage ratio is far worse than the headline number suggests. A manager who does not look at opportunity age will miss this until it shows up as a missed quarter.
Cleaning up opportunity age in sales pipeline: where to start
Start with the oldest deals first. Export everything over 12 months old. Review each one with the responsible rep. Apply a simple question: “Is there a documented next step with the customer that happened in the last 30 days?” If the answer is no, close it.
Be consistent and clear with your team about why you are doing this. Some reps interpret pipeline cleanup as an attack on their numbers. Frame it differently. Closing stale deals does not mean the opportunity is gone forever. It means your forecast reflects reality, which is better for everyone including the rep, who will stop defending dead deals in every forecast call.
After the initial cleanup, build a rhythm. Review pipeline age monthly at the team level and quarterly at the individual level. Over time, reps develop better habits around deal hygiene because they see that clean pipelines lead to more productive conversations and fewer uncomfortable forecast reviews.
Quick facts
- The average enterprise B2B sales cycle runs around nine months, making any open deal beyond 18 months a strong candidate for closure.
- A simple export comparing deal amount to deal age in days is enough to identify stale pipeline in under an hour.
- In most pipelines, up to 50 percent of open deals should be closed as lost after an honest age review.
- Sales reps commonly use opportunity records as reminders or activity markers, which inflates pipeline without reflecting real buyer intent.
- Stale deals distort the forecast that finance, leadership, and investors use to approve spending and set growth targets.
- Closing a deal as lost does not delete the opportunity. You can re-open it the moment buyer activity returns.
Frequently asked questions
- What is opportunity age in sales pipeline?
Opportunity age measures how many days an opportunity has been open in your CRM from creation to today, or to close. High opportunity age relative to your average sales cycle is a signal that a deal may no longer be active. Sales leaders use this metric to assess pipeline quality and identify deals that need to be closed or escalated. - How do you determine if an opportunity is too old?
Compare the deal’s age to your average sales cycle length, adjusted for deal size and type. A small deal that is three times older than your average cycle is almost certainly stale. A large, complex deal slightly beyond average may still be viable. The key question is whether documented, recent buyer activity exists to justify keeping the deal open. - Why do sales reps keep old deals open?
Reps often keep deals open because they believe the buyer will eventually come back, they use the record as a reminder, or they do not want to show a closed-lost deal on their record. Managers can address this by making clear that closing stale deals improves everyone’s forecast accuracy, and that re-opening a deal when a buyer re-engages is always an option. - What happens to the forecast when stale deals stay open?
Stale deals inflate the pipeline number, making coverage appear stronger than it is. Finance and leadership make investment decisions based on these numbers. When the pipeline fails to convert, the shortfall appears as a surprise. In reality, the problem existed for months inside the aged deal list. - How often should you review opportunity age in your pipeline?
Run a team-level review monthly and an individual-level review quarterly. After the initial cleanup, set a standing rule: any deal beyond twice your average sales cycle with no recent customer activity goes to “Closed Lost.” Most CRM systems can automate a flag or report to surface these deals without manual hunting.
Opportunity age in sales pipeline: a clean forecast starts here
Opportunity age is one of the simplest and most powerful lenses you can apply to a sales pipeline. A full-looking pipeline with mostly old deals is not an asset. It is a liability that produces bad forecasts, bad decisions, and bad conversations. The fix is straightforward: measure age against deal size, close what no longer makes sense, and build a rhythm that keeps the pipeline honest over time.
Start the analysis this week. Export your open opportunities, sort by age, and compare each one against your average sales cycle. You will likely find deals that have been open far too long without any real buyer engagement. Close them. Your forecast, your team’s focus, and your next board conversation will all be better for it.
If you want help building a pipeline hygiene process for your team, get in touch.