You want to import feedbacks in a survey.
It is possible to simply import feedbacks into a survey to solve numerous needs:
- Migration of surveys from one Skeepers account to another
- Migration of feedbacks from one questionnaire to another similar, activated survey
- Creation of "fake" feedbacks to try our analysis tools
- Recovery of feedbacks collected through an other platform than Skeepers
- Correction of incorrect feedbacks or feedbacks collected with the wrong attributes
Requirements
To have permissions "import.feedback" and "campaign.import.feedback.ftp" activated on the Skeepers account :
First of all, make sure you select a campaign that has similar questions, an activated broadcast and into which the feedbacks will be inserted.
Skeepers offers two different ways of importing feedback to a survey.
For occasional use, the first manual method is preferable. For recurring use, we recommend you to use FTP or API methods to import your feedbacks.
It is not possible to import feedbacks that are older than 2 years or dated prior to the creation of your Skeepers Feedback Management account.
Manual feedbacks import
- You can access through the manual feedback import through 'Settings' section of the left-hand sidebar of your Skeepers solution. Go to the 'Campaigns' category and click on 'Feedbacks Import'.
- Once this new window is open, choose the campaign from which you wish to import feedbacks from the campaign selection drop-down list. Note that more than one campaign can be selected. Once the campaign has been selected, click on the 'Download CSV template' button.
- Then, open this new CSV file named "Feedbacks import template.csv" and inspect it. Each column represents an element (feedback collection date, button, question, flag or attribute) of the selected campaign. The line with the "XXX" indicates the format expected in each cell. Once you have read this, you can delete the line and start filling in the file with compatible answers.
To ensure that your feedback matches the expected format, we recommend submitting a test feedback to your campaign, exporting it, and using it as a reference when filling in the CSV file.
It is important to scrupulously respect the format of the columns and the format of the values in the CSV template (rating scale, numerical value). If you do not need a column, do not delete it—simply leave it empty. Also, make sure to save the file in CSV UTF-8 format. If a cell containing a telephone number generates an error, add a single quotation mark (') before the + sign, for example: '+330600000000.
Once all the relevant feedbacks have been completed, return to the Skeepers platform and press the 'Upload your file' button, choosing the completed CSV template.
If the file has been validated, press the 'Start import' button and wait for the email notification to verify that the feedbacks have been imported successfully into your campaign. If the import fails, the errors will be detailed.
Feedbacks import via FTP
The second method of importing feedback to a campaign is for more recurring use.
- This function can be accessed within the specific campaign by pressing the campaign settings wheel. Then click on the 'Settings' button that has just appeared and go to the 'Feedbacks import' section.
- Configure the import according to your needs before pressing the 'Download CSV template' button. Follow then the procedure described in the previous section.
The third and final method for importing feedback into a campaign is intended for more frequent use. As this is the most complex solution to set up, we recommend using it only if you already use the Skeepers API (whose documentation is available here).
The API call to use for importing answers is detailed in this section of the API documentation.