Combining all verbatim feedback | XM Community
Skip to main content

We would like to combine all our verbatim feedback from 20+ surveys across approx 5 questions into one big text feedback data set. The idea behind this is that people could come and search for keywords for projects they are working on to see if any customer feedback relates to this keyword. 

 

Any ideas on how to do this? 

 

I can’t do via embedded data as our survey program has been running for many years, so we are looking for a solution for a very large dataset across multiple surveys. Hopefully via dashboards. 

You are right. You can achieve this using the dashboard. You can combine text fields from different surveys and analyze the comments.




Refer this support link: https://www.qualtrics.com/support/vocalize/dashboard-settings-cx/dashboard-data/dashboard-data-overview/

 


Thanks for the input - I am wanting to combine all the verbatim questions into one data field for searching purpose - this is what I am unclear how to do?


Hi ​@ccarroll 

I think what you have in mind could be achieved by building a kind of pivot/stacked dataset in which each row would contain a verbatim and information about its origin.

In each survey, you could build daily workflows to extract the survey responses and use a basic transform task to create unique IDs (could be concat responseId + question, for example) and to uniformize the fields’ names. You could then load the results into an IDP.

The initial setup would be a bit heavy since you would need one such workflow for each of your 5 open ended questions for each of your 20 surveys, bit in the end you would end up with an IDP containing rows similar to this:

uniqueId sourceSurvey sourceQuestion verbatim
R_037SfMKD3Mg8yVM_Q1 SV_A Q1 Verbatim 1
R_037SfMKD3Mg8yVM_Q2 SV_A Q2 Verbatim 2
R_3dWhMnwIQ3jfELI_Q1 SV_B Q1 Verbatim 3
R_3dWhMnwIQ3jfELI_Q2 SV_B Q2 Verbatim 4

 

 


Thanks for the input - I am wanting to combine all the verbatim questions into one data field for searching purpose - this is what I am unclear how to do?

But with dashboard mapping it will combine open end from all surveys in on field that can be used for search purpose.


Leave a Reply