Loading...
Loading...
Use when analyzing e-commerce performance on Xiaohongshu, tracking live stream sales data, researching product trends, monitoring competitor shops, or optimizing e-commerce strategies with data insights
npx skill4agent add vivy-yi/xiaohongshu-skills ju-mama❌ "No idea which products sell best"
❌ "Guessing pricing strategies"
❌ "Blind to competitor moves"
❌ "Wasting ad spend on poor performers"
❌ "Stock outs or overstock situations"✅ "Know exactly what sells and why"
✅ "Optimal pricing based on market data"
✅ "Competitor strategies revealed"
✅ "Invest in high-ROI products only"
✅ "Inventory matches demand perfectly"| Analysis Type | Key Metrics | Update Frequency | Use For |
|---|---|---|---|
| Live Stream Sales | GMV, units sold, conversion | Real-time | Performance optimization |
| Product Trends | Search volume, sales rank | Daily | Product selection |
| Shop Analytics | Revenue, traffic, conversion | Daily | Business health |
| Competitor Data | Pricing, promotions, sales | Weekly | Strategy adjustment |
| Influencer Commerce | Sales per influencer, ROI | Per campaign | Partner selection |
Live Stream Analytics Framework:
1. GMV and Sales Tracking
Measure Revenue Generation:
Key Metrics:
GMV (Gross Merchandise Value):
- Total sales value (before returns)
- Real-time tracking during stream
- Segment by product
- Compare to targets
Units Sold:
- Quantity of each product
- Inventory depletion rate
- Best-selling items
- Stock level alerts
Conversion Rate:
- Viewers to buyers
- Clicks to purchases
- Offer conversion
- Time-based conversion (peak times)
Example Live Stream Dashboard:
"Live Stream: March 15, 8-9 PM
Product: Hydrating Serum Launch
Real-Time Metrics:
- Peak viewers: 5,200
- Average watch time: 18 minutes
- GMV generated: ¥127,500
- Units sold: 847 units
- Avg order value: ¥150
- Conversion rate: 16.3%
Product Breakdown:
- Hydrating Serum: 650 units (¥97,500)
- Gentle Cleanser: 120 units (¥12,000)
- Night Cream: 77 units (¥18,000)
Peak Sales Time:
- 8:45-8:55 PM (offer announcement)
- Sold 350 units in 10 minutes
Insights:
- Offer timing drove 40% of sales
- Serum is hero product (77% of revenue)
- Cleanser and cream are add-ons
- Optimal offer time: 45 min into stream"
2. Engagement-to-Sales Funnel
Understand Conversion Path:
Funnel Stages:
Viewers → Product Clicks → Add to Cart → Purchase
Stage Metrics:
Viewers (Top of Funnel):
- Total unique viewers
- Peak concurrent
- Average duration
Product Clicks (Mid-Funnel):
- Product page views
- Click-through rate
- Product interest ranking
Add to Cart (Bottom-Funnel):
- Cart additions
- Cart abandonment rate
- Multiple product adds
Purchase (Conversion):
- Completed purchases
- Conversion rate
- Revenue per viewer
Funnel Analysis:
"Live Stream Funnel Analysis:
Stage 1 - Viewers: 5,200 (100%)
↓
Stage 2 - Product Clicks: 1,820 (35% click-through)
↓
Stage 3 - Add to Cart: 1,144 (63% cart rate from clicks)
↓
Stage 4 - Purchase: 847 (74% purchase rate from carts)
Drop-off Analysis:
- 65% don't click products (engagement issue)
- 37% abandon cart (objection or friction)
- 26% don't purchase (decision hesitation)
Optimization Opportunities:
- Improve product presentations (increase clicks)
- Address cart objections (reduce abandonment)
- Create urgency (increase purchase rate)
Next Stream Actions:
- More product demos (boost click-through)
- Limited stock warnings (reduce hesitation)
- Bundle offers (increase cart value)"
3. Offer Performance Analysis
Identify Winning Promotions:
Offer Types Tested:
Percentage Discount:
- 10% off (moderate)
- 20% off (strong)
- 30% off (aggressive)
Bundle Deals:
- Buy 2 get 1 free
- Complete kit (3 products)
- Starter kit (2 products)
Exclusive Offers:
- Live-only pricing
- Limited quantity
- Time-sensitive (next 10 minutes)
Performance Comparison:
"Offer Test Results:
Offer A: 15% off single product
- Units sold: 180
- Revenue: ¥22,950
- Avg discount: ¥22.50 per unit
- Margin: 65%
Offer B: Buy 2 get 1 free (bundle)
- Units sold: 450 (150 bundles)
- Revenue: ¥45,000
- Avg discount: ¥30 per bundle
- Margin: 55%
- Inventory movement: 3x faster
Offer C: Live-only 20% off + free shipping
- Units sold: 280
- Revenue: ¥33,600
- Avg discount: ¥40 per unit
- Margin: 50%
- Urgency: High (live-only)
Winner: Offer B (Buy 2 Get 1)
- Highest revenue (¥45,000)
- Best inventory efficiency
- Good margin maintained
- Customer perceived value: High
Learning: Bundles outperform single discounts"
4. Host Performance Evaluation
Measure Presenter Effectiveness:
Host Metrics:
Sales Conversion:
- Revenue per host
- Units sold per host
- Conversion rate by host
- Audience engagement
Presentation Skills:
- Product knowledge
- Energy and enthusiasm
- Audience interaction
- Objection handling
Comparison:
"Host Performance Comparison:
Host A (Brand Founder):
- Streams: 4x/week
- Avg GMV: ¥85,000/stream
- Conversion rate: 14.2%
- Strength: Product expertise, authentic
- Weakness: Less polished presentation
Host B (Professional Streamer):
- Streams: 5x/week
- Avg GMV: ¥92,000/stream
- Conversion rate: 16.8%
- Strength: Polished, great sales skills
- Weakness: Less product depth
Host C (Customer Tester):
- Streams: 2x/week
- Avg GMV: ¥65,000/stream
- Conversion rate: 12.5%
- Strength: Authenticity, relatable
- Weakness: Limited availability
Optimal Mix:
- Host B for major launches (sales skill)
- Host A for educational content (expertise)
- Host C for testimonials (authenticity)
- Combined: ¥242,000/week (all three)"
5. Time-of-Stream Optimization
Identify Peak Selling Moments:
Stream Timeline Analysis:
- First 15 minutes (warm-up)
- 15-45 minutes (peak selling)
- 45-60 minutes (recovery)
- Last 15 minutes (final push)
Peak Identification:
"Time-Based Sales Analysis:
Timeline: 8:00 PM - 9:00 PM
8:00-8:15 PM: Warm-up
- Viewers joining: 0 → 2,000
- Sales: 45 units (¥6,750)
- Activity: Building rapport, intro
8:15-8:45 PM: Peak Performance
- Viewers: 2,000 → 5,200 (peak)
- Sales: 520 units (¥78,000)
- Activity: Product demos, offers
- Key moment: 8:45 PM (150 units in 5 min)
8:45-9:00 PM: Final Push
- Viewers: 5,200 → 3,800
- Sales: 282 units (¥42,300)
- Activity: Last chance offers, urgency
Insights:
- Peak selling: 8:30-9:00 PM (63% of sales)
- Best offer placement: 8:45 PM
- Viewer retention: 73% for full hour
Optimization:
- Build anticipation first 15 min
- Make key offers at 30-45 min mark
- Save best deals for final 15 min
- Extend stream if momentum strong"Product Trend Analysis Framework:
1. Rising Product Categories
Spot Emerging Demand:
Trend Metrics:
Search Volume Growth:
- Week-over-week change
- Month-over-month change
- Seasonal patterns
- Long-term trajectory
Sales Velocity:
- Units sold per day
- Days to sell out (inventory)
- Restock frequency
- Growth rate
Price Trends:
- Average selling price
- Price distribution
- Discount frequency
- Premium vs. budget split
Category Analysis:
"Rising Categories (March 2026):
Skincare: Hydrating Serums
- Search volume: +180% (past month)
- Sales growth: +150%
- Avg price: ¥150-200
- Top brands: [List]
- Key ingredients: HA, ceramides
- Opportunity: High demand, low competition
Beauty: Clean Makeup
- Search volume: +95% (past month)
- Sales growth: +85%
- Avg price: ¥120-180
- Trend: Natural, minimal
- Opportunity: Rising fast
Wellness: Stress Relief
- Search volume: +65% (past month)
- Sales growth: +70%
- Avg price: ¥80-150
- Trend: Aromatherapy, teas
- Opportunity: Emerging niche
Action: Prioritize hydrating serum inventory"
2. Competitor Product Analysis
Benchmark and Differentiate:
Analysis Elements:
Product Mix:
- What competitors sell
- Price points
- Product features
- Bundle strategies
- Unique selling propositions
Performance Data:
- Best-selling products
- Sales velocity
- Customer ratings
- Review sentiment
- Return rates
Pricing Intelligence:
"Competitor Product Pricing:
Our Hydrating Serum: ¥199
Competitor A: ¥179
- Features: 5% HA only
- Positioning: Budget
- Sales: High volume, low margin
Competitor B: ¥249
- Features: HA + peptides
- Positioning: Premium
- Sales: Moderate volume, high margin
Competitor C: ¥189
- Features: HA + ceramides
- Positioning: Mid-tier
- Sales: High volume, good margin
Our Positioning:
- Price: ¥199 (mid-range)
- Features: HA + ceramides + peptides
- Value: More ingredients than C at same price
- Differentiation: Superior formulation
Pricing Strategy:
- Competitive but not cheapest
- Emphasize ingredient quality
- Bundle for better value
- Premium positioning justified"
3. Seasonal Product Trends
Plan Inventory Calendar:
Seasonal Patterns:
Spring (March-May):
- Lightweight moisturizers
- Sun protection (SPF)
- Brightening products
- Flower-based ingredients
Summer (June-August):
- After-sun care
- Oil-control products
- Sweat-resistant makeup
- Body care
Autumn (September-November):
- Rich moisturizers
- Repair products
- Anti-aging focus
- Nourishing treatments
Winter (December-February):
- Heavy hydration
- Barrier repair
- Soothing products
- Gift sets
Seasonal Planning:
"Q2 Product Planning (April-June):
April: Spring Transition
Trending: Lightweight moisturizers (+80%)
Action: Stock 500 units
Forecast: Sell out by May 15
May: Sun Protection Prep
Trending: SPF products (+150%)
Action: Stock 1,000 units
Forecast: Sell out by June 30
June: Summer Hydration
Trending: Gel moisturizers (+120%)
Action: Stock 800 units
Forecast: Sell out by August
Inventory Investment:
- Total units: 2,300
- Total value: ¥345,000 (wholesale)
- Expected revenue: ¥805,000 (retail)
- ROI: 2.3x
Risk Management:
- Overstock risk: Low (strong trends)
- Stockout risk: Moderate (high demand)
- Strategy: 20% buffer stock"
4. Product Feature Analysis
Identify Winning Attributes:
Feature Performance:
Ingredient Popularity:
- Hyaluronic acid (always popular)
- Vitamin C (seasonal spikes)
- Retinol (steady demand)
- Niacinamide (rising fast)
- Ceramides (growing)
Packaging Trends:
- Pump bottles (convenience)
- Sustainable packaging (premium)
- Travel sizes (trial)
- Gift sets (gifting)
Feature Analysis:
"Product Feature Correlation:
High-Selling Products Share:
1. 'Contains hyaluronic acid' (87%)
2. 'Fragrance-free' (72%)
3. 'Suitable for sensitive skin' (68%)
4. 'Pump included' (65%)
5. 'Travel size available' (54%)
Low-Selling Products:
1. 'Strong fragrance' (only 23% have)
2. 'Jar packaging' (only 31% have)
3. 'No size options' (only 42% have)
Insights:
- HA is table stakes (must-have)
- Fragrance-free is expectation
- Sensitive skin friendly = broader market
- Pump preferred over jar
- Size options increase appeal
Product Development:
New formulation must include:
✓ Hyaluronic acid (primary ingredient)
✓ Fragrance-free
✓ 'Safe for sensitive skin' claim
✓ Pump dispenser
✓ Multiple size options
Avoid:
✗ Heavy fragrance
✗ Jar packaging
✗ Single size only"
5. Price Point Optimization
Find Sweet Spot:
Price Analysis:
Price Band Performance:
Under ¥100:
- Volume: Very high
- Margin: Low (30-40%)
- Competition: Intense
¥100-¥150:
- Volume: High
- Margin: Good (50-60%)
- Competition: Moderate
¥150-¥200:
- Volume: Medium-high
- Margin: Very good (65-75%)
- Competition: Manageable
¥200-¥300:
- Volume: Medium
- Margin: Excellent (75-85%)
- Competition: Low
Over ¥300:
- Volume: Low
- Margin: Excellent (80%+)
- Competition: Very low
Optimization:
"Current Price: ¥199
Band: ¥150-¥200 (sweet spot)
Performance at ¥199:
- Units sold/month: 800
- Revenue: ¥159,200
- Margin: 70%
- Profit: ¥111,440
Test ¥179 (lower band):
Projected units: 1,100 (+37%)
Projected revenue: ¥196,900 (+24%)
Projected margin: 65%
Projected profit: ¥127,985 (+15%)
Test ¥219 (upper band):
Projected units: 550 (-31%)
Projected revenue: ¥120,450 (-24%)
Projected margin: 75%
Projected profit: ¥90,338 (-19%)
Decision: Stay at ¥199
Current price maximizes profit
Moving to ¥179 increases volume but decreases
margin and profit per unit
Moving to ¥219 reduces volume significantly
Alternative: Keep ¥199, offer bundle discount
Bundle: ¥349 for 2 (effectively ¥174.50 each)
Increases units, maintains margin perception"Shop Analytics Framework:
1. Revenue and Traffic Analysis
Measure Shop Health:
Key Metrics:
Daily Revenue:
- Gross merchandise value (GMV)
- Net revenue (after returns)
- Average order value (AOV)
- Revenue by traffic source
Traffic Metrics:
- Unique visitors
- Page views
- Traffic sources (organic, paid, social)
- Bounce rate
Conversion Metrics:
- Conversion rate (visitors to buyers)
- Add-to-cart rate
- Checkout completion rate
- Cart abandonment rate
Dashboard Example:
"Shop Performance Dashboard (March 2026):
Traffic:
- Unique visitors: 12,500
- Page views: 45,000 (3.6 pages/visitor)
- Bounce rate: 42%
- Avg session duration: 4:32
Traffic Sources:
- Xiaohongshu organic: 45%
- Live streams: 30%
- Paid ads: 15%
- Direct: 10%
Revenue:
- Gross revenue: ¥458,000
- Returns: ¥23,000 (5%)
- Net revenue: ¥435,000
- Avg order value: ¥186
Conversion:
- Overall conversion: 3.8%
- Add-to-cart: 12%
- Checkout completion: 68%
- Cart abandonment: 32%
Performance Grade: B+
- Traffic: Good
- Conversion: Above average (3.5% benchmark)
- AOV: Healthy
- Returns: Low (good)"
2. Product Performance Ranking
Identify Winners and Losers:
Product Metrics:
Sales Velocity:
- Units sold per day
- Days in stock
- Sell-through rate
- Restock frequency
Profitability:
- Revenue per product
- Margin per product
- ROI ranking
- Inventory turn rate
Customer Satisfaction:
- Rating (1-5 stars)
- Review sentiment
- Return rate
- Repeat purchase rate
Product Ranking:
"Product Performance Report:
A-Tier (Superstars):
1. Hydrating Serum
- Monthly sales: 650 units (¥129,500)
- Margin: 72%
- Rating: 4.8/5
- Returns: 3%
- Verdict: Hero product, scale inventory
2. Gentle Cleanser
- Monthly sales: 420 units (¥46,200)
- Margin: 68%
- Rating: 4.7/5
- Returns: 4%
- Verdict: Strong performer, good add-on
B-Tier (Steady Sellers):
3. Night Cream
- Monthly sales: 280 units (¥56,000)
- Margin: 70%
- Rating: 4.6/5
- Returns: 5%
- Verdict: Consistent, keep in stock
4. Vitamin C Serum
- Monthly sales: 220 units (¥57,200)
- Margin: 65%
- Rating: 4.5/5
- Returns: 8%
- Verdict: Seasonal, increase in summer
C-Tier (Underperformers):
5. Eye Cream
- Monthly sales: 80 units (¥18,400)
- Margin: 62%
- Rating: 4.2/5
- Returns: 12%
- Verdict: Consider discontinuing
Action Plan:
- Increase A-Tier inventory by 50%
- Bundle B-Tier with A-Tier
- Discontinue C-Tier after inventory sold"
3. Customer Acquisition Cost
Measure Marketing Efficiency:
CAC Metrics:
By Channel:
- Xiaohongshu organic: CAC = ¥15
- Live streams: CAC = ¥25
- Paid ads: CAC = ¥45
- Influencer partnerships: CAC = ¥35
Lifetime Value (LTV):
- Avg customer lifetime: 18 months
- Avg monthly spend: ¥120
- Total LTV: ¥2,160
LTV:CAC Ratio:
- Organic: 2,160 / 15 = 144 (excellent)
- Live stream: 2,160 / 25 = 86.4 (very good)
- Paid ads: 2,160 / 45 = 48 (good)
- Influencers: 2,160 / 35 = 61.7 (good)
Optimization:
"CAC Analysis (March 2026):
Total marketing spend: ¥25,000
New customers acquired: 850
Blended CAC: ¥29.41
Channel Performance:
Organic (Xiaohongshu):
- Spend: ¥5,000 (content creation)
- Customers: 350
- CAC: ¥14.29 ✓ (best)
Live Streams:
- Spend: ¥8,000 (host fees, platform)
- Customers: 320
- CAC: ¥25.00 ✓ (good)
Paid Ads:
- Spend: ¥7,000
- Customers: 155
- CAC: ¥45.16 (acceptable)
Influencer Partnerships:
- Spend: ¥5,000 (product + fees)
- Customers: 140
- CAC: ¥35.71 ✓ (good)
Optimization:
1. Shift budget to organic (lowest CAC)
2. Increase live stream frequency (good CAC)
3. Optimize paid ads (currently high CAC)
4. Maintain influencer partnerships
Target: Blended CAC under ¥25"
4. Return and Refund Analysis
Understand Product Issues:
Return Metrics:
Overall Return Rate:
- Target: Under 5%
- Current: 4.2% ✓ (good)
- Trend: Stable
By Product:
- Hydrating Serum: 2.8% (low)
- Night Cream: 5.0% (acceptable)
- Vitamin C Serum: 8.0% (high ⚠️)
By Reason:
- Didn't work: 45%
- Skin reaction: 25%
- Wrong product: 15%
- Damaged shipping: 10%
- Changed mind: 5%
Analysis:
"Return Rate Analysis (Q1 2026):
Total returns: 87 units
Total sales: 2,068 units
Return rate: 4.2%
Product Breakdown:
Hydrating Serum: 18 returns (2.8%)
- Reasons: Didn't work (70%), Skin reaction (30%)
- Action: Improve description, manage expectations
Night Cream: 14 returns (5.0%)
- Reasons: Didn't work (60%), Skin reaction (40%)
- Action: Add sample sizes for trial
Vitamin C Serum: 22 returns (8.0%)
- Reasons: Skin reaction (80%), Didn't work (20%)
- Action: Reformulate (lower concentration), improve patch test advice
Cost of Returns:
- Refund amount: ¥15,660
- Shipping loss: ¥2,610
- Restocking cost: ¥1,305
- Total cost: ¥19,575 (4.5% of revenue)
Reduction Strategies:
1. Better product descriptions
2. Ingredient education
3. Sample sizes for trial
4. Patch test guidance
5. Improved packaging"
5. Inventory Optimization
Balance Stock and Demand:
Inventory Metrics:
Turnover Rate:
- Fast: Under 30 days
- Healthy: 30-60 days
- Slow: 60-90 days
- Dead stock: Over 90 days
Stockout Analysis:
- Frequency: How often out of stock
- Duration: How long out of stock
- Sales lost: Revenue missed
- Customer impact: Negative reviews
Overstock Risk:
- Aging inventory
- Holding costs
- Discounting required
- Obsolescence risk
Inventory Health:
"Inventory Analysis (March 31, 2026):
Fast-Movers (under 30 days):
- Hydrating Serum: 12 days ✓
- Stock: 200 units
- Monthly sales: 650
- Days of inventory: 9
- Action: Reorder 800 units
Healthy (30-60 days):
- Gentle Cleanser: 45 days ✓
- Stock: 150 units
- Monthly sales: 420
- Days of inventory: 11
- Action: Reorder 500 units
Slow-Movers (60-90 days):
- Night Cream: 75 days ⚠️
- Stock: 120 units
- Monthly sales: 280
- Days of inventory: 13
- Action: Bundle with serum, create promo
At Risk (over 90 days):
- Eye Cream: 120 days ⚠️
- Stock: 80 units
- Monthly sales: 80
- Days of inventory: 30
- Action: 50% off sale, consider discontinuing
Stockout Impact:
- February: Out of stock 5 days
- Missed sales: 108 units (¥21,492)
- Customer complaints: 15
- Negative reviews: 3
Action Plan:
1. Increase safety stock to 15 days
2. Improve demand forecasting
3. Reduce lead times with suppliers
4. Implement pre-order for backorders"Competitor Analysis Framework:
1. Shop Performance Benchmarking
Compare E-commerce Metrics:
Competitor Selection:
Direct Competitors:
- Similar products
- Same price range
- Overlapping audience
- Comparable size
Aspirational Competitors:
- Market leaders
- Larger operations
- Best practices to learn
Benchmark Metrics:
Revenue Comparison:
- Monthly GMV
- Growth rate
- Market share
- Year-over-year
Traffic Comparison:
- Monthly visitors
- Traffic sources
- Engagement rate
- Conversion rate
Example Benchmark:
"Shop Comparison (March 2026):
Your Shop:
- Monthly GMV: ¥435,000
- Growth: +15% from Feb
- Visitors: 12,500
- Conversion: 3.8%
- AOV: ¥186
Competitor A:
- Monthly GMV: ¥620,000
- Growth: +12%
- Visitors: 18,000
- Conversion: 4.2%
- AOV: ¥178
Competitor B:
- Monthly GMV: ¥380,000
- Growth: +18%
- Visitors: 10,000
- Conversion: 4.5%
- AOV: ¥195
Analysis:
Strengths:
- Higher AOV (¥186 vs ¥178 vs ¥195)
- Solid growth (15%)
- Competitive conversion (3.8%)
Opportunities:
- Increase traffic to match Competitor A
- Improve conversion to match Competitor B
- Launch new products to increase GMV
Gap to Competitor A:
GMV gap: ¥185,000
To close gap: Need 42% more revenue
Strategy: Increase conversion to 4.5% + traffic by 20%"
2. Pricing Strategy Analysis
Monitor and React:
Price Tracking:
Competitor Price Changes:
- Product pricing
- Bundle pricing
- Discount patterns
- Sale timing
Price Matching:
- Are we priced higher?
- Can we justify premium?
- Should we match or beat?
- Value differentiation
Competitive Response:
"Price Monitoring (Weekly):
Our Hydrating Serum: ¥199
Competitor A Similar Product: ¥179
- Price difference: ¥20 (10%)
- Their ingredients: HA only
- Our ingredients: HA + ceramides + peptides
- Differentiation: Superior formulation
- Strategy: Maintain price, emphasize quality
Competitor B Similar Product: ¥189
- Price difference: ¥10 (5%)
- Their ingredients: HA + ceramides
- Our ingredients: HA + ceramides + peptides
- Differentiation: Additional peptides
- Strategy: Slight premium justified
Competitor C Similar Product: ¥249
- Price difference: -¥50 (we're lower)
- Their ingredients: HA + ceramides + vitamin C
- Our ingredients: HA + ceramides + peptides
- Differentiation: Different value prop
- Strategy: Highlight our lower price
Pricing Strategy:
- Maintain ¥199 (sweet spot)
- Emphasize ingredient quality
- Bundle for better perceived value
- Never race to bottom (price war)
Price Elasticity Test:
- Tested ¥189 (10% off) for 1 week
- Result: 30% more sales, but 22% less profit
- Conclusion: Current pricing optimizes profit"
3. Promotional Strategy Monitoring
Learn from Competitor Campaigns:
Campaign Tracking:
Promotion Types:
- Percentage discounts
- Bundle deals
- Free gifts
- Flash sales
- Holiday specials
Timing Patterns:
- When they run promotions
- Duration of promotions
- Frequency of promotions
- Response to your promotions
Campaign Analysis:
"Competitor Promotion Calendar (March 2026):
Competitor A:
- March 1-7: 20% off everything
- March 15-17: Flash sale (48 hours)
- March 25-31: Buy 2 get 1 free
- Frequency: Aggressive
Competitor B:
- March 8-14: Spring sale (15% off)
- March 22-24: Weekend deal (25% off)
- Frequency: Moderate
Competitor C:
- March 5: Single-day promo (30% off)
- March 20-22: Mini flash sale
- Frequency: Light
Our Promotions:
- March 10-12: Live stream exclusive (20% off)
- March 28-30: End of month bundle (buy 2 get 1)
- Frequency: Light (maintain brand value)
Competitive Response:
When Competitor A runs 20% off:
- Monitor our sales impact
- If significant: Run complementary promo
- If minimal: Hold price, emphasize quality
Strategy:
- Don't match every promotion
- Maintain brand premium
- Focus on value over price
- Promote during their quiet periods"
4. Product Launch Tracking
Anticipate Market Moves:
Launch Monitoring:
New Product Signals:
- Teaser content
- Influencer previews
- Countdown posts
- Patent filings
- Supplier changes
Launch Analysis:
"Competitor New Product Launch:
Competitor A Launch: March 15
Product: Vitamin C + Retinol Serum
Price: ¥229
Positioning: Anti-aging powerhouse
Pre-Launch Signals:
- March 1: Teaser posts (spotted)
- March 8: Influencer previews (5 partners)
- March 12: Countdown posts
Launch Performance:
- First week sales: ~1,200 units (estimated)
- Reviews: 4.3/5 average
- Social mentions: 850+
- Influencer posts: 45+
Our Response:
Wait and watch:
- Monitor customer feedback
- Identify product weaknesses
- Look for market gaps
Competitive Launch:
If product successful:
- Launch our own Vitamin C serum (differentiated)
- Emphasize our unique formula
- Price strategically
Timeline: May 2026 (6 weeks after their launch)
Strategy: Learn from their mistakes, improve on their weaknesses"
5. Market Share Analysis
Understand Position in Ecosystem:
Market Metrics:
Category Share:
- Skincare category: Total market size
- Our share: Percentage
- Competitor shares: Map landscape
- Growth trends
Segment Leadership:
- By price tier (budget, mid, premium)
- By concern (dry skin, anti-aging, etc.)
- By ingredient (HA, vitamin C, etc.)
- By demographic (age, location)
Market Analysis:
"Dry Skincare Category (March 2026):
Total Market Size: ¥45M monthly
Market Share:
Your Brand: ¥2.16M (4.8%) ← #5
Competitor A: ¥6.75M (15%) ← #2
Competitor B: ¥4.95M (11%) ← #3
Competitor C: ¥3.60M (8%) ← #4
Leader: ¥9.00M (20%) ← #1
Share Growth:
- Your brand: +0.6% points (from 4.2%)
- Leader: +0.3% points (from 19.7%)
- Competitor A: -0.4% points (from 15.4%)
- Competitor B: +0.2% points (from 10.8%)
Segment: Dry Skincare, ¥100-200 Price Range
Total segment: ¥18M
Your share: ¥1.8M (10%) ← #3 in segment
Growing faster than category (18% vs 12%)
Insights:
- Gaining market share (good trajectory)
- Strong in mid-tier segment
- Opportunity: Challenge #2 spot in category
- Strategy: Focus on segment leadership"Influencer Commerce Analytics:
1. Influencer Sales Performance
Measure ROI by Partner:
Sales Metrics:
Per-Influencer Tracking:
- Revenue generated
- Units sold
- Conversion rate (viewers to buyers)
- Average order value
- ROI (revenue / cost)
Engagement Quality:
- Audience match score
- Comment quality
- Follower demographics
- Authenticity rating
Performance Report:
"Influencer Commerce Performance (Q1 2026):
Top Performers:
Influencer A (25k followers):
- Partnership cost: ¥3,000
- Revenue generated: ¥27,000
- Units sold: 180
- ROI: 9.0x
- Conversion: 12.5%
- Audience match: Perfect (dry skin focus)
- Verdict: Renew, increase investment
Influencer B (50k followers):
- Partnership cost: ¥6,000
- Revenue generated: ¥42,000
- Units sold: 280
- ROI: 7.0x
- Conversion: 9.8%
- Audience match: Very good
- Verdict: Solid performer, continue
Influencer C (100k followers):
- Partnership cost: ¥12,000
- Revenue generated: ¥36,000
- Units sold: 240
- ROI: 3.0x
- Conversion: 4.2%
- Audience match: Poor (too broad)
- Verdict: Decline to renew
Influencer D (8k followers):
- Partnership cost: ¥800 (product only)
- Revenue generated: ¥9,600
- Units sold: 64
- ROI: 12.0x
- Conversion: 18.5%
- Audience match: Perfect (niche)
- Verdict: Scale up (more partners like this)
Optimal Mix:
- 60% micro-influencers (1k-10k)
- 30% mid-tier (10k-50k)
- 10% macro (50k-100k+)
- Avoid: Low ROI macro influencers"
2. Commission Structure Analysis
Optimize Affiliate Programs:
Commission Models:
Flat Rate:
- 10% commission on all sales
- Simple to understand
- Easy to track
- Works for most products
Tiered Structure:
- 10% (up to ¥5k sales)
- 12% (¥5k-15k sales)
- 15% (¥15k+ sales)
- Incentivizes performance
Product-Based:
- 8% on low-margin products
- 15% on high-margin products
- Encourages strategic promotion
Commission Analysis:
"Affiliate Program Performance:
Current Structure:
- Flat rate: 12% commission
- 50 active affiliates
- Monthly sales: ¥180,000
- Commission paid: ¥21,600
- Avg per affiliate: ¥3,600 sales
Tiered Test (March):
- 10% (under ¥5k): 35 affiliates
- 12% (¥5k-15k): 12 affiliates
- 15% (over ¥15k): 3 affiliates
Results:
- Top 3 increased effort significantly
- Sales from top 3: ¥67,500 (from ¥45k)
- Total sales: ¥198,000 (+10%)
- Commission paid: ¥24,750 (vs ¥21,600 old)
- Incremental cost: ¥3,150
- Incremental revenue: ¥18,000
- ROI on tiered: 5.7x
Decision:
- Implement tiered structure
- Motivates top performers
- Net benefit: +14,850 profit
Next optimization:
- Test product-based commissions
- Higher margin products = higher commission"
3. Live Stream Host Comparison
Find Best Sales Partners:
Host Types:
Brand Host (Founder/Employee):
- Product knowledge: Excellent
- Sales skills: Variable
- Authenticity: High
- Cost: Salary + % of sales
- Best for: Product launches, education
Professional Streamer:
- Product knowledge: Good
- Sales skills: Excellent
- Authenticity: Medium
- Cost: Flat fee + commission
- Best for: Ongoing sales, promotions
Customer/Testifier:
- Product knowledge: Personal experience
- Sales skills: Low-medium
- Authenticity: Very high
- Cost: Product + small fee
- Best for: Testimonials, social proof
Host Performance:
"Host Performance Comparison:
Host A (Brand Founder):
- Streams: 4x/month
- Avg GMV/stream: ¥85,000
- Cost: ¥15,000 (salary) + 10% commission
- Net profit: ¥61,500/stream
- ROI: 3.6x
- Strength: Expertise, authenticity
Host B (Professional Streamer):
- Streams: 8x/month
- Avg GMV/stream: ¥45,000
- Cost: ¥8,000 (flat) + 15% commission
- Net profit: ¥30,250/stream
- ROI: 2.9x
- Strength: Sales skills, frequency
Host C (Customer Testifier):
- Streams: 2x/month
- Avg GMV/stream: ¥35,000
- Cost: ¥2,000 (product + fee)
- Net profit: ¥33,000/stream
- ROI: 16.5x (!!)
- Strength: Authenticity, trust
Optimal Strategy:
- Keep Host A (expertise important)
- Reduce Host B frequency (optimize ROI)
- Scale Host C model (find more customers)
- Target: 10 customer hosts like C
Projected with 10 customer hosts:
- Each: 2x/month
- GMV: ¥35,000 × 10 × 2 = ¥700,000
- Cost: ¥2,000 × 10 × 2 = ¥40,000
- Profit: ¥660,000
- ROI: 16.5x (excellent)"
4. Co-Branded Product Analysis
Evaluate Partnership Products:
Collaboration Metrics:
Product Performance:
- Sales velocity
- Customer reception
- Return rate
- Profit margin
- Brand lift
Partnership Success:
- Revenue split (fair?)
- Marketing contribution
- Inventory management
- Communication quality
- Repeat potential
Collaboration Example:
"Co-Branded Launch:
Partner: Popular Xiaohongshu influencer
Product: 'Influencer Name x Your Brand' limited edition
Price: ¥249 (premium)
Split: 50/50 revenue share
Performance:
- Launch month sales: 800 units
- Revenue: ¥199,200
- Our share: ¥99,600
- Cost of goods: ¥40,000
- Net profit: ¥59,600
- Margin: 60% (vs 70% own products)
Marketing Contribution:
- Influencer created: 5 posts, 2 lives, 1 video
- We created: 3 posts, paid ads, email marketing
- Their reach: 250k impressions
- Our reach: 150k impressions
- Combined: 400k impressions
Customer Feedback:
- Product rating: 4.7/5
- Return rate: 6% (slightly higher)
- Repeat purchase: 22% (lower than usual)
- Acquisition: 60% new customers (good!)
Analysis:
Pros:
- New customer acquisition (60%)
- Brand exposure (400k impressions)
- Influencer authenticity (social proof)
Cons:
- Lower margin (60% vs 70%)
- Higher returns (6% vs 4%)
- Lower repeat purchase (22% vs 35%)
- Complex logistics
Verdict: Successful, repeat annually (not ongoing)"
5. Affiliate Fraud Detection
Protect Your Investment:
Fraud Signals:
Suspicious Patterns:
- Unusual spike in sales (then cancellations)
- Same customer info (fake accounts)
- High return rate from one affiliate
- Click-to-conversion ratio (too perfect)
- Coupon stacking abuse
Detection Methods:
- Manual review of suspicious orders
- IP address tracking
- Customer validation
- Return rate monitoring
- Affiliate behavior analysis
Fraud Prevention:
"Fraud Detection Case:
Red Flags Raised:
Affiliate X: New partner, strong first month
Performance:
- Month 1 sales: ¥45,000 (unusually high)
- Units: 300 units
- Orders: 120 orders (avg ¥375 each)
- Return rate: 35% (very high!)
- Customer complaints: 25 (quality issues)
Investigation:
- Analyzed customer data
- Found patterns:
* 40 orders from same 5 IP addresses
* 80 orders to same shipping address
* 25 orders with suspicious emails
- Conclusion: Fraud (fake orders to earn commission)
Action Taken:
1. Blocked affiliate from program
2. Reversed commissions (¥5,400)
3. Cancelled suspicious orders
4. Blacklisted affiliate
5. Implemented stricter verification
New Safeguards:
- Manual review of first-time affiliates
- Hold commissions for 30 days (clearing period)
- Verified customer requirement (real people)
- Minimum account age (6 months)
- Return rate monitoring (flag over 15%)
Result:
- Fraud attempts: Down 90%
- Savings: ¥8,000/month in prevented fraud
- Affiliate quality: Improved significantly"
## Common Mistakes
| Mistake | Why Happens | Fix |
|---------|-------------|-----|
| Ignoring small data sets | Focus on big numbers | Track micro-conversions (cart adds, clicks) |
| Optimizing for revenue only | Easy metric | Focus on profit margin, not just sales |
| Copying competitor pricing | Seems safe | Differentiate on value, not price |
| Overstocking best-sellers | Fear of running out | Forecast demand accurately, hold safety stock |
| Not analyzing returns | Seen as cost of business | Investigate return reasons, improve products |
| Chasing low CAC blindly | Attractive number | Balance CAC with LTV and retention |
| Ignoring seasonality | Short-term focus | Plan inventory 2-3 months ahead |
## Real-World Impact
**Case Study: Ju Mama Data-Driven Growth**
- **Before**: Guessing inventory needs, 15% stockouts, 20% overstock
- **After**: Data-driven forecasting, optimal stock levels
- **Result**: 2% stockouts, 5% overstock, 35% increase in inventory efficiency
**Data-Backed Insights**:
- Real-time live stream analytics increases sales by 25% (optimize in moment)
- Product trend data reveals opportunities 3 weeks before competitors
- Competitor pricing monitoring prevents 15% revenue loss
- Inventory optimization reduces holding costs by 40%
- Influencer ROI analysis improves partnership selection by 3x
- Seasonal planning accuracy increases to 85% (from 60%)
- Return rate analysis reduces fraud by 90%
- Data-backed pricing increases margins by 20% (without losing volume)
## Related Skills
**REQUIRED**: Use e-commerce-optimization (overall online sales strategy)
**REQUIRED**: Use data-analytics (performance tracking and insights)
**Recommended**:
- **inventory-management** (stock optimization)
- **pricing-strategy** (optimal price points)
- **live-stream-sales** (real-time selling tactics)
- **competitor-analysis** (market intelligence)