What Are Governed Metrics?

Governed metrics are centrally defined, version-controlled calculations that ensure everyone in an organization computes the same metric the same way — regardless of the tool, dashboard, or query they use.

When a data team defines "Net Revenue Retention" as a governed metric, the formula, filters, time window, and cohort logic are locked in. Any tool that queries this metric applies the identical logic, eliminating the "my numbers don't match yours" problem.

Why Governed Metrics Matter

Without governance, metrics drift. Marketing calculates "conversion rate" differently from product, finance has three versions of "MRR," and leadership loses trust in data because the same question produces different answers depending on who you ask.

Governed metrics solve this by establishing a single canonical definition for each metric. The definition is maintained by the data team, tested for accuracy, and enforced at the query layer. Business users can still explore freely — they just can't accidentally redefine a metric.

For organizations scaling self-service BI, governed metrics are the guardrail that makes self-service safe. They enable broad access without sacrificing consistency.

How Governed Metrics Work

1. Definition — A data team writes the exact SQL logic, specifying the aggregation, filters, grain, and any conditional rules (e.g., exclude refunds, apply currency conversion).

2. Version control — Definitions are stored in a metrics repository with change history, so updates are tracked, reviewed, and auditable.

3. Enforcement — The semantic layer or metrics engine applies the governed definition whenever the metric is requested, overriding any ad hoc calculation attempts.

4. Discovery — Business users browse a metric catalog to find available metrics, read their definitions, and understand what each one measures before querying.

Examples of Governed Metrics

• MRR (Monthly Recurring Revenue): Defined as the sum of all active subscription amounts, excluding one-time charges and trials. Every dashboard and report uses this single definition.
• Churn Rate: Defined as the percentage of customers who cancelled in a given month, with specific rules for pauses, downgrades, and reactivations.
• Customer Acquisition Cost (CAC): Defined as total sales and marketing spend divided by new customers acquired, with a specific attribution window.

Governed Metrics and Lookato

Lookato lets data teams define governed metrics that are enforced across every natural language query. When a user asks "What's our churn rate?", Lookato applies the canonical definition automatically — no risk of accidental recalculation. Metrics are discoverable, consistently applied, and always up to date.