# Media buyer rules and ad formulas in Excel (free)

> Free Excel sheet for media buyers: 61 rules with formulas, breakeven ROAS and max CPA, a budget funnel, a scale or kill helper for 10 ad sets and a quiz.

Source: https://softwiro.com/blog/media-buyer-rules-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Media buyer rules in Excel (free): ad formulas, scaling rules and testing discipline

61 rules with formulas and trial-number examples, breakeven ROAS, and a scale, keep or kill helper that uses your own targets.

15 November 2026 6 min read

## In short

- 61 rules in 8 sections: metrics, relations, break-even, decisions, scaling, testing, creative fatigue and funnel.
- Breakeven ROAS and max CPA from your own margin, plus LTV:CAC and a budget funnel.
- A scale, keep, kill or wait helper for up to 10 ad sets against targets you type yourself.
- Launch, daily, weekly and monthly checklists, and spend pacing.
- General rules; reference numbers vary by business, market and platform.

You want to make ad decisions with written rules instead of instinct: when to scale an ad set, when to kill it, when to wait, how much you can pay for one conversion without losing money, and how to test and pace the budget. The free [media buyer rules sheet](https://softwiro.com/templates/media-buyer-rules) gathers this in 61 rules, each with its formula and an example using trial numbers, plus calculators and a decision helper whose limits you set. These are general rules; reference numbers vary by business, market and platform, and the sheet gives no benchmark CTR or CPM figures.

## The problem it solves

A media buyer sees dozens of numbers in a platform report, then kills an ad a few hours after launch, doubles the budget of an apparent winner that then collapses, or judges a test on a handful of conversions. The cause is usually missing written limits before launch: which ROAS means break-even? How much spend is enough to judge? The sheet puts the formulas in one place, asks you to write your limits, and applies them to every ad set the same way.

## How the sheet works, step by step

1. Open المرجع (the reference) to review the metrics, formulas and examples; filter by the "section" column, or pick a metric in بحث عن قاعدة (rule lookup).
2. In حاسبات (calculators) compute your campaign metrics, then breakeven ROAS and max CPA from your product margin.
3. Type your targets into the settings of قرار الإعلانات (ad decisions): the ROAS target, the minimum acceptable ROAS, the minimum spend before judging, minimum conversions, maximum frequency, minimum CTR and the scaling step.
4. Enter up to 10 ad sets from the platform report. The sheet suggests scale, keep and watch, kill or wait, with a creative-fatigue warning and a proposed budget.
5. Use قوائم التشغيل (the checklists) before launch and daily, weekly and monthly.
6. Take اختبار ذاتي (the self-test), log your score in المتابعة (progress), then open الملخص (the summary).

## What is in each sheet

- Reference: 61 rules in 8 sections: core metrics (15), relations between metrics (5), profitability and break-even (7), decision rules (8), scaling and budget (6), testing (6), creative fatigue (5), funnel and naming (9).
- Calculators: five: campaign metrics; breakeven ROAS, max CPA and LTV:CAC; a budget funnel; spend pacing; and converting CPM, CTR and CVR to CPC, CPA and ROAS.
- Ad decisions: a decision helper for ten ad sets against your own targets.
- Checklists: 28 items in four lists.
- Self-test, progress and summary: 40 questions, review dates and six charts.

## A walk-through on the numbers (sample data)

These figures come from the sample copy inside the sheet. They are illustrative, not market averages.

- Campaign metrics: spend 5,000, impressions 400,000, clicks 6,000, 150 conversions and revenue 30,000 give CPM 12.5, CPC 0.83, CTR 1.5%, CVR 2.5%, CPA 33.33, ROAS 6 and AOV 200; at a 40% margin the ad profit is 7,000.
- Break-even: AOV 200 with variable costs of 120 gives 80 profit per order and a 40% margin, so breakeven ROAS is 2.5 and max CPA is 80. With a 20 target profit per order the target CPA is 60 and the target ROAS 3.33; with LTV 300 and CAC 75, LTV:CAC is 4 and the max CAC at 3:1 is 100.
- Funnel: a 10,000 budget with CPM 25, CTR 1.2%, CVR 2% and AOV 250 gives 400,000 impressions, 4,800 clicks, 96 conversions, revenue 24,000, ROAS 2.4 and CPA 104.17: below the 2.5 breakeven, for an expected profit of −400.
- Pacing: a 30,000 monthly budget, 12 days gone and 13,000 spent: 12,000 expected, so pace is 108.3% ("faster than pace" with a 5% tolerance); 17,000 remain for 18 days, 944.44 a day, and at the current pace spend will reach 32,500.
- Ad decisions: with the sample targets (ROAS target 3, minimum 2, spend 600, conversions 10, frequency 3, CTR 0.8%, step 20%), eight ad sets give three "scale", two "keep and watch", two "kill" and one "wait". Total spend is 16,150, revenue 43,490 and ROAS 2.69, and daily budget moves from 2,550 to a proposed 2,210. Two ad sets show high frequency (possible fatigue).
- Checklists and quiz: 16 of 28 items done (57.1%); 37 of 40 questions answered and 29 correct, a score of 72.5%; two topics were due for review on 2026-11-15.

## Common mistakes

- Judging before the spend threshold: an ad set with 350 spent against a 600 threshold waits; do not evaluate it.
- Deciding on one metric: a good CTR with a weak ROAS is not success.
- Changing more than one thing in a test: it hides the cause; change one variable.
- Changing the success criterion after seeing results: write it down before you start.
- Raising the budget in one big jump: gradual scaling is a common practice, not a platform rule, so set your own step.
- Treating breakeven ROAS as profit: it is break-even at ad level before fixed costs and labour; aim above it.
- Relying only on platform numbers: compare them with MER and your store's figures.

## When to move from the sheet to a system

The sheet is enough for a media buyer running a few campaigns and copying numbers by hand. When accounts and clients multiply and copying eats hours, you need automatic data pulls, alerts and ready reports, and Softwiro can [build a system around your way of working](https://softwiro.com/contact). Meanwhile use the [breakeven and unit economics sheet](https://softwiro.com/templates/ads-breakeven-unit-economics), the [ads performance tracker](https://softwiro.com/templates/ads-performance-tracker) and the [A/B test log](https://softwiro.com/templates/ads-ab-test-log); all ad sheets are on the [ads templates page](https://softwiro.com/templates/for-ads) (Arabic).

## Next step

Download the sheet, enter your product margin in **حاسبات** to see your breakeven ROAS, then write your targets in **قرار الإعلانات** before you open the platform report, and enter your ad sets. You will have your first written decision made by your own rules.

## FAQ

**Does the sheet give benchmark CTR or CPM numbers?** No. These are general rules; reference numbers vary by business, market and platform, and all example numbers are trial figures.

**Is scaling by 20% a platform rule?** No. It is a common practice and you set your own step.

**How do I calculate breakeven ROAS?** It is 1 ÷ gross margin, so a 40% margin gives 2.5.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: media buyer rules (1/3)](https://softwiro.com/uploads/cheatsheets/media-buyer-rules/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/media-buyer-rules/en-1.jpg)[![Cheat sheet: media buyer rules (2/3)](https://softwiro.com/uploads/cheatsheets/media-buyer-rules/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/media-buyer-rules/en-2.jpg)[![Cheat sheet: media buyer rules (3/3)](https://softwiro.com/uploads/cheatsheets/media-buyer-rules/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/media-buyer-rules/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### Does the sheet give benchmark CTR, CPM or CPA numbers?

No. These are general rules; reference numbers vary by business, market and platform. Every example number is a trial figure, and all decision limits are typed by you in the settings.

### Are the scale and kill rules platform rules?

No. They are general rules built on the targets you write, such as gradual scaling by a small percentage every few days, a common practice whose step you set yourself. Platforms have their own policies and behaviour.

### How do I calculate breakeven ROAS and max CPA?

Breakeven ROAS = 1 ÷ gross margin, and max CPA = average order value × margin. Enter AOV and the variable cost per order in the second calculator. It is break-even at ad level, before fixed costs and labour.

### How many ad sets can the decision helper hold?

Ten, with eight in the sample. The sheet computes the decision from the spend, conversions, revenue and frequency you type, copied by hand from the platform report.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
