Learn
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!
Sign up to start coding
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.