13/13 Gate✓ IQ Certified10/10?

What's the right way to clean up a pipeline that has 60% deals older than 90 days?

📖 2,866 words🗓️ Published Jul 21, 2026

Direct Answer

Clean a pipeline with 60% deals older than 90 days by segmenting them by cause—buyer inaction, internal neglect, or dead deals—then enforcing a 14-day requalification deadline with automatic removal for non-response, followed by weekly pipeline reviews that flag any deal over 90 days without recent activity for mandatory manager assessment.

Why Stale Deals Accumulate and How to Diagnose the Root Cause

A pipeline where 60% of deals exceed 90 days rarely appears overnight. It builds gradually through a combination of weak qualification criteria, insufficient stage-gate enforcement, and behavioral biases that cause sales reps to hold onto opportunities long after they have gone cold. Understanding why these deals accumulate is the first step toward a durable cleanup.

The most common root causes include qualification frameworks that are too permissive at the top of the funnel, allowing leads that lack budget, authority, need, or timeline to enter the pipeline and linger indefinitely. Another frequent contributor is the absence of mandatory stage progression rules—deals can sit in "negotiation" or "proposal sent" for months without any system forcing a status change. Reps also exhibit optimism bias, consistently overestimating the probability of closing aged opportunities because they remember the initial enthusiasm but ignore the months of silence that followed.

To diagnose which root cause dominates your pipeline, run a simple audit. Export all deals older than 90 days and tag each with the last meaningful activity date, the current stage, and the primary reason for stalling—buyer went dark, internal champion left, budget was cut, or no follow-up was attempted. If more than half of stalled deals show no activity in the last 30 days, your problem is likely process enforcement. If most show sporadic activity but no stage progression, your qualification gates are too weak. If reps cannot articulate why the deal is still open, you have a data hygiene issue that requires immediate archival.

This diagnosis directly informs your cleanup approach. Process enforcement problems need automation and manager oversight. Weak qualification gates require retraining on frameworks like MEDDPICC or BANT. Data hygiene issues demand a one-time purge with clear criteria for what stays and what goes. Without this diagnostic step, you risk cleaning the pipeline only to watch it refill with the same type of stale deals within two quarters.

The 14-Day Requalification Protocol for Aged Deals

Once you have diagnosed the root causes, execute a structured requalification protocol that forces a decision on every deal older than 90 days within a fixed two-week window. This protocol has three phases: outreach, assessment, and disposition.

Phase 1: Outreach. Every rep responsible for aged deals sends a standardized email or places a call to their contacts. The message is direct and transparent: "We noticed your opportunity has been open for [X] days. Is this still a priority for you in the next 30 days? If not, we will close it out to keep our records accurate." This removes ambiguity and gives the buyer a low-friction way to confirm interest or disengage. Reps must log the outreach attempt in the CRM within 48 hours. If the buyer does not respond within five business days, the deal automatically moves to a "pending closure" queue.

Phase 2: Assessment. For buyers who respond positively, the rep schedules a 15-minute call to requalify using four criteria: is the decision-maker still the same person, is the budget still allocated, has the need changed, and is the timeline still within 30 to 60 days. If any of these four elements is missing or uncertain, the deal drops to a lower stage or moves to a nurture pipeline. The rep documents the call outcome directly in the CRM with a required field for each criterion.

Phase 3: Disposition. Deals that pass requalification remain in the active pipeline with a new stage and a specific next step due within 14 days. Deals that fail requalification are moved to closed-lost with a reason code—budget removed, no response, champion left, or no longer a priority. Deals where the buyer expressed interest but could not commit to a timeline go to a nurture pipeline with a 90-day re-engagement reminder. This three-way disposition ensures no deal remains in limbo.

The 14-day timeline is critical because it creates urgency without being arbitrary. Research from sales analytics platforms consistently shows that deals older than 90 days have a 60 to 80 percent lower close rate than deals under 30 days, so waiting longer to requalify only compounds the problem. The protocol also removes the emotional burden from reps by making the process systemic—they are following a rule, not admitting failure.

Building CRM Automation to Prevent Pipeline Staleness

After the initial cleanup, the most important step is implementing CRM automation that prevents the 60 percent stale rate from recurring. Without automation, pipeline hygiene depends entirely on human discipline, which historically fails within 60 to 90 days of any cleanup initiative.

Start by configuring stage aging alerts in your CRM. Set a rule that flags any deal that remains in the same stage for more than 30 days without a stage change or logged activity. The alert should notify both the rep and their direct manager via email or in-app notification. This creates immediate visibility into deals that are beginning to stall, rather than discovering them months later. Most CRM platforms—Salesforce, HubSpot, Pipedrive, and Zoho—support this natively through workflow rules or automation builders.

Next, establish hard stage gates that require specific criteria to be met before a deal can advance. For example, a deal cannot move from "qualification" to "discovery" without a confirmed conversation with the economic buyer. It cannot move from "proposal sent" to "negotiation" without a verbal commitment to proceed. These gates should be enforced through required fields or document uploads in the CRM. When a rep tries to advance a deal without meeting the criteria, the system blocks the stage change and displays the missing requirements.

Finally, create an automatic pipeline purge rule for deals that exceed 120 days without any logged activity. This rule moves the deal to a closed-lost or nurture pipeline automatically, with a notification to the rep and manager explaining the action. The rep can override the purge only with manager approval and a documented reason for keeping the deal alive. This hard boundary prevents the slow accumulation of zombie deals that characterized the original 60 percent problem.

The automation should also include a weekly pipeline health report that calculates the percentage of deals older than 90 days, the average deal age, and the number of deals approaching the 90-day threshold. Distribute this report to the sales team every Monday morning. When reps see the metrics trending upward, they self-correct because they know the review is coming. Over three to four months, these automated systems reduce the stale deal ratio from 60 percent to under 20 percent without requiring manual intervention.

How to Train Sales Reps on Pipeline Hygiene Discipline

Automation handles the mechanics of pipeline hygiene, but lasting change requires training reps to think differently about aged deals. Many reps view pipeline cleanup as an administrative burden imposed by management, not as a strategic tool that improves their own performance. Training should reframe this perspective by connecting pipeline hygiene directly to rep outcomes.

Start with a 90-minute workshop focused on the economics of stale deals. Present data showing that reps who maintain a clean pipeline with fewer than 20 percent deals older than 90 days typically achieve 15 to 25 percent higher win rates because they spend their time on active opportunities rather than zombie deals. Show the inverse: reps with high stale ratios spend 30 to 40 percent of their selling time on deals that have less than a 10 percent chance of closing. This reframes cleanup as time recovery, not busywork.

Next, teach a simple requalification script that reps can use without sounding aggressive or desperate. The script has three parts: a statement of observation ("I noticed we haven't connected in a while"), a direct question ("Is this still a priority for you?"), and a clear next step ("If it is, let's schedule 15 minutes this week. If not, I'll close this out so we can focus on what matters."). Role-play this script in pairs until it feels natural. Reps who practice this script report higher response rates because the tone is respectful and transparent rather than pushy.

Finally, establish a weekly 15-minute pipeline review within each rep's existing 1:1 with their manager. During this review, the rep presents their three oldest deals and answers two questions: "What evidence do you have that this deal will close in the next 30 days?" and "What is the specific next step and when will it happen?" If the rep cannot provide concrete answers, the manager moves the deal to a nurture or closed-lost pipeline during the meeting. This creates real-time accountability and prevents the slow drift that leads to 60 percent stale rates.

Reinforce this training with a monthly "pipeline health score" that each rep can see on a shared dashboard. The score combines their stale deal ratio, average deal age, and requalification completion rate. Reps who maintain a score above 80 percent for three consecutive months receive recognition in team meetings or a small incentive such as a gift card or extra PTO day. Over six months, this combination of training, accountability, and positive reinforcement transforms how reps manage their pipelines.

Measuring Pipeline Health with Leading Indicators

Most organizations measure pipeline health by total value and win rate, but these are lagging indicators that tell you what already happened. To prevent the 60 percent stale rate from recurring, you need leading indicators that flag problems before they compound.

The most actionable leading indicator is the aged deal ratio, calculated as the percentage of pipeline value or deal count that exceeds 90 days. A healthy ratio varies by sales cycle length, but for most B2B organizations with 30- to 60-day cycles, the target is under 20 percent. Track this weekly and set a hard ceiling at 25 percent. When the ratio exceeds that threshold, trigger an automatic pipeline review that pauses new deal creation until the aged deals are addressed.

The second leading indicator is stage velocity, measured as the average number of days deals spend in each pipeline stage. Export the last 30 closed-won deals and calculate the average time in each stage. If any stage shows an average dwell time that exceeds 30 days, that stage is a bottleneck requiring investigation. Common causes include insufficient resources for proposal creation, slow legal review, or unclear criteria for advancing to the next stage. Address the bottleneck directly rather than blaming reps for slow movement.

The third leading indicator is the requalification survival rate, calculated as the percentage of aged deals that survive requalification and remain in the active pipeline. A healthy survival rate is 20 to 40 percent. If your survival rate exceeds 50 percent, your requalification criteria are too lenient and you are keeping deals that should be closed. If your survival rate is below 15 percent, your initial qualification was too permissive and you need to tighten your top-of-funnel criteria.

Create a simple dashboard that displays these three metrics alongside total pipeline value and win rate. Share it in your weekly sales team meeting and include a trend line showing the previous four weeks. When reps see the aged deal ratio climbing, they self-correct because they know the review is coming. Over two to three months of consistent measurement and discussion, these leading indicators become the primary drivers of pipeline hygiene rather than afterthoughts.

Handling Long Sales Cycles Without Letting Deals Go Stale

Some organizations have legitimate long sales cycles—enterprise deals, government contracts, or complex medical device sales can take 12 to 18 months. In these environments, a blanket 90-day stale rule would eliminate healthy pipeline. The solution is to distinguish between natural long-cycle deals and deals that are stalled due to neglect.

Start by establishing a separate "long-cycle" pipeline stage for deals that have a documented reason for extended duration. The documentation must include the expected close date (beyond 90 days), the specific milestones that must be met before close, and the next scheduled touchpoint. Deals in this stage are exempt from the standard 90-day purge rule but are subject to a monthly milestone review. If a deal misses two consecutive milestone reviews without a documented reason, it moves back to the standard pipeline and becomes subject to the 90-day rule.

Next, define what constitutes meaningful activity for long-cycle deals. A meaningful activity is not a generic "check-in" email—it must be a specific action that advances the deal, such as a meeting with a new stakeholder, a product demo for a decision-maker, or receipt of a required document. Require reps to log these activities with a description of how they advanced the deal. If a long-cycle deal has no meaningful activity for 60 days, it is flagged for manager review regardless of its stage.

Finally, set a hard maximum for how long a deal can remain in the pipeline without closing. For most long-cycle organizations, this maximum is 18 to 24 months. Deals that exceed this maximum are automatically moved to a "recycle" pipeline where they must be fully requalified before re-entering the active pipeline. This prevents the extreme outliers that distort pipeline metrics and forecasting accuracy.

By creating a separate process for legitimate long-cycle deals, you preserve the discipline of the 90-day rule for standard deals while accommodating the reality of complex sales. The key is documentation and milestone tracking—without these, every rep will claim their deals are "long-cycle" to avoid cleanup.

FAQ

What's the first step to clean up a pipeline with 60% deals older than 90 days? Segment those aged deals into three buckets: active engagement within 14 days, stalled with no recent contact, and dead with no response to outreach attempts. This focuses your team's energy on deals that still have a realistic path forward.

How do I decide which old deals to keep versus remove? Score each aged deal on recent buyer activity and alignment with your ideal customer profile. Deals with zero activity in the past 30 days and poor fit are safe to archive. Deals with recent engagement and strong fit deserve requalification.

Should I automatically delete all deals over 90 days old? No—some long-cycle industries have legitimate deals that take longer. Instead, set a 120-day hard maximum without meaningful activity as the trigger for automatic removal, with manager override available for documented long-cycle deals.

How often should I repeat this cleanup process? Run a full requalification blitz quarterly for all deals over 90 days. Implement weekly automated alerts for deals approaching 60 days without activity. Monthly manager reviews catch problems before they compound into 60% stale rates.

What metrics should I track after cleaning up? Monitor your aged deal ratio (target under 20%), stage velocity (target under 30 days per stage), requalification survival rate (target 20-40%), and pipeline coverage ratio (target 3x quota). Share these weekly in team meetings.

How do I prevent deals from aging out again? Implement mandatory weekly updates for any deal older than 60 days, requiring a specific next step or reason for extension. Configure CRM automation to flag deals at 60 days, require manager review at 75 days, and auto-purge at 120 days.

Sources

flowchart TD A[Deal Created] --> B["Stage 1: Qualification"] B --> C{30 Days in Stage?} C -->|Yes| D[Flag for Manager Review] C -->|No| E[Advance to Discovery] D --> F{Activity Logged?} F -->|Yes| E F -->|No| G[Auto-Notify Rep + Manager] E --> H["Stage 2: Discovery"] H --> I{45 Days in Stage?} I -->|Yes| J[Require Economic Buyer Confirmation] I -->|No| K[Advance to Proposal] J --> L{Confirmed?} L -->|Yes| K L -->|No| M[Move to Nurture Pipeline] K --> N["Stage 3: Proposal Sent"] N --> O{60 Days in Stage?} O -->|Yes| P[Auto-Purge to Closed-Lost] O -->|No| Q[Advance to Negotiation] P --> R[Notify Rep + Manager] Q --> S["Stage 4: Negotiation"] S --> T{90 Days in Stage?} T -->|Yes| U[Manager Override Required] T -->|No| V[Close-Won] U --> W{Override Approved?} W -->|Yes| S W -->|No| X[Move to Closed-Lost]

flowchart TD A[Pipeline Health Dashboard] --> B[Aged Deal Ratio] A --> C[Stage Velocity] A --> D[Requalification Survival Rate] B --> E{Under 20%?} E -->|Yes| F[Healthy - Continue Monitoring] E -->|No| G[Trigger Pipeline Review] G --> H[Pause New Deal Creation] H --> I[Assign Aged Deals for Requalification] I --> J[Track Survival Rate] C --> K{Any Stage Over 30 Days?} K -->|Yes| L[Investigate Bottleneck] L --> M[Root Cause Analysis] M --> N[Implement Process Change] N --> O[Re-measure Velocity in 30 Days] K -->|No| P[Normal Velocity] D --> Q{Survival Rate 20-40%?} Q -->|Yes| R[Healthy Requalification] Q -->|No, Below 15%| S[Tighten Top-of-Funnel Criteria] Q -->|No, Above 50%| T[Strengthen Requalification Standards] S --> U[Update Qualification Framework] T --> V[Retrain Reps on Criteria] U --> W[Monitor Next Quarter] V --> W

Related on PULSE

[How do I clean a CRM that has 5 years of bad data?](/knowledge/q113)
[What is a stage aging report — and how do you use it to clean pipeline?](/knowledge/q10871)
[How do I tell the difference between a stalled deal and a dead deal?](/knowledge/q36)
[What specific data points must RevOps clean before feeding them to an AI predictive lead model?](/knowledge/q16577)
[How Do I Stop CRM Data Decay and Keep My Database Clean in 2027?](/knowledge/q16206)
[What's a realistic sales tech stack for a $20M ARR SaaS in 2026?](/knowledge/q107)

Download:

## Direct Answer

Clean a pipeline with 60% deals older than 90 days by segmenting them by cause—buyer inaction, internal neglect, or dead deals—then enforcing a 14-day requalification deadline with automatic removal for non-response, followed by weekly pipeline reviews that flag any deal over 90 days without recent activity for mandatory manager assessment.

## Why Stale Deals Accumulate and How to Diagnose the Root Cause

A pipeline where 60% of deals exceed 90 days rarely appears overnight. It builds gradually through a combination of weak qualification criteria, insufficient stage-gate enforcement, and behavioral biases that cause sales reps to hold onto opportunities long after they have gone cold. Understanding why these deals accumulate is the first step toward a durable cleanup.

The most common root causes include qualification frameworks that are too permissive at the top of the funnel, allowing leads that lack budget, authority, need, or timeline to enter the pipeline and linger indefinitely. Another frequent contributor is the absence of mandatory stage progression rules—deals can sit in "negotiation" or "proposal sent" for months without any system forcing a status change. Reps also exhibit optimism bias, consistently overestimating the probability of closing aged opportunities because they remember the initial enthusiasm but ignore the months of silence that followed.

To diagnose which root cause dominates your pipeline, run a simple audit. Export all deals older than 90 days and tag each with the last meaningful activity date, the current stage, and the primary reason for stalling—buyer went dark, internal champion left, budget was cut, or no follow-up was attempted. If more than half of stalled deals show no activity in the last 30 days, your problem is likely process enforcement. If most show sporadic activity but no stage progression, your qualification gates are too weak. If reps cannot articulate why the deal is still open, you have a data hygiene issue that requires immediate archival.

This diagnosis directly informs your cleanup approach. Process enforcement problems need automation and manager oversight. Weak qualification gates require retraining on frameworks like MEDDPICC or BANT. Data hygiene issues demand a one-time purge with clear criteria for what stays and what goes. Without this diagnostic step, you risk cleaning the pipeline only to watch it refill with the same type of stale deals within two quarters.

## The 14-Day Requalification Protocol for Aged Deals

Once you have diagnosed the root causes, execute a structured requalification protocol that forces a decision on every deal older than 90 days within a fixed two-week window. This protocol has three phases: outreach, assessment, and disposition.

**Phase 1: Outreach.** Every rep responsible for aged deals sends a standardized email or places a call to their contacts. The message is direct and transparent: "We noticed your opportunity has been open for [X] days. Is this still a priority for you in the next 30 days? If not, we will close it out to keep our records accurate." This removes ambiguity and gives the buyer a low-friction way to confirm interest or disengage. Reps must log the outreach attempt in the CRM within 48 hours. If the buyer does not respond within five business days, the deal automatically moves to a "pending closure" queue.

**Phase 2: Assessment.** For buyers who respond positively, the rep schedules a 15-minute call to requalify using four criteria: is the decision-maker still the same person, is the budget still allocated, has the need changed, and is the timeline still within 30 to 60 days. If any of these four elements is missing or uncertain, the deal drops to a lower stage or moves to a nurture pipeline. The rep documents the call outcome directly in the CRM with a required field for each criterion.

**Phase 3: Disposition.** Deals that pass requalification remain in the active pipeline with a new stage and a specific next step due within 14 days. Deals that fail requalification are moved to closed-lost with a reason code—budget removed, no response, champion left, or no longer a priority. Deals where the buyer expressed interest but could not commit to a timeline go to a nurture pipeline with a 90-day re-engagement reminder. This three-way disposition ensures no deal remains in limbo.

The 14-day timeline is critical because it creates urgency without being arbitrary. Research from sales analytics platforms consistently shows that deals older than 90 days have a 60 to 80 percent lower close rate than deals under 30 days, so waiting longer to requalify only compounds the problem. The protocol also removes the emotional burden from reps by making the process systemic—they are following a rule, not admitting failure.

## Building CRM Automation to Prevent Pipeline Staleness

After the initial cleanup, the most important step is implementing CRM automation that prevents the 60 percent stale rate from recurring. Without automation, pipeline hygiene depends entirely on human discipline, which historically fails within 60 to 90 days of any cleanup initiative.

Start by configuring stage aging alerts in your CRM. Set a rule that flags any deal that remains in the same stage for more than 30 days without a stage change or logged activity. The alert should notify both the rep and their direct manager via email or in-app notification. This creates immediate visibility into deals that are beginning to stall, rather than discovering them months later. Most CRM platforms—Salesforce, HubSpot, Pipedrive, and Zoho—support this natively through workflow rules or automation builders.

Next, establish hard stage gates that require specific criteria to be met before a deal can advance. For example, a deal cannot move from "qualification" to "discovery" without a confirmed conversation with the economic buyer. It cannot move from "proposal sent" to "negotiation" without a verbal commitment to proceed. These gates should be enforced through required fields or document uploads in the CRM. When a rep tries to advance a deal without meeting the criteria, the system blocks the stage change and displays the missing requirements.

Finally, create an automatic pipeline purge rule for deals that exceed 120 days without any logged activity. This rule moves the deal to a closed-lost or nurture pipeline automatically, with a notification to the rep and manager explaining the action. The rep can override the purge only with manager approval and a documented reason for keeping the deal alive. This hard boundary prevents the slow accumulation of zombie deals that characterized the original 60 percent problem.

The automation should also include a weekly pipeline health report that calculates the percentage of deals older than 90 days, the average deal age, and the number of deals approaching the 90-day threshold. Distribute this report to the sales team every Monday morning. When reps see the metrics trending upward, they self-correct because they know the review is coming. Over three to four months, these automated systems reduce the stale deal ratio from 60 percent to under 20 percent without requiring manual intervention.

```mermaid
flowchart TD
    A[Deal Created] --> B[Stage 1: Qualification]
    B --> C{30 Days in Stage?}
    C -->|Yes| D[Flag for Manager Review]
    C -->|No| E[Advance to Discovery]
    D --> F{Activity Logged?}
    F -->|Yes| E
    F -->|No| G[Auto-Notify Rep + Manager]
    E --> H[Stage 2: Discovery]
    H --> I{45 Days in Stage?}
    I -->|Yes| J[Require Economic Buyer Confirmation]
    I -->|No| K[Advance to Proposal]
    J --> L{Confirmed?}
    L -->|Yes| K
    L -->|No| M[Move to Nurture Pipeline]
    K --> N[Stage 3: Proposal Sent]
    N --> O{60 Days in Stage?}
    O -->|Yes| P[Auto-Purge to Closed-Lost]
    O -->|No| Q[Advance to Negotiation]
    P --> R[Notify Rep + Manager]
    Q --> S[Stage 4: Negotiation]
    S --> T{90 Days in Stage?}
    T -->|Yes| U[Manager Override Required]
    T -->|No| V[Close-Won]
    U --> W{Override Approved?}
    W -->|Yes| S
    W -->|No| X[Move to Closed-Lost]
```

## How to Train Sales Reps on Pipeline Hygiene Discipline

Automation handles the mechanics of pipeline hygiene, but lasting change requires training reps to think differently about aged deals. Many reps view pipeline cleanup as an administrative burden imposed by management, not as a strategic tool that improves their own performance. Training should reframe this perspective by connecting pipeline hygiene directly to rep outcomes.

Start with a 90-minute workshop focused on the economics of stale deals. Present data showing that reps who maintain a clean pipeline with fewer than 20 percent deals older than 90 days typically achieve 15 to 25 percent higher win rates because they spend their time on active opportunities rather than zombie deals. Show the inverse: reps with high stale ratios spend 30 to 40 percent of their selling time on deals that have less than a 10 percent chance of closing. This reframes cleanup as time recovery, not busywork.

Next, teach a simple requalification script that reps can use without sounding aggressive or desperate. The script has three parts: a statement of observation ("I noticed we haven't connected in a while"), a direct question ("Is this still a priority for you?"), and a clear next step ("If it is, let's schedule 15 minutes this week. If not, I'll close this out so we can focus on what matters."). Role-play this script in pairs until it feels natural. Reps who practice this script report higher response rates because the tone is respectful and transparent rather than pushy.

Finally, establish a weekly 15-minute pipeline review within each rep's existing 1:1 with their manager. During this review, the rep presents their three oldest deals and answers two questions: "What evidence do you have that this deal will close in the next 30 days?" and "What is the specific next step and when will it happen?" If the rep cannot provide concrete answers, the manager moves the deal to a nurture or closed-lost pipeline during the meeting. This creates real-time accountability and prevents the slow drift that leads to 60 percent stale rates.

Reinforce this training with a monthly "pipeline health score" that each rep can see on a shared dashboard. The score combines their stale deal ratio, average deal age, and requalification completion rate. Reps who maintain a score above 80 percent for three consecutive months receive recognition in team meetings or a small incentive such as a gift card or extra PTO day. Over six months, this combination of training, accountability, and positive reinforcement transforms how reps manage their pipelines.

## Measuring Pipeline Health with Leading Indicators

Most organizations measure pipeline health by total value and win rate, but these are lagging indicators that tell you what already happened. To prevent the 60 percent stale rate from recurring, you need leading indicators that flag problems before they compound.

The most actionable leading indicator is the aged deal ratio, calculated as the percentage of pipeline value or deal count that exceeds 90 days. A healthy ratio varies by sales cycle length, but for most B2B organizations with 30- to 60-day cycles, the target is under 20 percent. Track this weekly and set a hard ceiling at 25 percent. When the ratio exceeds that threshold, trigger an automatic pipeline review that pauses new deal creation until the aged deals are addressed.

The second leading indicator is stage velocity, measured as the average number of days deals spend in each pipeline stage. Export the last 30 closed-won deals and calculate the average time in each stage. If any stage shows an average dwell time that exceeds 30 days, that stage is a bottleneck requiring investigation. Common causes include insufficient resources for proposal creation, slow legal review, or unclear criteria for advancing to the next stage. Address the bottleneck directly rather than blaming reps for slow movement.

The third leading indicator is the requalification survival rate, calculated as the percentage of aged deals that survive requalification and remain in the active pipeline. A healthy survival rate is 20 to 40 percent. If your survival rate exceeds 50 percent, your requalification criteria are too lenient and you are keeping deals that should be closed. If your survival rate is below 15 percent, your initial qualification was too permissive and you need to tighten your top-of-funnel criteria.

Create a simple dashboard that displays these three metrics alongside total pipeline value and win rate. Share it in your weekly sales team meeting and include a trend line showing the previous four weeks. When reps see the aged deal ratio climbing, they self-correct because they know the review is coming. Over two to three months of consistent measurement and discussion, these leading indicators become the primary drivers of pipeline hygiene rather than afterthoughts.

```mermaid
flowchart TD
    A[Pipeline Health Dashboard] --> B[Aged Deal Ratio]
    A --> C[Stage Velocity]
    A --> D[Requalification Survival Rate]
    B --> E{Under 20%?}
    E -->|Yes| F[Healthy - Continue Monitoring]
    E -->|No| G[Trigger Pipeline Review]
    G --> H[Pause New Deal Creation]
    H --> I[Assign Aged Deals for Requalification]
    I --> J[Track Survival Rate]
    C --> K{Any Stage Over 30 Days?}
    K -->|Yes| L[Investigate Bottleneck]
    L --> M[Root Cause Analysis]
    M --> N[Implement Process Change]
    N --> O[Re-measure Velocity in 30 Days]
    K -->|No| P[Normal Velocity]
    D --> Q{Survival Rate 20-40%?}
    Q -->|Yes| R[Healthy Requalification]
    Q -->|No, Below 15%| S[Tighten Top-of-Funnel Criteria]
    Q -->|No, Above 50%| T[Strengthen Requalification Standards]
    S --> U[Update Qualification Framework]
    T --> V[Retrain Reps on Criteria]
    U --> W[Monitor Next Quarter]
    V --> W
```

## Handling Long Sales Cycles Without Letting Deals Go Stale

Some organizations have legitimate long sales cycles—enterprise deals, government contracts, or complex medical device sales can take 12 to 18 months. In these environments, a blanket 90-day stale rule would eliminate healthy pipeline. The solution is to distinguish between natural long-cycle deals and deals that are stalled due to neglect.

Start by establishing a separate "long-cycle" pipeline stage for deals that have a documented reason for extended duration. The documentation must include the expected close date (beyond 90 days), the specific milestones that must be met before close, and the next scheduled touchpoint. Deals in this stage are exempt from the standard 90-day purge rule but are subject to a monthly milestone review. If a deal misses two consecutive milestone reviews without a documented reason, it moves back to the standard pipeline and becomes subject to the 90-day rule.

Next, define what constitutes meaningful activity for long-cycle deals. A meaningful activity is not a generic "check-in" email—it must be a specific action that advances the deal, such as a meeting with a new stakeholder, a product demo for a decision-maker, or receipt of a required document. Require reps to log these activities with a description of how they advanced the deal. If a long-cycle deal has no meaningful activity for 60 days, it is flagged for manager review regardless of its stage.

Finally, set a hard maximum for how long a deal can remain in the pipeline without closing. For most long-cycle organizations, this maximum is 18 to 24 months. Deals that exceed this maximum are automatically moved to a "recycle" pipeline where they must be fully requalified before re-entering the active pipeline. This prevents the extreme outliers that distort pipeline metrics and forecasting accuracy.

By creating a separate process for legitimate long-cycle deals, you preserve the discipline of the 90-day rule for standard deals while accommodating the reality of complex sales. The key is documentation and milestone tracking—without these, every rep will claim their deals are "long-cycle" to avoid cleanup.

## Related questions

### How do I tell the difference between a stalled deal and a dead deal?

A stalled deal has recent activity within 30 days, a known next step, and a responsive buyer. A dead deal has no activity for 60+ days, an unresponsive buyer, or a confirmed change in budget or priority. Requalify stalled deals; archive dead deals.

### What metrics should I track after cleaning my pipeline?

Track aged deal ratio (target under 20%), stage velocity (target under 30 days per stage), requalification survival rate (target 20-40%), and pipeline coverage ratio (target 3x quota). Review these weekly in team meetings.

### How often should I run a pipeline cleanup?

Run a full requalification blitz quarterly for all deals over 90 days. Implement weekly automated alerts for deals approaching 60 days without activity. Monthly manager reviews catch problems before they compound.

### What CRM automation helps prevent stale deals?

Configure stage aging alerts at 30 days, require activity logging for stage progression, set hard 120-day auto-purge rules with manager override, and distribute weekly pipeline health reports to the entire sales team.

## FAQ

**What's the first step to clean up a pipeline with 60% deals older than 90 days?**
Segment those aged deals into three buckets: active engagement within 14 days, stalled with no recent contact, and dead with no response to outreach attempts. This focuses your team's energy on deals that still have a realistic path forward.

**How do I decide which old deals to keep versus remove?**
Score each aged deal on recent buyer activity and alignment with your ideal customer profile. Deals with zero activity in the past 30 days and poor fit are safe to archive. Deals with recent engagement and strong fit deserve requalification.

**Should I automatically delete all deals over 90 days old?**
No—some long-cycle industries have legitimate deals that take longer. Instead, set a 120-day hard maximum without meaningful activity as the trigger for automatic removal, with manager override available for documented long-cycle deals.

**How often should I repeat this cleanup process?**
Run a full requalification blitz quarterly for all deals over 90 days. Implement weekly automated alerts for deals approaching 60 days without activity. Monthly manager reviews catch problems before they compound into 60% stale rates.

**What metrics should I track after cleaning up?**
Monitor your aged deal ratio (target under 20%), stage velocity (target under 30 days per stage), requalification survival rate (target 20-40%), and pipeline coverage ratio (target 3x quota). Share these weekly in team meetings.

**How do I prevent deals from aging out again?**
Implement mandatory weekly updates for any deal older than 60 days, requiring a specific next step or reason for extension. Configure CRM automation to flag deals at 60 days, require manager review at 75 days, and auto-purge at 120 days.

## Sources

- https://www.gartner.com/en/sales/insights/sales-pipeline-management
- https://hbr.org/2020/01/how-to-clean-up-your-sales-pipeline
- https://blog.hubspot.com/sales/pipeline-cleanup
- https://www.forrester.com/blogs/category/b2b-sales/
- https://www.salesforce.com/resources/articles/pipeline-management/
- https://www.gong.io/resources/sales-pipeline-best-practices/
- https://www.joinpavilion.com/research
- https://www.bridgegroupinc.com/research

## Related on PULSE

- [How do I clean a CRM that has 5 years of bad data?](/knowledge/q113)
- [What is a stage aging report — and how do you use it to clean pipeline?](/knowledge/q10871)
- [How do I tell the difference between a stalled deal and a dead deal?](/knowledge/q36)
- [What specific data points must RevOps clean before feeding them to an AI predictive lead model?](/knowledge/q16577)
- [How Do I Stop CRM Data Decay and Keep My Database Clean in 2027?](/knowledge/q16206)
- [What's a realistic sales tech stack for a $20M ARR SaaS in 2026?](/knowledge/q107)

Was this helpful?

Sources cited

clari.comhttps://www.clari.com/blog/sales-pipeline-management/gong.iohttps://www.gong.io/blog/sales-pipeline/gartner.comhttps://www.gartner.com/en/sales/research bvp.comhttps://www.bvp.com/atlas/state-of-the-cloud-2026 news.crunchbase.comhttps://news.crunchbase.com/forcemanagement.comhttps://forcemanagement.com/meddpicc/

⌬ Apply this in PULSE

Free CRM · Revenue IntelligenceAudit pipeline, score reps, ship the fix

Kory White

What's the right way to clean up a pipeline that has 60% deals older than 90 days?

Why Stale Deals Accumulate and How to Diagnose the Root Cause

The 14-Day Requalification Protocol for Aged Deals

Building CRM Automation to Prevent Pipeline Staleness

How to Train Sales Reps on Pipeline Hygiene Discipline

Measuring Pipeline Health with Leading Indicators

Handling Long Sales Cycles Without Letting Deals Go Stale

Related questions

How do I tell the difference between a stalled deal and a dead deal?

What metrics should I track after cleaning my pipeline?

How often should I run a pipeline cleanup?

What CRM automation helps prevent stale deals?

FAQ

Sources

Related on PULSE

Two scores — Gate vs IQ