| average | median | q1 | q3 | iqr | sd |
|---|---|---|---|---|---|
| 456.1 | 320 | 200 | 540 | 340 | 418.7 |
This section shows weekly net revenue after subtracting transport costs, alongside a summary of transactions and liters sold.
| week | net_revenue | total_transactions | liters_sold |
|---|---|---|---|
| 1 | 410 | 3 | 41.0 |
| 2 | 820 | 8 | 65.0 |
| 3 | 2420 | 16 | 184.0 |
| 4 | 2920 | 17 | 305.0 |
| 5 | 2070 | 15 | 168.0 |
| 6 | 1800 | 15 | 180.0 |
| 7 | 1570 | 13 | 154.0 |
| 8 | 3350 | 27 | 271.0 |
| 9 | 2670 | 24 | 231.0 |
| 10 | 4850 | 39 | 393.0 |
| 11 | 5400 | 35 | 493.0 |
| 12 | 2280 | 6 | 113.5 |
| month | monthly_net_revenue | monthly_transactions | monthly_liters |
|---|---|---|---|
| 1 | 6570 | 44 | 595.0 |
| 2 | 8790 | 70 | 773.0 |
| 3 | 15200 | 104 | 1230.5 |
Customer Growth
This section tracks how many new customers were added each month, helping visualize growth trends.
Retention & Churn
This section compares customers who returned for multiple visits versus those who only purchased once.
| month | total_transport |
|---|---|
| 1 | 620 |
| 2 | 800 |
| 3 | 1060 |
Revenue by Container Size
Payment analysis
| customer_name | customer_id | location | total_litres | total_visits | customer_lifetime_value_kes |
|---|---|---|---|---|---|
| Githaiga Advocate | s031 | Kenyatta | 190 | 3 | 1750 |
| Susan Kamau | s034 | Independence church- Kenyatta | 165 | 6 | 1400 |
| Peter Ngugi | s098 | New location | 48 | 1 | 1400 |
| Evans Nganga | s002 | New location | 140 | 7 | 1370 |
| Kennedy Maingi (Bonny) | s019 | Molo 220 | 85 | 7 | 1370 |
| Ian Kimori | s022 | Kenyatta | 160 | 7 | 1320 |
| Viv’s Pub | s004 | New location | 90 | 4 | 1300 |
| Brian Masero | s001 | Kenyatta | 120 | 6 | 950 |
| Wangari (Mama Mboga) | s008 | New location | 65 | 11 | 870 |
| Eunice Nyaa | s051 | Kenyatta | 100 | 2 | 870 |
| Rose Nyambati | s024 | Kenyatta | 100 | 5 | 850 |
| Jose Boda | s028 | Njenga Karume | 80 | 4 | 800 |
| Davis Nyabuto | s047 | Kenyatta | 80 | 2 | 730 |
| Chris driver | s015 | New location | 40 | 2 | 650 |
| Postbank | s026 | Maziwa house | 80 | 2 | 640 |