weekly-ops-report
Installation
SKILL.md
Weekly Ops Report
A weekly report is a contract: what changed, where is it concentrated, what needs a decision. Anything that does not serve one of those three questions is decoration and gets cut.
Workflow
- Data-quality gate first. Before any KPI: duplicated rows, missing calendar days, impossible values (negative quantities, dates out of range). Fix what is safe to fix, and report every finding in a footer - an unattended report must audit its own inputs.
- Compute the KPI set agreed for the audience (typical core: revenue/volume, service level, stock cover; keep it under ~6). For each: this week, vs last week, and vs the trailing 8-week average. The baseline comparison prevents one unusual prior week from faking a trend.
- Apply movement thresholds. Only movements beyond agreed thresholds (state defaults, e.g. |revenue| >= 5%, |service| >= 1.5 pts) become findings. Reporting every wiggle trains readers to ignore the report.
- Decompose every finding. A movement without its driver is not a finding. Break the moved metric by its main dimension (region, carrier, category...) and name the concentrated segment with its share of the move.
- Write findings as sentences, one line each, using: METRIC moved X (vs baseline) - DRIVER is the main contributor (Y, ~Z% of the move) - SUGGESTED NEXT STEP. Tag each finding positive / negative / warning. Maximum five findings; if more qualify, keep the five largest by impact.
- Assemble in fixed order: headline KPI cards, findings list, trend view (13 weeks), attention lists (e.g. low-cover SKUs), data-quality footer. Same structure every week - familiarity is what makes deltas visible.
- Validate before delivering. Recompute one headline KPI directly from raw rows and match it against the report value. If automation is involved, this check runs inside the pipeline, not in someone's head.