Skip to main content
ClaudeWave
Skill452 repo starsupdated 6d ago

10-reverse-kpi-global

This Claude Code skill calculates required marketing budgets by working backward from revenue goals to necessary spend levels, or forward from available budgets to projected revenue across four global regions (US/EU/SEA/LATAM) with region-specific conversion rates and costs. Use it when planning campaigns with defined revenue targets, stress-testing budget assumptions across pessimistic, realistic, and optimistic scenarios, or determining whether available marketing spend can achieve specific revenue objectives.

Install in Claude Code
Copy
git clone --depth 1 https://github.com/minhnv0807/ai-business-skills /tmp/10-reverse-kpi-global && cp -r /tmp/10-reverse-kpi-global/skills/en/10-reverse-kpi-global ~/.claude/skills/10-reverse-kpi-global
Then start a new Claude Code session; the skill loads automatically.

SKILL.md

# 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 alloc
PULL_REQUEST_TEMPLATESkill
channel-operatorSubagent

Agent van hanh kenh — thiet lap kenh, brief landing page, email marketing, social listening

content-producerSubagent

Agent san xuat noi dung — viet script, copy, brief creator, lap lich noi dung

mkt-strategistSubagent

Agent chien luoc marketing — lap ke hoach, nghien cuu thi truong, phan tich doi thu, xay dung chien luoc thuong hieu

performance-analystSubagent

Agent phan tich hieu suat — doc data, danh gia chien dich, tinh KPI, bao cao

personal-brand-builderSubagent

Agent xay dung thuong hieu ca nhan voi AI Avatar — chien luoc, content engine, monetization, community cho founder/coach/creator

29-dropshipping-mastery-globalSkill

Full dropshipping pipeline for US/EU/global markets — product research (winning criteria, Minea, PiPiAds), supplier sourcing (AliExpress, CJ Dropshipping, Spocket, Zendrop), Shopify store setup (themes, apps), ad creative pipeline (10 ads/week methodology, UGC pattern), audience targeting (interest stacking, lookalike, broad), pricing math (3-5x markup, BE-ROAS), customer service (long shipping, refunds), scaling playbook (CBO, vertical), compliance (FTC, EU CHRD). Trigger: 'dropshipping', 'shopify store', 'AliExpress', 'winning product', 'Facebook ads dropship', 'TikTok ads dropship', 'Shopify conversion'.

22-personal-brand-context-globalSkill

Foundation skill for global personal brand cluster. Creates `.agents/personal-brand-context-global.md` with region-specific personal brand context. 4 region variants (US/EU/SEA/LATAM); each covers founder/coach/creator inside. Reads BEFORE other PB skills (23-28 global). Trigger: 'global personal brand', 'international personal brand', 'US founder brand', 'EU coach brand', 'creator economy global'.