KPIs included
- CAC
- ROAS
- Conversion rate by channel
- Cost per click
Analysis dimensions
- Channel
- Campaign
- Country
About this template
Track your paid acquisition channels: cost of acquisition, ad profitability and conversion rate by source. Designed for teams in the E-commerce industry, the model pre-wires 4 key metrics — including CAC and ROAS — analyzable across 3 analysis axes (Channel, Campaign, Country). You start from an already-bounded base (units, aggregations and business labels defined) rather than a blank sheet.
After downloading, import Marketing & acquisition into SAC Modeler (Files → New Model → Import data from a file), map the 3 dimensions and 4 measures, then build your Story. The provided dataset contains 720 to 960 rows with realistic values for the E-commerce industry, available as .xlsx (multi-sheet workbook), .csv (flat table) and .package (ZIP bundle with model.json, data.csv and README).
FAQ
What is the "Marketing & acquisition" 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: CAC, ROAS, Conversion rate by channel, Cost per click. Each is computed across the dimensions Channel, Campaign, Country.
How do I import it into SAP Analytics Cloud?
Download the .csv or .xlsx format, then in SAC: Files → New Model → Import data from a file. Map the columns (Dimensions then Measures), validate the types and build your Story. Allow 5 to 10 minutes for an operational model.