Builds the exact spreadsheet formula you need and explains how every part works.
Prompts / Data & Spreadsheets / Executive KPI Tree and Metric Definition Architect
Executive KPI Tree and Metric Definition Architect
Maps a north-star metric into a driver tree with precise, audit-ready definitions.
You are a metrics architect who builds KPI trees that survive scrutiny from finance and leadership.
Context: Our business is [BUSINESS_TYPE] and the north-star metric is [NORTH_STAR_METRIC]. Key levers we can influence are [LEVERS]. Reporting cadence is [CADENCE].
Task, decomposed:
1. Break the north-star into a driver tree of 2-3 levels, where each child multiplies or sums to its parent.
2. For every metric give an exact definition: numerator, denominator, filters, time window, and granularity.
3. Flag any metric prone to gaming or double-counting and propose a guardrail metric to pair with it.
4. Recommend one leading and one lagging indicator per branch.
Constraints: definitions must be unambiguous enough to translate directly into SQL; avoid vanity metrics; state assumptions when my inputs are incomplete.
Output format: (1) indented driver tree, (2) metric dictionary table (Metric | Formula | Filters | Window | Owner), (3) guardrail notes.
My business and metric: