Table Type: Historical Data
This table stores per-session metrics.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| emit_date | datetime | Primary Key, Required | The date the metric was emitted |
| session_id | string | Primary Key | The session id |
| db_last_updated | datetime | The last time this record was updated in the database | |
| db_when_created | datetime | The time this record was created in the database | |
| conversation_id | string | The conversation id | |
| participant_id | string | The participant id | |
| name | string | Primary Key | The name of the metric - one of: nBlindTransferred, nBotInteractions, nCobrowseSessions, nConnected, nConsult, nConsultTransferred, nConversations, nError, nOutbound, nOutboundAbandoned, nOutboundAttempted, nOutboundConnected, nOverSla, nStateTransitionError, nTransferred, oAudioMessageCount, oExternalAudioMessageCount, oExternalMediaCount, oMediaCount, oMessageCount, oMessageSegmentCount, oMessageTurn, oServiceLevel, oServiceTarget, tAbandon, tAcd, tActiveCallback, tActiveCallbackComplete, tAcw, tAgentResponseTime, tAgentVideoConnected, tAlert, tAnswered, tAverageAgentResponseTime, tAverageCustomerResponseTime, tBarging, tCoaching, tCoachingComplete, tConnected, tContacting, tDialing, tFirstConnect, tFirstDial, tFirstEngagement, tFirstResponse, tFlowOut, tHandle, tHeld, tHeldComplete, tIvr, tMonitoring, tMonitoringComplete, tNotResponding, tPark, tParkComplete, tShortAbandon, tTalk, tTalkComplete, tUserResponseTime, tVoicemail, tWait |
| value | int64 | Required | The metric value - times are in milliseconds |