Template

KPI Definition & Ownership Template (Interactive)

Interactive, standards-based KPI definition template that captures name, owner, decision context, calculation logic, data lineage, monitoring rules, validation history, RACI, and example values. Designed to be saved as structured JSON and reused across dashboards, audits, and accountability workflows.

Interactive Tool

KPI Definition & Ownership Template (Interactive)

Use this template to make KPIs unambiguous, dependable, and actionable. Capture the business question the metric answers, explicit calculation logic, data sources and ownership, monitoring rules and alerts, validation history, and the decisions the KPI should trigger. The interactive form saves a structured KPIDefinition record that teams can reuse in dashboards, audits, and automated alerts.

Completed example (illustrative)

KPI: Monthly Active Users (MAU)

Business question: How many distinct users engage with the product each calendar month?

Owner: Growth Product Manager

Calculation (numerator/denominator): Numerator = count(distinct user_id where event in ('open_app','login') and event_date between month_start and month_end). No denominator. SQL example: SELECT COUNT(DISTINCT user_id) FROM events WHERE event_type IN ('open_app','login') AND event_date >= '2023-07-01' AND event_date < '2023-08-01';

Target / tolerance: Target: 120,000 MAU; tolerance: ±5%

Linked decision: If MAU falls >10% below target for two months, trigger retention experiment and review by Growth huddle.

Short, specific name (for example: Monthly Active Users)
One or two sentences explaining what the KPI measures and why it matters
The concrete question stakeholders should be able to answer using this KPI
Primary accountable individual
Role or team accountable for the KPI
Who performs the measurement or maintenance tasks
Who is ultimately accountable
Who should be consulted when changes are proposed
Who should be informed about KPI changes and breaches
How often the KPI is computed and reviewed
Exact definition of numerator (include filters, date boundaries, dedup rules)
If applicable, exact definition of denominator
Units (e.g., users, sessions, $)
Provide SQL or a clear formula, including any aggregations and time-window logic
List systems, tables, file names, event streams and owners
Person or team responsible for the underlying data
Paste production SQL or ETL logic here if available
Numeric or qualitative target (e.g., 120,000 MAU or Improve NPS by 3 pts)
Acceptable variance around target (e.g., ±5%)
How important is this KPI to core operations or strategic goals?
Signals that typically move before this KPI
What decisions should be made or actions taken when the KPI changes or breaches thresholds
Explicit conditions for alerts (e.g., 10% drop vs target for 2 consecutive periods)
Where should alerts be sent?
Describe validation rules (row counts, null rate thresholds, freshness checks)
Last date when calculation and sources were validated
Who validated, what was checked, known issues
ETL jobs, event producers, or other KPIs this one depends on
Helps connect changes to visualization owners
URLs or locations of dashboards showing this KPI
Link to runbook, Confluence page or data dictionary
Increment when calculation or ownership changes
Record of revisions: date, author, reason
You can explore this tool now. Sign in or create an account to save your responses and return to them later.
Sign In to Save Create an Account
Make this tool part of your work

Save a personal copy, bring it to your team, or tailor the questions and workflow to fit what you are hungry to improve.

Member customization and team collaboration are coming soon.
Discuss Ask the Librarian

Discussion

Comments and conversation will live here.