Sv translation | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DescriptionThis report contains itemised call details for all calls made using a selection of service numbers. The calls are reported whether they only use the IVR, the IVR and the ACD or just the ACD. Both inbound and outbound calls are reported.
Row and Column PopulationRowsAt least one line row per call is produced. There will be additional lines rows in the report if more than one of any of the following actions happens:
ColumnsThe columns are grouped into 4 areas, populated as follows: The system records data as follows:
Cases
Sample Execution (Input) → Sample Report (Output)ColumnsThe following columns are provided. Legend
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sv translation | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Table of Contents | ||||||
---|---|---|---|---|---|---|
|
Description
Ce rapport contient des données agrégées pour les appels entrants et sortants vers les numéros de service sélectionnés sur la période et la granularité choisies. Les données sont regroupées par marqueurs de statistiques IVR sélectionnés puis par granularité et ne sont pas présentées individuellement par marqueur de statistiques IVR ou par numéro de service.
Exemple d'exécution (entrée) → Exemple de rapport (sortie)
Colonnes
Les colonnes suivantes sont fournies.
Légende
Tableau
Alias
StatisticsPartA (voir aussi Référence au tableau - StatisticsPartA (A))
a
AcdStatisticsPartB (Voir aussi Tableau de référence - AcdStatisticsPartB (AcdB) )
acdb
StatisticsPartB (Voir aussi Tableau de référence - StatisticsPartB (B) )
b
Appels
AcdGetIvrStatisticsMarkers_CountCalls
Connecté
AcdGetIvrStatisticsMarkers_CountCallsAgents
COUNT( DISTINCT( a.ID ) )
acdb.dtAgentConnect IS NOT NULL
Pourcent
marqueur d'appel
AcdGetIvrStatisticsMarkers_Count
Pourcent
0 - 9
AcdGetIvrStatisticsMarkers_RatingValue
COUNT( ivr.ID )
ivr.IVRStatisticsMarkersID = <IvrStatisticsMarkersID>
for calls to and from agents and external destinations made to / from the ACD. | b2 |
a - Columns
Column | Source Table (when not StatisticsPartA) | Field |
---|---|---|
a_ID | ID | |
a_ServiceNumbersID | ServiceNumbersID | |
a_ServiceNumbersName | ServiceNumbers | Name |
a_ServiceNumbersName2 | ServiceNumbers | Name2 |
a_DynamicPriorityGroupsID | DynamicPriorityGroupsID | |
a_DynamicPriorityGroupsName | DynamicPriorityGroups | Name |
a_ANumber | ANumber | |
a_BNumber | BNumber | |
a_bOutbound | bOutbound | |
a_dtCallStart | dtCallStart | |
a_dtCallAlert | dtCallAlert | |
a_dtCallConnect | dtCallConnect | |
a_dtCallEnd | dtCallEnd | |
a_bCallerHangup | bCallerHangup | |
a_CauseCodesID | CauseCodesID | |
a_RoutingApplicationsID | RoutingApplicationsID | |
a_RoutingApplicationsName | RoutingApplications | Name |
a_CONNRES | CONNRES | |
a_UserData | UserData | |
a_UserData2 | UserData2 | |
a_UserData3 | UserData3 | |
a_DiallerCampaignsID | DiallerCampaignsID | |
a_DiallerCampaignsName | DiallerCampaigns | Name |
a_AcdEventsID | AcdEventsID |
b1 - Columns
Column | Source Table (when not StatisticsPartB) | Field |
---|---|---|
b1_ID | ID | |
b1_ANumber | ANumber | |
b1_BNumber | BNumber | |
b1_dtCallStart | dtCallStart | |
b1_dtCallAlert | dtCallAlert | |
b1_dtCallConnect | dtCallConnect | |
b1_dtWhisperEnd | dtWhisperEnd | |
b1_dtCallEnd | dtCallEnd | |
b1_bCallerHangup | bCallerHangup | |
b1_CauseCodesID | CauseCodesID | |
b1_CNumbersID | CNumbersID | |
b1_CNumbersName | CNumbers | Name |
b1_CONNRES | CONNRES |
acdb - Columns
Column | Source Table (when not AcdStatisticsPartB) | Field |
---|---|---|
acdb_ID | ID | |
acdb_AcdGroupsID | AcdGroupsID | |
acdb_AcdGroupsName | AcdGroups | Name |
acdb_AcdConfigurationGroupsID | AcdConfigurationGroupsID | |
acdb_AcdConfigurationGroupsName | AcdGroups | Name |
acdb_AcdGroupEndReasonsID | AcdGroupEndReasonsID | |
acdb_AcdGroupEndReasonsName | AcdGroupEndReasons | Name (via ShortTexts) |
acdb_AcdGroupActionListID | AcdGroupActionListID | |
acdb_AcdGroupActionListName | AcdGroupActionList | Name |
acdb_AcdGroupActionTypesID | AcdGroupActionTypesID | |
acdb_AcdGroupActionTypesName | AcdGroupActionTypes | Name (via ShortTexts) |
acdb_AcdGroupCheckPointsID | AcdGroupCheckPointsID | |
acdb_AcdGroupCheckPointsName | AcdGroupCheckPoints | Name (via ShortTexts) |
acdb_nPriorityGroupStart | nPriorityGroupStart | |
acdb_nPriorityGroupEnd | nPriorityGroupEnd | |
acdb_dtGroupStart | dtGroupStart | |
acdb_dtAnnouncement1Start | dtAnnouncement1Start | |
acdb_dtAnnouncement2Start | dtAnnouncement2Start | |
acdb_dtQueueStart | dtQueueStart | |
acdb_dtDistributeStart | dtDistributeStart | |
acdb_dtAgentConnect | dtAgentConnect | |
acdb_dtGroupActionStart | dtGroupActionStart | |
acdb_dtGroupEnd | dtGroupEnd | |
acdb_bLastAgentConnect | bLastAgentConnect | |
acdb_bCallbackVoiceMailBooked | bCallbackVoiceMailBooked | |
acdb_bCallInStandardServiceTimes | bCallInStandardServiceTimes | |
acdb_AcdSkillsID1 | AcdSkillsID1 | |
acdb_AcdSkillsName1 | AcdSkills | Name |
acdb_bDeletedAcdSkillsID1 | bDeletedAcdSkillsID1 | |
acdb_AcdSkillsID2 | AcdSkillsID2 | |
acdb_AcdSkillsName2 | AcdSkills | Name |
acdb_bDeletedAcdSkillsID2 | bDeletedAcdSkillsID2 | |
acdb_AcdSkillsID3 | AcdSkillsID3 | |
acdb_AcdSkillsName3 | AcdSkills | Name |
acdb_bDeletedAcdSkillsID3 | bDeletedAcdSkillsID3 | |
acdb_nOverflowLevelIndicator | nOverflowLevelIndicator | |
acdb_ExtendedGroupSearchAcdGroupsID | ExtendedGroupSearchAcdGroupsID | |
acdb_ExtendedGroupSearchAcdGroupsName | AcdGroups | Name |
b2 - Columns
Column | Source Table (when not StatisticsPartB) | Field |
---|---|---|
b2_ID | ID | |
b2_ANumber | ANumber | |
b2_BNumber | BNumber | |
b2_dtCallStart | dtCallStart | |
b2_dtCallAlert | dtCallAlert | |
b2_dtCallConnect | dtCallConnect | |
b2_dtWhisperEnd | dtWhisperEnd | |
b2_dtCallEnd | dtCallEnd | |
b2_bCallerHangup | bCallerHangup | |
b2_CauseCodesID | CauseCodesID | |
b2_CNumbersID | CNumbersID | |
b2_CNumbersName | CNumbers | Name |
b2_CONNRES | CONNRES | |
b2_UsersID | UsersID | |
b2_UsersUID | Users | UID |
b2_UsersName | Users | Name |
b2_UsersFirstName | Users | FirstName |
b2_nSkillReal | nSkillReal | |
b2_nSkillAfterCorrection | nSkillAfterCorrection | |
b2_PostCallInterval | PostCallInterval | |
b2_AcdEventsID | AcdEventsID | |
b2_TransferAcdSynonymsID | TransferAcdSynonymsID | |
b2_TransferAcdSynonymsName | AcdSynonyms | Name |
b2_bTransferAgent | bTransferAgent | |
b2_bTransferExternalNumber | bTransferExternalNumber | |
b2_StatisticsPartBOrigin | StatisticsPartBOrigin | |
b2_OriginUsersID | OriginUsersID | |
b2_OriginUsersUID | Users | UID |
b2_OriginUsersName | Users | Name |
b2_OriginUsersFirstName | Users | FirstName |
Minimum
AcdGetIvrStatisticsMarkers_RatingMin
MIN( ivr.Rating)
ivr.IVRStatisticsMarkersID = <IvrStatisticsMarkersID>
Maximum
AcdGetIvrStatisticsMarkers_RatingMax
MAX( ivr.Rating)
ivr.IVRStatisticsMarkersID = <IvrStatisticsMarkersID>
Total
AcdGetIvrStatisticsMarkers_RatingTotal
SUM( ivr.Rating)
ivr.IVRStatisticsMarkersID = <IvrStatisticsMarkersID>
Moyenne
Table of Contents | ||||||
---|---|---|---|---|---|---|
|
language | de |
---|
Table of Contents | ||||||
---|---|---|---|---|---|---|
|
Beschreibung
Dieser Bericht enthält aggregierte Daten für eingehende und ausgehende Anrufe an die ausgewählten Dienstnummern über den gewählten Zeitraum und die gewählte Granularität. Die Daten werden nach ausgewählten IVR-Statistikmarkern und dann nach Granularität gruppiert und nicht einzeln pro IVR-Statistikmarker oder pro Servicenummer dargestellt.
Beispielausführung (Input) → Beispielreport (Output)
Dieser Report ist für die folgenden Ausgabeformate optimiert:
Status | ||||||
---|---|---|---|---|---|---|
|
Status | ||||||
---|---|---|---|---|---|---|
|
Spalten
Die folgenden Spalten sind bereitgestellt.
Legende
Table
Alias
StatisticsPartA (Siehe auch Table Reference - StatisticsPartA (A) )
a
AcdStatisticsPartB (Siehe auch Table Reference - AcdStatisticsPartB (AcdB) )
acdb
StatisticsPartB (Siehe auch Table Reference - StatisticsPartB (B) )
b
Anrufe
AcdGetIvrStatisticsMarkers_CountCalls
Connected
AcdGetIvrStatisticsMarkers_CountCallsAgents
COUNT( DISTINCT( a.ID ) )
acdb.dtAgentConnect IS NOT NULL
Percent
Call Marker
AcdGetIvrStatisticsMarkers_Count
Percent
0 - 9
AcdGetIvrStatisticsMarkers_RatingValue
COUNT( ivr.ID )
ivr.IVRStatisticsMarkersID = <IvrStatisticsMarkersID>
Minimum
AcdGetIvrStatisticsMarkers_RatingMin
MIN( ivr.Rating)
ivr.IVRStatisticsMarkersID = <IvrStatisticsMarkersID>
Maximum
AcdGetIvrStatisticsMarkers_RatingMax
MAX( ivr.Rating)
ivr.IVRStatisticsMarkersID = <IvrStatisticsMarkersID>
Total
AcdGetIvrStatisticsMarkers_RatingTotal
SUM( ivr.Rating)
ivr.IVRStatisticsMarkersID = <IvrStatisticsMarkersID>
Average
This column is calculated as follows: |
---|
Table of Contents | ||||||
---|---|---|---|---|---|---|
|
Sv translation | ||||||
---|---|---|---|---|---|---|
| ||||||
|
Sv translation | ||||||
---|---|---|---|---|---|---|
| ||||||
|