weekly-crm-report - SKILL.md Agent Skill

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-skill-creator version: 1.0.0

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.