Sales#
Sales Volume and Revenue
On 75% of days, there were up to 215 orders. On 5% of days, there were 45 or fewer orders. On 5% of days, there were 293 or more orders. There were also several days with over 400 orders.
On 75% of days, sales amounted to up to 33K R\(. On 5% of days, sales were 6.7K R\) or less. On 5% of days, sales were 49K R\( or more. There were also several days with sales exceeding 70K R\).
Most sales occurred in the evening (36% of all sales), while the fewest occurred at night (9%). Morning accounted for 23%, and afternoon for 32%.
The fewest sales occurred on Saturday (11%), while the most occurred on Monday (16%).
77% of all orders were placed on weekdays.
59% of orders received a review rating of 5.
The fewest orders received a rating of 2 (3%).
Orders with a rating of 1 were more common than those with ratings of 2 and 3.
92% of orders were not delayed.
63% of orders fell into the medium price category.
46% of orders were in the medium weight category, while 40% were lightweight.
59% of orders had a medium delivery time category.
51% of orders used installment payments.
75% of orders were paid with a credit card, while 20% used “boleto.”
Top 3 product categories by order volume: Bed Bath Table (9%), Health Beauty (9%), and Sports Leisure (8%).
Top 3 generalized categories by order volume: Electronics (27%), Furniture (18%), and Home & Garden (14%).
42% of sales were in São Paulo. 13% and 12% were in Rio de Janeiro and Minas Gerais, respectively. Other states accounted for 6% or less.
The city of São Paulo accounted for 16% of all sales, while Rio de Janeiro accounted for 7%. Other cities accounted for 3% or less.
The total value of installment orders was significantly higher than non-installment orders, despite similar order volumes. This means installment orders are more expensive, which is logical—installments allow customers to afford higher-value purchases.
Order Value
75% of orders had a value of up to 177 R\(. 5% had a value of up to 33 R\). 5% had a value of 445 R\( or more. There were also many outliers exceeding 1000 R\).
Non-delayed orders had lower average values than delayed orders.
Installment orders had much higher average values—customers using installments can afford more expensive purchases.
Although São Paulo had the most orders, it had the lowest average order value among top states.
The highest average order value was in the state of Pará.
The city of São Paulo had the most orders but not the highest order value. Rio de Janeiro ranked second in order volume but had high order values.
Among top cities by sales volume, Salvador had the highest average order value.
Orders with a rating of 1 had higher average values than others. Rating 2 ranked second. Conclusion: expensive orders received more 1 and 2 ratings.
Order Ratings
59% of orders received a rating of 5.
Peaks in high and low ratings were observed at night, especially on Thursdays.
Non-delayed orders had significantly higher average ratings than delayed orders.
Non-delayed orders had a higher share of 5 ratings, while delayed orders had more 1 ratings.
Faster deliveries correlated with higher ratings.
The lowest average rating was in the state of Maranhão.
Among top states by sales volume, Rio de Janeiro and Bahia had the highest share of 1 ratings.
Among top cities by sales volume, Rio de Janeiro and Porto Alegre had noticeably higher shares of 1 ratings.
Order Weight
75% of orders weighed up to 2 kg. 5% weighed up to 150 grams. 5% weighed 10 kg or more.
Delayed orders were heavier than non-delayed orders.
Installment orders were heavier than non-installment orders.
Among top states by sales volume, Mato Grosso had the heaviest average orders.
Among top cities by sales volume, Santos and Rio de Janeiro had the heaviest orders. Rio de Janeiro ranked second in order volume.
Orders with a rating of 1 were significantly heavier than others. Rating 2 ranked second. Conclusion: heavier orders received lower ratings.
Number of Products per Order
90% of orders consisted of a single product.
There were 2 anomalous orders with 20 and 21 products.
Non-delayed orders had slightly more products per order than delayed orders.
Orders with ratings of 1 and 2 had higher average product counts than others.
Product Price per Order
For 75% of orders, the average product price was up to 140 R\(. 5% had an average product price of 363 R\) or higher.
Delayed orders had higher average product prices.
Installment orders had significantly higher average product prices.
Among top states by sales volume, Pará had the highest average product price, while São Paulo had the lowest (despite having the most orders).
Among top cities by sales volume, the top 3 by product price were Brasília, Rio de Janeiro, and Salvador.
Number of Sellers per Order
99% of orders had only one seller.
Number of Categories per Order
99% of orders had only one category.