Table Type: Historical Data
Contains the survey answers for a conversation.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| conversation_id | string | Primary Key | |
| survey_id | string | Primary Key | |
| question_group_id | string | Primary Key | |
| question_id | string | Primary Key | |
| answer_id | string | Primary Key | |
| score | int32 | Unweighted score of the question | |
| marked_na | boolean | True when the evaluation is submitted with a question that does not have an answer. Only allowed when naEnabled is true or if set by the system | |
| system_marked_na | boolean | If markedNA is true, systemMarkedNA indicates whether it was marked by a user or by the system due to visibility conditions. Always false if markedNA is false. | |
| assisted_answer_id | string | AnswerId found with evaluation assistance conditions | |
| nps_score | int32 | NPS score provided for the question if it is a NPS question | |
| nps_text_answer | string | Free text answer provided for the question if it is a NPS question | |
| free_text_answer | string | Free text answer provided for the question if it is a free text question | |
| db_last_updated | datetime |