AgentSkillsCN

data-analytics

在优化小红书内容表现、探究内容成败背后的原因、基于数据驱动制定内容策略,或追踪账号增长关键指标时使用。

SKILL.md
--- frontmatter
name: data-analytics
description: Use when needing to optimize Xiaohongshu content performance, understanding why posts succeed or fail, making data-driven decisions about content strategy, or tracking account growth metrics

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):

code
❌ "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):

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

MetricWhat It MeasuresGood BenchmarkAnalysis Tool
Views/ExposureContent reach500+ for new accountsXiaohongshu Creator Center
Engagement Rate(Likes+Comments+Shares)/Views8-12% averageExcel / Qiangua
Save RateContent value3-5% is goodCreator Center
Follower GrowthAccount growth5-10% monthlyCreator Center
Peak HoursBest posting time7-9pm for mostQiangua / 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

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

Tab 2: Weekly Summary

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

Tab 3: Audience Insights

code
| 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:

code
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

MistakeWhy HappensFix
Analyzing too frequentlyImpatienceWeekly data collection, monthly analysis
Focusing on vanity metricsViews are visibleEngagement rate and followers matter more
Not acting on insightsAnalysis paralysisCreate 3 action items from each analysis
Ignoring audience dataFocus on contentUser demographics reveal WHY content works
Comparing to mega-accountsUnrealistic benchmarksCompare 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)