Description: Agent empathy metrics by conversation.
Loading diagram…
erDiagram
SPEECH_AGENTS_EMPATHY {
string conversation_id
string transcript_id
string agent_user_id
float agent_empathy_score
string conversation_start_time
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
SPEECH_TRANSCRIPTS {
string conversation_id PK
datetime conversation_start_time
float conversation_sentiment_score
float conversation_sentiment_trend
float conversation_empathy_score
bigint conv_duration_ms
bigint handle_time_ms
bigint cust_speech_ms
bigint agent_speech_ms
bigint overtalk_ms
bigint overtalk_instances
bigint silence_ms
bigint ivr_ms
bigint other_ms
bigint queue_acd_ms
float cust_speech_pct
float agent_speech_pct
float overtalk_pct
float silence_pct
float ivr_pct
float other_pct
float queue_acd_pct
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
string agent_user_id
string agent_queue_id
}
USERS {
string id PK
string name
string division__id
string department
string email
string state
string title
string username
string manager__id
float version
string employer_info__official_name
string employer_info__employee_id
string employer_info__employee_type
string employer_info__date_hire
string routing_status__status
datetime routing_status__start_time
string presence__id
string presence__name
string presence__source
boolean presence__primary
string presence__presence_definition__id
string presence__presence_definition__system_presence
string presence__message
datetime presence__modified_date
string team__id
string team__name
string team__description
datetime team__date_modified
float team__member_count
boolean acd_auto_answer
string language_preference
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
SPEECH_AGENTS_EMPATHY }o--|| USERS : agent_user_id
SPEECH_AGENTS_EMPATHY }o--|| SPEECH_TRANSCRIPTS : conversation_id
| Source table |
Source column |
Target column |
| - |
- |
- |