DecisionKits
MER-Based Ad Spend Planner
MER-Based Ad Spend Planner
- One-off payment & lifetime use
Couldn't load pickup availability
How much should you spend on each ad channel next month?
Past a certain point every extra ad dollar earns less. This template finds the spend level that maximizes profit for Meta, Google and TikTok, while keeping MER above your floor and cost per order below your limit.
What you can do with it
- Get a recommended monthly spend per channel, and the profit change vs today
- See profit and MER at every spend level from –50% to +50%
- Know your break-even cost per order — and get a warning if your limit is above it
- Set budgets on profit, not on last month's habit
What's inside
- Excel template (v5) with 3 tabs: Inputs · Dashboard · How to Use — sample data included so you see a finished example first
- README (step-by-step setup) and Why This Tool Matters guide
- Single-company license · works in Microsoft Excel 2019 or later and Microsoft 365
One-time purchase, instant download. Questions? info@decisionkits.com
Share
WHAT IT SOLVES
WHAT IT SOLVES
Past a certain point, every extra ad dollar earns less. Most budgets are set on last month's habit, not on profit. This template finds the spend level that maximizes profit for each ad channel, while keeping MER above your floor and cost per order below your limit.
WHAT YOU GET
WHAT YOU GET
You get a ZIP file, ready to use:
The Excel template (v5) with 3 tabs — Inputs, Dashboard and How to Use — and sample data, so you see a finished example first
A README with step-by-step setup
The Why This Tool Matters guide
A license for single-company use
Works in Microsoft Excel 2019 or later and Microsoft 365.
HOW IT WORKS
HOW IT WORKS
After checkout you get an instant download and an email with your ZIP file.
Open the Excel file and look at the finished example. Then, in the Inputs tab, replace the sample data with current spend, MER, gross margin, maximum cost per order and average order value for each ad channel.
The Dashboard updates on its own: the recommended spend per channel, the profit change against today, profit and MER at every spend level from -50% to +50%, and your break-even cost per order.
I manage ops for a 3-person e-com brand and this toolkit helps us make decisions in minutes.