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|
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!
We learned how to build a funnel from a single table. Next, let’s see how we compare funnels for A/B Testing.