Retailer Data Overview

💡Use this handy guide to understand more about SKUtrak’s Asda connector.

Asda takes on pound stores with 50p offers

 

About this data source

SKUtrak collects data currently from the Asda Retail Link with the DSS (Decision Support System) application.

Each day, we gather metrics on supplier service (inbound metrics to Depot), Depot stock, waste, and store-level sales. Additionally, we separately collect data on store-level stock. Currently, we use bot accounts through Retail Link as the approved method for gathering this information.

Please note, Asda are replacing Walmart's Retail Link DSS reporting system with the Asda Data & Reporting (ADR) application. SKUtrak currently sources your Asda data from Retail Link DSS and we will be transitioning to use ADR. You can discover more on the latest status here.

 

Status page

Please use this link to access our status page on all retailer data feeds and please ensure to subscribe to our email updates.

 

Historical data overview: Asda

Use this matrix to see an overview of historical data available when SKUtrak is first connected, determined by the number of days or weeks of data available per measure.

Measure

Days

Weeks

Estate Level

Store Stock

1

 

Estate Level

Availability

1

 

Estate Level

Sales Value

31

102

Estate Level

Sales Volume

31

102

Estate Level

Average Price

31

102

Estate Level

Average Stores Ranged

1

 

Estate Level

Rate of Sale Volume

1

 

Estate Level

Rate of Sale Value

1

 

Estate Level

Lost Sales Value

1

 

Estate Level

Lost Sales Volume

1

 

Estate Level

Lost Sales % (Value)

1

 

Estate Level

Lost Sales % (Volume)

1

 

Depot Level

Depot Inbound %

1

 

Depot Level

Supplier Ordered

1

 

Depot Level

Supplier Matched

1

 

Depot Level

Supplier Credited

1

 

Depot Level

Depot Stock

1

 
       

Store Level

Sales Value

31

 

Store Level

Sales Volume

31

 

Store Level

Rate of Sale Value

1

 

Store Level

Rate of Sale Volume

1

 

Store Level

Store Stock

1

 

Store Level

Waste Value

28

 

Store Level

Waste Volume

28

 

Store Level

Wastage % (Value)

28

 

Store Level

Wastage % (Volume)

28

 

 

 

Asda data glossary:

Metric

Definition

Origin

Sales Value

Electronic Point of Sales (EPOS) value recorded

Retailer

Sales Volume

As above in units

Retailer

Rate of Sale Value (RoS)

EPOS daily sales value recorded for each store ÷ by either stores ranged or stores stocked

SKUtrak

Rate of Sale Volume (RoS)

As above in units

SKUtrak

Average Selling Price

Sales Value ÷ by Sales Volume

SKUtrak

Waste Value

Bin Waste at retail price

Retailer

Waste Volume

As above in units

Retailer

Waste Value %

Wastage Value as a % of Total Sales Value

Retailer

Waste Volume %

As above in units

Retailer

Availability %

The % of stores ranged where stock > 0

SKUtrak

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

Lost Sales Volume

As above, in units

SKUtrak

Lost Sales Value %

Lost Sales Value, as a % of Total Sales Value

SKUtrak

Lost Sales Volume %

As above in units

SKUtrak

Supplier Ordered

Number of cases ordered into depot

Retailer

Supplier Matched

Number of cases delivered into depot

Retailer

Supplier Credited

Number of cases not fulfilled

Retailer

Depot Inbound %

% of cases ordered which were fulfilled

SKUtrak

Depot Stock

Stock units in depot

Retailer

Store Stock

Stock units in store

Retailer

Average Stores Ranged

Total number of stores a product is ranged in

Retailer

 

 

 

FAQs

Q:  How are online sales broken out for Asda?

Current limitations in the dataset restrict our ability to separate out online sales for Asda.