Summary KPIs
Filters: date range, source, cityTotal Revenue
₦455,150
12.4%vs prev period
Orders
3,034
8.1%
Unique Users
115,700
5.7%
Conversion Rate
2.62%
0.3%AOV ₦150
Revenue & Sessions
Back-office revenue joined on transaction_id with GA4 sessions
Search → Purchase Funnel
GA4 events joined on user_id
Sessions115,700
Product Views68,420
Add to Cart21,340
Checkout8,210
Purchases3,034
Total Customers
84,210
6.2%
Repeat Purchasers
34,510
9.8%41% of base
New This Week
1,204
4.1%
Avg LTV
₦412
3.4%
Segments
Filter: customer_id, city, segment
Repeat Purchaser Cohorts
Orders per customer distribution
1 order (new)49,700
2 orders18,420
3–5 orders11,240
6–10 orders3,610
10+ (VIP)1,240
Repeat Rate
41%
Avg Orders / Cust
2.3
Top Customers
Joined via DASS user_id
| ID | City | Orders | LTV |
|---|---|---|---|
| C-88214 | Lagos | 14 | ₦3,820 |
| C-74019 | Abuja | 11 | ₦3,140 |
| C-91245 | Port Harcourt | 9 | ₦2,680 |
| C-63302 | Ibadan | 8 | ₦2,410 |
| C-55817 | Calabar | 7 | ₦2,110 |
Data pipeline
GA4 + Back-Office → BigQuery → Dashboard
Join Keys
transaction_id · user_id
Last Sync
2 min ago