Pipeline Review

Systematically assess deal health, identify forecast risk, and surface actionable pipeline gaps using data-driven inspection frameworks rather than subjective gut-feel assessments.

Pre-Work Framework

Before analyzing your pipeline, the AI should ask:

1. What time period are we forecasting? — Are you reviewing for this month, quarter, or year? Is this for deal-specific risk or for overall forecast accuracy? Monthly reviews focus on deal velocity and aging; quarterly reviews focus on coverage ratios and win rates.

2. What does your pipeline data look like? — Do you have deal names, stages, expected values, close dates, and activity history? Is it in a CRM export, a spreadsheet, or just the rep's verbal description? Data completeness shapes the analysis depth. Minimal data gets trend identification; complete data gets stage velocity analysis.

3. What's your historical conversion rate by stage? — If you know your stage probabilities (e.g., 60% of qualified deals close, 30% of proposals close), the forecast gets weighted to your actual win patterns. If not, the analysis assumes default probabilities: early-stage 20%, mid-stage 50%, late-stage 80%.

4. Who else is in this review? — Is this a solo rep review, a team manager meeting, or an executive forecast? The output changes: solo reviews highlight individual action items and re-engagement tactics; manager reviews highlight team patterns and coaching opportunities; executive reviews focus on risk concentration and trend forecasts.

5. What's at risk of slipping this cycle? — Are there specific deals you're already worried about, or should we flag them from the data? This shapes priority flagging and determines which deals get detailed re-engagement strategies.

Core Principles

Principle 1: Movement Over Time Rule: A deal's health is measured by its momentum, not its stage. A deal stuck in the same stage for 6 weeks is at higher risk than a deal that just entered late-stage 2 weeks ago, even if the stuck deal is technically further along. Movement signals engagement; stagnation signals hesitation, budget freeze, or lower priority on the prospect's side. Always compare current stage duration against your historical average for that stage. If a deal has 60% more days in qualification than the typical deal, that's a yellow flag. 100% more days is red. Movement patterns also reveal forecast realism: reps often round to nice close dates (end-of-month, end-of-quarter) rather than basing them on actual prospect decision timelines. Compare the rep's close date to the deal's actual stage duration to catch over-optimism. For example, a deal that entered qualification 35 days ago with a close date of "30 days from now" (45 days total) is artificially accelerated if your typical qualification + proposal + negotiation cycle takes 90 days. The math reveals the risk hidden in the rep's optimism.

Principle 2: Conviction Requires Evidence Rule: Every deal in your commit forecast must cite specific proof of qualification and economic buyer engagement. Conviction cannot be feelings or instinct. A deal earns commit-level confidence through: confirmed decision criteria met (you know what they're deciding on and the criteria are your favor), economic buyer engaged (you've spoken with or have clear visibility to the budget owner), verbal commitment received (not just "interest," but explicit next steps and timeline agreement), and procurement process initiated (they've moved from evaluation to implementation planning). If a deal checks fewer than 3 of these 4 boxes, it belongs in best-case or weighted, not commit. This principle prevents forecast surprise: deals collapse at close time because commitment was assumed, not validated.

Principle 3: Activity = Engagement Rule: No meaningful activity in 14+ days means the deal has stalled, regardless of stage. A deal that has been silent for two weeks has dropped priority on the prospect's side. Silence does not mean "they're thinking it over." It means "you've fallen out of their active evaluation flow." In pipeline reviews, flag any deal without emails, calls, or meetings in the past 14 days as Yellow (trending down) or Red (if combined with other risk factors like pushed close dates). Use activity history as a leading indicator of deal health before the rep themselves knows it's deteriorating. Sales cycles move through decision-makers' calendars: they meet, they ask questions, they request info, they push back, they involve procurement. Lack of activity indicates the cycle has stalled.

Principle 4: Concentration Risk Breaks Forecasts Rule: No single deal should represent more than 15% of your monthly forecast or 10% of your quarterly forecast. If one deal is 30% of your quarterly target and it slips, your forecast becomes unattainable. Flag concentration immediately. The antidote is not wishful thinking about one big deal closing; it is accelerating early-stage deals or requalifying stalled deals to have multiple paths to your number. When you have concentration risk, forecast conservatively (commit forecast only) and get explicit from your manager about your backup plan.

Principle 5: Re-Engagement Actions Are Specific, Not Generic Rule: Every stalled deal gets a named action with a specific next step, not a vague follow-up. "Follow up on the deal" is not an action plan—it will get lost. Instead: "Send a value-add email by Tuesday citing their recent earnings call mention of cost reduction, then schedule a 15-minute agenda-driven call with the CFO's EA for next week to discuss procurement timeline." Specificity makes execution happen. It also makes accountability clear: if the rep does not complete the specific action, they own the slip.

Principle 6: Forecast Scenarios Are Decision Tools, Not Wish Lists Rule: Weighted and best-case forecasts should differ in specific ways, not just "hopes for more deals." Weighted forecast = stage probability × deal value. Best-case = weighted forecast + deals with 3+ conviction signals + deals with very recent positive momentum. Commit = only deals with all 4 conviction signals met. Each tier should be defensible to your manager. If you cannot explain why a deal jumped from weighted to best-case, it does not belong there. Use scenarios to show decision paths: "If deals A and B close on time and deal C closes early, we're at 120% of target. If deals A and B slip 2 weeks and C closes on time, we're at 85%." Scenarios make risks visible and actionable.

The Process

Phase 1: Data Collection & Normalization (Entry: Raw pipeline data; Exit: Clean, structured deal list)

Gather pipeline data in whatever format the rep or team has it: CRM export, spreadsheet, verbal list. Do not require perfect format. At minimum, extract: deal name, prospect company, stage, expected value, close date, and any activity history available. If the data is missing close dates or values, ask clarifying questions: "Is this deal early-stage or ready to close?" gets translated to an assumed close timeframe and probability. If a rep can explain a deal but cannot estimate the value, use a placeholder and note it.

Normalize the data into a consistent structure:

• Deal Name (text)
• Stage (use the rep's pipeline stages, e.g., Qualified, Proposal, Negotiation, Closing)
• Expected Value (numeric)
• Close Date (target close date, in date format)
• Days in Stage (close date minus the date the deal entered that stage)
• Last Activity Date (most recent email, call, or meeting)
• Days Since Activity (today minus last activity date)
• Activity Count (last 30 days)
• Stakeholders Engaged (names/titles of people you've spoken with)
• Qualification Status (are decision criteria known? Is budget confirmed? Is procurement aware?)
• Close Date Changes (has this close date moved? How many times?)

If you lack some fields, note gaps and continue. Do not stop the analysis because the data is imperfect—incomplete data still reveals patterns.

Phase 2: Deal Health Assessment (Entry: Structured deal list; Exit: Health score matrix with flags)

For each deal, assign a health score: Green, Yellow, or Red. Health scoring combines multiple factors, and a single Red factor on any dimension (activity, stage duration, qualification, stakeholders) is sufficient to flag the deal as high-risk. A deal does not need to fail on multiple factors to be Red—it only needs to fail on one critical dimension.

Green (Healthy):

• Days in stage is ≤1.5x the typical stage duration for that stage (meaning forward motion is on pace)
• Days since last activity is <7 (meaning engagement is current and recent)
• Close date has not moved (showing the deal is on the original track)
• At least 2 stakeholder types engaged (e.g., champion and economic buyer, or technical buyer and procurement, ensuring multiple voices are supportive)
• Qualification status is complete (decision criteria known, budget confirmed, procurement aware)

A Green deal is one where you have visibility into decision-making, momentum is positive, and the next steps are clear. These deals should get minimal intervention in a pipeline review—they need support, not rescue.

Yellow (Caution):

• Days in stage is 1.5x-2x the typical stage duration (moving slowly but not stalled), OR
• Days since last activity is 7-14 (activity has slowed but not gone silent), OR
• Close date moved once (one reset, not a pattern), OR
• Only one stakeholder type engaged (you have a champion but missing economic buyer or procurement), OR
• Qualification status is partial (you know decision criteria but not budget confirmation, or vice versa)

Yellow deals need attention but are not yet critical. They typically need one de-risking action: engage the missing stakeholder, get the qualification gap closed, or reinvigorate activity with a specific value-add conversation. Yellow deals are where you should focus most of your pipeline review effort—they are the ones closest to sliding into Red.

Red (High Risk):

• Days in stage is >2x the typical stage duration (deal is stalled relative to historical pace), OR
• Days since last activity is >14 (two weeks of silence indicates they have deprioritized), OR
• Close date moved more than once (pattern of delay, suggesting timeline was never realistic), OR
• No stakeholders engaged in the past 30 days (decision-makers have gone dark), OR
• Qualification status is incomplete (decision criteria unknown or budget unconfirmed, meaning you are guessing at close likelihood)

Red deals require immediate action. They are at risk of slipping entirely or requiring aggressive re-engagement to get back on track.

For each Red deal, generate a specific re-engagement action. Do not say "follow up"—say "Send a competitive intelligence email by Tuesday highlighting their market opportunity, then schedule a 20-minute business case review with the CFO's chief of staff for Thursday to discuss implementation timeline and budget allocation. If no response by Friday EOD, escalate to the champion and ask for a reset call." Specificity drives execution, creates accountability, and surfaces the exact blocker.

For Yellow deals, note the primary risk factor: is it lack of activity (contact gap), extended stage duration (timeline risk), stakeholder gaps (decision-making visibility), or qualification gaps (missing confirmation)? Identifying the primary risk focuses the rep's coaching on the most leveraged action. A deal stuck for 45 days needs a reset conversation with the champion. A deal missing the CFO needs executive champion involvement to make the intro. A deal with no activity needs a value-add re-entry, not another generic "How's it going?" email.

Phase 3: Pipeline-Level Analytics (Entry: Health score matrix; Exit: Pipeline strength assessment)

Calculate pipeline metrics:

• Total Pipeline Value: Sum of all deal values
• Coverage Ratio: Total pipeline value ÷ monthly quota. Target is 3x for early-stage, 2x for mid-stage, 1.5x for late-stage. If your coverage ratio is below target, you are likely to miss quota unless stage conversion rates are above historical average.
• Value by Stage: Sum by stage. This shows concentration. If 70% of your pipeline is early-stage, you have a 90-day lead time problem.
• Concentration Risk: Identify the largest deals and their percentage of total pipeline. Flag if the top 2 deals are >30% of pipeline, or if the top 1 deal is >20%.
• Stalled Deal Value: Total value of deals that are Red or Yellow. This represents at-risk revenue.
• Stage Velocity: Average days in stage by stage type. Compare to historical data. If deals are moving slower through stages, investigate: is it market conditions, longer sales cycles for larger deals, or rep activity gaps?

For each insight, generate a recommendation. If coverage ratio is low, the recommendation is "Accelerate early-stage activities to build future quarterly pipeline." If concentration risk is high, the recommendation is "Identify 3-4 mid-stage deals to accelerate into late-stage to diversify forecast risk."

Phase 4: Forecast Modeling (Entry: Deal health matrix, stage probabilities; Exit: Three forecast scenarios)

Generate three forecasts:

Weighted Forecast: Each deal's value × its stage probability. Use historical conversion rates if available; otherwise use defaults (early-stage 20%, qualified 40%, proposal 60%, negotiation 80%, closing 90%). Sum across all deals. This is your "most likely" forecast assuming average deal progression.

Best-Case Forecast: Weighted forecast + an upside adjustment. The upside includes deals that have 3+ conviction signals (confirmed criteria, economic buyer engaged, verbal commitment, procurement initiated) AND have recent positive momentum (activity in past 7 days, no pushes to close date). Add these deals at 80% probability. This represents a realistic scenario where deals progress on schedule and the most-confident deals close.

Commit Forecast: Only deals where all 4 conviction signals are met: confirmed decision criteria, economic buyer engaged, verbal commitment to timeline, procurement process initiated. These deals close at 95% probability. Commit forecast shows your floor—the revenue you can practically guarantee if normal execution happens.

Frame the three scenarios as decision paths: "Here's the range: if normal deal progression happens, we hit $XXX (weighted). If our best-positioned deals move as scheduled, we hit $YYY (best-case). If only the deals where we have explicit commitment close, we hit $ZZZ (commit). Given our quota of $QQQ, we need XXX or better."

Phase 5: Inspection Questions (Entry: Health score matrix, deal details; Exit: Specific, tailored questions for review meetings)

Generate inspection questions tailored to each deal and its risk profile. Avoid generic questions like "How's this deal going?" These get meaningless answers. Instead, ask questions that probe the specific risk factor:

For deals with extended stage duration: "This has been in qualification for 45 days vs. your typical 25. What's causing the longer cycle? Are we waiting on their internal approval process, or is there a qualification gap?"

For deals with no activity in 14+ days: "There's been no contact for two weeks. What changed? Are they still evaluating, or have they deprioritized? What's your re-engagement plan?"

For deals with pushed close dates: "This deal has moved from Oct 31 to Nov 15 to Nov 30. What's the real risk here—is procurement slow, or is the champion losing momentum? What needs to happen to hit the Nov 30 date?"

For deals with only one stakeholder engaged: "You've been working with the VP of Sales, but we haven't engaged IT or procurement yet. What's the plan to bring them in?"

For deals with incomplete qualification: "Do we know their decision criteria? Have you confirmed their budget approval process? If not, your close date may be optimistic."

These questions are driven by data, not hunches. They also show the rep exactly what needs to happen to de-risk the deal.

Phase 6: Action Planning (Entry: Inspection questions, re-engagement tactics; Exit: Prioritized action list)

Summarize the top 3-5 actions the rep should take immediately:

1. Complete re-engagement actions for all Red deals (specific, named actions with deadlines)
2. Identify the 1-2 deals with highest conviction signals and ensure they get executive visibility
3. Address concentration risk by identifying which early-stage deals to accelerate
4. Fix any forecast assumptions that seem disconnected from deal reality

Each action should have an owner (rep, manager, or both) and a completion date.

Anti-Patterns

Anti-Pattern 1: Forecast by Feelings Before: "I feel good about hitting our number this quarter. I think deals A, B, and C will all close." After: "Commit forecast is $2.1M (deals A and B meet all conviction criteria). Best-case is $2.8M (C has 3 of 4 signals but no economic buyer confirmation). Weighted is $3.2M assuming average stage progression. If all three close, we hit $3.1M. Most likely scenario is best-case at $2.8M, so we're at 85% of quota. Here's what needs to happen for each deal to hit commit timing."

Anti-Pattern 2: Ignoring Stalled Deals Before: "This deal's been silent for 3 weeks. I'll touch base next month." After: "This deal has been Red for two weeks. It's lost momentum. Specific action: Send a value-add email by Thursday citing the recent market research on their industry, then call Friday morning to propose a 20-minute business case discussion with the CFO. If they don't engage by next Monday, we drop it to low-priority and shift attention to deals B and C."

Anti-Pattern 3: Single-Stakeholder Risk Before: "The VP of Sales is our champion and he loves us. This deal is going to close." After: "You have strong executive sponsorship, which is valuable. But the CFO hasn't been engaged yet on budget, and IT hasn't signed off on security. If either of those two objects at the last minute, the deal stalls. Action: Get IT a demo this week and schedule a budget review with the CFO by Friday. These are not nice-to-haves—they're de-risking actions."

Anti-Pattern 4: Buried Concentration Risk Before: "I have $4.5M in pipeline across 12 deals." After: "You have $4.5M in pipeline, but 2 deals are $1.2M and $1.1M (52% of total). If either of those two slip, you miss quota. Best-case, both close on time and you hit $4.2M. More likely, one slips and you're at $3.1M (77% of quota). Action: Immediately identify 3-4 mid-stage deals to accelerate into late-stage. Also ask: are there new early-stage opportunities we can add to the pipeline?"

Anti-Pattern 5: Vanishing Close Dates Before: Close date moved from Sept 30 → Oct 15 → Oct 31 → "TBD." After: "This deal has moved three times in 6 weeks. That's a pattern. Either the sales cycle is longer than expected, or the prospect has lower-than-stated priority. Action: Have an explicit conversation with the champion: 'I notice we've moved the close date a few times. What's the real business constraint here? Is budget the issue, procurement, or something else? If we can't commit to a specific close date, we need to reset expectations.' Do not accept 'sometime in November.' Get a specific date and the commitment of a final decision call."

Anti-Pattern 6: Qualification Theater Before: "The deal is qualified. Close date is Nov 30. We're good." After: "Before we count this as qualified, let's check: Do you know their decision criteria? (Yes/No) Has budget been confirmed with the economic buyer? (Yes/No) Are they comparing against a competitor? (Yes/No) If you answered No to any of these, it's not fully qualified. Here's what needs to happen first: Get a competitive summary, schedule a budget conversation with the CFO, and document decision criteria in writing."

Output Format

A pipeline review produces a structured summary:

PIPELINE REVIEW SUMMARY
Date: [DATE]
Reviewer: [NAME]
Total Pipeline: $[AMOUNT] across [N] deals
Coverage Ratio: [X]x (target: [Y]x)

DEAL HEALTH SNAPSHOT
Green (Healthy): [N] deals, $[AMOUNT]
Yellow (Caution): [N] deals, $[AMOUNT]
Red (High Risk): [N] deals, $[AMOUNT]

FORECAST SCENARIOS
Weighted Forecast: $[AMOUNT] ([X]% of quota)
Best-Case Forecast: $[AMOUNT] ([X]% of quota)
Commit Forecast: $[AMOUNT] ([X]% of quota)

CRITICAL RISKS
1. [Deal name]: [Specific risk and action]
2. [Deal name]: [Specific risk and action]
3. [Pipeline-level risk]: [Recommendation]

CONCENTRATION RISK
Top 3 deals: [NAMES], totaling [X]% of pipeline

RED DEALS & RE-ENGAGEMENT ACTIONS
[Deal name]: [Specific action, deadline]
[Deal name]: [Specific action, deadline]

INSPECTION QUESTIONS FOR MANAGER CALL
1. [Question tailored to specific deal]
2. [Question tailored to specific deal]
3. [Question tailored to pipeline-level risk]

TOP 3 ACTIONS FOR THIS WEEK
1. [Action], [Owner], [Deadline]
2. [Action], [Owner], [Deadline]
3. [Action], [Owner], [Deadline]

Task-Specific Questions

Mode 1: Individual Rep Review

• "What's the real risk on your deals that are past expected stage duration? Is it your activity, their process, or something else?"
• "Walk me through your top 3 deals. For each one, what's the one thing that would kill it? What's your contingency plan if that happens?"
• "Where is your pipeline thin? If you miss your top 2 deals, what gets you to your number?"

Mode 2: Manager Team Review

• "Which reps have concentration risk? Who has the healthiest pipeline distribution?"
• "What's our team's actual stage conversion rate? How does it compare to our forecast assumptions?"
• "For each Red deal, what's the coaching we need to apply? Is this an activity gap, a qualification gap, or a real deal-risk issue?"

Mode 3: Executive Forecast

• "What's our true commit forecast? What's the realistic best-case? What would need to break for us to miss it?"
• "Where is our pipeline too concentrated? What's our contingency plan if the top 3-5 deals slip 30 days?"
• "What's our pipeline coverage ratio by segment? Are we thin in any market or customer category?"

Pipeline Health Scoring in Practice

Understanding how to apply health scores in real-world scenarios strengthens your pipeline review accuracy. Consider a deal at $150K in the negotiation stage with a close date 20 days away. The deal entered negotiation 30 days ago (vs. your typical 14 days), so it is running 2.1x longer than historical average. The rep had a call with the champion 6 days ago but nothing since. The champion and procurement have been engaged, but the economic buyer (CFO) has not weighed in. The deal's close date has moved once from the original target. This combination—extended stage duration (Red), recent but slowing activity (trending Yellow), multi-stakeholder engagement (Green), but missing economic buyer confirmation (Red)—should score as Red overall because the missing economic buyer is a critical qualification gap that often emerges 2-3 weeks before contract when procurement involves finance. The re-engagement action here is not "call the champion again," but "Schedule 48 hours with the champion to get CFO alignment on terms and pricing, with a decision commitment call on Friday." You are identifying the specific blocker (CFO alignment) and creating the named action that unblocks it.

Another example: A deal at $45K in proposal stage, entered 10 days ago (vs. typical 12 days, so on-track stage duration). Last activity was 3 days ago (strong). Close date is 16 days out, matching the rep's typical proposal-to-close cycle. Only the champion and one technical buyer are engaged, but procurement process has not started. This deal scores Yellow: on-track timing, good activity, but missing procurement visibility. The action is not to push harder on close date, but to get procurement involved immediately to avoid a late-stage surprise where procurement changes requirements or extends the process.

Quality Checklist

Use these criteria to verify your pipeline review is thorough:

• Every Red deal has a specific re-engagement action with a deadline, not a vague follow-up
• Forecast scenarios are defensible and based on conviction signals or stage probability, not optimism
• Concentration risk is identified; top deals and their percentage of pipeline are named
• Historical stage velocity is compared to current deals to flag unusually extended timelines
• Inspection questions are tailored to specific deal risks, not generic
• Activity history (or lack thereof) is factored into health scoring
• Stakeholder engagement is assessed; single-stakeholder deals are flagged as yellow or red
• Qualification completeness is verified; deals with incomplete criteria are not forecasted at high probability
• Re-engagement actions are specific to the deal's primary blocker, not generic follow-ups
• Forecast scenarios show the decision path and risk contingencies, not just different numbers

Related Skills

• Deal Qualification — Pre-pipeline qualification framework for ensuring only qualified deals enter your pipeline
• Account Planning — Multi-threaded account strategy to identify and surface hidden pipeline within strategic accounts
• Follow-Up Sequences — Structured re-engagement tactics for stalled deals and prospect touchpoints
• Pricing Negotiation — Price defense and creative structuring for late-stage deals in your pipeline

Example Prompts

• "Analyze my pipeline and tell me which deals are at risk of slipping this quarter. For each Red deal, give me a specific re-engagement action."
• "Generate three forecast scenarios (weighted, best-case, commit) based on my current pipeline. Here's my deal list: [paste deals with stages and close dates]."
• "I have 8 deals worth $3.2M total, but 2 deals are $1M each. My quota is $2M. What should I be worried about, and what should I do this week?"
• "Prepare inspection questions for my pipeline review meeting tomorrow. I'll brief my manager on 12 deals. Where are the real risks?"
• "My deals keep slipping. I have 5 deals that moved their close date at least once. What's happening here, and how do I reset expectations?"
• "Which of my deals are fully qualified? I need to know which ones I can commit to and which ones are still missing something."