Define your metrics
Before analysing, Datama needs to know which columns are dimensions, which are metrics, and how the metrics combine into the KPI you want to explain.
Web app
In the web app, you set this in the Datama block, the last block of the data layer, marked with a D.
Dimensions and metrics
Section titled “Dimensions and metrics”Datama detects them for you, reading the columns from left to right: the columns up to the last text column are dimensions, the ones after it are metrics. The first dimension is used as the comparison dimension.
Check the result, and move a column to the other list when needed. See Data requirements for what makes a good dimension or metric.
Market equation
Section titled “Market equation”The market equation, also called metric relation, writes your KPI as a product of steps, for example:
Revenue = Sessions × Orders/Sessions × Revenue/Orders
By default, Datama generates a funnel: each metric divided by the previous one. See Market equation to build and edit it, and to set the name, unit, focus and excluded dimensions of each step.
Generate it with AI
Section titled “Generate it with AI”In the quick setup options, the ✨ button proposes a market equation for your data.
- The first time, accept the AI terms and conditions.
- In the chat, add context if needed: currency (
$by default), language, step names… - Datama proposes an equation in a table. Reply to adjust the steps, names or units.
- Click Use This Equation. Reset clears the chat and starts again.
Only the column names and the context you type are sent: no value of your data leaves Datama.
Each step, and the result of the equation, can have a unit:
- a symbol, such as
$,€or£, shown next to the values; - a pattern, such as
$.*M, to control how values are written.
With the unit %, values are also multiplied by 100.
Thresholds
Section titled “Thresholds”A step can have a threshold, in %. When you send the analysis by Slack, Teams or email, you can choose to receive the message only when a threshold is reached.