data-analytics

SKILL.md

Data Analytics (数据分析)

Overview

Data analytics is the systematic analysis of Xiaohongshu account and content metrics to understand performance, identify patterns, and make informed decisions that optimize growth and engagement.

When to Use

Use when:

  • Content performance is inconsistent
  • Unsure what content resonates with audience
  • Follower growth has plateaued
  • Need to validate content strategy decisions
  • Preparing content optimization plans
  • Analyzing competitor performance

Do NOT use when:

  • Just starting with no content data (wait for 5+ posts)
  • Need real-time monitoring during posting (use platform-native analytics)

Core Pattern

Before (guessing without data):

❌ "I think my audience likes fashion content"
❌ "This post should do well because I worked hard on it"
❌ "Let me try this topic and see what happens"

After (data-driven decisions):

✅ "My top 5 posts are all skincare tutorials - audience prefers educational content"
✅ "Posts published at 8pm get 3x more engagement than 2pm"
✅ "Before-and-after format averages 15% engagement vs 8% for other formats"

5 Core Metrics Framework:

  1. Exposure (浏览量) - Reach and discovery
  2. Engagement (互动率) - Likes, comments, shares
  3. Conversion (转化率) - Follows, saves, clicks
  4. Growth (粉丝增长) - New followers, unfollows
  5. Audience (用户画像) - Demographics, behavior patterns

Quick Reference

Metric What It Measures Good Benchmark Analysis Tool
Views/Exposure Content reach 500+ for new accounts Xiaohongshu Creator Center
Engagement Rate (Likes+Comments+Shares)/Views 8-12% average Excel / Qiangua
Save Rate Content value 3-5% is good Creator Center
Follower Growth Account growth 5-10% monthly Creator Center
Peak Hours Best posting time 7-9pm for most Qiangua / Huitun

Implementation

Step 1: Data Collection (Weekly)

Export data from:

  • Xiaohongshu Creator Center (native, free)

    • Account overview → Data analysis
    • Post performance → Content data
    • Audience insights → User profile
  • Qiangua Data (recommended, freemium)

    • Account analysis
    • Content performance
    • Industry benchmarks

Step 2: Build Analysis Spreadsheet

Create Excel/Google Sheets with tabs:

Tab 1: Content Performance

| Date | Title | Views | Likes | Comments | Shares | Saves | Followers | Engagement Rate |
|------|-------|-------|-------|----------|--------|-------|-----------|----------------|

Tab 2: Weekly Summary

| Week | Total Posts | Avg Views | Avg Engagement | New Followers | Top Performing Post |
|------|-------------|-----------|----------------|---------------|-------------------|

Tab 3: Audience Insights

| Date | Age Group | Gender | Location | Active Hours | Top Interests |
|------|------------|--------|----------|---------------|----------------|

Step 3: Analyze Patterns (Monthly)

Content Analysis:

  • Which topics perform best? (top 10 posts by engagement)
  • Which formats work? (image vs video vs carousel)
  • What titles drive clicks? (high CTR vs low CTR)
  • When is best posting time? (hour-by-hour breakdown)

Audience Analysis:

  • Who are your top followers? (demographics)
  • When are they most active? (hour/day patterns)
  • What content do they engage with most? (interest analysis)

Step 4: Identify Actionable Insights

Transform data into decisions:

Question → Data → Action:

Q: Why did engagement drop this week?
A: Views stable but engagement rate fell from 10% to 6%
→ Check: Content type shift? Topics changed? Timing different?
→ Action: Return to top-performing content topics next week

Q: Which content brings most followers?
A: Skincare tutorials average 12 new followers per post
→ Action: Create 3 more tutorial posts this month

Q: When should I post for maximum reach?
A: 7-9pm gets 3x more views than 2-5pm
→ Action: Schedule all posts for 7-9pm timeframe

Step 5: Apply Insights to Strategy

Update content strategy based on findings:

  • Double down on what works (top performing topics/formats)
  • Eliminate what doesn't (bottom 20% performers)
  • Test new variations inspired by successful patterns
  • Optimize posting schedule based on peak hours

Common Mistakes

Mistake Why Happens Fix
Analyzing too frequently Impatience Weekly data collection, monthly analysis
Focusing on vanity metrics Views are visible Engagement rate and followers matter more
Not acting on insights Analysis paralysis Create 3 action items from each analysis
Ignoring audience data Focus on content User demographics reveal WHY content works
Comparing to mega-accounts Unrealistic benchmarks Compare to similar-sized accounts in niche

Real-World Impact

Data-driven optimization results (real examples):

  • Account A: Posted randomly → 5x follower growth after implementing data-driven posting schedule
  • Account B: Mixed content → 3x engagement increase by focusing on top-performing topic only
  • Account C: Generic fashion → 10x save rate by shifting to "budget-friendly" angle based on audience data

Key insight: Accounts using weekly data analysis grow 3-5x faster than those posting blindly.


Related Skills:

  • REQUIRED: data-metrics-understanding (understand what each metric means)
  • REQUIRED: content-performance-analysis (analyze individual post performance)
  • REQUIRED: qiangua-data (tool for advanced analytics)
  • traffic-analysis (analyze where traffic comes from)
  • user-persona-analysis (understand your audience demographics)
Weekly Installs
8
GitHub Stars
50
First Seen
11 days ago
Installed on
opencode8
gemini-cli8
github-copilot8
codex8
kimi-cli8
amp8