Versions Compared

Old Version 4

changes.mady.by.user jtel Support

Saved on

compared with

New Version Current

changes.mady.by.user jtel Support

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

ACD entrant

Entrant répondu

Emails

Messagerie vocale + rappels

Appel entrant perdu

Destination extérieure

Disponibilité directe

Disponibilité y compris CB/VM

Sv translation
languageen

Table of Contents
maxLevel2
outlinetrue
typeflat

Status
colourRed
titleUNDER CONSTRUCTION

Sv translation
languagefr

Description

This report contains aggregated data for calls to and from service number(s) over the time period chosen. Data is presented aggregated over the complete time period selected. 

Warning
titleImportant Information

This report produces a row in the data, even if the service number has received no calls. 

In the selection criteria, the condition a.ID IS NOT NULL is used technically to ensure correct data counting.

Sample Report (Output)

Selection Criteria

The following selection criteria are provided:

CriteriaDescription
Output FormatThe format to produce the report in 
PeriodThe time period over which to produce the report
Service Level (s)Calls which enter the ACD group and are answered by an agent before the calculation dtAgentConnect - dtGroupStart exceeds this parameter will be considered as "in service" in the report.
Hangup Threshold (s)Calls which enter the ACD group and hangup before the time difference dtGroupEnd - dtGroupStart exceeds this parameter will be considered as "Short Hangups" in the report.
Service NumbersThe service numbers for which to produce the report.

Columns

Legend

Table

Alias

StatisticsPartA (See also Table Reference

Table of Contents
maxLevel2
outlinevrai
typeplat

Description

Ce rapport contient les données agrégées des appels entrants vers le(s) numéro(s) de service associé(s) aux numéros de facturation sélectionnés sur la période choisie. Les données sont présentées groupées par jour.

Exemple d'exécution (entrée) → Exemple de rapport (sortie)

Colonnes

Les colonnes suivantes sont fournies.

Légende

StatisticsPartA (Voir aussi Tableau de référence Voir aussi Tableau de référence Voir aussi Tableau de référence

Tableau

Alias

- StatisticsPartA (A) )

a

AcdStatisticsPartB (

See also Table Reference - AcdStatisticsPartB (AcdB) )

acdb

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

Total entrant

Critères utilisésDescription

COUNT( stats.ID ) 

a.bOutbound = 0

Nombre total d'appels entrants vers le(s) numéro(s) de service associé(s) au(x) numéro(s) de facturation sélectionné(s).
Critères utilisésDescription

COUNT( stats.ID ) 

a.bOutbound = 0

AND acdb.ID IS NOT NULL

Nombre total d'appels entrants vers le(s) numéro(s) de service associé(s) au(x) numéro(s) de facturation sélectionné(s) et qui ont été acheminés vers un groupe ACD.
Critères utilisésDescription

COUNT( stats.ID ) 

a.bOutbound = 0

acdb.dtAgentConnect IS NOT NULL

Nombre total d'appels entrants vers le(s) numéro(s) de service associé(s) au(x) numéro(s) de facturation sélectionné(s) et qui ont été connectés avec succès à un agent.
Critères utilisésDescription

COUNT( * ) 

AcdEventTypesID = 5

AND ( AcdGroupsID IN ( SELECT ID FROM JTELWeb.AcdGroups WHERE ClientsID = _ClientsID ) ) );

Nombre total d'emails envoyés par les agents connectés aux groupes ACD du client actuel.
Critères utilisésDescription

COUNT( * ) 

acdb.dtAgentConnect IS NOT NULL

Nombre total d'appels entrants vers le(s) numéro(s) de service associé(s) au(x) numéro(s) de facturation sélectionné(s) et qui se sont terminés par un rappel ou une messagerie vocale réservée.
Cette colonne est le résultat du calcul suivant:

ACD entrant - entrant répondu - (Messagerie vocale + rappels)

Critères utilisésDescription

COUNT( stats.ID ) 

b.CNumbersID IS NOT NULL 

Nombre total d'appels qui ont été transférés vers une destination externe.
Cette colonne est le résultat du calcul suivant:
Inbound Answered * 100 / Inbound ACD
Cette colonne est le résultat du calcul suivant:
Entrant Répondu * 100 / (ACD entrant + (messagerie vocale + rappels))

Service Number

The following fields are provided per unique service number:

FieldDatabase FieldValue
PlatformServiceNumbers.RootNumberThe platform destination (actually physically called number on the platform).
NumberServiceNumbers.NameThe service number (used for outbound signalling) for this service number.
NameServiceNumbers.Name2The name of the service number.
IDServiceNumbers.IDThe ID of the service number.
Billing NumberServiceNumbers.BillingNumberThe associated billing number for this service number.

e

Calls

The following fields are provided summarizing all calls to the service number:

FieldCalculationNotes
Calls Total #
WHEN ( a.ID IS NOT NULL ) 
THEN 1
ELSE 0
Count 1 for each unique call made to / from the service number.

Outbound

The following fields are provided summarizing all outbound calls from the service number:

FieldCalculationNotes
Outbound Total #
WHEN ( a.bOutbound = 1 )
THEN 1
ELSE 0
Count 1 for each unique outbound call made from the service number.
Outbound Connected #
WHEN ( a.bOutbound = 1 ) 
     AND 
     ( a.dtCallConnect IS NOT NULL ) 
THEN 1ELSE 0
Count 1 for each answered outbound call made from the service number.
Outbound Connected Sum (s) / hh:mm:ss
WHEN ( a.bOutbound = 1 ) 
     AND 
     ( a.dtCallConnect IS NOT NULL ) 
THEN IFNULL( JTELStats2.MICROSECONDS_TO_SECONDS_ROUNDED( TIMESTAMPDIFF( MICROSECOND, a.dtCallConnect, a.dtCallEnd ) ), 0 )
ELSE 0
Sum connected time for each answered outbound call made from the service number.
Outbound Connected Avg (s) / hh:mm:ss
( Outbound Connected Sum (s) / Outbound Connected # )
Average of connected time for each answered outbound call made from the service number.

Inbound

The following fields are provided summarizing all inbound calls to the service number:

FieldCalculationNotes
Inbound Total #
WHEN ( a.bOutbound = 0 ) 
THEN 1
ELSE 0
Count 1 for each unique inbound call made to the service number.

IVR

The following fields are provided summarizing all IVR calls to the service number:

FieldCalculationNotes
IVR Only #
WHEN ( a.bOutbound = 0 ) 
     AND 
     ( acdb.ID IS NULL ) 
THEN 1
ELSE 0
Count 1 for each inbound call to the IVR only (not an ACD call) made to the service number.
IVR Only Sum (s) / hh:mm:ss
WHEN ( a.bOutbound = 0 ) 
     AND 
     ( acdb.ID IS NULL ) 
THEN IFNULL( JTELStats2.MICROSECONDS_TO_SECONDS_ROUNDED( TIMESTAMPDIFF( MICROSECOND, a.dtCallConnect, a.dtCallEnd ) ), 0 )
ELSE 0
Sum connected time for each inbound call to the IVR only (not an ACD call) made to the service number.
IVR Only Avg (s) / hh:mm:ss
( IVR Only Sum (s) / IVR Only # )
Average of connected time for each inbound call to the IVR only (not an ACD call) made to the service number.

ACD

The following fields are provided summarizing all ACD calls to the service number (which either entered the ACD directly, or via the IVR):

Warning

Note: the condition below: AcdOriginGroupsID IS NULL does not count call transfers to groups. This would falsify the report as we are only concerned with unique calls to ServiceNumbers.


FieldCalculationNotes
ACD Total #
WHEN ( a.bOutbound = 0 ) 
     AND 
     ( acdb.ID IS NOT NULL ) 
     AND
     ( acdb.AcdOriginGroupsID IS NULL )
THEN 1
ELSE 0

Count 1 for each inbound call to the ACD made to the service number.


ACD Not Serviced #
WHEN ( a.bOutbound = 0 ) 
     AND 
     ( acdb.ID IS NOT NULL ) 
     AND
     ( acdb.AcdOriginGroupsID IS NULL )
     AND 
     ( acdb.dtAgentConnect IS NULL )
THEN 1
ELSE 0
Count 1 for each call which was not connected to an agent.
ACD Not Serviced Short
WHEN ( a.bOutbound = 0 ) 
     AND 
     ( acdb.ID IS NOT NULL ) 
     AND
     ( acdb.AcdOriginGroupsID IS NULL )
     AND 
     ( acdb.dtAgentConnect IS NULL )
     AND
     ( acdb.AcdGroupEndReasonsID IN ( 1, 2, 3, 4 ) )
     AND
     ( JTELStats2.MICROSECONDS_TO_SECONDS_ROUNDED( TIMESTAMPDIFF( MICROSECOND, acdb.dtGroupStart, acdb.dtGroupEnd ) ) <= _HangUpSeconds )
THEN 1
ELSE 0
Count 1 for each call which was not connected to an agent which hungup before the queue or in the queue on or before the Hangup Seconds parameter was reached in the group (dtGroupEnd - dtGroupStart).
ACD Not Serviced Long
WHEN ( a.bOutbound = 0 ) 
     AND 
     ( acdb.ID IS NOT NULL ) 
     AND
     ( acdb.AcdOriginGroupsID IS NULL )
     AND 
     ( acdb.dtAgentConnect IS NULL )
     AND
     ( acdb.AcdGroupEndReasonsID IN ( 1, 2, 3, 4 ) )
     AND
     ( JTELStats2.MICROSECONDS_TO_SECONDS_ROUNDED( TIMESTAMPDIFF( MICROSECOND, acdb.dtGroupStart, acdb.dtGroupEnd ) ) <= _HangUpSeconds )
THEN 1
ELSE 0
Count 1 for each call which was not connected to an agent which hungup before the queue or in the queue after the Hangup Seconds parameter was reached in the group (dtGroupEnd - dtGroupStart).
ACD Not Serviced Others
WHEN ( a.bOutbound = 0 ) 
     AND 
     ( acdb.ID IS NOT NULL ) 
     AND
     ( acdb.AcdOriginGroupsID IS NULL )
     AND
     ( acdb.dtAgentConnect IS NULL )
     AND
     ( NOT acdb.AcdGroupEndReasonsID IN ( 1, 2, 3, 4 ) )
THEN 1
ELSE 0
Count 1 for each call which was not connected to an agent and which exited the group for another reason - for example returning to the IVR or executing a group action.
ACD Serviced #
WHEN ( a.bOutbound = 0 ) 
     AND 
     ( acdb.ID IS NOT NULL ) 
     AND
     ( acdb.AcdOriginGroupsID IS NULL )
     AND 
     ( acdb.dtAgentConnect IS NOT NULL )
THEN 1
ELSE 0
Count 1 for each call which was connected to an agent.
ACD Serviced INS
WHEN ( a.bOutbound = 0 ) 
     AND 
     ( acdb.ID IS NOT NULL ) 
     AND
     ( acdb.AcdOriginGroupsID IS NULL )
     AND 
     ( acdb.dtAgentConnect IS NOT NULL )
     AND
     ( JTELStats2.MICROSECONDS_TO_SECONDS_ROUNDED( TIMESTAMPDIFF( MICROSECOND, acdb.dtGroupStart, acdb.dtAgentConnect ) ) <= _ServiceLevelSeconds ) 
THEN 1
ELSE 0
Count 1 for each call which was connected to an agent where the time difference dtAgentConnect - dtGroupStart is lower or equal to the Service Level parameter.
ACD Serviced OOS
WHEN ( a.bOutbound = 0 ) 
     AND 
     ( acdb.ID IS NOT NULL ) 
     AND
     ( acdb.AcdOriginGroupsID IS NULL )
     AND 
     ( acdb.dtAgentConnect IS NOT NULL )
     AND
     ( JTELStats2.MICROSECONDS_TO_SECONDS_ROUNDED( TIMESTAMPDIFF( MICROSECOND, acdb.dtGroupStart, acdb.dtAgentConnect ) ) > _ServiceLevelSeconds ) 
THEN 1
ELSE 0
Count 1 for each call which was connected to an agent where the time difference dtAgentConnect - dtGroupStart is higher than the Service Level parameter.
ACD Waiting Time Sum (s) / hh:mm:ss
WHEN ( a.bOutbound = 0 )
     AND 
     ( acdb.ID IS NOT NULL ) 
     AND
     ( acdb.AcdOriginGroupsID IS NULL )
     AND 
     ( acdb.dtAgentConnect IS NOT NULL )
THEN JTELStats2.MICROSECONDS_TO_SECONDS_ROUNDED( TIMESTAMPDIFF( MICROSECOND, acdb.dtGroupStart, acdb.dtAgentConnect ) )
ELSE NULL
Sum of the waiting time (dtAgentConnect - dtGroupStart) for connected agent calls in the group.
ACD Waiting Time Avg. (s) / hh:mm:ss
( ACD Waiting Time Sum (s) / ACD Serviced # )
Average of the waiting time (dtAgentConnect - dtGroupStart) for connected agent calls in the group.
ACD Talk Time Sum (s) / hh:mm:ss
WHEN ( a.bOutbound = 0 )
     AND 
     ( acdb.ID IS NOT NULL ) 
     AND
     ( acdb.AcdOriginGroupsID IS NULL )
     AND 
     ( acdb.dtAgentConnect IS NOT NULL )
     AND
     ( b.dtCallConnect IS NOT NULL )
     AND
     ( b.dtCallEnd IS NOT NULL )
THEN JTELStats2.MICROSECONDS_TO_SECONDS_ROUNDED( TIMESTAMPDIFF( MICROSECOND, b.dtCallConnect, b.dtCallEnd ) )
ELSE 0
Sum of the connected time with all agents (b.dtCallEnd - b.dtCallStart) for connected agent calls in the group.
ACD Talk Time Avg. (s) / hh:mm:ss
( ACD Talk Time Sum (s) / ACD Serviced # )
Average of the connected time with all agents (b.dtCallEnd - b.dtCallStart) for connected agent calls in the group.
ACD Post Call Time Sum (s) / hh:mm:ss
WHEN ( a.bOutbound = 0 )
     AND 
     ( acdb.ID IS NOT NULL ) 
     AND
     ( acdb.AcdOriginGroupsID IS NULL )
     AND 
     ( acdb.dtAgentConnect IS NOT NULL )
     AND
     ( b.dtCallConnect IS NOT NULL )
     AND
     ( b.dtCallEnd IS NOT NULL )
THEN PostCallInterval
ELSE 0
Sum of the post call time for all agents (b.PostCallInterval) for connected agent calls in the group.
ACD Post Call Time Avg. (s) / hh:mm:ss
( ACD Post Call Time Sum (s) / ACD Serviced # )
Average of the post call time for all agents (b.PostCallInterval) for connected agent calls in the group.


plat

Sv translation
languagefr

Table of Contents
maxLevel2
outlinetrue
typeflat

Status
colourRed
titleUNDER CONSTRUCTION

Table of Contents
maxLevel2
outlinevrai
type