ContactsReport
Query the Contacts Report via the Explore API. Provides detailed information on each contact within an interaction. Up to a month of data per request.
Select
The ContactsReport is a report view backed by the Talkdesk Explore API. The connector 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 connector defaults the time range to the last 31 days.
For example, the following query is processed server-side:
SELECT * FROM ContactsReport WHERE TimespanFrom >= '2025-01-01' AND TimespanTo < '2025-02-01'
Columns
| Name | Type | References | Description |
| InteractionId [KEY] | String | The unique identifier of the interaction. | |
| ContactId [KEY] | String |
Contacts.Id | The unique identifier of the contact within the interaction. |
| CompanyNumber | String | The company phone number used in the contact. | |
| PhoneDisplayName | String | The display name of the phone number. | |
| ContactPersonNumber | String | The phone number of the contact person. | |
| ExternalPhoneNumber | String | The external phone number, if applicable. | |
| Direction | String | The direction of the contact. Example values: IN, OUT. | |
| ContactType | String | The type of contact. Example values: Answered, Connected, Missed, Abandoned. | |
| StartedAt | Datetime | The start time of the contact. | |
| WaitTime | Double | The waiting time before the contact was handled, in seconds. | |
| TimeToMissed | Double | The time until the contact was missed, in seconds. | |
| AbandonTime | Double | The time until the contact was abandoned, in seconds. | |
| ShortAbandonTime | Double | The short abandon time, in seconds. | |
| TimeToVoicemail | Double | The time until the contact went to voicemail, in seconds. | |
| RingTime | Double | The ring time before the contact was answered, in seconds. | |
| ConnectTime | Double | The connect time, in seconds. | |
| AnsweredAt | Datetime | The time the contact was answered. | |
| ConnectedAt | Datetime | The time the contact was connected. | |
| TalkTime | Double | The talk time duration, in seconds. | |
| HardHoldTime | Double | The hard hold time, in seconds. | |
| SoftHoldTime | Double | The soft hold time, in seconds. | |
| HoldTime | Double | The total hold time, in seconds. | |
| AfterCallWorkTime | Double | The after-call work time, in seconds. | |
| FinishedAt | Datetime | The time the contact was finished. | |
| Duration | Double | The total duration of the contact, in seconds. | |
| HandleTime | Double | The handle time of the contact, in seconds. | |
| InsideBusinessHours | String | Whether the contact occurred during business hours. Values: Yes, No. | |
| InsideServiceLevel | String | Whether the contact was within the service level threshold. Values: Yes, No. | |
| WithinServiceLevelThreshold | String | Whether the contact was answered within the service level threshold. Values: Yes, No. | |
| TransferOut | String | Whether the contact was transferred out. Values: Yes, No. | |
| TransferOutType | String | The type of transfer out, if applicable. | |
| TransferIn | String | Whether the contact was a transfer in. Values: Yes, No. | |
| TransferInType | String | The type of transfer in, if applicable. | |
| Callback | String | Whether the contact was a callback. Values: Yes, No. | |
| RingGroups | String | The ring groups associated with the contact. | |
| UserName | String | The name of the agent who handled the contact. | |
| DirectAssignmentUser | String | The user directly assigned to the contact, if applicable. | |
| TeamName | String | The team name of the agent who handled the contact. | |
| UserId | String |
Users.Id | The unique identifier of the agent who handled the contact. |
| DirectAssignmentIds | String | The IDs of directly assigned users, if applicable. | |
| TeamId | String |
Teams.Id | The unique identifier of the team. |
| HandlingRingGroups | String | The ring groups that handled the contact. | |
| DisconnectedByAgent | String | Whether the contact was disconnected by the agent. Values: Yes, No. | |
| LastContact | String | Whether this was the last contact in the interaction. Values: Yes, No. | |
| DataStatus | String | The data status of the contact record. Example values: Valid. | |
| HandlingAttributeNames | String | The names of handling attributes assigned to the contact. | |
| HandlingAttributeLevels | String | The proficiency levels of handling attributes. | |
| UserAttributeNames | String | The names of user attributes assigned to the agent. | |
| UserAttributeLevels | String | The proficiency levels of user attributes. |
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. |