E-commerce · Analytics ·

Conversion funnel

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

Illustrative preview of the SAP Analytics Cloud dashboard Conversion funnel for the E-commerce industry: metrics Product view rate, Add-to-cart rate, Abandonment rate, Final conversion rate, analyzed by Stage, Device, Category.
Illustrative preview of a possible rendering in SAC. Brand colors and structure; synthetic figures.
Template validation passport
Model type
SAC Analytics
Versions
Single (Actual)
Formats
.xlsx · .csv · .zip
Structure
3 dimensions · 4 measures
Data source
Import (Modeler) or Live connection
Structure check
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

  • Product view rate
  • Add-to-cart rate
  • Abandonment rate
  • Final conversion rate

Analysis dimensions

  • Stage
  • Device
  • Category

About this template

Visualize the purchase journey: product view → add to cart → checkout → conversion. Spot the drop-off points. Designed for teams in the E-commerce industry, the model pre-wires 4 key metrics — including Product view rate and Add-to-cart rate — analyzable across 3 analysis axes (Stage, Device, Category). 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 Conversion funnel: 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 "Conversion funnel" 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: Product view rate, Add-to-cart rate, Abandonment rate, Final conversion rate. Each is computed across the dimensions Stage, Device, Category.

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.

Related reading

More E-commerce templates

All E-commerce templates →
SAC Analytics Digital performance & GMV A 360° view of your e-commerce activity: GMV, sessions, conversion and performan SAC Analytics Marketing & acquisition Track your paid acquisition channels: cost of acquisition, ad profitability and SAC Analytics Cohort analysis Measure retention and customer value at 1, 3 and 6 months after acquisition. Ide