Qualtrics: Directory

Description

• A directory is an address book for the entire brand and contains all of the contacts that have been added by your users. This model provides a detailed view of each directory, enhanced with metrics regarding contacts, survey distribution, and engagement.

Supported Data Sources

• Qualtrics

Columns

Type	Name	Description
BOOLEAN	is_deduped_on_email	Boolean representing if directory contacts are deduped based on email.
BOOLEAN	is_deduped_on_ext_ref	Boolean representing if directory contacts are deduped based on an external data reference.
BOOLEAN	is_deduped_on_first_name	Boolean representing if directory contacts are deduped based on first name.
BOOLEAN	is_deduped_on_last_name	Boolean representing if directory contacts are deduped based on last name.
BOOLEAN	is_deduped_on_phone	Boolean representing if directory contacts are deduped based on phone number.
STRING	directory_id	The directory ID, also known as a pool ID. Example - POOL_012345678901234
BOOLEAN	is_default	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.
STRING	name	Name of the directory.
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.
INTEGER	count_distinct_emails	Count of distinct email addresses in the directory.
INTEGER	count_distinct_phones	Count of distinct phone numbers (stripped of any non-numeric characters) in the directory.
INTEGER	total_count_contacts	Total number of contacts.
INTEGER	total_count_unsubscribed_contacts	Total number of contacts who have unsubscribed from the directory.
INTEGER	count_contacts_created_30d	Number of contacts created in the last 30 days (inclusive) in this directory.
INTEGER	count_contacts_unsubscribed_30d	Number of contacts who have opted out of receiving communications through this directory in the last 30 days (inclusive).
INTEGER	count_contacts_sent_survey_30d	Number of contacts in this directory who have been sent a survey in the past 30 days (inclusive).
INTEGER	count_contacts_opened_survey_30d	Number of contacts in this directory who have been sent a survey in the past 30 days (inclusive) and opened it.
INTEGER	count_contacts_started_survey_30d	Number of contacts in this directory who have been sent a survey in the past 30 days (inclusive)and started it.
INTEGER	count_contacts_completed_survey_30d	Number of contacts in this directory who have been sent a survey in the past 30 days (inclusive) and completed it.
INTEGER	count_surveys_sent_30d	Number of distinct surveys sent to contacts in the past 30 days (inclusive).
INTEGER	count_mailing_lists	Number of mailing lists the exist within the directory.