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.
How it works
Section titled “How it works”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
Volumeis the number of products sold;Revenue/Volumeis 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.
Build the equation
Section titled “Build the equation”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.
Step settings
Section titled “Step settings”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. |
Sub-steps
Section titled “Sub-steps”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.
Checks
Section titled “Checks”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.