​

Guide Overview

This guide is intended to highlight the Key Measures for you to utilize within Crisp Retail Analytics utilizing Scintilla 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) YOYor** 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).