Data source: User Status History (App)
The User Status History data source is a collection of tables you can use to build user status history reports in App.
In this article
Overview
The User Status History data source is one of several data sources available for creating reports in App. To learn more about data sources in general, please see: Overview: Data sources for reports (App).
With the User Status History data source, you can create reports that show status changes over a historical period for users on your account.
You can use this data source to retrieve information like:
Show the status changes of a single user over the course of a day (when they logged in, when they handled interactions, etc.)
Show how multiple users are spending time in various statuses (On a call, Away, Busy, etc.)
This article provides common use cases for the creating reports with this data source and a list of the available tables when working with this data source.
Use case
You can use the User Status History data source to build reports to show the status changes of your users over a period of time, like over the course of a day or a week. This is called a user status history report.
These reports are useful when you want to see the status changes of a single user over the course of the day. For example, you could use this report to see when a user logged in, handled interactions, took a lunch break, and logged off for the day.
User status history reports are also useful when you want to see what multiple users are doing when they’re in particular statuses.
Tables
The User Status History data source consists only of the database tables that are relevant to this data source. This ensures you have access to the data you need when creating the types of reports that relate to this data source. .
Below are the tables available when creating a report with this data source. Click any of the links below to view column documentation for each table.
Contains general information for users on your organization’s account.
This information includes users’ name, title, and work contact information.
Contains records for all of the status changes for a user - this is for both queue and non-queue users.
The records that are included in this table is data like: the user’s status, the start time for when they entered into that status, the duration for how long the user was in a specific status, and more.
Contains general information about queues.
This information includes the queue’s name, weight, whether or not the queue is active, and more.