Free SKILL.md scraped from GitHub. Clone the repo or copy the file directly into your Claude Code skills directory.
npx versuz@latest install wangxuzhou666-arch-colar-agents-integrations-hermes-skills-data-analyticsgit clone https://github.com/wangxuzhou666-arch/colar-agents.gitcp colar-agents/SKILL.MD ~/.claude/skills/wangxuzhou666-arch-colar-agents-integrations-hermes-skills-data-analytics/SKILL.md---
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
version: 1.0.0
author: The Agency
metadata:
hermes:
tags: [marketing]
source: agency-agents
---
# 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)