Power BI Connector for Twilio

Build 24.0.9060

CallMetrics

The call metrics resource provides an overview of metadata and quality metrics for a provided call.

Table Specific Information

The call metrics resource provides an overview of metadata and quality metrics for a provided call.

Select

Twilio allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only the equals or = comparison.
NOTE: CallSid is required in order to query CallMetrics.

SELECT * FROM CallMetrics WHERE CallSid = 'CH7040b87e3664410aa4c241a3d6c85f0b'

SELECT * FROM CallMetrics WHERE CallSid = 'CH7040b87e3664410aa4c241a3d6c85f0b' AND edge = 'carrier_edge'

Columns

Name Type References Description
CallSid String

Calls.Sid

SID for the call
AccountSid String The account SID this call belongs to
CarrierEdgecodec Integer Contains Carrier edge codec value for the Twilio media gateway of a PSTN call
CarrierEdgecodec_name String Contains Carrier edge codec_name value for the Twilio media gateway of a PSTN call
CarrierEdgecumulativeJitterAvg Double Contains Carrier edge jitter average value for the Twilio media gateway of a PSTN call
CarrierEdgecumulativeJitterMax Double Contains Carrier edge jitter max value for the Twilio media gateway of a PSTN call
CarrierEdgecumulativePacketDelayVariationD300 Integer Contains Carrier edge packet_delay_variation value for the Twilio media gateway of a PSTN call
CarrierEdgecumulativePacketDelayVariationD50 Integer Contains Carrier edge packet_delay_variation value for the Twilio media gateway of a PSTN call
CarrierEdgecumulativePacketDelayVariationD70 Integer Contains Carrier edge packet_delay_variation value for the Twilio media gateway of a PSTN call
CarrierEdgecumulativePacketsLost Integer Contains Carrier edge packets_lost value for the Twilio media gateway of a PSTN call
CarrierEdgecumulativePacketsReceived Integer Contains Carrier edge packets_received value for the Twilio media gateway of a PSTN call
CarrierEdgeintervalPacketsLossPercentage Integer Contains Carrier edge packets_loss_percentage value for the Twilio media gateway of a PSTN call
CarrierEdgeintervalPacketsLost Integer Contains Carrier edge packets_lost value for the Twilio media gateway of a PSTN call
CarrierEdgeintervalPacketsReceived Integer Contains Carrier edge packets_received value for the Twilio media gateway of a PSTN call
CarrierEdgemetadataEdgeLocation String Contains Carrier edge location info for the Twilio media gateway of a PSTN call
CarrierEdgemetadataRegion String Contains Carrier edge region info for the Twilio media gateway of a PSTN call
ClientEdge String Contains metrics and properties for the Twilio media gateway of a Client call
Direction String Defines media stream direction from the perspective of the Twilio Media edge.
Edge String Represents the Twilio Media Edge the metric was captured on
SdkEdge String Contains metrics and properties for the SDK sensor library for Client calls
SipEdge String Contains metrics and properties for the Twilio media gateway of a SIP Interface or Trunking call
Timestamp Datetime Timestamp of metric sample.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060