Log in from a computer to take this course

You'll need to log in from a computer to start Learn Intermediate SQL for Marketers and Product Managers. But you can practice or keep up your coding streak with the Codecademy Go app. Download the app to get started.

apple storegoogle store
Learn

We could use SQL to calculate the percent change between each question, but it’s just as easy to analyze these manually with a calculator or in a spreadsheet program like Microsoft Excel or Google Sheets.

If we divide the number of people completing each step by the number of people completing the previous step:

Question Percent Completed this Question
1 100%
2 95%
3 82%
4 95%
5 74%

We see that Questions 2 and 4 have high completion rates, but Questions 3 and 5 have lower rates.

This suggests that age and household income are more sensitive questions that people might be reluctant to answer!

Instructions

We learned how to build a funnel from a single table. Next, let’s see how we compare funnels for A/B Testing.

Sign up to start coding

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?