Dashboard Performance
Retention performance — KPI aktivitas (revenue, reorder, FU) di-filter periode; phase counts & LTV = real-time.
2026-05-06 → 2026-06-04
1. Active Performance Summary
Total Active Customer
497
phase Active
Active Revenue
Rp 4.098.579.580
dalam periode
Active Reorder
437
dalam periode
Active AOV
Rp 9.378.901
revenue ÷ reorder
Active Repeat Rate
89.7%
active dgn ≥2 order
Active Contribution
100.0%
% dari total revenue
Near Dormant Count
102
≥50 hari
Revenue at Risk Active
Rp 6.324.325.825
LTV near-dormant
2. Active Revenue Trend (6 bulan)
📈 Repeat Revenue Trend (6 bulan)
📊 Revenue by Category (stacked)
🔢 Reorder Count Trend
3. Active Cycle Summary (FU 1-3)
| Cycle | Customer di Cycle | Due Today | Done | Missed | Response Rate | Closing | Revenue |
|---|---|---|---|---|---|---|---|
| FU 1 | 312 | 0 | 185 | 0 | 37.8% | 35 | Rp 870.032.600 |
| FU 2 | 104 | 0 | 110 | 0 | 33.6% | 17 | Rp 71.653.100 |
| FU 3 | 81 | 0 | 20 | 0 | 100.0% | 19 | Rp 113.832.520 |
4. Active Progress by Team
| Team | Due | Done | Missed | Response | Closing | Closing % | Revenue | Compliance % |
|---|---|---|---|---|---|---|---|---|
| Team 2 | 0 | 259 | 0 | 109 | 61 | 23.6% | Rp 2.559.401.640 | 100.0% |
| Team 1 | 0 | 158 | 0 | 77 | 66 | 41.8% | Rp 1.539.177.940 | 100.0% |
5. Active Progress by Sales
| Team | Sales | Due | Done | Missed | Closing | Closing % | Revenue | Compliance % |
|---|---|---|---|---|---|---|---|---|
| Team 2 | Mustofa | 0 | 230 | 0 | 53 | 23.0% | Rp 2.436.589.200 | 100.0% |
| Team 1 | Eka | 0 | 158 | 0 | 66 | 41.8% | Rp 1.539.177.940 | 100.0% |
| Team 2 | Intan | 0 | 29 | 0 | 8 | 27.6% | Rp 122.812.440 | 100.0% |
6. Active Customer Detail (top 30, urut lama)
Customer Active — Sort by Last Order ASC30 baris
| Customer | Sales | City | Last Order | Days | Cycle | FU Due | Last Product | Last Revenue |
|---|---|---|---|---|---|---|---|---|
PT. Roti Indonesia Satu 6281807140696 | Eka | Jakarta Selatan | 25 Mar | 71 | FU 2 | — | — | Rp 1.020.000 |
KAYLA AZZAHRA 6281804228075 | Eka | Jakarta Pusat | 27 Mar | 69 | FU 2 | — | — | Rp 950.000 |
Paisal S Alparidji 6282138922090 | Eka | Pandeglang | 27 Mar | 69 | FU 2 | — | — | Rp 510.000 |
Quinta 6281327775872 | Eka | Salatiga | 28 Mar | 68 | FU 2 | — | — | Rp 1.430.000 |
Robi Mulyadi 6285158788706 | Eka | Karawang | 28 Mar | 68 | FU 2 | — | — | Rp 1.020.000 |
ika 6282134071245 | Eka | Malang | 28 Mar | 68 | FU 2 | — | — | Rp 10.580.000 |
tatamu cafe 6283149511094 | Eka | Purworejo | 28 Mar | 68 | FU 2 | — | — | Rp 650.000 |
ANJALY 62816289279 | Eka | Jakarta Barat | 01 Apr | 64 | FU 2 | — | — | Rp 6.737.500 |
Ahmad Fachri 6281318960358 | Eka | Karawang | 01 Apr | 64 | FU 2 | — | — | Rp 3.355.000 |
CV NUSANTARA PANGAN GEMILANG 6281232873102 | Eka | Surabaya | 01 Apr | 64 | FU 2 | — | — | Rp 304.200.000 |
Jimmy 628113899553 | Eka | Badung | 01 Apr | 64 | FU 2 | — | — | Rp 1.985.000 |
PT. Inti Selera Asia 6282211183939 | Eka | Surabaya | 01 Apr | 64 | FU 2 | — | — | Rp 2.760.000 |
Anastasia 6281314801806 | Eka | Bekasi | 01 Apr | 64 | FU 2 | — | — | Rp 3.082.500 |
ALDI 6285942575702 | Eka | — | 01 Apr | 64 | FU 2 | — | — | Rp 2.980.000 |
PT ADHYA BOGAINDO SEJAHTERA 6289632305330 | Eka | Jakarta Pusat | 02 Apr | 63 | FU 2 | — | — | Rp 715.000 |
INTANana Adithio 62818860887 | Eka | Kuningan | 02 Apr | 63 | FU 2 | — | — | Rp 9.300.000 |
Putri 6281296218976 | Eka | Balikpapan | 02 Apr | 63 | FU 2 | — | — | Rp 2.690.000 |
NASIH 6281318988705 | Eka | Bekasi | 02 Apr | 63 | FU 2 | — | — | Rp 4.245.000 |
Shirley 6282111119908 | Eka | Tangerang | 02 Apr | 63 | FU 2 | — | — | Rp 2.618.000 |
Sofyan M 6281287708833 | Mustofa | Surabaya | 06 Apr | 59 | FU 3 | — | — | Rp 935.000 |
MAYA 6282130007816 | Mustofa | Bekasi | 06 Apr | 59 | FU 3 | — | — | Rp 4.775.000 |
Elpiano Arip Saputera MAHATO 62852655597333 | Eka | Jakarta Barat | 06 Apr | 59 | FU 1 | — | — | Rp 11.088.000 |
Ani 6285782715329 | Eka | Tangerang Selatan | 06 Apr | 59 | FU 1 | — | — | Rp 1.770.000 |
Stanley 6281387758439 | Eka | Bogor | 06 Apr | 59 | FU 1 | — | — | Rp 6.831.000 |
medja restaurant 6287747537238 | Eka | Bogor | 06 Apr | 59 | FU 1 | — | — | Rp 1.650.000 |
ovan oma coffee 6281287465353 | Mustofa | Jakarta Selatan | 06 Apr | 59 | FU 3 | — | — | Rp 1.470.000 |
SUGA COFFEE 6285179771186 | Eka | Bekasi | 06 Apr | 59 | FU 1 | — | — | Rp 792.000 |
Yuri Coffe 6285261713839 | Mustofa | Medan | 06 Apr | 59 | FU 3 | — | — | — |
ZAKY 6281295318628 | Eka | Ketapang | 06 Apr | 59 | FU 1 | — | — | Rp 9.460.000 |
NAYA JIWA RAGA 6281266606382 | Mustofa | Padang | 06 Apr | 59 | FU 3 | — | — | Rp 3.696.000 |
7. Near Dormant Alert (≥50 hari sejak last order)
Near Dormant30 baris
| Customer | Sales | City | Days Since Order | Lifetime Revenue | Last Cycle Done | Action |
|---|---|---|---|---|---|---|
PT. Roti Indonesia Satu 6281807140696 | Eka | Jakarta Selatan | 71 | Rp 19.290.000 | FU 1 | Lanjut ke FU 2 |
KAYLA AZZAHRA 6281804228075 | Eka | Jakarta Pusat | 69 | Rp 950.000 | FU 1 | Lanjut ke FU 2 |
Paisal S Alparidji 6282138922090 | Eka | Pandeglang | 69 | Rp 63.480.000 | FU 1 | Lanjut ke FU 2 |
Quinta 6281327775872 | Eka | Salatiga | 68 | Rp 13.207.500 | FU 1 | Lanjut ke FU 2 |
Robi Mulyadi 6285158788706 | Eka | Karawang | 68 | Rp 9.300.000 | FU 1 | Lanjut ke FU 2 |
ika 6282134071245 | Eka | Malang | 68 | Rp 126.325.000 | FU 1 | Lanjut ke FU 2 |
tatamu cafe 6283149511094 | Eka | Purworejo | 68 | Rp 7.660.000 | FU 1 | Lanjut ke FU 2 |
ANJALY 62816289279 | Eka | Jakarta Barat | 64 | Rp 6.737.500 | FU 4 | 🚨 Dormant transition imminent |
Ahmad Fachri 6281318960358 | Eka | Karawang | 64 | Rp 69.874.500 | FU 1 | Lanjut ke FU 2 |
CV NUSANTARA PANGAN GEMILANG 6281232873102 | Eka | Surabaya | 64 | Rp 969.155.000 | FU 1 | Lanjut ke FU 2 |
Jimmy 628113899553 | Eka | Badung | 64 | Rp 25.075.300 | FU 1 | Lanjut ke FU 2 |
PT. Inti Selera Asia 6282211183939 | Eka | Surabaya | 64 | Rp 76.530.800 | FU 1 | Lanjut ke FU 2 |
Anastasia 6281314801806 | Eka | Bekasi | 64 | Rp 7.060.000 | FU 1 | Lanjut ke FU 2 |
ALDI 6285942575702 | Eka | — | 64 | Rp 14.850.000 | FU 1 | Lanjut ke FU 2 |
PT ADHYA BOGAINDO SEJAHTERA 6289632305330 | Eka | Jakarta Pusat | 63 | Rp 4.480.000 | FU 1 | Lanjut ke FU 2 |
INTANana Adithio 62818860887 | Eka | Kuningan | 63 | Rp 11.800.000 | FU 1 | Lanjut ke FU 2 |
Putri 6281296218976 | Eka | Balikpapan | 63 | Rp 11.874.250 | FU 1 | Lanjut ke FU 2 |
NASIH 6281318988705 | Eka | Bekasi | 63 | Rp 4.245.000 | FU 1 | Lanjut ke FU 2 |
Shirley 6282111119908 | Eka | Tangerang | 63 | Rp 9.758.000 | FU 1 | Lanjut ke FU 2 |
Sofyan M 6281287708833 | Mustofa | Surabaya | 59 | Rp 127.327.000 | FU 4 | 🚨 Dormant transition imminent |
MAYA 6282130007816 | Mustofa | Bekasi | 59 | Rp 7.195.550 | FU 2 | Lanjut ke FU 3 |
Elpiano Arip Saputera MAHATO 62852655597333 | Eka | Jakarta Barat | 59 | Rp 163.181.000 | — | ⚠️ Belum ada FU |
Ani 6285782715329 | Eka | Tangerang Selatan | 59 | Rp 5.020.000 | — | ⚠️ Belum ada FU |
Stanley 6281387758439 | Eka | Bogor | 59 | Rp 71.741.400 | — | ⚠️ Belum ada FU |
medja restaurant 6287747537238 | Eka | Bogor | 59 | Rp 2.981.000 | — | ⚠️ Belum ada FU |
ovan oma coffee 6281287465353 | Mustofa | Jakarta Selatan | 59 | Rp 18.320.000 | FU 2 | Lanjut ke FU 3 |
SUGA COFFEE 6285179771186 | Eka | Bekasi | 59 | Rp 12.927.000 | — | ⚠️ Belum ada FU |
Yuri Coffe 6285261713839 | Mustofa | Medan | 59 | Rp 16.500.000 | FU 2 | Lanjut ke FU 3 |
ZAKY 6281295318628 | Eka | Ketapang | 59 | Rp 11.407.500 | — | ⚠️ Belum ada FU |
NAYA JIWA RAGA 6281266606382 | Mustofa | Padang | 59 | Rp 54.546.000 | FU 2 | Lanjut ke FU 3 |