# 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

* <img src="https://fivetran.com/integrations/qualtrics/resources/qualtrics.svg" alt="" data-size="line"> 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.                                                                                                                                                                                                                  |


---

# 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-directory.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.