Clean QuestionPro Data Overview


Data Cleaning Tips

Abbreviations - Make sure to not put the same exact abbreviation on any 2 questions. If you use an abbreviation once you can not use it again.

Matrix Column Order - Matrix Column Order is required but not Matrix Row Order.

How Next/Save Affects Final Question and Abbreviation -If you leave Final Question and/or Abbreviation blank then the first column header value at the top will be put in these columns if you hit next /save/previous without entering a value in the field(s). If you enter the Final Question Text and not the Abbreviation it will place the Final Question text in the Abbreviation field. If you enter the Abbreviation Text and not the Final Question text it will place the first column header as the Final Question text.

Constant Sum Question Type - The first question will not have the first part of the answer, you will have to go to the raw file and add the answer to the question in the Final Question and Abbreviation so you know which one it is. On the other ones, you will have to add the question text from the previous question.

Rank Order/Drag and Drop Ranking Question Types - The first column name will be the question text instead of the actual value that is seen in the survey. You will have to go to the raw file and replace the first Column Name with the correct value.

Image Rating Question Type - The Image name does not load due to it being in the 2nd header. You will have to go to the raw file and replace the Column Name with the Image name.

Other Option â€“ You will need to add the question Text when you get to this question number. I usually copy the original question and put "Other" at the end.

*If you would like a more in-depth explanation about the Cleaning process then watch the Clean Other Survey Softwares's Data video to see the logic behind it all. If you still are having problems please reach out to support.


Question Type Notes

Video Time VizualSurvey Question Type Notes
2:52 Single Response
3:40 Multiple Choice
3:53 Single Response Matrix You will need to remove the question text from Matrix Row.   
11:03 Multiple Choice Matrix Watch the video to see what to do.
Matrix of Dropdown Menus  
Matrix Dropdown
6:30 Numeric  
7:36 Ranking  
2:09 Textbox  
Date  
Net Promoter  
Zip Code
   

.