Skip to Content
Product Information

Best Practices for consuming Qualtrics Surveys in SAP Analytics Cloud

The good news is that the Qualtrics connector for SAP Analytics Cloud is available with QRC 1 2020 for all customers!

Through this connector, SAP Analytics Cloud can access all the data that has been provided through responses for a survey. However, it is important that the user creating the model understands the structure of the survey and hence it is useful to have access to the survey in Qualtrics.

Here are some suggestions that would help get the best out of analytics on Qualtrics surveys.

During the wrangling step of model creation, the following standard steps will help in getting better insights.

Some basic initial steps

1. Add a count column

Create a calculated column with value 1 to count your responses.

2. The first row appears with descriptions of questions. This row should be removed.

Why is this row provided at all?

If you don’t have access to the Qualtrics survey which creating the model, since the column headers provide the question numbers, the description information will you help you decide on which questions are relevant for analysis.

3. Create a Geo dimension

Use the  columns LocationLatitude and LocationLongitude to create your Geo dimension.

Modeling different types of questions

Qualtrics offers several options for questions types that may be included into a survey. Here are suggestions on handling some question types in Analytics Cloud.

Net Promoter Score (NPS)

For a question of type NPS – eg Q1, Qualtrics generates a field Q1_NPS_GROUP  with value Promoter or 3, Detractor or 1 or Passive or 2 for each response. To calculate an aggregated NPS Score in SAP Analytics Cloud , calculate the count of Promoters, count of detractors and calculate the NPS as (Promotercount/count- Detractorcount/count) *100.

Matrix Table

For a question of type Matrix Table – columns are generated based on number of statements. Eg. Q2 has 3 statements, then the generated columns are Q2_1, Q2_2 and Q2_3 and the descriptions are available as mentioned in point 2 above. You can create a model for each matrix question, selecting the columns ResponseID, Q2_1 to Q2_3 , doing an unpivot on the Q2 columns and then adding count as in step1.

Link the model thus created to the other model for this survey through ResponseID.

A similar approach can be followed for Rank Order Question Type .

Text Entry

For these questions, if there is TextIQ license, then doing text analysis generates some sentiment related fields. It is useful to have calculated measures based on Sentiment score field which can have Positive, Negative or Neutral


I would avoid importing this question type during model creation as this would generate too many columns and you could easily hit out 100 columns that SAP Analytics Cloud wrangling screen supports. However, if I can use such questions if I am creating a dataset from the Qualtrics connector as here I can consume 1000 columns.

Adding description for Dimension Names and Dimension Members

The question numbers are available as dimension names. To have dimensions look more meaningful , add a description for each dimension in the model based on your Qualtrics survey. For dimension members the code values provided. You would need to provide descriptions based on the Qualtrics survey. You can get all this information using the Export Survey to Word option in Qualtrics.


How to use the Qualtrics Connector

Here’s the standard documentation for the Qualtrics connector

Import Data Connection to Qualtrics

Importing Qualtrics Data to a New or Existing Model

SAC Qualtrics Integration is now available in the Qualtrics Marketplace.

Enjoy using the Qualtrics connector for your X data along with myriad of connectors delivering O data and find hidden insights you never did before!

Watch the teaser video of the Qualtrics connector.

You must be Logged on to comment or reply to a post.
    • Hi Prateek,

      It will support all surveys exposed through the Survey APIs of Qualtrics which the use setting up the connectivity has access to be if CX, EX or Brand.

      Best regards,


  • Thanks Rituparna Reddi for this blog, very interesting.

    We are having a problem when after creating the connection between the survey and SAC, when we add an embedded data field in Qualtrics, the SAC model fails to refresh... (adding questions it not a problem, but adding embedded data fields is...). Do you perhaps know how to solve that?



    • Apparently this is as designed, adding any Embedded Data field on Qualtrics side is breaking the connector.

      I created a Customer Influence Request for enhancing the connector so Embedded Data would be part of the Query Builder, if anyone else experiences this issue, please vote!


  • Rituparna Reddi , I have another question:

    when you do a Refresh on the connector in SAC, does that do a full or a delta data load?

    Because I edited some data on the Qualtrics side, and I SAC doesn't seem to pick up the new values 🙁