Most B2B teams set their ad budgets before they understand how many leads it actually takes to close one deal. The result is a number pulled from a competitor benchmark or a gut feeling, and when the quarter ends short, nobody can explain why. The fix is not a bigger budget. It is working backwards from your revenue target using three numbers you already have: average deal size, close rate, and average sales cycle length.
Why Most Pipeline Targets Are Guesswork
The most common approach is to take last year's revenue target, add 20%, and hand that to marketing to figure out. This skips the middle layer entirely: how many qualified opportunities, SQLs, MQLs, and raw inquiries does that revenue number actually require? Without mapping each stage and its conversion rate, budget decisions are arbitrary and attribution becomes impossible later.
A company targeting $2.4M in new ARR with an average contract value of $40,000 needs 60 closed deals. If their historical close rate from SQL to closed-won is 25%, they need 240 SQLs. If only 30% of MQLs become SQLs, that is 800 MQLs. Every number in that chain changes how much paid media makes sense and which channels to use.
This kind of reverse-funnel model is not new, but Gartner's research on the B2B buying journey confirms that buying groups now involve 6-10 stakeholders and timelines have lengthened, which makes accurate stage-level conversion tracking more important than ever. One optimistic assumption early in the funnel compounds into a large shortfall by Q4.
The Four Inputs You Need Before Touching Ad Spend
You need four data points, all of which should come from your CRM rather than industry averages. Average deal size tells you how many deals you need. Close rate from first meeting to signed contract tells you how many opportunities to generate. Lead-to-meeting rate tells you how many raw inquiries to capture. And average sales cycle length tells you how much pipeline you need to be building right now to hit a target six months from now.
- Average deal size (use median, not mean, to avoid distortion from outliers)
- SQL-to-closed-won rate (segment by channel if possible, since inbound and outbound differ)
- MQL-to-SQL conversion rate (flag anything below 20% as a qualification problem, not a volume problem)
- Average days from first touch to closed deal (use this to determine pipeline coverage needed today)
If your sales cycle is 90 days and you want to hit a Q4 target, the pipeline you generate in October is mostly irrelevant. You need to be building it in July. This is the single most common planning error we see in B2B companies that run paid media: they treat ad spend as a same-quarter lever when it is almost always a next-quarter one.
Connecting Pipeline Math to Channel Budget Allocation
Once you know how many MQLs you need per month, you can work out a realistic cost-per-MQL target and compare it against what each channel actually delivers. If you need 80 MQLs per month and your blended cost-per-MQL from Google Search is currently $210, you need roughly $16,800 per month from that channel alone before factoring in any LinkedIn or content spend. That number either fits your unit economics or it does not, and you find that out before launch rather than after three months of data.
Channel selection also changes depending on deal size. For deals above $50,000 ACV, LinkedIn tends to produce higher-quality SQLs despite a higher CPL, because you can target by seniority, company size, and job function rather than keyword intent alone. For deals under $20,000, branded and competitor search terms often outperform LinkedIn on a cost-per-SQL basis. Understanding your deal economics first tells you which trade-off is acceptable. For a detailed look at what paid search actually costs in B2B, see our B2B Google Ads cost benchmarks which breaks down CPCs, CPLs, and conversion rates by sector.
Conversion Rate Benchmarks to Pressure-Test Your Model
Your internal data is the right starting point, but if you are a younger company with limited historical data, you need reference points. In B2B SaaS, a reasonable MQL-to-SQL rate sits between 20-30%, and SQL-to-closed-won typically runs 20-35% depending on how tightly you define an SQL. If your close rate is above 45%, your SQL definition is probably too loose and you are flattering your pipeline. If it is below 15%, your qualification criteria or sales process needs attention before you scale ad spend.
Landing page conversion rate is another lever that changes the entire model. If your paid traffic converts at 1.5% and you improve that to 3%, you halve your cost-per-lead without touching your bids or targeting. This is why pipeline planning and conversion rate optimisation are the same conversation. If your current pages are underperforming, our analysis of why B2B landing pages fail to convert covers the most common structural and copy issues we fix before scaling spend.
How to Use Pipeline Coverage Ratios as a Guardrail
Pipeline coverage ratio is the total value of open opportunities divided by your revenue target for the period. A standard benchmark for B2B is 3x to 4x coverage, meaning if you need to close $500,000 this quarter, you want $1.5M to $2M of qualified pipeline open right now. This ratio accounts for the deals that stall, go dark, or push to the next quarter, which in most B2B sales cycles accounts for 40-60% of the opportunities that enter the funnel.
Coverage ratios also act as an early warning system. If you are entering a quarter with only 1.8x coverage and your average sales cycle is 75 days, no amount of ad spend launched on day one of that quarter will save you. The honest answer is to acknowledge the shortfall, focus paid media on next quarter, and use the current quarter to improve conversion rates within existing pipeline. Attribution modelling helps here too: understanding which touches actually influence deals, not just which ones get last-click credit. Our piece on multi-touch attribution for B2B ROI explains how to build a model that reflects the actual buying journey rather than crediting the last ad click.
Building the Model Into a Single Working Spreadsheet
The simplest version of this model fits on one tab. Row one is your annual revenue target. Divide by average deal size to get deals needed. Divide deals needed by close rate to get SQLs needed. Divide SQLs by MQL-to-SQL rate to get MQLs needed. Divide MQLs by twelve to get your monthly MQL target. Multiply by your blended cost-per-MQL to get a minimum monthly budget floor. Everything above that floor is discretionary scaling, and everything below it is knowingly accepting a revenue gap.
Once the model exists, update it quarterly with actuals. Close rates change. Deal sizes drift. A new product tier or a price increase shifts the whole picture. Teams that run this model live catch problems in month two of a quarter rather than in month three when the miss is already locked in. The model is not a forecast. It is a set of assumptions that forces you to argue about the right things: conversion rates, deal quality, and channel efficiency rather than whether to spend $5,000 more on LinkedIn next month.