Clean SurveyMonkey 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.

*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
1:37 Single Response
5:25 Multiple Choice
4:03 Single Response Matrix The first Matrix Row will be the question, you will need to go in the raw data and see what the value was in the 2nd header and put that value in the first Matrix Row field.
Multiple Choice Matrix The first Matrix Row will be the question, you will need to go in the raw data and see what the value was in the 2nd header and put that value in the first Matrix Row field.
6:15 Matrix of Dropdown Menu The first Matrix Row will be the question, you will need to go in the raw data and see what the value was in the 2nd header and put that value in the first Matrix Row field.
Matrix Dropdown
3:15 Numeric  
7:20 Ranking The first Column Name will be the question, you will need to go in the raw data and see what the value was in the 2nd header and put that value in the first Matrix Row field.
00:18 Textbox  
2:00 Date  
3:53 Net Promoter  
1:12 Zip Code
   

.