Surveys Sent API Export

Access level: Any user with permission to access the API

To export your data via an API export:

Review > Surveys Sent

Filters that currently may be applied are: Date Range; Project (NOT Project Group); Survey Template

Go to the File tab

Select Export API Data

The export can seem quite daunting at first. Listed below are some helpful notes to aid you in using this file. The first table provides the list of columns in order. The second table provides the list of columns by grouping.

Table 1: BY COLUMN ORDER

Column	Title	Grouping
A	Survey ID (unique ID to survey group)	Survey Detail
B	Survey Name	Survey Setup
C	Survey Template ID (backend CFT code)	Survey Setup
D	Survey Template Name	Survey Setup
E	Project ID (backend CFT code)	Project
F	Project Number	Project
G	Project Name	Project
H	Project Group ID (backend CFT code)	Project
I	Project Group Name	Project
J	Project Type ID (backend CFT code)	Project
K	Project Type Name	Project
L	Project Client ID (backend CFT code)	Project
M	Project Client Name	Project
N	Project Client Type ID (backend CFT code)	Project
O	Project Client Type Name	Project
P	Start Date	Survey Detail
Q	End Date	Survey
R	Remind Date	Survey Detail
S	Reminder Sent	Survey Detail
T	Sender Email	Sender
U	Sender First Name	Sender
V	Sender Last Name	Sender
W	Recipient Email	Recipient
X	Recipient First Name	Recipient
Y	Recipient Last Name	Recipient
Z	Original Sender	Survey Setup
AA	Last Activity Date	Survey Detail
AB	Status (i.e., Not Started, Finished, etc.)	Responses
AC	Finished On	Survey Detail
AD	Is Dismissed	Responses
AE	Is Forwarded	Responses
AF	Link to Survey	Survey
AG	Tag	Project
AH	Question ID (backend CFT code)	Responses
AI	Question	Responses
AJ	Category Name	Responses
AK	Is Custom	Survey
AL	Score	Responses
AM	Comment	Responses
AN	Date Response	Responses
AO	NPS Value	Responses
AP	NPS Comment	Responses
AQ	NPS Date Response	Responses
AR	Allow Uninvited	Responses
AS	Sender Generic Email	Survey Setup
AT	Include NPS	Responses
AU	Recipient Client Type	Recipient
AV	Survey Template Type	Survey Setup
AW	Survey Template Type Name	Survey Setup
AX	Recipient ID (backend CFT code)	Recipient
AY	Recipient Client Number	Recipient
AZ	Sent On	Survey Setup
BA	Email Survey Link	Survey Detail
BB	Modify Survey Link	Survey Detail
BC	Answers Report Link	Responses
BD	Thank You Message	Survey Setup
BE	Is Scorable	Responses
BF	Score Group	Responses
BG	NPS Category (promoter, passive, detractor)	Responses
BH	Invitation Text	Survey Setup
BI	Vendor Report Email Text	Survey Setup
BJ	Vendor Send Report to Vendor Contacts	Survey Detail
BK	Project is Active	Project
BL	Project Client Number	Project
BM	Recipient Client Name	Recipient
BN	Company Name	Company
BO	Company ID (backend CFT code)	Company
BP	Company Number	Company

Table 2: BY GROUPING

Column	Title	Grouping
BO	Company ID (backend CFT code)	Company
BN	Company Name	Company
BP	Company Number	Company
L	Project Client ID (backend CFT code)	Project
M	Project Client Name	Project
BL	Project Client Number	Project
N	Project Client Type ID (backend CFT code)	Project
O	Project Client Type Name	Project
H	Project Group ID (backend CFT code)	Project
I	Project Group Name	Project
E	Project ID (backend CFT code)	Project
BK	Project is Active	Project
G	Project Name	Project
F	Project Number	Project
J	Project Type ID (backend CFT code)	Project
K	Project Type Name	Project
AG	Tag	Project
BM	Recipient Client Name	Recipient
AY	Recipient Client Number	Recipient
AU	Recipient Client Type	Recipient
W	Recipient Email	Recipient
X	Recipient First Name	Recipient
AX	Recipient ID (backend CFT code)	Recipient
Y	Recipient Last Name	Recipient
AR	Allow Uninvited	Responses
BC	Answers Report Link	Responses
AJ	Category Name	Responses
AM	Comment	Responses
AN	Date Response	Responses
AT	Include NPS	Responses
AD	Is Dismissed	Responses
AE	Is Forwarded	Responses
BE	Is Scorable	Responses
BG	NPS Category (promoter, passive, detractor)	Responses
AP	NPS Comment	Responses
AQ	NPS Date Response	Responses
AO	NPS Value	Responses
AI	Question	Responses
AH	Question ID (backend CFT code)	Responses
AL	Score	Responses
BF	Score Group	Responses
AB	Status (i.e., Not Started, Finished, etc.)	Responses
T	Sender Email	Sender
U	Sender First Name	Sender
V	Sender Last Name	Sender
Q	End Date	Survey
AK	Is Custom	Survey
AF	Link to Survey	Survey
BA	Email Survey Link	Survey Detail
AC	Finished On	Survey Detail
AA	Last Activity Date	Survey Detail
BB	Modify Survey Link	Survey Detail
R	Remind Date	Survey Detail
S	Reminder Sent	Survey Detail
P	Start Date	Survey Detail
A	Survey ID (unique ID to survey group)	Survey Detail
BJ	Vendor Send Report to Vendor Contacts	Survey Detail
BH	Invitation Text	Survey Setup
Z	Original Sender	Survey Setup
AS	Sender Generic Email	Survey Setup
AZ	Sent On	Survey Setup