Quick start
This guide runs a first Compare analysis: it explains the variation of one KPI between two periods. It takes about ten minutes once your data is ready.
1. Check your data
Section titled “1. Check your data”Datama reads a table with one row per segment and period:
- a column for what you want to compare, often a date, or a dimension such as device or country;
- the other dimensions that may explain the variation (channel, country, product…);
- the metrics: quantitative columns that can be summed, with no ratios or percentages, ideally in the order of your funnel (sessions, then orders, then revenue).
See Data requirements for details and examples.
2. Open Datama
Section titled “2. Open Datama”Web app
In Datama Studio, click + next to the story tabs (Add a story).
Looker Studio, Tableau, Power BI, Qlik
Add the Datama visual to your report, then map your dimensions and metrics to its fields. The page of your tool in Environments describes both steps. Then go to step 4.
Excel, Google Sheets
Open the Datama add-on and select your data. The page of your spreadsheet in Environments describes both steps. Then go to step 4.
AI Skill
Install the skill and give it your data. See AI Skill. The steps below explain how to read the result.
Web app
3. Create a story
Section titled “3. Create a story”In the Create a story window:
- Type a Story title and, if you like, pick a Story icon.
- Under Choose a preset, select Compare. The Modules list now holds a Waterfall module.
- Keep Display on Scroll and Layout on Default.
- Click Create.
See Create a story for every option.
4. Set up the analysis
Section titled “4. Set up the analysis”Datama proposes a first set-up from your data. Check the two settings that matter most, then click Apply:
- the comparison: the two periods or segments to compare (Start and End);
- the market equation: how your metrics combine into your main KPI.
5. Read the waterfall
Section titled “5. Read the waterfall”The waterfall explains the gap of your KPI from Start to End. For example:
- Revenue fell by 28.1%, from 45,549 € last year to 32,747 € this year.
- Each bar is one step of the market equation: here, users fell by 11.7% and checkouts per session by 26.7%.
- The size of a bar is its impact on revenue: the drop of checkouts per session costs 12,298 €.
Click a step to see which dimension explains it best, and how much each of its segments contributes. Each contribution splits into a mix effect and a performance effect (see Key concepts).
Next steps
Section titled “Next steps”Web app
- Add other modules to the story: Add and arrange modules.
- Share settings between modules: Pin settings to the story.
- Present your story: Present and share.
- Learn the options of the waterfall: Compare.
- Every setting shared by the modules: Set up the analysis.