Skip to content

Market equation

The market equation describes how the metrics of your data combine into the KPI you want to explain. Datama uses it to split a variation of that KPI into the variation of each factor.

In the web app, Market Equation is a panel of the module settings that you can pin to the story: its formula and its total step (name, unit, emoji) are then shared by every module.

The equation is written as a product of factors, each one a ratio between two metrics. Each factor is a step: one bar of the Compare waterfall.

A retail example. To understand Revenue:

Revenue = Volume × Revenue/Volume

  • Volume is the number of products sold;
  • Revenue/Volume is the unit price.

The two steps separate what depends on sales volume from what depends on pricing, often managed by different teams. With more metrics, each step divides a metric by the previous one, like a funnel:

Orders = Sessions × Orders/Sessions

Revenue = Sessions × Orders/Sessions × Revenue/Orders

There is no limit on the number of steps; keep it under ten for a readable analysis.

Two buttons write a complete equation from your metrics in one click:

  • Generate Prod Market Equation: a product of ratios, the default;
  • Generate Sum Market Equation: a sum of metrics, for a KPI made of parts, for example Revenue = Revenue France + Revenue UK + Revenue US.

Then, for each step:

  • Numerator and Denominator: the step is the ratio numerator / denominator. Pick 1 as denominator to use the plain numerator volume.
  • Move up, Move down, Insert a step here, Remove this step.

The last line shows the Result of the equation above: your main KPI. Use Main KPI settings to set its name and unit.

Open Edit this step on a step:

Setting Effect
Name Label shown on the waterfall for this step. Names must be unique.
Unit Displayed next to the step name on the charts.
Emoji Optional icon of the step.
Focus dimension Always analyse this step through this dimension first, regardless of its interest score.
Excluded dimensions Dimensions never used to split this step. You cannot exclude them all.
Initial open state Whether the step is expanded when the waterfall loads: Auto, Always or Never.
Covariance How the step collects the covariance, the share of the gap that no step explains alone. See Compare › How it works.

A step can be detailed into sub-steps, for example the unit price split by product family. Add a sub-step creates one under the step; Indent and Outdent move a step in and out of the one above. Rewrite as the product of the sub-steps or Rewrite as the sum of the sub-steps updates the parent step from its sub-steps.

Datama lists the problems of the equation under Errors and Warnings, for example a numerator or denominator that does not exist in the data, step names that are not unique, or a dimension both focused and excluded. An equation needs at least one step.