Qualtrics
## Columns
| Type | Name | Description |
| -------- | --------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| STRING | survey\_id | The unique identifier for this survey. Match pattern = ^SV\_\[a-zA-Z0-9]{11,15}$ |
| STRING | survey\_name | Name of the survey. |
| STRING | survey\_status | The distribution status of the survey, or a flag indicating that it's a library blockAllowed values - `Inactive`, `Active`, `Pending`, `LibBlock`, `Deactive`, `Temporary` |
| STRING | brand\_base\_url | Base url for the organization/brand. |
| STRING | brand\_id | Unique ID of the organization/brand. |
| INTEGER | bundle\_short\_name | Short name for the content bundle that the survey is from. |
| INTEGER | composition\_type | Survey composition type. |
| INTEGER | auto\_scoring\_category | The automated scoring category. |
| INTEGER | default\_scoring\_category | The default scoring category. |
| INTEGER | division\_id | The unique identifier for the Division ID. Match pattern = ^DV\_\[0-9a-zA-Z]{11,15}$ |
| STRING | creator\_user\_id | The unique identifier for a specific `USER` who created the survey. |
| STRING | owner\_user\_id | The unique identifier for a specific user who owns this. |
| STRING | project\_category | Project category of the survey.Allowed values - `CORE`, `CX`, `EX`, `BX`, `PX` |
| STRING | project\_type | Type of [Qualtrics project](https://www.qualtrics.com/support/survey-platform/my-projects/my-projects-overview/#SelectingProjectType). Match pattern = ^\[a-zA-Z]+$ |
| INTEGER | registry\_sha | The survey registry SHA. |
| INTEGER | registry\_version | The survey registry version. |
| INTEGER | schema\_version | Qualtrics schema version. |
| BOOLEAN | scoring\_summary\_after\_questions | Boolean representing whether the scoring summary is after questions. |
| BOOLEAN | scoring\_summary\_after\_survey | Boolean representing whether the scoring summary is after the survey. |
| INTEGER | scoring\_summary\_category | The unique identifier for the scoring. |
| INTEGER | last\_accessed\_at | The date the survey was last accessed. |
| STRING | last\_activated\_at | The date the survey was last activated. |
| STRING | last\_modified\_at | The point in time when the record was last modified. |
| 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 | version\_id | The unique identifier for this survey version. |
| INTEGER | version\_number | The version number of this survey. |
| STRING | version\_description | A user-provided description of the survey version. |
| STRING | survey\_version\_created\_at | The creation date and time of the record, expressed as an ISO 8601 value. |
| INTEGER | count\_published\_versions | Number of versions that have been published for this survey. |
| STRING | publisher\_user\_id | ID of `USER` who published this survey version in your org. |
| STRING | publisher\_email | Email of the `USER` who published the latest survey version. |
| STRING | creator\_email | Email of the `USER` who created the object. |
| STRING | owner\_email | Email of the `USER` who owns the object. |
| INTEGER | count\_questions | Total number of questions (does not include deleted ones) in the survey. |
| DECIMAL | avg\_response\_duration\_in\_seconds | On average, how long it took a respondent to finish a survey in seconds. |
| DECIMAL | median\_response\_duration\_in\_seconds | The median of how long it took a respondent to finish a survey in seconds. |
| DECIMAL | avg\_survey\_progress\_pct | On average, how far a respondent has progressed through a survey as a percentage out of 100. |
| DECIMAL | median\_survey\_progress\_pct | The median of how far a respondent has progressed through a survey as a percentage out of 100. |
| INTEGER | count\_survey\_responses | Total number of survey responses. |
| INTEGER | count\_completed\_survey\_responses | Total number of *completed* survey responses (ie `is_finished=true`). |
| INTEGER | count\_survey\_responses\_30d | Number of survey responses recorded in the past 30 days. |
| INTEGER | count\_completed\_survey\_responses\_30d | Number of *completed* survey responses recorded in the past 30 days. |
| INTEGER | count\_anonymous\_survey\_responses | Number of recorded survey responses distributed anonymously. |
| INTEGER | count\_anonymous\_completed\_survey\_responses | Number of *completed* recorded survey responses distributed anonymously. |
| INTEGER | count\_social\_media\_survey\_responses | Number of recorded survey responses distributed via [social media](https://www.qualtrics.com/support/survey-platform/distributions-module/social-media-distribution/). |
| INTEGER | count\_social\_media\_completed\_survey\_responses | Number of *completed* survey responses distributed via [social media](https://www.qualtrics.com/support/survey-platform/distributions-module/social-media-distribution/). |
| INTEGER | count\_personal\_link\_survey\_responses | Number of recorded survey responses distributed via [personal links](https://www.qualtrics.com/support/survey-platform/distributions-module/email-distribution/personal-links/). |
| INTEGER | count\_personal\_link\_completed\_survey\_responses | Number of *completed* survey responses distributed via [personal links](https://www.qualtrics.com/support/survey-platform/distributions-module/email-distribution/personal-links/). |
| INTEGER | count\_qr\_code\_survey\_responses | Number of recorded survey responses distributed via [QR codes](https://www.qualtrics.com/support/survey-platform/distributions-module/web-distribution/qr-code/). |
| INTEGER | count\_qr\_code\_completed\_survey\_responses | Number of *completed* survey responses distributed via [QR codes](https://www.qualtrics.com/support/survey-platform/distributions-module/web-distribution/qr-code/). |
| INTEGER | count\_email\_survey\_responses | Number of recorded survey responses distributed via [email](https://www.qualtrics.com/support/survey-platform/distributions-module/email-distribution/emails-overview/). |
| INTEGER | count\_email\_completed\_survey\_responses | Number of *completed* survey responses distributed via [email](https://www.qualtrics.com/support/survey-platform/distributions-module/email-distribution/emails-overview/). |
| INTEGER | count\_sms\_survey\_responses | Number of recorded survey responses distributed via [SMS invite](https://www.qualtrics.com/support/survey-platform/distributions-module/mobile-distributions/sms-surveys/). |
| INTEGER | count\_sms\_completed\_survey\_responses | Number of *completed* survey responses distributed via [SMS invite](https://www.qualtrics.com/support/survey-platform/distributions-module/mobile-distributions/sms-surveys/). |
| INTEGER | count\_uncategorized\_survey\_responses | Number of recorded survey responses not distributed via the default channels. |
| INTEGER | count\_uncategorized\_completed\_survey\_responses | Number of *completed* survey responses not distributed via the default channels. |
---
# 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-survey.md?ask=