skills.rest
yuyuxinli
yuyuxinliOFFICIAL
Explore all skills by this author →
GitHub

wechat-content-analytics

Parse WeChat XLS exports, compute KPIs, and generate JSON reports.

1|1|Updated Mar 29, 2026
Search Tags:#analytics#article#wechat#report#kpis#xls#pre-score
One-click install
npx skills add https://github.com/yuyuxinli/moodcoco --skill wechat-content-analytics
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: wechat-content-analytics
Source: https://github.com/yuyuxinli/moodcoco/tree/main/.claude/skills/wechat-content-analytics
Command: npx skills add https://github.com/yuyuxinli/moodcoco --skill wechat-content-analytics

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, xlrd, and includes scripts (resource) components.

## What problem does it solve? WeChat Content Analytics helps teams analyze WeChat public account article performance directly from backend XLS exports and supports pre-publish scoring for markdown articles before publishing, saving time and surfacing actionable insights.

## Core Features & Use Cases

  • Post-publish analysis: parse XLS exports, compute key KPIs, diagnose bottlenecks, and benchmark performance.
  • Pre-publish scoring: score a markdown article against controllable metrics before publishing to predict engagement and reach.
  • Cross-article trend: compare multiple articles to identify growth patterns and optimization opportunities.
  • Automated reporting: generate structured JSON reports ready for product decisions.

### Quick Start Run the pre_score.py script on your article.md to generate metrics and baseline recommendations.

Frequently Asked Questions about wechat-content-analytics

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze WeChat article performance from an XLS export?▼

WeChat article performance analytics parses backend XLS exports to extract metadata, compute derived KPIs, and diagnose post-publish bottlenecks. It generates a structured JSON report benchmarking article performance for product decisions.

Can I score a markdown article before publishing to predict WeChat engagement?▼

Pre-publish scoring applies a workflow to markdown articles to forecast quality and predict engagement reach before publishing. Running the pre_score.py script generates metrics and baseline recommendations against controllable metrics.

How do I compare multiple WeChat articles to identify growth trends?▼

Cross-article trend analysis compares multiple WeChat articles by parsing XLS exports and computing derived KPIs. This identifies growth patterns and optimization opportunities across your content to surface actionable insights.

Does this analytics workflow require pandas and xlrd to process XLS files?▼

Yes, the WeChat XLS analytics workflow requires pandas and xlrd dependencies to parse backend XLS exports. These libraries extract metadata and compute derived KPIs to satisfy the standardized reporting schema.

What is the best way to generate structured JSON reports for WeChat KPIs?▼

Automated reporting generates structured JSON reports by parsing WeChat backend XLS exports and computing key KPIs. This standardized schema output is ready for product decisions and diagnosing content bottlenecks.

Can I diagnose post-publish bottlenecks using WeChat article XLS exports?▼

Post-publish analysis diagnoses bottlenecks by parsing WeChat article XLS exports to compute key KPIs. It benchmarks performance and surfaces actionable insights to optimize future content reach and engagement.

Related Skills

Explore More Data & Analytics Skills→
bettercallfanbettercallfan

wechat-article-fetch

Extract WeChat article content and save it as Markdown files.

Community
Intermediate
guihousunguihousun

building-streamlit-dashboards

Create Streamlit dashboards with bordered KPI cards, sparklines, and sidebar filters.

Community
Intermediate
phillipganphillipgan
1

chart-image

Generate chart images from JSON data using Vega-Lite and Sharp.

Community
Intermediate
aiworkskillsaiworkskills
490

aws-wechat-article-main

Orchestrate end-to-end WeChat article production from topic to publish.

Community
Advanced