SAC Analytics
Single (Actual)
.xlsx · .csv · .zip
3 dimensions · 4 measures
Verified ✓
Every field above is verifiable from the downloaded file itself. Live-tenant validation happens in your own SAP Analytics Cloud environment — you import and validate your own figures. Independent project, not affiliated with SAP SE.
KPIs included
- LTV by cohort
- Retention rate M1/M3/M6
- Revenue by cohort
- Churn
Analysis dimensions
- Cohort
- Acquisition channel
- Segment
About this template
Measure retention and customer value at 1, 3 and 6 months after acquisition. Identify the most profitable cohorts. Designed for teams in the E-commerce industry, the model pre-wires 4 key metrics — including LTV by cohort and Retention rate M1/M3/M6 — analyzable across 3 analysis axes (Cohort, Acquisition channel, Segment). You start from an already-bounded base (units, aggregations and business labels defined) rather than a blank sheet.
This is a complete SAC template kit for Cohort analysis: sample data, model definition, KPI dictionary, a step-by-step import guide (matching the current SAC screens) and a dashboard blueprint — recommended calculations with ready-to-paste SAC formulas plus a layout that follows universal dashboarding rules. Import the "Data" sheet into SAC Modeler (Create New → Model → Start with data → File), check the 3 dimensions and 4 measures, then build a professional Story in minutes using the blueprint. The dataset contains 720 to 960 rows of realistic sample values for the E-commerce industry, available as .xlsx (7-sheet workbook), .csv (flat table) and a .zip model kit (model.json, data.csv, README and licence). You supply and validate your own figures.
FAQ
What is the "Cohort analysis" template for?
It provides a ready-to-use SAC structure to drive analytics in the E-commerce industry. The standard business KPIs and dimensions are already defined, saving you the modeling phase.
Which KPIs are included?
The template includes 4 metrics: LTV by cohort, Retention rate M1/M3/M6, Revenue by cohort, Churn. Each is computed across the dimensions Cohort, Acquisition channel, Segment.
How do I import it into SAP Analytics Cloud?
Download the .xlsx or .csv, then in SAC: Modeler → Create New → Model → "Start with data" → File. Pick the "Data" sheet, tick "first row as headers", and SAC builds the model. The workbook includes a step-by-step Import guide (matching the current SAC screens) and a Dashboard blueprint with ready-to-paste calculations, so you can build a professional Story in minutes. You supply and validate your own figures.