← Back to Skills Marketplace
runkecheng

每日网销数据排名分析

by runkecheng · GitHub ↗ · v1.0.0 · MIT-0
cross-platform ⚠ suspicious
102
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install daily-screport-analysis
Description
读取收钱吧邮箱中来自 [email protected](市场邮件推送)的网销数据邮件,进行团队/个人排名分析。触发场景:(1) 用户说「网销排名」「网销数据」「团队排名」「分析排名」「邮件的排名数据」 (2) cron 定时触发的每日排名分析 (3) 用户说「今天的网销数据呢」「网销情况怎样」。用于...
README (SKILL.md)

每日网销数据排名分析

读取 [email protected] 邮箱中 [email protected](市场邮件推送)的邮件,解析并展示网销团队/个人排名数据。

依赖项

必须:已安装 imap-smtp-email-chinese skill,并在其 .env 中配置好邮箱 IMAP 连接信息:

# /workspace/skills/imap-smtp-email-chinese/.env
IMAP_HOST=imap.feishu.cn
IMAP_PORT=993
[email protected]
IMAP_PASS=\x3C邮箱专用密码>
IMAP_TLS=true

该 skill 会自动查找 imap-smtp-email-chinese 的 node_modules 和.env,无需单独安装 npm 依赖。

邮件类型

来自 [email protected](显示名:市场邮件推送)有以下邮件:

时间(BJT) 主题 内容
09:00 「网销每日数据」 团队级日/月累计统计(有效转化率、审核通过数等)
10:00-15:00(整点) 「网销开通实时数据报表」 团队主管排名表 + 全员个人排名表

分析脚本

scripts/daily-screport-analysis.js — 核心分析脚本。

运行方式

node /workspace/skills/daily-screport-analysis/scripts/daily-screport-analysis.js

输出 JSON 结构

{
  "success": true,
  "totalEmails": 10,
  "dailyTeamData": [
    { "team": "起点战队", "leader": "何启明",
      "dailyOpen": 126, "dailyValid": 36, "dailyValidRate": 0.29,
      "dailyApproved": 108, "dailyApprovedRate": 0.93,
      "monthlyOpen": 1849, "monthlyValid": 833, "monthlyValidRate": "0.45",
      "monthlyApproved": 1435, "monthlyApprovedRate": "0.96" }
  ],
  "teamAggregation": [
    { "team": "起点战队", "totalPeople": 12, "totalApproved": 50,
      "avgApproved": 4.2, "topPerson": "孙江宁", "members": [...] }
  ],
  "summary": {
    "totalTeams": 11, "totalPeople": 128, "totalApprovedSum": 290,
    "topTeams": ["起点战队(50单)", "极光战队(42单)", ...],
    "topPeople": ["王广超(飞翔, 13单)", ...],
    "zeroApproved": 56,
    "dailyTotalApproved": 2398, "monthlyTotalApproved": 35672
  }
}

分析维度

  1. 团队主管排名:团队+主管的审核通过数排名
  2. 全员个人排名:按审核通过数降序排列
  3. 团队聚合统计:人均审核通过数、团队人数、Top成员
  4. 新人追踪:识别2026届新人(名单参考 MEMORY.md)表现
  5. 零单人员:审核通过数为0的人员统计

报告格式

按以下结构输出结果给用户:

📊 网销团队/个人排名日报 | {日期}

▎团队排名Top5(审核通过数)
🥇 {团队名} — {n}单({主管})
...

▎个人排名Top10
1️⃣ {姓名(团队)}{n}单
...

▎团队人均审核通过数
🥇 {团队名} — {n}单/人
...

▎2026新人表现突出
🌟 {姓名(团队)}{n}单
⚪ 零单新人需关注:...

▎月度累计
🗓 全团队月累计:**{n}单**

配置要求

  1. IMAP 邮箱连接(在 imap-smtp-email-chinese/.env 中配置)
  2. Standing Orders(写入 AGENTS.md):授权自动执行
  3. Cron 定时任务(工作日 09:35 BJT):自动触发
Usage Guidance
Before installing, confirm that this skill should access the configured shouqianba mailbox, fix TLS certificate verification, and avoid enabling cron or AGENTS.md standing orders until the credential requirement and automatic-access scope are clearly documented.
Capability Analysis
Type: OpenClaw Skill Name: daily-screport-analysis Version: 1.0.0 The skill is designed to analyze sales report emails but exhibits risky security practices and potential vulnerabilities. The script `scripts/daily-screport-analysis.js` disables TLS certificate verification (`rejectUnauthorized: false`), which exposes the IMAP connection to man-in-the-middle (MITM) attacks. Furthermore, the script performs cross-skill file access by traversing directories to read sensitive credentials from a `.env` file belonging to a different skill (`/workspace/skills/imap-smtp-email-chinese/.env`). While these behaviors appear intended to facilitate the stated functionality for 'shouqianba.com' reports, they constitute significant security flaws and risky credential handling.
Capability Assessment
Purpose & Capability
The stated purpose and visible code are coherent: the skill connects to an IMAP mailbox, searches for [email protected] emails, parses ranking tables, and outputs team/person ranking data. This is still sensitive business and employee-performance email data.
Instruction Scope
The instructions disclose cron/standing-order automatic execution for daily reports. That is purpose-aligned, but users should understand it may read the mailbox without a fresh prompt each workday.
Install Mechanism
There is no install spec, while package.json lists dependencies and the script can reuse another skill’s node_modules. This is disclosed but creates a dependency/provenance review point.
Credentials
The registry metadata declares no required env vars, primary credential, or config path, but the skill reads IMAP_USER/IMAP_PASS from a local .env and connects to a mailbox. The code also disables TLS certificate verification for that credentialed IMAP connection.
Persistence & Privilege
SKILL.md asks for Standing Orders in AGENTS.md and a cron trigger. No code in the visible artifact installs persistence itself, but users should only enable these if recurring automatic mailbox access is intended.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install daily-screport-analysis
  3. After installation, invoke the skill by name or use /daily-screport-analysis
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
初始版本:读取 [email protected] 邮件进行团队/个人排名分析并推送到飞书
Metadata
Slug daily-screport-analysis
Version 1.0.0
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 1
Frequently Asked Questions

What is 每日网销数据排名分析?

读取收钱吧邮箱中来自 [email protected](市场邮件推送)的网销数据邮件,进行团队/个人排名分析。触发场景:(1) 用户说「网销排名」「网销数据」「团队排名」「分析排名」「邮件的排名数据」 (2) cron 定时触发的每日排名分析 (3) 用户说「今天的网销数据呢」「网销情况怎样」。用于... It is an AI Agent Skill for Claude Code / OpenClaw, with 102 downloads so far.

How do I install 每日网销数据排名分析?

Run "/install daily-screport-analysis" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is 每日网销数据排名分析 free?

Yes, 每日网销数据排名分析 is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does 每日网销数据排名分析 support?

每日网销数据排名分析 is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created 每日网销数据排名分析?

It is built and maintained by runkecheng (@runkecheng); the current version is v1.0.0.

💬 Comments