eCommerce KPI Assignments
Assignments mirror common retail analytics questions.
KPI focus:
- completed-order revenue (recognized revenue)
- repeat purchase behavior
- AOV by month
Assignment 1: Monthly Completed-Order Revenue #
Naming matters in interviews: summing order_total over completed orders only is completed-order revenue (recognized revenue), not GMV. True GMV counts all orders at the moment of placement, including ones later cancelled.
Loading SQL editor...
Assignment 2: Repeat Purchase Rate #
Loading SQL editor...
Assignment 3: AOV by Month #
Average order value (AOV) is completed-order revenue divided by completed-order count for the month. It answers a different question than total revenue: are customers spending more or less per order over time?
Loading SQL editor...
Warning
Production metric definitions vary by business:
- net sales vs gross sales
- return windows
- cancelled/refunded order treatment
Align KPI logic with finance definitions before publishing results.
Next Step #
Continue with:
- RFM Customer Segmentation
- Conversion Funnel Analysis
- then finish with the eCommerce Case Study Capstone