Pipeline Aging Heatmap

Recolor it to your brand

Use the color picker above to recolor this graphic to your team or company colors, switch the background (including transparent), then download it as an SVG or PNG. No sign-up, no watermark.

How to use it

The SVG scales to any size with no quality loss — drop it straight into PowerPoint, Google Slides, Canva, Figma, or a LinkedIn banner slot. The PNG export is ready to upload anywhere that wants a raster image.

More free graphics

Browse the full [Pulse Graphics library](/graphics) — banners, slides, printables, quote cards, and clip art you can borrow for your own decks and posts.

Related on PULSE

• [Pipeline Health Dashboard](/knowledge/gb0520)
• [Pipeline Coverage Gauge](/knowledge/gb0504)
• [Forecast First, Pipeline Second — Banner](/knowledge/gb0461)
• [Pipeline Council — Team Banner](/knowledge/gb0444)
• [Pipeline is oxygen — RevOps Mindset Banner](/knowledge/gb0426)
• [Pipeline Stages — Icon / Clip Art](/knowledge/gb0019)

How to Read a Pipeline Aging Heatmap: Spotting the Signals Before They Become Problems

A pipeline aging heatmap is more than a colorful grid — it's a diagnostic tool that reveals the health of your sales process at a glance. The color coding (green, yellow, orange, red) maps to the number of days a deal has lingered in a given stage. The key is learning to interpret the patterns, not just the colors.

Green (0–14 days in stage) indicates healthy velocity — deals moving as expected with active engagement on both sides. Yellow (15–30 days) is a caution signal: still alive, but momentum may be slipping. Orange (31–45 days) suggests a deal that's stalling, often due to procurement delays, budget freezes, or a champion who's gone quiet. Red (46+ days) is a critical warning: high risk of churn or being overtaken by a competitor. Treat these bands as illustrative defaults; calibrate the exact cutoffs to your own stage-level cycle times.

The most valuable insight comes from comparing stages. If your demo stage is consistently yellow or orange but your negotiation stage is green, that points to a qualification or discovery problem — reps are pushing unqualified leads into demos, then struggling to advance them. Conversely, if demos are green but negotiation is red, the issue is likely pricing, contract complexity, or a mismatch between your solution and the buyer's budget.

A common blind spot is the "dead zone" — deals that sit in a stage for 60+ days but are still marked "open." These often represent opportunities that should be closed-lost but are kept alive for pipeline optics. A good rule of thumb: any deal beyond 45 days in a stage should trigger an automatic review by the sales manager or deal desk. Some teams set a hard cutoff at 60 days, after which the deal moves to a "stalled" category unless the rep provides a written justification with a specific next step and date.

Another pattern to watch for is "stage hopping" — deals that bounce back and forth between stages (e.g., from negotiation back to discovery). This often indicates scope creep, a lost champion, or a buyer restarting their evaluation. A heatmap showing multiple red cells for the same deal across different stages is a strong signal the deal is unlikely to close.

To make the heatmap actionable, pair it with a velocity metric: average days per stage for won deals versus lost deals. If your won deals average 10 days in demo but your current heatmap shows 25 days in demo for active deals, you have a leading indicator of lower win rates ahead. That lets you intervene before deals turn red — for example, by scheduling a call with the economic buyer or sending a case study that addresses a specific objection.

Common Pipeline Aging Heatmap Pitfalls and How to Avoid Them

Even experienced sales leaders misread a pipeline aging heatmap. Here are the most frequent mistakes and how to correct them.

Pitfall 1: Treating all red as equal. A deal that's been red for 10 days is very different from one red for 60 days. Instead of a single "red" threshold, use graduated alerts: orange at 31 days, red at 46 days, and "critical" at 60+ days. This prevents overreacting to deals that are merely slow versus those that are truly stuck.

Pitfall 2: Ignoring stage-specific benchmarks. A 30-day stay in "proposal" may be normal for enterprise deals with complex procurement, but the same duration in "discovery" is a red flag. Set different aging thresholds per stage based on your historical data. For example:

• Discovery: 7 days max
• Demo: 14 days max
• Proposal: 21 days max
• Negotiation: 14 days max
• Contract: 7 days max

Review these benchmarks quarterly and adjust them to your average deal-cycle length.

Pitfall 3: Focusing only on the oldest deals. It's tempting to fixate on the reddest cells, but the most impactful saves often come from catching deals in the yellow zone. A deal that's been in demo for 20 days can frequently be rescued with a simple follow-up or value-add asset. Once it's red, the buyer may already have gone dark or chosen another vendor. Set automated alerts for any deal crossing the 20-day mark in any stage, not just the 45-day threshold.

Pitfall 4: Using the heatmap in isolation. It tells you *where* deals are stuck, not *why*. Always cross-reference deal notes, activity logs, and call recordings. A deal red in negotiation might be waiting on external legal review (often unavoidable), while a deal red in discovery is likely a qualification failure. Without context, you risk misdiagnosing the problem.

Pitfall 5: Not segmenting by deal size or buyer persona. A $50k deal in proposal for 30 days is very different from a $500k deal in the same stage — larger deals naturally take longer. Create separate heatmaps (or filters) for deal tiers: SMB (under $50k), mid-market ($50k–$250k), and enterprise ($250k+), each with its own aging thresholds. Likewise, segment by persona — a CFO-led deal moves differently than a department-head-led one.

Pitfall 6: Over-reliance on manual updates. If reps must manually update stages, the heatmap will always lag reality. Integrate your CRM with calendar and email to detect stage changes from meeting types, document sends, or signatures. If a rep sends a proposal via your CPQ tool, the deal should auto-advance to "proposal." That keeps the heatmap accurate without adding admin burden.

Pitfall 7: Ignoring the "ghost deals." These appear on the heatmap but have no recent activity — no calls, emails, or meetings in the last 14 days. They're effectively dead but never closed out. Run a weekly report flagging any deal in a stage more than 21 days with zero logged activity in the last 14, and require reps to either schedule a next step or move it to closed-lost.

Actionable Playbooks for Each Pipeline Aging Heatmap Zone

Once you know where deals are aging, you need a playbook for each zone. These aren't one-size-fits-all — tune them to your sales cycle — but they give you a starting framework.

Green Zone Playbook (0–14 days): Maintain momentum

• Objective: Keep the deal moving without over-pursuing.
• Actions: Send a meeting recap with clear next steps within 24 hours of each interaction. Use a mutual action plan both parties update after each meeting. Set the next meeting before the current one ends. Add a reminder to check in 5 days before the deal would hit yellow.
• Metrics to watch: Activity-to-meeting ratio (aim for roughly two touches per meeting). Time-to-next-step (under 3 days).
• Red flags: If a deal stays green but has no activity for 7+ days, it's likely stalled — treat it as yellow.

Yellow Zone Playbook (15–30 days): Re-engage and re-qualify

• Objective: Determine whether the deal is still viable or should be disqualified.
• Actions: Schedule a pulse-check call with the champion and ask three questions: (1) "What's changed since we last spoke?" (2) "Who else needs to be involved in this decision?" (3) "What's the one thing that would make this a priority this quarter?" If you can't get a meeting within 5 business days, escalate to a manager for a joint call. Send a case study or ROI calculator tailored to their industry.
• Metrics to watch: Response rate to the pulse check (target above 70%). Number of new stakeholders identified (target at least one).
• Decision point: If after 30 days you still don't have a clear timeline or budget, move the deal to a lower-priority "nurture" stage. Don't let it sit in yellow indefinitely.

Orange Zone Playbook (31–45 days): Escalate and create urgency

• Objective: Force a decision or exit gracefully.
• Actions: Involve a sales manager or executive sponsor for a call with the buyer's manager. Offer a pilot or proof of concept to reduce risk. Send a decision-deadline email outlining the consequences of delay (pricing changes, implementation slots filling up). For deals over $100k, schedule a face-to-face (virtual or in person). Prepare a close plan listing every remaining step and owner.
• Metrics to watch: Manager-involvement rate (target 100% for deals over $50k). Time to next executive touch (under 5 days).
• Decision point: If after 45 days there's no clear path to close within 30 days, move it to a "stalled" category. This keeps the deal from skewing your heatmap and forces a candid conversation with the buyer.

Red Zone Playbook (46+ days): Salvage or close-lost

• Objective: Either close within 30 days or remove from the pipeline.
• Actions: Run a deal-review board with sales leadership. Assign a "deal doctor" (a senior rep not involved in the deal) to audit the opportunity. Send a final offer with a 7-day expiration. If the buyer is unresponsive, send a breakup email — "I'm closing this out on my end; if you decide to move forward, here's how to reach me" — which often triggers a response. For deals that are clearly lost, close them as closed-lost with a reason code (budget, competition, no decision).
• Metrics to watch: Salvage rate (a realistic target is that around 20% of red deals close within 30 days of the review). Reason-code completion rate (target 100% so lost-deal data stays clean).
• Decision point: If there's no movement within 14 days of the deal-review board, close it lost and reallocate the rep's time to greener opportunities.

Sources

• HubSpot — *Sales Pipeline Management* guides and HubSpot Research on deal stages and pipeline velocity
• Salesforce — *What Is Sales Pipeline Management?* and Sales Cloud forecasting/pipeline-inspection documentation
• Gartner — Sales practice research on pipeline analytics, deal inspection, and forecast accuracy
• Harvard Business Review — articles on sales-pipeline management and B2B deal qualification
• Forrester — B2B Revenue Waterfall and pipeline/conversion benchmarking research
• McKinsey & Company — B2B sales growth and commercial-analytics insights on pipeline health

FAQ

What is a Pipeline Aging Heatmap? A pipeline aging heatmap is a color-coded grid that shows how long each open deal has sat in its current sales-pipeline stage. By shading cells from green to red based on days-in-stage, it lets teams spot stalled opportunities instantly and prioritize action by deal age and stage.

How do I interpret the colors on the heatmap? Green means a deal is progressing within the expected window, yellow warns it's starting to age, orange signals real stalling, and red flags a deal that's stuck and at risk. A common four-band default is 0–14 days (green), 15–30 (yellow), 31–45 (orange), and 46+ (red) — but you should calibrate those cutoffs to your own stage-level cycle times rather than treat them as fixed.

What data do I need to create this heatmap? At minimum, CRM records with each deal's current stage, the date it entered that stage, and its last activity date. To set meaningful color bands you also need stage-specific aging thresholds derived from your historical close rates and average days per stage.

How often should I update the heatmap? Most teams refresh it weekly or bi-weekly — frequent enough to catch trends without flooding managers with noise. Fast-moving, high-volume pipelines may justify daily updates, but weekly is the common sweet spot. Wherever possible, automate stage updates so the heatmap reflects reality instead of lagging behind manual data entry.

Can this heatmap predict which deals will close? It isn't a predictive model, but it's a strong early-warning system. Deals that age past your typical stage duration are statistically less likely to close, so the heatmap highlights which opportunities need intervention now — pair it with a win/loss velocity metric for sharper signal.

What's the best way to act on a red deal in the heatmap? Run a focused review with the rep to diagnose the stall — common causes are no access to the decision-maker, unresolved objections, or budget delays. Set one clear next step with a deadline and an owner, and if there's no progress within about two weeks, either move the deal to a nurture track or close it lost with a reason code so your data stays clean.