Retail_HQ
/Basket Intelligence

Basket / Cart Intelligence

What customers buy together, attach rates, and cross-sell opportunities.

Avg basket
₦33,300
Baskets started
1,548
Paid baskets
1,284
Abandonment
17%
Attach rate
38%

Basket combinations

Highest lift today
Bread + Milk + Eggs
Avg basket
₦4.8k
+22%
Seen in 148 baskets today
Rice + Oil + Tomato Paste
Avg basket
₦12.4k
+31%
Seen in 92 baskets today
Paracetamol + Vitamin C
Avg basket
₦2.1k
+18%
Seen in 74 baskets today
Milo + Peak Milk
Avg basket
₦3.8k
+27%
Seen in 128 baskets today
Dettol + Handwash
Avg basket
₦2.6k
+15%
Seen in 66 baskets today
Indomie + Soft Drink
Avg basket
₦1.4k
+12%
Seen in 214 baskets today

Basket value distribution

<₦2k2–5k5–10k10–25k25–50k50–100k>100k

Cross-sell opportunities

Pair Peak Milk shoppers with Milo
Potential ₦1.2M / month · 62% overlap
Bundle Paracetamol + Vitamin C at Apo
Increase pharmacy basket by 18%
Weekend Indomie + Bigi Cola combo
Push at Wuse 2 checkout screens

Attach rate by category

  • Groceries42%
  • Beverages38%
  • Pharmacy31%
  • Household28%
  • Personal Care24%

High-value baskets

  • #RCP-88412 · Wuse 2₦218k
  • #RCP-88410 · Gwarinpa₦164k
  • #RCP-88405 · Wuse 2₦142k
  • #RCP-88401 · Apo₦96k

Branch basket comparison

  • Wuse 2₦38.2k avg
  • Gwarinpa₦32.1k avg
  • Apo Pharmacy₦21.8k avg
Abandoned baskets: 264 today · avg value ₦18,200
Basket trend
+4.8%13 weeks
Items / basket
6.8+0.3
Cross-sell rate
22%+1.4pp
Upsell rate
14%+0.6pp
Missed attach
₦4.2M
Promo influence
31%+3pp

Operational workspace — what is happening

Association matrix — top product pairs

Support / confidence / lift
Product AProduct BSupportConfidenceLiftRevenue
Peak MilkMilo12.4%62%2.8₦4.6M
BreadEggs10.1%58%2.4₦3.1M
Rice 10kgGroundnut Oil7.2%54%3.1₦6.8M
IndomieBigi Cola16.8%48%1.9₦2.2M
ParacetamolVitamin C5.4%41%2.6₦1.4M
DettolHandwash4.8%38%2.2₦1.1M

Purchase journey signals

Live feed
  1. Beverages attach risingToday
    +6pp when placed beside snacks
  2. Pharmacy bundle tractionToday
    Paracetamol + Vitamin C lift 2.6
  3. Missed attach detectedYesterday
    Rice sold without oil in 46% of baskets
  4. High-value baskets upThis week
    Baskets above ₦100k +18%
  5. Weekend patternThis week
    Family baskets dominate Saturday

Merchandising opportunity queue

6 in queue
Co-locate rice and oil
Projected +₦2.4M / month
Open
Milo end-cap beside dairy
62% overlap
Open
Pharmacy bundle signage
Apo counter
Open
Weekend snack combo
Indomie + Bigi Cola
Open
Checkout impulse reset
All branches
Open
Basket-builder prompt
POS cross-sell screen
Open

Analytics workspace — why is it happening

Average basket evolution

13 weeks
MonTueWedThuFriSatSun

Basket segmentation

Top-up34%
Weekly shop28%
Family bulk18%
Impulse12%
Pharmacy8%

Basket value distribution

<2k2–5k5–10k10–25k25–50k50–100k>100k

Upsell opportunity value (₦k / month)

Ranked
#1
Rice → Oil
2,400
#2
Dairy → Milo
1,200
#3
Snacks → Drinks
860
#4
Pharmacy bundle
640
#5
Cleaning duo
420

Time-of-day basket heat map

Heat map
08101214161820
Top-up
38
44
36
30
34
52
40
Weekly
12
26
42
38
40
58
30
Family
6
14
32
28
30
46
20
Impulse
22
30
38
34
32
48
26

Attach rate vs basket value

Correlation
ImpulseTop-upWeeklyFamilyPharmacyAttach rate %Basket value (index)

Category relationship strength

Comparative
Category ACategory BLiftTrend
GroceriesBeverages2.4Rising
FreshBakery3.0Stable
PharmacyPersonal care1.8Rising
HouseholdPersonal care1.5Falling

Management workspace — exceptions & approvals

Exception centre

3 open
Rice baskets missing oil attachMerchandising
46% of rice baskets lack the highest-lift companion product.
Impulse zone under-performingStore Ops
Checkout impulse attach fell 3pp after the last reset.
Household affinity weakeningCategory Lead
Household to personal-care lift down from 1.9 to 1.5.

Pending approvals

Awaiting sign-off
  • Adjacency change: rice and oil
    All branches
    Review
  • Pharmacy bundle pricing
    Apo · 5% bundle discount
    Review
  • Checkout impulse reset
    Merchandising budget
    Review

Manager action queue

Assigned
ActionOwnerDuePriority
Implement rice and oil adjacencyMerchandisingThis weekHigh
Refresh checkout impulse rangeStore OpsThis weekMedium
Launch pharmacy bundle at ApoCategory LeadNext weekMedium
Add cross-sell prompts at POSITNext sprintLow

Escalations

Routed upward
Household category affinity declineEscalated
Sustained fall requires assortment review.

Cross-sell experiment studio

· Simulated combination uplift
Peak Milk + Milo
Current attach31%
Potential attach46%
Revenue uplift₦2.8M/mo
Target branchGwarinpa
PlacementEnd-cap aisle 2
POS promptYes
Indomie + Soft Drink
Current attach24%
Potential attach38%
Revenue uplift₦1.9M/mo
Target branchWuse 2
PlacementCheckout gondola
POS promptYes
Bread + Milk + Eggs
Current attach18%
Potential attach29%
Revenue uplift₦1.4M/mo
Target branchAll branches
PlacementFresh food bundle
POS promptNo
Paracetamol + Vitamin C
Current attach12%
Potential attach22%
Revenue uplift₦640k/mo
Target branchApo
PlacementPharmacy counter
POS promptYes
Dettol + Handwash
Current attach27%
Potential attach35%
Revenue uplift₦780k/mo
Target branchWuse 2
PlacementPersonal care aisle
POS promptNo
Rice 5kg + Vegetable Oil
Current attach41%
Potential attach52%
Revenue uplift₦3.1M/mo
Target branchGwarinpa
PlacementBulk pallet
POS promptYes