Budget allocator template for Real estate

The budget allocator with three columns an agency needs: which listing or office a share belongs to, how much of it the vendor is funding, and which market it is being spent into.

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.

Use it when the same marketing budget covers listings paid for by vendors and presence paid for by the agency. Those two kinds of money have different owners and different tests, and an allocator that does not separate them will eventually spend one on the other.

Use it again at the start of every campaign period, and whenever the office takes on a listing large enough to change the shape of the split.

An agency's marketing budget is not one budget. It is a large number of small campaigns paid for by vendors, plus the office's own spend on being visible in its market, and the two behave completely differently.

Vendor money is committed to one property. It cannot be moved to another listing because that listing is doing better, it cannot be borrowed for the office's brand campaign, and it has to be accountable to the person who paid it. Office money is genuinely allocatable and is judged on appraisal requests rather than on enquiries for any particular home.

Putting both in one allocator, in clearly separated rows, is what makes the total honest. Leaving them in separate documents is how an office loses track of what it is actually spending; blending them into shared rows is how a vendor ends up funding the agency's presence.

The vendor funded column is the one that does the work. It records how much of the row somebody else is paying, and by implication how much of it is available for reallocation: usually none.

That marking matters because everything else in an allocator is about moving money to where it works best. A rule that does that across an office's whole budget is correct for the office's own rows and wrong for every vendor row in the sheet. Writing it in the row, rather than trusting it to be understood, is the difference between a rule that can be applied safely and one that has to be supervised.

The corollary is that the genuinely allocatable portion of an agency's budget is smaller than the total suggests. That is worth seeing plainly, because it is the money that decisions can actually be made about.

In most categories geography is a targeting detail. In property it is most of the targeting, and it is the single biggest driver of what a share achieves.

Two corridors with similar prices can have very different competition, very different volumes of buyers, and very different costs to reach them. A cost per enquiry from one says almost nothing about the other, so rows that combine markets produce an average that cannot be used to argue for anything.

One market per row, named the way the office names it. Over a few campaign periods the allocator then answers a question most agencies cannot: what a campaign in this corridor, at this bracket, actually costs.

A floor in this category protects the vendor as much as the agency.

A listing campaign below its floor is present but not visible: it reaches a fraction of the corridor, a small number of times, and produces enquiries too thin to fill an inspection. The property then carries the reputational cost of a quiet campaign, and the agency carries the conversation about why.

Set floors from what a campaign in that market and bracket needs to reach the buyers who plausibly exist for it. Where a vendor's budget cannot reach the floor, the honest response is a different plan — a shorter campaign at proper weight rather than a long one at a level that does nothing — and the allocator is the right place for that conversation to start.

Ceilings matter here for the opposite reason and they matter often.

The pool of plausible buyers for a specific home in a specific corridor at a specific price is genuinely small. Past a certain weight, more money buys more frequency against the same people, and frequency against a small audience produces irritation rather than enquiry. A large vendor budget spent entirely on one corridor will hit that point well before the campaign ends.

Where the ceiling is reached, the useful moves are wider geography, adjacent price brackets, or different placements rather than more of the same. Writing the ceiling into the row is what makes that a plan rather than a mid-campaign scramble.

Agency presence spend is real and worth doing, and it fails when it is judged on the wrong number.

Give it its own rows, its own basis — usually a bet or a fixed commitment rather than measured performance — and its own metric, which for most offices is appraisal requests or listing presentations won. Judged on enquiries, it will always lose to a listing row, because a listing row is selling something specific to people who want exactly that.

Give it a slower cadence too. Presence works over quarters, and an allocator that re-argues it monthly will cut it in the first quiet month.

The evidence column should name your own recent campaigns in this market and bracket: what a campaign cost, how many inspections it produced, how many registered buyers.

There is no external figure that can stand in. Property markets differ street by street, and a benchmark from another city describes a different auction. Where an office is new to a corridor, name the row as a bet, write the assumption down, and treat the first campaign there as the thing that produces the baseline.

Every row names a listing or the office and states how much of it the vendor is funding. Vendor-funded rows are marked as unavailable for reallocation. Shares sum to one whole per currency. Every listing row has a floor set from what a campaign in that market and bracket needs. Office presence sits in its own rows, with its own metric and a slower cadence. And every market is named, with no row covering two.