How Can I Find the Text Associated With Multiple Choice Question Responses?

Question

How can I find the text associated with responses to multiple choice questions?

Environment

Connector: Qualtrics

Answer

The value column of the QUESTION_RESPONSE table shows the number associated with the option the customer selected. For example, a value of 3 indicates the customer chose the third option. However, the value column doesn't include the text associated with the selected option.

If your multiple choice question is a single answer variation, you can map the number in the value column to the applicable response text by running the following query:

SELECT qr.response_id, qr.question, qr.value, qo.text 
FROM <your_qualtrics_schema>.question_response qr
INNER JOIN <your_qualtrics_schema>.survey_response sr
ON qr.response_id = sr.ID
INNER JOIN <your_qualtrics_schema>.question_option qo
ON sr.survey_id = qo.survey_id
AND qr.question_id = qo.question_id
AND qr.value = qo.key
WHERE qr.response_id = '<response_id>'
AND qr.question_id = '<question_id>'
;

IMPORTANT: It's not possible to map value column values to the applicable response text if your multiple choice question is a multiple answer variation.