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