| daily_average | median | q1 | q3 | iqr | sd |
|---|---|---|---|---|---|
| 449 | 320 | 200 | 520 | 320 | 404 |
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 | 2,420 | 16 | 184.0 |
| 4 | 2,920 | 17 | 305.0 |
| 5 | 2,070 | 15 | 168.0 |
| 6 | 1,800 | 15 | 180.0 |
| 7 | 1,570 | 13 | 154.0 |
| 8 | 3,350 | 27 | 271.0 |
| 9 | 2,670 | 24 | 231.0 |
| 10 | 4,850 | 39 | 393.0 |
| 11 | 5,100 | 34 | 463.0 |
| 12 | 4,910 | 30 | 366.0 |
| 13 | 1,710 | 22 | 174.5 |
| month | monthly_net_revenue | monthly_transactions | monthly_liters |
|---|---|---|---|
| 1 | 6,570 | 44 | 595.0 |
| 2 | 8,790 | 70 | 773.0 |
| 3 | 17,530 | 127 | 1453.0 |
| 4 | 1,710 | 22 | 174.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 | 1210 |
| 4 | 200 |
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 | 1,750 |
| Ian Kimori | s022 | Kenyatta | 200 | 9 | 1,620 |
| Peter Ngugi | s098 | New location | 48 | 1 | 1,400 |
| Evans Nganga | s002 | New location | 140 | 7 | 1,370 |
| Kennedy Maingi (Bonny) | s019 | Molo 220 | 85 | 7 | 1,370 |
| Susan Kamau | s034 | Independence church- Kenyatta | 165 | 6 | 1,350 |
| Viv’s Pub | s004 | New location | 90 | 4 | 1,300 |
| Rose Nyambati | s024 | Kenyatta | 120 | 6 | 1,100 |
| Jose Boda | s028 | Njenga Karume | 100 | 5 | 1,000 |
| Brian Masero | s001 | Kenyatta | 120 | 6 | 950 |
| Wangari Naomi | s008 | New location | 65 | 11 | 870 |
| Eunice Nyaa | s051 | Kenyatta | 100 | 2 | 870 |
| Emily Gitundu | s029 | Kenyatta | 80 | 4 | 800 |
| Davis Nyabuto | s047 | Kenyatta | 80 | 2 | 730 |
| Paul Onchoke | s012 | Treasure | 40 | 2 | 650 |