96,478 delivered orders from Olist, Brazil's largest marketplace connector, Sep 2016 – Aug 2018. Fifteen queries built on CTEs and window functions; every figure below traces back to its query output.
Average rating collapses from 4.30 to 1.72 once an order runs more than two weeks past the promised date — a 2.58-point gap driven by logistics, not product quality.
I expected seller dispatch to be the bottleneck. It isn't — last-mile carrier transit is 74% of the timeline and 3.3× longer than seller handover. That reframes the fix from seller SLAs to carrier routing.
Ten lowest on-time rates, minimum 100 delivered orders.
Where shipping quietly erodes margin.
Grew steadily through 2017, then flattened across 2018.
Champions carry 39% of revenue on 38% of customers.
29 sellers of 2,970 generate a quarter of all revenue.
18 of 72 categories account for 80% of revenue.
| Category | Revenue | Share | Cumulative |
|---|