Skip to content

CX‐Data‐Collection‐Data‐Format

Ryan Wold edited this page Jan 18, 2024 · 7 revisions

Before you upload your data file of survey responses, please review the following checklist. Touchpoints will validate the format of the CSV headers

  • File format is .csv
  • There are 17 fields in the data table, from column A to column Q.

The field names are:

Field Name CSV Column Range of Values Description
external_id A String External identifier
question_1 B String 0,1 thumbs up/down or 1,2,3,4,5
positive_effectiveness C String Positive Effectiveness*
positive_ease D String Positive Ease
positive_efficiency E String Positive Efficiency
positive_transparency F String Positive Transparency
positive_humanity G String Positive Humanity
positive_employee H String Positive Employee
positive_other I String Positive Other
negative_effectiveness J String Negative Effectiveness
negative_ease K String Negative Ease
negative_efficiency L String Negative Efficiency
negative_transparency M String Negative Transparency
negative_humanity N String Negative Humanity
negative_employee O String Negative Employee
negative_other P String Negative Other
question_4 Q String Question 4

Asterisk * indicates The positive and negative indicator questions (C-P) values can be: 0, 1, null for false, true, and not asked, respectively.

The first row of your csv should look like:

question_1, positive_effectiveness, positive_ease, positive_efficiency positive_transparency, positive_humanity, positive_employee, positive_other, negative_effectiveness, negative_ease, negative_efficiency, negative_transparency, negative_humanity, negative_employee, negative_other, question_4

If your dataset does not conform to this basic checklist here, please reach out to your HISP Portfolio Manager for support.

In Touchpoints, please attach only the survey data corresponding to the Collection Detail you just completed. If you have multiple post-transaction feedback surveys to report, you need to complete a corresponding collection detail for each survey.