You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

Description

This report contains aggregated data for inbound and outbound calls to the selected service numbers over the time period and granularity chosen. Data is grouped per selected IVR statistics markers then per granularity and not presented individually per IVR statistics marker or per service number.

Sample Execution (Input) → Sample Report (Output)

This report is optimised for the following output formats: PDFHTML

Columns

The following columns are provided.

Legend

Table

Alias

StatisticsPartA (See also Table Reference - StatisticsPartA (A) )

a

AcdStatisticsPartB (See also Table Reference - AcdStatisticsPartB (AcdB) )

acdb

StatisticsPartB (See also Table Reference - StatisticsPartB (B) )

b

StatisticsPartIVR ( See also Table Reference - StatisticsPartIVR )ivr

Calls

AcdGetIvrStatisticsMarkers_CountCalls

Criteria UsedDescription
COUNT( a.ID )Total number of inbound and outbound calls made via the selected service number(s) within a particular time slice.

Connected

AcdGetIvrStatisticsMarkers_CountCallsAgents

Criteria UsedDescription

COUNT( DISTINCT( a.ID ) )

acdb.dtAgentConnect IS NOT NULL

Total number of inbound and outbound calls made via the selected service number(s) within a particular time slice and which were successfully connected to the destination.

Percent

This column is calculated as follows:
Connected * 100 / Calls

Call Marker

AcdGetIvrStatisticsMarkers_Count

Criteria UsedDescription
COUNT( ivr.ID )Total number of inbound and outbound calls made via the selected service number(s) within a particular time slice.

Percent

This column is calculated as follows:
Call Marker * 100 / Calls

0 - 9

AcdGetIvrStatisticsMarkers_RatingValue

Criteria UsedDescription

COUNT( ivr.ID )

ivr.IVRStatisticsMarkersID = <IvrStatisticsMarkersID>


Total number of inbound and outbound calls made via the selected service number(s) within a particular time slice and which went through a statistics marker of type <IvrStatisticsMarkersID>. Where <IvrStatisticsMarkersID> is 0, 1, ..., or 9.

Minimum

AcdGetIvrStatisticsMarkers_RatingMin

Criteria UsedDescription

MIN( ivr.Rating)

ivr.IVRStatisticsMarkersID = <IvrStatisticsMarkersID>


Minimum number of inbound and outbound calls made via the selected service number(s) within a particular time slice and which went through a statistics marker of type <IvrStatisticsMarkersID>. Where <IvrStatisticsMarkersID> is 0, 1, ..., or 9.

Maximum

AcdGetIvrStatisticsMarkers_RatingMax

Criteria UsedDescription

MAX( ivr.Rating)

ivr.IVRStatisticsMarkersID = <IvrStatisticsMarkersID>


Maximum number of inbound and outbound calls made via the selected service number(s) within a particular time slice and which went through a statistics marker of type <IvrStatisticsMarkersID>. Where <IvrStatisticsMarkersID> is 0, 1, ..., or 9.

Total

AcdGetIvrStatisticsMarkers_RatingTotal

Criteria UsedDescription

SUM( ivr.Rating)

ivr.IVRStatisticsMarkersID = <IvrStatisticsMarkersID>


Total number of inbound and outbound calls made via the selected service number(s) within a particular time slice and which went through a statistics marker of type <IvrStatisticsMarkersID>. Where <IvrStatisticsMarkersID> is 0, 1, ..., or 9.

Average

This column is calculated as follows:
Total  * 100 / Call Marker

  • No labels