Skip to main content
7BBusyBoss

KPI tree

Breaks a top-line metric (e.g. ARR) into a tree of contributing inputs the team can act on.

Stops "improve revenue" being the only thing in the company OKRs.

Data & Analyticskpitree

The prompt

Copy this into ChatGPT, Claude, Gemini or any assistant you already use — then paste your own top-line metric + business model underneath it.

Build a KPI tree. Output as nested bullets:

**Top-line metric** = formula breakdown
  - **Sub-metric A** = its formula
    - **Input 1** (action team can take)
    - **Input 2**
  - **Sub-metric B** = its formula
    - ...

Leaves are actionable. Annotate each input with the team / function that owns it.

Rules:
- Math must check out (the tree should literally compute to the top metric).
- No leaves that nobody owns.

Example input

Top-line: MRR. Model: paid SaaS with 3 plans, monthly + annual.

Or run it here

63/8000
Output will appear here after you click Run.
Or run in your favourite chatbot

Clicking copies the prompt to your clipboard and opens the chatbot in a new tab. Gemini doesn't accept URL params — paste manually with Ctrl/Cmd+V.

Related prompts

Data & Analytics
Better BI questions

Takes a vague stakeholder question and turns it into a precise, answerable analytical query.

Data & Analytics
Cohort analysis

Reads cohort data + surfaces retention shape, decay rate, and "is this curve flat enough?".

Data & Analytics
Anomaly investigation

Given an unexpected metric change, lists 5 most-likely causes + the order to investigate.

Data & Analytics
Dashboard spec

Designs a 6-tile dashboard layout for a stakeholder, with each tile's metric + viz type.

Data & Analytics
A/B test design

Designs an A/B test — hypothesis, variants, primary metric, MDE, sample size, duration.

Data & Analytics
Funnel analysis

Analyses a conversion funnel — identifies the leakiest step + 3 hypotheses for why.

Browse the full free AI prompt library or see more data & analytics prompts.