Back to Details

ads-math

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

PPC Financial Calculator & Modeling

PPC财务计算器与建模

<!-- Created: 2026-04-13 | v1.5 --> <!-- Source: itallstartedwithaidea/google-ads-skills (PPC math concept) -->
<!-- 创建时间: 2026-04-13 | v1.5 --> <!-- 来源: itallstartedwithaidea/google-ads-skills (PPC计算概念) -->

Process

流程

  1. Ask the user what calculation they need (or detect from context)
  2. Collect required inputs (from pasted data, exports, or verbal description)
  3. Perform calculations with clear formulas shown
  4. Present results with interpretation and recommendations
  5. Flag any concerning metrics or benchmarks
  1. 询问用户所需的计算类型（或从上下文推断）
  2. 收集必要输入数据（来自粘贴的导出数据、口头描述等）
  3. 使用清晰展示的公式执行计算
  4. 呈现计算结果并附上解读与建议
  5. 标记任何异常指标或基准情况

Calculators

计算器模块

1. CPA Calculator

1. CPA计算器

CPA = Total Spend / Total Conversions

Inputs needed:
- Total ad spend (period)
- Total conversions (same period)

Output:
- CPA with period context
- CPA trend (if historical data provided)
- Comparison to industry benchmark (from benchmarks.md)
CPA = 总花费 / 总转化量

所需输入:
- 周期内广告总花费
- 同一周期内总转化量

输出:
- 带周期背景的CPA数值
- CPA趋势（若提供历史数据）
- 与行业基准的对比数据（来自benchmarks.md）

2. ROAS Calculator

2. ROAS计算器

ROAS = Revenue from Ads / Ad Spend
ROAS% = (Revenue - Spend) / Spend × 100

Inputs needed:
- Total ad spend
- Total revenue attributed to ads

Output:
- ROAS as ratio (e.g., 3.5x) and percentage (250%)
- Break-even ROAS (based on margins if provided)
- Comparison to platform benchmarks
ROAS = 广告带来的收入 / 广告花费
ROAS% = (收入 - 花费) / 花费 × 100

所需输入:
- 广告总花费
- 广告带来的总收入

输出:
- ROAS比率（如3.5x）和百分比（250%）
- 收支平衡ROAS（若提供利润率数据）
- 与平台基准的对比数据

3. Break-Even Analysis

3. 收支平衡分析

Break-Even CPA = Average Order Value × Profit Margin
Break-Even ROAS = 1 / Profit Margin

Inputs needed:
- Average order value (AOV) OR average deal value
- Profit margin (gross margin %)
- Current CPA or ROAS

Output:
- Maximum profitable CPA
- Minimum profitable ROAS
- Current headroom (how far above/below break-even)
- Recommendation: scale, maintain, or cut
收支平衡CPA = 平均订单价值 × 利润率
收支平衡ROAS = 1 / 利润率

所需输入:
- 平均订单价值(AOV)或平均交易价值
- 利润率（毛利率百分比）
- 当前CPA或ROAS数值

输出:
- 最大可盈利CPA
- 最低可盈利ROAS
- 当前操作空间（与收支平衡点的差距）
- 建议：扩大投放、维持现状或削减预算

4. Impression Share Opportunity

4. 展示份额机会评估

Impression Share Lost (Budget) = opportunity from budget increase
Impression Share Lost (Rank) = opportunity from bid/quality improvement

Revenue Opportunity = Current Revenue × (1 / Current IS - 1)

Inputs needed:
- Current impression share %
- IS lost to budget %
- IS lost to rank %
- Current spend and conversions

Output:
- Estimated additional conversions from full IS
- Budget needed for full IS (estimated)
- Priority: budget increase vs quality improvement
因预算流失的展示份额 = 增加预算可获得的机会
因排名流失的展示份额 = 优化出价/质量可获得的机会
收入机会 = 当前收入 × (1 / 当前展示份额 - 1)

所需输入:
- 当前展示份额百分比
- 因预算流失的展示份额百分比
- 因排名流失的展示份额百分比
- 当前花费与转化量

输出:
- 达到完整展示份额后的预估新增转化量
- 达到完整展示份额所需的预估预算
- 优先级建议：增加预算 vs 优化质量

5. Budget Forecasting

5. 预算预测

Projected Spend = Daily Budget × Days in Period
Projected Conversions = Projected Spend / Historical CPA
Projected Revenue = Projected Conversions × AOV

Scaling scenarios:
- Conservative: +20% budget → estimated impact
- Moderate: +50% budget → estimated impact
- Aggressive: +100% budget → estimated impact (with diminishing returns caveat)

Inputs needed:
- Current daily budget
- Historical CPA (last 30 days)
- Forecast period
- AOV (if revenue projection needed)

Output:
- 3 scenarios with spend, conversions, revenue projections
- Diminishing returns warning for aggressive scaling
- 20% scaling rule reminder (never increase >20% at a time)
预估花费 = 每日预算 × 周期天数
预估转化量 = 预估花费 / 历史CPA
预估收入 = 预估转化量 × AOV

投放规模场景:
- 保守型：预算增加20% → 预估影响
- 稳健型：预算增加50% → 预估影响
- 激进型：预算增加100% → 预估影响（附带收益递减提示）

所需输入:
- 当前每日预算
- 历史CPA（过去30天）
- 预测周期
- AOV（若需要收入预测）

输出:
- 3种场景下的花费、转化量、收入预测
- 激进型规模扩张的收益递减警告
- 20%调整规则提醒（单次预算增幅不得超过20%）

6. LTV:CAC Ratio

6. LTV:CAC比率分析

CAC = Total Marketing Spend / New Customers Acquired
LTV = Average Revenue per Customer × Average Customer Lifespan
LTV:CAC Ratio = LTV / CAC

Inputs needed:
- Total marketing spend (all channels)
- New customers acquired
- Average revenue per customer (monthly or annual)
- Average customer lifespan (months)
- Optional: gross margin for unit economics

Output:
- LTV:CAC ratio with interpretation:
  - <1:1 = losing money on every customer
  - 1:1-2:1 = break-even to marginal
  - 3:1 = healthy (SaaS benchmark)
  - 5:1+ = may be under-investing in growth
- Payback period: months to recover CAC
- Recommendation based on ratio
CAC = 总营销花费 / 新增客户数量
LTV = 单客户平均收入 × 客户平均生命周期
LTV:CAC比率 = LTV / CAC

所需输入:
- 全渠道总营销花费
- 新增客户数量
- 单客户平均收入（月度或年度）
- 客户平均生命周期（月）
- 可选：单位经济效益毛利率

输出:
- LTV:CAC比率及解读:
  - <1:1 = 每获取一个客户都在亏损
  - 1:1-2:1 = 收支平衡至微利
  - 3:1 = 健康水平（SaaS行业基准）
  - 5:1+ = 可能在增长方面投入不足
- 投资回收期：收回CAC所需的月数
- 基于比率的行动建议

7. MER (Marketing Efficiency Ratio)

7. MER（营销效率比率）评估

MER = Total Revenue / Total Marketing Spend

Inputs needed:
- Total business revenue (period)
- Total marketing spend across ALL channels (same period)

Output:
- MER ratio (e.g., 5.0x)
- Interpretation:
  - E-commerce: 3-5x typical, 8x+ excellent
  - SaaS: 5-10x typical (higher margins)
  - Local service: 3-8x typical
- Comparison to business-type benchmark
- Note: MER captures blended efficiency including organic, brand, and retention
MER = 总业务收入 / 总营销花费

所需输入:
- 周期内总业务收入
- 同一周期内全渠道总营销花费

输出:
- MER比率（如5.0x）
- 解读:
  - 电商行业：3-5x为常规水平，8x+为优秀
  - SaaS行业：5-10x为常规水平（毛利率更高）
  - 本地服务行业：3-8x为常规水平
- 与对应业务类型基准的对比
- 说明：MER涵盖自然流量、品牌流量及留存流量的综合效率

Incrementality & Advanced Measurement

增量测量与高级评估

For advanced accounts evaluating cross-channel contribution:
  • Meta Incremental Attribution (launched April 2025): AI-powered holdout testing measuring real causal impact. Evaluate if budget exceeds $5K/month.
  • Google Meridian (2025): Open-source Marketing Mix Model for incrementality measurement across channels.
  • These tools complement PPC math calculations by measuring what would NOT have happened without the ad spend.
For large accounts detecting small effects (5% MDE), multiply the 10% MDE sample by ~4x.
针对评估跨渠道贡献的高级账户：
  • Meta增量归因（2025年4月推出）：基于AI的对照组测试，衡量真实因果影响。当预算超过每月5000美元时可评估。
  • Google Meridian（2025年推出）：用于增量测量的开源营销组合模型，覆盖多渠道。
  • 这些工具可补充PPC计算，衡量若无广告投入则不会产生的效果。
对于需要检测微小效果（5%最小可检测效果）的大型账户，需将10%最小可检测效果的样本量扩大约4倍。

Quick Formulas Reference

快速公式参考

MetricFormula
CPASpend / Conversions
ROASRevenue / Spend
CTRClicks / Impressions × 100
CVRConversions / Clicks × 100
CPCSpend / Clicks
CPM(Spend / Impressions) × 1,000
CPLSpend / Leads
Break-Even CPAAOV × Margin%
Break-Even ROAS1 / Margin%
LTVARPU × Avg Lifespan
CACTotal Marketing / New Customers
MERTotal Revenue / Total Marketing
Impression Share OppRevenue × (1/IS - 1)
指标公式
CPA花费 / 转化量
ROAS收入 / 花费
CTR点击量 / 展示量 × 100
CVR转化量 / 点击量 × 100
CPC花费 / 点击量
CPM(花费 / 展示量) × 1,000
CPL花费 / 线索量
收支平衡CPAAOV × 毛利率%
收支平衡ROAS1 / 毛利率%
LTV单客户平均收入 × 平均生命周期
CAC总营销花费 / 新增客户数量
MER总收入 / 总营销花费
展示份额机会收入 × (1/展示份额 - 1)

Output Format

输出格式

undefined
undefined

PPC Financial Analysis

PPC财务分析

[Calculator Name]

[计算器名称]

Inputs:
  • [Listed inputs with values]
Results:
MetricValueBenchmarkStatus
[Metric][Value][Benchmark]PASS/WARNING/FAIL
Interpretation: [1-2 sentence analysis]
Recommendation: [Actionable next step]
undefined
输入数据:
  • [带数值的输入列表]
计算结果:
指标数值基准值状态
[指标][数值][基准值]通过/警告/异常
解读: [1-2句话的分析内容]
建议: [可执行的下一步行动]
undefined

Data to Request

需要请求的数据

If the user doesn't provide enough data, ask for:
  • Platform and campaign type
  • Time period for analysis
  • Spend and conversion data
  • Revenue data (if ROAS/break-even needed)
  • Margin data (if break-even/LTV needed)
  • Business type (for benchmark comparison)
若用户未提供足够数据，需询问以下信息:
  • 平台与广告活动类型
  • 分析的时间周期
  • 花费与转化数据
  • 收入数据（若需要ROAS/收支平衡计算）
  • 利润率数据（若需要收支平衡/LTV计算）
  • 业务类型（用于基准对比）