CX- Import External Data Into New Survey
- Go To: Login >> Customer Experience >> Analytics >> Manage Data >> Import
- Click on Sample Excel Document
- Fill the data as per the template
- Browse the file and click on Upload Data
No. When you import data, a new survey is created automatically. All questions and answers are also created as per the imported file format.
Yes. You can edit the survey, change the text for questions and answers. However, we recommend that you don't make any structural changes. If you make structural changes the data may get affected.
Every time you import data a new survey is created and the data is imported in the new survey. Data cannot be imported in to an existing survey even if the survey was created importing data in the same format. Please maintain the data file that you used to import data offline. To add more responses please add data to the same file and import the data again. A new survey will be created that will have the entire data.
Data can be imported from an excel (.xls) file format. First twenty six columns are reserved for system variables including some important data columns. Actual survey questions start from the 27th column (I) onwards.
- First Column (A): External Reference Variable column (Optional)
- Second Column (B): Timestamp column (Optional)
- Third Column (C): Time Taken (Optional)
- Fourth Column (D): Weight
- Fifth Column (E): Response Status
- Sixth Column (E): Custom Variable 1 (Optional)
- Seventh Column (F): Custom Variable 2 (Optional)
- Eigth Column (G): Custom Variable 3 (Optional)
- Ninth Column (H): Custom Variable 4 (Optional)
- Twenty Seventh Column (I): Question Type | Text (Required) - Actual Questions start from the twenty seventh column onwards.
Below is the list of supported question types to "Import External Data Into Existing Survey"
- Multiple Choice: Select One, Select Many, Drop Down Menu
- Text: Comment Box, Single Row Text, Numeric Input, Email Address, Contact Information
- Graphical Rating: Star rating, Text Slider, Numeric Slider, Thumbs UP/Down, Smiley-Rating
- Matrix Table: Multi-Point Scales, Checkbox/Multi-Select, Spreadsheet, Side-By-Side Matrix
- Ordering: Drag and Drop
- Misc: Date/Time, Calendar
- Customer Satisfaction: Net Promoter Score
- Data/Reference: Lookup Table
This feature/tools described here are available with the following license(s) :