Survey Responses will be created and will be assigned to a Contact. You choose whether the survey response will be

• Assigned to an existing contact

• Assigned to a new automatically-generated contact - one for each row

Each survey response will appear in the purple box.

Open

Instructions for preparing CSV files to import Stories

Stories which are Survey Responses

When it comes to importing Survey Responses, create one csv file per type of survey per project. This is because the survey response stories will be imported into a single project at a time and linked to a specific Survey. (i.e. there should be one CSV file per Survey Campaign)

There should be columns as follows:

• Contact's Unique Identifier Code: this is the unique identifying code that relates to each person you work with. 

• Date survey was completed

• A column for each question in the survey

Therefore if someone completed the same survey twice, e.g. at the start of a programme and then at the end, there will be two rows for that contact in the CSV file. The Date survey was completed column will differentiate the responses.

Open

Sample files

Here are the download links to the sample csv files:

• Survey Responses csv file: https://drive.google.com/file/d/1IdmnmXLd2Yjhmi1uCmk0_OSgUOxl-9vr/view?usp=sharing  

• Master spreadsheet (saved in Google Sheets) that was used to generate each of the csv files: https://docs.google.com/spreadsheets/d/1u-AKY8eNXeCRBx6vxK7_kuYjCQdrajwRlhneXMW2pkI/edit?usp=sharing

Next steps

• Start by just preparing one of each type of csv file and send it to your Customer Success Executive.

• We will check that the format is correct

• Step 2 - Organise your import data

• Step 3 of 3: Import your data