OutboundPhoneNumberReport
A read-only view of Voice Insights metrics aggregated per outbound phone number handle for a previously generated report. Requires a ReportId returned by the GenerateOutboundPhoneNumberReport stored procedure.
View-Specific Information
SELECT
The connector uses the Twilio API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the connector.
| Column | Supported Operators |
| ReportId | = |
ReportId is required in the WHERE clause. It is returned by the GenerateOutboundPhoneNumberReport stored procedure, which defaults to the last 7 days when no time range is specified.
For example:
SELECT * FROM OutboundPhoneNumberReport WHERE ReportId = 'voiceinsights_report_00000000000000000000000000'
Columns
| Name | Type | References | Description |
| ReportId | String | The unique report identifier returned by the GenerateOutboundPhoneNumberReport stored procedure. Required in WHERE clause. | |
| Handle | String | Outbound phone number handle represented in the report. | |
| TotalCalls | Integer | Total number of outbound calls made during the report period. | |
| CallAnswerScore | Double | Score (0-100) representing how often outbound calls were answered. | |
| SilentCallsPercentage | Double | Percentage of calls with silence tags over total calls. A silent tag is indicative of a connectivity issue or muted audio. | |
| ShortDurationCallsPercentage | Double | Percentage of completed outbound calls under 6 seconds. More than 15% is typically indicative of low trust. | |
| LongDurationCallsPercentage | Double | Percentage of outbound calls lasting 60 seconds or longer. | |
| PotentialRobocallsPercentage | Double | Percentage of completed outbound calls to unassigned or unallocated phone numbers. | |
| CallsByDeviceTypeMobile | Integer | Number of outbound calls placed from a mobile device type. | |
| CallsByDeviceTypeVoip | Integer | Number of outbound calls placed from a VoIP device type. | |
| CallsByDeviceTypeLandline | Integer | Number of outbound calls placed from a landline device type. | |
| CallsByDeviceTypeUnknown | Integer | Number of outbound calls placed from an unknown device type. | |
| AnswerRateDeviceTypeMobile | Double | Answer rate percentage for outbound calls placed from a mobile device type. | |
| AnswerRateDeviceTypeVoip | Double | Answer rate percentage for outbound calls placed from a VoIP device type. | |
| AnswerRateDeviceTypeLandline | Double | Answer rate percentage for outbound calls placed from a landline device type. | |
| AnswerRateDeviceTypeUnknown | Double | Answer rate percentage for outbound calls placed from an unknown device type. | |
| CallStatePercentageBusy | Double | Percentage of outbound calls that ended with a busy state. | |
| CallStatePercentageCanceled | Double | Percentage of outbound calls that ended with a canceled state. | |
| CallStatePercentageCompleted | Double | Percentage of outbound calls that ended with a completed state. | |
| CallStatePercentageFail | Double | Percentage of outbound calls that ended with a failed state. | |
| CallStatePercentageNoAnswer | Double | Percentage of outbound calls that ended with a no-answer state. | |
| BlockedCallsByCarrier | String | JSON array with metrics for completed outbound calls blocked by downstream carriers (e.g. ATT, T-Mobile, Verizon in the US). | |
| AnsweringMachineDetectionTotalCalls | Integer | Total number of calls analyzed for answering machine detection. | |
| AnsweringMachineDetectionAnsweredByHumanPercentage | Double | Percentage of analyzed calls answered by a human. | |
| AnsweringMachineDetectionAnsweredByMachinePercentage | Double | Percentage of analyzed calls answered by a machine. |