Understanding of reorder rate in 11/12 (sql, analyzing business metrics)


#1

https://www.codecademy.com/courses/sql-analyzing-business-metrics/lessons/advanced-aggregates/exercises/reorder-rate?action=lesson_resume


if the reorder rate as defined in 11/12, is high, does it mean large no. of orders are make by same people, then it should present most of orders are reorder, right? it should be opposite to the defination.



Replace this line with your code.


#2

I was also confused when reading the explanation of reorder rate, and I am on your side. I think that is a mistake or typo in the explanation.


#3

I agree that something is wrong here.

Say 20 different people ordered a product 1 time each (20 distinct orders, 20 distinct people). This would mean 100% first-time orders.

The number of people who made orders can't be greater than the number of orders (20 people, 30 orders for example). So the only other option is more orders than people (say, 20 orders, 5 people), and this could mean one of two pretty opposite cases:

  1. 1 person ordered 16 times and the other 4 only once each (few people reordering (1 of 5))
  2. each person ordered 4 times (many people people reordering (5 of 5))

Both of these cases would have the same "reorder_ratio", yet they're opposites based on my understanding of the ratio. So I'm missing something or the exercise is wrong.


#4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.