Skip to content

conversation_uni_yyyy_mm__flow_outcomes

Description: Monthly denormalized fact table of Genesys Cloud interactions containing conversation, participant, session and segment data.

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.

Last updated: