Skip to Content
Product Information
Author's profile photo Rituparna Reddi

Analyzing Qualtrics surveys in SAP Analytics Cloud

( Please note that the standard SAP Analytics Cloud connector for Qualtrics is now available. You can find more information in my blog Best Practices for consuming Qualtrics surveys in SAP Analytics Cloud .)

Is there any standard SAP Analytics Cloud content for Qualtrics surveys?

With the August release of Business Content (7th September 2019 – to be precise)  – we bring to you a new business package SAP Qualtrics: Customer Satisfaction.

This content is built based on excel export of results for a survey using the XM Solution Automated Project CSAT from Qualtrics.

To give you an idea of what you can expect from this content –


Get a total overview of your CSAT survey for selected products, be it trend of your survey responses and CSAT, geographical and demographic results, likelihood of purchase, willingness to recommend and understanding of negative comments.


Get into the details of all attributes addressed in your survey to analyse the satisfaction level  and importance given to them by your survey respondents.


Get further insights into your survey results by analyzing customer service engagement and all details on demographic responses.

Adhoc Analysis:

Freely analyze the responses based on measures and dimensions of your choice.


This content is built using responsive layout so it works just as well on different displays and devices.

How can this content be fed by my CSAT survey from Qualtrics?

Follow the standard content documentation’s section on SAP Qualtrics CSAT.


How can I analyse results of surveys I have designed in Qualtrics using SAP Analytics Cloud?

SAP Analytics Cloud team is building a dedicated data acquisition connector for Qualtrics. This connector will be available in 2020 H1.

Here’s a sneak preview of what this connector will look like.

Today, it is possible to do an excel import of Qualtrics survey results in SAP Analytics Cloud.

I’ll take the example of a survey and how I would use it in SAP Analytics Cloud.

Let’s look at a simple survey here.

Here’s the survey exported to word, where I can see the filed IDs.


I export the survey results to excel selecting the option “use numeric values”.

The excel downloaded has the following structure.

I use the following steps to interpret the survey in SAP Analytics Cloud.

  • Remove the second and third row from the survey excel exported from Qualtrics.
  • Create a base model based on open ended question fields and other standard fields (ResponseId, dates, progress…) with 1 to 1 mapping, enriching geo if needed and adding a calculated column with value 1 (for having a single count associated with a response)
  • For each scale questions create a model using
    – ResponseId as a dimension and
    – unpivot the question’s columns
    – Add calculated column with value 1
  • Link all models on ResponseId

My models are now ready to be used in stories to provide state-of-the-art analytics.

Try analyzing your Qualtrics survey responses in SAP Analytics Cloud and be surprised with the insights you derive!










Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Michaela Degbeon
      Michaela Degbeon

      Really powerful!

      Author's profile photo Sven Ringling
      Sven Ringling

      Thanks for sharing this!
      I have 2 questions:

      1. is there a reason other than keeping development cost low that the solution is using a manual export to csv instead of using APIs?
      2. thsi content is only for customer experience, right? Nothing for Employee Experience. Is the reason for that that SAC is currently not able to emulate the anonymity threshold used for reports and dashboards with EX data in Qualtrics?
      Author's profile photo Rituparna Reddi
      Rituparna Reddi
      Blog Post Author

      Hi Sven Ringling ,

      A connector using the APIs will be available in SAP Analytics Cloud in Q1 2020. I have added a preview video of this connector to the blog.

      You are right, this content is for CX. We will gradually provide standard content for all 4 areas- Customer, Employee, Brand and Product.

      Best regards,


      Author's profile photo Xin Yuan Law
      Xin Yuan Law

      Is SAP Analytics Cloud connector for Qualtrics support for image upload? With using this connector, can I create image model using Qualtrics connection in SAP Analytics Cloud?

      Author's profile photo Rituparna Reddi
      Rituparna Reddi
      Blog Post Author

      It is not possible to do so through the Qualtrics connector - image dimension is supported through HANA views as explained in this blog

      Author's profile photo Xin Yuan Law
      Xin Yuan Law

      Thanks, Rituparna.