The Import Feedback feature allows you to import feedback data collected via other software to Retently, automatically aggregate it to include existing data and avoid any blind spots in your NPS trend.
To access the feedback import option, click the settings menu icon and choose the Import Feedback page.
On the Import Feedback page you will be asked to perform 4 steps:
- Create or select an existing campaign
- Upload the CSV file
- Map your data
Below we will cover each of the steps and guide you through the entire process of feedback import.
1. Create/Select campaign
You need a survey campaign to be able to import the feedback stored in the CSV file.
At the first step you will be asked to either select or create a campaign to import the feedback in. Make sure the campaign has a survey template assigned. The campaign can be active or paused, as well as of any type: email, in-app, survey by link or Intercom.
2. Upload CSV file
Moving next, you will have to upload a CSV file with your feedback. You can either drag a file from your computer and drop it in the upload designated area, or simply hit the Click to upload button to choose the file from your computer.
The file must include at least your respondents’ email addresses and the survey scores (on a scale from 0 to 10) to be valid.
3. Map your data
Once uploaded, you will be asked to map the data from the CSV file to Retently properties. Apart from the required fields (email address and rating), you will be able to map additional columns such as text feedback, sent/opened/responded date, feedback tags, customer properties, and more. You can select default customer properties or create custom ones to match your CSV data. Learn more about custom properties and how they work here.
Make sure to map as much data as you consider useful for future convenience. If you have at least one of the date properties (sent, opened, responded date) available in your CSV file, we highly recommend mapping them accordingly. This will turn helpful when a customer has multiple feedback records in the CSV file. Hence, you make sure the responses are imported in the correct order, and maintain consistency of your data.
If none of the feedback date property is mapped, you will be able to choose a response date in the last, Import section, under Settings. By default, the imported feedback will display the current date, as the date when the survey was responded to. You can choose a different date from the calendar picker, if needed.
If at least one of the date options are mapped, you will be displayed only a short piece of information on the import section as per the image below.
Moving next, hit the Import button to complete the upload of the CSV file. It may take a while depending on how much feedback data you have.
Viewing the imported feedback
The imported feedback will be available on your Feedback page, along with existing customer feedback. The imported feedback will be counted in your NPS score and other data displayed on the Dashboard.
The survey respondents will be imported in Retently along with their feedback. For existing customers, only the feedback and the attached tags will be updated.
On the Outbox page, each feedback record will be labeled “IMPORTED” to indicate that the data was imported from an external source and not collected in Retently. The record will also store the name of the campaign, the survey channel, and the subject line of the assigned survey template. The statuses sent/opened/responded will have the date of the CSV import or the specific date attached.