Agent Skills: Weekly Business Report Generator

Auto-generates weekly KPI reports from multiple data sources including Supabase analytics, CRM data, financial spreadsheets, and email metrics. Produces executive-ready reports with dashboards, trends, highlights, concerns, and action items.

UncategorizedID: OneWave-AI/claude-skills/weekly-business-report

Install this agent skill to your local

pnpm dlx add-skill https://github.com/OneWave-AI/claude-skills/tree/HEAD/weekly-business-report

Skill Files

Browse the full folder contents for weekly-business-report.

Download Skill

Loading file tree…

weekly-business-report/SKILL.md

Skill Metadata

Name
weekly-business-report
Description
Auto-generates weekly KPI reports from multiple data sources including Supabase analytics, CRM data, financial spreadsheets, and email metrics. Produces executive-ready reports with dashboards, trends, highlights, concerns, and action items.

Weekly Business Report Generator

Pull data from multiple business systems, synthesize it into a coherent narrative, and produce an executive-ready weekly report that turns raw numbers into strategic insight.

Contents

  • references/configuration.md — first-run setup questions, directory layout, full config.yaml, and kpi-history.json schema.
  • references/data-and-calculations.md — per-source data collection, trend indicators, target comparison, rolling averages, anomaly detection, comparison modes, custom KPI groups, quality rules, and error handling.
  • references/output-template.md — the full report markdown template and detail levels.

Workflow

First run (no configuration exists)

  1. Run the setup questions and create the directory layout. See references/configuration.md.
  2. Generate config.yaml and templates/kpi-definitions.yaml from the schema in references/configuration.md.
  3. Initialize history/kpi-history.json using the schema in references/configuration.md.

Each subsequent run

  1. Read config.yaml and templates/kpi-definitions.yaml.
  2. Determine the reporting period (the previous full business week).
  3. Pull data from each enabled source and snapshot it to data/{date}/. See references/data-and-calculations.md.
  4. Calculate every KPI: trend indicators, target comparison, rolling averages, and anomalies. See references/data-and-calculations.md.
  5. Compare against targets and prior weeks; flag anomalies.
  6. Generate the report from the template in references/output-template.md, tailored to each recipient's detail level.
  7. Save the report to reports/{date}-weekly-report.md and append this week's values to history/kpi-history.json.

Quick Commands

  • "Generate this week's report" — full report for the most recent complete week.
  • "Show me revenue trends" — revenue-specific trend analysis with 4-8 week history.
  • "What are the concerns this week?" — concerns-only output.
  • "Add KPI [name]" — add a new KPI to tracking (see custom KPI groups in references/data-and-calculations.md).
  • "Update targets" — modify target values for existing KPIs.
  • "Compare last 4 weeks" — side-by-side comparison of the last 4 weekly reports.
  • "YTD summary" — year-to-date summary across all tracked KPIs.

Apply the report quality rules and error handling in references/data-and-calculations.md to every run.