In trying to analyze SurveyMonkey results through our Fivetran connector, we've run into issues with trying to connect a user's answer choice to the actual options available in a multiple choice question (e.g. User 1 answered Option 2 to Question 3). We can see how many responses to the entire survey occurred or how many people responded to each question, but we cannot get a unique count of responses by the answer options. For example, if there is a Yes/No question, we can see that 200 people answered the question, but when we try to join the question options (Yes/No) to the users' response choices, there is no way to see how many people responded Yes vs No. You can see the unique identifier for an existing response, but it's unclear whether that response was Yes or No. 

From looking at the ERD, I believe this is because Choice ID is only available in the response_answer table. Therefore, an individual's response choice cannot be tied back to the actual question details available in question_history or question_option_history. 

I imagine that other people have run into this issue, but I can't find anything in the documentation. Can we please get support to figure out how to accurately represent survey responses and analyze multiple choice questions?