Description: Monthly denormalized fact table of Genesys Cloud interactions containing conversation, participant, session and segment data.
Columns
Section titled “Columns”| Column | Type | Description |
|---|---|---|
conversation_id |
text |
Unique identifier of the conversation/interaction in Genesys Cloud. |
session_id |
text |
Identifier of the interaction session. |
flow_outcome |
text |
Name of the flow outcome. |
flow_outcome_id |
text |
Identifier of the flow outcome. |
flow_outcome_value |
text |
Field flow_outcome_value extracted from Genesys Cloud. |
flow_outcome_start_timestamp |
timestamp with time zone |
Field flow_outcome_start_timestamp extracted from Genesys Cloud. |
flow_outcome_end_timestamp |
timestamp with time zone |
Field flow_outcome_end_timestamp extracted from Genesys Cloud. |
_sdc_source_key_id |
text |
Technical control field from the Singer/SDC pipeline. |
_sdc_sequence |
bigint |
Technical ingestion sequence from the Singer/SDC pipeline. |
_sdc_level_0_id |
bigint |
Technical identifier of the first nested array level in the Singer/SDC pipeline. |

