How Can I Analyze Survey Response Data in the Destination?

Question

How can I analyze survey response data synced by Fivetran?

Environment

Connector: Medallia Agile Research

Answer

To analyze survey response data, use the following core tables:

• SURVEY: High-level survey details, including the survey ID, creation date, and title.
• SURVEY_QUESTION: Details and text for each survey question.
• SURVEY_QUESTION_RESPONSE: Possible response options for each survey question.
• SURVEY_RESPONDENT: Details about each survey respondent, such as response date, location, IP address, and country.
• SURVEY_RESPONDENT_RESPONSE: Responses each respondent submitted for each question.

Join these tables to see how each respondent answered each question in a survey. For a complete list of synced columns, see our Medallia Agile Research schema documentation.