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.
Web analytics
Section titled “Web analytics”Website performance
Section titled “Website performance”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 |
Product A/B test
Section titled “Product A/B test”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 |
Content analytics
Section titled “Content analytics”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 |
Anomalies in a conversion funnel
Section titled “Anomalies in a conversion funnel”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 |
Marketing
Section titled “Marketing”Email campaign
Section titled “Email campaign”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.
Paid acquisition
Section titled “Paid acquisition”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 |
Display campaigns
Section titled “Display campaigns”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 |
Business and finance
Section titled “Business and finance”Retail performance
Section titled “Retail performance”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.
Category management
Section titled “Category management”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 |
Financial controlling
Section titled “Financial controlling”A controller explains the variation of the margin.
| Module | Compare |
| Market equation | Margin = Items × Revenue/Items × Margin/Revenue |
| Data | Controlling sample |
Customer relationship
Section titled “Customer relationship”Churn rate
Section titled “Churn rate”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 |
Your own use case
Section titled “Your own use case”- Write down the KPI to explain, and how your metrics lead to it: that is your market equation.
- List the dimensions that can explain a change.
- Shape the data as in Data requirements.
For stories from real clients, see Use case of the month.