Guide Overview
This guide is intended to highlight the Key Measures for you to utilize within Crisp Retail Analytics utilizing Walmart Luminate data. The options for Measures are very robust so we have pulled out and listed for you below the main measures we think your organization will find valuable and rely on most frequently.
Tip: If you are not sure what measures are available or want to search for calculations be sure to use our in-product dictionary functionality within your workspace.
Sales Measures
$ Sales - Sales Amount Current
Is the dollar amount of sales for a specific item number that is scanned at a store level register.Includes all returns (total store returns) at store level. If there are no sales when this value shows up as a negative sales amount.
$ Sales PY - Sales Amount PY
$ Sales Chg - Sales Amount YOY
$ Sales % Chg - Sales Amount YOY %
Unit Sales - Sales Quantity Current
Is the unit amount of sales for a specific item number that is scanned at a store level register. Includes all returns (total store returns) at store level. If there are no sales when this value shows up as a negative sales amount.
Unit Sales PY - Sales Quantity PY
Unit Sales Chg - Sales Quantity YOY
Unit Sales % Chg - Sales Quantity YOY %
Retail Price Measures
Avg Retail Price - Average Retail Price
Average Retail Price for the given time period selected.
Avg Retail Price PY - Average Retail Price PY
Avg Retail Price Chg - Average Retail Price YOY
Avg Retail Price % Chg - Average Retail Price %
Store Count Measures
Valid Store Count - Valid Store Count
Calculated measure to determine the unique valid stores for the time period selected.
Valid Store Count PY - Valid Store Count PY
Valid Store Count Chg - Valid Store Count YOY
Valid Store Count % Chg - Valid Store Count YOY %
Velocity Measures
$/S/W - Velocity Sales (Stores w/ Sales)
Calculated measure to determine the total Sales Amount per Stores with Sales for the given time selection.
$/S/W PY - Velocity Sales (Stores w/ Sales)PY
$/S/W Chg - Velocity Sales (Stores w/ Sales) YOY
$/S/W % Chg - Velocity Sales (Stores w/ Sales) YOY %
U/S/W - Velocity Units (Stores w/ Sales)
Calculated measure to determine the total Unit Sales Amount per Stores with Sales for the given time selection.
U/S/W PY - Velocity Units (Stores w/ Sales) PY
U/S/W Chg - Velocity Units (Stores w/ Sales) YOY
U/S/W % Chg - Velocity Units (Stores w/ Sales) YOY %
Stores Scanning Measures
POS Stores - Stores Scanning
Calculated measure to determine the number of stores where the Sales Quantity is greater than 0.
POS Stores PY - Stores Scanning PY
POS Stores Chg - Stores Scanning YOY
POS Stores % Chg - Stores Scanning YOY %
Replenishment & Pipeline Measures
In-stock - In Stock Replenishment % (Store) Current
Calculated metric to determine the Repl Instock % at the store / item level or In Stock % (Store)
In-stock PY - In Stock Replenishment % (Store) PY - or In Stock % (Store)PY
In-stock Chg - In Stock Replenishment % (Store) YOY or In Stock % (Store) YOY
In-stock Point Chg - In Stock Replenishment % (Store) YOY % or In Stock % (Store) YOY %
Unit Inventory (Store + DC) - Store Pipeline Quantity
This is a calculation: sum of (On hand Qty + On Order Qty + In Transit Qty + In Warehouse Qty).