excel-analytics

The saved excerpt is a snapshot from review. The external source remains the complete and most current version.

---
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
- Compari