Reverse KPI Calculation (Global)
Calculate marketing budget by working backward from revenue goal — or forward from available spend to expected revenue. Universal math; currency and benchmark numbers vary per region (US/EU/SEA/LATAM).
For newbies — Read this first
If you've never run a reverse KPI calc:
- Reverse KPI = working backward from a goal. Instead of "I'll spend $5K and see what happens," you say "I want $50K in revenue, so I need X impressions, Y leads, Z customers — therefore the budget is $W."
- It works in two directions:
- Backward: Revenue target → required spend (when you have a goal)
- Forward: Available spend → expected revenue (when you have a budget)
- You always run 3 scenarios. Pessimistic (worst case), Realistic (base case), Optimistic (best case). One number is dangerous — three numbers force you to stress-test.
- Conversion rates are the leverage. Small changes in conversion (e.g., 50% → 55%) cascade up the funnel and change your budget significantly.
- Currency matters. A 5% margin in USD is different in EUR, BRL, or VND. Always pick the right region variant for your benchmarks.
- Don't trust round numbers. "100 leads" is suspicious — real funnels produce odd numbers like 87 or 213.
- Time horizon affects budget. A $50K monthly target needs different planning than a $50K annual target. Always specify the period.
Step 0 — Read context + select region variant
Before calculation:
- Read
.agents/product-marketing-context-global.md — get product, AOV, region, currency, target market.
- Pick region variant for benchmark conversion rates and CPM/CPL:
variants/01-us.md — USD, US benchmarksvariants/02-eu.md — EUR/GBP, EU benchmarksvariants/03-sea.md — USD/local, SEA benchmarksvariants/04-latam.md — USD/BRL/MXN, LATAM benchmarks
- Confirm direction: Reverse (revenue → spend) or Forward (spend → revenue)?
Information gathering
Ask user up to 4 questions:
- What is the goal? Revenue target $X/month? Or available budget $Y to allocate?
- Product/service and AOV? Average order value or deal size in your currency.
- Industry and current channel mix? Industry niche? Channels currently running? Any existing CPL/CPM data?
- Campaign duration? 1 month? Quarter? 6 months? Phased?
Two calculation directions
Direction 1 — Reverse: Revenue → Budget
Use when: "I want to hit $200K/month — how much ad spend do I need?"
Revenue target
/ AOV (average order value)
= ORDERS NEEDED
/ Booking → Customer rate
= BOOKINGS NEEDED
/ Lead → Booking rate
= LEADS NEEDED
/ Click → Lead rate
= CLICKS NEEDED
/ CTR
= IMPRESSIONS NEEDED
× CPM / 1000
= TOTAL AD BUDGET
For e-commerce (no booking step):
Revenue target
/ AOV
= ORDERS NEEDED
/ Conversion rate
= SESSIONS NEEDED (clicks)
/ CTR
= IMPRESSIONS NEEDED
× CPM / 1000
= TOTAL AD BUDGET
For B2B (longer funnel):
Revenue target
/ ACV (annual contract value)
= CUSTOMERS NEEDED
/ Win rate
= OPPORTUNITIES NEEDED
/ SQL → Opportunity rate
= SQL NEEDED
/ MQL → SQL rate
= MQL NEEDED
/ Lead → MQL rate
= LEADS NEEDED
→ continue with CPL × LEADS NEEDED = SPEND
Direction 2 — Forward: Budget → Revenue
Use when: "I have $50K — how much revenue can I expect?"
Budget
/ CPM × 1000
= IMPRESSIONS
× CTR
= CLICKS
× Click → Lead rate
= LEADS
× Lead → Booking rate
= BOOKINGS
× Booking → Customer rate
= ORDERS
× AOV
= REVENUE
3-Scenario sensitivity analysis (universal)
Scenario structure
Always run three scenarios:
| Variable |
Pessimistic |
Realistic (Base) |
Optimistic |
| CPM |
Industry avg + 30% |
Industry avg |
Industry avg − 20% |
| Click → Lead |
Industry avg − 15% |
Industry avg |
Industry avg + 15% |
| Lead → Booking |
Industry avg − 10% |
Industry avg |
Industry avg + 10% |
| Booking → Customer |
Industry avg − 10% |
Industry avg |
Industry avg + 10% |
Reading the results
- Pessimistic = budget needed for safety / FX swings / first-month learning curve
- Realistic (Base) = the actual planning number
- Optimistic = aspiration target, used for stretch KPI or commission triggers
Use Base for budget. Use Pessimistic as buffer. Use Optimistic as stretch goal.
Sensitivity (which lever moves the budget most?)
| Variable |
Base value |
Change +10% |
Budget change |
Sensitivity |
| CPM |
[#] |
+10% |
+10% |
Direct 1:1 |
| CTR |
[#]% |
+10% |
-9% |
High |
| Click→Lead |
[#]% |
+10% |
-9% |
High |
| Lead→Booking |
[#]% |
+10% |
-9% |
High |
| Booking→Customer |
[#]% |
+10% |
-9% |
High |
| AOV |
[#] |
+10% |
-9% (fewer orders needed) |
Indirect |
80/20 rule
The two highest-leverage levers are usually:
- CPM — controlled by creative + targeting → optimize via A/B testing
- Lead → Booking — controlled by sales/CS quality → optimize via script + response speed
Break-even calculation
Break-even orders = Fixed costs / (AOV − Variable cost per order)
Break-even days = Break-even orders / (Avg orders per day)
| Item |
Value |
| Fixed costs/month (rent, salary, tools, software) |
[#] |
| Ad spend (variable, but allocated upfront) |
[#] |
| Total fixed |
[#] |
| AOV |
[#] |
| Variable cost per order (COGS, shipping, fees) |
[#] |
| Profit per order |
AOV − VarCost = [#] |
| Break-even orders |
Total fixed / Profit per order |
| Break-even days |
BE orders / 30 |
| Result |
Meaning |
Action |
| BE < 50% of expected orders |
Safe — good margin buffer |
Can scale spend |
| BE = 50–80% of expected |
Tight — limited margin |
Optimize cost first |
| BE > 80% of expected |
Risky — easy to lose |
Cut costs or raise AOV |
Budget allocation by phase
| Phase |
% of budget |
Duration |
Goal |
Primary KPI |
| Teaser / Awareness |
15% |
Week 1 |
Curiosity, brand build |
Reach, video views, saves |
| Soft launch |
20% |
Week 2 |
Test creative, first leads |
CPL, lead, A/B test data |
| Full launch |
40% |
Weeks 3–4 |
Scale winners, drive sales |
ROAS, orders, revenue |
| Maintenance + retarget |
25% |
Week 5+ |
Retarget, nurture, repeat |
CPA, LTV, retention |
Example allocation (budget $80K/month)
| Phase |
% |
Amount |
Days |
Daily |
| Teaser |
15% |
$12K |
7 |
$1,714/day |
| Soft launch |
20% |
$16K |
7 |
$2,286/day |
| Full launch |
40% |
$32K |
14 |
$2,286/day |
| Maintenance |
25% |
$20K |
balance |
depends on remaining days |
Channel allocation principles
- Proven channel → 60-70% of budget. Don't dilute by spreading evenly.
- New / test channel → 15-20% of budget. Enough to gather data, not enough to bleed cash.
- Retarget → 10-15% of budget. Highest ROAS — target previously engaged users.
- Switch channels when ROAS < 2x for 2 weeks. Don't wait too long.
ROI projection timeline
| Phase |
Duration |
Expectation |
Track |
| Testing |
Weeks 1–2 |
No orders yet, testing creative + audience |
CPM, CTR, CPL |
| First results |
Weeks 3–4 |
First orders, ROAS still low |
First orders, leads |
| Optimization |
Month 2 |
ROAS improving, stabilizing |
ROAS, CPA |
| Scale |
Month 3+ |
Stable ROAS, controlled budget increases |
ROAS held, revenue up |
| Mature |
Month 6+ |
Self-running, enough data to forecast |
LTV, retention, organic % |
Rules of thumb
| Rule |
Explanation |
| First 2 weeks lose money |
Learning cost — don't panic, don't pause |
| Base ROAS achieved by month 2 |
Month 1 is testing, don't judge ROAS yet |
| Scale budget max 20%/week |
Faster scaling = performance drops, CPM rises |
| ROAS drops 30% when scaling |
Normal — wider audience = lower conv rate |
| Retarget ROAS 2-3x prospecting |
Always allocate budget for retargeting |
Cross-reference
| Need |
Skill |
| Full marketing plan first |
00-marketing-plan-global |
| Current performance to inform calc |
03-performance-eval-global |
| Competitive spend benchmarks |
08-competitor-research-global |
| Customer insight to refine conv rates |
09-customer-insight-global |
| Post-campaign data analysis |
13-data-analysis-global |
Quality checklist
Before delivering reverse KPI report:
1---
2name: 10-reverse-kpi-global
3description: "Use when the user needs to work backward from a revenue goal to the numbers that produce it — required leads, max CPA and CPL, funnel conversion thresholds, and the budget that has to be spent, with three scenarios and currency handling for US, EU, SEA, and LATAM. Trigger on 'reverse KPI', 'how much budget do I need', 'what CPA can I afford', 'work backward from revenue', 'how many leads to hit target', 'break-even ROAS'. Also use when the user names a revenue target and asks whether it is realistic. Not for — splitting an existing budget across channels and months, see `61-budget-planning-global`; a full paid media plan, see `54-media-plan-global`; the period plan, see `00-marketing-plan-global`."
4metadata:
5 version: 1.0.1
6 category: strategy
7license: MIT
8triggers:
9 - "reverse KPI"
10 - "budget calculation"
11 - "KPI breakdown"
12 - "marketing budget plan"
13 - "campaign budget"
14related:
15 - product-marketing-context-global
16 - 00-marketing-plan-global
17 - 03-performance-eval-global
18 - 07-marketing-report-global
19---
20
21# Reverse KPI Calculation (Global)
22
23Calculate marketing budget by working backward from revenue goal — or forward from available spend to expected revenue. Universal math; currency and benchmark numbers vary per region (US/EU/SEA/LATAM).
24
25---
26
27## For newbies — Read this first
28
29If you've never run a reverse KPI calc:
30
311. **Reverse KPI = working backward from a goal.** Instead of "I'll spend $5K and see what happens," you say "I want $50K in revenue, so I need X impressions, Y leads, Z customers — therefore the budget is $W."
322. **It works in two directions:**
33 - Backward: Revenue target → required spend (when you have a goal)
34 - Forward: Available spend → expected revenue (when you have a budget)
353. **You always run 3 scenarios.** Pessimistic (worst case), Realistic (base case), Optimistic (best case). One number is dangerous — three numbers force you to stress-test.
364. **Conversion rates are the leverage.** Small changes in conversion (e.g., 50% → 55%) cascade up the funnel and change your budget significantly.
375. **Currency matters.** A 5% margin in USD is different in EUR, BRL, or VND. Always pick the right region variant for your benchmarks.
386. **Don't trust round numbers.** "100 leads" is suspicious — real funnels produce odd numbers like 87 or 213.
397. **Time horizon affects budget.** A $50K monthly target needs different planning than a $50K annual target. Always specify the period.
40
41---
42
43## Step 0 — Read context + select region variant
44
45Before calculation:
46
471. **Read `.agents/product-marketing-context-global.md`** — get product, AOV, region, currency, target market.
482. **Pick region variant for benchmark conversion rates and CPM/CPL:**
49 - `variants/01-us.md` — USD, US benchmarks
50 - `variants/02-eu.md` — EUR/GBP, EU benchmarks
51 - `variants/03-sea.md` — USD/local, SEA benchmarks
52 - `variants/04-latam.md` — USD/BRL/MXN, LATAM benchmarks
533. **Confirm direction:** Reverse (revenue → spend) or Forward (spend → revenue)?
54
55### Information gathering
56
57Ask user up to 4 questions:
58
591. **What is the goal?** Revenue target $X/month? Or available budget $Y to allocate?
602. **Product/service and AOV?** Average order value or deal size in your currency.
613. **Industry and current channel mix?** Industry niche? Channels currently running? Any existing CPL/CPM data?
624. **Campaign duration?** 1 month? Quarter? 6 months? Phased?
63
64---
65
66## Two calculation directions
67
68### Direction 1 — Reverse: Revenue → Budget
69
70Use when: "I want to hit $200K/month — how much ad spend do I need?"
71
72```
73Revenue target
74 / AOV (average order value)
75 = ORDERS NEEDED
76 / Booking → Customer rate
77 = BOOKINGS NEEDED
78 / Lead → Booking rate
79 = LEADS NEEDED
80 / Click → Lead rate
81 = CLICKS NEEDED
82 / CTR
83 = IMPRESSIONS NEEDED
84 × CPM / 1000
85 = TOTAL AD BUDGET
86```
87
88For e-commerce (no booking step):
89
90```
91Revenue target
92 / AOV
93 = ORDERS NEEDED
94 / Conversion rate
95 = SESSIONS NEEDED (clicks)
96 / CTR
97 = IMPRESSIONS NEEDED
98 × CPM / 1000
99 = TOTAL AD BUDGET
100```
101
102For B2B (longer funnel):
103
104```
105Revenue target
106 / ACV (annual contract value)
107 = CUSTOMERS NEEDED
108 / Win rate
109 = OPPORTUNITIES NEEDED
110 / SQL → Opportunity rate
111 = SQL NEEDED
112 / MQL → SQL rate
113 = MQL NEEDED
114 / Lead → MQL rate
115 = LEADS NEEDED
116 → continue with CPL × LEADS NEEDED = SPEND
117```
118
119### Direction 2 — Forward: Budget → Revenue
120
121Use when: "I have $50K — how much revenue can I expect?"
122
123```
124Budget
125 / CPM × 1000
126 = IMPRESSIONS
127 × CTR
128 = CLICKS
129 × Click → Lead rate
130 = LEADS
131 × Lead → Booking rate
132 = BOOKINGS
133 × Booking → Customer rate
134 = ORDERS
135 × AOV
136 = REVENUE
137```
138
139---
140
141## 3-Scenario sensitivity analysis (universal)
142
143### Scenario structure
144
145Always run three scenarios:
146
147| Variable | Pessimistic | Realistic (Base) | Optimistic |
148|----------|-------------|------------------|------------|
149| CPM | Industry avg + 30% | Industry avg | Industry avg − 20% |
150| Click → Lead | Industry avg − 15% | Industry avg | Industry avg + 15% |
151| Lead → Booking | Industry avg − 10% | Industry avg | Industry avg + 10% |
152| Booking → Customer | Industry avg − 10% | Industry avg | Industry avg + 10% |
153
154### Reading the results
155
156- **Pessimistic** = budget needed for safety / FX swings / first-month learning curve
157- **Realistic (Base)** = the actual planning number
158- **Optimistic** = aspiration target, used for stretch KPI or commission triggers
159
160> Use Base for budget. Use Pessimistic as buffer. Use Optimistic as stretch goal.
161
162### Sensitivity (which lever moves the budget most?)
163
164| Variable | Base value | Change +10% | Budget change | Sensitivity |
165|----------|-----------|-------------|---------------|-------------|
166| CPM | [#] | +10% | +10% | **Direct 1:1** |
167| CTR | [#]% | +10% | -9% | **High** |
168| Click→Lead | [#]% | +10% | -9% | **High** |
169| Lead→Booking | [#]% | +10% | -9% | **High** |
170| Booking→Customer | [#]% | +10% | -9% | **High** |
171| AOV | [#] | +10% | -9% (fewer orders needed) | **Indirect** |
172
173### 80/20 rule
174
175The two highest-leverage levers are usually:
176
1771. **CPM** — controlled by creative + targeting → optimize via A/B testing
1782. **Lead → Booking** — controlled by sales/CS quality → optimize via script + response speed
179
180---
181
182## Break-even calculation
183
184```
185Break-even orders = Fixed costs / (AOV − Variable cost per order)
186Break-even days = Break-even orders / (Avg orders per day)
187```
188
189| Item | Value |
190|------|-------|
191| Fixed costs/month (rent, salary, tools, software) | [#] |
192| Ad spend (variable, but allocated upfront) | [#] |
193| Total fixed | [#] |
194| AOV | [#] |
195| Variable cost per order (COGS, shipping, fees) | [#] |
196| Profit per order | AOV − VarCost = [#] |
197| Break-even orders | Total fixed / Profit per order |
198| Break-even days | BE orders / 30 |
199
200| Result | Meaning | Action |
201|--------|---------|--------|
202| BE < 50% of expected orders | Safe — good margin buffer | Can scale spend |
203| BE = 50–80% of expected | Tight — limited margin | Optimize cost first |
204| BE > 80% of expected | Risky — easy to lose | Cut costs or raise AOV |
205
206---
207
208## Budget allocation by phase
209
210| Phase | % of budget | Duration | Goal | Primary KPI |
211|-------|-------------|----------|------|-------------|
212| **Teaser / Awareness** | 15% | Week 1 | Curiosity, brand build | Reach, video views, saves |
213| **Soft launch** | 20% | Week 2 | Test creative, first leads | CPL, lead, A/B test data |
214| **Full launch** | 40% | Weeks 3–4 | Scale winners, drive sales | ROAS, orders, revenue |
215| **Maintenance + retarget** | 25% | Week 5+ | Retarget, nurture, repeat | CPA, LTV, retention |
216
217### Example allocation (budget $80K/month)
218
219| Phase | % | Amount | Days | Daily |
220|-------|---|--------|------|-------|
221| Teaser | 15% | $12K | 7 | $1,714/day |
222| Soft launch | 20% | $16K | 7 | $2,286/day |
223| Full launch | 40% | $32K | 14 | $2,286/day |
224| Maintenance | 25% | $20K | balance | depends on remaining days |
225
226---
227
228## Channel allocation principles
229
2301. **Proven channel → 60-70% of budget.** Don't dilute by spreading evenly.
2312. **New / test channel → 15-20% of budget.** Enough to gather data, not enough to bleed cash.
2323. **Retarget → 10-15% of budget.** Highest ROAS — target previously engaged users.
2334. **Switch channels when ROAS < 2x for 2 weeks.** Don't wait too long.
234
235---
236
237## ROI projection timeline
238
239| Phase | Duration | Expectation | Track |
240|-------|----------|-------------|-------|
241| Testing | Weeks 1–2 | No orders yet, testing creative + audience | CPM, CTR, CPL |
242| First results | Weeks 3–4 | First orders, ROAS still low | First orders, leads |
243| Optimization | Month 2 | ROAS improving, stabilizing | ROAS, CPA |
244| Scale | Month 3+ | Stable ROAS, controlled budget increases | ROAS held, revenue up |
245| Mature | Month 6+ | Self-running, enough data to forecast | LTV, retention, organic % |
246
247### Rules of thumb
248
249| Rule | Explanation |
250|------|-------------|
251| First 2 weeks lose money | Learning cost — don't panic, don't pause |
252| Base ROAS achieved by month 2 | Month 1 is testing, don't judge ROAS yet |
253| Scale budget max 20%/week | Faster scaling = performance drops, CPM rises |
254| ROAS drops 30% when scaling | Normal — wider audience = lower conv rate |
255| Retarget ROAS 2-3x prospecting | Always allocate budget for retargeting |
256
257---
258
259## Cross-reference
260
261| Need | Skill |
262|------|-------|
263| Full marketing plan first | `00-marketing-plan-global` |
264| Current performance to inform calc | `03-performance-eval-global` |
265| Competitive spend benchmarks | `08-competitor-research-global` |
266| Customer insight to refine conv rates | `09-customer-insight-global` |
267| Post-campaign data analysis | `13-data-analysis-global` |
268
269---
270
271## Quality checklist
272
273Before delivering reverse KPI report:
274
275- [ ] Region variant selected — currency and benchmarks match user's market
276- [ ] Direction confirmed (reverse vs forward)
277- [ ] Industry-specific conversion rates used (not generic averages)
278- [ ] All 3 scenarios calculated (pessimistic, base, optimistic)
279- [ ] Sensitivity analysis identifies top 2 levers + how to improve them
280- [ ] Break-even calculated with risk grade
281- [ ] Phase allocation has specific timeline
282- [ ] Channel allocation matches industry mix
283- [ ] ROI timeline realistic (no "ROAS 5x in week 1" promises)
284- [ ] Total budget consistent across phase + channel breakdowns
285- [ ] Seasonality noted if campaign falls on Q4/Tet/Carnival/Black Friday
286- [ ] Currency conversion documented if cross-border
gabrielmoreira