← Back to Skills Marketplace
164
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install ticket-stats
Description
企业内部咨询工单统计分析。用于处理Excel格式的工单数据，统计每日接收工单数量、处理完成数量、未及时回复数量，并根据关键词自动归类到功能模块（订单交易、经营数据、门店设置、账号管理、商品管理、营销活动、顾客评价），生成带可视化图表的每日摘要报告。
Usage Guidance
This appears coherent and limited in scope, but take normal precautions: run the script in an isolated environment (virtualenv/container), review the script yourself if you can, and ensure the input files do not contain secrets you don't want written to disk. Install required Python packages (pandas, openpyxl, matplotlib) from official sources before use. The script writes chart image files to the working directory and does not perform network I/O or request credentials.
Capability Analysis
Type: OpenClaw Skill
Name: ticket-stats
Version: 1.0.0
The skill is a legitimate tool for analyzing enterprise ticket data from Excel or CSV files. The core logic in `scripts/analyze_tickets.py` uses standard data science libraries (pandas, matplotlib) to categorize tickets by keywords, calculate response metrics, and generate visual reports. There is no evidence of data exfiltration, unauthorized network access, or malicious instructions in the documentation.
Capability Assessment
Purpose & Capability
Name/description (ticket statistics and classification) align with the included script and SKILL.md. The script reads Excel/CSV, classifies by keywords, computes metrics, and generates charts — all expected for this purpose.
Instruction Scope
Runtime instructions limit actions to reading a provided Excel/CSV file, local processing with pandas, and optional local chart output. There are no instructions to read unrelated system files, environment variables, or to send data externally.
Install Mechanism
Instruction-only skill with a Python script; no install spec or remote downloads. It relies on standard Python packages (pandas, openpyxl, matplotlib) which the user must install — no high-risk install URLs or archive extraction present.
Credentials
The skill does not request any environment variables, credentials, or config paths. The resources it needs (local Excel/CSV files and optional Python libs) are proportionate to its function.
Persistence & Privilege
always is false and the skill does not modify agent/system configurations. It runs only when invoked and does not request elevated or persistent privileges.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install ticket-stats - After installation, invoke the skill by name or use
/ticket-stats - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release of the ticket-stats skill:
- Analyze internal support ticket data from Excel files, including daily counts for received, resolved, and late-response tickets.
- Automatically categorize tickets into key business modules using keyword matching.
- Generate daily summary reports featuring key metrics, pie charts, trend graphs, and keyword frequency visualization.
- Provide example scripts and usage instructions for easy deployment.
Metadata
Frequently Asked Questions
What is Ticket Stats?
企业内部咨询工单统计分析。用于处理Excel格式的工单数据，统计每日接收工单数量、处理完成数量、未及时回复数量，并根据关键词自动归类到功能模块（订单交易、经营数据、门店设置、账号管理、商品管理、营销活动、顾客评价），生成带可视化图表的每日摘要报告。 It is an AI Agent Skill for Claude Code / OpenClaw, with 164 downloads so far.
How do I install Ticket Stats?
Run "/install ticket-stats" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Ticket Stats free?
Yes, Ticket Stats is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does Ticket Stats support?
Ticket Stats is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Ticket Stats?
It is built and maintained by FlankCat (@flankcat); the current version is v1.0.0.
More Skills