# Qualtrics: Daily Breakdown

## Description

* Daily breakdown of activities related to surveys and distribution in your Qualtrics instance.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/qualtrics/resources/qualtrics.svg" alt="" data-size="line"> Qualtrics

## Columns

| Type     | Name                                                | Description                                                                                                                                                                                                                                                              |
| -------- | --------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| 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. |
| DATETIME | date\_day                                           | Day of activity in your Qualtrics instance.                                                                                                                                                                                                                              |
| INTEGER  | count\_contacts\_created                            | New contacts created on this day.                                                                                                                                                                                                                                        |
| INTEGER  | count\_contacts\_unsubscribed\_from\_directory      | Count of contacts that unsubscribed from a directory.                                                                                                                                                                                                                    |
| INTEGER  | count\_contacts\_unsubscribed\_from\_mailing\_list  | Count of contacts that unsubscribed from a mailing list.                                                                                                                                                                                                                 |
| INTEGER  | count\_contacts\_sent\_surveys                      | Count of unique contacts who have been sent surveys via the distribution.                                                                                                                                                                                                |
| INTEGER  | count\_contacts\_opened\_sent\_surveys              | Count of contacts who opened a survey that was sent on this day.                                                                                                                                                                                                         |
| INTEGER  | count\_contacts\_started\_sent\_surveys             | Count of contacts who started a survey that was sent on this day.                                                                                                                                                                                                        |
| INTEGER  | count\_contacts\_completed\_sent\_surveys           | Count of contacts who completed a survey that was sent on this day.                                                                                                                                                                                                      |
| INTEGER  | count\_distinct\_surveys\_responded\_to             | Count of distinct survey templates (ie `survey_id`) that contacts responded to on this day.                                                                                                                                                                              |
| INTEGER  | total\_count\_survey\_responses                     | Count of distinct survey responses recorded on this day.                                                                                                                                                                                                                 |
| INTEGER  | total\_count\_completed\_survey\_responses          | Count of distinct complete survey responses recorded on this day.                                                                                                                                                                                                        |
| 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-daily-breakdown.md?ask=<question>
```

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.