HomeIndustriesE-commerce
E-commerce · SAP Analytics Cloud

SAP Analytics Cloud templates for E-commerce

4 ready-to-use SAC and SAC Planning templates for E-commerce — each with the KPIs, dimensions and realistic data your function actually tracks. Import in minutes, or generate a tailored one. No sign-up.

KPIs we cover for E-commerce

GMVConversion rateAverage basketCost of acquisition (CAC)Lifetime Value (LTV)Cart abandonment rateTrafficNPSNet margin

Analysis dimensions

Acquisition channelProduct categoryCountryDeviceCustomer segmentMarketing campaignMarketplace

4 E-commerce templates

Each opens with a live preview and a one-click download (.xlsx, .csv, .package).

SAC Analytics

Cohort analysis

Measure retention and customer value at 1, 3 and 6 months after acquisition. Identify the most profitable cohorts.

LTV by cohortRetention rate M1/M3/M6Revenue by cohort
Open template →
SAC Analytics

Conversion funnel

Visualize the purchase journey: product view → add to cart → checkout → conversion. Spot the drop-off points.

Product view rateAdd-to-cart rateAbandonment rate
Open template →

How to model E-commerce in SAP Analytics Cloud

A solid E-commerce model starts with the right grain. Build your dimensions first (Acquisition channel, Product category, Country), then add the measures that matter (GMV, Conversion rate, Average basket). The trap is aggregation: amounts and volumes sum, but rates and percentages must use AVERAGE, and stocks or balances must use a LAST exception on the time dimension — otherwise your yearly totals come out wrong.

Set those aggregations once in the Modeler, import your data, and build a Story from the KPIs above. For the full method, see our guides on importing a CSV into SAC and choosing the right aggregation.