roi-calculator
Use when the user asks to "calculate influencer ROI", "prove campaign value", or "what was our ROAS"; produces direct ROI/ROAS, earned media value, attribution-modeled revenue, LTV-based ROI, and a stakeholder-ready summary. Not for building the full slide/written report — use report-generator. 达人营销ROI计算/投资回报测算
aaron-he-zhu · 已有静态检查记录
安装与使用
运行命令前先阅读来源与依赖说明。复制命令不会自动安装或执行。
npx skills add aaron-he-zhu/aaron-marketing-skills --skill roi-calculator技能说明
name: roi-calculator slug: aaron-roi-calculator displayName: "ROI Calculator · ROI 计算" summary: "活动投入产出核算:成本归集、收益口径与 ROI 及 STAR 回报(R)证据汇总" description: 'Use when the user asks to "calculate influencer ROI", "prove campaign value", or "what was our ROAS"; produces direct ROI/ROAS, earned media value, attribution-modeled revenue, LTV-based ROI, and a stakeholder-ready summary. Not for building the full slide/written report — use report-generator. 达人营销ROI计算/投资回报测算' version: "20.2.0" license: Apache-2.0 compatibility: "Claude Code and compatible agent-skill hosts" homepage: "https://github.com/aaron-he-zhu/aaron-marketing-skills" when_to_use: "Use when measuring or projecting influencer campaign ROI, justifying or defending budgets, comparing ROI across campaigns or channels, evaluating individual influencer or tier value, or preparing executive-level ROI numbers. Activate when the user supplies spend and results data and wants ROI, ROAS, EMV, CPA/CAC, attribution, or LTV impact computed." argument-hint: " [revenue] [results data]" metadata: {"author": "aaron-he-zhu", "version": "20.2.0", "discipline": "influencer", "phase": "report", "geo-relevance": "low", "hermes": {"tags": ["marketing", "influencer", "report"], "category": "influencer"}, "openclaw": {"emoji": "📣", "homepage": "https://github.com/aaron-he-zhu/aaron-marketing-skills"}}
ROI Calculator
This skill helps you calculate and communicate the return on investment for influencer marketing campaigns using various methodologies appropriate for your goals and available data.
Cross-discipline (paid ads): this is the shared return-math engine for paid ads — paid-measurement-loop, attribution-reconciler, and budget-optimizer delegate ROAS/CPA/payback ratios here rather than recomputing them. Save paid runs under
memory/ad/roi-calculator/.
Quick Start
Shortest invocation:
Calculate ROI for our influencer campaign: $25K spend, $72K revenue, 2.1M reach
Common scenario — compare methods before reporting:
What's the ROI of our campaign using direct revenue, EMV, and LTV-based methods?
Skill Contract
- Reads: campaign ID, complete opaque creator scope when creator-level math is requested, spend/cost-basis breakdown, deduplicated results data (reach, impressions, engagements, clicks, conversions, attributed revenue, new customers), the predeclared attribution model/window/decision rule, AOV and economic LTV inputs if LTV is in scope, and prior performance output from
performance-analyzer. Reuse authorized opaquecreator_refvalues; raw handles/names/URLs/provider IDs stay transient and never identify a saved row. - Writes: return the ROI calculation and summary inline by default; save them to
memory/influencer/roi-calculator/YYYY-MM-DD-<topic>.md(or the declared paid path) only with exact WARM-save authorization. Saved output usescampaign_id, complete opaquecreator_refscope, and opaque evidence/artifact refs—never raw identity locators. - Promotes: only with separate exact authorization, promote durable headline numbers with their attribution window, source, and uncertainty to
memory/hot-cache.md; a calculation or WARM-save request does not authorize this operation. - Done when:
- At least one ROI methodology is computed with the inputs and formula shown.
- Each headline metric is stated against a declared, source-dated comparison target; no universal benchmark is invented.
- A bottom-line arithmetic assessment and 1-3 recommendations are written. Call the campaign profitable only when attributed revenue and a complete campaign cost basis are verified; otherwise state that profitability is unverified.
- Every denominator is verified numeric and
> 0; zero, negative, missing, or incompatible denominators yieldundefined/NEEDS_INPUT, never a ratio.
- Primary next skill: report-generator
Handoff Summary
Emit the standard shape from skill-contract.md §Handoff Summary Format.
Data Sources
This family is Tier 1 — it works with no live integrations. Ask the user for spend and results data and compute everything from those inputs. Connectors below can pull the numbers automatically when available:
~~social platform analytics— reach, impressions, engagements, video views per platform for EMV and cost-per-metric math.~~ecommerce / analytics— revenue, conversions, link clicks, and AOV for direct ROI and attribution.~~CRM— new-customer counts, repeat-purchase rate, and lifetime value for LTV-based ROI.~~influencer database— per-influencer fees and tier data for by-influencer ROI.
With zero integrations, supply the investment and results tables by hand and the skill still produces every calculation. See CONNECTORS.md for the free/keyless recipe per category.
Instructions
When a user requests ROI calculation, work the steps below. Each step has a fill-in template in references/roi-templates.md — link the step number to its block there.
-
Gather ROI inputs — campaign details, the investment (total spend) table, and the results-data table. (template)
-
Calculate direct ROI — Simple ROI = (Revenue − Investment) / Investment × 100; ROAS = Revenue / Investment. Call the difference net return under the declared formula, not profit, unless the revenue attribution and complete cost basis are verified. State positive/zero/negative arithmetic return and a separate profitability-verification status. (template)
-
Calculate Earned Media Value (EMV) — impression-based (Impressions × comparable CPM / 1000) or engagement-based (E