Clean SurveyGizmo Data
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.
Percentage Question Type – Numbers will not show up in data preview due to the formatting of the data but it will show up correctly in the dashboard.
*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|
|3:57||Single Response||Even though Contact Information is one question we need to assign each column with its own New Question #.|
|8:47||Single Response Matrix||Will need to remove the question text from the Matrix Row.|
|6:27||Multiple Choice Matrix||In the Matrix Row column, your text will be in this format First:Second:Third. You will need to delete the first part and third part only keeping the middle which is separated by colons, also make sure to delete the colons. This will leave you with just the matrix row value that was in your survey. It is ok if that matrix row is duplicated a few times.|
|9:21||Matrix of Dropdown Menus||In the Matrix Row delete the 2nd colon and everything after it. You will also need to replace the 1st colon with a dash. Make sure you do not have any dashes in your Matrix Row other then the dash you just put in that separates the answers.|
|10:37||Ranking||Delete the question text from the Column Name.|