Key Figures: Market-Basket Analysis

  • Sales quantity

Quantity sold in sales and base unit of measure

  • Sales value

Retail value in local currency

Note Note

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.

End of the note.
  • 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

See also:

How Key Figures Are Calculated: Retail Information System