Qualtrics: Response

Description

• Breakdown of responses to individual questions (and their sub-questions). Enhanced with information regarding the survey-level response and the survey.

Supported Data Sources

• Qualtrics

Columns

Type	Name	Description
STRING	question_response_id	Fivetran-generated unique key hashed on response_id, question_id, sub_question_key, sub_question_text , question_option_key , loop_id and importId.
STRING	survey_response_id	The unique ID for the SURVEY_RESPONSE.
STRING	survey_id	The unique identifier for this survey. Match pattern = ^SV_[a-zA-Z0-9]{11,15}$
STRING	question_id	The unique identifier for the question. Match pattern = ^QID[a-zA-Z0-9]+$
STRING	question_text	Text for the question.
INTEGER	sub_question_key	Key of the sub question.
INTEGER	sub_question_text	Sub question text.
INTEGER	question_option_key	The key of the QUESTION_OPTION that was chosen.
INTEGER	value	Value of the question response.
INTEGER	loop_id	ID of the Loop and Merge object this response is associated with.
STRING	distribution_channel	The method by which the survey was distributed to respondents.
INTEGER	survey_response_status	The type of response.
INTEGER	survey_progress	How far the respondent has progressed through the survey as a percentage out of 100.
INTEGER	duration_in_seconds	How long it took for the respondent to finish the survey in seconds.
BOOLEAN	is_finished_with_survey	Boolean (stored as int) indicating if the respondent finished and submitted the survey, the value will be 1, otherwise it will be 0.
STRING	survey_finished_at	The point in time when the survey response was finished.
STRING	survey_response_last_modified_at	The point in time when the record was last modified.
DATETIME	survey_response_recorded_at	The point in time when the survey response was recorded.
DATETIME	survey_response_started_at	The point in time when the survey response was recorded.
STRING	recipient_email	Email of the recipient if they are a single recipient (not a mailing list or sample).
STRING	recipient_first_name	First name of the recipient if they are a single recipient (not a mailing list or sample).
STRING	recipient_last_name	Last name of the recipient if they are a single recipient (not a mailing list or sample).
STRING	user_language	The language of the respondent.
STRING	ip_address	IP address of the recipient.
INTEGER	location_latitude	The approximate location of the respondent at the time the survey was taken.
INTEGER	location_longitude	The approximate location of the respondent at the time the survey was taken.
STRING	source_relation	The schema or database this record came from if you are making use of the qualtrics_union_schemas or qualtrics_union_databases variables, respectively. Empty string if you are not using either of these variables to union together multiple Qualtrics connectors.
INTEGER	recode_value	Recode/mapping value for the option.
STRING	question_option_text	Question option text.
STRING	first_name	Contact's first name.
STRING	last_name	Contact's surname.
STRING	email_domain	Domain of the contact's email address.
STRING	contact_language	The user's default language.
STRING	contact_external_data_reference	The external reference for the contact.
BOOLEAN	is_xm_directory_contact	Boolean representing whether the contact came from the XM Directory API endpoint (ie stored in the directory_contact table).
BOOLEAN	is_research_core_contact	Boolean representing whether the contact came from the (to-be-deprecated) Research Core API endpoint (ie stored in the core_contact table).
STRING	embedded_data	JSON of Any extra information you would like recorded in addition to the question responses (from the survey_embedded_data source table).
STRING	survey_name	Name of the survey.
STRING	survey_status	The distribution status of the survey, or a flag indicating that it's a library blockAllowed values - Inactive, Active, Pending, LibBlock, Deactive, Temporary
STRING	project_category	Project category of the survey.Allowed values - CORE, CX, EX, BX, PX
STRING	project_type	Type of Qualtrics project. Match pattern = ^[a-zA-Z]+$
STRING	brand_base_url	Base url for the organization/brand.
STRING	question_description	Label to identify the question.
STRING	question_type	The type of question. Can be -MC,Matrix,Captcha,CS,DB,DD,Draw,DynamicMatrix,FileUpload,GAP,HeatMap,HL,HotSpot,Meta,PGR,RO,SBS,Slider,SS,TE,Timing,TreeSelect
STRING	block_id	The ID of the survey block. Match pattern = ^BL_[a-zA-Z0-9]{11,15}$
STRING	block_description	Description given to the block.
INTEGER	block_question_randomization	If/how the block questions are randomized. Can be - false (no randomization), RandomWithXPerPage (randomize all and place X questions in each block), RandomWithOnlyX (randomly present only X out of the total questions), or Advanced (custom configuration)
STRING	block_type	Type of block. Can be Trash, Default, or Standard
INTEGER	block_visibility	Whether the questions in the block are 'collapsed' or 'expanded' by default.
INTEGER	validation_setting_force_response	The response from forcing respondents to answer a question or request that they consider answering the question before leaving the page
INTEGER	validation_setting_force_response_type	The type of response from forcing respondents to answer a question or request that they consider answering the question before leaving the page
STRING	validation_setting_type	The type of forced response validation that is set.
BOOLEAN	is_question_deleted	Boolean representing whether the record was soft-deleted in Qualtrics.
BOOLEAN	is_block_deleted	Boolean representing whether the record was soft-deleted in Qualtrics.