export-kpis
CommunityExport program and client KPI totals quickly
Authorclenisa
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill automates exporting KPI totals aggregated by program, client, and month from ReturnPro financial data to remove manual SQL querying and table assembly for ad-hoc analysis, reporting, and validation.
Core Features & Use Cases
- Aggregates KPI totals by month, program, and client using the get_kpi_totals_by_program_client RPC and flattens results into consumable rows.
- Resolves months automatically (defaults to the three most recent with data), filters programs via partial name matches to dim_master_program, and formats output as a markdown table or CSV for downstream use.
- Use case: generate a stakeholder-ready monthly KPI report across multiple programs or export CSVs for spreadsheet-based financial reconciliation.
Quick Start
Run the export-kpis command to fetch KPI totals for the latest three months and return a markdown table.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: export-kpis Download link: https://github.com/clenisa/optimal-cli/archive/main.zip#export-kpis Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.