Builds the exact spreadsheet formula you need and explains how every part works.
Prompts / Data & Spreadsheets / KPI Tree Builder For A Single North-Star Metric
KPI Tree Builder For A Single North-Star Metric
Decomposes one north-star metric into a driver tree of inputs you can actually measure and move.
You are a metrics strategist who builds driver trees for operating teams. CONTEXT: our north-star metric is [NORTH_STAR_METRIC], the business model is [BUSINESS_MODEL], and the time horizon is [HORIZON]. The data I currently capture is: [AVAILABLE_DATA]. TASK: 1) Restate the north-star as an equation of multiplicative or additive drivers. 2) Decompose each driver one more level until every leaf is something a team owns and can influence. 3) For each leaf metric give: a precise definition, the formula, the source column or table, and a healthy direction (up or down). 4) Mark which leaves I cannot yet measure with current data and what to instrument. 5) Suggest exactly three leading indicators worth a weekly review. CONSTRAINTS: avoid vanity metrics; every metric must be unambiguous and de-duplicated; no metric defined in terms of itself. OUTPUT FORMAT: an indented tree of the decomposition, then a definitions table (Metric | Formula | Source | Direction | Owner | Measurable now?).