OpenParable
Skip to content
← Back to skills

Weekly Crm Report

Business
weekly-crm-report

Weekly Crm Report is an Agent Skill for business published in the FrancyJGLisboa/agent-skill-creator repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

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.

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/FrancyJGLisboa/agent-skill-creator/blob/HEAD/references/examples/weekly-crm-report/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/weekly-crm-report, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

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.