reep kpi dashboard

Retail Dashboard

Week Ending:29 November 2015

Nat. rep.4,755Unique Shoppers

164,359Indiv. Receipts

1.1 millionTotal Line Items

Key metrics

Data availablevia PC, tablet and

mobile

Table of Contents

Projected Market Share KPI per Customer

KPI per Receipts Received Over/Under Trading

Customer Switching Survey Profile

14 Sep 21 Sep 28 Sep 5 Oct 12 Oct 19 Oct 26 Oct 2 Nov 9 Nov 16 Nov 23 Nov 30 Nov 7 Dec

0%

2%

4%

6%

8%

10%

12%

14%

16%

18%

20%

22%

24%

26%

28%

30%

% of Total Moving Average of Price (w) (Market share)

29.7%

26.1%

26.5%

9.3%

8.4%

Kantar MarketShare:13 September 2015

Tesco: 27.7%Supervalu: 27.2%Dunnes: 25.4%Lidl: 10.1%Aldi: 9.7%

Kantar MarketShare:8 November 2015


Reep MarketShare:22 November2015


S.Valu Tesco Dunnes Aldi Lidl

Market Share 4 Wk Moving Avg

Revenue per customer

% chg v previous

Baskets per customer

% chg v previous

Items per basket

% chg v previous

Revenue per basket

% chg v previous

Revenue per item

% chg v previous -0.6%

1.73

8.3%

22.4

8.9%

13.0

0.0%

3.5

8.3%

78.2

3.6%

3.12

9.3%

26.3

5.6%

8.4

2.8%

4.4

12.4%

114.3

5.7%

2.12

8.8%

16.3

3.1%

7.7

4.7%

3.7

13.9%

60.5

12.5%

2.83

20.0%

14.6

6.8%

5.2

5.0%

4.2

26.0%

62.0

8.5%

2.44

14.8%

15.4

5.9%

6.3

2.8%

5.9

18.1%

91.3

5.3%

2.40

11.0%

18.7

5.5%

7.8

3.4%

13.2

14.8%

245.7

Month on MonthKPI: per Customer

Grand Total

Baby

Bakery

Drinks

FoodCupboard

Fresh Food

Frozen Food

Health &Beauty

Home & Ents

Household

Middle Isle

Pets

Grand Total 14.8%

7.7%

7.6%

16.8%

9.1%

17.9%

5.3%

12.5%

15.1%

18.3%

11.7%

-3.2%

18.1%

21.8%

17.9%

17.5%

12.1%

2.6%

4.7%

7.8%

24.4%

32.5%

6.8%

-0.7%

26.0%

-7.7%

83.4%

16.1%

0.9%

17.9%

5.2%

18.6%

20.8%

42.4%

19.5%

3.5%

13.9%

-8.1%

20.8%

11.9%

17.0%

20.7%

-5.0%

17.0%

1.6%

0.4%

8.7%

11.2%

12.4%

3.4%

0.0%

16.0%

5.8%

22.7%

16.8%

13.1%

11.0%

8.1%

8.0%

-9.5%

8.3%

5.3%

-12.2%

10.6%

-5.7%

34.0%

-10.4%

8.5%

8.9%

-2.2%

1.8%

22.2%

Month on MonthRevenue per Customer (% change)

Grand Total

AldiDun.. LidlS.ValuTesco

BabyBakeryDrinksFood CupboardFresh FoodFrozen FoodHealth & BeautyHome & EntsHouseholdMiddle IslePets

Month on Month

Aldi Dun.. LidlS.ValuTesco


Aldi Dun.. LidlS.ValuTesco


AldiDun.. LidlS.ValuTesco


AldiDun.. LidlS.Va..Tesco


AldiDun.. LidlS.Va..Tesco


AldiDun..LidlS.Va..Tesco


Category Revenue

Customer Numbers In Category

Customer Spend In Category

Category Penetraon

Total Customers

Shop Frequency

Spend per Shop

KPI: per Receipts Received

-1,395 3,255Down Up

Revenue

% Change

Contribution -202

-2.1%

9,241

Month on Month

Cat. custmrs

% Change

Contribution 467

4.9%

1,444 Rev per custo..

% Change

Contribution -669

-6.8%

6.40

Cat. penetrati..

% change

Contribution 196

2.0%

48.49%

CategoryFresh Food

Total Custom..

% change

Contribution 271

2.9%

2,978 Cust. frequency

% change

Contribution 427

4.8%

2.11 Spend per visit

% change

Contribution -1,096

-11.1%

3.03

KPI detail: per Receipts ReceivedRetailerTesco

SubcategoryFresh FruitChange in Revenue

(v. previous period)

Number of customersshopping in category

Avg Category Revenueper Customer

Category PenetrationTotal CustomersIn-Store

Avg No. of Visits perCustomer in Period

Avg Customer Spendper Visit

Aldi Dunnes Lidl S.Valu Tesco

Baby Baby Milk & Food

Baby Other

Bakery Bakery Other

Bread

Drinks Beer & Cider

Non-alcoholic drinks

Spirits

Wine

FoodCupboard

Crisps, Chocs & Sweets

Food Cupboard Other

Fresh FoodFresh Fruit

Fresh Meat, Deli & Dairy

Fresh Vegetables

FrozenFood

Frozen Desserts

Frozen Savoury Items

Health &Beauty

Haircare & Oral Care

Health & Beauty Other

Home &Ents

Flowers and Plants

N'papers, Mags & Tobacco

Household Household Other

Laundry, Paper & Tissues

Middle IsleMiddle Isle - N/A

Middle Isle Product

Pets Cat & Dog Food

Pets Other

105

125

76

117

35

14

120

151

127

22

103

83

144

125

97

167

80

73

97

101

125

130

131

106

116

130

87

158

105

98

79

86

60

81

106

95

109

64

69

68

113

133

100

97

86

78

100

85

91

90

78

81

71

111

115

103

126

117

173

75

90

76

144

122

126

107

106

92

88

59

125

112

104

106

76

135

164

66

66

57

14

128

141

60

29

147

70

215

57

33

234

57

40

4

158

79

95

87

89

95

77

134

114

92

110

683199

100

17188

143

118

82

90

110

79

36

70

43

140

NovemberOver/Under Trading by Category<90 indicates relative underperformance (red)

>110 indicates relative outperformance (green)

31 Aug 14 Sep 28 Sep 12 Oct 26 Oct

BakeryBread

Bakery Other

0.0%

20000.0%

40000.0%

60000.0%

0.0%

20000.0%

40000.0%

60000.0%

Sheet 54

31 Aug 7 Sep 14 Sep 21 Sep 28 Sep 5 Oct 12 Oct 19 Oct 26 Oct 2 Nov 9 Nov 16 Nov

Fresh Food

Fresh Fruit

Fresh Meat, Deli & Dairy

Fresh Vegetables

0

50

100

150

0

50

100

150

0

50

100

150

Fresh Food

Aldi Dunnes Lidl S.Valu Tesco

Historic Category Over/Under Index <90 indicates relative underperformance

>110 indicates relative outperformance

Retailer InThis Period

Retailer PrevPeriod

Aldi Aldi

D.Stores

Lidl

SuperValu

Tesco

D.Stores Aldi

D.Stores

Lidl

SuperValu

Tesco

Lidl Aldi

D.Stores

Lidl

SuperValu

Tesco

SuperValu Aldi

D.Stores

Lidl

SuperValu

Tesco

Tesco Aldi

D.Stores

Lidl

SuperValu

Tesco

35.09%

20.58%

14.99%

11.27%

18.07%

19.02%

43.03%

12.29%

17.61%

8.06%

23.17%

19.71%

27.59%

10.42%

19.11%

18.92%

20.38%

15.52%

26.84%

18.34%

22.03%

20.57%

14.62%

33.31%

9.47%

CategorisationFresh Food

Time PeriodMonthly

Numbers or spendCustomer spend

AldiDunnes StoresLidlSuperValuTesco

Customer Switching

Chord diagram indicates from where retailers have taken customers/spendversus previous period.

Table on right breaks out where each retailers' customers (by number or byspend) shopped in the previous month.

0% 10% 20% 30%

15 - 24

25 - 34

35 - 44

45 - 54

55 - 64

DublinRest of LeinsterMunsterConnacht and Ulster (part of)

0% 10% 20% 30%

15 - 24

25 - 34

35 - 44

45 - 54

55 - 64

0% 10% 20% 30%

15 - 24

25 - 34

35 - 44

45 - 54

55 - 64

0% 10% 20% 30%

15 - 24

25 - 34

35 - 44

45 - 54

55 - 64

0% 10% 20% 30%

15 - 24

25 - 34

35 - 44

45 - 54

55 - 64

Survey Profile: age group and region

0% 10% 20% 30%

15 - 24

25 - 34

35 - 44

45 - 54

55 - 64

Grand Total

reep kpi dashboard

Documents