In addition to Chart Report, collecting respondent details is an integral part of survey analysis. With Data Report in SurveyCake, it is possible to view or delete data, designate filter, sorting info and convert info for easy browsing. Excel and SPSS files can also be downloaded for further analysis or data storage! All responses can be found and reviewed using Data Report, accessible via survey backstage.
Here are the explanation of the commonly used features in Data Report:
You can view the complete details of your survey responses here!
When there is a sudden surge in usage of SurveyCake services, the system will automatically activate a response queuing protection mechanism. This will temporarily place responses in the Line-Up Responses to prevent server disconnection due to a sudden high traffic.
If you've enabled features such as Isolate By Response Time, Isolate Duplicates, or reCAPTCHA, responses identified as invalid by the system are placed in the Quarantine area, which helps you to separate them from valid responses.
You can conduct prize or lottery draws for your surveys without exporting your data. Simply use SurveyCake's built-in feature, Random Picker, to select random responses and directly pick the lucky winners from all of your survey responses!
Use the Find Duplicates feature to identify and compare duplicate response data, such as duplicate names, IP records, or email addresses.
In addition to the Find duplicates, you can also use Date Filter and Filter to view specific response.
Allows you to quickly share the survey response with others.
You can choose to display your data in three different formats: "Standard Format", "SPSS Format," or "Original Format."
Standard Format
Using the default system format, data is automatically converted into the most intuitive format, presenting each complete answer directly within its corresponding question field. This allows you to quickly review every data result.
SPSS Format
We will convert response data into a format compatible with SPSS software (converting all answers except text-based ones into numeric representations), enabling advanced analysis directly within SPSS.
Original Format
In original format, these three question types : Checkboxes、Ranking、Selection Based that have multiple possible answers will be presented in and Excel format makes them easier to analyse.
For checkboxes and selection-based questions, the choices are represented using numeric values, 1 and 0, to indicate whether each option was selected (1 for selected, 0 for not selected). In the case of ranking questions, the results are presented column by column based on the respondent's ranking.
You can export your detailed survey results into either CSV format or Excel format for further application or backup. Simply select your desired format, and you will obtain the corresponding CSV file or Excel file.
You can add additional information or notes to individual or multiple response data at any time.
If you wish to separate specific data from the general Data Report without deleting it, you can temporarily move that data to the Quarantine area.
Later, if you want to include that data back in the Data Report, simply select it in the Quarantine area, and then click the "Put it back to Data Report" button in the upper right corner.
11.Print
You can present individual or multiple survey responses in a vertical format, making it easy to print or export for further use.
In the printed PDF file, the complete details of one or multiple survey responses will be presented in details
If you wish to delete one or more survey responses, simply select the data you want to delete and then click the "Delete" button. hint~Notice : The deleted response(s) CANNOT be recovered.
FAQs
Why do some Numbers questions with more digits become 0 in certain parts of the response when exporting details to Excel? (For example, one response data contains an 18-digit number, but some digits become 0 after exporting to Excel)
It happened due to Excel's limitations and is not a malfunction of the Data Report feature.
Excel automatically converts digits beyond 15 characters into zeros when handling long numbers (you can refer here for further explanation). To address this problem, you can consider one of the following methods:
Refer to the official Excel documentation mentioned above for adjustments, such as formatting cells or adding quotation marks.
Upload the Excel file exported from your SurveyCake admin dashboard directly to Google Drive, and then open it using Google Sheets, which should display the complete numbers without truncation!
What should I do if exporting data to Excel keeps failing?
It is more likely caused by the volume of data that you are exporting.
Therefore, if you expect that your export data will exceed 180,000 records, it is recommended that you use filtering or date filtering functions to reduce the number of records exported each time, and then export them in batches!
Why can’t I see the response(s) in the Data Report but the respondents have already filled out and submitted the survey?
In general, as long as the respondent completes filling out the survey, presses the "Submit" button, and enters the thank-you page, it means that the survey response(s) has been successfully recorded. Therefore, you can instantly see the response data in the Data Report.
However, if you are certain that the respondent has indeed submitted the survey but you cannot see their response in the Data Report, it may be due to one of the following reasons:
Failure to disable previous Date Filter or Filter features
Since the Date Filter and Filter are automatically saved, if you haven't cleared any previous filters you've set, when you access the Data Report, it will display the response(s) that match those filters, not all of your survey response(s).
Therefore, you can simply go into the Date filter or Filter settings and click "Clear Filters" button to remove the filter and view all unfiltered data!
Enabling the "Responses Quality" feature, which automatically places specific response in Quarantine
If your survey has any of the "Responses Quality" features enabled (e.g.,Isolate By Response Time, Isolate Duplicates, or reCAPTCHA ), then you have actually received the data. However, the system has recognized it as invalid data and placed it in the Quarantine area, which is why it doesn't appear in the Data Report.
In this case, you need to go to the Quarantine area, select the data you want to move back to the Data report, and click "Put back to Data Report" button in the upper right corner.
Accessing the wrong survey Data Report
It's possible that you have multiple surveys with similar titles, and you entered the Data Report of the survey that the respondent did not submit. Make sure that you access the correct survey's Data Report to review the respondent's submitted response.
Share the survey using the preview mode URL
Please ensure that you share the official survey link, not the preview mode link. The preview mode is only for testing purposes and cannot collect real responses.
Why can't I see new responses?
Please go to the Account Setting and check if you are currently on the BASIC plan or not. If your current plan is BASIC, it is likely that the surveys you created had utilized PRO features while subscribing to PRO plan. After cancellingcanceling your subscription, you will not be able to view the responses collected through PRO features. If you want to view new responses, you can simply resubscribe to the PRO plan.
For more information, please refer to the Cancel Subscription.
Summary
Data Report provides easy data filtering and export for further analysis or data storage.
