Skip to product information
1 of 2

DecisionKits

MER-Based Ad Spend Planner

MER-Based Ad Spend Planner

Regular price $49.00 USD
Regular price Sale price $49.00 USD
Sale Sold out
No taxes apply. Digital product — instant download after checkout.
Quantity
  • One-off payment & lifetime use

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

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

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

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.

View full details