Table Type: Aggregated Data
This table contains the number of conversations answered, abandoned or flowed-out by queue, interval and second aggregated into 15 minute intervals, including initial direction.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| queue_id | string | Primary Key | The queue identifier |
| time | datetime | Primary Key, Required | The start of the interval we are reporting on |
| media_type | string | Primary Key | The type of media - Callback, Chat, Cobrowse, Email, Internalmessage, Message, Screenshare, Unknown, Video, Voice |
| direction | string | Primary Key | The direction of the interaction - Inbound or Outbound |
| initial_direction | string | Primary Key | The initial direction of the interaction - Inbound or Outbound |
| seconds | int32 | Primary Key, Required | The number of seconds in the aggregation. The other fields store counts against this number of seconds. |
| abandoned_count | int32 | Required | The number of interactions that were abandoned in this second |
| answered_count | int32 | Required | The number of interactions that were answered in this second |
| flowedout_count | int32 | Required | The number of interactions that were flowed out in this second |
| db_last_updated | datetime | The last time this record was updated in UTC |