10 reverse KPI global skill

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.

by minhnv0807·MIT license·★ 599 Stars on the repo·GitHub ↗

Use now

Files of 10 reverse KPI global

minhnv0807/master1 file shown
SKILL.md
Show the full text287 lines

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:

  1. 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."
  2. 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)
  3. 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.
  4. Conversion rates are the leverage. Small changes in conversion (e.g., 50% → 55%) cascade up the funnel and change your budget significantly.
  5. Currency matters. A 5% margin in USD is different in EUR, BRL, or VND. Always pick the right region variant for your benchmarks.
  6. Don't trust round numbers. "100 leads" is suspicious — real funnels produce odd numbers like 87 or 213.
  7. 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:

  1. Read .agents/product-marketing-context-global.md — get product, AOV, region, currency, target market.
  2. Pick region variant for benchmark conversion rates and CPM/CPL:
    • variants/01-us.md — USD, US benchmarks
    • variants/02-eu.md — EUR/GBP, EU benchmarks
    • variants/03-sea.md — USD/local, SEA benchmarks
    • variants/04-latam.md — USD/BRL/MXN, LATAM benchmarks
  3. Confirm direction: Reverse (revenue → spend) or Forward (spend → revenue)?
Information gathering

Ask user up to 4 questions:

  1. What is the goal? Revenue target $X/month? Or available budget $Y to allocate?
  2. Product/service and AOV? Average order value or deal size in your currency.
  3. Industry and current channel mix? Industry niche? Channels currently running? Any existing CPL/CPM data?
  4. 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:

  1. CPM — controlled by creative + targeting → optimize via A/B testing
  2. 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

  1. Proven channel → 60-70% of budget. Don't dilute by spreading evenly.
  2. New / test channel → 15-20% of budget. Enough to gather data, not enough to bleed cash.
  3. Retarget → 10-15% of budget. Highest ROAS — target previously engaged users.
  4. 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:

  • Region variant selected — currency and benchmarks match user's market
  • Direction confirmed (reverse vs forward)
  • Industry-specific conversion rates used (not generic averages)
  • All 3 scenarios calculated (pessimistic, base, optimistic)
  • Sensitivity analysis identifies top 2 levers + how to improve them
  • Break-even calculated with risk grade
  • Phase allocation has specific timeline
  • Channel allocation matches industry mix
  • ROI timeline realistic (no "ROAS 5x in week 1" promises)
  • Total budget consistent across phase + channel breakdowns
  • Seasonality noted if campaign falls on Q4/Tet/Carnival/Black Friday
  • Currency conversion documented if cross-border
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
287 

Discussion

Alternatives

Ad campaign analyzerAnalyze ad campaign performance data (Google, Meta, LinkedIn) to identify what's working, what's wasting budget, and specific cut/scale/test recommendations. Runs statistical analysis, funnel diagnostics, and multi-channel budget reallocation with specific dollar-amount shift recommendations and scenario modeling.Business & ops · MITStartup financial modelingBuild comprehensive 3-5 year financial models with revenue projections, cost structures, cash flow analysis, and scenario planning for early-stage startups. Use this skill when creating financial projections, calculating burn rate or runway, modeling fundraising scenarios, or preparing investor-ready financials for a seed or Series A raise.Business & ops · MITProject managerUse this agent when you need to establish project plans, track execution progress, manage risks, control budget/schedule, and coordinate stakeholders across complex initiatives. Specifically:\\n\\n<example>\\nContext: A software team is starting a major product release with multiple dependencies and tight deadlines. The stakeholders need a comprehensive project plan with timeline, resource allocation, and risk mitigation strategies.\\nuser: "We're launching a new payment processing platform in Q2. Can you help us plan the project, identify risks, and set up tracking?"\\nassistant: "I'll establish a comprehensive project management plan including scope definition, work breakdown structure, detailed timeline with milestones, resource allocation strategy, risk register with mitigation plans, budget estimates, and communication protocols. I'll also set up progress tracking mechanisms and escalation procedures."\\n<commentary>\\nInvoke project-manager when a project needs comprehensive planning from inception, including scope, timeline, budget, resources, and risk management. This is distinct from scrum-master (which facilitates team execution within sprints) and differs in scope than a single-area task.\\n</commentary>\\n</example>\\n\\n<example>\\nContext: A mid-project review shows the team is running 2 weeks behind schedule, budget is trending 12% over, and there are unresolved dependency issues with another team.\\nuser: "Our project is sliding. We're behind schedule, over budget, and stuck waiting on another team. I need to understand what's happening and how to fix it."\\nassistant: "I'll conduct a project health assessment: analyze schedule variance and critical path to identify what's causing the delay, review budget performance and forecast final costs, identify blocking dependencies and propose resolution strategies, assess risk mitigation effectiveness, and develop a corrective action plan with stakeholder communication strategy."\\n<commentary>\\nUse project-manager when a project is in execution phase and you need to address performance issues (schedule, budget, scope, quality) or resolve cross-team dependencies and blockers. Project-manager handles systemic project problems, not just individual team execution.\\n</commentary>\\n</example>\\n\\n<example>\\nContext: A project is nearing completion with deliverables ready for handoff. The team needs to verify all objectives were met, document lessons learned, and properly close the project.\\nuser: "We're wrapping up the mobile app redesign. Everything seems done but I want to make sure we're closing this properly. Need to document what we learned and ensure all deliverables are signed off."\\nassistant: "I'll manage project closure: verify all deliverables against acceptance criteria, confirm stakeholder sign-off, facilitate lessons learned session to capture what worked well and areas for improvement, ensure complete documentation, conduct team retrospective, and create archive for future reference. I'll also compile final metrics on schedule, budget, quality, and team satisfaction."\\n<commentary>\\nInvoke project-manager at the end of a project lifecycle to ensure proper closure, stakeholder handoff, documentation completion, and organizational learning. This captures the full project management cycle from planning through closure.\\n</commentary>\\n</example>Business & ops · MIT/cs:cfo-review — CFO Forcing Questions/cs:cfo-review <plan> — Numerate-skeptic interrogation of any plan that touches money. Unit economics, runway, dilution, capital allocation. Use when a plan commits meaningful spend — e.g. a hiring wave, a fundraise decision, or a new channel budget. · MIT