Mattresses and More users were asked to answer a five-question survey:
- “How likely are you to recommend Mattresses and More to a friend?”
- “Which Mattresses and More location do you shop at?”
- “How old are you?”
- “What is your gender?”
- “What is your annual household income?”
However, not every user finished the survey!
We want to build a funnel to analyze if certain questions prompted users to stop working on the survey.
We will be using a table called
survey_responses with the following columns:
question_text- the survey question
user_id- the user identifier
response- the user answer
Start by getting a feel for the
Select all columns for the first 10 records from
Delete your previous query.
Let’s build our first basic funnel!
Count the number of distinct
user_id who answered each
You can do this by using a simple
GROUP BY command.
What is the number of responses for each question?