Skip to content
Faisal Mahmud TusherDigital marketing, SEO & analytics
with Faisal Tusher

B2B Marketing › Advanced

Building a Pipeline Budget for a Fleet Telematics Firm

An invented fleet telematics provider sets its marketing budget as last year's figure plus a little. You replace that with a budget built from the revenue target: deals, opportunities and leads by segment, acquisition limits from customer value on gross margin and a payback rule, a channel plan priced against those limits, and the assumptions sales and finance must sign before the year starts.
ExerciseAdvanced levelModule 1: Pipeline economics and budget5 minUpdated

Why this matters

A budget set as last year plus a little cannot say what it buys, so it cannot be defended when finance asks or cut sensibly when the year goes badly. Working back from revenue turns the budget into a statement about the Funnel: how many leads, at what cost, to produce how many deals. The guide to lifetime value and acquisition cost sets the ceiling on what a customer is worth acquiring; the budget calculator walkthrough for lead generation turns a lead count and a cost per lead into a total. Here the work is in the segments and the limits.

The firm and its inherited budget

Routewise Telematics is an invented provider of vehicle tracking software, sold by annual subscription to small and mid-sized fleets. Sales and finance have set next year's new-business target, and marketing must say whether last year's budget, carried forward with a small increase, can deliver it.

Illustrative example — not a real result

Routewise Telematics: targets, funnel rates and channels

New annual recurring revenue target: £1,200,000, of which small fleets £400,000 and mid-sized fleets £800,000.

MeasureSmall fleetsMid-sized fleets
First-year contract value£6,000£30,000
Lead to opportunity12%20%
Opportunity to won30%20%
Typical sales cycleTwo monthsSix months
Gross margin70%75%
Annual churn20%10%
Sales cost per won deal£1,200£6,000

Finance rule: total acquisition cost, sales included, must be repaid from gross margin within twelve months, and three-year customer value must be at least three times acquisition cost.

ChannelSegmentRecent cost per leadLeads available at that cost in a year
Google searchSmall£651,200
Software review sitesSmall£90800
LinkedInMid-sized£240400
Trade showsMid-sized£400150
Partner webinarsMid-sized£150125

Last year's budget: £220,000. Proposed for next year: £231,000.

From revenue target to pipeline coverage

Work each segment separately, because the rates differ too much to blend. Divide the target by contract value for deals, by the win rate for opportunities and by the lead-to-opportunity rate for leads, using stages defined as in the guide to lead stages. Pipeline coverage, the value of open opportunities against the target, is simply the inverse of the win rate, so a segment that wins less often needs more coverage. Cycle length decides when that pipeline must exist: a six-month cycle means the leads for next spring's deals are bought this autumn.

Then set the ceiling. Customer value (LTV) is built on gross margin over a fixed window with the segment's own churn, not on contract revenue, and the payback rule from the retention and payback guide caps acquisition cost (CAC) where cash is the constraint.

Task

  1. Work back from each segment's target to deals, opportunities, leads and pipeline coverage.
  2. Calculate three-year customer value on gross margin for each segment.
  3. Set the maximum acquisition cost from the finance rule, then the marketing allowance per deal and per lead.
  4. Price the leads by channel against those limits and size the budget with a reserve.
  5. Test how sensitive the budget is to the weakest rate.
  6. List the assumptions sales and finance must agree before the year starts.

Worked answer

Illustrative example — not a real result

Routewise Telematics: from target to budget

Small fleets: £400,000 ÷ £6,000 ≈ 67 deals; ÷ 0.30 ≈ 224 opportunities; ÷ 0.12 ≈ 1,867 leads. Coverage: 224 × £6,000 = £1,344,000, about 3.4 times the target. Mid-sized: £800,000 ÷ £30,000 ≈ 27 deals; ÷ 0.20 = 135 opportunities; ÷ 0.20 = 675 leads. Coverage: 135 × £30,000 = £4,050,000, about 5.1 times the target.

Three-year value on gross margin. Small: £4,200 + £3,360 + £2,688 = £10,248. Mid-sized: £22,500 + £20,250 + £18,225 = £60,975.

Maximum acquisition cost, the lower of first-year margin and a third of three-year value: small £3,416; mid-sized £20,325. Less sales cost: marketing may spend £2,216 per small deal and £14,325 per mid-sized deal. Per lead: small £2,216 × (0.12 × 0.30) ≈ £80; mid-sized £14,325 × (0.20 × 0.20) ≈ £573.

Budget. Small: search 1,200 × £65 = £78,000; review sites 667 × £90 = £60,030. Mid-sized: LinkedIn 400 × £240 = £96,000; trade shows 150 × £400 = £60,000; partner webinars 125 × £150 = £18,750. Total £312,780; with a 10% reserve, about £344,000. The proposed £231,000 funds about two-thirds of it.

Sensitivity: a mid-sized win rate of 19% instead of 20% needs 143 opportunities and 715 leads, 40 more, about £10,400 at the segment's blended cost per lead.

What the numbers say. The inherited budget cannot deliver the target at current rates; either the budget rises to roughly half as much again as last year, or the target falls, or a rate improves, and sales and finance should choose knowingly. Mid-sized fleets carry the plan: every channel there sits far below its ceiling, so this is where extra money is safest. Small fleets are tight. Search fits under the per-lead ceiling, but review sites cost more per lead than a small-fleet customer can repay; cap their bids near the ceiling and accept fewer leads, or test whether their leads qualify at a better rate before paying full price.

Timing. Mid-sized deals take half a year, so the first half of next year's mid-sized revenue depends on leads bought in the coming months. The budget should start now, not in January.

Assumptions to agree in writing. Contract value and win rate by segment, lead-to-opportunity rate measured over a full cycle, stage definitions, churn and gross margin, sales cost per deal, the payback rule and the date the plan will be re-forecast if a rate drifts. A rate nobody signed is a rate nobody owns when it misses.

Common mistakes

  • Blending segments. One average rate fits neither segment and misprices both.
  • Customer value on contract revenue. Margin and churn decide what a customer is worth.
  • Ignoring sales cost. Marketing's allowance is what remains after the sales effort per deal.
  • Starting spend with the revenue period. Long cycles need the pipeline months earlier.

Next, take the pipeline economics checkpoint or revisit the intermediate business-to-business level.

Pages this lesson applies

Terms used on this page

Also related

Related