Builds a session-level reporting table from already downloaded Genesys historical conversation data.
The action does not call Genesys APIs. It selects conversations by analytics_conversation.db_last_updated, rebuilds summary rows for affected conversations in deterministic batches, and advances its savepoint only after the refresh succeeds.
When multiple segments exist for a session, flattened segment fields use fixed first-by-time rules. The queue fields come from the first non-null queue segment. The wrap-up code fields come from the first non-null agent wrap-up segment, and wrap_up_note is taken from that same selected wrap-up segment.
Parameters
| Parameter | Description | |
|---|---|---|
| savepoint | Optional | The savepoint name to use (default 'session_activity_summary'). |
| start_date | Optional | Override the savepoint start date (yyyy-MM-dd or yyyy-MM-dd HH:mm:ss). |
| end_date | Optional | End date for the db_last_updated window. Defaults to the current maximum analytics_conversation.db_last_updated. |
| lookback_minutes | Optional | Minutes to subtract from the savepoint start when start_date is not provided (default 5). |
| batch_size | Optional | Number of affected conversations to rebuild per batch (default 5000). |
Tables Affected
Variables Set
No variables set.
Permissions needed
No permissions needed.
Examples
- conversations_from_datalake() session_activity_summary_when_updated()
- session_activity_summary_when_updated(start_date='2025-01-01')