Store performance & footfall
Compare revenue, average basket and incoming footfall by store and catchment area.
RevenueAverage basketStore footfall
Open template →
Retail · SAP Analytics Cloud
SAP Analytics Cloud templates for Retail
4 ready-to-use SAC and SAC Planning templates for Retail — 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 Retail
RevenueAverage basketConversion rateReturn rateGross marginInventory turnoverSales per m²Store footfallStockout rate
Analysis dimensions
StoreProduct categoryRegionChannelCustomer segmentSeasonProduct familyBrand
4 Retail templates
Each opens with a live preview and a one-click download (.xlsx, .csv, .package).
Stock & supply chain
Master inventory turnover, stockouts and cover by SKU — from store to central warehouse.
Inventory turnoverStockout rateStock cover
Open template →
Promotional performance
Measure the real effectiveness of your promotions: net uplift, ROI, cannibalization and incremental margin.
Promo upliftPromotional ROIParticipation rate
Open template →
Loyalty program
Manage your member base: acquisition, purchase frequency and the basket gap between members and non-members.
Enrollment rateRepurchase rateMember vs non-member basket
Open template →
How to model Retail in SAP Analytics Cloud
A solid Retail model starts with the right grain. Build your dimensions first (Store, Product category, Region), then add the measures that matter (Revenue, Average basket, Conversion rate). 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.