Export responses: table and field descriptions

The export responses report for both 'request' & 'response' follows the naming conventions used in the data return API, as well as the API status page export. The most up-to-date fields are below.

As of September 2018 If you are using the existing export fields in a macro or script, you will need to make an update to reflect the last row in the table below.

Field

Description

request_id

Unique Connect Request ID

request_sent_at

UTC timestamp of request creation*

request_delivery_status

The state of the delivery of the email for this response, typically "Sent"

response_received_at

UTC timestamp of response receipt*

star_rating

1-5 star response from customer

comments

Denotes if the response included comments

reward_name

Name of the reward that was given

areas_for_improvement

An indication this particular area of improvement (AOI) was given in response

additional_question_response

The answer

ext_interaction_id

Unique ID created for survey request

external_url

Unique ID provided from Integrated CRM source

channel

Was interaction via phone / email / chat

tags

A collection of categories under which this interaction can be classified. (Provided via API)

brand

The brand the consumer experienced for this response

customer_name

Customer name input for survey send

request_sent_to

Customer email address input for survey send

employee_first_name

Employee First Name

employee_last_name

Employee Last Name

employee_email

Email address of the employee

employee_custom_id

External (client) identifier for Employee

employee_status

Employee status of account; Active, Confirmed, Unconfirmed

employee_employment_status

Employment status of the employee - full time or part time

employee_start_date

Employee start date provided by employee in profile

team_leader

The name of the team leader / manager associated with this request

team_leader_email_address

The client supplied email address of the manager of the employee

team_leader_employee_custom_id

The client supplied custom id of the manager of the employee

requested_via

If this request was submitted via API or manually through the Connect interface

reward_eligible

Denotes if this response was eligible for a reward grant from the customer

additional_question_eligible

Denotes whether the question was seen by the consumer

additional_question_id

Unique ID created for each Question

additional_question_text

The question copy

twitter_share_eligible

If Twitter share for the company was enabled at the time of response submittal

twitter_share_initiated

If the customer began a Twitter share after their response

facebook_share_eligible

If Facebook share for the company was enabled at the time of response submittal

facebook_share_initiated

If the customer began a Facebook share after their response

twitter_follow_eligible

If Twitter follow for the company was enabled at the time of response submittal

twitter_follow_initiated

If the customer began a Twitter follow after their response

facebook_follow_eligible

If Facebook follow for the company was enabled at the time of response submittal

facebook_follow_initiated

If the customer began a Facebook follow after their response

custom_link_eligible

If this interaction was eligible to show a custom link to the consumer

custom_link_initiated

If the consumer clicked on a custom link

language

Language of the Consumer Survey (Provided via API)

country

Name of the Consumer's Country (Provided via API)

areas_of_excellence_selected

An indication this particular area of excellence (AOE) was given in response

areas_of_excellence_shown

List of areas of excellence shown to the consumer on the survey

*ISO 8601 format includes date and time in UTC timezone