How can I find out how many people responded to my survey and how many just visited it without answering?
The Excel results spreadsheet (Results > Download responses as Excel sheet (.xlsx)) tells you how many people left at least one answer to one question: each row in the Respondents tab of the spreadsheet equals one respondent. Maptionnaire records all responses that respondents leave, even if they only answer one question.
To find out how many people visited the survey without answering, go to Team settings > Reports > Download questionnaires report as CSV. Please note that if you have several drafts and published questionnaires, it may take a moment for the report to be generated!
The report is in the CSV format, so you should open it in Excel and arrange its contents to columns (Data > Text to Columns > Delimited > Next > choose Comma and Tab > Finish). The resulting file should look similar to the image below (click it to make it larger).
One row represents one questionnaire. The All Respondents column includes the number of all visitors to the survey, including those who never left any responses. Submitted Respondents is the number of respondents who clicked the Done button at the end of the survey. The number of Visible Respondents with Any Meaningful Data tells you the number of respondents who left at least one answer. This number will match the number of rows in the Respondents tab in the results Excel.
What does 'Submitted' mean in the Excel spreadsheet of my survey's results? Why didn't all respondents submit their responses?
In the Excel sheet of results, the column titled Submitted tells you how many respondents clicked the Done button on the last page of the survey. Because clicking Done or even reaching the last page of the survey is not mandatory for responses to be saved, the number of people who submitted their answers is almost always lower than the number of rows in the Excel sheet.
Please sign in to leave a comment.