What does example supermarket sales data look like?


In conjoint analysis, when you want to accurately predict volumes, it can be helpful to calibrate conjoint preference scores to actual market volumes. For that, we need to use week-by-week supermarket sales data, which comes from third-party data vendors.

Below is an example data excerpt to demonstrate teh format of such data. In it, each row corresponds to sales of a particular SKU (including brand, packaging, and size) in a particular week in a particular channel (such as a supermarket chain).

Week SKU Channel Weight Value Units Distribution Average selling price % of units sold on promo
5 Oct 2020 Coca Cola - Cola - 50ml - can Tesco 50ml $16.2 M 5,182 K 97% $3.12 0
12 Oct 2020 Coca Cola - Cola - 50ml - can Tesco 50ml $16.7 M 5,589 K 95% $2.99 20.00%
19 Oct 2020 Coca Cola - Cola - 50ml - can Tesco 50ml $16.8 M 5,388 K 99% $3.12 0
26 Oct 2020 Coca Cola - Cola - 50ml - can Tesco 50ml $16.9 M 5,630 K 99% $3.00 17.45%
2 Nov 2020 Coca Cola - Cola - 50ml - can Tesco 50ml $17.8 M 5,720 K 100% $3.12 0
5 Oct 2020 Pepsi - Pepsi Cola - 50ml - can Tesco 50ml $19.9 M 6,456 K 96% $3.09 0
12 Oct 2020 Pepsi - Pepsi Cola - 50ml - can Tesco 50ml $20.3 M 6,583 K 98% $3.09 0
19 Oct 2020 Pepsi - Pepsi Cola - 50ml - can Tesco 50ml $20.8 M 6,734 K 99% $3.09 0
26 Oct 2020 Pepsi - Pepsi Cola - 50ml - can Tesco 50ml $21.0 M 6,805 K 95% $3.09 0
2 Nov 2020 Pepsi - Pepsi Cola - 50ml - can Tesco 50ml $18.7 M 6,036 K 97% $3.09 0
5 Oct 2020 Coca Cola - Cola - 100ml - bottle Tesco 100ml $25.0 M 5,955 K 97% $4.19 0
12 Oct 2020 Coca Cola - Cola - 100ml - bottle Tesco 100ml $28.1 M 7,082 K 96% $3.97 23.00%
19 Oct 2020 Coca Cola - Cola - 100ml - bottle Tesco 100ml $23.1 M 5,506 K 96% $4.19 0
26 Oct 2020 Coca Cola - Cola - 100ml - bottle Tesco 100ml $26.5 M 6,319 K 96% $4.19 0
2 Nov 2020 Coca Cola - Cola - 100ml - bottle Tesco 100ml $26.1 M 6,225 K 97% $4.19 0

This question from our users was answered on 29 October 2020. If there is anything else you'd like to know, please do not hesitate to contact us.