Introduction¶

E-commerce operators in China typically face a long-standing problem: operational data is scattered across the backends of Taobao/Tmall, Douyin, JD.com, and Pinduoduo, with inconsistent metrics and definitions. To view overall GMV, traffic sources, or promotion fee ratios, one often has to manually export tables, consolidate data, and create charts. By the time the charts are ready, market changes have already passed. The Skill introduced below is designed to solve this by organizing this data into a dashboard and directly providing diagnostic conclusions and actionable tasks for the week.

What is this¶

The E-commerce Operations Dashboard is a community-sourced Skill located at @user_31070f98/dashboard01, version 1.0.0, categorized under business-ops, and published by user_31070f98. It does not handle logging into backends to scrape data; instead, it integrates operational data from platforms like Taobao/Tmall (Shengyicanmou + Alimama), Douyin E-commerce (Doudian + Ocean Engine Qianchuan), JD.com, and Pinduoduo into a visualized dashboard, outputting diagnostic conclusions and action lists. The accompanying workflow is “Excel Single Source of Truth + One-Click Import for Auto-Update”: users maintain an Excel file following a fixed template, and upon import, the dashboard refreshes automatically, eliminating the need to recreate reports every time. The tag requires_api_key=false indicates that an API Key is not mandatory.

Core Features¶

The core modules of this Skill are organized around the philosophy of “View the Big Picture, Break Down Details, and Finalize Actions.” They include:

• Industry & Competitive Benchmarking: View your position within the industry and against competitors.
• GMV Secondary Breakdown: Decompose transaction volume into actionable layers.
• Traffic Funnel by Channel: Differentiate conversion performance across various traffic sources.
• Anomaly Alerts: Includes quantification of downside risks; it not only flags anomalies but also explains potential impact magnitude.
• Profit Perspective: Gross Profit + Net Profit + Promotion Fee Ratio, avoiding the pitfall of focusing solely on GMV while ignoring profit.
• Traffic Costs: CPC, UV Cost, and Return on Investment (ROI).
• Top 10 Products: Identify core products and underperformers.
• User Repurchase RFM: Analyze user segmentation and repurchase behavior.
• 30-Day Trends: Observe recent performance trajectories.
• Weekly Actions & Opportunities vs. Risks: Convert analysis into executable items.
• Data Source Collection Plan: Explains what data is needed and where to obtain it.

These modules cover common operational perspectives ranging from traffic, products, and users to profit, effectively consolidating over a dozen metrics that operators monitor daily into a single dashboard.

Installation & Activation¶

The official page scraping failed, so the following information comes from previously scraped materials and does not include installation commands. The Skill’s coordinates on SkillHub are @user_31070f98/dashboard01, source community, version 1.0.0, category business-ops. The materials do not provide specific installation commands or configuration field differences for Cursor, Codex CLI, or Claude Code. Therefore, no speculation is made here; please refer to the official page for usage details.

Typical Usage¶

The trigger mechanism for this Skill is straightforward: it activates automatically when topics related to e-commerce data appear in the conversation. Official trigger words include:

• Platforms & Tools: E-commerce data, Shengyicanmou (Business Advisor), Alimama, Zhitongche (Through Train), Wanxiangtai (Panoramic Platform), Yinli Mofang (Gravity Cube), Qianchuan.
• Operational Metrics: GMV, Conversion Rate, Average Order Value (AOV), Repurchase Rate, ROI.
• Analysis Actions: Dashboard, Operations Analysis, Store Diagnosis, Traffic Cost, Product Analysis.

For example, if a user mentions “Help me check the store’s ROI and traffic costs for this week” or “Pull up the GMV and Top 10 products for the last 30 days,” it falls within its trigger scope. The actual process follows the official workflow: first, prepare the required Excel single source of truth; second, perform a one-click import to auto-update the dashboard; then, review modules such as Anomaly Alerts, Profit Perspective, and Traffic Costs; finally, finalize the week’s actions and assess Opportunities vs. Risks.

Use Cases & Notes¶

This tool is suitable for operations personnel or small teams who need to monitor multiple domestic platforms simultaneously and wish to convert analysis results directly into action items. Its value lies in unifying data definitions and reducing manual data consolidation, rather than replacing platform backends.

There are two points to note during usage. First, it processes Excel data already collected by the user; it is not responsible for logging into platform backends to scrape data. Data collection must still follow the official data source collection plan. Second, metric definitions vary across platforms. Before importing, ensure the data source template corresponds to actual fields; otherwise, dashboard results may be biased. As the official page currently fails to scrape, dynamic information such as ratings and downloads cannot be verified. Please refer to the official page for installation and configuration details.

Conclusion¶

The E-commerce Operations Dashboard solves the problems of scattered multi-platform operational data, inconsistent definitions, and difficult implementation of conclusions. It consolidates data organization, metric breakdowns, alerts, and action lists into a single “Excel Single Source of Truth + One-Click Import” workflow, making it ideal for those who need to regularly review store operations.

Official URL: https://api.skillhub.cn/user_31070f98/dashboard01
SkillHub Page: https://www.skillhub.cn/skills/user_31070f98/dashboard01