/roi-analysis

name: roi-analysis
description: Use when calculating marketing ROI on Xiaohongshu, measuring campaign return on investment, analyzing cost per acquisition, evaluating marketing spend efficiency, or proving marketing value to stakeholders

ROI Analysis (ROI分析)

Overview

ROI (Return on Investment) analysis is the systematic measurement and evaluation of marketing efficiency on Xiaohongshu, calculating returns from investments to optimize spend, justify budgets, and demonstrate business impact through data-driven financial metrics.

When to Use

**Use when**:

• Calculating campaign or content ROI
• Measuring cost per acquisition (CPA)
• Comparing channel or campaign efficiency
• Justifying marketing budget to stakeholders
• Optimizing resource allocation
• Evaluating long-term customer value vs acquisition cost
• Making data-driven investment decisions
• Proving marketing value to leadership

**Do NOT use when**:

• Tracking basic engagement metrics (use data-analytics)
• Monitoring follower growth (use data-metrics-understanding)
• Analyzing content quality (use content-performance-analysis)

Core Pattern

**Before** (unclear returns, gut-feel budgeting):

❌ "Not sure if this campaign is profitable"
❌ "We think it's working, spends keep increasing"
❌ "Can't justify budget to finance team"
❌ "No idea which channel performs best"

**After** (clear ROI, data-driven budgeting):

✅ "Campaign A: 5.2x ROAS, generates ¥520K per ¥100K spend"
✅ "Channel B: ¥45 CAC vs Channel C: ¥120 CAC - scale B"
✅ "Marketing drives 35% of revenue, budget justified"
✅ "Shift budget from C to A and B for 40% ROI improvement"

**6 Essential ROI Metrics**: 1. **ROAS** (Return on Ad Spend): Revenue / Ad Spend 2. **ROI** (Return on Investment): (Revenue - Cost) / Cost × 100% 3. **CPA** (Cost Per Acquisition): Spend / New Customers 4. **CAC** (Customer Acquisition Cost): Marketing Spend / New Customers 5. **CLV** (Customer Lifetime Value): Avg Purchase × Frequency × Lifespan 6. **Payback Period**: Time to recoup acquisition investment

Quick Reference

| Metric | Formula | Good Benchmark | Use Case | Calculation Frequency | |--------|--------|----------------|----------|----------------------| | **ROAS** | Revenue ÷ Ad Spend | 3-5x good, 10x excellent | Ad efficiency | Per campaign, monthly | | **ROI** | (Revenue - Cost) ÷ Cost × 100% | 200%+ good | Overall profitability | Per campaign, quarterly | | **CPA** | Spend ÷ Acquisitions | ¥50-150 varies | Acquisition cost | Per campaign, monthly | | **CAC** | Marketing Spend ÷ New Customers | Minimize | Investment efficiency | Monthly, quarterly | | **CLV** | Avg Order × Frequency × Lifespan | 3× CAC minimum | Long-term value | Quarterly, annually | | **Payback** | Acquisition Cost ÷ (Monthly Profit × Margin) | <12 months | Risk assessment | Per cohort |

Implementation

Step 1: Define Investment and Return

**Identify All Investments (Costs)**:

Direct Marketing Costs:
✅ Ad spend (Xiaohongshu ads, sponsored content)
✅ Influencer fees (KOL collaborations, endorsements)
✅ Content production costs (photography, video creation, design)
✅ Tool and software subscriptions (analytics, scheduling, editing)
✅ Team salaries and contractor fees (proportional time allocation)
✅ Platform fees and commissions
✅ Event and activity costs (giveaways, contests, launch parties)

Indirect Costs (Optional for Full ROI):
✅ Overhead allocation (office space, equipment, utilities)
✅ Management time (strategy, approval, oversight)
✅ Training and development
✅ Research and planning

Cost Tracking Template:
Campaign Costs:
- Ad spend: ¥X
- Influencer fees: ¥Y
- Production: ¥Z
- Tools: ¥A
- Team time: ¥B
Total Investment: ¥X+Y+Z+A+B

Monthly Recurring Costs:
- Retainer fees: ¥X
- Software subscriptions: ¥Y
- Team salaries: ¥Z
- Content budget: ¥A
Total Monthly: ¥X+Y+Z+A

**Define Returns (Revenue)**:

Direct Revenue (Trackable):
✅ Product sales from trackable sources
✅ Service bookings
✅ Course or digital product sales
✅ Affiliate commissions earned
✅ Lead generation (assign value per lead)

Attribution Models:
Last-Click Attribution:
- Credit goes to final touchpoint before purchase
- Simple but undervalues awareness activities
- Formula: Revenue from last-click Xiaohongshu content

Multi-Touch Attribution:
- Distribute credit across all touchpoints in customer journey
- More accurate but complex
- Example: Xiaohongshu ad (40%) + Organic search (30%) + Direct (30%)

Lead Value Attribution:
- Lead quality: Marketing Qualified Lead (MQL) = ¥X value
- Conversion rate: 20% of MQLs convert at ¥Y revenue
- Attributed revenue: MQLs × 20% × ¥Y

Example Revenue Tracking:
Month Revenue:
- Direct sales (trackable): ¥150,000
- Lead conversions (20% of 500 leads × ¥300 avg): ¥30,000
- Total Attributed Revenue: ¥180,000

Step 2: Track Marketing Costs

**Cost Collection Process**:

Step 1: Establish Cost Categories
Create consistent categories:
- Content Production (creative, design, copy)
- Media Buying (ad spend, boosted posts)
- Influencer Marketing (partnerships, sponsorships)
- Tools & Technology (software, platforms)
- Team & Labor (salaries, contractors, agencies)
- Events & Activities (giveaways, contests, launches)

Step 2: Implement Tracking System
Options:
Option A: Spreadsheet Tracking
- Monthly cost tracker by category
- Invoice tracking and organization
- Manual entry for time allocation
- Template: Date, Category, Description, Amount, Notes

Option B: Accounting Software Integration
- Link to accounting system (QuickBooks, Xero)
- Export marketing expenses
- Automated categorization
- Real-time cost monitoring

Option C: Marketing Project Management
- Track costs by project/campaign
- Assign budget vs actual
- Alert on overspend
- Forecast remaining budget

Step 3: Allocate Time and Resources
For team members:
- Track hours spent on marketing activities
- Calculate hourly cost (salary ÷ monthly hours)
- Allocate time to specific campaign