...
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.
...
...
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
Then you can begin to import your files
Sample files
Here are the download links to the sample csv files:
Contacts csv file: https://drive.google.com/file/d/1Id_YkeMrBszINxofdAs7HR90LLGjeVQJ/view?usp=sharing
Session Attendance csv file: https://drive.google.com/file/d/1Iok1EDcrD0gD66Mcph3dIOLvEnd7dWMs/view?usp=sharing
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
Then you can begin to import your files