❌ "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"

✅ "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"

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

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 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 campaigns
- Formula: Hours × Hourly Rate = Labor Cost

Example Calculation:
Marketing Manager: ¥15,000/month ÷ 160 hours = ¥94/hour
Time spent on Campaign A: 40 hours
Labor cost for Campaign A: 40 × ¥94 = ¥3,760

Step 4: Track Indirect Costs (Optional)
For complete ROI picture:
- Overhead allocation (rent, utilities, equipment)
- Use percentage of total costs
- Example: 10% overhead allocation
- Formula: Direct Costs × 1.10 = Total Costs

Method 1: Direct Tracking (E-commerce)
Best for: Product sales with clear attribution

Setup:
- Xiaohongshu shop with analytics
- UTM parameters on links
- Unique discount codes per campaign
- Order tagging (source, campaign, content)

Metrics:
- Revenue by campaign
- Revenue by content type
- Revenue by influencer
- Revenue by product
- Conversion rate by source

Example:
Campaign: "Summer Skincare Launch"
UTM: utm_source=xiaohongshu&utm_campaign=summer2025
Code: SUMMER25
Track: All sales with code SUMMER25
Revenue Attributed: ¥75,000

---

Method 2: Lead Generation (B2B or Services)
Best for: Service businesses, consultants, agencies

Setup:
- Lead capture mechanism (forms, DMs)
- Lead quality scoring
- Lead nurturing tracking
- Conversion tracking from lead to customer

Metrics:
- Number of leads generated
- Lead quality score (MQL vs SQL)
- Lead-to-customer conversion rate
- Value per conversion
- Time to conversion

Calculation:
Campaign Cost: ¥20,000
Leads Generated: 200
Cost Per Lead (CPL): ¥20,000 ÷ 200 = ¥100
Conversion Rate: 20% (40 leads become customers)
Value Per Customer: ¥2,000 (avg project)
Revenue: 40 × ¥2,000 = ¥80,000
ROI: (¥80,000 - ¥20,000) ÷ ¥20,000 = 300%

---

Method 3: Brand Awareness (Harder to measure)
Best for: Long-term brand building, not immediate sales

Setup:
- Brand lift studies
- Surveys and market research
- Share of voice tracking
- Brand search volume
- Social sentiment analysis

Metrics:
- Increase in brand searches
- Improvement in brand sentiment
- Share of conversation in category
- Brand recall and recognition

Value Assignment (Challenging):
- Estimate long-term value of awareness
- Compare to previous periods
- Industry benchmarks
- Delphi method (expert estimation)

Example:
Before Campaign: 5% brand search share in category
After Campaign: 12% brand search share
Increase: 7 percentage points
Category search volume: 100K/month
Incremental brand searches: 7,000/month
Value per branded search: ¥5 (based on conversion)
Attributed Value: 7,000 × ¥5 = ¥35,000/month

ROAS (Return on Ad Spend):
Formula: Revenue ÷ Ad Spend
Example: ¥180,000 ÷ ¥50,000 = 3.6x

Interpretation:
- For every ¥1 spent, generate ¥3.60 in revenue
- Benchmark: 3-5x is good, below 3x needs optimization
- Above 5x is excellent, scale the campaign

ROI (Return on Investment):
Formula: (Revenue - Cost) ÷ Cost × 100%
Example: (¥180,000 - ¥80,000) ÷ ¥80,000 × 100% = 125%

Interpretation:
- 125% return means profit is 1.25× the investment
- Positive ROI (>0%) = profitable
- Negative ROI (<0%) = losing money
- Benchmark: 100%+ ROI is good (doubled investment)

CPA (Cost Per Acquisition):
Formula: Spend ÷ Number of Acquisitions
Example: ¥50,000 ÷ 500 customers = ¥100 CPA

Interpretation:
- How much it costs to acquire each customer
- Compare to customer lifetime value
- Target: CPA should be ≤ 1/3 of CLV

CAC (Customer Acquisition Cost):
Formula: Total Marketing Spend ÷ New Customers
Example: ¥80,000 ÷ 500 = ¥160 CAC

Interpretation:
- Includes all marketing costs, not just ad spend
- Broader measure than CPA
- Should be minimized while maintaining quality

CLV (Customer Lifetime Value):
Formula: Avg Order Value × Purchase Frequency × Customer Lifespan

Example Calculation:
- Average Order Value: ¥200
- Purchase Frequency: 3 times/year
- Customer Lifespan: 2 years (makes 6 purchases total)
- CLV = ¥200 × 6 = ¥1,200

CLV:CAC Ratio:
- Target: 3:1 minimum (CLV ≥ 3× CAC)
- Our example: ¥1,200 CLV ÷ ¥160 CAC = 7.5:1 ratio
- Interpretation: Excellent! Each customer worth 7.5× acquisition cost

Payback Period:
Formula: CAC ÷ (Monthly Profit per Customer)

Example:
- CAC: ¥160
- Monthly profit per customer: ¥50
- Payback Period: ¥160 ÷ ¥50 = 3.2 months
- Interpretation: Recover investment in 3.2 months

Break-Even Point:
Formula: Fixed Costs ÷ (Price - Variable Cost %)

Example:
- Campaign Fixed Cost: ¥20,000
- Product Price: ¥200
- Variable Cost (COGS): 40% or ¥80
- Contribution Margin: ¥200 - ¥80 = ¥120
- Break-Even Volume: ¥20,000 ÷ ¥120 = 167 units

Campaign Comparison:

Campaign A:
- Spend: ¥30,000
- Revenue: ¥120,000
- ROAS: 4.0x
- ROI: 300%
- CPA: ¥60
- Verdict: ✅ Scale

Campaign B:
- Spend: ¥20,000
- Revenue: ¥40,000
- ROAS: 2.0x
- ROI: 100%
- CPA: ¥133
- Verdict: ⚠️ Optimize or pause

Campaign C:
- Spend: ¥50,000
- Revenue: ¥250,000
- ROAS: 5.0x
- ROI: 400%
- CPA: ¥40
- Verdict: ✅ Scale aggressively

Decision Framework:
- ROAS < 2x: Pause immediately, optimize or cancel
- ROAS 2-3x: Optimize before scaling
- ROAS 3-5x: Scale gradually
- ROAS > 5x: Scale as fast as possible

Channel Optimization:
If Channel A: ROAS 5.0x, CPA ¥50
And Channel B: ROAS 2.5x, CPA ¥120
Decision: Shift budget from B to A

Reallocation Strategy:
1. Identify best performers (ROAS > 4x)
2. Identify worst performers (ROAS < 2x)
3. Calculate potential reallocation
4. Test reallocation incrementally
5. Measure impact for 2-4 weeks
6. Complete reallocation if positive

Example Reallocation:
Current Budget: ¥100K split evenly
- Channel A (¥50K): ROAS 5.0x → ¥250K revenue
- Channel B (¥50K): ROAS 2.5x → ¥125K revenue
Total: ¥375K revenue, 3.75x ROAS

Proposed Reallocation:
- Channel A (¥80K): ROAS 5.0x → ¥400K revenue
- Channel B (¥20K): ROAS 2.5x → ¥50K revenue
Total: ¥450K revenue, 4.5x ROAS

Impact: +¥75K revenue (+20%) for same spend

Strategy 1: Improve ROAS for Underperformers
Tactics:
- Improve ad targeting (narrow audience, better relevance)
- Enhance creative (test new messaging, images)
- Optimize landing page (better conversion)
- Adjust bidding strategy (lower bids, better efficiency)
- Test different content formats

Strategy 2: Reduce CAC
Tactics:
- Improve organic content (reduce reliance on paid)
- Build brand loyalty (increase repeat purchases)
- Focus on high-intent audiences (bottom of funnel)
- Use retargeting (higher conversion, lower cost)
- Negotiate better rates with partners

Strategy 3: Increase CLV
Tactics:
- Improve product quality (higher prices, retention)
- Add complementary products (cross-sell, upsell)
- Build subscription models (recurring revenue)
- Create community and loyalty programs
- Provide exceptional customer service

Strategy 4: Shorten Payback Period
Tactics:
- Focus on quick-win campaigns
- Front-load revenue (initial purchase incentives)
- Improve onboarding (faster time to value)
- Nurture leads more effectively (faster conversion)
- Target decision-ready audiences (high intent)

Strategy 5: Maximize Efficiency
Tactics:
- A/B test all variables systematically
- Eliminate waste (cut worst performers)
- Automate optimization (use platform AI)
- Scale winners aggressively (don't hold back)
- Reinvest profits into growth (compound returns)

Executive Summary (1 Page):
Campaign Performance Overview:
Total Investment: ¥150,000
Total Revenue Attributed: ¥525,000
Overall ROAS: 3.5x
Overall ROI: 250%
Net Profit: ¥375,000

Key Achievements:
✅ Campaign C exceeded targets (5.0x ROAS)
✅ CPA decreased by 25% (¥120 → ¥90)
✅ CLV increased by 20% (¥1,200 → ¥1,440)
✅ Payback period shortened by 40% (5 → 3 months)

Top 3 Campaigns:
1. Campaign C: ¥50K spend → ¥250K revenue (5.0x ROAS)
2. Campaign A: ¥30K spend → ¥120K revenue (4.0x ROAS)
3. Product Launch: ¥40K spend → ¥140K revenue (3.5x ROAS)

Recommendations:
1. Scale Campaign C by 50% (highest ROAS)
2. Pause Campaign D (lowest ROAS, 1.8x)
3. Reallocate ¥20K from D to C
4. Test video creative in Campaign A (testing showed 15% lift)
5. Invest in retargeting (lower CAC observed)

Expected Impact:
- New Revenue: ¥100K+ from optimization
- Improved ROAS: 4.0x overall (from 3.5x)
- Reduced CPA: ¥80 (from ¥90)

Budget Justification:
Current monthly budget: ¥150,000
Generate: ¥525,000 revenue
Profit: ¥375,000 net
ROI: 250%

Proposed increase:
+¥50,000 budget
Expected +¥175,000 revenue (at 3.5x ROAS)
Net profit: +¥125,000

Break-Even Analysis:
Need ¥50K to generate ¥175K (3.5x)
Break-even achieved within 3 weeks

Risk Assessment:
- Risk: Optimization doesn't achieve expected lift
- Mitigation: Test incrementally, monitor closely
- Exit strategy: Revert to previous allocation if underperforming

Timeline to Results:
Week 1-2: Implement optimizations
Week 3-4: Monitor performance
Week 5-6: Scale winners if successful
Month 2: Full implementation

Confidence Level: High
Based on: Historical data, test results, benchmark comparisons

To Finance Team:
"Our summer campaign generated ¥525K revenue on ¥150K investment,
 delivering 350% ROI. Key insights: Video content outperformed
 images by 40%, retargeting reduced CPA by 30%, and product-focused
 campaigns beat brand campaigns by 2x. We recommend increasing budget
 by ¥50K to scale our winners, projecting additional ¥175K revenue
 with 250% ROI. Risk is low: all recommendations are data-backed
 with test validation."

To Executive Team:
"Marketing is now directly contributing 35% of company revenue,
 up from 22% last quarter. Our most efficient campaigns deliver 5x
 return, while underperformers drag down the average. Strategic
 reallocation of budget from low-ROAS to high-ROAS campaigns will
 improve overall efficiency from 3.5x to 4.0x ROI, generating an
 additional ¥100K profit monthly without increasing total spend."

To Team:
"Great work everyone! Campaign C's 5x ROAS is exceptional - let's
 scale it. Campaign D's 1.8x is below target - we're pausing it to
 focus resources on winners. Your creative testing in Campaign A
 showed 15% improvement - let's roll that out across all campaigns.
 Performance data shows retargeting is our secret weapon - let's
 double down there next month."