Qualtrics: Distribution

Description

• Table of each survey's distribution (method of reaching out to XM directory contacts) enhanced with survey response and status metrics.

Supported Data Sources

• Qualtrics

Columns

Type	Name	Description
STRING	created_at	The creation date and time of the record, expressed as an ISO 8601 value.
STRING	header_from_email	Email from address.
STRING	header_from_name	Email from name.
STRING	header_reply_to_email	Email reply-to address.
STRING	header_subject	Email subject; text or message id (MS_).
STRING	distribution_id	The unique Distribution ID.
INTEGER	message_library_id	Library ID of the message.
INTEGER	message_id	The ID for the desired library message.
INTEGER	message_text	Text of the message to send.
STRING	last_modified_at	The point in time when the record was last modified.
STRING	organization_id	ID of the organization/brand this record belongs to.
STRING	owner_user_id	The unique identifier for a specific user who owns this.
STRING	parent_distribution_id	The unique ID of the parent distribution.
STRING	recipient_contact_id	The contact ID of the recipient. Can point to directory_contact or core_contact.
STRING	recipient_library_id	Library ID of the message.
STRING	recipient_mailing_list_id	The mailing list or contact group associated with the distribution(s). Can point to directory_mailing_list or core_mailing_list.
STRING	recipient_sample_id	The ID for the desired sample. Can point to directory_sample or core_sample (not included in package).
STRING	request_status	The distribution's status. States include Pending and Done. The Pending state is for email that is scheduled to be sent at a later time.
STRING	request_type	The distribution's type. Types include Invite, Reminder, and ThankYou.
STRING	send_at	The date and time the request will be or was sent (in ISO 8601 format). Note that this date and time could be in the future if the email distribution is scheduled to send after a delay.
STRING	survey_link_expires_at	The expiration date for the link associated with the survey distribution. Null if request_type != Invite.
STRING	survey_link_type	The link type (Individual, Anonymous, or Multiple) for the link associated with the survey distribution. Null if request_type != Invite.
STRING	survey_id	The unique survey ID. Will be non-null even if request_type != Invite.
BOOLEAN	is_deleted	Boolean representing whether the record was soft-deleted in Qualtrics.
DATETIME	_fivetran_synced	The time when a record was last updated by Fivetran.
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.
STRING	parent_distribution_header_subject	Email subject; text or message id (MS_) of the parent distribution.
STRING	recipient_mailing_list_name	Name of the mailing list associated with the distribution(s).
STRING	owner_email	Email of the USER who owns the object.
STRING	owner_first_name	First name of the user who owns the object.
STRING	owner_last_name	Surname of the user who owns the object.
INTEGER	current_count_surveys_pending	Count of distributed surveys currently pending (the distribution is scheduled but has yet to be sent).
INTEGER	current_count_surveys_success	Count of distributed surveys currently with a status of success (the distribution was successfully delivered to the contact).
INTEGER	current_count_surveys_error	Count of distributed surveys currently with a status of error (an error occurred while attempting to send the distribution).
INTEGER	current_count_surveys_opened	Count of distributed surveys currently with a status of opened (the distribution was opened by the contact).
INTEGER	current_count_surveys_complaint	Count of distributed surveys currently with a status of complaint (the contact complained that the distribution was spam).
INTEGER	current_count_surveys_skipped	Count of distributed surveys currently with a status of skipped (the contact was skipped due to contact frequency rules or blacklisted contact information).
INTEGER	current_count_surveys_blocked	Count of distributed surveys currently with a status of blocked (the distribution failed to send, because the contact blocked it or the email was caught by the spam circuit breaker).
INTEGER	current_count_surveys_failure	Count of distributed surveys currently with a status of failed (the distribution failed to be delivered).
INTEGER	current_count_surveys_unknown	Count of distributed surveys currently with a status of unknown (the distribution failed for an unknown reason).
INTEGER	current_count_surveys_softbounce	Count of distributed surveys currently with a status of softbounce (the distribution bounced but can be retried).
INTEGER	current_count_surveys_hardbounce	Count of distributed surveys currently with a status of hardbounce (the distribution bounced and should not be retried).
INTEGER	current_count_surveys_surveystarted	Count of distributed surveys currently with a status of surveystarted (the contact started the survey distributed).
INTEGER	current_count_surveys_surveypartiallyfinished	Count of distributed surveys currently with a status of surveypartiallyfinished (the contact submitted a partially completed survey response).
INTEGER	current_count_surveys_surveyfinished	Count of distributed surveys currently with a status of surveyfinished (the contact submitted a completed survey response).
INTEGER	current_count_surveys_surveyscreenedout	Count of distributed surveys currently with a status of surveyscreenedout (the contact screened out while taking the survey).
INTEGER	current_count_surveys_sessionexpired	Count of distributed surveys currently with a status of sessionexpired (the contact's survey session has expired).
INTEGER	total_count_contacts	Total number of contacts.
INTEGER	count_contacts_sent_surveys	Count of unique contacts who have been sent surveys via the distribution.
INTEGER	count_contacts_opened_surveys	Count of unique contacts who have opened surveys via the distribution.
INTEGER	count_contacts_started_surveys	Count of unique contacts who have started surveys via the distribution.
INTEGER	count_contacts_completed_surveys	Count of unique contacts who have completed surveys via the distribution.
DATETIME	first_survey_sent_at	Timestamp of when the first survey was sent via this distribution.
DATETIME	last_survey_sent_at	Timestamp of when a survey was most recently sent out via this distribution.
DATETIME	first_survey_opened_at	Timestamp of when the first survey was opened via this distribution.
DATETIME	last_survey_opened_at	Timestamp of when a survey was most recently opened via this distribution.
DATETIME	first_response_completed_at	Timestamp of when the first survey was completed via this distribution.
DATETIME	last_response_completed_at	Timestamp of when a survey was most recently completed via this distribution.
DECIMAL	avg_time_to_open_in_seconds	Average time difference between when a survey was sent and when it was opened.
DECIMAL	avg_time_to_start_in_seconds	Average time difference between when a survey was sent and when it was started.
DECIMAL	avg_time_to_complete_in_seconds	Average time difference between when a survey was sent and when it was completed.
DECIMAL	median_time_to_open_in_seconds	Median time difference between when a survey was sent and when it was opened.
DECIMAL	median_time_to_start_in_seconds	Median time difference between when a survey was sent and when it was started.
DECIMAL	median_time_to_complete_in_seconds	Median time difference between when a survey was sent and when it was completed.