Sv translation | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||
Status |
BackgroundCompressedACDB15 and CompressedACDBDay tables are provided which compress the statistics based on an ACD Groups view of the calls. This means that for example, if a call is transferred from one group to another, it will be counted twice in the report, once for each ACD group. This type of counting is useful, for example, when using some personell planning tools which require a group / queue based view of the data for predicting the number of required agents. ParametersData is aggregated according to the settings of the parameters:
QueryTwo tables are provided, CompressedACDB15 (15 minute time slices) and CompressedACDBDay (day compression), aggregated according to the following query:
Partitioning and AggregationsWhen the data is aggregated, it is divided into several consistent partitions, according to the following logic. The resulting aggregations then either count a call, if a condition is met, or determine the time between two timestamps. Inbound and Outbound | |||||||||||||||||||||||||||||||||||||||
bOutbound | Fields | |||||||||||||||||||||||||||||||||||||||
1 | Outbound |
acdb.AcdGroupEntryReasonsID | Field |
NULL | Direct |
1 | OverflowIn_TransferIn |
2 | OverflowIn_GroupRules |
3 | OverflowIn_IVR |
Abandoned_* Fields
Further partitions records which have entered the ACD, only calls which enter the queueare abandoned.
The additional condition used is:
Translations Ignore | ||
---|---|---|
|
Inbound: Queue_Serviced_* Fields
Further partition on calls which entered the queue, only calls answered by an agent are considered (calls were definitely offhook). The condition used is:
|
NotQueued_Hangup field
The The additional condition used is:
Translations Ignore | ||
---|---|---|
|
Inbound: Queue_NotServiced_* Fields
|
NotQueued_Rule_* Fields
Further partition on calls which entered the queue, and were offhook, only calls not answered by an agent are considered. The condition used is:
Translations Ignore | ||
---|---|---|
|
Queued_Hungup field
The condition used isThese calls are further partitioned into Abandoned and Reject as follows:
Translations Ignore | ||
---|---|---|
|
Inbound: AgentCalls_*, GroupTransfer_*, AgentTransfer_*, NumberTransfer_* Fields
|
Queued_Rule_* Fields
The condition used is:
Translations Ignore | ||
---|---|---|
|
AgentCalls_*
The condition used isOnly records which meet the following condition are considered:
Translations Ignore | ||
---|---|---|
|
I.e. where an agent or destination call was made.
The following partitions are used:
Condition
Partition
Translations Ignore |
---|
StatisticsPartB.StatisticsPartBOrigin IS NULL |
AgentCalls_
Translations Ignore |
---|
( OR |
GroupTransfer_
Translations Ignore |
---|
( StatisticsPartB.StatisticsPartBOrigin IS NOT NULL ) AND ( StatisticsPartB.AcdGroupsID = AcdStatisticsPartB.AcdGroupsID ) AND ( StatisticsPartB.bTransferAgent <> 0 ) |
Translations Ignore |
---|
( StatisticsPartB.StatisticsPartBOrigin IS NOT NULL ) AND ( StatisticsPartB.AcdGroupsID = AcdStatisticsPartB.AcdGroupsID ) AND ( StatisticsPartB.bTransferExternalNumber <> 0 ) |
Further partitioning is according to the CONNRES field.
Outbound
Condition
Partitioning
Translations Ignore |
---|
DiallerCampaignsID IS NULL |
ClickToDial_
Translations Ignore |
---|
DiallerCampaignsID IS NOT NULL |
Inbound and Outbound: Partitioning on CONNRES
CONNRES
Result
1
OK
2
NoAnswer
3
Busy
4
CallerHangup
6
Rejected
0, 5, > 6
|
Tables
CompressedACDB15
This table contains compressed statistics for 15 minute intervals.
CompressedACDBDay
This table contains compressed statistics for day intervals.
Fields
The field definitions are essentially the same, in both tables, only the aggregation intervals are different.
Field | Type | Contents |
ID | INT | A unique ID assigned to each record. Note, that IDs are not re-used, since if an interval is recalculated, the record is added with REPLACE, i.e. the existing record will be delteted and a new record with a new ID will be created in its place. |
ClientsID | INT | ID of client from Clients table. |
ServiceNumbersID | INT | ID of service number from ServiceNumbers table. |
DynamicPriorityGroupsID | INT | ID of dynamic priority group from DynamicPriorityGroups table, or 0 if no dynamic priority group was used. |
RoutingApplicationsID | INT | ID of the routing application from the RoutingApplications table, or 0 if none was used. |
AcdGroupsID | INT | ID of the ACD group, from the AcdGroups table, or 0 for calls which did not enter the ACD. |
DiallerCampaignsID | INT | ID of the dialler campaign, from the DiallerCampaigns table, or 0 for calls which did not use a dialler campaign. |
dtIntervalStart | DATETIME | Date and Time of the start of the interval. |
ServiceNumbersRootNumber | VARCHAR(32) | The RootNumber field of the service number, as configured when the compressed statistics were created. |
ServiceNumbersName | VARCHAR(64) | The Name field of the service number, as configured when the compressed statistics were created. |
ServiceNumbersName2 | VARCHAR(64) | The Name2 field of the service number, as configured when the compressed statistics were created. |
DynamicPriorityGroupsName | VARCHAR(64) | The Name field from the DynamicPriorityGroups table, as configured when the compressed statistics were created. |
AcdGroupsName | VARCHAR(64) | The Name field from the AcdGroups table, as configured when the compressed statistics were created. |
DiallerCampaignsName | VARCHAR(64) | The Name field from the DiallerCampaigns table, as configured when the compressed statistics were created. |
ACD_Count | INT | Inbound calls to ACD, total. |
ACD_Direct | INT | Calls routed directly to the acd group and this is the first acd group the call has been processed in |
ACD_OverflowIn_TransferIn | INT | Calls routed to the ACD group due to an agent making a call transfer from one group to another group (blind or assisted) |
ACD_OverflowIn_GroupRules | INT | Calls routed to the ACD group by a group rule overflowing from one group to another |
ACD_OverflowIn_IVR | INT | Calls routed to the ACD group by the IVR and this was not the first group the call was processed in (so the call was in the ACD, left to go back to the IVR and then was routed to another ACD group by the IVR) |
GroupStart_LoggedInForCallsAgentCountExceptPostcall | INT | The number of agents logged into the acd group for calls at the time the call entered the group, not including agents who were in automatic post call. |
GroupStart_LoggedInForCallsAgentCount | INT | The number of agents logged into the acd group for calls at the time the call entered the group. |
GroupStart_PresentAgentCount | INT | The number of agents logged into the acd group who were in a status with the “present” flag in the ACD agent status when the call entered the ACD group. |
GroupStart_LoggedInToAcdAgentCount | INT | The number of agents logged into the acd group (in any status) when the call entered the ACD group. |
GroupStart_LoggedInRequiredSkillAgentCount | INT | The number of agents logged into the acd group (in any status) when the call entered the ACD group who had the required skills associated with the call. |
GroupStart_Client_LoggedInAgentCount | INT | The number of agents logged into the client account in total (over all ACD groups), when the call entered the ACD group. |
Abandoned_BeforeQueue_Count | INT | Calls that are abandoned before queue. |
Abandoned_BeforeQueue_Time_GroupStart_GroupEnd_Total | BIGINT | Calls that are abandoned before queue, total seconds from dtGroupStart to dtGroupEnd. |
Abandoned_BeforeQueue_Time_GroupStart_GroupEnd_Max | INT | Calls that are abandoned before queue, max seconds from dtGroupStart to dtGroupEnd. |
Abandoned_Queue_Count | INT | Calls that are abandoned in queue. |
Abandoned_Queue_Time_GroupStart_GroupEnd_Total | BIGINT | Calls that are abandoned in queue, total seconds from dtGroupStart to dtGroupEnd. |
Abandoned_Queue_Time_GroupStart_GroupEnd_Max | INT | Calls that are abandoned in queue, max seconds from dtGroupStart to dtGroupEnd. |
Abandoned_Queue_5Sec_Count | INT | Calls that are abandoned in queue in less than 5 seconds. |
Abandoned_Queue_5Sec_Time_GroupStart_GroupEnd_Total | BIGINT | Calls that are abandoned in queue in less than 5 seconds, total seconds from dtGroupStart to dtGroupEnd. |
Abandoned_Queue_5Sec_Time_GroupStart_GroupEnd_Max | INT | Calls that are abandoned in queue in less than 5 seconds, max seconds from dtGroupStart to dtGroupEnd. |
Abandoned_SLA_Count | INT | Calls that are abandoned within service level. |
NotQueued_Hangup_Count | INT | Calls that are not queued and hangup by the system. |
NotQueued_Hangup_Time_GroupStart_GroupEnd_Total | BIGINT | Calls that are not queued and hangup by the system, total seconds from dtGroupStart to dtGroupEnd. |
NotQueued_Hangup_Time_GroupStart_GroupEnd_Max | INT | Calls that are not queued and hangup by the system, max seconds from dtGroupStart to dtGroupEnd. |
NotQueued_Rule_Count | INT | Calls that are not queued by a Group rule. |
NotQueued_Rule_Time_GroupStart_GroupEnd_Total | BIGINT | Calls that are not queued by a Group rule, total seconds from dtGroupStart to dtGroupEnd. |
NotQueued_Rule_Time_GroupStart_GroupEnd_Max | INT | Calls that are not queued by a Group rule, max seconds from dtGroupStart to dtGroupEnd. |
NotQueued_Rule_Hangup_Count | INT | Calls that are not queued by a Group rule and the rule is Hangup. |
NotQueued_Rule_Hangup_Time_GroupStart_GroupEnd_Total | BIGINT | Calls that are not queued by a Group rule and the rule is Hangup, total seconds from dtGroupStart to dtGroupEnd. |
NotQueued_Rule_Hangup_Time_GroupStart_GroupEnd_Max | INT | Calls that are not queued by a Group rule and the rule is Hangup, max seconds from dtGroupStart to dtGroupEnd. |
NotQueued_Rule_Overflow_Count | INT | Calls that are not queued by a Group rule and the rule is Overflow to group. |
NotQueued_Rule_Overflow_Time_GroupStart_GroupEnd_Total | BIGINT | Calls that are not queued by a Group rule and the rule is Overflow to group, total seconds from dtGroupStart to dtGroupEnd. |
NotQueued_Rule_Overflow_Time_GroupStart_GroupEnd_Max | INT | Calls that are not queued by a Group rule and the rule is Overflow to group, max seconds from dtGroupStart to dtGroupEnd. |
NotQueued_Rule_MediaEvent_Count | INT | Calls that are not queued by a Group rule and the rule is request/create Media event (Voicemail, Callback, Fax). |
NotQueued_Rule_MediaEvent_Time_GroupStart_GroupEnd_Total | BIGINT | Calls that are not queued by a Group rule and the rule is request/create Media event, total seconds from dtGroupStart to dtGroupEnd. |
NotQueued_Rule_MediaEvent_Time_GroupStart_GroupEnd_Max | INT | Calls that are not queued by a Group rule and the rule is request/create Media event, max seconds from dtGroupStart to dtGroupEnd. |
NotQueued_Rule_ExDestination_Count | INT | Calls that are not queued by a Group rule and the rule is External destination. |
NotQueued_Rule_ExDestination_Time_GroupStart_GroupEnd_Total | BIGINT | Calls that are not queued by a Group rule and the rule is External destination, total seconds from dtGroupStart to dtGroupEnd. |
NotQueued_Rule_ExDestination_Time_GroupStart_GroupEnd_Max | INT | Calls that are not queued by a Group rule and the rule is External destination, max seconds from dtGroupStart to dtGroupEnd. |
Queued_Hangup_Count | INT | Calls that are queued and hangup by the system. |
Queued_Hangup_Time_GroupStart_GroupEnd_Total | BIGINT | Calls that are queued and hangup by the system, total seconds from dtGroupStart to dtGroupEnd. |
Queued_Hangup_Time_GroupStart_GroupEnd_Max | INT | Calls that are queued and hangup by the system, max seconds from dtGroupStart to dtGroupEnd. |
Queued_Hangup_Time_QueueStart_GroupEnd_Total | BIGINT | Calls that are queued and hangup by the system, total seconds from dtqueueStart to dtGroupEnd. |
Queued_Hangup_Time_QueueStart_GroupEnd_Max | INT | Calls that are queued and hangup by the system, max seconds from dtQueueStart to dtGroupEnd. |
Queued_Rule_Count | INT | Calls that are queued by a Group rule. |
Queued_Rule_Time_GroupStart_GroupEnd_Total | BIGINT | Calls that are queued by a Group rule, total seconds from dtGroupStart to dtGroupEnd. |
Queued_Rule_Time_GroupStart_GroupEnd_Max | INT | Calls that are queued by a Group rule, max seconds from dtGroupStart to dtGroupEnd. |
Queued_Rule_Hangup_Count | INT | Calls that are queued by a Group rule and the rule is Hangup. |
Queued_Rule_Hangup_Time_GroupStart_GroupEnd_Total | BIGINT | Calls that are queued by a Group rule and the rule is Hangup, total seconds from dtGroupStart to dtGroupEnd. |
Queued_Rule_Hangup_Time_GroupStart_GroupEnd_Max | INT | Calls that are queued by a Group rule and the rule is Hangup, max seconds from dtGroupStart to dtGroupEnd. |
Queued_Rule_Overflow_Count | INT | Calls that are queued by a Group rule and the rule is Overflow to group. |
Queued_Rule_Overflow_Time_GroupStart_GroupEnd_Total | BIGINT | Calls that are queued by a Group rule and the rule is Overflow to group, total seconds from dtGroupStart to dtGroupEnd. |
Queued_Rule_Overflow_Time_GroupStart_GroupEnd_Max | INT | Calls that are queued by a Group rule and the rule is Overflow to group, max seconds from dtGroupStart to dtGroupEnd. |
Queued_Rule_MediaEvent_Count | INT | Calls that are queued by a Group rule and the rule is request/create Media event (Voicemail, Callback, Fax). |
Queued_Rule_MediaEvent_Time_GroupStart_GroupEnd_Total | BIGINT | Calls that are queued by a Group rule and the rule is request/create Media event (Voicemail, Callback, Fax), total seconds from dtGroupStart to dtGroupEnd. |
Queued_Rule_MediaEvent_Time_GroupStart_GroupEnd_Max | INT | Calls that are queued by a Group rule and the rule is request/create Media event (Voicemail, Callback, Fax), max seconds from dtGroupStart to dtGroupEnd. |
Queued_Rule_ExDestination_Count | INT | Calls that are queued by a Group rule and the rule is External destination. |
Queued_Rule_ExDestination_Time_GroupStart_GroupEnd_Total | BIGINT | Calls that are queued by a Group rule and the rule is External destination, total seconds from dtGroupStart to dtGroupEnd. |
Queued_Rule_ExDestination_Time_GroupStart_GroupEnd_Max | INT | Calls that are queued by a Group rule and the rule is External destination, max seconds from dtGroupStart to dtGroupEnd. |
AgentCall_Count | INT | Total calls to agent. |
AgentCall_SLA_Count | INT | Total calls to agent within the Service level. |
AgentCall_Time_GroupStart_GroupEnd_Total | BIGINT | Total calls to agent, total seconds from dtGroupStart to dtGroupEnd. |
AgentCall_Time_GroupStart_GroupEnd_Max | INT | Total calls to agent, max seconds from dtGroupStart to dtGroupEnd. |
AgentCall_Time_GroupStart_AgentConnect_Total | BIGINT | Total calls to agent, total seconds from dtGroupStart to dtAgentConnect. |
AgentCall_Time_GroupStart_AgentConnect_Max | INT | Total calls to agent, max seconds from dtGroupStart to dtAgentConnect. |
AgentCall_Time_QueueStart_AgentConnect_Total | BIGINT | Total calls to agent, total seconds from dQueueStart to dtAgentConnect. |
AgentCall_Time_QueueStart_AgentConnect_Max | INT | Total calls to agent, max seconds from dtQueueStart to dtAgentConnect. |
AgentCall_Time_AgentConnect_GroupEnd_Total | BIGINT | Total calls to agent, total seconds from dtAgentConnect to dtGroupEnd. |
AgentCall_Time_AgentConnect_GroupEnd_Max | INT | Total calls to agent, max seconds from dtAgentConnect to dtGroupEnd. |
AgentCall_Time_CallStart_CallEnd_Total | BIGINT | Total calls to agent, total seconds from dtCallStart to dtCallEnd. |
AgentCall_Time_CallStart_CallEnd_Max | INT | Total calls to agent, max seconds from dtCallStart to dtCallEnd. |
AgentCall_PostCall_Time_Total | BIGINT | Inbound calls to agents, agent answered, post call work required, total seconds |
AgentCall_PostCall_Time_Max | INT | Inbound calls to agents, agent answered, post call work required, max seconds |
...