Follow the transformation
Name the stakeholder and decision.
Define the unit of analysis (customer, order, day, device, etc.).
Define each measure with numerator, denominator, time window and inclusion/exclusion rules where relevant.
Data and Metric Definitions is about connecting analysis to a decision.
Data and Metric Definitions is about connecting analysis to a decision. Measures quantify something, dimensions describe how observations are grouped, and KPIs select a small set of measures that reflect progress toward an objective.
Data and Metric Definitions matters because analysis is only useful when another person can understand the evidence and another analyst can reproduce the calculation. Reporting therefore includes definitions, uncertainty, data lineage and execution details—not just final numbers.
Treat this as a sequence of observable decisions rather than one opaque command. Stage 1: Name the stakeholder and decision. Stage 2: Define the unit of analysis (customer, order, day, device, etc.). Stage 3: Define each measure with numerator, denominator, time window and inclusion/exclusion rules where relevant. Final checkpoint: Check whether the metric can move because of data collection changes rather than real-world change.
Name the stakeholder and decision.
Define the unit of analysis (customer, order, day, device, etc.).
Define each measure with numerator, denominator, time window and inclusion/exclusion rules where relevant.
Field: order_date = timestamp when payment is confirmed, UTC.
Metric: refund_rate = refunded_orders / completed_orders within the same 30-day cohort.
Exclusions: test orders and cancelled-before-payment orders.Operational definitions prevent two analysts from calculating “the same” metric differently.
For Data and Metric Definitions, connect the displayed result to the specific input and mechanism above; independently verify one value/state change rather than treating successful execution as proof.
MeasureA numeric quantity such as revenue or response time.DimensionA grouping/category such as region, product or channel.KPIA measure deliberately tied to an objective and decision cadence.TargetA desired value or threshold against which a KPI is evaluated.Use Data and Metric Definitions when it connects a clearly framed stakeholder question to measurable evidence and an action or decision.
Reframe the analysis if the decision, unit of analysis, metric definition, comparison group or time window is still ambiguous; more computation will not repair an undefined question.
Build a tiny, inspectable example of Data and Metric Definitions. First name the stakeholder and decision. Then define the unit of analysis (customer, order, day, device, etc.). Write the expected result before running it, and explain one condition that would make the result misleading or invalid.
Before trusting a result from Data and Metric Definitions, which check provides the strongest evidence that you understand and applied it correctly?
Step 1Name the stakeholder and decision.Step 2Define the unit of analysis (customer, order, day, device, etc.).Step 3Define each measure with numerator, denominator, time window and inclusion/exclusion rules where relevant.Step 4Choose dimensions that support meaningful segmentation.