Every Revenue Target Divides Down to a Weekly Number
Most annual plans contain a revenue target on one page and a list of marketing activities on another, with nothing in between. The target came from finance. The activities came from marketing. Nobody wrote down the arithmetic connecting them, which means that in week six, when someone asks whether the year is on track, the honest answer is that nobody can tell yet.
The arithmetic is not complicated. It is four divisions, and it ends at a number small enough to manage on a Monday morning.
The rule hiding inside “3x pipeline”
Ask most commercial teams how much pipeline they need against a target and the answer is three times. It is the most repeated number in growth planning, and it is not a rule. It is an assumption about win rate that nobody says out loud.
Coverage has to be at least 1 divided by your win rate.
| If you win | You need at least | Because |
|---|---|---|
| 40% of opportunities | 2.5x coverage | 1 ÷ 0.40 |
| 33% | 3.0x | 1 ÷ 0.33 |
| 25% | 4.0x | 1 ÷ 0.25 |
| 20% | 5.0x | 1 ÷ 0.20 |
| 15% | 6.7x | 1 ÷ 0.15 |
Three times coverage is correct if you win a third of what you quote. If you win a quarter, you need four times. If you win a fifth, you need five. A team closing 15 percent and planning at 3x is not being optimistic, it is planning to miss, and the miss was created in the spreadsheet before a single campaign ran. No amount of channel optimisation closes a gap that was built into the plan.
This is also the first place to look when a year goes wrong and everyone reaches for the marketing budget. Check the coverage assumption before you check the ads.
How the numbers connect
Read it top to bottom. Every line is derived from the one above it, which is why a change anywhere upstream moves everything below it.
-
GivenThe revenue target
Set by ownership and finance. Marketing does not negotiate this number, marketing works backwards from it. Everything below is a consequence of this line.
-
DerivedRequired pipelineRevenue target ÷ win rate
The most important dependency in the whole stack, and the one marketing controls least. Win rate is largely a sales execution and product fit number, but it sets marketing's workload. A five point drop in win rate can raise the pipeline marketing has to create by a third.
-
DerivedRequired opportunitiesRequired pipeline ÷ average deal size
Watch this one when the company moves upmarket. Larger deals lower the opportunity count you need, which sounds like relief, but they usually lower win rate and lengthen the sales cycle at the same time. Two of those three effects work against you.
-
DerivedRequired qualified appointmentsRequired opportunities ÷ appointment-to-opportunity rate
This is where a sensible department target comes from. Qualified appointments is not an arbitrary choice of metric. It is the revenue target divided down three times, which is exactly why it is worth holding a team to.
-
WeeklyAppointments per weekRequired appointments ÷ selling weeks
The number that turns an annual target into something manageable. Use selling weeks, not calendar weeks: strip out the holiday periods when nobody in your market signs anything. Everything the team does upstream exists in service of this one figure.
-
Efficiency checkCAC paybackSpend ÷ (new revenue × gross margin) × 12
Expressed in months. This answers the question a CFO is actually asking, which is not "what was the return" but "when does the cash come back". Definitions vary widely between companies, so agree yours in writing before anyone quotes a number in a board pack.
-
The timing constraintSales cycle length
This determines how long before any of the above can be fairly judged. Money spent in one quarter shows up as revenue two or three quarters later. A plan that promises results faster than the cycle allows is not ambitious, it is arithmetically impossible.
A worked example
A commercial services business with a target for new contract revenue. Every figure below is invented to show the mechanism. Use your own.
| Step | Figure | Where it came from |
|---|---|---|
| Revenue target | $12,000,000 | given by ownership |
| Average contract value | $40,000 | given, from last year’s book |
| Contracts required | 300 | 12,000,000 ÷ 40,000 |
| Close rate on quotes | 25% | given by sales |
| Quotes required | 1,200 | 300 ÷ 0.25 |
| Quote rate from site visits | 60% | given |
| Site visits required | 2,000 | 1,200 ÷ 0.60 |
| Visit rate from qualified enquiries | 50% | given |
| Qualified enquiries required | 4,000 | 2,000 ÷ 0.50 |
| Selling weeks | 48 | given |
| Enquiries per week | 84 | 4,000 ÷ 48 |
Note what the coverage rule predicted. A 25 percent close rate requires 4x coverage, and 1,200 quotes at $40,000 each is $48,000,000 of quoted work against a $12,000,000 target. The chain and the rule agree, because they are the same arithmetic approached from two directions.
Eighty-four qualified enquiries a week is a number a marketing team can plan against. Twelve million dollars is not.
Now move one number
Take the same business and change nothing except close rate. Sales converts 20 percent of quotes instead of 25.
Close rate 25%
- Contracts required
- 300
- Quotes required
- 1,200
- Site visits required
- 2,000
- Qualified enquiries
- 4,000
- Enquiries per week
- 84
Close rate 20%
- Contracts required
- 300
- Quotes required
- 1,500
- Site visits required
- 2,500
- Qualified enquiries
- 5,000
- Enquiries per week
- 105
A five point move in a number marketing does not control has raised marketing's weekly workload by 25 percent, with no change in target, budget, or headcount.
This is the single most useful thing the chain does. It converts a sales problem into a marketing cost, in public, in advance. The conversation stops being “marketing needs to generate more leads” and becomes “a five point close rate recovery is worth more than a 25 percent budget increase, and it is cheaper”. Both are legitimate options. Only one of them was visible before somebody did the division.
It also disciplines the opposite request. When someone proposes a target increase without touching any conversion rate, the chain shows exactly what that costs in weekly volume, which is usually enough to make the conversation honest.
The same chain, three different businesses
The structure does not change with the business model. Only the names of the steps do.
Commercial services
Quoted work, field sales, long install lead times.
- Revenue target $12M
- Average contract $40k
- Close rate 25%
- Visit to quote 60%
- Enquiry to visit 50%
- Weekly enquiries 84
B2B with a sales team
Committee buying, named accounts, multi-quarter cycles.
- Revenue target $20M
- Average deal $125k
- Win rate 20%
- Appointment rate 40%
- Selling weeks 46
- Weekly appointments 44
Direct to consumer
No sales conversation. Conversion rate does the same job as win rate.
- Revenue target $6M
- Average order $120
- Orders required 50,000
- Site conversion 2.5%
- Selling weeks 52
- Weekly sessions 38,500
Illustrative figures throughout. The point is the shape of the calculation, not the numbers.
In the third case there is no win rate, but the rule still holds: 1 divided by a 2.5 percent conversion rate is 40, so every order needs 40 sessions behind it. Which is why a conversion rate improvement is worth far more than it sounds. Moving that business from 2.5 percent to 3.0 percent cuts the weekly requirement from 38,500 sessions to 32,100, which is a third of a million fewer sessions to buy or earn over a year, at no additional media cost.
When you are allowed to judge it
The chain tells you what to produce. The sales cycle tells you when you are entitled to an opinion about whether it worked.
If the average cycle is four months and the appointment-to-opportunity lag is another few weeks, then spend in January does not fully resolve into revenue until well into the second quarter. Judging a channel at six weeks is not rigour, it is judging an incomplete number and then acting on it. The observation window is not caution or an excuse for slow results. It is cycle length plus lag, and it should be written down at the start, alongside the kill criteria that say what failure will look like when the window closes.
This cuts both ways. It protects a programme from being killed before it can report, and it removes the excuse of “these things take time” from a programme that has had its full window and produced nothing.
What ownership should do with this
You do not need to build the model. You need to ask for it, once, and refuse plans that do not contain it.
When the annual plan arrives, ask for one page showing the target divided down to a weekly number, with every conversion rate in the chain named and sourced. Three things become visible immediately. Whether the coverage assumption is arithmetically sound or a reflex. Which conversion rates the plan is quietly depending on improving, which is where most optimistic plans hide their optimism. And what the weekly number is, which is the only figure in the whole exercise that anyone can actually manage.
A team that can produce that page in an afternoon has been thinking about the business. A team that cannot has been thinking about activities. That distinction is worth more than most of what gets debated in a marketing review, and it takes one question to surface.
Baron Belalov is a fractional CMO working with growth-stage and established companies globally.