--- name: pipeline-coverage-analysis description: Ensure sufficient pipeline to hit revenue targets with coverage ratio analysis. Use when analyzing pipeline coverage ratios, identifying pipeline gaps, generating pipeline alerts, or planning pipeline generation activities. Triggers on phrases like "pipeline coverage", "coverage ratio", "pipeline gap", "pipeline generation", "quota coverage", "pipeline math". --- # Pipeline Coverage Analysis Ensure sufficient pipeline coverage to hit revenue targets through systematic gap analysis and proactive pipeline generation planning. ## Workflow 1. Calculate required pipeline coverage ratio based on historical win rates and deal velocity. 2. Measure current pipeline coverage by rep, team, region, and segment. 3. Identify coverage gaps and shortfalls at every level of the organization. 4. Alert reps and managers to pipeline gaps with specific generation targets. 5. Recommend pipeline generation activities based on gap size and timeline. 6. Track pipeline coverage trends over time and forecast future gaps. 7. Plan hiring and resource allocation based on pipeline capacity. ## Coverage Ratio Framework ``` PIPELINE COVERAGE RATIO CALCULATION ══════════════════════════════════════════════════════════════════════ Formula: Pipeline Coverage Ratio = Weighted Pipeline Value / Quota Weighted Pipeline Value = Σ (Opportunity Amount × Stage Probability) Quota = Individual, team, or organizational revenue target Required Coverage Ratios by Company Stage: Startup (< $5M ARR): → Required ratio: 5–6X (higher win rate uncertainty) → Rationale: Small deal count, variable win rates, longer sales cycles → Minimum acceptable: 4X (below this = high risk of missing quota) Growth ($5–$50M ARR): → Required ratio: 3–4X → Rationale: Established sales process, predictable win rates → Minimum acceptable: 2.5X Scale-Up ($50–$200M ARR): → Required ratio: 3–3.5X → Rationale: Mature process, large deal count, stable win rates → Minimum acceptable: 2X Enterprise ($200M+ ARR): → Required ratio: 2.5–3X → Rationale: Large pipeline volume, high predictability → Minimum acceptable: 2X Coverage Ratio by Pipeline Stage: ╔═══════════════════════╦═══════════════╦═══════════════════════════╗ ║ Pipeline Stage ║ Min Coverage ║ Rationale ║ ╠═══════════════════════╬═══════════════╬═══════════════════════════╣ ║ Identified/Prospecting ║ 6–8X ║ Lowest conversion rate ║ ║ Discovery ║ 4–5X ║ Moderate qualification ║ ║ Qualified ║ 3–4X ║ Strong qualification ║ ║ Proposal/Demo ║ 2–3X ║ High progression rate ║ ║ Negotiation ║ 1.5–2X ║ Near-close confidence ║ ╚═══════════════════════╩═══════════════╩═══════════════════════════╝ Note: Coverage requirements decrease as deals advance through pipeline Early-stage pipeline must be substantially larger to account for attrition ``` ## Coverage Gap Analysis ``` COVERAGE GAP IDENTIFICATION AND ALERTING ══════════════════════════════════════════════════════════════════════ Gap Analysis by Level: Level 1 — Individual Rep: → Quota: $[X] → Weighted Pipeline: $[X] → Coverage Ratio: [X]X → Required Ratio: [X]X (based on company stage) → Gap: [Positive/Negative] $[X] → Status: [Green/Yellow/Red] → Alert: "Sarah, your pipeline coverage is 2.1X — you need $200K more weighted pipeline to reach the 3X target. Focus on [specific activities]." Level 2 — Team/Region: → Team Quota: $[X] → Team Weighted Pipeline: $[X] → Team Coverage Ratio: [X]X → Gap Analysis by Rep: [List reps above/below target] → Cross-coverage: [Can stronger reps compensate for weaker ones?] → Alert: "West Region at 2.3X coverage — team needs $1M more pipeline. 3 reps below target: [names]. Action plan needed." Level 3 — Segment/Vertical: → Segment Quota: $[X] → Segment Pipeline: $[X] → Coverage Ratio: [X]X → Trend: [Growing/Stable/Declining] → Alert: "Enterprise segment only 2.3X covered — below 3X target. Need to prioritize enterprise prospecting activities." Level 4 — Organization: → Total Quota: $[X] → Total Weighted Pipeline: $[X] → Coverage Ratio: [X]X → Coverage by Region: [Breakdown] → Coverage by Segment: [Breakdown] → Coverage by Product: [Breakdown] → Overall Status: [Green/Yellow/Red] → Alert: "Company-wide pipeline coverage at 2.8X — below 3X target. $5M gap identified. Regional breakdown: [details]." Coverage Status Colors: → Green: Coverage ≥ Required ratio (on track) → Yellow: Coverage 80–99% of required ratio (monitoring needed) → Orange: Coverage 60–79% of required ratio (action needed) → Red: Coverage < 60% of required ratio (critical — immediate action) ``` ## Pipeline Generation Recommendations ``` PIPELINE GENERATION STRATEGIES BY GAP SIZE ══════════════════════════════════════════════════════════════════════ Small Gap (< 20% shortfall): → Increase outbound prospecting volume by 20% → Re-engage stale pipeline deals (re-activation campaign) → Leverage existing customer referrals → Host targeted webinar or event → Expected pipeline generation: $50K–$200K per rep Medium Gap (20–50% shortfall): → All Small Gap actions PLUS: → Launch targeted ABM campaign (10–20 accounts) → Partner/sponsor industry event → Increase marketing-qualified lead flow (coordinate with marketing) → Implement multi-channel prospecting cadence → Expected pipeline generation: $200K–$500K per rep Large Gap (50–100% shortfall): → All Medium Gap actions PLUS: → Executive-sponsored outreach campaign → Competitive displacement campaign (target competitor customers) → Referral program acceleration (incentivize existing customers) → Content marketing campaign (gated assets, whitepapers) → Consider hiring additional SDR capacity → Expected pipeline generation: $500K–$1M+ per rep Critical Gap (> 100% shortfall): → All Large Gap actions PLUS: → Emergency pipeline generation sprint (2-week intensive) → Reallocate resources from low-performing segments → Consider quota adjustment or extension → Executive personal outreach to strategic accounts → Revenue operations review of pipeline processes → Expected pipeline generation: $1M+ per rep (requires significant effort) Pipeline Generation Activity ROI: ╔═══════════════════════════════╦══════════════╦════════════════════╗ ║ Activity ║ Pipeline/Rep ║ Time Investment ║ ╠═══════════════════════════════╬══════════════╬════════════════════╣ ║ Outbound prospecting ║ $50K–$150K ║ 10–15 hrs/week ║ ║ ABM campaign ║ $100K–$300K ║ 5–10 hrs/week ║ ║ Customer referrals ║ $100K–$500K ║ 2–3 hrs/week ║ ║ Event sponsorship ║ $200K–$1M ║ 20–40 hrs/event ║ ║ Competitive displacement ║ $150K–$400K ║ 5–10 hrs/week ║ ║ Content marketing ║ $50K–$200K ║ 2–5 hrs/week ║ ║ Partner co-selling ║ $100K–$300K ║ 3–5 hrs/week ║ ║ Executive outreach ║ $200K–$500K ║ 5–10 hrs/week ║ ╚═══════════════════════════════╩══════════════╩════════════════════╝ ``` ## Edge Cases - **Seasonal pipeline fluctuations**: Pipeline may be strong in certain quarters and weak in others due to industry seasonality - Resolution: Implement seasonal adjustment factors in coverage requirements; build pipeline in strong quarters for weak quarters; set quarterly (not annual) coverage targets; plan prospecting intensity by season - **New rep pipeline ramp**: New reps start with zero pipeline — coverage requirements are unrealistic during ramp period - Resolution: Implement ramp-adjusted coverage requirements (50% of normal in month 1–2, 75% in month 3, 100% in month 4+); pre-load new rep pipeline from marketing/SDR team; provide lead allowance during ramp period - **Pipeline concentration risk**: Coverage looks adequate but concentrated in few large deals — one loss = significant gap - Resolution: Track coverage by deal count (not just value); require minimum deal count per rep; flag concentration risk (> 30% of pipeline in single deal); diversify pipeline across segments and verticals - **Stale pipeline inflation**: Old deals in pipeline inflate coverage numbers without realistic close potential - Resolution: Weight pipeline by deal age (older deals get lower probability); exclude deals > 180 days old from coverage calculation; regular pipeline cleanup to remove dead deals; age-based coverage adjustment - **Cross-sell/upsell pipeline**: Expansion revenue may be underreported in pipeline — actual coverage higher than calculated - Resolution: Include expansion pipeline in coverage calculation separately; track expansion coverage ratio alongside new business; set separate coverage targets for expansion (typically lower: 2X); coordinate with customer success team ## Integration Points - **Salesforce CRM**: Pipeline reports, forecast management, coverage dashboards; $25–$3,000/month per user - **Clari**: Revenue intelligence with pipeline coverage analytics; custom pricing - **Tableau/Looker**: Coverage visualization and analytics; $70–$1,200/month per user - **HubSpot CRM**: Pipeline coverage reports and alerts; $45–$3,200/month - **Revenue.io**: Sales analytics with pipeline health scoring; $15,000–$50,000/year - **Gong/Chorus**: Conversation intelligence for pipeline signal validation; $120–$240/month per user - **Slack**: Coverage alerts and pipeline generation reminders; custom channels - **Outreach.io/SalesLoft**: Pipeline generation activity tracking; $80–$200/month per user - **Power BI**: Microsoft pipeline coverage dashboards; $10–$20/month per user - **Salesforce Revenue Cloud**: Comprehensive pipeline management; custom pricing