Skip to content

aiskillstore/marketplace / skills/aaron-he-zhu/roi-calculator

roi-calculator

Verified

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.

FileKindSize
SKILL.mdskill md11.9 KB
references/roi-templates.mdmarkdown12.3 KB
skill-report.jsonconfig51.6 KB

references/roi-templates.md

View on GitHub
# ROI Calculator — Templates & Benchmark Inputs

Fill-in templates for each methodology in [../SKILL.md](../SKILL.md) Instructions, plus the worked example and benchmark-evidence contract. Each block maps to a numbered step.

## Step 1 — ROI Calculation Inputs

```markdown
### ROI Calculation Inputs

**Campaign Details**:
- Campaign: [name]
- Duration: [dates]
- Objective: [awareness/consideration/conversion]

**Investment (Total Spend)**:
| Category | Amount |
|----------|--------|
| Influencer fees | $[X] |
| Product/Gifting | $[X] |
| Production costs | $[X] |
| Paid amplification | $[X] |
| Agency/Tools | $[X] |
| **Total Investment** | **$[X]** |

**Results Data**:
| Metric | Value |
|--------|-------|
| Total Reach | [X] |
| Total Impressions | [X] |
| Total Engagements | [X] |
| Video Views | [X] |
| Link Clicks | [X] |
| Conversions/Sales | [X] |
| Revenue | $[X] |
| New Customers | [X] |
```

## Step 2 — Direct ROI Calculation

```markdown
## Direct ROI Calculation

### Simple ROI

**Formula**: (Revenue - Investment) / Investment × 100

```
Revenue:     $[X]
Investment:  $[X]
Profit:      $[X]

ROI = ($[Revenue] - $[Investment]) / $[Investment] × 100
ROI = [X]%
```

### Return on Ad Spend (ROAS)

**Formula**: Revenue / Investment

```
ROAS = $[Revenue] / $[Investment]
ROAS = [X]:1

Interpretation: For every $1 spent, generated $[X] in revenue
```

### Direct ROI Summary

| Metric | Value | Declared target (source/date) | Comparison |
|--------|-------|-------------------------------|------------|
| ROI % | [X]% | [X]% ([source], [date]) | [above/below/equal/pending] |
| ROAS | [X]:1 | [X]:1 ([source], [date]) | [above/below/equal/pending] |
| Profit | $[X] | Not applicable | Descriptive |

**Assessment**: [Profitable/Break-even/Loss]
```

## Step 3 — Earned Media Value (EMV)

```markdown
## Earned Media Value Calculation

### EMV Methodology

EMV estimates the equivalent paid media cost to achieve the same results.

### Impression-Based EMV

**Formula**: Impressions × declared comparable CPM / 1000

| Platform | Impressions | CPM | EMV |
|----------|-------------|-----|-----|
| Instagram | [X] | $[X] | $[X] |
| TikTok | [X] | $[X] | $[X] |
| YouTube | [X] | $[X] | $[X] |
| **Total** | **[X]** | - | **$[X]** |

### Engagement-Based EMV

**Formula**: Engagements × Cost per Engagement

| Engagement Type | Volume | CPE | EMV |
|-----------------|--------|-----|-----|
| Likes | [X] | $[X] | $[X] |
| Comments | [X] | $[X] | $[X] |
| Shares | [X] | $[X] | $[X] |
| Saves | [X] | $[X] | $[X] |
| Video Views | [X] | $[X] | $[X] |
| **Total** | - | - | **$[X]** |

### Combined EMV

| Method | Value |
|--------|-------|
| Impression EMV | $[X] |
| Engagement EMV | $[X] |
| **Average EMV** | **$[X]** |

### EMV ROI

```
EMV Generated: $[X]
Investment:    $[X]
EMV Multiple:  [X]x

For every $1 spent, earned $[X] in equivalent media value
```

### EMV Caveats

⚠️ **Note**: EMV is an estimate and varies by methodology. Use for directional comparison, not absolute measurement.
```

## Step 4 — Cost Efficiency Analysis

```markdown
## Cost Efficiency Analysis

### Cost Per Metrics

| Metric | Formula | Result | Declared target (source/date) | Comparison |
|--------|---------|--------|-------------------------------|------------|
| CPM | Spend ÷ (Impressions/1000) | $[X] | $[X] ([source], [date]) | [above/below/equal/pending] |
| CPR (Reach) | Spend ÷ (Reach/1000) | $[X] | $[X] ([source], [date]) | [above/below/equal/pending] |
| CPE | Spend ÷ Engagements | $[X] | $[X] ([source], [date]) | [above/below/equal/pending] |
| CPV (Video) | Spend ÷ Views | $[X] | $[X] ([source], [date]) | [above/below/equal/pending] |
| CPC | Spend ÷ Clicks | $[X] | $[X] ([source], [date]) | [above/below/equal/pending] |
| CPA | Spend ÷ Acquisitions | $[X] | $[X] ([source], [date]) | [above/below/equal/pending] |
| CAC | Total Spend ÷ New Customers | $[X] | $[X] ([source], [date]) | [above/below/equal/pending] |

### Comparison Contract

| Field | Required value |
|-------|----------------|
| Target metric and rule | [metric, threshold/range, better direction] |
| Source | [publisher or first-party cohort query] |
| Publication/retrieval date | [YYYY-MM-DD] |
| Market and comparison cohort | [market, industry, audience, platform] |
| Observation window | [dates and lag] |
| Attribution basis | [model and conversion definition] |
| Cost and currency basis | [included costs, currency, FX date] |
| Compatibility notes | [material differences or none] |

**Comparison result**: [above/below/equal/pending]. Use `pending` when the target is absent, stale, or materially incompatible.

### vs. Other Channels

Normalize currency, included costs, observation window, and attribution before comparing channels.

| Channel | CPA | Source/date | Comparable basis? | vs. Influencer |
|---------|-----|-------------|-------------------|----------------|
| Influencer Marketing | $[X] | [source/date] | Baseline | - |
| Paid Social | $[X] | [source/date] | [yes/no] | [+/-X% or pending] |
| Paid Search | $[X] | [source/date] | [yes/no] | [+/-X% or pending] |
| Display Ads | $[X] | [source/date] | [yes/no] | [+/-X% or pending] |
| Email Marketing | $[X] | [source/date] | [yes/no] | [+/-X% or pending] |
```

## Step 5 — Attribution Analysis

```markdown
## Attribution Analysis

### Attribution Methods

| Method | Description | Result | Notes |
|--------|-------------|--------|-------|
| First Touch | All credit to first interaction | $[X] | Awareness focus |
| Last Touch | All credit to last interaction | $[X] | Conversion focus |
| Linear | Equal credit across touchpoints | $[X] | Balanced view |
| Time Decay | More credit to recent touches | $[X] | Recency bias |
| Position Based | 40/20/40 first/middle/last | $[X] | Common B2C model |

### Attributed Revenue by Model

| Model | Attributed Revenue | ROI |
|-------|-------------------|-----|
| First Touch | $[X] | [X]% |
| Last Touch | $[X] | [X]% |
| Linear | $[X] | [X]% |
| Time Decay | $[X] | [X]% |
| Position Based | $[X] | [X]% |

### Recommended Model for Your Business

**Recommended**: [Model]
**Rationale**: [Why this model fits your customer journey]

### Multi-Touch Journey Example

```
Customer Journey:

Day 1: Sees @creator1 TikTok (Awareness) ─────┐
Day 3: Sees @creator2 Instagram Reel ─────────┤
Day 5: Clicks @creator1's link (Consideration)┼── Purchase Day 7
Day 7: Uses @creator2's code (Conversion) ────┘

Attribution:
Last Touch:     100% to @creator2
First Touch:    100% to @creator1
Linear:         50% each
Position Based: 40% @creator1, 40% @creator2, 20% repeat exposure
```
```

## Step 6 — Lifetime Value Analysis

```markdown
## Lifetime Value Analysis

### New Customer Metrics

| Metric | Influencer Acquired | Overall Average |
|--------|--------------------|--------------------|
| New customers | [X] | - |
| First order AOV | $[X] | $[X] |
| Repeat purchase rate | [%] | [%] |
| Customer lifetime value | $[X] | $[X] |

### LTV-Based ROI

**Formula**: (New Customers × Avg LTV) - Investment / Investment

```
New Customers:     [X]
Average LTV:       $[X]
Total LTV:         $[X]
Investment:        $[X]

LTV-Based ROI = ($[X] - $[X]) / $[X] × 100
LTV-Based ROI = [X]%
```

### Short-term vs. Long-term View

| Timeframe | Revenue | ROI |
|-----------|---------|-----|
| Immediate (this campaign) | $[X] | [X]% |
| 6-month projected | $[X] | [X]% |
| 12-month projected | $[X] | [X]% |
| Lifetime projected | $[X] | [X]% |

### Customer Quality Indicators

| Indicator | Influencer-Acquired | Organic | Paid Ads |
|-----------|--------------------|---------| ---------|
| AOV | $[X] | $[X] | $[X] |
| Return rate | [%] | [%] | [%] |
| Repeat rate | [%] | [%] | [%] |
| NPS/Satisfaction | [X] | [X] | [X] |
```

## Step 7 — Influencer-Level ROI

```markdown
## Influencer-Level ROI

### Individual Influencer Performance

| Influencer | Investment | Revenue | ROI | ROAS | Rank |
|------------|------------|---------|-----|------|------|
| @[handle1] | $[X] | $[X] | [X]% | [X]:1 | 1 |
| @[handle2] | $[X] | $[X] | [X]% | [X]:1 | 2 |
| @[handle3] | $[X] | $[X] | [X]% | [X]:1 | 3 |
| @[handle4] | $[X] | $[X] | [X]% | [X]:1 | 4 |
| @[handle5] | $[X] | $[X] | [X]% | [X]:1 | 5 |

### ROI Distribution

```
Influencer ROI Distribution:

@handle1  |████████████████████| 320%
@handle2  |██████████████      | 180%
@handle3  |████████████        | 150%
@handle4  |██████              | 75%
@handle5  |████                | 45%

Campaign Average: 180%
```

### Investment Efficiency

| Influencer | % of Budget | % of Revenue | Efficiency |
|------------|-------------|--------------|------------|
| @[handle1] | [%] | [%] | [X]x |
| @[handle2] | [%] | [%] | [X]x |

### ROI by Tier

| Tier | Investment | Revenue | ROI | Avg ROAS |
|------|------------|---------|-----|----------|
| Macro | $[X] | $[X] | [%] | [X]:1 |
| Micro | $[X] | $[X] | [%] | [X]:1 |
| Nano | $[X] | $[X] | [%] | [X]:1 |
```

## Step 8 — ROI Summary Report

```markdown
# ROI Summary Report

## Campaign: [Name]
## Period: [Dates]

---

## Investment Summary

| Category | Amount | % of Total |
|----------|--------|------------|
| Influencer Fees | $[X] | [%] |
| Product/Gifts | $[X] | [%] |
| Amplification | $[X] | [%] |
| Other | $[X] | [%] |
| **Total Investment** | **$[X]** | **100%** |

## Returns Summary

| Return Type | Value |
|-------------|-------|
| Direct Revenue | $[X] |
| Earned Media Value | $[X] |
| New Customers | [X] |
| Projected LTV | $[X] |

## ROI by Methodology

| Methodology | ROI | Notes |
|-------------|-----|-------|
| Direct Revenue ROI | [X]% | Hard returns |
| ROAS | [X]:1 | Revenue per dollar |
| EMV Multiple | [X]x | Media value generated |
| LTV-Based ROI | [X]% | Long-term value |

## Key Metrics

| Metric | Result | Declared target (source/date) | Comparison |
|--------|--------|-------------------------------|------------|
| CPM | $[X] | $[X] ([source], [date]) | [above/below/equal/pending] |
| CPA | $[X] | $[X] ([source], [date]) | [above/below/equal/pending] |
| ROAS | [X]:1 | [X]:1 ([source], [date]) | [above/below/equal/pending] |

## Bottom Line

**Investment**: $[X]
**Return**: $[X]
**Net Profit**: $[X]
**ROI**: [X]%

**Assessment**: [Campaign was profitable/broke even/lost money]

## Recommendations

1. [Key recommendation 1]
2. [Key recommendation 2]
3. [Key recommendation 3]

**Decision owner and precommitted rule**: [owner / rule / UNDECIDED]

---

*Report Generated: [Date]*
```

## Worked Example

**User**: "Calculate ROI for our influencer campaign: $25K spend, $72K revenue, 2.1M reach"

**Output**:

```markdown
# ROI Calculation Summary

## Investment & Returns

| Item | Value |
|------|-------|
| Total Investment | $25,000 |
| Direct Revenue | $72,000 |
| Total Reach | 2,100,000 |

## ROI Results

### Direct ROI
- **Profit**: $47,000
- **ROI**: 188%
- **ROAS**: 2.88:1

For every $1 spent, you generated $2.88 in revenue.

### Earned Media Value
- **EMV** (directional scenario at a declared $8 CPM): $16,800
- **EMV Multiple**: 0.67x

### Cost Efficiency
- **CPM**: $11.90
- **CPA**: Unknown (conversion count was not supplied)

## Assessment: Profitable on the supplied direct-revenue basis

Direct revenue exceeds the supplied investment, but no source-dated peer target or incrementality evidence was provided. Do not infer benchmark outperformance or authorize a scale decision from this read alone; obtain verified conversions, attribution evidence, and the campaign owner's precommitted decision rule first.
```

## Benchmark Evidence Template

Do not use a repository-default industry threshold. Supply a first-party target or a source-dated external comparator whose market, cohort, window, attribution, and cost basis are compatible with the campaign.

| Field | Value |
|-------|-------|
| Metric | [ROAS / ROI / CPM / CPA / CAC / other] |
| Target or distribution | [value, range, or quantile] |
| Better direction | [higher/lower] |
| Source | [publisher, report, URL, or first-party query] |
| Publication/retrieval date | [YYYY-MM-DD] |
| Market / industry / platform | [scope] |
| Comparison cohort | [selection definition and sample size, if known] |
| Observation window and lag | [dates] |
| Attribution and conversion definition | [basis] |
| Included costs / currency / FX date | [basis] |
| Compatibility assessment | [compatible / materially different / unknown] |
| Comparison status | [above / below / equal / pending] |
canvas-designanthropics/skillsCreate beautiful visual art in .png and .pdf documents using design philosophy. You should use this skill when the user asks to create a poster, piece of art, design, or other static piece. Create original visual designs, never copying existing artists' work to avoid copyright violations.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
docxanthropics/skillsUse this skill whenever the user wants to create, read, edit, or manipulate Word documents (.docx files) or Word templates (.dotx files). Triggers include: any mention of 'Word doc', 'word document', '.docx', '.dotx', or requests to produce professional documents with formatting like tables of contents, headings, page numbers, or letterheads. Also use when extracting or reorganizing content from .docx or .dotx files, inserting or replacing images in documents, performing find-and-replace in Word files, working with tracked changes or comments, or converting content into a polished Word document. If the user asks for a 'report', 'memo', 'letter', 'template', or similar deliverable as a Word or .docx file, use this skill. Do NOT use for PDFs, spreadsheets, Google Docs, or general coding tasks unrelated to document generation.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
pdfanthropics/skillsUse this skill whenever the user wants to do anything with PDF files. This includes reading or extracting text/tables from PDFs, combining or merging multiple PDFs into one, splitting PDFs apart, rotating pages, adding watermarks, creating new PDFs, filling PDF forms, encrypting/decrypting PDFs, extracting images, and OCR on scanned PDFs to make them searchable. If the user mentions a .pdf file or asks to produce one, use this skill.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
pptxanthropics/skillsUse this skill any time a .pptx or .potx file is involved in any way — as input, output, or both. This includes: creating slide decks, pitch decks, or presentations; reading, parsing, or extracting text from any .pptx or .potx file (even if the extracted content will be used elsewhere, like in an email or summary); editing, modifying, or updating existing presentations; combining or splitting slide files; working with templates (.potx), layouts, speaker notes, or comments. Trigger whenever the user mentions "deck," "slides," "presentation," or references a .pptx or .potx filename, regardless of what they plan to do with the content afterward. If a .pptx or .potx file needs to be opened, created, or touched, use this skill.Stars: 198kUpdated Claude CodeCodexVerifiedInstall