Articles in this section

See more

How to Import Data from Qualtrics

  • Updated
Follow

This article describes how to import a data set into Displayr using our Qualtrics integration. 
Please note that a data set added via the Qualtrics integration will always update whenever you load the Displayr document. The automatic refresh setting, using a Schedule, described below is designed to simplify the updating process.

Requirements

Please note these steps require a Displayr license.

  • A paid Qualtrics plan that includes API access. To check whether a Qualtrics account has API access, contact the Qualtrics Administrator at your organization. A Qualtrics administrator may contact a sales representative at Qualtrics to discuss licensing for API access.
  • A Displayr document.

Finding your Qualtrics API information

Your Qualtrics Base URL is the base URL when you are logged into your account with "/API" appended to it. 

We usually recommend using one of the two for your Base URL:

You can find the datacenter ID and organization ID by logging into your Qualtrics account and going to Account Settings at the top right. Then go to the User Settings > User section and look for a box that looks like this:

QualtricsIDs.png

Once logged in to Qualtrics, you'll need to then find your Qualtrics API Token:

  1. Click on the User icon at the upper right-hand corner of the window and go to Account Settings.
  2. Go to User Settings > API.
  3. Copy the string of alphanumeric text labeled "Token" in the box labeled API. This is your Qualtrics API Token.
  4. If this is empty, you'll need to generate an API token by clicking the Generate Token button at the bottom of the API box.

Note that you will need to keep these details as Displayr won't automatically save them in your document.

Importing your Qualtrics data

1. Select Data Sources > Plus (+) > Qualtrics.
2. Using your copied Base URL and API Token, enter these details in the appropriate fields.

QualtricsImport.png

3. Click OK.

4. Select the desired survey and Displayr will add it as a data set to your document.

Automatically update your data

If you want to automatically pull in updated data from your Qualtrics survey, you can set up a Schedule. You can view, update, or add a schedule to your data set from the object inspector when your data set is selected.

Schedule.png

See Schedules for more information and details about how to set up a schedule to automatically update your data.

Note that a data set added via the Qualtrics integration will always update whenever you load the Displayr document. The Schedule setting is designed to simplify the updating process.

Technical details

  • For security, the Base URL must start with "https://". More information on your Base URL can be found at Base URL and Datacenter IDs.
  • For more information on Qualtrics API Tokens, look at API Key Authentication.
  • We do not currently support importing surveys with more than 1 million responses.
  • Data is not updated automatically. You will need to update your data file through the API manually.
  • Qualtrics Side-by-Side questions may have missing data for some multiple-response questions within them. Qualtrics is aware of this issue and intends to fix it in the future.
  • When importing Qualtrics "Matrix - Profile" questions, value labels may not be imported correctly if the columns of the matrix are labeled differently between different rows.
  • For Single Answer or Matrix - Single Answer questions, a new value may be added called "Not Answered" to represent cases where a respondent has been shown a particular option but decided not to choose any value for it. Cases where a respondent was not shown the option (e.g. due to randomization) are represented with Missing Values.

Next

Once you've imported your data, it's always a good idea to Check Your Data.

Related articles