← 返回 Skills 市场
164
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install ticket-stats
功能描述
企业内部咨询工单统计分析。用于处理Excel格式的工单数据，统计每日接收工单数量、处理完成数量、未及时回复数量，并根据关键词自动归类到功能模块（订单交易、经营数据、门店设置、账号管理、商品管理、营销活动、顾客评价），生成带可视化图表的每日摘要报告。
安全使用建议
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.
功能分析
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.
能力评估
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.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install ticket-stats - 安装完成后，直接呼叫该 Skill 的名称或使用
/ticket-stats触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
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.
元数据
常见问题
Ticket Stats 是什么？
企业内部咨询工单统计分析。用于处理Excel格式的工单数据，统计每日接收工单数量、处理完成数量、未及时回复数量，并根据关键词自动归类到功能模块（订单交易、经营数据、门店设置、账号管理、商品管理、营销活动、顾客评价），生成带可视化图表的每日摘要报告。 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 164 次。
如何安装 Ticket Stats？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install ticket-stats」即可一键安装，无需额外配置。
Ticket Stats 是免费的吗？
是的，Ticket Stats 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
Ticket Stats 支持哪些平台？
Ticket Stats 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 Ticket Stats？
由 FlankCat（@flankcat）开发并维护，当前版本 v1.0.0。
推荐 Skills