# roi-analysis

roi-analysis calculates marketing ROI and ad efficiency on Xiaohongshu. Helps justify budgets to stakeholders using concrete financial performance metrics.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 175 installs · ★ 564 repo stars
- Author: vivy-yi
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/vivy-yi/xiaohongshu-skills/tree/HEAD/skills/03-数据分析/roi-analysis/SKILL.md
- Updated: 2026-01-23
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/roi-analysis

## What it does

This skill guides financial evaluation of Xiaohongshu marketing campaigns. It calculates six core figures: ROAS, general ROI, acquisition costs (CPA and CAC), customer lifetime value, and payback speed. The methodology covers direct outlays like sponsored creator fees and production expenses, as well as team labor rates.

The workflow outlines expense categorization across spreadsheets or accounting tools alongside revenue tracking via shop analytics, UTM parameters, and promo codes. It applies attribution setups ranging from last-touch credit to multi-touch journeys.

Do not use it for evaluating follower growth or post engagement. The skill focuses strictly on revenue attribution and campaign profitability.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add vivy-yi/xiaohongshu-skills --skill roi-analysis -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/roi-analysis/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/roi-analysis/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add vivy-yi/xiaohongshu-skills --skill roi-analysis -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/roi-analysis/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add vivy-yi/xiaohongshu-skills --skill roi-analysis -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/roi-analysis/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install vivy-yi/xiaohongshu-skills skills/03-数据分析/roi-analysis
```

2. **Manually: put the files in place**
- File: `.github/skills/roi-analysis/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add vivy-yi/xiaohongshu-skills --skill roi-analysis -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/vivy-yi/xiaohongshu-skills --path skills/03-数据分析/roi-analysis
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/roi-analysis/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add vivy-yi/xiaohongshu-skills --skill roi-analysis -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/vivy-yi/xiaohongshu-skills/tree/HEAD/skills/03-数据分析/roi-analysis/SKILL.md

## When to use it
- calculate campaign ROAS and net ROI
- measure customer acquisition cost across channels
- defend marketing budgets with financial attribution
- reallocate ad spend toward profitable channels

## Example prompts
- Calculate ROAS and CAC for our latest Xiaohongshu launch using these sales numbers
- Compare channel profitability and suggest how to reallocate the ad spend
- Build a payback period model factoring in influencer costs and creative production

## Similar
- [roi-calculator](https://affpapa.org/en/nevibecode/skills/roi-calculator.md) — skill · 1100 installs
- [marketing-analyst](https://affpapa.org/en/nevibecode/skills/marketing-analyst.md) — skill · 312 installs
- [cac-roas-benchmark](https://affpapa.org/en/nevibecode/skills/cac-roas-benchmark.md) — skill · 26700 installs
- [ad-platform-selection](https://affpapa.org/en/nevibecode/skills/ad-platform-selection.md) — skill · 26700 installs
- [upGrowth Growth Toolkit](https://affpapa.org/en/nevibecode/mcp/upgrowth-growth-toolkit.md) — MCP server · ★ 3 repo stars
- [cs-demand-gen-specialist](https://affpapa.org/en/nevibecode/agents/cs-demand-gen-specialist.md) — subagent · ★ 30251 repo stars

From the same set: [vivy-yi/xiaohongshu-skills](https://affpapa.org/en/nevibecode/by/vivy-yi/xiaohongshu-skills.md) — 100 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
