weekly-crm-report
Cleans a weekly CRM export and produces a regional sales summary. Activates when the user asks to clean a CRM export, deduplicate sales rows, calculate regional totals, or generate a weekly sales report from a CSV.
- License 许可
- MIT
- 最近更新
- 2026-11-02
- Stars
- ★ 0
- Forks
- 1
01 前言 Front Matter
- name
- weekly-crm-report
- license
- MIT
- metadata
- { "author": "agent-skill-creator", "version": "1.0.0" }
- description
- Cleans a weekly CRM export and produces a regional sales summary. Activates when the user asks to clean a CRM export, deduplicate sales rows, calculate regional totals, or generate a weekly sales report from a CSV.
02 资源文件 7
- 资产文件evals/golden/case-1/input.csv62 B
- 资产文件evals/golden/case-2/input.csv46 B
- 资产文件evals/golden/case-3/input.csv39 B
- 参考文档evals/weekly-crm-report.eval.md1.8 KB
- 参考文档README.md1.5 KB
- 脚本scripts/run_evals.py16.6 KB
- 脚本scripts/run_pipeline.py2.3 KB
03 SKILL.md 正文
Weekly CRM Report
Turn a raw weekly CRM export (CSV) into a clean regional sales summary: drop duplicate rows, total revenue per region, and emit a structured JSON summary an agent can narrate or hand to a PDF/dashboard step.
This is a bundled example skill — small but real, and used to demonstrate the creator's validation, pipeline, and eval-rollout machinery end to end.
Activation
Activates on requests like "clean this CRM export", "weekly sales report", "regional totals from this CSV". Do not activate on general spreadsheet or analytics questions that don't involve a CRM export.
Input
A CSV with at least region and amount columns (extra columns are ignored).
Duplicate rows (identical across all columns) are removed before totalling.
Run
One command produces the summary:
python3 scripts/run_pipeline.py --input <export.csv> --output summary.json
Output JSON shape:
{
"rows_in": 120,
"rows_after_dedup": 118,
"regions": {"West": 40210.5, "East": 38110.0},
"grand_total": 78320.5
}
Anti-goals
- Not a general BI tool; it totals one numeric column per region.
- Does not fetch from a live CRM API; it operates on an exported CSV.
04 同仓库更多 Skills
youtube-clipper
YouTube 视频智能剪辑工具。下载视频和字幕,AI 分析生成精细章节(几分钟级别), 用户选择片段后自动剪辑、翻译字幕为中英双语、烧录字幕到视频,并生成总结文案。 使用场景:当用户需要剪辑 YouTube 视频、生成短视频片段、制作双语字幕版本时。 关键词:视频剪辑、YouTube、字幕翻译、双语字幕、视频下载、clip video
viem-integration
Integrate EVM blockchains using viem. Use when user says "read blockchain data", "send transaction", "interact with smart contract", "connect to Ethereum", "use viem", "use wagmi", "wallet integration", "viem setup", or mentions blockchain/EVM development with TypeScript.
v4-security-foundations
Security-first Uniswap v4 hook development. Use when user mentions "v4 hooks", "hook security", "PoolManager", "beforeSwap", "afterSwap", or asks about V4 hook best practices, vulnerabilities, or audit requirements.
v4-sdk-integration
App-layer SDK guide for building swap and liquidity experiences directly with the Uniswap v4 SDK. Use when user asks about "v4 sdk", "uniswap v4", "v4 swap", "v4 liquidity", "PoolManager", "V4Planner", "StateView", "PositionManager", "pool state", "v4 position", "uniswap sdk", or when building swap/liquidity UX directly with SDKs rather than via the Trading API.
v4-hook-generator
Generate Uniswap v4 hook contracts via OpenZeppelin MCP. Use when building custom swap logic, async swaps, hook-owned liquidity, custom curves, dynamic fees, MEV protection, limit orders, or oracle hooks.
testing
For testing with Light Protocol programs and clients on localnet, devnet, and mainnet validation.