Digital Advertising
Digital Advertising Budget Template: How to Plan and Track Ad Spend
We plan advertising budgets with every client before a campaign goes live. This guide is for owners who want a clear, simple way to set and track their ad spend. It explains how to work out a starting budget, gives a template to fill in and shows how to track results. Use it before your next campaign, so your budget links directly to the enquiries you need.
How to work out your starting budget
A useful budget starts from what a customer is worth, not from a round number. Knowing that value tells you how much you can afford to pay for each enquiry. Your enquiry target then sets the monthly budget. Work through these steps with your own figures.
- Work out the average profit from one new customer.
- Decide the most you will pay to win that customer.
- Estimate how many enquiries you need to win one customer.
- Divide your maximum customer cost by that number to get a target cost per enquiry.
- Multiply your target cost per enquiry by the enquiries you want each month.
The result is your starting monthly budget. Treat the first month as a test, as real costs often differ from estimates. Adjust the budget once you see actual cost per enquiry.
Digital advertising budget template
The template below tracks your plan against real results each month. Copy it into a spreadsheet and add one row per platform or campaign. Fill in the planned columns before launch. Complete the actual columns at the end of each month.
| Platform or campaign | Planned monthly budget (£) | Actual spend (£) | Enquiries | Cost per enquiry (£) | Customers won | Notes |
|---|---|---|---|---|---|---|
| Google Ads: main service | ||||||
| Facebook and Instagram: local offer | ||||||
| Retargeting | ||||||
| Total |
Add a column for revenue if you sell online. Keep each month on a separate tab so trends are easy to compare. The notes column records changes such as new ads or paused audiences.
How to track and adjust your budget
A budget is a plan, not a fixed rule. Results each month show where extra spend pays off and where it does not. Small, regular adjustments beat large, occasional changes. Follow these steps at each monthly review.
- Compare actual cost per enquiry with your target for each row.
- Move budget from rows above target to rows below it.
- Increase total spend only when cost per enquiry stays on target.
- Hold some budget for testing new ads or audiences.
- Record every change in the notes column.
Seasonal businesses should plan higher budgets for their busiest months. Our campaign checklist covers the full monthly review. Our platform comparison helps you decide where each row of budget goes.
Budget planning checklist
Use this checklist when you set or review your advertising budget. Each item links spend to business results. Revisit it every quarter.
- Average profit per customer calculated
- Maximum cost to win a customer agreed
- Target cost per enquiry set
- Monthly budget calculated from enquiry targets
- Template set up with one row per platform or campaign
- Actual spend and enquiries recorded monthly
- Budget moved towards the best-performing rows
Good to know
Budget planning FAQs
How much should a small business spend on advertising?+
Spend depends on your customer value, your goals and your market. Work backwards from the cost you can afford for each new customer. Start with a test budget large enough to show clear results. Increase it when cost per enquiry stays on target.
Should ad spend include management fees?+
Keep ad spend and management fees as separate lines in your budget. Ad spend goes to the platforms, while fees pay for planning and management. Separating them shows the true cost per enquiry from each platform. Include both when you calculate total return.
What should I do if my budget runs out early?+
A budget that runs out early often means targeting is too broad. Check locations, keywords and schedules for wasted spend. Set daily limits that spread spend across the month. Increase budget only when results justify it.
How do I track enquiries from ads?+
Install conversion tracking on every form, call and booking on your website. Each platform then reports enquiries alongside spend. Call tracking numbers help record phone enquiries accurately. Check tracking with a test enquiry before every new campaign.
Keep this template updated at the end of every month. Share it with anyone who signs off your marketing spend. So you can plan budgets from real customer value and move money to the campaigns that work.
Last updated