Digital Marketing Budget Template + Forecast (Free Excel)

The most common way to set a marketing budget is a percentage of revenue. It produces a number with no relationship to what an outcome costs you, which is why it is so hard to defend when questioned.

Work backwards from the target instead.

The forecast

Every input, and where each number should come from:

Input	Where the number comes from
Target outcomes	The number of customers or enquiries you need.
Conversion rate	Enquiry to customer, from your own data. Not a benchmark.
Required enquiries	Target ÷ conversion rate.
Cost per enquiry	From your own last three months, blended.
Required media budget	Required enquiries × cost per enquiry.
Sanity check	Budget ÷ target outcomes must be below what a customer is worth. If not, the plan is wrong, not the budget.

From those, the sheet calculates enquiries needed, the media budget required, the cost per customer, the margin per customer — and a verdict.

The check most forecasts skip

If cost per customer is at or above what a customer is worth, the sheet says “Not viable”. That is not a budget problem. The answer is a higher conversion rate, a higher price, or a cheaper channel — and a bigger budget makes it worse rather than better.

Preview of the file

The forecast tab. Four yellow inputs; everything below calculates, including the viability verdict.

Splitting the budget

Allocation advice is usually given by industry, which is close to useless. The variable that actually matters is whether your measurement works yet.

Situation	Media	Production	Tools	People	Why
No working measurement yet	0–20%	30%	20%	30%	Spending on media before measurement works is how budget disappears without a lesson
One channel proven	50%	25%	10%	15%	Scale what works before adding another
Two or three channels running	60%	20%	10%	10%	Hold 10% back for testing, ring-fenced so it is not absorbed

The first row is the one people resist. Running media against broken tracking does not produce a smaller result — it produces an unmeasurable one, which is worse, because you cannot tell whether to continue.

The annual budget

The third tab is a channel-by-month grid with row and column totals. Two conventions worth keeping:

Media and production on separate lines. Blended into one, production gets quietly starved whenever media needs more, and nobody notices until the creative is stale.
A contingency line that is a real line. If contingency is “whatever is left”, the first opportunity gets funded by cancelling something that was working.

What I check before signing off a budget

Four questions, and the third is the one that changes minds:

Does the cost per outcome come from our own data? Not a benchmark, not last year’s agency deck. If we do not have it, the honest first step is a small test to find out rather than an annual plan built on a guess.
What happens at half this budget? A plan that only works at the full figure is fragile. Knowing which activities survive a cut is more useful than the plan itself, and you will be asked eventually.
What does this budget imply about reach? Running the funnel arithmetic often reveals that the target needs several times the traffic the channel can plausibly deliver. Better to find that in a spreadsheet than in Q3.
Who can move money between lines, and how quickly? The point of measuring is reallocating. A budget that cannot be changed until next year makes the measurement decorative.

Common mistakes

Budgeting by percentage of revenue with no reference to what an outcome costs.
Forecasting from a published industry benchmark instead of your own numbers.
No contingency, so the first opportunity is funded by cancelling something that was working.
Media and production in one line, so production gets starved unnoticed.
A forecast with no sanity check against customer value.
Treating the annual budget as fixed once set, when the point of measuring is to reallocate.