Table Type: Historical Data
Contains the surveys for a conversation.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| conversation_id | string | Primary Key | The unique identifier of the conversation. |
| survey_id | string | Primary Key | The survey id. |
| survey_type | string | The type of the survey - one of: Web or Voice | |
| event_time | datetime | The time the survey event occurred. | |
| queue_id | string | The unique identifier of the queue associated with the survey. | |
| survey_completed_date | datetime | The date the survey was completed. | |
| survey_form_context_id | string | The context ID of the survey form, regardless of version | |
| survey_form_id | string | The unique identifier of the survey form. | |
| survey_form_name | string | The name of the survey form. | |
| survey_partial_response | boolean | Indicates whether the survey was partially completed. | |
| survey_promoter_score | int32 | The net promoter score of the survey. | |
| survey_status | string | The status of the survey - one of: Pending, Sent, In progress, Finished, Error, Opt out, Expired | |
| user_id | string | The user id of the user associated with the survey. | |
| o_survey_total_score | int64 | The overall total score of the survey. | |
| db_last_updated | datetime | When this record was last updated in UTC. |