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. |
---
# 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-distribution.md?ask=