Reverse KPI Calculation (Global)

SkillDev tools

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`.

Available today. Use it from your connected AI after setup.

Connect ahel once, and every AI you use reads what you have installed.

Then ask your AI: use the Reverse KPI Calculation (Global) skill

What this skill tells your AI

The instructions your AI receives, as published by minhnv0807/ai-business-skills in skills/en/10-reverse-kpi-global/SKILL.md and read by ahel’s review.

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:

VariablePessimisticRealistic (Base)Optimistic
CPMIndustry avg + 30%Industry avgIndustry avg − 20%
Click → LeadIndustry avg − 15%Industry avgIndustry avg + 15%
Lead → BookingIndustry avg − 10%Industry avgIndustry avg + 10%
Booking → CustomerIndustry avg − 10%Industry avgIndustry 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?)

VariableBase valueChange +10%Budget changeSensitivity
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)
ItemValue
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 orderAOV − VarCost = [#]
Break-even ordersTotal fixed / Profit per order
Break-even daysBE orders / 30
ResultMeaningAction
BE < 50% of expected ordersSafe — good margin bufferCan scale spend
BE = 50–80% of expectedTight — limited marginOptimize cost first
BE > 80% of expectedRisky — easy to loseCut costs or raise AOV

Budget allocation by phase

Phase% of budgetDurationGoalPrimary KPI
Teaser / Awareness15%Week 1Curiosity, brand buildReach, video views, saves
Soft launch20%Week 2Test creative, first leadsCPL, lead, A/B test data
Full launch40%Weeks 3–4Scale winners, drive salesROAS, orders, revenue
Maintenance + retarget25%Week 5+Retarget, nurture, repeatCPA, LTV, retention

Example allocation (budget $80K/month)

Phase%AmountDaysDaily
Teaser15%$12K7$1,714/day
Soft launch20%$16K7$2,286/day
Full launch40%$32K14$2,286/day
Maintenance25%$20Kbalancedepends 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

PhaseDurationExpectationTrack
TestingWeeks 1–2No orders yet, testing creative + audienceCPM, CTR, CPL
First resultsWeeks 3–4First orders, ROAS still lowFirst orders, leads
OptimizationMonth 2ROAS improving, stabilizingROAS, CPA
ScaleMonth 3+Stable ROAS, controlled budget increasesROAS held, revenue up
MatureMonth 6+Self-running, enough data to forecastLTV, retention, organic %

Rules of thumb

RuleExplanation
First 2 weeks lose moneyLearning cost — don't panic, don't pause
Base ROAS achieved by month 2Month 1 is testing, don't judge ROAS yet
Scale budget max 20%/weekFaster scaling = performance drops, CPM rises
ROAS drops 30% when scalingNormal — wider audience = lower conv rate
Retarget ROAS 2-3x prospectingAlways allocate budget for retargeting

Cross-reference

NeedSkill
Full marketing plan first00-marketing-plan-global
Current performance to inform calc03-performance-eval-global
Competitive spend benchmarks08-competitor-research-global
Customer insight to refine conv rates09-customer-insight-global
Post-campaign data analysis13-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

Signals

GitHub stars
574
Forks
226
Last commit
Sep 2026
Advanced
Catalog kind
skill
Gateway key
x-10-reverse-kpi-global
Source
github.com/minhnv0807/ai-business-skills