Sales Pipeline Gap Analysis: Find Your Revenue Shortfall

Here is a scenario that plays out at small B2B sales teams every quarter: six weeks out, the pipeline dashboard shows 3.5x coverage. The head of sales exhales. Then the weekly review starts. Three of the largest deals have had no logged activity in 30 days. Two reps are carrying 40% less pipeline than they need individually. Close dates on four deals are copied from last quarter and nobody updated them. The 3.5x number was built on stale records.

A pipeline coverage ratio tells you how large your pipeline looks relative to quota. A pipeline gap analysis tells you where the shortfall actually lives, and what you can do about it before the quarter closes.

According to the Ebsta x Pavilion 2025 GTM report, 76% of sellers missed quota in H1 2025. Missing quota is rarely a surprise that arrives on the last day of the quarter. It is almost always visible six to eight weeks out, in the gap between pipeline as it appears and pipeline as it is.

Coverage Ratio vs. Pipeline Gap: The Difference That Matters

A pipeline coverage ratio is a single number: your total open pipeline value divided by your revenue target. If you have $2M in pipeline and a $500K target, your ratio is 4x.

The problem is that the ratio treats every deal in the pipeline as equally real. A deal with no activity in 45 days contributes the same value as one where the prospect requested a contract last week. This is why the ratio can look healthy while the quarter is already broken.

A pipeline gap analysis separates two distinct questions:

How large is my absolute shortfall? Not a ratio, but the dollar amount you need to add or accelerate to hit your target.

Where is that shortfall concentrated? Which reps, which stages, which sources, which deal types.

The second question is where the analysis becomes actionable. A $600K pipeline gap concentrated in one rep's territory calls for a different response than a $600K gap spread evenly across the team.

For a foundational look at how the coverage ratio works and what your number means in context, see Sales Pipeline Coverage Ratio: Formula, Benchmarks, and Fixes.

How to Calculate Your Pipeline Gap

Start with one formula:

Pipeline needed = Revenue target / Historical win rate

If your Q4 target is $500K USD and your team historically closes 25% of qualified deals, you need $2M in open, qualified pipeline to expect to hit your number. This is the same logic behind a 4x coverage target for a team with a 25% win rate.

Win rate benchmarks vary significantly by segment. According to data from Salesmotion and Zenitdata, SMB-focused teams typically see win rates of 28 to 35%, mid-market teams 20 to 28%, and enterprise teams 12 to 18%. Use your own historical data rather than an industry average. If your win rate is closer to the enterprise range, your pipeline requirement is proportionally higher.

Then subtract your current pipeline value:

Pipeline gap = Pipeline needed - Current qualified pipeline

If your current pipeline is $1.4M and you need $2M, your gap is $600K. That is the number you are working to close, through new sourcing, acceleration of stalled deals, or pulling in opportunities sitting further out in the funnel.

One step before running this calculation: clean your pipeline of deals that are no longer genuinely active. Zombie deals, deals with close dates more than 30 days in the past, and deals with no logged activity in 60 or more days should be moved to a separate category first. Including them makes the gap look smaller than it is. See CRM Data Hygiene: A Practical Guide for Sales Teams for how to run this audit systematically.

Break the Gap Down by Dimension

An aggregate gap number tells you how much trouble you are in. A breakdown by dimension tells you where to focus.

By Rep

Pull each rep's current pipeline value and compare it to their individual quota using the same win-rate math. A team-level gap often traces to one or two reps who are significantly below their individual pipeline targets while the rest of the team is on track. If two reps are each carrying $300K less pipeline than they need, the $600K team gap is a sourcing problem specific to two people.

This matters because the remedy is different. A sourcing gap for two reps points to targeted prospecting support, not a broad marketing push.

By Stage

Map how many deals are at each stage and compare stage durations against your historical average. If deals in your "Evaluation" or "Proposal" stage are sitting there twice as long as they typically do before moving or dying, you have a velocity problem, not just a volume problem.

Deals stuck in late stages deserve attention first. A deal at 60% probability that has stalled for three weeks is closer to your target than sourcing a net-new deal. The path to close is shorter. The risk is that you have not diagnosed why it stalled.

Common reasons deals stall in late stages: a champion who left the account, a budget freeze, a competitor evaluation that was not logged in the CRM, or no agreed next step. Each has a different fix, and none of them is visible in a coverage ratio.

By Source

Separate pipeline by how it was sourced: outbound, inbound, partner, expansion. Win rates and cycle lengths vary significantly by source, which means a $500K gap filled entirely with outbound-sourced early-stage deals is harder to close this quarter than a $500K gap with a mix of inbound and late-stage outbound.

If your historical inbound win rate is 35% but your outbound win rate is 18%, an inbound opportunity at the same stage is worth roughly twice as much to your near-term forecast. A gap analysis that ignores source will consistently produce optimistic projections.

By Deal Age

Age is a proxy for quality. A qualified deal that entered the pipeline eight weeks ago and has had consistent activity every two weeks is different from one that entered eight weeks ago and had two touchpoints before going quiet. Both count the same in a raw pipeline number.

Add a deal-age filter: separate deals that have had at least one logged touchpoint in the last 14 days from those that have not. The second group is your zombie pipeline. It may not be dead, but it should not count at full face value when you are calculating your true gap.

For more on how to spot deals that are quietly losing momentum, see Deal Slippage: How to Spot It Before Close Dates Turn Red.

Why Clean CRM Data Is the Prerequisite

A pipeline gap analysis is only as accurate as the data behind it. This is where most teams hit the same wall: the analysis requires current, accurate information about deal stage, recent activity, close dates, and deal value. But reps log activity inconsistently, close dates drift without being updated, and stage changes happen in conversations that never make it into the CRM.

The practical result is that the gap analysis systematically understates the actual shortfall. Stale close dates make deals look closer than they are. Stages that have not advanced in weeks suggest deals that are actually stuck. No logged activity in 30 days often means the deal is dead, not dormant.

Two ways to address this:

Audit before you analyze. Apply filters before running the numbers: remove deals with close dates more than 30 days past, remove deals with no activity in 60 days, and flag any deal where the close date was copied from a prior quarter without advancing. What remains is your qualified pipeline.

Continuous capture instead of pre-meeting cleanup. The deeper fix is ensuring activity gets logged daily rather than in a sprint before a review meeting. When email threads, calls, and meetings are captured automatically and mapped to the right deal record, the data behind your gap analysis reflects what is actually happening.

A tool like the Company Brain addresses this by syncing rep email threads and deal activity daily, drafting CRM updates that a rep reviews and approves before anything writes, and making that pipeline queryable. Instead of pulling a manual gap report from your CRM and then cleaning it, you can ask plain-language questions like "which reps are below their coverage target" or "which deals in the proposal stage have had no activity in 14 days" and get answers from a database that updates as the work happens. The posture shifts from auditing stale records before a review to working with data that is current between reviews.

What to Do With the Gap You Find

Running the analysis is the diagnostic. The response depends on what you found.

If the gap is primarily a sourcing gap (not enough new opportunities entering the pipeline): the remedy is prospecting velocity. More outbound sequences, a demand generation push, or activation of dormant accounts. Be realistic about timing. A deal sourced today in a 90-day sales cycle will not close this quarter. That sourcing work is for next quarter.

If the gap is concentrated in one or two reps: work their pipeline in 1:1s, identify which of their current deals have a realistic path to close, and bring in sourcing support specifically for their territory rather than spreading resources across the team.

If the gap is a velocity problem (enough deals in the pipeline, but they are not advancing): focus on unsticking late-stage deals. That usually means a manager joining the next call, an executive introduction, or a revised proposal that addresses a stall point that was never surfaced in the CRM.

If the gap is a data quality problem (you cannot tell which category you are in because the data is unreliable): run the cleanup audit first, then implement a process to make activity capture systematic rather than voluntary before the next quarter starts.

The goal of the analysis is to arrive at one of these specific answers rather than a vague directive to "add more pipeline." More pipeline is always true. The gap analysis tells you what kind, where, and how fast you can realistically generate it given what is already in motion.

Running the Analysis in Practice

For a team on HubSpot, Salesforce, or Pipedrive, the inputs exist in your CRM today. The steps:

1. Export all open deals with current stage, value, close date, and last activity date.
2. Apply cleanup filters: remove deals with close dates more than 30 days past, remove deals with no activity in 60 days.
3. Apply historical win rates by stage to get a weighted pipeline value per deal.
4. Sum the weighted values, compare to your target, and calculate the gap.
5. Slice the gap by rep, stage, source, and deal age.
6. For each segment where the gap is concentrated, identify whether the problem is sourcing, velocity, or data quality.

This can be built in a spreadsheet, a CRM saved view, or a BI tool. The constraint is always the same: it requires clean, current data to produce a reliable result.

Teams that run this analysis weekly tend to catch shortfalls six to eight weeks before quarter-end, when there is still time to change the outcome. Teams that run it monthly often discover the gap at the pipeline review when it is already too late to source a deal that closes in time.

Frequently Asked Questions

What is a sales pipeline gap analysis?

A pipeline gap analysis compares your current open pipeline value against the pipeline you need to hit your revenue target, then breaks the shortfall down by rep, stage, source, and deal age. It goes beyond a coverage ratio by identifying exactly where the gap is concentrated so you can act on the right problem.

How do you calculate your pipeline gap?

First calculate how much pipeline you need: divide your revenue target by your historical win rate. If your target is $500K USD and your win rate is 25%, you need $2M in qualified pipeline. Then subtract your current pipeline value. A $1.4M current pipeline against a $2M requirement means a $600K shortfall.

What is a healthy pipeline coverage ratio for a B2B sales team?

Coverage ratio benchmarks vary by segment. SMB teams typically target 2.5x to 3x, mid-market teams 3x to 4x, and enterprise teams 4x to 5x. The right multiple depends on your win rate: a team closing 25% of deals needs 4x coverage to expect to hit quota.

Why do pipeline gap analyses often give wrong results?

The most common reason is stale CRM data. Deals with outdated close dates, stages that have not progressed in weeks, and no recent logged activity inflate the apparent pipeline without reflecting real buying intent. A gap analysis built on uncleaned CRM data produces a number that is systematically too optimistic.

What should you do if you find a pipeline gap mid-quarter?

Separate the analysis by source: what percentage of the gap can inbound fill, and what requires outbound acceleration? Then focus on stuck deals in late stages first, since those have the shortest path to close. Finally, identify which reps are most below their individual pipeline targets and prioritize sourcing support there.