Olist marketplace · Sales & Operations
Jun 2018 had the lowest late share of any month in the window (1.2%), so the rise looks bigger than it is: Jul 2018 is still below both the 12-month pooled late share (Aug 2017 – Jul 2018: 7.6%, all late orders over all delivered orders) and the median month (5.1%).
Portfolio project: the requirements are simulated (no real client),
the data is the public Olist dataset. Cards show July 2018, the last complete
month; definitions are in docs/dashboard_spec.md.
Whole analysis window. A step counts when its timestamp is filled in. The accent bar marks the biggest drop between two steps.
Complete weeks only; the shaded part is not drawn because order volume thins out at the very end of the data.
The top 15 categories bring 76.4% of GMV; Office furniture has the lowest review (3.62)
| # | Product category | GMV | Orders | Late % | Avg review |
|---|---|---|---|---|---|
| 1 | Health beauty | BRL 1.43M | 8,757 | 7.5% | 4.19 |
| 2 | Watches gifts | BRL 1.29M | 5,599 | 7.4% | 4.07 |
| 3 | Bed bath table | BRL 1.24M | 9,394 | 7.4% | 3.97 |
| 4 | Sports leisure | BRL 1.14M | 7,656 | 6.6% | 4.18 |
| 5 | Computers accessories | BRL 1.05M | 6,636 | 6.4% | 4.04 |
| 6 | Furniture decor | BRL 892k | 6,373 | 7.2% | 4.02 |
| 7 | Housewares | BRL 770k | 5,838 | 5.4% | 4.16 |
| 8 | Cool stuff | BRL 703k | 3,609 | 5.9% | 4.18 |
| 9 | Auto | BRL 677k | 3,863 | 7.3% | 4.11 |
| 10 | Garden tools | BRL 578k | 3,500 | 6.5% | 4.15 |
| 11 | Toys | BRL 552k | 3,833 | 6.4% | 4.21 |
| 12 | Baby | BRL 477k | 2,859 | 8.1% | 4.05 |
| 13 | Perfumery | BRL 445k | 3,120 | 6.6% | 4.21 |
| 14 | Telephony | BRL 393k | 4,175 | 7.1% | 4.01 |
| 15 | Office furniture | BRL 340k | 1,266 | 8.1% | 3.62 |
Late share runs from 2.8% in Amazonas to 21.5% in Alagoas; the biggest state, São Paulo, is at 4.5%
| # | Customer state | GMV | Orders | Late % | Avg review |
|---|---|---|---|---|---|
| 1 | São Paulo (SP) | BRL 5.86M | 41,021 | 4.5% | 4.21 |
| 2 | Rio de Janeiro (RJ) | BRL 2.11M | 12,654 | 12.1% | 3.91 |
| 3 | Minas Gerais (MG) | BRL 1.84M | 11,457 | 4.6% | 4.17 |
| 4 | Rio Grande do Sul (RS) | BRL 874k | 5,395 | 6.1% | 4.16 |
| 5 | Paraná (PR) | BRL 792k | 4,962 | 4.1% | 4.21 |
| 6 | Bahia (BA) | BRL 606k | 3,340 | 12.2% | 3.88 |
| 7 | Santa Catarina (SC) | BRL 606k | 3,590 | 8.2% | 4.10 |
| 8 | Distrito Federal (DF) | BRL 350k | 2,114 | 5.7% | 4.09 |
| 9 | Goiás (GO) | BRL 339k | 1,990 | 6.6% | 4.07 |
| 10 | Espírito Santo (ES) | BRL 322k | 2,014 | 10.7% | 4.06 |
| 11 | Pernambuco (PE) | BRL 319k | 1,636 | 9.6% | 4.02 |
| 12 | Ceará (CE) | BRL 273k | 1,316 | 13.8% | 3.87 |
| 13 | Pará (PA) | BRL 216k | 965 | 11.3% | 3.86 |
| 14 | Mato Grosso (MT) | BRL 186k | 900 | 6.0% | 4.11 |
| 15 | Maranhão (MA) | BRL 150k | 732 | 17.5% | 3.78 |
| 16 | Paraíba (PB) | BRL 140k | 530 | 10.5% | 4.02 |
| 17 | Mato Grosso do Sul (MS) | BRL 136k | 708 | 9.7% | 4.14 |
| 18 | Piauí (PI) | BRL 108k | 489 | 13.9% | 3.93 |
| 19 | Rio Grande do Norte (RN) | BRL 101k | 478 | 9.4% | 4.10 |
| 20 | Alagoas (AL) | BRL 96k | 409 | 21.5% | 3.77 |
| 21 | Sergipe (SE) | BRL 73k | 342 | 15.4% | 3.83 |
| 22 | Tocantins (TO) | BRL 61k | 278 | 9.9% | 4.11 |
| 23 | Rondônia (RO) | BRL 57k | 246 | 2.9% | 4.13 |
| 24 | Amazonas (AM) | BRL 28k | 147 | 2.8% | 4.22 |
| 25 | Acre (AC) | BRL 20k | 81 | 3.8% | 4.05 |
| 26 | Amapá (AP) | BRL 16k | 68 | 3.0% | 4.19 |
| 27 | Roraima (RR) | BRL 9.7k | 43 | 12.5% | 3.70 |
Tinted cells are measured against the average of all orders in the window (late 6.8%, review 4.12): teal is better, orange is worse, by more than 1 pp (late) or 0.1 points (review). The bar in the GMV column is relative to the largest row of the table. An order with items from several categories or sellers counts once in each.
| # | Seller (first 8 characters of the id) | GMV | Orders | Late % | Avg review |
|---|---|---|---|---|---|
| 1 | Seller 4869f7a5 (SP) | BRL 249k | 1,131 | 10.5% | 4.14 |
| 2 | Seller 7c67e144 (SP) | BRL 240k | 982 | 9.1% | 3.49 |
| 3 | Seller 53243585 (BA) | BRL 236k | 358 | 3.4% | 4.13 |
| 4 | Seller 4a3ca931 (SP) | BRL 235k | 1,804 | 9.7% | 3.83 |
| 5 | Seller fa1c13f2 (SP) | BRL 203k | 584 | 9.2% | 4.34 |
| 6 | Seller da8622b1 (SP) | BRL 185k | 1,314 | 6.6% | 4.17 |
| 7 | Seller 7e93a43e (SP) | BRL 177k | 331 | 4.7% | 4.25 |
| 8 | Seller 1025f0e2 (SP) | BRL 173k | 915 | 7.9% | 3.99 |
| 9 | Seller 7a67c85e (SP) | BRL 163k | 1,159 | 5.2% | 4.24 |
| 10 | Seller 955fee92 (SP) | BRL 161k | 1,286 | 6.1% | 4.16 |
| 11 | Seller 6560211a (SP) | BRL 151k | 1,847 | 5.3% | 3.95 |
| 12 | Seller 1f50f920 (SP) | BRL 142k | 1,403 | 8.9% | 4.14 |
| 13 | Seller 46dc3b2c (RJ) | BRL 136k | 509 | 5.9% | 4.22 |
| 14 | Seller a1043baf (MG) | BRL 133k | 715 | 5.0% | 4.23 |
| 15 | Seller cc419e06 (SP) | BRL 129k | 1,697 | 5.3% | 4.09 |