Login Logout Extract
Updated
This documentation outlines the extract capturing agent login and logout timestamp data. The Login-Logout Extract provides session-level records reflecting when agents log in to and log out of the platform.
Each row represents a unique login session and includes the corresponding login timestamp, logout timestamp, total logged-in duration, and logout cause. This extract enables visibility into agent session activity without including interaction-level performance metrics.
Purpose
Provide agent login and logout timestamp data.
Enable tracking of agent session activity, provides visibility into session duration and logout behaviour.
Support operational monitoring and workforce reporting.
Extract Configuration and Availability
The extract configuration and availability details are listed below:
Extract Attribute | Details |
Channel Split | Not channel-specific; platform-level agent session data |
Agent Split | Agent ID provides the split of all login sessions performed by the agent |
Granularity | Login Session-Level - Each row indicates unique Login Session ID |
Date Filter | Extract depicts data based on Login Timestamp of the agent |
Update Frequency | 1 min after the login event logged |
Custom Field Behavior | Custom Fields by default are not added in this extract but feasibility of custom field exists in the particular extract based on below:
Default Behavior: User Custom Field: Current Value |
Data Schema
The schema details are listed below:
Metrics | Definition | Unique Key | Data Type | Is Null |
Agent | The sprinklr user for whom the report is being generated | Varchar | N | |
Agent ID | The sprinklr user ID for whom the report is being generated | Y | Number | N |
Login Timestamp | Date Timestamp when Agent logged in to the system | Timestamp | N | |
Logout Timestamp | Date Timestamp when Agent Logged out of the system | Timestamp | N | |
Logged In Time | Measures total time that agent logged in to the system | Number | N | |
Session ID | This gives the unique login session Id for the user. | Y | Varchar | N |
Logout Cause | Indicates the reason an agent logged out of the platform. This dimension helps identify whether the logout was due to session expiry, forced logout, user logout etc. | Varchar | N |
Data Settings
Reporting Preferences allow users to customize the default formats for specific metric types. These preferences are applied at the user level. If no changes are made, the system will continue to honor the following defaults:
Default Timestamp Format: MM DD, YYYY, HH:MM AM/PM - Eg: Jan 15, 2026, 12:36 AM
Default Time Duration Format: HH (h) MM (min) SS (s) - Eg: 3h 02m 35s
For more details, refer to the related article.
When Custom Fields are added in an Extract, they must be treated as Unique Key during calculations to ensure accuracy and consistency.
Note:
Each row represents a unique Session ID, corresponding to a single login session for an agent.
The extract includes only login and logout activity and does not contain call or interaction-level metrics.
Logout Cause identifies the reason for session termination (e.g., user logout, forced logout, session expiry).
The Agent ID field can be mapped with other agent-level extracts (e.g., Agent Performance or Agent Skill) for enriched reporting.