Metric reconciliation

The Measurement Steward maintains metric definitions with a grain, numerator and denominator expressions, aggregation method, unit and version. The Operations Analyst uses an approved definition and the eligible readings for one source. The manual reconciliation workflow computes the observed conversion rate, protects a zero denominator and stores a result linked to its operation run.

• Rule. The Measurement Steward maintains the approved definition, grain and version.
• Scope. The Operations Analyst selects eligible readings for the source and period.
• Result. The calculation stores its numerator, denominator, status and linked run.

The run connects the calculation to an input hash and source revision. The Operations Analyst can compare the earlier and successor results by period, definition version and included reading scope. That trail explains a changed number on the operational overview. The Measurement Steward checks that the approved rule and aggregation method still fit the source; the analyst keeps each saved result with its own run.

Agree which approved definition applies to a stream and time window. Record how eligible readings are selected and what a zero denominator means for the result status. The team should decide how a corrected source revision is compared with the earlier persisted result.

Rehearse the same period with eligible readings and then with a zero denominator. The Operations Analyst checks which readings entered the scope and whether the saved status and reason explain the result. The Measurement Steward checks the definition version used for that period.

For a stream with accepted observations in a coverage window, the analyst checks the approved definition and the included reading scope. The calculation records numerator, denominator, value and source row count. If the denominator is zero, the result must explain its outcome without presenting an ordinary rate. A later correction gets a successor source revision and a new run; the original result remains available.

After a correction, the Operations Analyst runs reconciliation again and locates both results. Compare their source revisions, run identities, periods and source row counts. Neither result should silently replace the other.

• Metric results to inspect — Results needing attention, with their reason and source run.
• Approved metric definitions — Metric rules with grain, version and aggregation method.

See the related process for the handoff and the data model for the connected records.