5.13.0 5.12.0 5.11.0 5.10.0 5.9.0 5.8.0 5.7.0 5.6.0 5.5.0 5.4.0 5.3.0 5.2.0 5.1.0 5.0 4.10 4.9 4.8 4.7 4.6 4.5.3 4.5.2 4.5.1 4.5 4.4 4.3
5.13.0 5.12.0 5.11.0 5.10.0 5.9.0 5.8.0 5.7.0 5.6.0 5.5.0 5.4.0 5.3.0 5.2.0 5.1.0 5.0 4.10 4.9 4.8 4.7 4.6 4.5.3 4.5.2 4.5.1 4.5 4.4 4.3

Channel Session

Channel Session

The source level modular information is present in Transformation Rules - ETL Pipelines | Channel Session

Manipulations:

Column

Description

start_time

cimEvent.timestamp where topic event is CHANNEL_SESSION_STARTED

end_time

cimEvent.timestamp where topic event is CHANNEL_SESSION_ENDED

disposition

cimEvent.channelSession.state.reasonCode where topic event is CHANNEL_SESSION_ENDED

Aggregations:

Column

Description

total_session_duration

Difference between start_time and end_time for a specific session

bot_acitivity_count

Sum of BOT_MESSAGES for a particular session

agent_activity_count

Sum of AGENT_MESSAGES for a particular session

customer_activity_count

Sum of CUSTOMER_MESSAGES for a particular session

avg_bot_confidence_level

Currently hard coded as 0.1

On-boarding on Data Platform

Channel Session Workflow in EF Data Platform.drawio.png