Pipeline Coverage in HubSpot: How to Calculate It

Pipeline coverage is open pipeline value divided by the revenue target it has to cover in the same period. The ratio you should hold is your own, derived from your win rate on qualified pipeline. Three times is the number everybody repeats and nobody sources. Work out yours and the figure usually moves.

The sum takes two minutes. Getting a figure you would defend in a board meeting takes longer, because coverage is only as honest as the close dates and deal amounts underneath it.

What is pipeline coverage?

Pipeline coverage is the ratio of open pipeline value to the revenue target it has to cover in the same period. A ratio means nothing on its own. It means something against the win rate it was derived from.

£2M of open pipeline against a £500k target is 4x coverage. Everything interesting sits in which deals you allowed into the numerator.

How do you calculate pipeline coverage?

Sum the Amount of every open deal with a Close date inside the period, then divide by the target for that period. £2M divided by £500k gives 4x.

Run it on the quarter you are selling into, not the one you are in. Coverage for the quarter that starts in six weeks is a number you still have time to do something about. Coverage for the current quarter is a report on decisions already made.

Where does the 3x pipeline coverage rule come from?

Three times coverage appears across sales content constantly, and we have not found a published methodology, sample or dataset behind it. It reads as a rule of thumb that became a benchmark through repetition. It also happens to describe a business with a 33% win rate on qualified pipeline, which is reasonable for some B2B SaaS companies and wrong for most of the ones we work with.

If your win rate is 20%, three times coverage means you have planned to miss before the quarter opens. If it is 45%, three times means you are carrying more pipeline than you need and under-investing in conversion. The number is an output of your own conversion maths, which makes it yours to derive.

How do you derive your own coverage ratio?

Divide one by your win rate on qualified pipeline. A 25% win rate gives a baseline requirement of 4x.

Use qualified pipeline rather than everything. Pull closed deals from the last twelve months, filter to deals that reached your qualification stage, and divide closed won by the total. If your qualification stage is loosely defined, the ratio inherits that looseness, and the MQL to SQL handoff most HubSpot portals get wrong covers how to tighten it.

Then adjust for two things your closed data already knows.

The first is slippage, the share of deals whose close date moves out of the period. If a fifth of your pipeline typically slips, divide the baseline by 0.8. A 4x baseline becomes 5x. What good forecast accuracy looks like goes into how to measure slippage properly rather than estimating it.

The second is sales cycle length against the period you are covering. Pipeline created with eight weeks to go in a business with a four-month cycle is not covering this quarter regardless of what the close date says.

Set the ratio per segment if your segments convert differently, which they usually do. One blended coverage number across enterprise and SMB hides both.

Should pipeline coverage use weighted or unweighted amounts?

Hold the headline ratio unweighted, and read weighted coverage alongside it.

Unweighted coverage answers whether enough pipeline exists. HubSpot’s Weighted amount property multiplies Amount by the Deal stage probability on each stage, so weighted coverage answers a different question, which is whether the pipeline you hold converts to the target at its current stage mix. Weighted coverage near 1.0 means the stage mix supports the number. Weighted coverage of 0.6 with healthy unweighted coverage means your pipeline is real but early.

Stage probabilities straight out of the box are guesses. Set them from your own stage-to-close conversion before anyone treats weighted coverage as a forecast.

How do you build the coverage report in HubSpot?

Build a single object deal report, sum of Amount, filtered to open deal stages with Close date inside the period, broken down by Deal owner and segment. That gives you the numerator from the custom report builder in a couple of minutes.

The division is the awkward part. HubSpot reports will not divide one report by a target held elsewhere, so coverage usually lives as a maintained single number on the dashboard or as a calculation done in the pipeline review itself. The Goals tool holds revenue targets per user and per team if your Sales Hub tier includes it, which keeps the denominator in the system rather than in a spreadsheet.

Wherever the target sits, date-stamp it. Coverage against a target that was revised twice is a number nobody trusts.

What breaks the pipeline coverage number?

Close dates, mostly. A deal pushed three times sits in your coverage figure inflating it, and the Close date property moves without leaving an obvious trace on a board. Filter the report to exclude deals past your time in stage threshold and the number drops, usually by more than people expect. That drop is the honest figure.

Deals with no Amount are the second leak. They count as pipeline on a board and as zero in a sum of Amount report, so your coverage reads low while your deal count looks healthy. Deals with a placeholder amount are worse, because they are confidently wrong.

The third is duplicates, which arrive with integrations and with reps creating a second deal rather than reopening a closed one.

Fix all three at the property level before you touch the report. That argument sits in full in our piece on why the right fields beat more fields.

Who owns pipeline coverage and when should you review it?

RevOps owns the calculation and the sales leader owns the response to it. Review coverage weekly for the quarter you are selling into and reset the ratio quarterly against the previous twelve months of closed data.

A coverage ratio that never moves is a report nobody is cleaning. The number should respond to win rate shifts, slippage and segment mix, and a flat line across four quarters means the inputs have stopped being maintained. Putting the review in a fixed slot is the difference between a managed number and a dashboard tile, and our guide to designing your revenue operating cadence sets out where it belongs in the week.

Fractional RevOps is how we usually run this. We derive the ratio from your own closed data, build the report in your portal, and hold the review in the weekly cadence rather than handing over a template. Book a call to talk through your pipeline coverage and we will look at your last twelve months of closed deals on the call.

FAQs