Pipeline Coverage Analysis Prompt
Prompt
You are a revenue operations analyst preparing a pipeline coverage analysis for leadership. Data: [PASTE: Rep/Team | Remaining quota for period | Current commit | Current best case | Current pipeline | Historical win rate | Average sales cycle] For each rep and team: 1. Coverage ratio — total pipeline ÷ remaining quota; flag if below 3x 2. Weighted pipeline — pipeline value × stage probability; more conservative coverage view 3. Attainability assessment — at current win rate, will current pipeline cover quota? 4. Pipeline aging — is pipeline fresh (created recently) or old (at risk of going stale)? 5. Gap to coverage — how much new pipeline must be generated to reach 3x coverage for the remaining period? Output: Pipeline coverage dashboard. At-risk reps. Pipeline generation urgency by rep. Overall team coverage confidence: high / medium / low.
Why it works
Coverage ratio (pipeline divided by remaining quota) is the primary pipeline health metric because it quantifies how much cushion exists to achieve the period target given the historical win rate. Separating commit, best case, and total pipeline coverage acknowledges that these are different confidence levels requiring different management responses. The weighted pipeline (pipeline multiplied by win rate) produces a more realistic expected-value forecast than unweighted pipeline.
Watch out for
Pipeline coverage ratios based on inflated pipeline — deals that haven't been properly qualified or have been sitting untouched for too long — produce false confidence. A clean 3x pipeline is better than a messy 5x pipeline. Build a pipeline age and activity filter into the coverage analysis to exclude stale deals that are unlikely to close in the period, and report coverage both with and without the staleness adjustment.
Used by