Exporting Data
In this article:
FAQs
- Which Reports are available for export?
- Can I filter my data before exporting?
- Can I import data into my account?
- What does it mean if sent surveys are "suppressed," "exhausted," or "dispatched"?
Suggested next article: Reporting and Analytics Overview
Introductory video
-
Click CC to enable captions in Youtube. [Stop at 9:37]
All about exporting your data
We are simply stewards of your data. Your Admin and Standard users can export all, or a cogent subset of your data, including:
- Survey responses
- Sent surveys
- Scheduled surveys for each project
- Specific data sets:
- Trends
- Reports
- People page
-
Limited users do not have permission to export data. For more information about the three user types, check out Accounts and User Types.
Exporting in a CSV format
By default, all exports are downloaded in a comma-separated values (CSV) format, which can be opened by Excel, Numbers, and other spreadsheet applications — as in this example using Delighted's Google Sheets integration.
As seen above, the export file will include a row for every response that you’ve received and a column for every detail — from the score and comment, to the respondent’s contact information, to every property that you’ve passed along to Delighted.
Filters applied to your Dashboard will not be applied to the export.
Once you have a larger volume of responses (generally around 500), we’ll email you a link to download your export file rather than downloading your export file immediately. If you have any issues receiving the download link, be sure to let us know.
Interested in an XLSX format?
Upon request, we can switch your exports to XLSX — just send us a note and we can make that adjustment!
How to export your data
To export data:
- 1
- Head to your Dashboard
- 2
- Scroll down along the left side → and choose “Export data”
-
- 3
- Select your export type → ex. "Survey responses," "Sent surveys," "Scheduled surveys"
- 4
- Specify a date range for your export → ex. "This week" or "Next 7 days"
- 5
- Click "Export as CSV"
-
There are three export options:
| 1 | Survey responses export | A list of all survey responses that have been recorded in that project, with one row per response |
| 2 | Sent surveys export | A list of all surveys that have been sent or displayed to customers from that project, with one row per recipient |
| 3 | Scheduled surveys export | A list of all upcoming surveys that have been scheduled, but not yet sent from that project, with one row per recipient |
These exports will generate a CSV of the selected data, with a column containing a timestamp, person fields, and each property included on the survey. In the case of the survey responses and sent surveys export, a column for each answered question will be included.
Can I filter my data before exporting?
Filters set on your Dashboard will not be applied to an export.
We will always export all of the data from the time range selected. You can filter your data further in Google Sheets, Excel, or wherever you're analyzing your responses.
Can I import data into my account?
Our Concierge team can help you import data into your account if needed!
Whether you're trying to migrate data from one project to another, or you're looking to import historical data from another platform into Delighted, reach out to our Concierge team and we can discuss options for importing your data.
What does it mean if sent surveys are "suppressed," "exhausted," or "dispatched"?
Most sent surveys have the status of "surveyed," then "opened," then "responded," as the recipient follows the typical pattern of receiving and filling out the survey. However, you may see another status that indicates if a survey was not sent.
| Suppressed | A survey send will be suppressed if attempts to survey that recipient in the past have bounced, or if that recipient has previously unsubscribed from Delighted surveys. We will not attempt to re-send these surveys |
| Exhausted | A survey will be listed as "exhausted" if it was not sent due to your plan limits being hit. These survey sends will be queued and sent as soon as your billing period refreshes |
| Dispatched | Surveys with the status "dispatched" are waiting to be sent. Likely, these are SMS surveys that were scheduled outside of the Smart Scheduling timeline we employ. As soon as the recipient's timezone falls within our Smart Scheduling hours, we will send the SMS survey. If this is an Email survey, make sure that you've fully set up the Email platform |
Which Reports are available for export?
There are several places within the Delighted platform where you'll see the option to export data — each parsing its own related subset of data.
Report exports
On the Reports tab, you'll see an export button associated with each of the reports we offer. Follow the links below to learn more about what each of these exports includes!
- The Snapshot Report
- The Over Time Report
- The Pivot Table Report
- The Additional Questions Report
- The Benchmarks Report: The Benchmarks report cannot be exported
Trend exports
Your saved Trends can also be exported to a CSV file. Look along the left side of the page after you have opened a specific Trend.
Exporting a Trend as a CSV will give you a file with a row for every response that you’ve received and a column for every detail — from the score and comment, to the respondent’s contact information, to every property that you’ve passed along to Delighted that applies to that Trend. This is essentially a filtered version of the survey responses export.
| Survey responses export | A list of all survey responses that have been recorded in that project, with one row per response |
These exports will generate a CSV of the selected data, with a column containing a timestamp, person fields, and each property included on the survey. In the case of the survey responses and sent surveys export, a column for each answered question will also be included.