Sales AI Skill

Pipeline Management

Manage end-to-end sales pipeline with stage definitions, hygiene enforcement, velocity tracking, forecasting accuracy improvement, aging deal management, and coverage ratio optimization. Use when running pipeline reviews, calculating pipeline velocity, cond...

Pipeline Management

Systematic pipeline governance framework ensuring accurate forecasting, healthy funnel metrics, and consistent revenue flow through disciplined stage management, hygiene practices, and velocity optimization.

Pipeline Stage Architecture

SALES STAGE DEFINITIONS (Standard 6-Stage Model)
═══════════════════════════════════════════════════════════

Stage 1 — Prospecting (Probability: 10%, Avg Duration: 10 days):
  Entry criteria:
    → Lead assigned to rep (from marketing, outbound, referral)
    → First touch logged (email sent, call made, LinkedIn connection)
    → Basic company info captured (name, industry, size, contact)
  Required activities:
    → Research company and contact (LinkedIn, website, news)
    → Send personalized outreach (email or call)
    → Log all interactions in CRM
  Exit criteria:
    → Prospect responds with interest (positive reply, meeting booked)
    → OR prospect explicitly not interested (disqualify)
  Conversion target: 15–25% of prospected leads reach Qualification

Stage 2 — Qualification (Probability: 20%, Avg Duration: 15 days):
  Entry criteria:
    → Prospect agreed to discovery call
    → Meeting scheduled and logged in CRM
  Required activities:
    → Complete discovery call (30–45 minutes)
    → Capture BANT/MEDDIC data in CRM
    → Identify primary pain and quantified impact
    → Name 2+ stakeholders involved in decision
  Exit criteria:
    → Pain validated with quantified business impact
    → Budget confirmed or timeline for budget allocation
    → Decision process understood
    → Next step agreed (demo, technical review, etc.)
  Conversion target: 40–60% of qualified deals reach Needs Analysis
  Red flags (disqualify if present):
    → No quantified pain after discovery call
    → Cannot name decision-maker or economic buyer
    → Timeline > 6 months with no urgency driver
    → Budget explicitly not available

Stage 3 — Needs Analysis / Demo (Probability: 30%, Avg Duration: 15 days):
  Entry criteria:
    → Deal created in CRM (Status: Active Opportunity)
    → Discovery notes complete in CRM
    → Demo or technical review scheduled
  Required activities:
    → Deliver personalized product demo (or technical deep-dive)
    → Map solution to prospect's specific pain points
    → Address objections in real-time
    → Identify economic buyer and plan engagement
  Exit criteria:
    → Prospect confirms solution fit ("this addresses our needs")
    → Economic buyer engaged or meeting planned
    → Decision criteria documented
    → Proposal or pricing discussion planned
  Conversion target: 50–65% of demoed deals reach Proposal

Stage 4 — Proposal / POC (Probability: 50%, Avg Duration: 20 days):
  Entry criteria:
    → Prospect requested formal proposal or proof-of-concept
    → Economic buyer confirmed involvement
  Required activities:
    → Send formal proposal (pricing, scope, timeline, terms)
    → Define POC success criteria (if applicable)
    → Track proposal engagement (opened, viewed, shared)
    → Schedule follow-up call within 3 business days
  Exit criteria:
    → Proposal accepted (verbal or written)
    → POC completed with positive results
    → Verbal agreement to move forward
    → Negotiation / contract discussion initiated
  Conversion target: 60–75% of proposed deals reach Negotiation

Stage 5 — Negotiation / Legal (Probability: 75%, Avg Duration: 15 days):
  Entry criteria:
    → Verbal agreement to purchase
    → Contract or MSA sent to prospect
  Required activities:
    → Negotiate terms (pricing, scope, timeline, SLAs)
    → Address legal/security questions (SOC 2, DPA, BAA)
    → Manage procurement process (if applicable)
    → Track contract status (sent, reviewed, revised, approved)
  Exit criteria:
    → Signed contract received
    → Payment processed (or payment terms confirmed)
    → Implementation kickoff scheduled
  Conversion target: 70–85% of negotiated deals close-won

Stage 6 — Closed Won (Probability: 100%, Avg Duration: 5 days):
  Entry criteria:
    → Signed contract on file
    → Payment received (or invoiced)
  Required activities:
    → Log closed date and revenue in CRM
    → Handoff to Customer Success team (intro email, implementation kickoff)
    → Update forecast and pipeline reports
    → Log win factors (what drove the decision)
  Post-close:
    → Implementation kickoff within 5 business days
    → CSM owns relationship (ownership transfer documented)
    → Expansion opportunity flagged (if applicable)

Closed Lost (Probability: 0%):
  Entry criteria:
    → Prospect explicitly declined or chose competitor
  Required activities:
    → Log loss reason (primary and secondary)
    → Log competitor name (if applicable)
    → Schedule loss interview (within 7 days)
    → Capture lessons learned
  Disposition categories:
    → Price too high (32% of losses)
    → Went with incumbent (18%)
    → Feature gap (15%)
    → Timing / not now (12%)
    → No budget (8%)
    → Competitor (specific) (7%)
    → No decision-maker (4%)
    → Other (4%)

Pipeline Hygiene & Governance

PIPELINE HYGIENE ENFORCEMENT
═══════════════════════════════════════════════════════════

Automated Hygiene Checks (CRM Workflows):
  → Daily checks:
     - Deals with no activity in 14+ days: Auto-flag + Slack alert to rep
     - Deals with close date in the past: Auto-flag + manager notification
     - Deals missing next step: Block stage advancement until updated
     - Deals missing forecast category: Auto-assign "Pipeline" + rep notification

  → Weekly checks:
     - Deals in same stage > 2x average duration: Aging alert to manager
     - Deals with close date > 3x stage median: Realism flag to rep
     - Opportunities with no MEDDIC data (Stage 3+): Block forecast inclusion
     - Duplicate opportunities (same account + product): Merge alert
     - Lost deals without loss reason: Auto-reminder to rep

  → Monthly checks:
     - Full pipeline audit: All required fields, activity logs, next steps
     - Forecast accuracy review: Actual closed vs. forecasted
     - Stage probability recalibration: Based on historical conversion data
     - Rep hygiene scoring: Individual compliance report

Hygiene Compliance Scoring:
  ┌─────────────────────────────┬──────────┬──────────────────────┐
  │ Metric                      │ Target   │ Action if Below      │
  ├─────────────────────────────┼──────────┼──────────────────────┤
  │ Required fields complete    │ > 95%    │ Manager coaching     │
  │ Next step updated weekly    │ > 90%    │ Automated reminder   │
  │ Activity logged weekly      │ > 85%    │ Manager 1:1 discuss  │
  │ Close date realistic        │ > 80%    │ Forecast review      │
  │ MEDDIC complete (Stage 3+)  │ > 90%    │ Block forecast       │
  │ Loss reason documented      │ > 95%    │ Auto-reminder        │
  │ Lost deal interview done    │ > 50%    │ Manager follows up   │
  └─────────────────────────────┴──────────┴──────────────────────┘

DEAL AGING MANAGEMENT:
  → Aging thresholds by stage:
     Stage 2 (Qualification): > 30 days = aging (flag for review)
     Stage 3 (Demo): > 30 days = aging
     Stage 4 (Proposal): > 45 days = aging
     Stage 5 (Negotiation): > 30 days = aging

  → Aging deal intervention:
     Week 1 (past threshold): Automated email to rep + Slack alert
     Week 2: Manager review in 1:1 — update forecast category to "Best Case" or "Pipeline"
     Week 3: Executive deal review — require action plan from rep
     Week 4: Disqualify or re-engage — if no progress, move to nurture
     Week 6: Archive — deal moved to long-term nurture, removed from active pipeline

  → Stale deal re-engagement:
     - New trigger event: Company news, hiring, funding, product launch
     - Quarterly check-in: "Checking in — is [initiative] still a priority?"
     - Value-add outreach: Share relevant case study or industry report
     - Breakup sequence: "Should I close this file? Feel free to reach out when [trigger]."

Pipeline Review Cadence

PIPELINE REVIEW STRUCTURE
═══════════════════════════════════════════════════════════

Daily Standup (15 minutes — rep + manager, or team huddle):
  → Yesterday's wins: Deals advanced, meetings booked, proposals sent
  → Today's priorities: Top 3 deals to advance, calls to make, follow-ups
  → Blocking issues: Anything needing manager/leader help
  → Quick metrics: Deals in pipeline, this week's expected closes
  → Format: Quick verbal update, not CRM review

Weekly 1:1 (30–45 minutes — rep + manager):
  Block 1 — Quota Check (5 minutes):
    → YTD attainment: [X]% of quota
    → Run rate: On track to hit quarterly quota? (Yes/No)
    → Gap: $[amount] behind / ahead of pace
    → Focus: What needs to happen this week to close the gap?

  Block 2 — Closed Deal Review (5 minutes):
    → Won deals: Revenue, cycle length, what worked
    → Lost deals: Reasons, lessons learned, interview scheduled?
    → Insight: What can we apply to active deals?

  Block 3 — Deal-by-Deal Review (20–25 minutes):
    → Each active deal (prioritize by stage and revenue):
       - Current stage and expected close date
       - MEDDIC score (if applicable)
       - Next step (specific action, owner, date)
       - Risk factors and mitigation plan
       - Forecast category (Commit / Best Case / Pipeline / Best Effort)
    → Focus on deals closing in next 30 days (immediate revenue)
    → Deep-dive on deals > $50K or strategic accounts

  Block 4 — Pipeline Health (5 minutes):
    → Coverage ratio: [X]x (target: 3–4x)
    → New pipeline generated this week: $[amount]
    → Aging deals: [X] deals past threshold
    → Action items: Specific next steps

  Block 5 — Coaching & Development (5 minutes):
    → Skill development: What to practice this week
    → Role-play: 5-minute objection handling or discovery practice
    → Resources: Articles, training, tools to review

Monthly Forecast Call (60 minutes — manager + all reps + VP):
  → Each rep presents:
     - Quota attainment YTD and for quarter
     - Top 5 deals by revenue (stage, confidence, close date)
     - Forecast: Commit amount, Best Case amount, total pipeline
     - Risks and mitigation plans
  → Manager synthesizes:
     - Team total forecast: $[amount]
     - Confidence level: High / Medium / Low
     - Key risks: Competitive threats, budget delays, etc.
     - Pipeline generation needs: $[amount] needed by [date]

Quarterly Business Review (90 minutes — leadership + sales team):
  → Q results: Revenue vs. target, win rate, sales cycle, quota attainment
  → Pipeline analysis: Coverage, velocity, conversion rates by stage
  → Forecast accuracy: Actual vs. forecasted, variance analysis
  → Process review: What worked, what didn't, improvements for next quarter
  → Territory analysis: Rep territory performance, rebalancing needs
  → Goal setting: Next quarter targets, individual and team goals

Pipeline Metrics & Analytics

PIPELINE HEALTH DASHBOARD
═══════════════════════════════════════════════════════════

PIPELINE COVERAGE RATIO:
  Formula: Total Pipeline Value ÷ Remaining Quota
  Targets by stage:
    → Total pipeline: 3–4x remaining quota (healthy)
    → Stage 2+ (qualified): 5x remaining quota
    → Stage 3+ (demo): 3x remaining quota
    → Stage 4+ (proposal): 2x remaining quota
    → Stage 5 (negotiation): 1.5x remaining quota
  → Below 2x: PIPELINE RISK — increase prospecting immediately
  → Above 6x: PIPELINE BLOAT — disqualify weak deals, focus on advancing

PIPELINE VELOCITY:
  Formula: (Number of Deals × Average Deal Size × Win Rate) ÷ Sales Cycle Length
  Example calculation:
    → Number of deals: 50 (per quarter)
    → Average deal size: $50,000
    → Win rate: 25%
    → Sales cycle: 60 days
    → Velocity: (50 × $50,000 × 0.25) ÷ 60 = $10,417/week
  → Target: Increase velocity by improving any of the 4 factors
  → Leverage:
     - More deals: Increase prospecting activity (+10 deals = +$2K/week)
     - Larger deals: Focus on higher-ACV opportunities (+$10K avg = +$2K/week)
     - Higher win rate: Improve qualification and demos (+5% = +$1K/week)
     - Shorter cycle: Reduce sales cycle (-10 days = +$2K/week)

STAGE-TO-STAGE CONVERSION RATES:
  ┌────────────────────────────┬──────────┬──────────┬──────────┬──────────┐
  │ Stage Transition           │ Target   │ Q1       │ Q2       │ Trend    │
  ├────────────────────────────┼──────────┼──────────┼──────────┼──────────┤
  │ Prospecting → Qualification│ 20%      │ 18%      │ 22%      │ ↑        │
  │ Qualification → Demo       │ 50%      │ 48%      │ 52%      │ ↑        │
  │ Demo → Proposal            │ 55%      │ 50%      │ 58%      │ ↑        │
  │ Proposal → Negotiation     │ 65%      │ 62%      │ 68%      │ ↑        │
  │ Negotiation → Closed Won   │ 75%      │ 70%      │ 78%      │ ↑        │
  │ Overall (Prospecting → Won)│ 3.3%     │ 3.1%     │ 3.8%     │ ↑        │
  └────────────────────────────┴──────────┴──────────┴──────────┴──────────┘
  → Bottleneck identification: Lowest conversion stage = priority for improvement
  → Current bottleneck: Prospecting → Qualification (below 20% target)
  → Action: Improve lead quality, enhance outreach, better targeting

FORECAST CATEGORIES:
  → Commit: 80%+ confidence deal will close this quarter
     - Criteria: Verbal agreement, contract in process, no major risks
     - Action: Track daily, remove any blockers
  → Best Case: 50–79% confidence deal will close this quarter
     - Criteria: Proposal sent, positive feedback, some risk factors
     - Action: Weekly review, address risks, build contingency plan
  → Pipeline: 20–49% confidence deal will close this quarter
     - Criteria: Demo done, interest shown, timeline uncertain
     - Action: Monthly review, advance to next stage, monitor engagement
  → Best Effort: < 20% confidence deal will close this quarter
     - Criteria: Early stage, long timeline, significant risk
     - Action: Track for next quarter, don't include in revenue forecast

FORECAST ACCURACY TRACKING:
  → Formula: |Actual Closed Revenue − Forecasted Revenue| ÷ Forecasted Revenue × 100
  → Target: < 10% variance (industry benchmark for accurate forecasting)
  → Acceptable: 10–15% variance
  → Problematic: > 15% variance (requires process improvement)
  → Rep-level tracking:
     - Rep A: 5% variance (excellent — trust forecast)
     - Rep B: 12% variance (acceptable — minor adjustment)
     - Rep C: 22% variance (problematic — coaching required, adjust forecast)
  → Bias detection:
     - Consistently over-forecasting: Rep is optimistic — auto-adjust by -10%
     - Consistently under-forecasting: Rep is conservative — encourage accuracy
  → Monthly review: Forecast accuracy report with rep-level breakdown

PIPELINE DECAY RATE:
  → Formula: Deals removed from pipeline this week ÷ Total pipeline at week start × 100
  → Healthy decay: 5–10% per week (normal deal progress and disqualification)
  → High decay: > 15% per week (quality issues, poor qualification, market issues)
  → Low decay: < 3% per week (pipeline bloat, deals not progressing)
  → Weekly tracking: Monitor trend over 4–8 weeks for pattern recognition

Integration Points

Edge Cases