Excel Analytics

If you're tracking Xiaohongshu performance and need custom analysis beyond what the platform gives you, this walks through building Excel spreadsheets that actually work. It covers the full workflow from importing data exports to setting up pivot tables, calculating engagement rates with formulas, and creating reusable dashboards. The spreadsheet architecture is solid: separate sheets for raw data, content logs, competitor tracking, and visualizations. You get specific formulas for metrics like week-over-week growth and moving averages, plus conditional formatting rules to highlight what matters. Best for manual or semi-automated analysis when you need flexibility. Skip it if you need real-time monitoring or have access to proper BI tools.

Install to Claude Code

npx -y skills add vivy-yi/xiaohongshu-skills --skill excel-analytics --agent claude-code