mcpField
X
xiaohongshu-dashboard

xiaohongshu-dashboard

github.com/belljia95Data & databases565 installsUpdated 37w ago
Repository

About xiaohongshu-dashboard

xiaohongshu-dashboard is a skill that turns Xiaohongshu creator center Excel exports into a dark-mode analytics dashboard. It processes the spreadsheet and generates a responsive, single-file HTML report with charts and content analysis.

Key features

  1. 01Process creator center Excel exports
  2. 02Generate KPI cards and trend charts
  3. 03Rank notes and analyze title keywords
  4. 04Filter metrics by month
  5. 05Create responsive single-file HTML

Use cases

  1. 01Review creator account performance by month
  2. 02Compare follower growth with impressions
  3. 03Find high-performing notes and title keywords

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/belljia95/xiaohongshu-dashboard-skill --skill xiaohongshu-dashboard

After installing, type/xiaohongshu-dashboardin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

README.md
assets/
template.html
scripts/
process_excel.py

Details

From the project README

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
  1. Read assets/template.html
  2. Replace the placeholder __RAW_DATA_PLACEHOLDER__ with the JSON output from Step 2
  3. 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

Comments

Markdown supported