# 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. | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/qualtrics-contact.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.