FrancyJGLisboa/agent-skills-platform / references/examples/weekly-crm-report
weekly-crm-report
UnverifiedCleans 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.
| File | Kind | Size |
|---|---|---|
| README.md | markdown | 1.7 KB |
| SKILL.md | skill md | 2.4 KB |
| VERIFICATION.md | markdown | 845 B |
| contracts/data_contract_crm_export/.contract_id | other | 10 B |
| contracts/data_contract_crm_export/code/contract_health.py | script | 386 B |
| discovery.json | config | 2.2 KB |
| evals/golden/case-1/expected.json | config | 126 B |
| evals/golden/case-1/input.csv | other | 62 B |
| evals/golden/case-2/expected.json | config | 129 B |
| evals/golden/case-2/input.csv | other | 46 B |
| evals/golden/case-3/expected.json | config | 106 B |
| evals/golden/case-3/input.csv | other | 39 B |
| evals/weekly-crm-report.eval.md | markdown | 1.8 KB |
| scripts/dependency_health.py | script | 3.9 KB |
| scripts/evolve.pyexecutable | script | 10.2 KB |
| scripts/review_staleness.py | script | 6.2 KB |
| scripts/run_evals.pyexecutable | script | 49.4 KB |
| scripts/run_pipeline.pyexecutable | script | 2.3 KB |
| scripts/schema_drift.py | script | 7.3 KB |
| scripts/skill_document.py | script | 9.8 KB |
| scripts/staleness_check.py | script | 7.5 KB |
| scripts/success_ledger.py | script | 16.5 KB |
SKILL.md
View on GitHub---
name: weekly-crm-report
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.
license: MIT
metadata:
author: agent-skills-platform
version: 1.0.0
created: 2026-06-27
last_reviewed: 2026-07-20
review_interval_days: 180
---
# 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:
```bash
python3 scripts/run_pipeline.py --input <export.csv> --output summary.json
```
Output JSON shape:
```json
{
"rows_in": 120,
"rows_after_dedup": 118,
"regions": {"West": 40210.5, "East": 38110.0},
"grand_total": 78320.5
}
```
## Gotchas
- **`rows_after_dedup` does not reconcile with `grand_total`.** Rows with a blank
or missing `region` are skipped when totalling but still counted in
`rows_after_dedup`, so a CSV with unassigned rows reports more rows than it
actually summed. Do not present the two numbers as if one explains the other —
if they must reconcile, filter blank regions before running.
- **An unparseable `amount` silently becomes `0.0`,** it does not raise. A column
of `N/A` or `—` produces a region total of `0.0` that looks like a real zero.
Check the input for non-numeric amounts before trusting a suspiciously low total.
- **Dedup compares every column, not just `region` and `amount`.** Two rows with
identical sales data but a differing timestamp or record-ID column are both kept.
The "extra columns are ignored" note above applies to totalling, not to dedup.
## 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.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |