Budget allocator template
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
A budget allocator is one row per destination and one argument per row. A destination is wherever the money can go — a channel, a phase, a segment, a market — and the row records what its share is, what the share is argued from, the least and the most it can usefully hold, and what has to be true before money moves.
That is the whole shape. Everything else on this page is about what belongs in each column, and about why the two columns most allocations leave out, the floor and the reallocation rule, are the two that decide whether the split survives contact with a bad week.
When to use it
Use it whenever a total has to be divided and more than one person has a view about how. The allocator is where the division is argued once, in writing, instead of repeatedly in meetings where whoever is unhappiest that week gets the increase.
Use it again on each row's own cadence. An allocation is not a decision you make in January; it is a decision you re-make on a schedule, with the previous version and its reasons in front of you.
| Type | How to fill it | |
|---|---|---|
| Allocation name | Text | What this split is called and the period it covers, in the words the team will use. The same name goes on the review, so a decision can be traced to the argument that produced it. |
| Destination | Text | What the share goes to: a channel, a campaign, a phase, a segment, a market. One destination per row, at whatever level the argument is actually being had. |
| Basis | Text | What the share is argued from: measured performance, a strategic bet, a fixed commitment, or a floor somebody insisted on. The four are not the same and should never be blended silently. |
| Share of total | Percent | This row's proportion of the whole budget. The column that makes the split visible as a shape rather than as a list of numbers, and the one a reviewer actually reads. |
| Amount (minor units) | Integer | The share as money, in the smallest unit of its currency: 150000 is 1,500.00. Whole numbers, because a column of decimals drifts a cent per row and the shares then fail to sum to the total they describe. |
| Currency | ISO 4217 code | The currency the destination bills in, not the one you report in. Shares are proportions of a total in one currency; two currencies in one allocation need two totals. |
| Floor (minor units) | Integer | The least this destination may hold and still be worth running. Below a floor a line stops learning and starts producing noise, and the floor is where that judgement is written down. |
| Ceiling (minor units) | Integer | The most this destination can absorb before the money stops buying anything new: a saturated audience, a capped inventory, a finite list. Blank where you genuinely do not know. |
| Reallocation rule | Text | What has to be true for money to move into or out of this row, and how much may move at once. Written before it is needed, so the decision is not made under pressure. |
| Review cadence | Text | How often this row is re-argued: weekly, monthly, at the end of a flight. A row with no cadence is a row that will be re-argued whenever somebody is unhappy. |
| Evidence | Text | What the share rests on, named: a baseline window from your own account, a contract, a test result, a stated assumption. A share with no evidence is an opinion with a decimal point on it. |
| Owner | Text | The person who answers for this row. Not the person who spends it — the person who defends the size of it when somebody asks why it is that big. |
| Notes | Text | What the next person needs: the assumption behind a bet, the commitment that cannot be unwound this quarter, the number that is a guess. Say plainly which is which. |
An allocation is an argument, written down
Most budget splits exist as a number in a slide and a set of half-remembered reasons. That is fine until somebody wants more, at which point the conversation starts from nothing and the increase usually goes to whoever argues hardest rather than to wherever the money works best.
An allocator fixes that by making the argument the document. One row per destination, and in each row not only the share but what the share rests on: a baseline read from your own account over a named window, a contract that cannot be unwound, a test result, or a stated assumption somebody is willing to own.
The immediate benefit is that the next conversation starts from the last one. The longer-term benefit is that a year of allocators shows what the team has actually believed over time, and how often those beliefs were right, which is the only way a split gets better rather than merely different.
Four bases, kept apart
The basis column asks what kind of claim a share is. There are broadly four, and the damage comes from blending them silently.
Measured performance is a share argued from a number you can point at: this destination has produced results at this cost over this window. A strategic bet is a share argued from a belief about the future: a new channel, a new market, an audience you think is undervalued. A fixed commitment is money that is already promised — a contract, a sponsorship, a minimum spend. And a floor is a share somebody has insisted on for reasons that are political rather than empirical, which is a real category and worth naming honestly.
Keep them in separate rows. A bet hidden inside a performance line makes the line look worse than it is and makes the bet unaccountable; a commitment folded into a performance line makes a fixed cost look like a choice. Once they are apart, each can be judged on its own terms, and the total becomes readable: this much is bought on evidence, this much on belief, this much is not really available at all.
Floors and ceilings are where the real decision is
Shares are what people argue about. Floors and ceilings are what actually determine whether a split works.
A floor is the least a destination may hold and still be worth running. Below it, a line does not simply produce less — it produces noise: too few results to distinguish from chance, too little delivery to leave the platform's learning behind, and a cost per result that swings wildly enough to justify any conclusion anybody wants to reach. Writing the floor down forces the real choice, which is that a destination is either funded properly or not funded at all. A split spread thinly across nine destinations, each below its floor, is not diversification; it is nine experiments none of which will produce an answer.
A ceiling is the most a destination can absorb before the money stops buying anything new. Audiences saturate, lists are finite, inventory is capped, a market has only so many buyers at a price. Leave the ceiling blank where you genuinely do not know it — that is honest — but fill it where you do, because the most common way an allocator fails is by pouring the freed budget from one row into another row that was already full.
Write the reallocation rule before you need it
The reallocation rule is the column that makes the allocator usable after the first bad week.
A good rule has three parts: a condition, a size and a direction. If the cost per result stays above target for two consecutive weeks, move up to a fifth of this row's amount into the row with the best rolling result. That can be applied by whoever is looking, on a Monday, without a meeting.
The size limit matters as much as the condition. Unbounded reallocation produces a budget that chases last week everywhere, which reliably underperforms a split that moves slowly, because most week-to-week variation is noise rather than signal. A cap on how much may move at once is the cheapest protection against that, and it is much easier to agree in advance than in the middle of a bad fortnight.
Rules written under pressure get argued about. Rules written in advance get followed, which is the entire point.
Cadence, and not re-litigating everything at once
Each row carries its own review cadence. A performance row might be weekly. A bet might be reviewed at the end of a quarter, because reviewing it sooner is just re-asking whether you still believe it. A commitment is reviewed when it can actually be changed.
Staggering the cadences is deliberate. An allocator that is entirely re-argued every month is an allocator nobody trusts, because the split never stays still long enough to produce evidence about itself. Fixing the cadence per row, in advance, is what lets a bet run long enough to be wrong in an informative way.
Before you commit the allocation
Six checks. Every row names a destination, a basis and an owner. Shares sum to one whole per currency. Every row has a floor and none is funded below it. Every row has a reallocation rule, written while nothing was going wrong. Every share names the evidence it rests on, or says plainly that it is an assumption. And the four bases sit in separate rows, so that the total can be read as what it is: a mixture of things you know, things you believe and things you have already promised.
Made for your industry
Budget allocator template for B2B SaaS
A free budget allocator template for B2B SaaS as a CSV and a Markdown file, with columns for the ICP segment, the funnel stage and pipeline coverage.
Budget allocator template for Ecommerce
A free budget allocator template for ecommerce as a CSV and a Markdown file, with columns for the catalogue segment, its margin and the promotion reserve.
Budget allocator template for Fintech
A free budget allocator template for fintech as a CSV and a Markdown file, with columns for the product, the jurisdiction and the approval rate assumed.
Budget allocator template for Healthcare
A free budget allocator template for healthcare as a CSV and a Markdown file, with columns for the service line, its capacity and the referral mix.
Budget allocator template for Real estate
A free budget allocator template for real estate as a CSV and a Markdown file, with columns for the listing or office, vendor funding and the market.
Templates that go with it
Account audit template
A free ad account audit template as a CSV and a Markdown file: one row per finding, with evidence, severity, a named owner and a due date.
Media plan template
A free media plan template as a CSV and a Markdown file: one row per line of spend, with notes on what belongs in every column and why.
Performance review template
A free performance review template as a CSV and a Markdown file: one row per line, with planned against actual, the cause, and a decision with an owner.
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.