#metrics
Posts tagged with #metrics.
Modeling & metricsWhy marketing CAC and ROAS never matched finance
How governed derived metrics and transparent lineage unify customer acquisition cost and return on ad spend across marketing channels and finance.
Modeling & metricsDerived metrics without double counting
Derived metrics compose other metrics, not raw columns — get the expansion order wrong and a ratio silently double-counts. Here's how datahashi keeps composition honest.
Modeling & metricsTime grains and asymmetric aggregates
Time grain is part of the metric contract. Some aggregates roll cleanly across grains. Others do not, and agents need to know the difference.
Modeling & metricsAdditive vs non-additive metrics
Why some metrics can be summed across dimensions and time, and why others must never be.
Modeling & metricsFan-out-safe metrics explained
What fan-out risk looks like in metric queries and how to keep aggregates correct.
Modeling & metricsDimensions that do not explode joins
How to model dimensions so metric grain stays correct and joins do not multiply rows.
Modeling & metricsYour first metric: name it, do not hand-write SQL
Walk through defining a first certified metric by name and measure without pasting hand-written SQL into the agent path.
Governance & trustMetric contracts: the same-number test
A metric contract is a shared definition you can test. If two consumers disagree on the number, the contract failed.
Modeling & metrics