Tempio

Budget allocator template for B2B SaaS

Free download as CSV and Markdown. Nothing sits in front of the file: no form, no account, no email address.

The files

What it is

The budget allocator with three columns a subscription business needs: which slice of the ideal customer profile a share is for, where in the funnel it acts, and how much pipeline coverage the share is meant to produce.

Everything else is the general allocator, unchanged. One row per destination, a basis for every share, a floor and a ceiling, and a reallocation rule written before it is needed.

When to use it

Use it when the budget has to serve a number that will not be visible for a quarter. An allocator argued only on last month's cost per lead will move money towards demand capture every time, because capture is always cheaper, and the pipeline will stop growing about two quarters later.

Use it again at the start of each quarter, with the previous version and its outcomes in front of you.

Every field, and what belongs in it
TypeHow to fill it
Allocation nameTextWhat this split is called and the period it covers, normally a quarter, because budgets, targets and pipeline coverage in this business are all set quarterly.
DestinationTextWhat the share goes to, at the level the argument happens: an ICP segment, a funnel stage within one, a named channel. One destination per row, never a blend of two stages.
BasisTextWhat the share rests on: measured performance from your own pipeline, a bet on a segment with no history, a contractual commitment, or a floor somebody insisted on. Named separately so each can be judged.
Share of totalPercentThis row's proportion of the quarter's budget. The column is where a drift towards demand capture becomes visible before it has emptied the top of the funnel.
Amount (minor units)IntegerThe share as money, in the smallest unit of its currency, as a whole number, so the quarterly rows add to the figure the revenue plan assumed.
CurrencyISO 4217 codeThe ISO 4217 code this destination is billed in. A company selling into several regions runs several, and a share is a proportion of one currency's total rather than of a converted sum.
Floor (minor units)IntegerThe least this row can hold and still do its job. For an awareness row set it from the weight needed to reach the segment often enough to be remembered, not from what is left over.
Ceiling (minor units)IntegerThe most this row can absorb before the money buys frequency rather than reach, which for an account-based row is set by the size of the list. Write unknown where it genuinely is.
Reallocation ruleTextThe condition that lets money move in or out of this row, and the cap on a single move. Awareness rows are excluded from weekly reallocation by design, and the rule should say so in words.
Review cadenceTextHow often this row is re-argued: fortnightly for capture, quarterly for awareness. Reviewing awareness on a two-week cost per lead is how upper-funnel spend is cut without a decision.
EvidenceTextWhat the share rests on, named: the baseline window from your own pipeline, the deal size for this segment, the coverage assumption, the test result behind a bet.
OwnerTextThe person who defends the size of this row, and for anything upstream of capture that is whoever owns the pipeline number rather than whoever spends the budget.
NotesTextWhat the next person needs: the assumption behind a bet, the coverage this row was sized against, the segment whose deal size nobody has checked recently.
ICP segmentTextThe slice of the ideal customer profile this share serves: a size band, an industry, a role. It sets the deal size, and therefore what a lead from this row is worth.
Funnel stageTextWhere this share acts: awareness, demand capture, pipeline acceleration, expansion. Blending stages in one row is how a split quietly stops funding anything upstream.
Pipeline coverageTextWhat this row is meant to contribute towards the coverage a quarter needs, as a proportion or an amount. It is the link between a media budget and a revenue number.

The cheapest row is not the most valuable row

Every allocator in this category faces the same gravitational pull. Demand capture — search, branded terms, anything where the buyer has already decided to look — is cheaper per lead than anything else in the account, because the intent was already there. An allocator argued on last month's cost per lead will move money towards it every single time.

The result is familiar. Efficiency improves for two quarters, the pipeline stops growing, and nobody can point to the decision that caused it, because there was no decision — only a series of reasonable-looking reallocations.

The columns here exist to make that pull visible and resistible. Funnel stage in every row, so awareness and capture cannot be compared as though they were the same purchase. Pipeline coverage in every row, so a share has to say what it is for and when. And a basis column that lets a share be argued as a bet rather than pretending to be a measurement.

One segment, one stage, one row

The ICP segment column sets what a lead from this row is worth. A lead from a segment with a large deal size can cost several times what a lead from a small one can and still be the better purchase, and a split that does not carry the segment will quietly optimise towards the cheapest leads regardless of what they are worth.

The funnel stage column sets what the row is buying. Awareness is buying future demand in a named market. Capture is buying present demand. Acceleration is buying speed on deals that already exist. Expansion is buying revenue from customers you already have. Four purchases, four timescales, four appropriate cadences.

Rows that mix them cannot be argued about usefully, because every question asked of the row has a different answer depending on which half you mean.

Cadence is the protection

The review cadence column does more work in this category than in any other.

An awareness row reviewed weekly, against a weekly cost per lead, will be cut. Not because it is failing, but because the evidence for it does not arrive on a weekly schedule, and the row it is being compared with produces its evidence immediately. The only defence is to fix the cadence in advance: awareness rows are re-argued quarterly, on reach into the named segment and on what happened to capture volume afterwards, and they are explicitly not reallocated on a two-week cost per lead.

That rule has to be written into the allocator while everyone is calm. Written down, it holds. Left implicit, it lasts until the first bad month.

Coverage is what a share is for

The pipeline coverage column connects the split to the number the business actually cares about.

Each row says what it contributes and to which quarter. An awareness row for the mid-market segment might contribute to coverage two quarters out. A capture row contributes to the current one. An acceleration row contributes to conversion rather than to volume.

The value of writing it down is that it makes the allocator re-plannable. When the revenue plan changes — a target moves, a segment is deprioritised, a product launch slips — the rows that need to change are identifiable in one pass instead of by argument.

Floors, in a category where thin spending is invisible

A floor is the least a row may hold and still do anything. In this category the failure is particularly quiet, because a thinly funded awareness row still produces impressions, still reports a cost per thousand, and still looks like it is working.

Set floors from reach rather than from leads: what weight is needed to reach the named segment often enough to be remembered. Below it, the row is buying a scattering of impressions across a market that will not recall any of them, and the money would do more in one of the other rows.

The practical consequence is uncomfortable and correct: an allocator with nine underfunded segments should become one with three funded ones.

Bets, named as bets

The basis column lets a row be argued as a strategic bet, and this category needs that more than most, because half the useful moves — a new segment, a new channel, a new region — have no baseline by definition.

Name the bet, write the assumption behind it in the notes, give it a floor large enough to produce an answer, and give it a cadence long enough to be wrong informatively. Then judge it on the question it was funded to answer rather than against the performance rows it sits beside.

A bet that is never named is either cut early or defended forever, and both outcomes teach the team nothing.

Before you commit the allocation

Every row names an ICP segment and one funnel stage. Awareness rows carry a quarterly cadence and are excluded from weekly reallocation. Shares sum to one whole per currency. Every row has a floor set from what it takes to do the job, not from what is left over. Every row states what coverage it contributes and when. And every bet is named as a bet, with its assumption written down and a cadence long enough to test it.

An allocator that passes those six is not necessarily the right split. It is a split whose reasons survive the quarter, which is what makes the next one better rather than merely different.

The general template, and other industries

Templates that go with it

Related reading

Questions

Put frontier AI to work on every ad account you run.

Tempio connects your ad accounts into one workspace and hands your own AI the numbers and the tools. Every change it writes is a draft until you approve it, or until a rule you wrote does.

Request early access
  • Read and draft by default. Approve is a separate permission you grant.