Skip to content

Use cases by domain

These examples show how to set up Datama for common questions. Each one gives the comparison, the market equation and the dimensions to use, and links to its sample data in a public Google Sheets spreadsheet. The same examples are available as demo workbooks in the web app.

An e-commerce site compares its revenue between a week of this year and the same week last year.

Module Compare
Comparison Week last year vs week this year
Market equation A conversion funnel, from sessions to revenue: Revenue = Sessions × Baskets/Sessions × Checkouts/Baskets × Revenue/Checkouts
Data Google Analytics sample

A product team compares the two versions of a checkout. In the sample, only one thing changes between A and B: the conversion of Mobile Chrome users from the first to the second cart step, which Compare finds on its own.

Module Compare
Comparison Variant A vs variant B
Market equation The steps of the checkout funnel
Dimensions Device, browser, and any other attribute of the test
Data A/B test sample

A team compares two versions of a website, zone by zone, with Contentsquare data.

Module Compare
Comparison Version A vs version B
Market equation Click = Visit × Views/Visit × Hover/Views × Click/Hover
Dimensions Page, Zone (picture, text…), Device
Data Contentsquare sample

A team watches its Google Analytics funnel every day, and wants to know when and where it breaks.

Module Detect
Detect anomaly on Date
Market equation Sessions × Baskets/Sessions × Checkouts/Baskets × Revenue/Checkouts
Data Anomaly detection sample

A marketing team compares two email campaigns, step by step: sent, opened, clicked, converted. In the sample, campaign B loses most at Open / Sent, because one customer segment opened it much less than campaign A.

Module Compare
Comparison Campaign A vs campaign B
Market equation The funnel of the campaign, from emails sent to conversions
Dimensions Customer segment, and any attribute of the audience
Data Campaign sample

With a numeric dimension such as age, Datama cuts it into ranges (18–20.5, 20.5–23…) to find the age groups that behave alike. See the continuous dimension sample and Clustering.

To leave part of the data out of the steps while keeping it in the total, see Out of scope segments and the scope sample.

A media team compares the revenue of its campaigns between last month and this month, from budget to revenue.

Module Compare
Comparison Last month vs this month
Market equation From spend to revenue: Revenue = Costs × Impressions/Costs × Clicks/Impressions × Sessions/Clicks × Transactions/Sessions × Revenue/Transactions
Dimensions Campaign group, Source (Google, Bing…), Campaign, Medium, Keyword
Data Acquisition sample

An e-commerce site compares two display campaigns across advertising platforms and devices, to find the most effective combination.

Module Compare
Comparison Campaign A vs campaign B
Market equation The funnel of the campaign, from impressions to revenue
Dimensions Platform, Device
Data Display sample

A retailer compares its net margin month over month, online and offline, with a business equation instead of a funnel.

Module Compare
Comparison Last month vs this month
Market equation Net margin = Quantity × Revenue/Quantity × Net revenue/Revenue × Gross margin/Net revenue × Net margin/Gross margin, that is volume × average price × (1 − discount rate) × gross margin rate × net margin rate
Data Retail sample

See also Margin analysis in the tips.

A category manager compares the revenue of each category year over year, across channels and brands.

Module Compare
Comparison Last year vs this year
Market equation Revenue = Stores × Units/Stores × Revenue/Units: distribution, rotation and price
Dimensions Category, Channel, Brand
Data Category sample

A controller explains the variation of the margin.

Module Compare
Market equation Margin = Items × Revenue/Items × Margin/Revenue
Data Controlling sample

A business compares its churn rate between last year and this year, by client type, gender and product.

Module Compare
Comparison Last year vs this year
Market equation Churn rate = Clients lost in the month / Clients at the beginning of the month
Dimensions Client type, Gender, Product
Data Churn sample
  1. Write down the KPI to explain, and how your metrics lead to it: that is your market equation.
  2. List the dimensions that can explain a change.
  3. Shape the data as in Data requirements.

For stories from real clients, see Use case of the month.