Custom Query

The Custom Query utility enables you to view ASR and cost / revenue information for all calls going from selected customer(s) to selected vendor(s). This query can also be filtered by destination and a precise time interval. The Split list allows the report to be divided into hourly and daily intervals.

Select a customer or vendor, or a destination (which may be specified exactly), or use a wildcard. (For example, all calls to England may be specified as “44%” in the destination field.) A date and time range for the search must be specified. To initiate the query, click the Show results button.

The results table contains two rows, one each for the customer and the vendor.

• Calls
• Billable Calls
• Duration, min:sec
• ASR (Average Success Rate)
• ALOC (Average Length of Call), min:sec
• Cost / Revenue, in the PortaBilling® owner’s currency

The Custom Query utility is a tool for monitoring various parameters of your current call flow. It should not be used to obtain billing statistics for a particular vendor (use the xDR statistics for the corresponding vendor), and should never be used to obtain information such as “total minutes for a particular customer”. Since this report operates with the vendor’s xDR, it will provide figures according to the vendor’s time rounding, not the customer’s. This can make a significant difference (e.g. your vendor uses 1 second rounding, while customers are billed on a per-minute basis).