/excel-analytics

name: excel-analytics
description: Use when analyzing Xiaohongshu data with Excel, creating spreadsheets for performance tracking, building data dashboards, conducting manual analysis, or learning spreadsheet skills for social media analytics

Excel Analytics (Excel数据分析)

Overview

Excel analytics is the systematic use of spreadsheet software to organize, analyze, visualize, and report on Xiaohongshu performance data, enabling custom analysis, flexible reporting, and data-driven insights without requiring specialized analytics tools.

When to Use

**Use when**:

• Building custom tracking spreadsheets for Xiaohongshu data
• Analyzing exported data from platform analytics
• Creating personalized dashboards and reports
• Conducting custom calculations and metrics
• Visualizing performance trends and patterns
• Learning data analysis fundamentals
• Comparing multiple time periods or content types
• Creating executive summaries for stakeholders

**Do NOT use when**:

• Real-time monitoring needed (use platform analytics)
• Complex statistical analysis required (use specialized tools)
• Automated reporting at scale (use BI tools)
• Simple quick checks (use platform native analytics)

Core Pattern

**Before** (manual, scattered, inefficient):

❌ "Data scattered across screenshots and exports"
❌ "Manual calculator for engagement rates"
❌ "No visual trends, just numbers in cells"
❌ "Recreating same reports from scratch every week"

**After** (organized, automated, insightful):

✅ "All data in one structured master spreadsheet"
✅ "Automatic calculations update when data changes"
✅ "Interactive charts show trends at glance"
✅ "Reusable dashboard template saves hours weekly"

**Excel Analytics Workflow**: 1. **Import** - Bring data from Xiaohongshu into Excel 2. **Clean** - Structure and format data properly 3. **Calculate** - Create metrics and KPIs with formulas 4. **Visualize** - Build charts and dashboards 5. **Analyze** - Extract insights and identify patterns 6. **Report** - Summarize findings for decision-making

Quick Reference

| Excel Feature | Use Case | Complexity | Time Saved | |---------------|----------|------------|-------------| | **Pivot Tables** | Summarize large datasets | Medium | 2-3 hours/week | | **VLOOKUP/XLOOKUP** | Match data across sheets | Medium | 1-2 hours/week | | **Charts** | Visualize trends | Simple | 1 hour/week | | **Conditional Formatting** | Highlight insights | Simple | 30 min/week | | **Formulas** | Calculate metrics | Medium | 2-3 hours/week | | **Macros** | Automate repetitive tasks | Advanced | 5+ hours/week |

Implementation

Step 1: Set Up Master Spreadsheet

**Spreadsheet Architecture**:

Workbook Structure (Separate Sheets/Tabs):

Sheet 1: README
- Purpose of spreadsheet
- How to use guide
- Definitions of metrics
- Contact for questions

Sheet 2: Raw Data Import
- Direct export from Xiaohongshu
- Date stamps for each import
- Raw, unmanipulated data
- Historical archive

Sheet 3: Content Performance Log
- One row per post
- Columns: Date, Content Type, Topic, Reach, Impressions, Likes, Comments, Shares, Saves, Engagement Rate
- Ongoing manual or automated entry

Sheet 4: Follower Growth Tracker
- Daily/weekly follower counts
- Growth rate calculations
- Follower acquisition sources
- Churn tracking

Sheet 5: Key Metrics Dashboard
- Executive summary
- Top-level KPIs
- Traffic light indicators (Green/Yellow/Red)
- Trend visualizations

Sheet 6: Content Analysis
- Performance by content type
- Performance by topic
- Top/bottom performing posts
- A/B test results

Sheet 7: Time Analysis
- Performance by day of week
- Performance by time of day
- Seasonal patterns
- Best posting times

Sheet 8: Competitor Tracking
- Competitor metrics
- Comparative analysis
- Market share
- Benchmarking

Sheet 9: Goals and Targets
- Target metrics by period
- Progress vs goals
- Gap analysis
- Forecasting

Sheet 10: Charts and Visualizations
- Trend charts
- Comparison charts
- Distribution charts
- Custom dashboards

**Data Dictionary (Column Definitions)**:

Essential Columns for Content Log:

A: Date (YYYY-MM-DD format)
B: Content_ID (Unique identifier)
C: Content_Type (Post, Video, Story, Live)
D: Topic (Primary theme/category)
E: Title (Post title or description)
F: Publish_Time (HH:MM format)
G: Day_of_Week (Monday-Sunday)
H: Reach (Unique users who saw content)
I: Impressions (Total displays)
J: Likes (❤️ reactions)
K: Comments (💬 responses)
L: Shares (📤 forwards)
M: Saves (📑 bookmarks)
N: Profile_Visits (👁️ profile clicks)
O: Follows_Gained (📈 new followers from post)
P: Engagement_Rate (Calculated)
Q: CTR (Click-through rate if applicable)
R: Conversion_Signups (Email, purchase, etc.)
S: Cost (If paid promotion)
T: Notes (Campaign context, etc.)

Optional Advanced Columns:
U: Hashtag_1, Hashtag_2, Hashtag_3
V: Product_Mentioned
W: Promo_Code_Used
X: A/B_Test_Variant
Y: Season (Spring/Summer/Fall/Winter)
Z: Campaign_Name

Step 2: Import and Clean Data

**Data Import Methods**:

Method 1: Manual Entry
Best for: Small accounts, <50 posts/week
Process:
- Create template with required columns
- Manual entry from Xiaohongshu analytics
- Time required: 30-60 minutes/week

Pros: Complete control, no technical skill needed
Cons: Time-consuming, human error risk

Method 2: Export and Import
Best for: Medium accounts, 50-200 posts/week
Process:
- Export from Xiaohongshu Pro analytics
- Download CSV file
- Import into Excel
- Map columns to your structure

Steps:
1. Xiaohongshu Pro → Analytics → Content Performance
2. Select date range
3. Export as CSV
4. Excel → Data → From Text/CSV
5. Select file and import
6. Transform data to match your structure

Pros: Faster, less error-prone
Cons: Requires export capability, some cleanup needed

Method 3: API Integration (Advanced)
Best for: Large accounts, 200+ posts/week
Process:
- Use Xiaohongshu API (if available)
- Connect Excel to API (Power Query)
- Automate