This section shows weekly net revenue after subtracting delivery fees, alongside a summary of transactions and liters sold.
| week | net_revenue | total_transactions | liters_sold |
|---|---|---|---|
| 1 | 410 | 3 | 41 |
| 2 | 770 | 8 | 65 |
| 3 | 2250 | 16 | 184 |
| 4 | 2820 | 17 | 305 |
| 5 | 1920 | 15 | 168 |
| 6 | 680 | 7 | 77 |
Customer Growth
This section tracks how many new customers were added each week, helping visualize growth trends.
Retention & Churn
This section compares customers who returned for multiple visits versus those who only purchased once.
Container breakdown
Payment analysis
| customer_name | customer_id | location | total_litres | total_visits | customer_lifetime_value_kes |
|---|---|---|---|---|---|
| Githaiga Advocate | s031 | Kenyatta | 90 | 1 | 900 |
| Kennedy Maingi (Bonny) | s019 | Molo 220 | 41 | 3 | 850 |
| Evance | s002 | New location | 60 | 3 | 600 |
| Viv’s Pub | s004 | New location | 60 | 3 | 600 |
| Wangari (Mama Mboga) | s008 | New location | 30 | 4 | 520 |
| Ian Kimori | s022 | Kenyatta | 60 | 3 | 520 |
| Brian Masero | s001 | Kenyatta | 60 | 3 | 500 |
| Paul Onchoke | s012 | Treasure | 20 | 1 | 500 |
| Chris driver | s015 | New location | 20 | 1 | 450 |
| Fidelis Wairimu Mburu | s010 | New location | 40 | 2 | 420 |
| Jose Boda | s028 | Njenga Karume | 40 | 2 | 400 |
| Winnie Wanjiru | s006 | New location | 20 | 2 | 350 |
| Postbank | s026 | Maziwa house | 40 | 1 | 350 |
| Kinyozi | s021 | New location | 20 | 4 | 270 |
| Rose Nyambati | s024 | Kenyatta | 40 | 2 | 250 |