DecisionGrade · Olist marketplace, Brazil

Order, delivery & customer performance

Built from the governed dbt marts. All values in Brazilian reais (R$).

Monthly net revenue

Item value of delivered orders, by purchase month

On-time delivery rate

Delivered on or before the promised date. Dashed line is the 85% SLA floor.

Late orders get far worse reviews

Average review score by how late the order arrived

Carrier transit vs seller handling

Average days per delivered order. The early-2018 slowdown was in transit.

Jun–Aug 2018 read low: the data ends in Oct 2018, so only faster orders from those months had arrived.

Top categories by net revenue

Seller tiers

Tiers need 20+ delivered orders. At risk: review below 3.5 or on-time below 80%. Top: review 4.3+ and on-time 93%+.

Delivery by customer state

Select a column to sort. States under the 85% on-time floor are flagged.

Definitions

Net revenue: item price on delivered orders. Freight is reported separately and is not revenue.

On time: delivered on or before the estimated delivery date shown to the customer.

Complete months: months with at least 500 orders (Jan 2017 to Aug 2018). Earlier and later months are partial.

Full formulas, owners and data-quality rules live in Governance/metric_definitions.md.