Qualtrics
Qualtrics is an online survey tool that allows you to build and distribute surveys, and analyze responses.
Features
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | BATCH_TRANSACTION_MEMBERSHIP , CONTACT_MAILING_LIST_MEMBERSHIP , CONTACT_TRANSACTION , DIRECTORY_CONTACT , DISTRIBUTION_CONTACT , QUESTION_RESPONSE , SURVEY_RESPONSE , SURVEY_EMBEDDED_DATA , TICKET and TRANSACTION_BATCH tables. |
History mode | ||
Custom data | check | |
Data blocking | check | |
Column hashing | check | |
Re-sync | check | |
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | check | |
Private networking | ||
Authorization via API | check |
Setup guide
Follow our step-by-step Qualtrics setup guide to connect Qualtrics with your destination using Fivetran connectors.
Authentication
You can choose between the Standard (recommended) and Advanced authentication methods to connect your Qualtrics account to Fivetran. For more information, see Authentication method section
Schema information
This schema applies to all Qualtrics connectors.
To zoom, open the ERD in a new window.NOTE: If you use XM Directory, we do not sync the Non-XM Directory Users tables shown in the ERD. You must have the Manage Directory permission to sync the
TRANSACTION_BATCH
andBATCH_TRANSACTION_MEMBERSHIP
tables. If you don't use XM Directory, we do not sync the XM Directory Users and XM Directory Lite Users tables shown in the ERD.
User types and data scope
Qualtrics has the following user types:
- Non-XM Directory (also known as core-XM) - using the Contacts platform
- XM Directory - using the XM Directory platform
- XM Directory Lite - using the XM Directory platform
The data scope depends on the user type. We sync common tables for any user type. We only sync user type-specific tables - Non-XM Directory tables and XM Directory tables - for the relevant user types.
To learn more about Qualtrics user migration from the Research Contacts to the XM Directory platform, see Qualtrics' Research Core to XM Directory Migration Guide.
Common tables
USER
LIBRARY
LIBRARY_SURVEY
LIBRARY_QUESTION
LIBRARY_BLOCK
LIBRARY_MESSAGE
DISTRIBUTION
SMS_DISTRIBUTION
SURVEY
SURVEY_RESPONSE
SURVEY_EMBEDDED_DATA
SURVEY_VERSION
SURVEY_VERSION_PUBLISH_EVENT
QUOTA
QUOTA_GROUP
GROUP_QUOTA_MEMBERSHIP
QUESTION
QUESTION_RESPONSE
SUB_QUESTION
QUESTION_OPTION
BLOCK
BLOCK_QUESTION
TICKET
Non-XM Directory tables
CORE_SAMPlE
CORE_MAILING_LIST
CORE_CONTACT
XM Directory tables
Table Name | XM Directory Lite Users | XM Directory Users |
---|---|---|
BATCH_TRANSACTION_MEMBERSHIP | check | |
CONTACT_MAILING_LIST_MEMBERSHIP | check | |
CONTACT_TRANSACTION | check | |
DIRECTORY_CONTACT | check | |
DIRECTORY_MAILING_LIST | check | check |
DIRECTORY_SAMPLE | check | check |
DISTRIBUTION_CONTACT | check | check |
SMS_DISTRIBUTION_CONTACT | check | check |
FREQUENCY_RULE | check | |
FREQUENCY_RULE_TARGET | check | |
TRANSACTION_BATCH | check |
Limitations
The survey endpoint only provides the surveys accessible by the API token user and not necessarily all the surveys. Refer to Qualtrics Community's I am not able to see ALL the surveys thread for more details.
The Qualtrics API does not allow us to fetch the data of the
CONTACT_TRANSACTION
table incrementally. We only sync contact transactions when the corresponding contact record is created or modified. As a result, you may observe missing records for theCONTACT_TRANSACTION
table in your destination. If you want to keep the table up to date, you should perform a connector re-sync.
Qualtrics API usage
The default Qualtrics API usage limit of a connector is 2000 requests per minute. Qualtrics allows a maximum API usage of 3000 requests per minute at the brand level. You can use our REST API to configure the usage. For more information, read Qualtrics' documenatation on request limits.