Qualtrics: Contact

Description

• Detailed view of all contacts (from both the XM Directory and Research Core contact endpoints), ehanced with response and mailing list metrics.

Supported Data Sources

• Qualtrics

Columns

Type	Name	Description
STRING	contact_id	The ID for the contact. Example - CID_012345678901234
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	directory_id	The directory ID, also known as a pool ID. Example - POOL_012345678901234
STRING	email	The user's email address.
STRING	email_domain	Domain of the contact's email address.
STRING	first_name	Contact's first name.
STRING	last_name	Contact's surname.
STRING	external_data_reference	The external reference for the contact.
STRING	language	The user's default language.
BOOLEAN	is_unsubscribed_from_directory	Boolean indicating whether the contact unsubscribed from all contact from the Directory.
DATETIME	unsubscribed_from_directory_at	Date and time the user opted out of the directory.
STRING	last_modified_at	The point in time when the record was last modified.
STRING	mailing_list_ids	Comma-separated list of mailing list IDs the record is associated with.
INTEGER	count_mailing_lists_subscribed_to	Count of distinct mailing lists the contact is a member of and has not opted out of.
INTEGER	count_mailing_lists_unsubscribed_from	Count of distinct mailing lists that the contact has opted out of receiving emails through.
DATETIME	created_at	The creation date and time of the record, expressed as an ISO 8601 value.
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	count_surveys_sent_email	Distinct surveys sent to the contact via email invite.
INTEGER	count_surveys_sent_sms	Distinct surveys sent to the contact via SMS invite.
INTEGER	count_surveys_opened_email	Distinct surveys opened by the contact via email invite.
INTEGER	count_surveys_opened_sms	Distinct surveys opened by the contact via SMS invite.
INTEGER	count_surveys_started_email	Distinct surveys started by the contact via email invite.
INTEGER	count_surveys_started_sms	Distinct surveys started by the contact via SMS invite.
INTEGER	count_surveys_completed_email	Distinct surveys completed by the contact via email invite.
INTEGER	count_surveys_completed_sms	Distinct surveys completed by the contact via SMS invite.
INTEGER	total_count_surveys	Total distinct surveys distributed.
INTEGER	total_count_completed_surveys	Total distinct surveys completed.
DECIMAL	avg_survey_progress_pct	On average, how far a respondent has progressed through a survey as a percentage out of 100.
DECIMAL	avg_survey_duration_in_seconds	On average, how long it took a respondent to finish a survey in seconds.
DECIMAL	median_survey_progress_pct	The median of how far a respondent has progressed through a survey as a percentage out of 100.
DECIMAL	median_survey_duration_in_seconds	The median of how long it took a respondent to finish a survey in seconds.
DATETIME	last_survey_response_recorded_at	The most recent point in time when a survey response was recorded.
DATETIME	first_survey_response_recorded_at	The earliest point in time when a survey response was recorded.
STRING	directory_name	Name of the directory.
BOOLEAN	is_in_default_directory	Boolean representing if this directory is the default one for your brand. The default directory will be the first directory listed in the dropdown menu in Qualtrics.
BOOLEAN	is_directory_deleted	Boolean representing whether the record was soft-deleted in Qualtrics.