Beginner
Metric definition library (single source of truth) template
Creates a standardized metric dictionary to prevent KPI drift across teams. Useful for scaling reporting and ensuring consistent definitions.
Build a metric definition library for these KPIs: {kpi_list}.
Inputs:
- Existing definitions (if any): {existing_definitions}
- Systems where data lives: {systems}
- Reporting cadence and audiences: {cadence_audiences}
Output:
A table with columns:
- KPI name
- Definition (plain English)
- Formula (with field names)
- Included/excluded items
- Data source and table/report
- Owner
- Refresh cadence
- Common pitfalls / edge cases
- Validation checks
Keep definitions unambiguous and audit-friendly.Related Prompts
Management Accounting & FP&A
BeginnerMonthly variance analysis: budget vs actual with bridges
Automates variance analysis with price/volume/mix and spending bridges where applicable. Produces exec-ready narratives and follow-up questions.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
47
Management Accounting & FP&A
IntermediateCost allocation model: shared services and drivers
Designs a cost allocation approach for shared services using clear drivers and documentation. Useful for management reporting and chargeback models.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
67
Management Accounting & FP&A
IntermediateSaaS: Churn Analysis & Retention Bridge
Explains the walk from Opening ARR to Closing ARR.
GPT-4oClaude 3.5 Sonnet
0
0
50