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

Intermediate

Inventory Valuation: LIFO vs FIFO Impact

Analyzes the effect of inventory cost flow assumptions on COGS and taxes.

GPT-4oGemini 1.5 Pro

168

Management Accounting & FP&A

Advanced

Allocating Shared Service Costs (Corporate Overhead)

Determines how to charge back HR, IT, and Finance costs to operating business units.

Claude 3.5 Sonnet

166

Management Accounting & FP&A

Beginner

KPI tree: link strategy to drivers and metrics

Creates a KPI tree that connects strategic objectives to operational drivers and metrics with definitions. Useful for leadership alignment and dashboard design.

GPT-5.2 Thinking; GPT-4.1; o3-mini

153