本文へ移動
cccskills
無料GitHub で公開

10-reverse-kpi-global

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

インストール方法を見る

含まれるファイル(5)

  • SKILL.md10.3 KB
  • variants/01-us.md6.8 KB
  • variants/02-eu.md8.1 KB
  • variants/03-sea.md8.0 KB
  • variants/04-latam.md9.3 KB

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:

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

レビュー

まだレビューはありません。使ってみた感想をお寄せください。

同じリポジトリのスキル

概要と使いどころ

Dung khi can ke hoach marketing tong the cho mot ky — muc tieu, phan khuc, kenh, ngan sach, timeline, KPI va ma tran rui ro. Co ca che do ban day du va che do ke hoach 1 trang cho chu doanh nghiep nho. Kich hoat khi user nhac 'lap ke hoach marketing', 'ke hoach MKT', 'marketing plan', 'chien luoc marketing nam', 'plan quy toi', 'ke hoach 1 trang'. Khong dung cho — tinh nguoc ngan sach tu doanh thu thi dung skill 10-tinh-kpi-nguoc; phan bo ngan sach chi tiet theo kenh thi dung skill 61-budget-planning; brief mot chien dich cu the thi dung skill 02-brief-chien-dich.

日本語の概要は準備中です。原文の説明を表示しています。

minhnv0807/ai-business-skills6132026年9月12日 更新

Use when the user needs an overall marketing plan for a period — objectives, segments, positioning, channel mix, content direction, budget, timeline, KPIs, and a risk matrix, adapted to US, EU, SEA, or LATAM. Trigger on 'marketing plan', 'marketing strategy for next year', 'go-to-market roadmap', 'plan for Q3', 'we have no marketing plan', 'where should we spend next quarter'. Also use when a founder only says the business needs to grow and has no idea which channel to start with. Not for — one specific campaign, see `02-campaign-brief-global`; working backward from a revenue goal to spend, see `10-reverse-kpi-global`; splitting a budget across channels and months, see `61-budget-planning-global`; taking a brand new product to market, see `59-go-to-market-global`.

日本語の概要は準備中です。原文の説明を表示しています。

minhnv0807/ai-business-skills6132026年9月12日 更新

Use when the user needs a monthly or weekly content calendar — posting schedule per channel, funnel ratio, content pillars, repurposing matrix, and an owner per slot. Trigger on 'content calendar', 'posting schedule', 'what should we post this month', 'editorial calendar', 'social media plan', 'we post randomly with no plan'. Also use when the user only says the team keeps running out of things to post. Not for — the brief for one specific post, see `36-content-brief-global`; the caption text itself, see `37-social-caption-global`; deciding next period content from last period data, see `40-next-content-plan-global`; a paid campaign timeline, see `02-campaign-brief-global`.

日本語の概要は準備中です。原文の説明を表示しています。

minhnv0807/ai-business-skills6132026年9月12日 更新

Dung khi can lich dang bai cho ca thang — chot content pillar va ti le, xep bai theo ngay va khung gio, ma tran tai su dung noi dung, va gan muc tieu cho tung tru cot. Kich hoat khi user nhac 'lich noi dung', 'content calendar', 'thang nay dang gi', 'len lich dang bai', 'ke hoach content thang', 'phan bo noi dung'. Khong dung cho — brief tung bai truoc khi viet thi dung skill 36-content-brief; viet caption thanh pham thi dung skill 37-caption-social; lap plan ky sau tu data thi dung skill 40-next-content-plan.

日本語の概要は準備中です。原文の説明を表示しています。

minhnv0807/ai-business-skills6132026年9月12日 更新

Dung khi can brief mot chien dich cu the cho ca team thuc thi — muc tieu, thong diep, deliverable, timeline phan cong theo tuan, gate duyet va ma tran rui ro. Kich hoat khi user nhac 'brief chien dich', 'ke hoach campaign', 'len brief cho team', 'chien dich thang toi', 'phan cong campaign', 'timeline chien dich'. Khong dung cho — ke hoach marketing ca ky thi dung skill 00-ke-hoach-mkt; danh sach asset can thiet ke thi dung skill 41-campaign-asset-list; giao viec cho tung nguoi thi dung skill 64-team-brief.

日本語の概要は準備中です。原文の説明を表示しています。

minhnv0807/ai-business-skills6132026年9月12日 更新

Use when a specific campaign needs a brief the whole team can execute from — context, objective, audience, core message, creative direction, channels, deliverables, week-by-week timeline, approval gates, and risks. Trigger on 'campaign brief', 'creative brief', 'launch brief', 'brief the team on this campaign', 'we are running a promo next month', 'what is the plan for this campaign'. Also use when the user describes a promotion out loud and asks for something the team can actually run. Not for — the whole period plan, see `00-marketing-plan-global`; the list of design files needed, see `41-campaign-asset-list-global`; assigning work to one person, see `64-team-brief-global`; a new product launch sequence, see `59-go-to-market-global`.

日本語の概要は準備中です。原文の説明を表示しています。

minhnv0807/ai-business-skills6132026年9月12日 更新

minhnv0807 のスキルをすべて見る

このスキルの問題を報告する