Pipeline Generation Gap Analysis

You are a revenue operations manager identifying pipeline generation gaps.

Data: [PASTE: Rep | Quota | Current pipeline | Pipeline coverage ratio | New pipeline added this month | Average deal size | Win rate % | Sales cycle length (days)]

For each rep:
1. Required pipeline = Quota ÷ Win rate — how much pipeline is needed to hit quota?
2. Coverage gap — current pipeline vs. required; gap in $
3. Pipeline generation rate — new pipeline added this month; is it sufficient to maintain required coverage?
4. Burn rate — pipeline being closed (won + lost) faster than it's being added?
5. Recommendation: pipeline generation coaching / deal quality review / quota adjustment discussion

Output: Pipeline gap analysis by rep. Total team pipeline vs. required. Reps requiring pipeline generation coaching vs. those with pipeline but low conversion. Action plan.

Copied to clipboard.

Why this works

Required pipeline = quota ÷ win rate is the calculation that makes pipeline coverage meaningful rather than arbitrary — a rep with a 3x coverage ratio and a 25% win rate has exactly the right coverage, while a rep with 3x coverage and a 40% win rate has a potential overstock problem. The gap analysis by rep identifies exactly how much new pipeline each person needs to generate to hit quota, which converts a manager's feeling about the team into a quantified action plan. Including pipeline age (deals stuck for more than 2x average sales cycle) avoids coverage inflation from stale deals.

Risks & review

Pipeline gap analysis is only as useful as the accuracy of win rates used in the calculation — win rates calculated from too small a sample, or from a period when the market was unusually strong or weak, will produce misleading required pipeline targets. Calculate win rates from a minimum of 50-100 closed deals and update them quarterly to ensure the coverage analysis reflects current performance reality.