SKUtrak Data Glossary

Learn more about the data available through SKUtrak

💡 Use this guide to help understand:

Metric definitions across Dashboards
Where the metric has originated from (Retailer or SKUtrak)
The most granular level of detail the metric works at
The amount of historical data available for the metric when SKUtrak is first connected

See the table below for a summary of each metric, as well as which Retailers the metric is available for:

Metric	Definition	Asda	Co-op	Morrisons	JS	Tesco	Waitrose
Sales Value	Electronic Point of Sales (EPOS) value recorded	✅	✅	✅	✅	✅	✅
Sales Volume	As above in units	✅	✅	✅	✅	✅	✅
Rate of Sale Value (RoS)	EPOS daily sales value recorded for each store ÷ by stores ranged	✅	✅	✅	✅	✅	✅
Rate of Sale Volume (RoS)	As above in units	✅	✅	✅	✅	✅	✅
Average Selling Price	Sales Value ÷ by Sales Volume	✅	✅	✅	✅	✅	✅
Waste Value	Bin Waste at retail price	✅	✅	✅	✅	✅	✅
Waste Volume	As above in units	✅	✅	✅	✅	✅	❌
Waste Value %	Wastage Value as a % of Sales Value	✅	✅	✅	✅	✅	✅
Waste Value (Markdown)	Total value of markdown reductions	❌	❌	✅	❌	❌	✅
Waste Value (Bin Waste)	Total value of bin waste at retail price	❌	❌	✅	❌	❌	✅
Waste Volume (Markdown)	Total volume of markdown reductions	❌	❌	✅	❌	❌	❌
Waste Volume (Bin Waste)	Total volume of bin waste at retail price	❌	❌	✅	❌	❌	❌
Waste Volume %	As above in units	✅	✅	✅	✅	✅	❌
Availability %	The % of stores ranged where stock > 0	✅	✅	✅	✅	✅	❌
Lost Sales Value	IF no stock showing in-store and no sales recorded on the day = Lost sales calculated by taking the average rate of sale on the day for stores with stock IF no stock showing in-store but some sales recorded on the day = Lost sales calculated by subtracting the amount sold from the average rate of sale for stores with stock	✅	✅	✅	✅	✅	❌
Lost Sales Volume	As above, in units	✅	✅	✅	✅	✅	❌
Lost Sales Value %	Lost Sales Value, as a % of Total Sales Value	✅	✅	✅	✅	✅	❌
Lost Sales Volume %	As above in units	✅	✅	✅	✅	✅	❌
Supplier Ordered	Number of cases ordered into depot	✅	✅	✅	✅	✅	❌
Supplier Matched	Number of cases delivered into depot	✅	✅	✅	✅	✅	❌
Supplier Credited	Number of cases not fulfilled	✅	✅	✅	✅	✅	❌
Supplier Service Level %	% of cases ordered which were fulfilled	✅	✅	✅	✅	✅	❌
Depot Ordered	Stock units ordered from depot into store on the original order date	❌	✅	✅	✅	✅	❌
Depot Matched	Stock units delivered from depot into store	❌	✅	✅	✅	✅	❌
Depot Credited	Stock units not fulfilled from depot into store	❌	✅	✅	✅	✅	❌
Depot Service Level %	% of stock ordered which was fulfilled from depot into store	❌	✅	✅	✅	✅	❌
Depot Stock	Stock units in depot	✅	✅	✅	✅	✅	❌
Store Stock	Stock units in store	✅	✅	✅	✅	✅	❌
Stock Cover	Number of days that current stock quantity in depot & store would last, based on the current sales forecast	❌	❌	✅	❌	❌	❌
Average Stores Ranged	Total number of stores a product is ranged in	✅	✅	✅	✅	✅	❌
Stores Selling	Total number of stores which sold a product on a given day	❌	❌	✅	❌	❌	❌
Sales Forecast	The sell-out sales forecast (in units)	❌	❌	✅	❌	❌	❌
Order Forecast	The retailer order forecast (in cases)	❌	❌	✅	❌	❌	❌

The specific details of the metrics (Origin, Lowest Grain, History Available) vary across Retailer, to see this detail, select a Retailer below:

Asda

Co-op

Asda data glossary:

Metric	Definition	Origin	Lowest Grain	History available
Sales Value*	Electronic Point of Sales (EPOS) value recorded	Retailer	Store	31 days
Sales Volume	As above in units	Retailer	Store	31 days
Rate of Sale Value (RoS)*	EPOS daily sales value recorded for each store	SKUtrak	Store	1 day
Rate of Sale Volume (RoS)	As above in units	SKUtrak	Store	1 day
Average Selling Price	Sales Value ÷ by Sales Volume	SKUtrak	Estate	97 weeks
Waste Value*	Bin Waste at retail price	Retailer	Store	31 days
Waste Volume	As above in units	Retailer	Store	31 days
Waste Value %	Wastage Value as a % of Total Sales Value	Retailer	Store	31 days
Waste Volume %	As above in units	Retailer	Store	31 days
Availability %	The % of stores ranged where stock > 0	SKUtrak	Estate	1 day
Lost Sales Value*	IF no stock showing in-store and no sales recorded on the day = Lost sales calculated by taking the average rate of sale on the day for stores with stock IF no stock showing in-store but some sales recorded on the day = Lost sales calculated by subtracting the amount sold from the average rate of sale for stores with stock	SKUtrak	Estate	1 day
Lost Sales Volume*	As above, in units	SKUtrak	Estate	1 day
Lost Sales Value %	Lost Sales Value, as a % of Total Sales Value	SKUtrak	Estate	1 day
Lost Sales Volume %	As above in units	SKUtrak	Estate	1 day
Supplier Ordered	Number of cases ordered into depot	Retailer	Depot	1 day
Supplier Matched	Number of cases delivered into depot	Retailer	Depot	1 day
Supplier Credited	Number of cases not fulfilled	Retailer	Depot	1 day
Supplier Service Level %	% of cases ordered which were fulfilled	SKUtrak	Depot	1 day
Depot Stock	Stock units in depot	Retailer	Depot	1 day
Store Stock	Stock units in store	Retailer	Store	1 day
Average Stores Ranged	Total number of stores a product is ranged in	Retailer	Estate	1 day

* = Metric calculation excludes VAT

Co-op Data Glossary:

Metric	Definition	Origin	Lowest Grain	History available
Sales Value*	Electronic Point of Sales (EPOS) value recorded	Retailer	Store	2 years
Sales Volume	As above in units	Retailer	Store	2 years
Rate of Sale Value (RoS)*	EPOS daily sales value recorded for each store	SKUtrak	Store	2 years
Rate of Sale Volume (RoS)	As above in units	SKUtrak	Store	2 years
Average Selling Price	Sales Value ÷ by Sales Volume	SKUtrak	Estate	2 years
Waste Value*	Bin Waste at retail price	Retailer	Store	2 years
Waste Volume	As above in units	Retailer	Store	2 years
Waste Value %	Wastage Value as a % of Total Sales Value	Retailer	Store	2 years
Waste Volume %	As above in units	Retailer	Store	2 years
Availability %	The % of stores ranged where stock > 0	Retailer	Estate	2 years
Lost Sales Value*	IF no stock showing in-store and no sales recorded on the day = Lost sales calculated by taking the average rate of sale on the day for stores with stock IF no stock showing in-store but some sales recorded on the day = Lost sales calculated by subtracting the amount sold from the average rate of sale for stores with stock	SKUtrak	Estate	2 years
Lost Sales Volume*	As above, in units	SKUtrak	Estate	2 years
Lost Sales Value %	Lost Sales Value, as a % of Total Sales Value	SKUtrak	Estate	2 years
Lost Sales Volume %	As above in units	SKUtrak	Estate	2 years
Supplier Ordered	Number of cases ordered into depot	Retailer	Depot	2 years
Supplier Matched	Number of cases delivered into depot	Retailer	Depot	2 years
Supplier Credited	Number of cases not fulfilled	Retailer	Depot	2 years
Supplier Service Level %	% of cases ordered which were fulfilled	SKUtrak	Depot	2 years
Depot Ordered	Stock units ordered from depot into store on the original order date	Retailer	Depot	2 years
Depot Matched	Stock units delivered from depot into store	Retailer	Depot	2 years
Depot Credited	Stock units not fulfilled from depot into store	Retailer	Depot	2 years
Depot Service Level %	% of stock ordered which was fulfilled from depot into store	SKUtrak	Depot	2 years
Depot Stock	Stock units in depot	Retailer	Depot	2 years
Store Stock	Stock units in store	Retailer	Store	2 years
Average Stores Ranged	Total number of stores a product is ranged in	Retailer	Estate	2 years

* = Metric calculation includes VAT

Morrisons Data Glossary:

Metric	Definition	Origin	Lowest Grain	History available
Sales Value*	Electronic Point of Sales (EPOS) value recorded	Retailer	Store	2 years
Sales Volume	As above in units	Retailer	Store	2 years
Rate of Sale Value (RoS)*	EPOS daily sales value recorded for each store	SKUtrak	Store	2 years
Rate of Sale Volume (RoS)	As above in units	SKUtrak	Store	2 years
Average Selling Price	Sales Value ÷ by Sales Volume	SKUtrak	Estate	2 years
Waste Value*	Bin Waste at retail price	Retailer	Store	2 years
Waste Volume	As above in units	Retailer	Store	2 years
Waste Value %	Wastage Value as a % of Total Sales Value	Retailer	Store	2 years
Waste Volume %	As above in units	Retailer	Store	2 years
Waste Value (Markdown)	Total value of markdown reductions	Retailer	Store	52 weeks
Waste Value (Bin Waste)	Total value of bin waste at retail price	Retailer	Store	52 weeks
Waste Volume (Markdown)	Total volume of markdown reductions	Retailer	Store	52 weeks
Waste Volume (Bin Waste)	Total volume of bin waste at retail price	Retailer	Store	52 weeks
Availability %	The % of stores ranged where stock > 0	Retailer	Estate	2 years
Lost Sales Value*	IF no stock showing in-store and no sales recorded on the day = Lost sales calculated by taking the average rate of sale on the day for stores with stock IF no stock showing in-store but some sales recorded on the day = Lost sales calculated by subtracting the amount sold from the average rate of sale for stores with stock	SKUtrak	Estate	2 years
Lost Sales Volume*	As above, in units	SKUtrak	Estate	2 years
Lost Sales Value %	Lost Sales Value, as a % of Total Sales Value	SKUtrak	Estate	2 years
Lost Sales Volume %	As above in units	SKUtrak	Estate	2 years
Supplier Ordered	Number of cases ordered into depot	Retailer	Depot	2 years
Supplier Matched	Number of cases delivered into depot	Retailer	Depot	2 years
Supplier Credited	Number of cases not fulfilled	Retailer	Depot	2 years
Supplier Service Level %	% of cases ordered which were fulfilled	SKUtrak	Depot	2 years
Depot Ordered	Stock units ordered from depot into store on the original order date	Retailer	Depot	78 weeks
Depot Matched	Stock units delivered from depot into store	Retailer	Depot	78 weeks
Depot Credited	Stock units not fulfilled from depot into store	Retailer	Depot	78 weeks
Depot Service Level %	% of stock ordered which was fulfilled from depot into store	SKUtrak	Depot	78 weeks
Depot Stock	Stock units in depot	Retailer	Depot	2 years
Store Stock	Stock units in store	Retailer	Store	28 days
Stock Cover	Number of days that current stock quantity in depot & store would last, based on the current sales forecast	Retailer	Estate	2 years
Average Stores Ranged	Total number of stores a product is ranged in	Retailer	Estate	2 years
Stores Selling	Total number of stores which sold a product on a given day	SKUtrak	Store	2 years
Sales Forecast	The sell-out sales forecast (in units)	Retailer	Store	2 years
Order Forecast	The retailer order forecast (in cases)	Retailer	Depot	2 years

* = Metric calculation includes VAT

Sainsbury's Data Glossary:

Metric	Definition	Origin	Lowest Grain	History available
Sales Value*	Electronic Point of Sales (EPOS) value recorded	Retailer	Store	6 weeks
Sales Volume	As above in units	Retailer	Store	6 weeks
Rate of Sale Value (RoS)*	EPOS daily sales value recorded for each store	SKUtrak	Store	6 weeks
Rate of Sale Volume (RoS)	As above in units	SKUtrak	Store	6 weeks
Average Selling Price	Sales Value ÷ by Sales Volume	SKUtrak	Estate	6 weeks
Waste Value*	Bin Waste at retail price	Retailer	Store	6 weeks
Waste Volume	As above in units	Retailer	Store	6 weeks
Waste Value %	Wastage Value as a % of Total Sales Value	Retailer	Store	6 weeks
Waste Volume %	As above in units	Retailer	Store	6 weeks
Availability %	The % of stores ranged where stock > 0	Retailer	Estate	6 weeks
Lost Sales Value*	IF no stock showing in-store and no sales recorded on the day = Lost sales calculated by taking the average rate of sale on the day for stores with stock IF no stock showing in-store but some sales recorded on the day = Lost sales calculated by subtracting the amount sold from the average rate of sale for stores with stock	Retailer	Estate	6 weeks
Lost Sales Volume*	As above, in units	Retailer	Estate	6 weeks
Lost Sales Value %	Lost Sales Value, as a % of Total Sales Value	SKUtrak	Estate	6 weeks
Lost Sales Volume %	As above in units	SKUtrak	Estate	6 weeks
Supplier Ordered	Number of cases ordered into depot	Retailer	Depot	6 weeks
Supplier Matched	Number of cases delivered into depot	Retailer	Depot	6 weeks
Supplier Credited	Number of cases not fulfilled	Retailer	Depot	6 weeks
Supplier Service Level %	% of cases ordered which were fulfilled	SKUtrak	Depot	6 weeks
Depot Ordered	Stock units ordered from depot into store on the original order date	Retailer	Depot	6 weeks
Depot Matched	Stock units delivered from depot into store	Retailer	Depot	6 weeks
Depot Credited	Stock units not fulfilled from depot into store	Retailer	Depot	6 weeks
Depot Service Level %	% of stock ordered which was fulfilled from depot into store	SKUtrak	Depot	6 weeks
Depot Stock	Stock units in depot	Retailer	Depot	6 weeks
Store Stock	Stock units in store	Retailer	Estate	6 weeks
Average Stores Ranged	Total number of stores a product is ranged in	Retailer	Estate	61 weeks

* = Metric calculation includes VAT

Tesco Data Glossary:

Metric	Definition	Origin	Lowest Grain	History available
Sales Value*	Electronic Point of Sales (EPOS) value recorded	Retailer	Store	2 years
Sales Volume	As above in units	Retailer	Store	2 years
Rate of Sale Value (RoS)*	EPOS daily sales value recorded for each store	SKUtrak	Store	2 years
Rate of Sale Volume (RoS)	As above in units	SKUtrak	Store	2 years
Average Selling Price	Sales Value ÷ by Sales Volume	SKUtrak	Store	2 years
Waste Value*	Bin Waste at retail price	Retailer	Store	2 years
Waste Volume	As above in units	Retailer	Store	2 years
Waste Value %	Wastage Value as a % of Total Sales Value	Retailer	Store	2 years
Waste Volume %	As above in units	Retailer	Store	2 years
Availability %	The % of stores ranged where stock > 0	Retailer	Estate	1 day
Lost Sales Value*	IF no stock showing in-store and no sales recorded on the day = Lost sales calculated by taking the average rate of sale on the day for stores with stock IF no stock showing in-store but some sales recorded on the day = Lost sales calculated by subtracting the amount sold from the average rate of sale for stores with stock	SKUtrak	Store	1 day
Lost Sales Volume*	As above, in units	SKUtrak	Store	1 day
Lost Sales Value %	Lost Sales Value, as a % of Total Sales Value	SKUtrak	Store	1 day
Lost Sales Volume %	As above in units	SKUtrak	Store	1 day
Supplier Ordered	Number of cases ordered into depot	Retailer	Depot	2 years
Supplier Matched	Number of cases delivered into depot	Retailer	Depot	2 years
Supplier Credited	Number of cases not fulfilled	Retailer	Depot	2 years
Supplier Service Level %	% of cases ordered which were fulfilled	SKUtrak	Depot	2 years
Depot Ordered	Stock units ordered from depot into store on the original order date	Retailer	Depot	2 years
Depot Matched	Stock units delivered from depot into store	Retailer	Depot	2 years
Depot Credited	Stock units not fulfilled from depot into store	Retailer	Depot	2 years
Depot Service Level %	% of stock ordered which was fulfilled from depot into store	SKUtrak	Depot	2 years
Depot Stock	Stock units in depot	Retailer	Depot	2 years
Store Stock	Stock units in store	Retailer	Store	2 years
Average Stores Ranged	Total number of stores a product is ranged in	Retailer	Estate	1 day

* = Metric calculation includes VAT

Waitrose Data Glossary:

Metric	Definition	Origin	Lowest Grain	History available
Sales Value*	Electronic Point of Sales (EPOS) value recorded	Retailer	Store	6 weeks
Sales Volume	As above in units	Retailer	Store	6 weeks
Rate of Sale Value (RoS)*	EPOS daily sales value recorded for each store	Retailer	Store	6 weeks
Rate of Sale Volume (RoS)	As above in units	Retailer	Store	6 weeks
Average Selling Price	Sales Value ÷ by Sales Volume	Retailer	Estate	42 days
Waste Value*	Bin Waste at retail price	Retailer	Store	42 days
Waste Value %	Wastage Value as a % of Total Sales Value	Retailer	Store	42 days
Waste Value (Markdown)	Total value of markdown reductions	Retailer	Store	42 days
Waste Value (Bin Waste)	Total value of bin waste at retail price	Retailer	Store	42 days

* = Metric calculation includes VAT