A UA Budget Planning Template Built for a Flat Market

Most UA teams built their 2024 budgets on an assumption that never quite held: that cost per install would ease as the market matured. It did not ease evenly. Hybrid-casual and 4X survival titles kept bidding costs high through the back half of last year, and an incumbent such as Monopoly GO! entering its third year live has shown that a whale can keep absorbing the spend a challenger studio needs for its own growth. Going into 2025, the useful task is not forecasting a recovery. It is building a UA budget planning template that survives a market staying flat, or getting worse, without a rewrite every quarter.

Why last year's spreadsheet doesn't travel

Most budget templates assume a single growth curve: spend rises, CPI drifts down as creative and bidding mature, blended payback improves, repeat. That curve needs a market with headroom. A flat market breaks the assumption quietly, because CPMs stay sticky and the top of the download charts belongs to titles with years of accumulated LTV data behind them. Spend can rise while payback stays flat or gets worse, and a template that only tracks spend against install volume will not flag the problem until a quarter has already gone.

The fix is not a new formula. It is separating what a single spend line usually hides: acquisition volume, acquisition efficiency, portfolio mix by channel and creative format. A UA budget planning template for 2025 needs all of that visible on one page and reviewed on the same cadence, or the efficiency erosion sits buried inside a volume number that still looks healthy.

A UA budget planning template with guardrails built in

Set the budget in three layers rather than one top-line number. The base layer funds proven channels and proven creative at last quarter's blended efficiency, and it should take no more than 55 to 65% of total spend. The test layer, roughly 20 to 30%, funds new channels, new creative concepts, new geos, each carrying an explicit kill date if the test has not hit a minimum signal threshold by then. The reserve is the remaining 10 to 15%. It sits unallocated until week four of the quarter, when the first real cohort data arrives.

That structure does what a flat market demands. Most spend stays where the team already knows the efficiency, experimentation has to earn its place against a deadline, and capital sits back until data justifies committing it rather than going out on a forecast somebody wrote in December.

Worked example: a hypothetical quarterly split

Take a mid-size hybrid-casual publisher with a hypothetical $2 million quarterly UA budget. Under the three-layer structure, roughly $1.2 million funds the base layer: Meta and Google campaigns on titles carrying at least two quarters of stable payback data. Another $500,000 or so funds the test layer, split across three creative concepts and one new channel, each with a kill date at day 21 if cost per trial user has not come within 20% of the base layer's average. The remaining $300,000 sits in reserve through week three. Then it goes to whichever test layer bet is beating its kill threshold, rather than getting spread evenly across all of them by default.

The numbers are illustrative, not benchmarks. What matters is the mechanism: a fixed date on which unproven spend either earns more budget or gets cut, written into the plan before the quarter starts rather than argued over in a review meeting once the money has already gone out.

Run the same structure against a second hypothetical, a mid-core or 4X studio with a smaller and more concentrated $800,000 quarterly budget, and the proportions shift. The base layer might sit closer to 70% of spend, since 4X payback curves run long enough that a title needs a full quarter or more of stable data before anyone can trust a channel, and the test layer shrinks to match, funding one or two new creative concepts instead of a broad spread. Proportions in a UA budget planning template should flex with payback horizon. They should not stay fixed across genres that monetise on entirely different timelines.

Common allocation mistakes worth naming

Three mistakes recur often enough to flag directly. One is sizing the test layer to whatever is left over after the base layer takes what it needs, rather than setting it as a deliberate percentage first; leftover-based test budgets shrink exactly when a team is under pressure to protect near-term efficiency, which is precisely when testing new concepts and channels matters most. Another is starting a test without pre-agreeing what hitting the kill threshold actually means, which turns every kill decision into a negotiation instead of a rule already settled. The third is quieter. Nobody claims the reserve layer in week four, it gets absorbed into the base layer by default, and a three-layer structure turns back into the single-line budget the template exists to avoid.

Reforecast triggers, not calendar reforecasts

Most teams reforecast on a calendar, monthly or quarterly, whatever the data happens to be doing. Tie it to triggers instead: a five-point swing in blended cost per install against the base layer's rolling average, a payback window moving out by more than a week on a top channel, a top-three creative concept losing more than 25% of its efficiency over two weeks. Any one of those should force an out-of-cycle review. Don't wait for the calendar.

This matters more in a flat market than a growing one, because the cost of missing a fatigue signal or a channel efficiency drop compounds for longer before the next scheduled review picks it up. A UA budget planning template that only checks itself once a month is, in a flat market, checking itself too late.

What to change this quarter

Build the three-layer split into whatever planning tool the team already uses, even if that is a spreadsheet. Set explicit kill dates on every test layer line before the quarter begins, not after the first result lands. And swap at least one calendar-based reforecast checkpoint for a trigger-based one this quarter, so the team has practised the discipline before a genuinely bad month forces it on them. The market that greets 2025 will not hand back the headroom that made looser budgeting workable in earlier years. Teams that change their planning structure now spend the rest of the year reacting less.

Related archive reading

These articles provide related context and remain subject to their stated review status.

• A UA quarterly business review template that holds up
• The budget conversation: how to defend a UA line in a flat market