| name | content-performance-analysis |
| description | Use when evaluating individual Xiaohongshu post performance, identifying what makes content succeed or fail, extracting viral content patterns, recognizing underperforming content that needs optimization, or comparing performance across different content types and formats |
Content Performance Analysis (内容效果分析)
Overview
Content performance analysis is the systematic evaluation of individual posts and overall content portfolio to identify success patterns, understand what resonates with the audience, and make data-driven decisions about content strategy.
When to Use
Use when:
- Post performance is inconsistent or unpredictable
- Need to understand why certain content went viral
- Identifying patterns in top-performing content
- Recognizing underperforming content that needs improvement
- Comparing different content formats (carousel vs video vs single image)
- Deciding which content types to focus on
- Planning content optimization based on past performance
Do NOT use when:
- Account has fewer than 5 published posts (insufficient data)
- Looking for real-time performance during first hours (wait 3-7 days)
- Analyzing paid advertising performance (use ad analytics tools)
Core Pattern
Before (guessing what works):
❌ "This post should do well, I worked hard on it"
❌ "I don't know why this post went viral, lucky I guess"
❌ "All my content is pretty similar, performance is random"
After (data-driven content insights):
✅ "Top 5 posts all use carousel format with before/after structure"
✅ "Posts with question titles get 2.3x more comments than statement titles"
✅ "Video content underperforms images - shift strategy to graphic content"
✅ "Posts published on Tuesday outperform Sunday by 40%"
3 Analysis Dimensions Framework:
- Engagement Data - Likes, comments, shares, saves (audience response)
- Growth Data - New followers, profile visits (conversion impact)
- Viral Data - Exposure, discovery traffic (reach and algorithm favor)
Quick Reference
| Metric | What It Reveals | Good Benchmark | Analysis Method |
|---|
| Engagement Rate | Content resonance | 8-12% average | (Likes+Comments+Shares+Saves)÷Views×100 |
| Save Rate | Content value/reuse | 3-5% is good | Saves÷Views×100 |
| Comment Rate | Discussion spark | 2-4% average | Comments÷Views×100 |
| Follower Conversion | Content converts to fans | 1-3% | New Followers÷Views×100 |
| Viral Score | Algorithm favor | Views÷Followers | >10 = viral hit |
Implementation
Step 1: Collect Post Performance Data
From Xiaohongshu Creator Center:
- Open Creator Center → 内容数据
- Select time range (last 30 days recommended)
- Export or manually record data for each post:
- Title
- Content type (image/video/carousel)
- Publish date/time
- Views (浏览量)
- Likes (点赞数)
- Comments (评论数)
- Shares (转发数)
- Saves (收藏数)
- New followers gained
From Qiangua Data (recommended for efficiency):
- Account analysis → Content performance
- Export all posts with metrics to Excel
- Sort by different metrics to identify patterns
Step 2: Calculate Key Performance Indicators
For each post, calculate:
Engagement Rate:
Engagement Rate = (Likes + Comments + Shares + Saves) ÷ Views × 100
- Excellent: >15%
- Good: 8-15%
- Average: 5-8%
- Below Average: <5%
Save Rate (content value):
Save Rate = Saves ÷ Views × 100
- Excellent: >7%
- Good: 4-7%
- Average: 2-4%
- Low: <2%
Comment Rate (engagement depth):
Comment Rate = Comments ÷ Views × 100
- Excellent: >5%
- Good: 3-5%
- Average: 1-3%
- Low: <1%
Viral Score:
Viral Score = Views ÷ Follower Count
- Viral Hit: >10 (reached 10x beyond existing audience)
- Strong Performance: 5-10
- Expected Performance: 1-5
- Underperforming: <1
Step 3: Identify Top and Bottom Performing Content
Top Performers (analyze last 10-20 posts):
- Sort by Engagement Rate - Find top 5
- Sort by Viral Score - Find top 5
- Sort by Save Rate - Find top 5
Bottom Performers:
- Sort by Engagement Rate - Find bottom 5
- Identify posts with Viral Score <1 (underperformed existing audience)
Step 4: Extract Success Patterns from Top Content
Analyze top 5 posts for common patterns:
Content Format Patterns:
- Single image vs carousel vs video
- Carousel slide count (3-5 slides optimal)
- Video length (under 60 seconds optimal)
Content Structure Patterns:
- Hook/intro style (question, statement, before/after)
- Main content organization (list, tutorial, story, comparison)
- Call-to-action presence and type
Title Patterns:
- Question vs statement
- Length (short vs long)
- Keyword usage
- Emotional triggers (curiosity, urgency, benefit)
Visual Patterns:
- Cover design style
- Color scheme
- Text overlay presence
- Face presence vs product-only
Topic Patterns:
- Content category (educational, entertainment, inspiration)
- Specific subtopics
- Target audience segment
Timing Patterns:
- Day of week
- Time of day
- Seasonal relevance
Document findings:
Pattern: Carousel format
- Frequency in top 5: 4/5 posts (80%)
- Average engagement: 14.2%
- Common structure: Before/after transformation
Pattern: Question-based titles
- Frequency in top 5: 3/5 posts (60%)
- Average engagement: 13.8%
- Comment rate: 4.1% (above average)
Step 5: Diagnose Underperforming Content
For bottom 5 posts, analyze:
Content Quality Issues:
- Low production value (poor images, bad lighting)
- Unclear value proposition
- Weak or confusing message
- Inadequate detail or depth
Content Format Issues:
- Suboptimal format for topic (e.g., complex topic in single image)
- Wrong carousel length (too short or too long)
- Video length issues (too long, boring intro)
Title and Cover Issues:
- Uncompelling cover (low CTR)
- Confusing or unappealing title
- Mismatch between title and content
- Lack of keywords for search
Targeting Issues:
- Content too broad/narrow for audience
- Off-brand or irrelevant to niche
- Missing audience pain point
Timing Issues:
- Posted at low-traffic times
- Competing with major events/holidays
- Seasonal mismatch
Create improvement plan for each underperforming post type:
Issue: Low CTR on single-image posts
Diagnosis: Covers lack visual hook, text-only, no face
Fix: Add face, use before/after format, bold overlay text
Test: Create 3 new posts with improved covers, measure CTR improvement
Step 6: Build Content Performance Matrix
Create a matrix to visualize performance by content type:
Content Type | Avg Engagement | Avg Viral Score | Post Count | Verdict
-------------|----------------|-----------------|------------|--------
Carousel | 12.4% | 6.2 | 8 | ⭐⭐⭐ Primary
Video | 7.8% | 3.1 | 5 | ⭐⭐ Secondary
Single Image | 9.2% | 4.5 | 7 | ⭐⭐ Secondary
Strategy decisions:
- Primary format (⭐⭐⭐): Use for 60-70% of content
- Secondary format (⭐⭐): Use for 20-30% of content
- Deprecated format: Phase out or significantly improve
Step 7: Develop Replicable Content Formulas
Based on top performers, create 3-5 proven content formulas:
Formula 1: Problem-Solution Tutorial
- Format: 5-slide carousel
- Title: Question-based ("Struggling with X?")
- Structure: Problem → Solution → Step-by-step → Result → CTA
- Performance: 14.2% engagement, 8.3 viral score
- Best for: Educational content, how-to topics
Formula 2: Before-After Transformation
- Format: 3-slide carousel
- Title: Benefit-driven ("How I achieved X in Y days")
- Structure: Before → Process → After
- Performance: 15.8% engagement, 12.1 viral score
- Best for: Transformation topics, results showcase
Formula 3: List-Based Tips
- Format: 4-6 slide carousel
- Title: Number-based ("7 tips for X")
- Structure: Hook → 7 tips (1 per slide) → Summary → CTA
- Performance: 11.3% engagement, 5.7 viral score
- Best for: Tips sharing, quick value content
Use formulas to:
- Plan content calendar
- Maintain consistency
- Scale content production
- Predict performance
Step 8: Track Performance Trends Over Time
Build weekly content performance log:
Week | Posts | Avg Engagement | Top Format | Viral Hits | Insights
-----|-------|----------------|------------|------------|----------
W1 | 4 | 9.2% | Carousel | 1 | Carousels outperforming
W2 | 5 | 10.5% | Video | 2 | Video improvement working
W3 | 3 | 12.8% | Carousel | 1 | Question titles boosting comments
Trend analysis:
- Engagement rate rising? Content strategy is working
- Certain formats consistently winning? Double down
- Viral hits increasing? Algorithm favor improving
- Specific topics always perform well? Create series
Common Mistakes
| Mistake | Why Happens | Fix |
|---|
| Judging content by views only | Views are vanity metric | Focus on engagement rate and saves - they indicate true resonance |
| Analyzing posts too soon (first 24 hours) | Early data is misleading | Wait 3-7 days for post to fully perform before analyzing |
| Comparing posts with different audience sizes | Unfair comparison | Use engagement rate % not raw numbers for fair comparison |
| Ignoring outlier posts (viral hits) | Assume they're flukes | Deep analyze viral hits - they contain valuable insights |
| Changing strategy too frequently | Impatience with slow growth | Collect data from 10+ posts before changing strategy |
| Focusing on averages only | Averages hide patterns | Look at top/bottom 20% to extract winning/losing patterns |
| Not tracking by content format | Miss format-specific insights | Always analyze by format (carousel vs video vs single) |
| Ignoring save rate | Saves predict long-term success | High save rate = evergreen content that drives ongoing traffic |
| Over-optimizing for one metric | Unbalanced strategy | Balance engagement (likes) with value (saves) and growth (followers) |
| Not documenting success formulas | Reinventing the wheel | Create 3-5 proven formulas, reuse consistently |
Real-World Impact
Case Study: Fashion Account Turnaround
- Before: 6.8% average engagement, unpredictable performance, no clear content direction
- Analysis: Discovered carousels with before/after structure averaged 14.5% engagement vs 5.2% for single images
- Action: Shifted 80% of content to carousel format using proven formulas
- After 30 days: 11.2% average engagement (+65%), follower growth rate doubled, 3 viral hits
- Key insight: Content format matters more than production quality
Data-Backed Insights:
- Accounts that document and reuse content formulas grow 3x faster
- Posts following proven formats outperform experimental content 70% of the time
- High-save content (>7% save rate) continues getting views for 30+ days
- Top-performing content often follows 1 of 5 predictable structures
- Analyzing bottom performers reveals as much as analyzing top performers
Related Skills
REQUIRED: Use data-analytics (overall data analysis framework)
REQUIRED: Use data-metrics-understanding (understand metrics)
Recommended for deeper analysis:
- traffic-analysis - Analyze which traffic sources drive best content performance
- content-planning - Apply insights to plan future content
- viral-strategy - Optimize content for viral potential
Use content-performance-analysis BEFORE:
- content-planning (align plan with proven content formulas)
- cover-design (design covers based on top-performing patterns)
- title-writing (write titles using successful patterns)
- graphic-content-creation / short-video-production (create content in winning formats)
Skills that provide context:
- account-positioning (ensure content aligns with positioning)
- persona-building (maintain consistent voice across content)
