CallsReport
Query the Calls Report (All Data Status) via the Explore API. Up to a month of data per request.
Select
The CallsReport is a report view. The driver processes the following pseudo-columns server-side; any other WHERE clause conditions are evaluated client-side.
- TimespanFrom supports the following operator: >=
- TimespanTo supports the following operator: <
- Timezone supports the following operator: =
If TimespanFrom and TimespanTo are omitted, the driver defaults the time range to the last 31 days.
For example, the following query is processed server-side:
SELECT * FROM CallsReport WHERE TimespanFrom >= '2025-01-01' AND TimespanTo < '2025-02-01'
Columns
| Name | Type | References | Description |
| InteractionId [KEY] | String | The unique identifier of the interaction. | |
| CallType | String | The type of call. Example values: inbound, outbound, outbound_missed. | |
| StartTime | Datetime | The start time of the call. | |
| EndTime | Datetime | The end time of the call. | |
| TalkdeskPhoneNumber | String | The Talkdesk phone number used in the call. | |
| CustomerPhoneNumber | String | The customer phone number. | |
| TalkTime | Double | The talk time duration of the call. | |
| Record | String | The URL of the call recording, if available. | |
| Hangup | String | How the call was terminated. Example values: disconnected. | |
| InBusinessHours | String | Whether the call occurred during business hours. Values: TRUE, FALSE. | |
| CallbackFromQueue | String | Whether the call was a callback from a queue. Values: TRUE, FALSE. | |
| WaitingTime | Double | The waiting time before the call was answered. | |
| AgentSpeedToAnswer | Double | The speed at which the agent answered the call. | |
| HoldingTime | Double | The total holding time during the call. | |
| Rating | String | The rating given for the call. | |
| Description | String | The description or notes associated with the call. | |
| AgentName | String | The name of the agent who handled the call. | |
| PhoneDisplayName | String | The display name of the phone number. | |
| DispositionCode | String | The disposition code assigned to the call. | |
| Transfer | String | Whether the call was transferred. Values: Yes, No. | |
| HandlingAgent | String | The agent currently handling the call, if different from the original agent. | |
| Tags | String | Comma-separated tags associated with the call. | |
| IVROptions | String | The IVR options selected during the call. | |
| CSATScore | String | The CSAT score for the call. | |
| CSATSurveyTime | String | The time the CSAT survey was completed. | |
| Mood | String | The detected mood of the customer during the call. | |
| MoodPrompted | String | Whether the customer was prompted for mood feedback. Values: Yes, No. | |
| Team | String | The team associated with the call. | |
| RatingReason | String | The reason given for the call rating. | |
| AgentDisconnected | String | Whether the agent disconnected the call. | |
| UsersEmail | String | The email address of the agent user. | |
| DataStatus | String | The data status of the call record. Example values: Valid. | |
| DispositionSet | String | The group of dispositions. | |
| NestedDisposition | String | Subcategory within Dispositions to label interactions with more granularity. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| TimespanFrom | Datetime | The start date for the report timespan. | |
| TimespanTo | Datetime | The end date for the report timespan. | |
| Timezone | String | The IANA timezone for the report timespan. |