B2B SaaS Pipeline Math and Coverage Modelling

A CFO asks how many leads marketing needs next year. If the answer takes a week and a consultant, the marketing team will be judged on activity for another twelve months. The arithmetic is six divisions and one time shift, and it should be done on a whiteboard in front of the person asking.

Here is the whole model, built in public, with a six million dollar example carried the whole way through and the places it breaks marked.

The backwards model, with a $6M example

Start at the revenue target and divide. Every step here is one number from your CRM.

Nine and a half thousand leads. Roughly 795 a month. Now split that by the share sales sources itself: if outbound and partner produce 40 percent of opportunities, marketing’s number drops to about 5,700 leads, or 475 a month.

That last adjustment is the one teams forget, and it is the difference between a plausible plan and a number nobody believes. Write the source split down before you publish the goal.

Run your own numbers through the B2B SaaS pipeline coverage calculator rather than rebuilding the spreadsheet, and use the lead goal calculator if you only need the top of the chain.

Coverage ratios, and why 3x is a starting point rather than a law

Pipeline coverage is open qualified pipeline divided by the target for the period. The number that matters is one divided by your win rate.

Then adjust for two things. Add a buffer for slippage, because deals move quarters even when they do not die: 10 to 20 percent on top is normal. And measure coverage at the start of the quarter, not mid quarter, because coverage measured after half the quarter’s deals have closed is a tautology.

The failure this table exposes: a team hitting 3.2x coverage and missing revenue does not have a pipeline problem. It has an 18 percent win rate being reported as 33. More demand generation spend will not fix that, and spending it is how a quarter of budget disappears into opportunities nobody could have closed.

Phasing the goal against sales cycle lag

This is the step that separates a model from a spreadsheet. Take the median cycle length from qualified opportunity to close, not the mean, because a handful of 400 day deals distorts the mean badly.

With a 120 day median cycle and a revenue plan that back loads into Q4, the leads supporting Q4 revenue must land in late Q2 and Q3. A flat monthly lead goal against a back loaded revenue plan guarantees a Q4 miss, and the miss gets blamed on Q4 execution when it was created in June.

That final check is where a lot of plans quietly fall apart. Generating 558 opportunities a year with six AEs means roughly 93 opportunities per rep per year, or eight a month entering their pipeline while they work the previous months’ deals. That is at the top of what a mid market AE handles well. Name the constraint out loud before you commit to the number.

The demand generation forecasting model extends this into a rolling forecast, and setting lead goals and pipeline coverage has the shorter operational version for a quarterly planning meeting.

Sourced versus influenced targets without a fight

Two targets, two definitions, written down before the quarter starts.

Marketing sourced pipeline. Marketing created the first qualified contact at the account, with no sales activity at that account in the prior 90 days. Target this as a share of total new pipeline: 40 to 60 percent is typical for inbound led companies, 20 to 35 percent where outbound dominates.

Marketing influenced pipeline. A meaningful marketing touch, defined as a form fill, event attendance, content download or webinar registration by any contact on the opportunity, occurring within the open opportunity window. Not a pageview. Not an email open.

Cap the influence window at the deal’s open period. Uncapped, influenced pipeline drifts toward 90 percent and stops informing anything, at which point sales stops reading the slide.

The lead definitions underneath this need to be settled too, particularly where a product led motion is running alongside a sales led one. The MQL vs PQL comparison covers the boundary, and the MQL definition is worth agreeing on in writing before it appears in a target.

The four failure modes

Stale pipeline. Age every open opportunity by days since last stage change. Anything sitting past 1.5 times your median cycle in the same stage is dead. Recompute coverage without it. The first honest recount typically removes 20 to 35 percent of open pipeline, and that single exercise explains most quarters where coverage looked healthy and revenue missed.

Sandbagged win rates. If reps or leadership quote a win rate 5 points above reality, your lead goal is understated by roughly 20 percent. Compute win rate from the CRM yourself, from qualified opportunity, over four quarters, including deals marked no decision as losses. Excluding no-decision deals is the single most common way win rate gets inflated.

Coverage hiding a conversion problem. Covered above and worth repeating, because it is the most expensive. When coverage is met and revenue is not, spend the next quarter’s budget on conversion, not volume.

Averaging across segments. A 45,000 dollar blended ACV made of 8,000 dollar SMB deals and 140,000 dollar enterprise deals produces a lead goal that is meaningless for both motions.

Defending the number in a board meeting

Bring three things. The chain, with every conversion rate labelled with the period it came from. The sensitivity table showing what happens if win rate moves 3 points either way. And the capacity check showing whether AE headcount can work the opportunities you plan to produce.

That table is the most useful slide in the deck, because it reframes the conversation. A three point win rate improvement is worth roughly 1,000 fewer leads a year, which is often cheaper to buy through enablement and better qualification than through media spend. Boards understand that trade immediately, and it moves the discussion off “why is marketing asking for more budget”.

The position

A marketing team that cannot recompute its lead goal from first principles, live, with no spreadsheet, will always be judged on activity rather than revenue. The arithmetic is not hard. The discipline is in using your own conversion rates, running it per segment, and phasing it against a real cycle length instead of a flat twelve months.

Do this next. Pull four quarters of closed opportunities, compute win rate with no-decision deals counted as losses, and compare it to the number people quote in meetings. If there is a gap, that gap is your plan’s error rate, and fixing it is worth more than any campaign you will run this quarter. The pipeline coverage definition is worth sending round beforehand, the SaaS PPC budget calculator converts the lead gap into a media number, and the wider funnel context sits in the B2B SaaS marketing hub.