Description: Resumo analítico de speech and text analytics by conversation.
Columns
Section titled “Columns”| Column | Type | Description |
|---|---|---|
conversation_id |
text |
Unique identifier of the conversation/interaction in Genesys Cloud. |
conversation_start_time |
timestamp with time zone |
Conversation start date/time. |
conversation_sentiment_score |
double precision |
Field conversation_sentiment_score extracted from Genesys Cloud. |
conversation_sentiment_trend |
double precision |
Field conversation_sentiment_trend extracted from Genesys Cloud. |
conversation_empathy_score |
double precision |
Field conversation_empathy_score extracted from Genesys Cloud. |
conv_duration_ms |
bigint |
Valor em milissegundos. |
handle_time_ms |
bigint |
Valor em milissegundos. |
cust_speech_ms |
bigint |
Valor em milissegundos. |
agent_speech_ms |
bigint |
Valor em milissegundos. |
overtalk_ms |
bigint |
Valor em milissegundos. |
overtalk_instances |
bigint |
Field overtalk_instances extracted from Genesys Cloud. |
silence_ms |
bigint |
Valor em milissegundos. |
ivr_ms |
bigint |
Valor em milissegundos. |
other_ms |
bigint |
Valor em milissegundos. |
queue_acd_ms |
bigint |
Valor em milissegundos. |
cust_speech_pct |
double precision |
Calculated percentage. |
agent_speech_pct |
double precision |
Calculated percentage. |
overtalk_pct |
double precision |
Calculated percentage. |
silence_pct |
double precision |
Calculated percentage. |
ivr_pct |
double precision |
Calculated percentage. |
other_pct |
double precision |
Calculated percentage. |
queue_acd_pct |
double precision |
Calculated percentage. |
_sdc_received_at |
timestamp with time zone |
Timestamp when the record was received by the Singer/SDC pipeline. |
_sdc_sequence |
bigint |
Technical ingestion sequence from the Singer/SDC pipeline. |
_sdc_table_version |
bigint |
Technical table version in the Singer/SDC pipeline. |
_sdc_batched_at |
timestamp with time zone |
Timestamp when the record was batch-written by the Singer/SDC pipeline. |
agent_user_id |
text |
Identificador do user/agente da conversation. |
agent_queue_id |
text |
Identificador da queue do agent na conversation. |

