Learn
Usage Funnels
Results

Overall conversion rates:

browse checkout purchase browse_to_checkout checkout_to_purchase
775 183 163 0.236 0.890

How conversion rates change as we get closer to Christmas:

browse_date browse checkout purchase browse_to_checkout checkout_to_purchase
2017-12-20 100 20 16 0.2 0.8
2017-12-21 150 33 28 0.22 0.84
2017-12-22 250 62 55 0.24 0.88
2017-12-23 275 68 64 0.24 0.94

Oh wow, look at the steady increase in sales (increasing checkout_to_purchase percentage) as we inch closer to Christmas Eve!

Instructions

Congratulations!

In this lesson, we learned how to build a funnel from a single table, compare funnels for A/B tests, and create a funnel from multiple tables using LEFT JOIN.

If you are still unsure of the queries, make sure to go back and copy some queries in your notes before moving on!

Folder Icon

Sign up to start coding

Already have an account?