Question
In the context of this exercise, how can we find out the percentage of users who went from browse to purchase?
Answer
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 21.03%.
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;