Before you start
- Have your CSV export. Use a Survey responses export you saved from Delighted before it closed.
- Have your People in GainTrace. An import only matches respondents. It never creates People or Companies. Sync your CRM or import your People and Companies first, so each respondent’s email finds a home. A respondent GainTrace can’t match to a Company is skipped, with a reason.
- Know your measures. Delighted exports can mix survey types. GainTrace imports NPS, CSAT and CES.
Import your history
1
Open the import
Go to Surveys > Data sources, find Import from other survey tools, and choose Import a CSV file.
2
Choose the Delighted format
Keep Delighted export as the file format and choose your file.
3
Check the column mapping
GainTrace suggests which of your columns is Email, Score, Response date and Comment, and optionally Response ID. Look at every one. GainTrace guesses Delighted’s column names from what is publicly known, and Delighted’s own help site is no longer available to check them against, so confirm each guess against your file.
4
Set the measure and scale
Choose From the Survey type column to import each row as its own survey type, or choose NPS, CSAT or CES for the whole file. For CSAT and CES, set the scale to 1 to 5 or 1 to 7. NPS is always 0 to 10.
5
Import
Check the preview of the first rows and the count of rows that can’t be imported, then choose Import.
Importing twice is safe
If the file has a Response ID column that you map, that ID identifies each row. Without one, GainTrace identifies a row by its email, score, date and measure. Importing the same file again, or an overlapping export, updates changed rows and never duplicates them.If you script it
If you’d rather load history from your own code, send each response toPOST /api/v1/nps-responses with a secret server API key, provider set to delighted and the Delighted response ID as externalId. It dedupes against the CSV import when the CSV has a Response ID column that you mapped. See the Surveys API.
Rebuild your survey
Imported history doesn’t recreate your survey, so set up what comes next:- Create an NPS survey from a template. See Build a survey.
- Set the Days between surveys for one person rule so cadence matches what you used before. See Survey rules.
- Choose how people get it: email invitations, a recurring Flow or an in-app survey.