How do I install the Xiaohongshu Dashboard skill?

Run npx skillmds@latest add belljia95/xiaohongshu-dashboard in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Xiaohongshu Dashboard safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Xiaohongshu Dashboard?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Xiaohongshu Dashboard free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Xiaohongshu Dashboard?

belljia95 (@belljia95) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Xiaohongshu Dashboard by belljia95 — Agent Skill

Name: Xiaohongshu Dashboard
Author: belljia95

Xiaohongshu Dashboard

Generate a beautiful dark-mode analytics dashboard for Xiaohongshu (Little Red Book / RED) creator data. Use when the user wants to: (1) create a data dashboard for their Xiaohongshu account, (2) visualize their Xiaohongshu/RED post performance data, (3) analyze their content metrics including impressions, CTR, likes, followers, keyword analysis, etc. Triggers on mentions of "xiaohongshu dashboard", "xiaohongshu analytics", "RED analytics", or similar requests in Chinese like "xiaohongshu kanban", "xiaohongshu shuju fenxi".

belljia95 Updated Sep 17, 2026

File contents

Xiaohongshu Dashboard Skill

Generate a tech-minimalist dark-mode analytics dashboard from Xiaohongshu creator center Excel exports.

Output

A single index.html file containing:

5 KPI metric cards (impressions, CTR, interactions, utility ratio, follower gain)
North Star trend chart (impressions vs followers over time)
Follower growth trend (cumulative + daily bar)
Follower conversion efficiency Top 10 (followers per 1K impressions)
Note ranking list with tabs (by impressions / interactions / followers)
Title keyword analysis (high-engagement + high-conversion keywords)
Date range filter (month picker)
Fully responsive (desktop / iPad / iPhone)

Tech stack: vanilla HTML/CSS/JS + Chart.js CDN. No build tools needed.

Workflow

Step 1: Collect the Excel file

Ask the user to provide their Xiaohongshu creator center data export Excel file (.xlsx).

The Excel typically contains columns like:

Title / Content title
Publish date
Content type (image-text / video)
Impressions / Views / CTR
Likes / Comments / Collects / Shares
Follower gain
Average view time

Step 2: Process the data

Run scripts/process_excel.py to read the Excel and output a JSON data blob.

python scripts/process_excel.py <path-to-excel-file>

The script handles:

Flexible column name matching (different Xiaohongshu export versions use different names)
Date parsing and month extraction
CTR normalization (percentage vs decimal)
Chinese keyword n-gram analysis for title keywords
Outputs JSON to stdout

If pandas/openpyxl are not installed, install them first:

pip install pandas openpyxl

Step 3: Generate the dashboard

Read assets/template.html
Replace the placeholder __RAW_DATA_PLACEHOLDER__ with the JSON output from Step 2
Write the result as index.html in the user's chosen output directory

Step 4: Open for preview

Open the generated index.html in the user's default browser so they can preview it immediately.

Design Specs

Theme: Tech-minimalist dark mode (inspired by Linear/Vercel/Raycast)
Background: zinc-950 (#09090b) with subtle grid pattern
Cards: Glass-morphism with backdrop-filter blur
Accent: Neon red (#FF4D6D) for primary metrics, neon green (#10B981) for growth metrics
Fonts: Inter (sans) + JetBrains Mono (mono) from Google Fonts CDN
Charts: Chart.js with gradient fills, custom tooltips, monospace axis labels

Customization

If the user wants to customize the dashboard:

Colors: Modify CSS variables in :root
Metrics: Add/remove metric cards in the metrics-grid section
Charts: Modify Chart.js config in the <script> section

---name: xiaohongshu-dashboarddescription: Generate a beautiful dark-mode analytics dashboard for Xiaohongshu (Little Red Book / RED) creator data. Use when the user wants to: (1) create a data dashboard for their Xiaohongshu account, (2) visualize their Xiaohongshu/RED post performance data, (3) analyze their content metrics including impressions, CTR, likes, followers, keyword analysis, etc. Triggers on mentions of "xiaohongshu dashboard", "xiaohongshu analytics", "RED analytics", or similar requests in Chinese like "xiaohongshu kanban", "xiaohongshu shuju fenxi".---# Xiaohongshu Dashboard SkillGenerate a tech-minimalist dark-mode analytics dashboard from Xiaohongshu creator center Excel exports.## OutputA single `index.html` file containing:- 5 KPI metric cards (impressions, CTR, interactions, utility ratio, follower gain)- North Star trend chart (impressions vs followers over time)- Follower growth trend (cumulative + daily bar)- Follower conversion efficiency Top 10 (followers per 1K impressions)- Note ranking list with tabs (by impressions / interactions / followers)- Title keyword analysis (high-engagement + high-conversion keywords)- Date range filter (month picker)- Fully responsive (desktop / iPad / iPhone)Tech stack: vanilla HTML/CSS/JS + Chart.js CDN. No build tools needed.## Workflow### Step 1: Collect the Excel fileAsk the user to provide their Xiaohongshu creator center data export Excel file (.xlsx).The Excel typically contains columns like:- Title / Content title- Publish date- Content type (image-text / video)- Impressions / Views / CTR- Likes / Comments / Collects / Shares- Follower gain- Average view time### Step 2: Process the dataRun `scripts/process_excel.py` to read the Excel and output a JSON data blob.```bashpython scripts/process_excel.py <path-to-excel-file>```The script handles:- Flexible column name matching (different Xiaohongshu export versions use different names)- Date parsing and month extraction- CTR normalization (percentage vs decimal)- Chinese keyword n-gram analysis for title keywords- Outputs JSON to stdoutIf pandas/openpyxl are not installed, install them first:```bashpip install pandas openpyxl```### Step 3: Generate the dashboard1. Read `assets/template.html`2. Replace the placeholder `__RAW_DATA_PLACEHOLDER__` with the JSON output from Step 23. Write the result as `index.html` in the user's chosen output directory### Step 4: Open for previewOpen the generated `index.html` in the user's default browser so they can preview it immediately.## Design Specs- **Theme**: Tech-minimalist dark mode (inspired by Linear/Vercel/Raycast)- **Background**: zinc-950 (#09090b) with subtle grid pattern- **Cards**: Glass-morphism with backdrop-filter blur- **Accent**: Neon red (#FF4D6D) for primary metrics, neon green (#10B981) for growth metrics- **Fonts**: Inter (sans) + JetBrains Mono (mono) from Google Fonts CDN- **Charts**: Chart.js with gradient fills, custom tooltips, monospace axis labels## CustomizationIf the user wants to customize the dashboard:- **Colors**: Modify CSS variables in `:root`- **Metrics**: Add/remove metric cards in the metrics-grid section- **Charts**: Modify Chart.js config in the `<script>` section

Frequently asked questions