Key Figures: Market-Basket Analysis (SAP Library

Key Figures: Market-Basket Analysis

Sales quantity

Quantity sold in sales and base unit of measure

Sales value

Retail value in local currency

In the standard system, this field is the sales with tax. Should this field contain the sales without tax, you should adjust the copying method accordingly.

Price reduction (total)

Difference between the target price and the actual retail price

Number of transactions

Number of sales documents at POS

Number of items

Number of items (articles) in transaction

Number of sales promotion items

Number of items in transaction that relate to a sales promotion

Number of merchandise categories

Number of merchandise categories in the transaction

Number of known customers

Number of customers available for a customer master

Number of anonymous customers (with card)

Number of anonymous customers who have paid by credit card and for whom no customer master exists

Number of anonymous customers

Number of customers who cannot be identified

Average price

Calculated on the base value of the sales unit and base unit of measure

Formula: Sales (value) / Sales (quantity)

Average number of items

Formula: Number of transaction items / Number of transactions

Average number of merchandise categories

Formula: Number of merchandise categories / Number of transactions

Proportion of promotion sales

Formula: Number of promotion items / Total number of items

Usage intensity

Is determined according to the base value of the sales unit and base unit of measure

Formula: Quantity / Number of transactions

Average transaction sales

Formula: Sales (value) / Number of transactions

Scanning rate

Formula: 100 x Number of known customers / Number of transactions

Proportion of anonymous customers (with card)

Formula: 100 x Number of anonymous customers (with card) / Number of transactions

Proportion of anonymous customers

Formula: 100 x Number of anonymous customers / Number of transactions