Customer Intelligence
Segments, repeat behavior, loyalty growth, and visit trends.
Loyalty members
42,180
New today
184
Repeat rate
64%
Churn 30d
3.2%
Segments
New28%
Returning46%
Loyalty26%
Visit trend
Last 30 days1234567891011121314
Total visitsLoyalty visits
Top customers
| Customer | Tier | Visits | Spend MTD |
|---|---|---|---|
| Aisha Bello | Platinum | 24 | ₦1,840,000 |
| PrimeCorp Ltd (Corp) | Corporate | 8 | ₦4,120,000 |
| Segun Adeleke | Gold | 18 | ₦720,000 |
| Ngozi Okafor | Gold | 16 | ₦640,000 |
| Musa Ibrahim | Silver | 12 | ₦380,000 |
New vs returning — this week
New
1,280
+8.4% w/w
Returning
4,842
+3.1% w/w
Active customers
18,420+3.2%
Avg CLV
₦486k+4.1%
Visit frequency
2.8 / month+0.2
VIP customers
612+28
Dormant
3,140
Churn risk
8.4%
Operational workspace — what is happening
VIP customer register
Top lifetime value| Customer | Tier | Visits / mo | Avg spend | CLV | Last visit |
|---|---|---|---|---|---|
| Adaeze N. | Platinum | 6.2 | ₦96,400 | ₦4.2M | Today |
| Ibrahim K. | Platinum | 5.4 | ₦88,100 | ₦3.8M | Yesterday |
| Tolu A. | Gold | 4.8 | ₦62,300 | ₦2.6M | 2 days |
| Ngozi E. | Gold | 4.1 | ₦58,900 | ₦2.2M | Today |
| Sani B. | Gold | 3.6 | ₦54,200 | ₦1.9M | 5 days |
| Funke O. | Silver | 3.2 | ₦38,600 | ₦1.4M | 12 days |
Customer lifecycle events
Live feed- 28 tier upgradesTodayGold to Platinum migration
- Churn risk flaggedToday184 customers past their usual cycle
- Win-back responsesThis week62 dormant customers returned
- Referral spikeThis week94 new referred sign-ups
- Cohort maturingThis monthQ1 cohort now at 2.4 visits/month
Customer action queue
6 in queueWin-back campaign
3,140 dormant customers
VIP concierge outreach
612 members
Churn intervention
184 high-risk
Referral reward payout
94 qualifying
Birthday offer batch
This month
Data quality clean-up
1,240 incomplete profiles
Analytics workspace — why is it happening
Active customers vs frequency
7 periodsMonTueWedThuFriSatSun
RFM segmentation
Champions14%
Loyal26%
Potential22%
At risk21%
Dormant17%
Spend distribution (customers)
<10k10–25k25–50k50–100k100k+
Favourite categories (index)
Ranked#1
Groceries
92
#2
Beverages
78
#3
Fresh
66
#4
Pharmacy
58
#5
Personal care
44
Cohort retention heat map (%)
Heat map| M1 | M2 | M3 | M4 | M5 | M6 | M7 | |
|---|---|---|---|---|---|---|---|
| Q1 cohort | 100 | 82 | 71 | 66 | 62 | 60 | 58 |
| Q2 cohort | 100 | 84 | 74 | 68 | 64 | 62 | 0 |
| Q3 cohort | 100 | 86 | 76 | 70 | 0 | 0 | 0 |
| Q4 cohort | 100 | 88 | 0 | 0 | 0 | 0 | 0 |
Frequency vs spend
CorrelationGeographic distribution
Comparative| Area | Customers | Share | Avg spend |
|---|---|---|---|
| Wuse / Maitama | 7,240 | 39% | ₦42,100 |
| Gwarinpa / Life Camp | 6,180 | 34% | ₦36,800 |
| Apo / Lokogoma | 3,420 | 19% | ₦24,600 |
| Other | 1,580 | 8% | ₦19,400 |
Management workspace — exceptions & approvals
Exception centre
3 open184 customers at high churn riskCRM
High-value members past their typical repurchase cycle.
3,140 dormant customersMarketing
No transaction in 90 days, representing ₦96M of lapsed annual value.
1,240 incomplete profilesData
Missing contact data blocks targeted outreach.
Pending approvals
Awaiting sign-off- ReviewWin-back campaign budget₦3.2M
- ReviewVIP concierge programme612 members
- ReviewReferral reward increase₦2,000 per referral
Manager action queue
Assigned| Action | Owner | Due | Priority |
|---|---|---|---|
| Launch churn-intervention outreach | CRM | This week | High |
| Run the dormant win-back campaign | Marketing | Next week | Medium |
| Complete profile data clean-up | Data Team | Month end | Medium |
| Formalise the VIP service standard | Customer Experience | Next month | Low |
Escalations
Routed upwardChurn among Gold-tier membersEscalated
Highest-value segment showing early attrition signals.
Customer segment explorer
· Select a segment to inspect its behaviourCustomers
3,412
Avg basket
₦8,240
Repeat in 30d
24%
Preferred branch
Wuse 2
Behaviour
- First basket dominated by grocery staples
- Only 11% attach a pharmacy item
- Best converted with a second-visit voucher