Upload and Prep GetFeedback Data Overview


Data Prep Tips

Add Resp ID – The output file from GetFeedback does not come with a respondent ID so we will have to add on the Upload Data step. You can add a respondent ID field by going to Upload Data, Actions, Add Resp. ID. This will add a distinct ID for each respondent which is needed for the workflow.

Zip Code Question Type - If you asked any open-ended or single one type question asking for a Zip Code then select the Zip Code Question Type and the dashboard will show a Map instead of a list of Zip Codes.

New Question # – Each New Question #  will be a separate question/chart in the dashboard. Most question types will have 1 column per question but some question types such as Multiple Choice, Matrix and Ranking will have multiple columns for one question. In this case, you will have to group all of those columns together by giving it the same New Question #.

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


Question Type Crosswalk

Video Time GetFeedback   VizualSurvey New Question # Notes
9:00 Multiple Choice   Single Response
Single  
10:15 Multiple Choice - Allow Multiple Answers Multiple Choice
Grouped If you select the Allow multiple answer option then you will use Multiple Choice Question type and have to group all the columns together with the same New Question #. Make sure you realize the first column of this question type will have the question and not the answer option, you will have to fix this in the Clean Data step.
13:09 Rating Single Response Matrix or Single Response
Single or Grouped If you want each column to show as its own bar chart then use Single Response. If you want it to show as a Matrix Grid then select Single Response Matrix and group the columns together.
15:50 Short Answer   Textbox
Single
9:00 Picture Choice
Single Response Single      Acts the same as GetFeedbacks Multiple Choice. Just give it one number and select Single Response.
16:00 Rank   Ranking
Grouped Make sure you realize the first column of this question type will have the question and not the answer option, you will have to fix this in the Clean Data step.
10:10 Form   Textbox or Zip Code
Single If you ask for the Zip Code here then make it a Zip Code question type so you can see it in a Map. Make sure you realize the first column of this question type will have the question and not the answer option, you will have to fix this in the Clean Data step.
7:50 Form - Date Date
Single
12:15 Slider    Numeric
Single  
14:29 Multiple Choice Grid   Single Response Matrix
Grouped
14:00 Net Promoter Score Net Promoter Score Single
13:13 Like/Dislike   Single Response
Single Will need to change the 1 and -1 to Yes/Like and No/Dislike in the Clean Data step.
10:15 Include "Other" Option* Textbox
Single The Include "Other " option will need to be its own New Question number and the Textbox question type even though it is part of the other question.
15:38 Customer Effort Single Response or Numeric
Single You have the option to see it in a bar chart if you select Single Response or see the Average and other statistics if you select Numeric.
12:34 Customer Satisfaction Score Single Response or Numeric
Single You have the option to see it in a bar chart if you select Single Response or see the Average and other statistics if you select Numeric.