Pipeline Forecasting for Marketing Leaders: The Arithmetic Behind the Number You Commit To

In the quarterly review, marketing reports 4.1x coverage and calls the quarter safe. Sales reports a gap of 1.2 million and calls it a demand problem. Both are reading the same CRM. Neither is lying. They have disagreed silently about which opportunities count, what stage weights apply, and whether a deal created six weeks ago in a segment with a five-month cycle can close this quarter.

That meeting repeats every ninety days. It is not a forecasting problem but an arithmetic and definitions problem allowed to look like one.

3x is folk wisdom, not a law

The rule everyone quotes says you need three times your target in open pipeline. It is a reasonable default and a terrible constant, because the right number is determined entirely by your own win rate.

Required coverage is roughly one divided by the win rate at the stage you count from, plus a margin for slippage. Win 40 per cent of qualified opportunities and 2.5x is adequate. Win 15 per cent and 3x is a forecast of missing by half. Anyone quoting 3x without the win rate it implies is repeating something they heard.

What you count matters as much as the ratio. Coverage including opportunities older than twice the median cycle counts ghosts: those deals rarely close, they just never get marked lost. Ten-minute check: pull open pipeline for this quarter, filter out everything created more than 1.5 cycles ago, recompute. In most companies the ratio drops by 20 to 40 per cent, and the new number is the one worth arguing about.

The four inputs, and how the error compounds

A marketing-side forecast is four estimates chained: how many qualified opportunities get created, what proportion convert, at what deal size, over what cycle length. Each looks harmless alone. Multiplied, they misbehave.

Be 10 per cent optimistic on volume, 10 per cent on conversion and 10 per cent on deal size, and the forecast is not 10 per cent high. It is 1.1 cubed, or 33 per cent high. Three defensible assumptions compound into a number nobody would have accepted if stated directly.

Cycle length is crueller still, because it does not scale the answer, it moves it into another quarter. A 20 per cent lengthening barely dents the annual figure and can empty the quarter you committed to.

The defence is not more precision. It is fewer multiplications. Forecast the segments where you have enough deals for rates to be stable, and hold the rest as a range with a named assumption. "1.8 to 2.4 million, assuming enterprise conversion holds at 22 per cent" beats a single figure to three decimals, because it tells the reader which assumption to challenge.

Below roughly thirty opportunities in a stage, the conversion rate you compute is mostly noise and moving budget on it is superstition. A segment with eleven deals showing a 45 per cent win rate, presented as fact, is the commonest error here.

Marketing-sourced pipeline is the most disputed number in the company

Sales believes marketing claims credit for accounts it had already worked. Marketing believes sales logs its own source on everything it touches. Both are right often enough to keep the fight alive.

The dispute ends not by finding the true answer but by writing a rule down and dating it.

Sourced means the first identified touch on the account came from a marketing-owned channel, before any outbound activity was logged. Applied mechanically, timestamp decides.

Influenced means marketing engagement occurred inside the opportunity window, regardless of who sourced it. Reported separately, never added to sourced.

Neither is a legitimate answer. Referrals and partner introductions get their own bucket rather than whichever column needs volume.

Two rules make it hold. Compute it in one place, from the signal ledger rather than each team's report. And freeze the source at opportunity creation: if it can be changed later, it will be, in the last week of the quarter. The number stays imperfect, which is fine. Two numbers, both defensible, in one meeting is not.

What moves before pipeline does

Pipeline is a lagging indicator. By the time coverage looks thin, the spend that would have fixed it needed to happen a cycle ago.

The reliable early signals: target accounts showing repeat, multi-person engagement; demo or pricing page visits from accounts already matching the ICP; reply rates on outbound to a fixed segment; the age distribution of first-stage opportunities. Those move four to eight weeks before opportunity creation changes, which is just enough time to act.

Total traffic, form fills and content downloads are less reliable: they correlate with pipeline only when channel mix is stable, and mix is what changes when you increase spend. Track each as a trend against its own history, paired with the lag you believe it has. An indicator with no stated lag cannot be tested, and an untested one is decoration on a command center rather than an input to it.

A forecast is a plan when someone can change it

A forecast is a plan if the person presenting it controls levers that move the outcome and has said what they will pull if the number drifts. Otherwise it is a wish. The test is whether it comes with triggers. "If coverage for next quarter falls below 2.8 by week four, we bring forward the 60k scoped for Q4 and pause the brand campaign." Threshold, action and source of funds, stated before anyone has an ego invested in the number being fine. Without triggers, the review becomes a debate about whether the prediction was reasonable rather than what to do.

When sales and marketing forecasts disagree

Disagreement is information, and three of its four causes are boring.

First, population: are both sides counting the same opportunities, stages, segments and date field? Created date and close date produce wildly different pictures, and this alone explains most gaps.

Second, weighting: sales forecasts judgementally, marketing stage-weighted. Stage weights assume this quarter resembles the last eight. Rep judgement holds information no model has, and optimism that rises near quota.

Third, timing: marketing counts pipeline created in the period, sales counts revenue closing in it. With a two-month cycle these barely overlap and both can be right.

Only after ruling those out do the forecasts genuinely differ, and then you reconcile at deal level on the top twenty opportunities rather than at the aggregate. Aggregates cannot be debugged. Deals can.

Where forecasting stops working

All of this assumes enough deals for rates to mean something. If you close twelve deals a year at 400k each, no conversion rate is stable and a stage-weighted model is arithmetic theatre applied to what is really a list of named accounts. Forecast the accounts, not the funnel: name every live opportunity, state the next event that must happen and the date, review weekly. Less sophisticated, considerably more accurate.

The other limit is regime change. Change the pricing, the segment or the competitive set and your historical rates describe a company you no longer are. Say the model is out of sample and widen the range rather than reporting precision from irrelevant history. An audit comparing what was committed against what landed over six quarters usually reveals whether your model ever worked or only looked like it did.

Frequently asked questions

How much pipeline coverage does a B2B company need?

Enough that coverage multiplied by the win rate of that pipeline clears the target. Required coverage is roughly one divided by the win rate: 40 per cent needs about 2.5x, 15 per cent closer to 7x. The quoted 3x implies a win rate near 33 per cent and misleads anyone winning at a different rate. Count only pipeline that can physically close in the period.

How should marketing-sourced pipeline be defined?

Write one rule, date it, give it an owner. Sourced means the first identified touch on the account came from a marketing-owned channel before any outbound was logged, decided by timestamp. Influenced means marketing engagement occurred inside the opportunity window, reported separately and never added to sourced. Referrals get their own bucket. Compute it in one place, and freeze the source at opportunity creation, because a source that can be edited later will be.

Why do marketing pipeline forecasts miss?

Usually because error compounds. A forecast multiplies opportunity volume, stage conversion, average deal size and cycle length, so three assumptions each 10 per cent optimistic produce a number 33 per cent high. Cycle length is worse: a 20 per cent lengthening does not shrink the annual figure, it moves revenue into the next quarter.

What should marketing watch if pipeline is a lagging indicator?

Indicators that move four to eight weeks earlier: repeat multi-person engagement from target accounts, demo and pricing page visits from accounts matching the ICP, reply rates on outbound to a fixed segment, and the age distribution of first-stage opportunities. Track each as a trend against its own history with a stated lag, so the claim that it leads pipeline can be tested.