This section shows weekly net revenue after subtracting expenditure, 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 | 2520 | 17 | 305 |
| 5 | 1920 | 15 | 168 |
| 6 | 1550 | 15 | 180 |
| 7 | 810 | 6 | 87 |
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 |
|---|---|---|---|---|---|
| Kennedy Maingi (Bonny) | s019 | Molo 220 | 41 | 3 | 850 |
| Githaiga Advocate | s031 | Kenyatta | 90 | 1 | 750 |
| Evance | s002 | New location | 80 | 4 | 700 |
| Brian Masero | s001 | Kenyatta | 80 | 4 | 650 |
| Viv’s Pub | s004 | New location | 60 | 3 | 600 |
| Jose Boda | s028 | Njenga Karume | 60 | 3 | 600 |
| Wangari (Mama Mboga) | s008 | New location | 30 | 4 | 520 |
| Ian Kimori | s022 | Kenyatta | 60 | 3 | 520 |
| Paul Onchoke | s012 | Treasure | 20 | 1 | 500 |
| Chris driver | s015 | New location | 20 | 1 | 450 |
| Fidelis Wairimu Mburu | s010 | New location | 40 | 2 | 420 |
| Susan Kamau | s034 | Independence church- Kenyatta | 50 | 2 | 400 |
| Winnie Wanjiru | s006 | New location | 20 | 2 | 350 |
| Postbank | s026 | Maziwa house | 40 | 1 | 350 |
| Davis Nyabuto | s047 | Kenyatta | 40 | 1 | 330 |