Who Keeps Buying — Dashboard

A Malaysian snack distributor's 300-outlet book, pulled apart by recurring vs one-off buying, channel performance, product fit, and delivery reliability.

What the December book looks like at a glance.

Revenue share by channel
Supermarket alone earns two-thirds of the book.
Revenue per shop by channel
A 53× gap between the top and the bottom channel.
Outlet concentration — who earns the revenue?
22 shops (7%) earn half the book. All 22 are Supermarkets.
Performance tier inside each channel
Minimarket shows the widest spread — anchors and at-risk side by side.
Urban vs rural revenue by channel
84% of revenue sits in 4 urban districts.
Gross margin % by channel
Margin is essentially flat — the difference is volume, not pricing.

Only 127 of 300 shops actually buy twice.

Recurring, festive, or leaving?
127 steady · 113 Christmas-only · 60 silent before Christmas.
Revenue share by purchase pattern
61% of revenue is recurring. The rest is a spike or a leak.
Steady revenue % by channel
Convenience Store is the loyalest; Sundry Shop is the weakest.
Quiet-before-Christmas shops by channel
Pre-churn shops are concentrated in Sundry and Minimarket.
Order frequency in December
81 shops ordered once. 102 shops ordered three or more times.
Top 20 quiet-before-Christmas shops — call this week
Ordered in the first half, then nothing. Classify: recover, lost, or disputed.

Same carton pushed into every shop, regardless of fit.

Revenue share by category
Festive Gift Packs + Premium = 56.6% of the book.
Price tier mix by channel
Every channel buys ~57% Premium — even Sundry Shop.
Category mix by channel
Visually identical rows — the flat-carton finding, in one picture.
Top 10 SKUs by revenue
The top 7 are all Festive Gift Packs.
Bottom 10 SKUs by revenue
Layer Cakes and Wafer Sticks sit at the tail of the range.
Gross margin % by category
Festive and Premium earn higher margin; Layer Cakes sit at the bottom.

Where the trucks go — and whether they arrive on time.

On-time delivery by district
Three rural districts break SLA. Kuala Langat shows rural can work.
On-time by channel
All channels clear 74%; Supermarket is the most demanding SLA.
Delivery breakdown by district
On-time vs slightly late vs very late, stacked.
Revenue by district
Petaling and Klang carry half the book between them.
Revenue per shop by district
Urban districts carry higher per-shop volume.
At-risk shops by channel
30 of 37 at-risk shops sit in Minimarket or Petrol Station.