In the context of this exercise, how can we find out the percentage of users who went from browse to purchase?
To do this, we just need to find out the percentage of users from browse to checkout who went to purchase.
The percent of users from browse to checkout was 24%, and the percent of these users from checkout to purchase was 89%.
So, the percent from browse to purchase is simply 24% of 89%, or
.24 * .89 = .2103, or around
To calculate this using a query, rounded to 2 decimal places, you can modify the statement to the following,
SELECT ROUND( (100.0 * COUNT(DISTINCT c.user_id) / COUNT(DISTINCT b.user_id)) * (100.0 * COUNT(DISTINCT p.user_id) / COUNT(DISTINCT c.user_id)) / 100.0, 2) AS browse_to_purchase FROM browse b LEFT JOIN checkout c ON b.user_id = c.user_id LEFT JOIN purchase p ON c.user_id = p.user_id;