Versions Compared

Old Version 7

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.
Sv translation
languageen

Background

CompressedUA contains statistics regarding:

  • Calls to users with respect to particular ACD groups and hotlines
  • Transfer calls made by users
  • Transfer calls received by users
  • Calls made by users for dialler campaigns
  • Calls made by users by click to dial

Information such as:

  • The service number
  • The ACD group
  • The dialler campaign
  • The number of calls
    • Direct 
    • From a transfer
    • Transfered by agent
  • Information on results
    • Answered
    • Busy
    • Caller Hangup
    • Rejected
  • Times
    • Ring time
    • Talk time

is provided.

Note: because these statistics are aggragated, not quite as much information is available as from the call detail records. However, this aggregated data can be retained for a much longer time.

Parameters

Data is aggregated according to the settings of the parameters:

Parameter

Default Value

Purpose

Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.SecondsToWait

7200

The minimum time after the end of a time interval before statistics are aggregated.

Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.NextTimeSlice

-

The date / time of the next time slice to be calculated. This parameter can be reset to an earlier date / time in which case the system will recalculate all intervals from the given date and time again.

Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.CustomCompress
The name of a stored procedure, in JTELStats2, which is called after the system statistics discussed below have been aggregated. This can be used to provide additional values in additional tables as required by a custom installation. NOTE: changing the CompressedUA tables themselves is NOT supported.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.CustomCompress.SuppressErrors0Set to 1, to suppress errors in the CustomCompress routine. If this flag is set, the system will continue with calculations for the data, even if the custom routine throws errors.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.EndTime02:50The end time beyond which the process will not run, and waits for the StartTime to pass before continuing. If empty, the process runs all the time.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.StartTime22:00The start time after which the process will start to run until the specified end time. If empty, the process runs all the time.

Query

Two tables are provided, CompressedUA15 (15 minute time slices) and CompressedUADay (day compression), aggregated according to the following queries.

The first query aggregates calls made TO the agent or BY the agent (direct calls from the ACD and calls transferred to the agent, click to dial calls and dialler calls):

Translations Ignore


Code Block
titleCompressedUA Query 1
SELECT      UsersID,
			(Various Aggregations)
FROM		JTELStats.StatisticsPartB b
LEFT JOIN	JTELStats.StatisticsPartA a
	ON		b.StatisticsPartAID = a.ID
WHERE		( b.ClientsID = _ClientsID )
			AND
			( b.dtCallStart BETWEEN _Timeslice_Begin AND Timeslice_End_ );



The second query aggregates calls made BY the agent (calls transferred by the agent):

Translations Ignore


Code Block
titleCompressedUA Query 2
SELECT      OriginUsersID,
			(Various Aggregations)
FROM		JTELStats.StatisticsPartB b
JOIN		JTELStats.StatisticsPartA a
	ON		b.StatisticsPartAID = a.ID
WHERE		( b.ClientsID = _ClientsID )
			AND
			( b.dtCallStart BETWEEN _Timeslice_Begin AND Timeslice_End_ )
			AND
			( b.OriginUsersID IS NOT NULL );



Partitioning and Aggregations 

When 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.

Partitioning Inbound and Outbound

bOutbound

Partitioning

0

Inbound

1

Outbound


Partitioning on CONNRES

All results are partitioned by CONNRES.

CONNRES

Field

1

OK

2

No Answer

3

Busy 

4 

Caller Hangup

6Reject
0, 5, 6Failure

Inbound: Partitioning on calls to UsersID

StatisticsPartBOrigin

Field

Meaning

NULL

Direct_*

Direct call to agent

NOT NULL

FromTransfer_*

Call transferred to agent

Inbound: Partitioning on calls made by OriginUsersID

bTransferExternalNumber

bTransferAgentField

Meaning

1


TransferOut_Number_*

Call transferred by agent to external number


1TransferOut_Agent_*

Call transferred by agent to another agent

00TransferOut_Group_*Call transferred by agent to group

Outbound: Partitioning on DiallerCampaignsID

DiallerCampaignsID

Field

Meaning

NULL

ClickToDial_*

Agent performed click to dial

NOT NULL

Dialler_*

Agent working in dialler campaign and dialler performed outdial

Tables

CompressedUA15

This table contains compressed statistics for 15 minute intervals.

CompressedUADay

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.

FieldTypeContents
IDINTA 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.
ClientsIDINTID of client from Clients table.
UsersIDINTThe ID of the user from the Users table.
UsersProfilesIDINTThe ID of the user profile from UserProfiles in which the agent was logged in, or 0 if no profile information is available.
ServiceNumbersIDINTID of service number from ServiceNumbers table.
DynamicPriorityGroupsIDINTID of dynamic priority group from DynamicPriorityGroups table, or 0 if no dynamic priority group was assigned.
RoutingApplicationsIDINTID of the routing application from the RoutingApplications Table, or 0 if the application is not available.
AcdGroupsIDINTID of the ACD group, from the AcdGroups table, or 0 if no ACD group is available.
DiallerCampaignsIDINTID of the dialler campaign, from the DiallerCampaigns table, or 0 if no dialler campaign is available.
dtIntervalStartDATETIMEDate and Time of the start of the interval.
UsersUIDVARCHAR(64)The UsersUID field.
UsersNameVARCHAR(64)The Users Name.
UsersFirstNameVARCHAR(64)The Users FirstName.
UsersProfilesNameVARCHAR(64)The UsersProfiles Name.
ServiceNumbersRootNumberVARCHAR(32)The RootNumber field of the service number, as configured when the compressed statistics were created.
ServiceNumbersNameVARCHAR(64)The Name field of the service number, as configured when the compressed statistics were created.
ServiceNumbersName2VARCHAR(64)The Name2 field of the service number, as configured when the compressed statistics were created.
DynamicPriorityGroupsNameVARCHAR(64)The Name field from the DynamicPriorityGroups table, as configured when the compressed statistics were created.
AcdGroupsNameVARCHAR(64)The Name field from the AcdGroups table, as configured when the compressed statistics were created.
Direct_CountINTInbound calls directly to agent, total offered.
Direct_OK_CountINTInbound calls directly to agent, answered.
Direct_OK_Time_CallStart_CallConnect_TotalBIGINTInbound calls directly to agent, answered, total seconds from dtCallStart to dtCallConnect.
Direct_OK_Time_CallStart_CallConnect_MaxINTInbound calls directly to agent, answered, max seconds from dtCallStart to dtCallConnect.
Direct_OK_Time_CallConnect_CallEnd_TotalBIGINTInbound calls directly to agent, answered, total seconds from dtCallConnect to dtCallEnd.
Direct_OK_Time_CallConnect_CallEnd_MaxINTInbound calls directly to agent, answered, max seconds from dtCallConnect to dtCallEnd.
Direct_OK_PostCall_CountINTInbound calls directly to agent, answered, number of calls with post call work.
Direct_OK_PostCall_Time_TotalBIGINTInbound calls directly to agent, answered, total time in post call work.
Direct_OK_PostCall_Time_MaxINTInbound calls directly to agent, answered, max time in post call work.
Direct_NoAnswer_CountINTInbound calls directly to agent, not answered.
Direct_NoAnswer_Time_CallStart_CallEnd_TotalBIGINTInbound calls directly to agent, not answered, total seconds from dtCallStart to dtCallEnd.
Direct_NoAnswer_Time_CallStart_CallEnd_MaxINTInbound calls directly to agent, not answered, max seconds from dtCallStart to dtCallEnd.
Direct_Busy_CountINTInbound calls directly to agent, busy.
Direct_CallerHangup_CountINTInbound calls directly to agent, caller hangup.
Direct_CallerHangup_Time_CallStart_CallEnd_TotalBIGINTInbound calls directly to agent, caller hangup, total seconds from dtCallStart to dtCallEnd.
Direct_CallerHangup_Time_CallStart_CallEnd_MaxINTInbound calls directly to agent, caller hangup, max seconds from dtCallStart to dtCallEnd.
Direct_Reject_CountINTInbound calls directly to agent, rejected.
Direct_Reject_Time_CallStart_CallEnd_TotalBIGINTInbound calls directly to agent, rejected, total seconds from dtCallStart to dtCallEnd.
Direct_Reject_Time_CallStart_CallEnd_MaxINTInbound calls directly to agent, rejected, max seconds from dtCallStart to dtCallEnd.
Direct_Failure_CountINTInbound calls directly to agent, failed.
FromTransfer_CountINTInbound calls transferred to agent, total offered.
FromTransfer_OK_CountINTInbound calls transferred to agent, answered.
FromTransfer_OK_Time_CallStart_CallConnect_TotalBIGINTInbound calls transferred to agent, answered, total seconds from dtCallStart to dtCallConnect.
FromTransfer_OK_Time_CallStart_CallConnect_MaxINTInbound calls transferred to agent, answered, max seconds from dtCallStart to dtCallConnect.
FromTransfer_OK_Time_CallConnect_CallEnd_TotalBIGINTInbound calls transferred to agent, answered, total seconds from dtCallConnect to dtCallEnd.
FromTransfer_OK_Time_CallConnect_CallEnd_MaxINTInbound calls transferred to agent, answered, max seconds from dtCallConnect to dtCallEnd.
FromTransfer_OK_PostCall_CountINTInbound calls transferred to agent, answered, number of calls with post call work.
FromTransfer_OK_PostCall_Time_TotalBIGINTInbound calls transferred to agent, answered, total time in post call work.
FromTransfer_OK_PostCall_Time_MaxINTInbound calls transferred to agent, answered, max time in post call work.
FromTransfer_NoAnswer_CountINTInbound calls transferred to agent, not answered.
FromTransfer_NoAnswer_Time_CallStart_CallEnd_TotalBIGINTInbound calls transferred to agent, not answered, total seconds from dtCallStart to dtCallEnd.
FromTransfer_NoAnswer_Time_CallStart_CallEnd_MaxINTInbound calls transferred to agent, not answered, max seconds from dtCallStart to dtCallEnd.
FromTransfer_Busy_CountINTInbound calls transferred to agent, busy.
FromTransfer_CallerHangup_CountINTInbound calls transferred to agent, caller hangup.
FromTransfer_CallerHangup_Time_CallStart_CallEnd_TotalBIGINTInbound calls transferred to agent, caller hangup, total seconds from dtCallStart to dtCallEnd.
FromTransfer_CallerHangup_Time_CallStart_CallEnd_MaxINTInbound calls transferred to agent, caller hangup, max seconds from dtCallStart to dtCallEnd.
FromTransfer_Reject_CountINTInbound calls transferred to agent, rejected.
FromTransfer_Reject_Time_CallStart_CallEnd_TotalBIGINTInbound calls transferred to agent, rejected, total seconds from dtCallStart to dtCallEnd.
FromTransfer_Reject_Time_CallStart_CallEnd_MaxINTInbound calls transferred to agent, rejected, max seconds from dtCallStart to dtCallEnd.
FromTransfer_Failure_CountINTInbound calls transferred to agent, failed.
TransferOut_Number_CountINTInbound calls transferred out to number by agent, total attempts.
TransferOut_Number_OK_CountINTInbound calls transferred out to number by agent, answered.
TransferOut_Number_OK_Time_CallStart_CallConnect_TotalBIGINTInbound calls transferred out to number by agent, answered, total seconds from dtCallStart to dtCallConnect.
TransferOut_Number_OK_Time_CallStart_CallConnect_MaxINTInbound calls transferred out to number by agent, answered, max seconds from dtCallStart to dtCallConnect.
TransferOut_Number_OK_Time_CallConnect_CallEnd_TotalBIGINTInbound calls transferred out to number by agent, answered, total seconds from dtCallConnect to dtCallEnd.
TransferOut_Number_OK_Time_CallConnect_CallEnd_MaxINTInbound calls transferred out to number by agent, answered, max seconds from dtCallConnect to dtCallEnd.
TransferOut_Number_NoAnswer_CountINTInbound calls transferred out to number by agent, no answer.
TransferOut_Number_NoAnswer_Time_CallStart_CallEnd_TotalBIGINTInbound calls transferred out to number by agent, no answer, total seconds from dCallStart to dtCallEnd.
TransferOut_Number_NoAnswer_Time_CallStart_CallEnd_MaxINTInbound calls transferred out to number by agent, no answer, max seconds from dCallStart to dtCallEnd.
TransferOut_Number_Busy_CountINTInbound calls transferred out to number by agent, busy.
TransferOut_Number_CallerHangup_CountINTInbound calls transferred out to number by agent, caller hangup.
TransferOut_Number_CallerHangup_Time_CallStart_CallEnd_TotalBIGINTInbound calls transferred out to number by agent, caller hangup, total seconds from dCallStart to dtCallEnd.
TransferOut_Number_CallerHangup_Time_CallStart_CallEnd_MaxINTInbound calls transferred out to number by agent, caller hangup, max seconds from dCallStart to dtCallEnd.
TransferOut_Number_Reject_CountINTInbound calls transferred out to number by agent, rejected.
TransferOut_Number_Reject_Time_CallStart_CallEnd_TotalBIGINTInbound calls transferred out to number by agent, rejected, total seconds from dCallStart to dtCallEnd.
TransferOut_Number_Reject_Time_CallStart_CallEnd_MaxINTInbound calls transferred out to number by agent, rejected, max seconds from dCallStart to dtCallEnd.
TransferOut_Number_Failure_CountINTInbound calls transferred out to number by agent, failed.
TransferOut_Group_CountINTInbound calls transferred out to group by agent, total attempts.
TransferOut_Group_OK_CountINTInbound calls transferred out to group by agent, answered.
TransferOut_Group_OK_Time_CallStart_CallConnect_TotalBIGINTInbound calls transferred out to group by agent, answered, total seconds from dtCallStart to dtCallConnect.
TransferOut_Group_OK_Time_CallStart_CallConnect_MaxINTInbound calls transferred out to group by agent, answered, max seconds from dtCallStart to dtCallConnect.
TransferOut_Group_OK_Time_CallConnect_CallEnd_TotalBIGINTInbound calls transferred out to group by agent, answered, total seconds from dtCallConnect to dtCallEnd.
TransferOut_Group_OK_Time_CallConnect_CallEnd_MaxINTInbound calls transferred out to group by agent, answered, max seconds from dtCallConnect to dtCallEnd.
TransferOut_Group_NoAnswer_CountINTInbound calls transferred out to group by agent, no answer.
TransferOut_Group_NoAnswer_Time_CallStart_CallEnd_TotalBIGINTInbound calls transferred out to group by agent, no answer, total seconds from dCallStart to dtCallEnd.
TransferOut_Group_NoAnswer_Time_CallStart_CallEnd_MaxINTInbound calls transferred out to group by agent, no answer, max seconds from dCallStart to dtCallEnd.
TransferOut_Group_Busy_CountINTInbound calls transferred out to group by agent, busy.
TransferOut_Group_CallerHangup_CountINTInbound calls transferred out to group by agent, caller hangup.
TransferOut_Group_CallerHangup_Time_CallStart_CallEnd_TotalBIGINTInbound calls transferred out to group by agent, caller hangup, total seconds from dCallStart to dtCallEnd.
TransferOut_Group_CallerHangup_Time_CallStart_CallEnd_MaxINTInbound calls transferred out to group by agent, caller hangup, max seconds from dCallStart to dtCallEnd.
TransferOut_Group_Reject_CountINTInbound calls transferred out to group by agent, rejected.
TransferOut_Group_Reject_Time_CallStart_CallEnd_TotalBIGINTInbound calls transferred out to group by agent, rejected, total seconds from dCallStart to dtCallEnd.
TransferOut_Group_Reject_Time_CallStart_CallEnd_MaxINTInbound calls transferred out to group by agent, rejected, max seconds from dCallStart to dtCallEnd.
TransferOut_Group_Failure_CountINTInbound calls transferred out to group by agent, failed.
TransferOut_Agent_CountINTInbound calls transferred out to agent by agent, total attempts.
TransferOut_Agent_OK_CountINTInbound calls transferred out to agent by agent, answered.
TransferOut_Agent_OK_Time_CallStart_CallConnect_TotalBIGINTInbound calls transferred out to agent by agent, answered, total seconds from dtCallStart to dtCallConnect.
TransferOut_Agent_OK_Time_CallStart_CallConnect_MaxINTInbound calls transferred out to agent by agent, answered, max seconds from dtCallStart to dtCallConnect.
TransferOut_Agent_OK_Time_CallConnect_CallEnd_TotalBIGINTInbound calls transferred out to agent by agent, answered, total seconds from dtCallConnect to dtCallEnd.
TransferOut_Agent_OK_Time_CallConnect_CallEnd_MaxINTInbound calls transferred out to agent by agent, answered, max seconds from dtCallConnect to dtCallEnd.
TransferOut_Agent_NoAnswer_CountINTInbound calls transferred out to agent by agent, no answer.
TransferOut_Agent_NoAnswer_Time_CallStart_CallEnd_TotalBIGINTInbound calls transferred out to agent by agent, no answer, total seconds from dCallStart to dtCallEnd.
TransferOut_Agent_NoAnswer_Time_CallStart_CallEnd_MaxINTInbound calls transferred out to agent by agent, no answer, max seconds from dCallStart to dtCallEnd.
TransferOut_Agent_Busy_CountINTInbound calls transferred out to agent by agent, busy.
TransferOut_Agent_CallerHangup_CountINTInbound calls transferred out to agent by agent, caller hangup.
TransferOut_Agent_CallerHangup_Time_CallStart_CallEnd_TotalBIGINTInbound calls transferred out to agent by agent, caller hangup, total seconds from dCallStart to dtCallEnd.
TransferOut_Agent_CallerHangup_Time_CallStart_CallEnd_MaxINTInbound calls transferred out to agent by agent, caller hangup, max seconds from dCallStart to dtCallEnd.
TransferOut_Agent_Reject_CountINTInbound calls transferred out to agent by agent, rejected.
TransferOut_Agent_Reject_Time_CallStart_CallEnd_TotalBIGINTInbound calls transferred out to agent by agent, rejected, total seconds from dCallStart to dtCallEnd.
TransferOut_Agent_Reject_Time_CallStart_CallEnd_MaxINTInbound calls transferred out to agent by agent, rejected, max seconds from dCallStart to dtCallEnd.
TransferOut_Agent_Failure_CountINTInbound calls transferred out to agent by agent, failed.
ClickToDial_CountINTOutbound, click to dial, total.
ClickToDial_OK_CountINTOutbound, click to dial, OK.
ClickToDial_OK_Time_CallStart_CallConnect_TotalINTOutbound, click to dial, OK, total seconds from dtCallStart to dtCallConnect (to destination leg).
ClickToDial_OK_Time_CallStart_CallConnect_MaxINTOutbound, click to dial, OK, max seconds from dtCallStart to dtCallConnect (to destination leg).
ClickToDial_OK_Time_CallConnect_CallEnd_TotalINTOutbound, click to dial, OK, total seconds from dtCallConnect to dtCallEnd (to destination leg).
ClickToDial_OK_Time_CallConnect_CallEnd_MaxINTOutbound, click to dial, OK, max seconds from dtCallConnect to dtCallEnd (to destination leg).
ClickToDial_NoAnswer_CountINTOutbound, click to dial, no answer.
ClickToDial_NoAnswer_Time_CallStart_CallEnd_TotalINTOutbound, click to dial, OK, total seconds from dtCallStart to dtCallEnd (to destination leg).
ClickToDial_NoAnswer_Time_CallStart_CallEnd_MaxINTOutbound, click to dial, OK, max seconds from dtCallStart to dtCallEnd (to destination leg).
ClickToDial_Busy_CountINTOutbound, click to dial, busy.
ClickToDial_AgentHangup_CountINTOutbound, click to dial, agent hangup before call connected.
ClickToDial_Reject_CountINTOutbound, click to dial, rejected.
ClickToDial_Failure_CountINTOutbound, click to dial, failed.
Dialler_CountINTOutbound, from dialler campaign, total.
Dialler_OK_CountINTOutbound, from dialler campaign, OK.
Dialler_OK_Time_CallStart_CallConnect_TotalINTOutbound, from dialler campaign, OK, total seconds from dtCallStart to dtCallConnect (to destination leg).
Dialler_OK_Time_CallStart_CallConnect_MaxINTOutbound, from dialler campaign, OK, max seconds from dtCallStart to dtCallConnect (to destination leg).
Dialler_OK_Time_CallConnect_CallEnd_TotalINTOutbound, from dialler campaign, OK, total seconds from dtCallConnect to dtCallEnd (to destination leg).
Dialler_OK_Time_CallConnect_CallEnd_MaxINTOutbound, from dialler campaign, OK, max seconds from dtCallConnect to dtCallEnd (to destination leg).
Dialler_NoAnswer_CountINTOutbound, from dialler campaign, no answer.
Dialler_NoAnswer_Time_CallStart_CallEnd_TotalINTOutbound, from dialler campaign, OK, total seconds from dtCallStart to dtCallEnd (to destination leg).
Dialler_NoAnswer_Time_CallStart_CallEnd_MaxINTOutbound, from dialler campaign, OK, max seconds from dtCallStart to dtCallEnd (to destination leg).
Dialler_Busy_CountINTOutbound, from dialler campaign, busy.
Dialler_AgentHangup_CountINTOutbound, from dialler campaign, agent hangup before call connected.
Dialler_Reject_CountINTOutbound, from dialler campaign, rejected.
Dialler_Failure_CountINTOutbound, from dialler campaign, failed.


Sv translation
languagede
Background

Hintergrund

CompressedUA

contains statistics regarding:
  • Calls to users with respect to particular ACD groups and hotlines
  • Transfer calls made by users
  • Transfer calls received by users
  • Calls made by users for dialler campaigns
  • Calls made by users by click to dial

Information such as:

  • The service number
  • The ACD group
  • The dialler campaign
  • The number of calls
    • Direct 
    • From a transfer
    • Transfered by agent
  • Information on results
    • Answered
    • Busy
    • Caller Hangup
    • Rejected
  • Times
    • Ring time
    • Talk time

is provided.

Note: because these statistics are aggragated, not quite as much information is available as from the call detail records. However, this aggregated data can be retained for a much longer time.

Parameters

Data is aggregated according to the settings of the parameters

entält Statistiken bezüglich:

  • Anrufe an Benutzer in Bezug auf bestimmte ACD-Gruppen und Hotlines
  • Weiterleitung von Anrufen durch Benutzer
  • Weitergeleitete Anrufe empfangen von Benutzern
  • Anrufer getätigt von Benutzern für Dialer Kampagnen
  • Anrufe getätigt von Benutzern durch Click to Dial

Informationen wie z.b.:

  • Die Service Nummer
  • Due ACD Gruppe
  • Die Dialer Kampagne
  • Die Anzahl an Anrufen
    • Direkt 
    • Durch eine Weiterleitung
    • Weitergeleitet durch Agent
  • Informationen zu Resultaten
    • Beantwortet
    • Besetzt
    • Auflegen durch Anrufer
    • Abgelehnt
  • Zeiten
    • Ring time
    • Redezeit

sind zur Verfügung gestellt.

Beachten Sie: Da diese Statistiken aggregiert sind, sind weniger Informationen verfügbar als in den Einzelverbindungsnachweisen. Jedoch können diese aggregierten Daten sehr viel länger aufbewahrt werden.

Parameter

Die Daten werden entsprechend den Einstellungen der Parameter aggregiert:

Parameter

Default Value

Purpose

Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.SecondsToWait

7200

The minimum time after the end of a time interval before statistics are aggregated

Die Mindestzeit nach dem Ende eines Zeitintervalls, bevor die Statistiken aggregiert werden.

Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.NextTimeSlice

-

The date / time of the next time slice to be calculated. This parameter can be reset to an earlier date / time in which case the system will recalculate all intervals from the given date and time again.

Datum und Uhrzeit des nächsten zu berechnenden Zeitintervalls. Dieser Parameter kann auf ein früheres Datum / eine frühere Uhrzeit zurückgesetzt werden. In diesem Fall berechnet das System alle Intervalle ab dem angegebenen Datum und der angegebenen Uhrzeit neu.

Portal.ACD.Statistics.
Portal.ACD.Statistics.
JTELStats2.Compress.CompressedUA.CustomCompress
The name of a stored procedure, in JTELStats2, which is called after the system statistics discussed below have been aggregated. This can be used to provide additional values in additional tables as required by a custom installation. NOTE: changing the CompressedUA tables themselves is NOT supported

Der Name einer gespeicherten Prozedur in JTELStats2, die aufgerufen wird, nachdem die unten beschriebenen Systemstatistiken aggregiert wurden. Dies kann verwendet werden, um zusätzliche Werte in zusätzlichen Tabellen bereitzustellen, wie es für eine benutzerdefinierte Installation festgelegt wurde. HINWEIS: Die Änderung der CompressedUA-Tabellen selbst wird NICHT unterstützt.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.CustomCompress.SuppressErrors0
Set to
Auf 1 gesetzt,
to suppress errors in the CustomCompress routine. If this flag is set, the system will continue with calculations for the data, even if the custom routine throws errors
um Fehler in der CustomCompress-Routine zu unterdrücken. Wenn dieses Flag gesetzt ist, fährt das System mit den Berechnungen für die Daten fort, auch wenn die benutzerdefinierte Routine Fehler auslöst.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.EndTime02:50
The end time beyond which the process will not run, and waits for the StartTime to pass before continuing. If empty, the process runs all the time.
Die EndTime, nach der der Prozess nicht mehr weiterläuft und wartet, bis die StartTime verstrichen ist, bevor er fortgesetzt wird. Wenn leer, läuft der Prozess die ganze Ze
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.StartTime22:00
The start time after which the process will start to run until the specified end time. If empty, the process runs all the time.

Query

Two tables are provided, CompressedUA15 (15 minute time slices) and CompressedUADay (day compression), aggregated according to the following queries.

The first query aggregates calls made TO the agent or BY the agent (direct calls from the ACD and calls transferred to the agent, click to dial calls and dialler calls):

Die Startzeit, nach der der Prozess beginnt, bis zur angegebenen Endzeit zu laufen. Wenn leer, läuft der Prozess die ganze Zeit.

Abfrage

Es werden zwei Tabellen bereitgestellt, CompressedA15 (15-Minuten-Zeitabschnitte) und CompressedADay (Tageskomprimierung), die gemäß der folgenden Abfrage aggregiert werden:

Die erste Abfrage aggregiert Anrufe, die AN den Agenten oder DURCH den Agenten getätigt werden (direkte Anrufe von der ACD und an den Agenten weitergeleitete Anrufe, Click-to-Dial-Anrufe und Dialer-Anrufe):

Translations Ignore


Code Block
titleCompressedUA Query 1
SELECT      UsersID,
			(Various Aggregations)
FROM		JTELStats.StatisticsPartB b
LEFT JOIN	JTELStats.StatisticsPartA a
	ON		b.StatisticsPartAID = a.ID
WHERE		( b.ClientsID = _ClientsID )
			AND
			( b.dtCallStart BETWEEN _Timeslice_Begin AND Timeslice_End_ );
The second query aggregates calls made BY the agent (calls transferred by the agent):



Die zweite Abfrage aggregiert die vom Agenten getätigten Anrufe (vom Agenten weitergeleitete Anrufe):

Translations Ignore


Code Block
titleCompressedUA Query 2
SELECT      OriginUsersID,
			(Various Aggregations)
FROM		JTELStats.StatisticsPartB b
JOIN		JTELStats.StatisticsPartA a
	ON		b.StatisticsPartAID = a.ID
WHERE		( b.ClientsID = _ClientsID )
			AND
			( b.dtCallStart BETWEEN _Timeslice_Begin AND Timeslice_End_ )
			AND
			( b.OriginUsersID IS NOT NULL );

Partitioning and Aggregations 

When 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.

Partitioning Inbound and Outbound

bOutbound

Partitioning

0

Inbound

1

Outbound

Partitioning on CONNRES



Partitionierung und Aggregationen 

Wenn die Daten aggregiert werden, werden sie in mehrere konsistente Partitionen unterteilt, die folgender Logik folgen. Die daraus resultierenden Aggregationen zählen dann entweder einen Anruf, wenn eine Bedingung erfüllt ist, oder ermitteln die Zeit zwischen zwei Zeitstempeln.

Partitionierung Eingehend und Ausgehend

bOutbound

Partitionierung

0

Eingehend

1

Ausgehend


Partitionierung auf CONNRES

Alle Ergebnisse werden partitioniert nach CONNRES.

CONNRES

Feld

All results are partitioned by CONNRES.

CONNRESField

1

OK

2
No Answer

Keine Antwort

3
Busy 

Besetzt 

4 
Caller Hangup

Auflegen durch Anrufer

6
Reject
Abgelehnt
0, 5, 6
Failure
Fehlgeschlagen
Inbound: Partitioning on calls to 

Eingehend: Partitionierung von Anrufen an UsersID

StatisticsPartBOrigin

Field
Feld
Meaning

Bedeutung

NULL

Direct_*
Direct call to agent

Direkter Anruf an Agent

NOT NULL

FromTransfer_*

Call transferred to agent

Inbound: Partitioning on calls made by 

Anruf weitergeleitet an Agent

Eingehend: Partitionierung von Anrufen getätigt von OriginUsersID

bTransferExternalNumber

bTransferAgent
Field
Feld
Meaning

Bedeutung

1


TransferOut_Number_*
Call transferred by agent to external number

Anruf weitergeleitet durch Agent zu externer Nummer


1TransferOut_Agent_*
Call transferred by agent to another agent

Anruf weitergeleitet durch Agent zu weiterem Agent

00TransferOut_Group_*
Call transferred by agent to group
Anruf weitergeleitet druch Agent zu Gruppe

Outbound: Partitioning on DiallerCampaignsID

DiallerCampaignsID

Field
Feld
Meaning

Bedeutung

NULL

ClickToDial_*

Agent

performed click to dial

hat Click-To-Dial durchgeführt

NOT NULL

Dialler_*

Agent

working in dialler campaign and dialler performed outdial

arbeitet in Dialer-Kampagne und Dialer führte Outdial durch

Tabellen

CompressedUA15

Diese Tabelle enthält komprimierte Statistiken für 15-Minuten-Intervalle.

CompressedUADay

Diese Tabelle enthält komprimierte Statistiken für Tagesintervalle.

Felder

Die Felddefinitionen sind in beiden Tabellen im Wesentlichen identisch, nur die Aggregationsintervalle sind unterschiedlich.

FeldTypInhalte
IDINTEine einzigartige ID, die jedem Datensatz zugewiesen wird. Beachten Sie, dass die IDs nicht wiederverwendet werden, denn wenn ein Intervall neu berechnet wird, wird der Datensatz mit REPLACE hinzugefügt, d.h. der bestehende Datensatz wird gelöscht und ein neuer Datensatz mit einer neuen ID wird an seiner Stelle erstellt.
ClientsIDINTID des Mandanten aus der Clients Tabelle
UsersIDINTDie ID des Benutzers aus der User Tabelle
UsersProfilesIDINTDie ID des Userprofils aus UserProfiles, in dem der Agent angemeldet war, oder 0, wenn keine Profilinformationen verfügbar sind.
ServiceNumbersIDINTID der Servicenummer aus der ServiceNumbers Tabelle.
DynamicPriorityGroupsIDINTID der Dynamic Priority Group aus der DynamicPriorityGroups Tabelle, oder 0, wenn keine Dynamic Priority Group zugewiesen wurde.
RoutingApplicationsIDINTID der Routingapplikation aus der RoutingApplications Tabelle, oder 0, wenn die Anwendung nicht verfügbar ist.
AcdGroupsIDINTID der ACD-Gruppe aus der Tabelle AcdGroups, oder 0, wenn keine ACD-Gruppe verfügbar ist.
DiallerCampaignsIDINTID der Dialer Kampagne aus der Tabelle DiallerCampaigns, oder 0, wenn keine Dialer Kampagne verfügbar ist.
dtIntervalStartDATETIMEDatum und Uhrzeit des Beginns des Intervalls.
UsersUIDVARCHAR(64)Das BenutzerUID Feld.
UsersNameVARCHAR(64)Der Name des Benutzers
UsersFirstNameVARCHAR(64)Der Vorname des Benutzers
UsersProfilesNameVARCHAR(64)Der Benutzerprofilname.
ServiceNumbersRootNumberVARCHAR(32)Das RootNumber Feld der Servicenummer, wie bei der Erstellung der compressed statistics konfiguriert.
ServiceNumbersNameVARCHAR(64)Das Name-Feld der Servicenummer, wie bei der Erstellung der compressed statistics konfiguriert.
ServiceNumbersName2VARCHAR(64)Das Name2-Feld der Servicenummer, wie bei der Erstellung der compressed statistics konfiguriert.
DynamicPriorityGroupsNameVARCHAR(64)Das Name-Feld aus der Tabelle DynamicPriorityGroups, wie bei der Erstellung der compressed statistics konfiguriert.
AcdGroupsNameVARCHAR(64)Das Name-Feld aus der AcdGroups Tabelle, wie bei der Erstellung der compressed statistics konfiguriert.
Direct_CountINTEingehende Anrufe direkt an Agent, Gesamtzahl der angebotenen Anrufe.
Direct_OK_CountINTEingehende Anrufe direkt an Agent, beantwortet
Direct_OK_Time_CallStart_CallConnect_TotalBIGINTEingehende Anrufe direkt an Agent, beantwortet, Sekunden gesamt ab dtCallStart bis dtCallConnect.
Direct_OK_Time_CallStart_CallConnect_MaxINTEingehende Anrufe direkt an Agent, beantwortet, Sekunden Höchstwert ab dtCallStart bis dtCallConnect.
Direct_OK_Time_CallConnect_CallEnd_TotalBIGINTEingehende Anrufe direkt an Agent, beantwortet, Sekunden gesamt ab dtCallConnect bis dtCallEnd.
Direct_OK_Time_CallConnect_CallEnd_MaxINTEingehende Anrufe direkt an Agent, beantwortet, Sekunden Höchstwert ab dtCallConnect bis dtCallEnd.
Direct_OK_PostCall_CountINTEingehende Anrufe direkt an Agent, beantwortet, Anzahl der Anrufe mit Nachbearbeitung.
Direct_OK_PostCall_Time_TotalBIGINTEingehende Anrufe direkt an Agent, beantwortet, Zeit gesamt in Nachbearbeitung.
Direct_OK_PostCall_Time_MaxINTEingehende Anrufe direkt an Agent, beantwortet, Zeit maximal in Nachbearbeitung.
Direct_NoAnswer_CountINTEingehende Anrufe direkt an Agent, keine Antwort.
Direct_NoAnswer_Time_CallStart_CallEnd_TotalBIGINTEingehende Anrufe direkt an Agent, keine Antwort, Sekunden gesamt ab dtCallStart bis dtCallConnect.
Direct_NoAnswer_Time_CallStart_CallEnd_MaxINTEingehende Anrufe direkt an Agent, keine Antwort, Sekunden Höchstwert ab dtCallStart bis dtCallConnect.
Direct_Busy_CountINTEingehende Anrufe direkt an Agent, besetzt.
Direct_CallerHangup_CountINTEingehende Anrufe direkt an Agent, Auflegen durch Anrufer
Direct_CallerHangup_Time_CallStart_CallEnd_TotalBIGINTEingehende Anrufe direkt an Agent, Auflegen durch Anrufer, Sekunden gesamt ab dtCallStart bis dtCallEnd.
Direct_CallerHangup_Time_CallStart_CallEnd_MaxINTEingehende Anrufe direkt an Agent, Auflegen durch Anrufer, Sekunden Höchstwert ab dtCallStart bis dtCallEnd.
Direct_Reject_CountINTEingehende Anrufe direkt an Agent, abgelehnt.
Direct_Reject_Time_CallStart_CallEnd_TotalBIGINTEingehende Anrufe direkt an Agent, abgelehnt, Sekunden gesamt ab dtCallStart bis dtCallEnd.
Direct_Reject_Time_CallStart_CallEnd_MaxINTEingehende Anrufe direkt an Agent, abgelehnt, Sekunden Höchstwert ab dtCallStart bis dtCallEnd
Direct_Failure_CountINTEingehende Anrufe direkt an Agent, fehlgeschlagen.
FromTransfer_CountINTEingehende Anrufe, an Agent weitergeleitet, angeboten gesamt.
FromTransfer_OK_CountINTEingehende Anrufe, an Agent weitergeleitet, beantwortet.
FromTransfer_OK_Time_CallStart_CallConnect_TotalBIGINTEingehende Anrufe, an Agent weitergeleitet, beantwortet, Sekunden gesamt ab dtCallStart bis dtCallConnect.
FromTransfer_OK_Time_CallStart_CallConnect_MaxINTEingehende Anrufe, an Agent weitergeleitet, beantwortet, Sekunden Höchstwert ab dtCallStart bis dtCallConnect.
FromTransfer_OK_Time_CallConnect_CallEnd_TotalBIGINTEingehende Anrufe, an Agent weitergeleitet, beantwortet, Sekunden gesamt ab dtCallConnect bis dtCallEnd.
FromTransfer_OK_Time_CallConnect_CallEnd_MaxINTEingehende Anrufe, an Agent weitergeleitet, beantwortet, Sekunden Höchstwert ab dtCallConnect bis dtCallEnd.
FromTransfer_OK_PostCall_CountINTEingehende Anrufe, an Agent weitergeleitet, beantwortet, Anzahl der Anrufe mit Nachbearbeitung.
FromTransfer_OK_PostCall_Time_TotalBIGINTEingehende Anrufe, an Agent weitergeleitet, beantwortet, Zeit Gesamt in Nachbearbeitung.
FromTransfer_OK_PostCall_Time_MaxINTEingehende Anrufe, an Agent weitergeleitet, beantwortet, Zeit Höchstwert in Nachbearbeitung.
FromTransfer_NoAnswer_CountINTEingehende Anrufe, an Agent weitergeleitet, keine Antwort.
FromTransfer_NoAnswer_Time_CallStart_CallEnd_TotalBIGINTEingehende Anrufe, an Agent weitergeleitet, keine Antwort, Sekunden gesam ab dtCallStart bis dtCallEnd.
FromTransfer_NoAnswer_Time_CallStart_CallEnd_MaxINTEingehende Anrufe, an Agent weitergeleitet, keine Antwort, Sekunden Höchstwert ab dtCallStart bis dtCallEnd.
FromTransfer_Busy_CountINTEingehemde Anrufe, an Agent weitergeleitet, besetzt.
FromTransfer_CallerHangup_CountINTEingehemde Anrufe, an Agent weitergeleitet, Auflegen durch Anrufer
FromTransfer_CallerHangup_Time_CallStart_CallEnd_TotalBIGINTEingehemde Anrufe, an Agent weitergeleitet, Auflegen durch Anrufer, Sekunden gesamt ab dtCallStart bis dtCallEnd.
FromTransfer_CallerHangup_Time_CallStart_CallEnd_MaxINTEingehemde Anrufe, an Agent weitergeleitet, Auflegen durch Anrufer, Sekunden Höchstwert ab dtCallStart bis dtCallEnd.
FromTransfer_Reject_CountINTEingehende Anrufe, an Agent weitergeleitet, abgelehnt.
FromTransfer_Reject_Time_CallStart_CallEnd_TotalBIGINTEingehende Anrufe, an Agent weitergeleitet, abgelehnt, Sekunden gesamt ab dtCallStart bis dtCallEnd.
FromTransfer_Reject_Time_CallStart_CallEnd_MaxINTEingehende Anrufe, an Agent weitergeleitet, abgelehnt, Sekunden gesamt ab dtCallStart bis dtCallEnd.
FromTransfer_Failure_CountINTEingehende Anrufe, an Agent weitergeleitet, fehlgeschlagen.
TransferOut_Number_CountINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, Anzahl Versuche gesamt.
TransferOut_Number_OK_CountINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, beanwortet.
TransferOut_Number_OK_Time_CallStart_CallConnect_TotalBIGINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, beantwortet, Sekunden gesamt ab dtCallStart bis dtCallConnect.
TransferOut_Number_OK_Time_CallStart_CallConnect_MaxINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, beantwortet, Sekunden Höchstwert ab dtCallStart bis dtCallConnect.
TransferOut_Number_OK_Time_CallConnect_CallEnd_TotalBIGINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, beantwortet, Sekunden gesamt ab dtCallConnect bis dtCallEnd.
TransferOut_Number_OK_Time_CallConnect_CallEnd_MaxINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, beantwortet, Sekunden Höchstwert ab dtCallConnect bis dtCallEnd.
TransferOut_Number_NoAnswer_CountINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, keine Antwort.
TransferOut_Number_NoAnswer_Time_CallStart_CallEnd_TotalBIGINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, keine Antwort, Sekunden gesamt ab dCallStart bis dtCallEnd.
TransferOut_Number_NoAnswer_Time_CallStart_CallEnd_MaxINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, keine Antwort, Sekunden Höchstwert ab dCallStart bis dtCallEnd.
TransferOut_Number_Busy_CountINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, besetzt.
TransferOut_Number_CallerHangup_CountINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, Auflegen durch Anrufer.
TransferOut_Number_CallerHangup_Time_CallStart_CallEnd_TotalBIGINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, Auflegen durch Anrufer, Sekunden gesamt ab dCallStart bis dtCallEnd.
TransferOut_Number_CallerHangup_Time_CallStart_CallEnd_MaxINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, Auflegen durch Anrufer, Sekunden Höchstwert abdCallStart bis dtCallEnd.
TransferOut_Number_Reject_CountINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, abgelehnt.
TransferOut_Number_Reject_Time_CallStart_CallEnd_TotalBIGINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, abgelehnt, Sekunden gesamt ab dCallStart bis dtCallEnd.
TransferOut_Number_Reject_Time_CallStart_CallEnd_MaxINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, abgelehnt, Sekunden Höchstwert ab dCallStart bis dtCallEnd.
TransferOut_Number_Failure_CountINTEingehende Anrufe, weitergeleitet durch Agent zu anderer Nummer, abgelehnt.
TransferOut_Group_CountINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, Versuche gesamt.
TransferOut_Group_OK_CountINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, beantwortet.
TransferOut_Group_OK_Time_CallStart_CallConnect_TotalBIGINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, beantwortet, Sekunden gesamt ab dtCallStart bis dtCallConnect.
TransferOut_Group_OK_Time_CallStart_CallConnect_MaxINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, beantwortet, Sekunden Höchstwert ab dtCallStart bis dtCallConnect.
TransferOut_Group_OK_Time_CallConnect_CallEnd_TotalBIGINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, beantwortet, Sekunden gesamt ab dtCallConnect bis dtCallEnd.
TransferOut_Group_OK_Time_CallConnect_CallEnd_MaxINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, beantwortet, Sekunden Höchstwert ab dtCallConnect bis dtCallEnd.
TransferOut_Group_NoAnswer_CountINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, keine Antwort.
TransferOut_Group_NoAnswer_Time_CallStart_CallEnd_TotalBIGINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, keine Antwort, Sekunden gesamt ab dCallStart bis dtCallEnd.
TransferOut_Group_NoAnswer_Time_CallStart_CallEnd_MaxINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, keine Antwort, Sekunden Höchstwert ab dCallStart bis dtCallEnd.
TransferOut_Group_Busy_CountINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, besetzt.
TransferOut_Group_CallerHangup_CountINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, Auflegen durch Anrufer.
TransferOut_Group_CallerHangup_Time_CallStart_CallEnd_TotalBIGINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, Auflegen durch Anrufer, Sekunden gesamt ab dCallStart bis dtCallEnd.
TransferOut_Group_CallerHangup_Time_CallStart_CallEnd_MaxINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, Auflegen durch Anrufer, Sekunden Höchstwert ab dCallStart bis dtCallEnd.
TransferOut_Group_Reject_CountINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, abgelehnt.
TransferOut_Group_Reject_Time_CallStart_CallEnd_TotalBIGINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, abgelehnt, Sekunden gesamt ab dCallStart bis dtCallEnd.
TransferOut_Group_Reject_Time_CallStart_CallEnd_MaxINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, abgelehnt, Sekunden Höchstwert ab dCallStart bis dtCallEnd.
TransferOut_Group_Failure_CountINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, fehlgeschlagen.
TransferOut_Agent_CountINTEingehende Anrufe, weitergeleitet durch Agent zu Gruppe, Versuche gesamt.
TransferOut_Agent_OK_CountINTEingehende Anrufe weitergeleitet durch Agent zu Agent, beantwortet.
TransferOut_Agent_OK_Time_CallStart_CallConnect_TotalBIGINTEingehende Anrufe weitergeleitet durch Agent zu Agent, beantwortet, Sekunden gesamt ab dtCallStart bis dtCallConnect.
TransferOut_Agent_OK_Time_CallStart_CallConnect_MaxINTEingehende Anrufe weitergeleitet durch Agent zu Agent, beantwortet, Sekunden Höchstwert ab dtCallStart bis dtCallConnect.
TransferOut_Agent_OK_Time_CallConnect_CallEnd_TotalBIGINTEingehende Anrufe weitergeleitet durch Agent zu Agent, beantwortet, Sekunden gesamt ab dtCallConnect bis dtCallEnd.
TransferOut_Agent_OK_Time_CallConnect_CallEnd_MaxINTEingehende Anrufe weitergeleitet durch Agent zu Agent, beantwortet, Sekunden Höchstwert ab dtCallConnect bis dtCallEnd.
TransferOut_Agent_NoAnswer_CountINTEingehende Anrufe weitergeleitet durch Agent zu Agent, keine Antwort.
TransferOut_Agent_NoAnswer_Time_CallStart_CallEnd_TotalBIGINTEingehende Anrufe weitergeleitet durch Agent zu Agent, keine Antwort, Sekunden gesamt ab dCallStart bis dtCallEnd.
TransferOut_Agent_NoAnswer_Time_CallStart_CallEnd_MaxINTEingehende Anrufe weitergeleitet durch Agent zu Agent, keine Antwort, Sekunden Höchstwert ab dCallStart bis dtCallEnd.
TransferOut_Agent_Busy_CountINTEingehende Anrufe weitergeleitet durch Agent zu Agent, besetzt.
TransferOut_Agent_CallerHangup_CountINTEingehende Anrufe weitergeleitet durch Agent zu Agent, Auflegen durch Anrufer.
TransferOut_Agent_CallerHangup_Time_CallStart_CallEnd_TotalBIGINTEingehende Anrufe weitergeleitet durch Agent zu Agent, Auflegen durch Anrufer, Sekunden gesamt ab dCallStart bis dtCallEnd.
TransferOut_Agent_CallerHangup_Time_CallStart_CallEnd_MaxINTEingehende Anrufe weitergeleitet durch Agent zu Agent, Auflegen durch Anrufer, Sekunden Höchstwert ab dCallStart bis dtCallEnd.
TransferOut_Agent_Reject_CountINTEingehende Anrufe weitergeleitet durch Agent zu Agent, abgelehnt.
TransferOut_Agent_Reject_Time_CallStart_CallEnd_TotalBIGINTEingehende Anrufe weitergeleitet durch Agent zu Agent, abgelehnt, Sekunden gesamt ab dCallStart bis dtCallEnd.
TransferOut_Agent_Reject_Time_CallStart_CallEnd_MaxINTEingehende Anrufe weitergeleitet durch Agent zu Agent, abgelehnt, Sekunden Höchstwert ab dCallStart bis dtCallEnd.
TransferOut_Agent_Failure_CountINTEingehende Anrufe weitergeleitet durch Agent zu Agent, fehlgeschlagen.
ClickToDial_CountINTAusgehend, click to dial, gesamt.
ClickToDial_OK_CountINTAusgehend, click to dial, OK.
ClickToDial_OK_Time_CallStart_CallConnect_TotalINTAusgehend, click to dial, OK, Sekunden gesamt ab dtCallStart bis dtCallConnect (zu destination leg).
ClickToDial_OK_Time_CallStart_CallConnect_MaxINTAusgehend, click to dial, OK, Sekunden Höchstwert ab dtCallStart bis dtCallConnect (zu destination leg).
ClickToDial_OK_Time_CallConnect_CallEnd_TotalINTAusgehend, click to dial, OK, Sekunden gesamt ab dtCallConnect bis dtCallEnd (zu destination leg).
ClickToDial_OK_Time_CallConnect_CallEnd_MaxINTAusgehend, click to dial, OK, Sekunden Höchstwert ab dtCallConnect bis dtCallEnd (zu destination leg).
ClickToDial_NoAnswer_CountINTAusgehend, click to dial, keine Antwort.
ClickToDial_NoAnswer_Time_CallStart_CallEnd_TotalINTAusgehend, click to dial, OK, Sekunden gesamt ab dtCallStart bis dtCallEnd (zu destination leg).
ClickToDial_NoAnswer_Time_CallStart_CallEnd_MaxINTAusgehend, click to dial, OK, Sekunden Höchstwert ab dtCallStart bis dtCallEnd (zu destination leg).
ClickToDial_Busy_CountINTAusgehend, click to dial, besetzt.
ClickToDial_AgentHangup_CountINTAusgehend, click to dial, Auflegen durch Agenten vor Herstellung der Anrufverbindung.
ClickToDial_Reject_CountINTAusgehend, click to dial, abgelehnt.
ClickToDial_Failure_CountINTAusgehend, click to dial, fehlgeschlagen.
Dialler_CountINTAusgehend, von Dialer Kampagne, gesamt.
Dialler_OK_CountINTAusgehend, von dialler campaign, OK.
Dialler_OK_Time_CallStart_CallConnect_TotalINTAusgehend, von Dialer Kampagne, OK, Sekunden gesamt ab dtCallStart bis dtCallConnect (zu destination leg).
Dialler_OK_Time_CallStart_CallConnect_MaxINTAusgehend, von Dialer Kampagne, OK, Sekunden Höchstwert ab dtCallStart bis dtCallConnect (zu destination leg).
Dialler_OK_Time_CallConnect_CallEnd_TotalINTAusgehend, von Dialer Kampagne, OK, Sekunden gesamt ab dtCallConnect bis dtCallEnd (zu destination leg).
Dialler_OK_Time_CallConnect_CallEnd_MaxINTAusgehend, von Dialer Kampagne, OK, Sekunden Höchstwert ab dtCallConnect bis dtCallEnd (zu destination leg).
Dialler_NoAnswer_CountINTAusgehend, von Dialer Kampagne, keine Antwort.
Dialler_NoAnswer_Time_CallStart_CallEnd_TotalINTAusgehend, von Dialer Kampagne, OK, Sekunden gesamt ab dtCallStart bis dtCallEnd (zu destination leg).
Dialler_NoAnswer_Time_CallStart_CallEnd_MaxINTAusgehend, von Dialer Kampagne, OK, Sekunden Höchstwert ab dtCallStart bis dtCallEnd (zu destination leg).
Dialler_Busy_CountINTAusgehend, von Dialer Kampagne, besetzt.
Dialler_AgentHangup_CountINTAusgehend, von Dialer Kampagne, Auflegen durch Agenten vor Herstellung der Anrufverbindung.
Dialler_Reject_CountINTAusgehend, von Dialer Kampagne, abgelehnt.
Dialler_Failure_CountINTAusgehend, von Dialer Kampagne, fehlgeschlagen.


Inbound calls directly to agent, answered
Sv translation
languagefr

Background

CompressedUA contient des statistiques concernant :

  • Appels aux utilisateurs concernant des groupes et des lignes directes particulières de l'ACD
  • Transférer les appels effectués par les utilisateurs
  • Transférer les appels reçus par les utilisateurs
  • Appels lancés par les utilisateurs pour les campagnes de numérotation
  • Appels effectués par les utilisateurs en cliquant pour composer

Des informations telles que :

  • Le numéro de service
  • Le Groupe ACD
  • Le Composeur Campagne
  • Le nombre d'appels
    • Directe 
    • A partir d'un transfert
    • Transfert par agent
  • Information sur les résultats
    • Répondu
    • Occupé
    • Raccrochage Appelant
    • Rejeté
  • Fois
    • Temps de sonnerie
    • Temps de conversation

est fournie.

Remarque : ces statistiques étant aggravées, les informations disponibles ne sont pas aussi nombreuses que celles provenant des enregistrements des détails des appels. Toutefois, ces données agrégées peuvent être conservées beaucoup plus longtemps.

Paramètres

Les données sont agrégées en fonction du réglage des paramètres :

Paramètre

Valeur par défaut

Objet

Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.SecondsToWait

7200

Le temps minimum après la fin d'un intervalle de temps avant l'agrégation des statistiques.

Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.NextTimeSlice

-

La date / l'heure de la prochaine tranche horaire à calculer. Ce paramètre peut être réinitialisé à une date/heure antérieure, auquel cas le système recalculera à nouveau tous les intervalles à partir de la date et de l'heure données.

Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.CustomCompress
Le nom d'une procédure stockée, dans JTELStats2, qui est appelé après que les statistiques du système discutées ci-dessous ont été agrégées. Cela peut être utilisé pour fournir des valeurs supplémentaires dans des tableaux supplémentaires comme requis par une installation personnalisée. REMARQUE: changer les tableaux CompressedU eux-mêmes est NON soutenu.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.CustomCompress.SuppressErrors0Réglé sur 1, pour supprimer les erreurs dans la routine CustomCompress. Si ce drapeau est activé, le système poursuivra les calculs pour les données, même si la routine personnalisée lance des erreurs.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.EndTime02:50L'heure de fin au-delà de laquelle le processus ne s'exécute pas, et attend que l'heure de début soit passée avant de continuer. S'il est vide, le processus s'exécute tout le temps.
Portal.ACD.Statistics.JTELStats2.Compress.CompressedUA.StartTime22:00L'heure de début après laquelle le processus commencera à s'exécuter jusqu'à l'heure de fin spécifiée. S'il est vide, le processus s'exécute tout le temps.

Requête

Deux tableaux sont fournis, CompressedUA15 (tranches de temps de 15 minutes) et CompressedUADay (compression de jour), agrégés selon les requêtes suivantes.

La première interrogation regroupe les appels faits À l'agent ou PAR l'agent (appels directs de l'ACD et appels transférés à l'agent, cliquer pour composer les appels et composer les appels) :

Translations Ignore


Code Block
titleRequête CompressedUA 1
SELECT UsersID, (Various Aggregations) FROM JTELStats.StatisticsPartB b LEFT JOIN JTELStats.StatisticsPartA a ON b.StatisticsPartAID = a.ID WHERE ( b.ClientsID = _ClientsID ) AND ( b.dtCallStart BETWEEN _Timeslice_Begin AND Timeslice_End_ );



La deuxième requête regroupe les appels effectués par l'agent (appels transférés par l'agent) :

Translations Ignore


Code Block
titleRequête CompressedUA 2
SELECT OriginUsersID, (Various Aggregations) FROM JTELStats.StatisticsPartB b JOIN JTELStats.StatisticsPartA a ON b.StatisticsPartAID = a.ID WHERE ( b.ClientsID = _ClientsID ) AND ( b.dtCallStart BETWEEN _Timeslice_Begin AND Timeslice_End_ ) AND ( b.OriginUsersID IS NOT NULL );



Répartition et agrégations 

Lorsque les données sont agrégées, elles sont divisées en plusieurs partitions cohérentes, selon la logique suivante. Les agrégats qui en résultent comptent alors soit un appel, si une condition est remplie, soit déterminent le temps entre deux horodatages.

Répartition des entrées et des sorties

bOutbound

Répartition

0

Entrant

1

Sortie


Partitionnement sur CONNRES

Tous les résultats sont partitionnés par CONNRES.

CONNRES

Champ

1

OK

2

Pas de réponse

3

Occupé 

4 

Raccrochage de l'appelant

6Rejeter
0, 5, 6Échec

Entrant: Partitionnement sur Appels to ID utilisateurs

StatisticsPartBOrigin

Champ

Signification

NULL

Direct_*

Appel direct à l'agent

NOT NULL

FromTransfer_*

Appel transféré à l'agent

Entrant: Partitionnement sur les appels effectués par OriginUsersID

bTransferExternalNumber

bTransferAgentChamp

Signification

1


TransferOut_Number_*

Appel transféré par l'agent vers un numéro externe


1TransferOut_Agent_*

Appel transféré par agent à un autre agent

00TransferOut_Group_*Appel transféré par agent au groupe

Sortant : Répartition sur DiallerCampaignsID

DiallerCampaignsID

Champ

Signification

NULL

ClickToDial_*

L'agent a effectué un clic pour composer

NOT NULL

Dialler_*

Agent travaillant dans la campagne de numérotation et numérotation effectuée en dehors

Tableaux

CompressedUA15

Ce tableau contient des statistiques compressées pour des intervalles de 15 minutes.

CompressedUADay

Ce tableau contient des statistiques compressées pour les intervalles de jours.

Champs

Les définitions des champs sont essentiellement les mêmes, dans les deux tableaux, seuls les intervalles d'agrégation sont différents.

ChampTypeContenu
IDINTUn identifiant unique est attribué à chaque enregistrement. Notez que les ID ne sont pas réutilisés, car si un intervalle est recalculé, l'enregistrement est ajouté avec REMPLACER, c'est-à-dire que l'enregistrement existant sera supprimé et un nouvel enregistrement avec un nouvel ID sera créé à sa place.
ClientsIDINTID du client à partir du tableau des clients.
UsersIDINTL'ID de l'utilisateur à partir du tableau des utilisateurs.
UsersProfilesIDINTL'ID du profil d'utilisateur de UserProfiles dans lequel l'agent était connecté, ou 0 si aucune information de profil n'est disponible.
ServiceNumbersIDINTID du numéro de service à partir du tableau ServiceNumbers.
DynamicPriorityGroupsIDINTID du groupe de priorité dynamique de la table DynamicPriorityGroups, ou 0 si aucun groupe de priorité dynamique n'a été attribué.
RoutingApplicationsIDINTID de l'application de routage à partir du tableau des applications de routage, ou 0 si l'application n'est pas disponible.
AcdGroupsIDINTID du groupe ACD, à partir du tableau AcdGroups, ou 0 si aucun groupe ACD n'est disponible.
DiallerCampaignsIDINTID de la campagne de numérotation, à partir du tableau DiallerCampaigns, ou 0 si aucune campagne de numérotation n'est disponible.
dtIntervalStartDATETIMEDate et heure du début de l'intervalle.
UsersUIDVARCHAR(64)Le champ UsersUID.
UsersNameVARCHAR(64)Le nom de l'utilisateur.
UsersFirstNameVARCHAR(64)Le prénom des utilisateurs.
UsersProfilesNameVARCHAR(64)Le nom des profils des utilisateurs.
ServiceNumbersRootNumberVARCHAR(32)Le champ RootNumber du numéro de service, tel qu'il a été configuré lors de la création des statistiques compressées.
ServiceNumbersNameVARCHAR(64)Le champ Nom du numéro de service, tel qu'il a été configuré lors de la création des statistiques compressées.
ServiceNumbersName2VARCHAR(64)Le champ Name2 du numéro de service, tel qu'il a été configuré lors de la création des statistiques compressées.
DynamicPriorityGroupsNameVARCHAR(64)Le champ Nom de la table DynamicPriorityGroups, tel qu'il a été configuré lors de la création des statistiques compressées.
AcdGroupsNameVARCHAR(64)Le champ Nom de la table AcdGroups, tel qu'il a été configuré lors de la création des statistiques compressées.
Direct_CountINTAppels entrants directement à l'agent, total offert.
Direct_OK_CountINT Appels Entrantsdirectement à l'agent, répondu

Tables

CompressedUA15

This table contains compressed statistics for 15 minute intervals.

CompressedUADay

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.

FieldTypeContents
IDINTA 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.
ClientsIDINTID of client from Clients table.
UsersIDINTThe ID of the user from the Users table.
UsersProfilesIDINTThe ID of the user profile from UserProfiles in which the agent was logged in, or 0 if no profile information is available.
ServiceNumbersIDINTID of service number from ServiceNumbers table.
DynamicPriorityGroupsIDINTID of dynamic priority group from DynamicPriorityGroups table, or 0 if no dynamic priority group was assigned.
RoutingApplicationsIDINTID of the routing application from the RoutingApplications Table, or 0 if the application is not available.
AcdGroupsIDINTID of the ACD group, from the AcdGroups table, or 0 if no ACD group is available.
DiallerCampaignsIDINTID of the dialler campaign, from the DiallerCampaigns table, or 0 if no dialler campaign is available.
dtIntervalStartDATETIMEDate and Time of the start of the interval.
UsersUIDVARCHAR(64)The UsersUID field.
UsersNameVARCHAR(64)The Users Name.
UsersFirstNameVARCHAR(64)The Users FirstName.
UsersProfilesNameVARCHAR(64)The UsersProfiles Name.
ServiceNumbersRootNumberVARCHAR(32)The RootNumber field of the service number, as configured when the compressed statistics were created.
ServiceNumbersNameVARCHAR(64)The Name field of the service number, as configured when the compressed statistics were created.
ServiceNumbersName2VARCHAR(64)The Name2 field of the service number, as configured when the compressed statistics were created.
DynamicPriorityGroupsNameVARCHAR(64)The Name field from the DynamicPriorityGroups table, as configured when the compressed statistics were created.
AcdGroupsNameVARCHAR(64)The Name field from the AcdGroups table, as configured when the compressed statistics were created.
Direct_CountINTInbound calls directly to agent, total offered.
Direct_OK_CountINT
.
Direct_OK_Time_CallStart_CallConnect_TotalBIGINT
Inbound calls directly to
Appels Entrants directement à l'agent,
answered
répondu, nombre total
seconds from dtCallStart to
de secondes de dtCallStart à dtCallConnect.
Direct_OK_Time_CallStart_CallConnect_MaxINT
Inbound calls directly to
Appels Entrants directement à l'agent,
answered
répondu, max
seconds from dtCallStart to
. secondes de dtCallStart à dtCallConnect.
Direct_OK_Time_CallConnect_CallEnd_TotalBIGINT
Inbound calls directly to
Appels Entrants directement à l'agent,
answered, total seconds from dtCallConnect to
répondu, max. secondes de dtCallConnect à dtCallEnd.
Direct_OK_Time_CallConnect_CallEnd_MaxINT
Inbound calls directly to
Appels Entrantsdirectement à l'agent,
answered
répondu, max
seconds from dtCallConnect to
. secondes de dtCallConnect à dtCallEnd.
Direct
AgentCalls_OK_PostCall_CountINT
Inbound calls directly to
Appels Entrantsdirectement à l'agent,
answered, number of calls with post call work
répondu, nombre d'appels avec travail post-appel.
Direct_OK_PostCall_Time_TotalBIGINT
Inbound calls directly to
Appels Entrantsdirectement à l'agent,
answered
répondu,
total time in post call work
temps total de travail après l'appel.
Direct_OK_PostCall_Time_MaxINT
Inbound calls directly to
Appels Entrantsdirectement à l'agent,
answered, max time in post call work
répondu, temps maximum dans le travail après-appel.
Direct_NoAnswer_CountINT
Inbound calls directly to
Appels Entrantsdirectement à l'agent,
not answered
sans réponse.
Direct_NoAnswer_Time_CallStart_CallEnd_TotalBIGINT
Inbound calls directly to
Appels Entrantsdirectement à l'agent,
not answered
sans réponse, nombre total
seconds from dtCallStart to
de secondes entre dtCallStart et dtCallEnd.
Direct_NoAnswer_Time_CallStart_CallEnd_MaxINT
Inbound calls directly to
Appels Entrantsdirectement à l'agent,
not answered, max seconds from dtCallStart to
sans réponse, secondes maximum entre dtCallStart et dtCallEnd.
Direct_Busy_CountINT
Inbound calls directly to
Appels Entrantsdirectement à l'agent,
busy
occupé.
Direct_CallerHangup_CountINT
Inbound calls directly to agent, caller hangup
Appels Entrantsdirectement à l'agent, l'appelant raccroche.
Direct_CallerHangup_Time_CallStart_CallEnd_TotalBIGINT
Inbound calls directly to agent, caller hangup, total seconds from dtCallStart to
Appels Entrantsdirectement à l'agent, raccrochage de l'appelant, total des secondes entre dtCallStart et dtCallEnd.
Direct_CallerHangup_Time_CallStart_CallEnd_MaxINT
Inbound calls directly to agent, caller hangup, max seconds from dtCallStart to
Appels Entrantsdirectement à l'agent, raccrochage de l'appelant, secondes maximum entre dtCallStart et dtCallEnd.
Direct_Reject_CountINT
Inbound calls directly to
Appels Entrantsdirectement à l'agent,
rejected
rejeté.
Direct_Reject_Time_CallStart_CallEnd_TotalBIGINT
Inbound calls directly to
Appels Entrantsdirectement à l'agent,
rejected
rejeté, nombre total
seconds from dtCallStart to
de secondes de dtCallStart à dtCallEnd.
Direct_Reject_Time_CallStart_CallEnd_MaxINT
Inbound calls directly to
Appels Entrants directement à l'agent,
rejected, max seconds from dtCallStart to
rejeté, maximum de secondes entre dtCallStart et dtCallEnd.
Direct_Failure_CountINT
Inbound calls directly to
Appels Entrantsdirectement à l'agent,
failed
a échoué.
FromTransfer_CountINT
Inbound calls transferred to
Appels Entrantstransféré à l'agent, total
offered
offert.
FromTransfer_OK_CountINT
Inbound calls transferred to
Appels Entrantstransféré à l'agent,
answered
a répondu.
FromTransfer_OK_Time_CallStart_CallConnect_TotalBIGINT
Inbound calls transferred to
Appels Entrants transféré à l'agent,
answered
répondu, nombre total
seconds from dtCallStart to
de secondes de dtCallStart à dtCallConnect.
FromTransfer_OK_Time_CallStart_CallConnect_MaxINT
Inbound calls transferred to
Appels Entrants transféré à l'agent,
answered
répondu, max
seconds from dtCallStart to
. secondes de dtCallStart à dtCallConnect.
FromTransfer_OK_Time_CallConnect_CallEnd_TotalBIGINT
Inbound calls transferred to
Appels Entrants transféré à l'agent,
answered
répondu, nombre total
seconds from dtCallConnect to
de secondes de dtCallConnect à dtCallEnd.
FromTransfer_OK_Time_CallConnect_CallEnd_MaxINT
Inbound calls transferred to
Appels Entrants transféré à l'agent,
answered
répondu, max
seconds from dtCallConnect to
. secondes de dtCallConnect à dtCallEnd.
FromTransfer_OK_PostCall_CountINT
Inbound calls transferred to
Appels Entrants transféré à l'agent,
answered, number of calls with post call work
répondu, nombre d'appels avec travail post-appel.
FromTransfer_OK_PostCall_Time_TotalBIGINT
Inbound calls transferred to
Appels Entrants transféré à l'agent,
answered
répondu,
total time in post call work
temps total de travail après l'appel.
FromTransfer_OK_PostCall_Time_MaxINT
Inbound calls transferred to
Appels Entrants transféré à l'agent,
answered, max time in post call work
répondu, temps maximum dans le travail post-appel.
FromTransfer_NoAnswer_CountINT
Inbound calls transferred to
Appels Entrants transféré à l'agent,
not answered
sans réponse.
FromTransfer_NoAnswer_Time_CallStart_CallEnd_TotalBIGINT
Inbound calls transferred to
Appels Entrants transféré à l'agent,
not answered
sans réponse, nombre total
seconds from dtCallStart to
de secondes entre dtCallStart et dtCallEnd.
FromTransfer_NoAnswer_Time_CallStart_CallEnd_MaxINT
Inbound calls transferred to
Appels Entrants transféré à l'agent,
not answered, max seconds from dtCallStart to
pas de réponse, secondes maximum entre dtCallStart et dtCallEnd.
FromTransfer_Busy_CountINT
Inbound calls transferred to
Appels Entrants transféré à l'agent,
busy
occupé.
FromTransfer_CallerHangup_CountINT
Inbound calls transferred to
Appels Entrants transféré à l'agent,
caller hangup
l'appelant raccroche.
FromTransfer_CallerHangup_Time_CallStart_CallEnd_TotalBIGINT
Inbound calls transferred to agent, caller hangup, total seconds from dtCallStart to
Appels Entrants transféré à l'agent, raccrochage de l'appelant, total des secondes entre dtCallStart et dtCallEnd.
FromTransfer_CallerHangup_Time_CallStart_CallEnd_MaxINT
Inbound calls transferred to agent, caller hangup, max seconds from dtCallStart to
Appels Entrants transféré à l'agent, raccrochage de l'appelant, secondes maximum entre dtCallStart et dtCallEnd.
FromTransfer_Reject_CountINT
Inbound calls transferred to
Appels Entrants transféré à l'agent,
rejected
rejeté.
FromTransfer_Reject_Time_CallStart_CallEnd_TotalBIGINT
Inbound calls transferred to
Appels Entrants transféré to agent, rejected, total seconds from dtCallStart to dtCallEnd.
FromTransfer_Reject_Time_CallStart_CallEnd_MaxINT
Inbound calls transferred to
Appels Entrants transféré à l'agent,
rejected
rejeté, max
seconds from dtCallStart to
. secondes de dtCallStart à dtCallEnd.
FromTransfer_Failure_CountINT
Inbound calls transferred to
Appels Entrantstransféré à l'agent,
failed
a échoué.
TransferOut_Number_CountINT
Inbound calls transferred out to number by
Appels Entrants transféré au nombre par agent, total
attempts
des tentatives.
TransferOut_Number_OK_CountINT
Inbound calls transferred out to number by agent, answered
Appels Entrants transféré au numéro par l'agent, répondu.
TransferOut_Number_OK_Time_CallStart_CallConnect_TotalBIGINT
Inbound calls transferred out to number by
Appels Entrantstransféré au numéro par agent,
answered
répondu, nombre total
seconds from dtCallStart to
de secondes de dtCallStart à dtCallConnect.
TransferOut_Number_OK_Time_CallStart_CallConnect_MaxINT
Inbound calls transferred out to number by agent, answered, max seconds from dtCallStart to
Appels Entrants transféré au numéro par l'agent, répondu, max. secondes de dtCallStart à dtCallConnect.
TransferOut_Number_OK_Time_CallConnect_CallEnd_TotalBIGINT
Inbound calls transferred out to number by
Appels Entrants transféré au numéro par agent,
answered
répondu, total
seconds from dtCallConnect to
des secondes de dtCallConnect à dtCallEnd.
TransferOut_Number_OK_Time_CallConnect_CallEnd_MaxINT
Inbound calls transferred out to number by agent, answered, max seconds from dtCallConnect to
Appels Entrantstransféré au numéro par l'agent, répondu, max. secondes de dtCallConnect à dtCallEnd.
TransferOut_Number_NoAnswer_CountINT
Inbound calls transferred out to number by agent, no answer
Appels Entrantstransféré au numéro par l'agent, pas de réponse.
TransferOut_Number_NoAnswer_Time_CallStart_CallEnd_TotalBIGINT
Inbound calls transferred out to number by agent, no answer, total seconds from dCallStart to
Appels Entrantstransféré au numéro par l'agent, pas de réponse, total des secondes de dCallStart à dtCallEnd.
TransferOut_Number_NoAnswer_Time_CallStart_CallEnd_MaxINT
Inbound calls transferred out to number by agent, no answer, max seconds from dCallStart to
Appels Entrantstransféré au numéro par l'agent, pas de réponse, max. secondes à partir de dCallStart to dtCallEnd.
TransferOut_Number_Busy_CountINT
Inbound calls transferred out to number by
Appels Entrants transféré au numéro par agent,
busy
occupé.
TransferOut_Number_CallerHangup_CountINT
Inbound calls transferred out to number by agent, caller hangup
Appels Entrantstransféré au numéro par l'agent, l'appelant raccroche.
TransferOut_Number_CallerHangup_Time_CallStart_CallEnd_TotalBIGINT
Inbound calls transferred out to number by agent, caller hangup, total seconds from dCallStart to
Appels Entrantstransféré au numéro par l'agent, raccrochage de l'appelant, nombre total de secondes entre dCallStart et dtCallEnd.
TransferOut_Number_CallerHangup_Time_CallStart_CallEnd_MaxINT
Inbound calls transferred out to number by agent, caller hangup, max seconds from dCallStart to
Appels Entrantstransféré au numéro par l'agent, raccrochage de l'appelant, secondes maximum entre dCallStart et dtCallEnd.
TransferOut_Number_Reject_CountINT
Inbound calls transferred out to number by
Appels Entrantstransféré au numéro par agent,
rejected
rejeté.
TransferOut_Number_Reject_Time_CallStart_CallEnd_TotalBIGINT
Inbound calls transferred out to number by
Appels Entrantstransféré au numéro par agent,
rejected
rejeté, nombre total
seconds from dCallStart to
de secondes de dCallStart à dtCallEnd.
TransferOut_Number_Reject_Time_CallStart_CallEnd_MaxINT
Inbound calls transferred out to number by
Appels Entrantstransféré au numéro par agent,
rejected
rejeté, max
seconds from dCallStart to
. secondes de dCallStart à dtCallEnd.
TransferOut_Number_Failure_CountINT
Inbound calls transferred out to number by agent, failed
Appels Entrantstransféré au numéro par l'agent, a échoué.
TransferOut_Group_CountINT
Inbound calls transferred out to group by agent, total attempts
Appels Entrants transféré au groupe par agent, tentatives totales.
TransferOut_Group_OK_CountINT
Inbound calls transferred out to group by
Appels Entrants transféré vers group par agent,
answered
a répondu.
TransferOut_Group_OK_Time_CallStart_CallConnect_TotalBIGINT
Inbound calls transferred out to group by
Appels Entrants transféré vers group par agent,
answered
répondu, nombre total
seconds from dtCallStart to
de secondes entre dtCallStart et dtCallConnect.
TransferOut_Group_OK_Time_CallStart_CallConnect_MaxINT
Inbound calls transferred out to group by
Appels Entrants transféré vers group par agent,
answered, max seconds from dtCallStart to
répondu, secondes maximum de dtCallStart à dtCallConnect.
TransferOut_Group_OK_Time_CallConnect_CallEnd_TotalBIGINT
Inbound calls transferred out to group by
Appels Entrants transféré vers group par agent,
answered
répondu, nombre total
seconds from dtCallConnect to
de secondes entre dtCallConnect et dtCallEnd.
TransferOut_Group_OK_Time_CallConnect_CallEnd_MaxINT
Inbound calls transferred out to group by
Appels Entrants transféré vers group par agent,
answered
répondu, max
seconds from dtCallConnect to
. secondes de dtCallConnect à dtCallEnd.
TransferOut_Group_NoAnswer_CountINT
Inbound calls transferred out to group by agent, no answer
Appels Entrants transféré vers group par l'agent, pas de réponse.
TransferOut_Group_NoAnswer_Time_CallStart_CallEnd_TotalBIGINT
Inbound calls transferred out to group by agent, no answer, total seconds from dCallStart to to
Appels Entrants transféré vers group par agent, pas de réponse, nombre total de secondes entre dCallStart et dtCallEnd.
TransferOut_Group_NoAnswer_Time_CallStart_CallEnd_MaxINT
Inbound calls transferred out to group by agent, no answer, max seconds from dCallStart 
Appels Entrants transféré vers groupe par agent, pas de réponse, maximum de secondes à partir de dCallStart à dtCallEnd.
TransferOut_Group_Busy_CountINT
Inbound calls transferred out to group by
Appels Entrants transféré vers groupe par agent,
busy
occupé.
TransferOut_Group_CallerHangup_CountINT
Inbound calls transferred out to group by agent, caller hangup
Appels Entrants transféré vers groupe par l'agent, l'appelant raccroche.
TransferOut_Group_CallerHangup_Time_CallStart_CallEnd_TotalBIGINT
Inbound calls transferred out to group by agent, caller hangup, total seconds from dCallStart to
Appels Entrants transféré vers groupe par agent, raccrochage de l'appelant, total des secondes entre dCallStart et dtCallEnd.
TransferOut_Group_CallerHangup_Time_CallStart_CallEnd_MaxINT
Inbound calls transferred out to group by agent, caller hangup, max seconds from dCallStart to
Appels Entrants transféré vers groupe par agent, raccrochage de l'appelant, secondes maximum entre dCallStart et dtCallEnd.
TransferOut_Group_Reject_CountINT
Inbound calls transferred out to group by
Appels Entrants transféré vers groupe by agent, rejected.
TransferOut_Group_Reject_Time_CallStart_CallEnd_TotalBIGINT
Inbound calls transferred out to group by
Appels Entrants transféré vers groupe par agent,
rejected
rejeté, nombre total
seconds from dCallStart to
de secondes entre dCallStart et dtCallEnd.
TransferOut_Group_Reject_Time_CallStart_CallEnd_MaxINT
Inbound calls transferred out to group by
Appels Entrants transféré vers groupe par agent,
rejected
rejeté, max
seconds from dCallStart to
. secondes entre dCallStart et dtCallEnd.
TransferOut_Group_Failure_CountINT
Inbound calls transferred out to group by
Appels Entrants transféré vers groupe par agent,
failed
a échoué.
TransferOut_Agent_CountINT
Inbound calls transferred out to agent by agent, total attempts
Appels Entrantstransféré à l'agent par l'agent, tentatives totales.
TransferOut_Agent_OK_CountINT
Inbound calls transferred out to agent by
Appels Entrants transféré vers agent par agent,
answered
répondu.
TransferOut_Agent_OK_Time_CallStart_CallConnect_TotalBIGINT
Inbound calls transferred out to agent by
Appels Entrants transféré vers agent par agent,
answered
répondu, nombre total
seconds from dtCallStart to
de secondes entre dtCallStart et dtCallConnect.
TransferOut_Agent_OK_Time_CallStart_CallConnect_MaxINT
Inbound calls transferred out to agent by
Appels Entrants transféré vers agent par agent,
answered, max seconds from dtCallStart to
répondu, secondes maximum de dtCallStart à dtCallConnect.
TransferOut_Agent_OK_Time_CallConnect_CallEnd_TotalBIGINT
Inbound calls transferred out to agent by
Appels Entrants transféré vers agent par agent,
answered
répondu, nombre total
seconds from dtCallConnect to
de secondes entre dtCallConnect et dtCallEnd.
TransferOut_Agent_OK_Time_CallConnect_CallEnd_MaxINT
Inbound calls transferred out to agent by
Appels Entrants transféré vers agent par agent,
answered
répondu, max
seconds from dtCallConnect to
. secondes de dtCallConnect à dtCallEnd.
TransferOut_Agent_NoAnswer_CountINT
Inbound calls transferred out to agent by
Appels Entrants transféré vers agent by the agent, no answer.
TransferOut_Agent_NoAnswer_Time_CallStart_CallEnd_TotalBIGINT
Inbound calls transferred out to agent by agent, no answer, total seconds from dCallStart to to
Appels Entrants transféré vers agent par agent, pas de réponse, nombre total de secondes entre dCallStart et dtCallEnd.
TransferOut_Agent_NoAnswer_Time_CallStart_CallEnd_MaxINT
Inbound calls transferred out to agent by agent, no answer, max seconds from dCallStart 
Appels Entrants transféré vers agent par agent, pas de réponse, maximum de secondes à partir de dCallStart à dtCallEnd.
TransferOut_Agent_Busy_CountINT
Inbound calls transferred out to agent by agent, busy
Appels Entrants transféré vers agent par agent, occupé.
TransferOut_Agent_CallerHangup_CountINT
Inbound calls transferred out to agent by agent, caller hangup
Appels Entrants transféré vers agent par l'agent, l'appelant raccroche.
TransferOut_Agent_CallerHangup_Time_CallStart_CallEnd_TotalBIGINT
Inbound calls transferred out to agent by agent, caller hangup, total seconds from dCallStart to
Appels Entrants transféré vers agent par agent, raccrochage de l'appelant, total des secondes entre dCallStart et dtCallEnd.
TransferOut_Agent_CallerHangup_Time_CallStart_CallEnd_MaxINT
Inbound calls transferred out to agent by agent, caller hangup, max seconds from dCallStart to
Appels Entrants transféré vers agent par agent, raccrochage de l'appelant, secondes maximum entre dCallStart et dtCallEnd.
TransferOut_Agent_Reject_CountINT
Inbound calls transferred out to agent by
Appels Entrants transféré vers agent par agent,
rejected
rejeté.
TransferOut_Agent_Reject_Time_CallStart_CallEnd_TotalBIGINT
Inbound calls transferred out to agent by
Appels Entrants transféré vers agent par agent,
rejected
rejeté, nombre total
seconds from dCallStart to
de secondes entre dCallStart et dtCallEnd.
TransferOut_Agent_Reject_Time_CallStart_CallEnd_MaxINT
Inbound calls transferred out to agent by
Appels Entrants transféré vers agent par agent,
rejected
rejeté, max
seconds from dCallStart to
. secondes entre dCallStart et dtCallEnd.
TransferOut_Agent_Failure_CountINT
Inbound calls transferred out to agent by
Appels Entrants transféré vers agent par agent,
failed
a échoué.
ClickToDial_CountINT
Outbound, click to dial
Sortant, cliquez pour composer, total.
ClickToDial_OK_CountINT
Outbound, click to dial
Sortant, cliquez pour composer, OK.
ClickToDial_OK_Time_CallStart_CallConnect_TotalINT
Outbound, click to dial
Sortant, cliquez pour composer, OK,
total seconds from dtCallStart to
secondes totales de dtCallStart à dtCallConnect (
to
au tronçon de destination
leg
).
ClickToDial_OK_Time_CallStart_CallConnect_MaxINT
Outbound, click to dial
Sortant, cliquez pour composer, OK,
max seconds from dtCallStart to dtCallConnect (to destination leg
secondes maximum entre dtCallStart et dtCallConnect (vers le segment de destination).
ClickToDial_OK_Time_CallConnect_CallEnd_TotalINT
Outbound, click to dial
Sortant, cliquez pour composer, OK,
total seconds from dtCallConnect to dtCallEnd (to destination leg
le nombre total de secondes entre dtCallConnect et dtCallEnd (vers le segment de destination).
ClickToDial_OK_Time_CallConnect_CallEnd_MaxINT
Outbound, click to dial
Sortant, cliquez pour composer, OK,
max seconds from dtCallConnect to dtCallEnd (to destination leg
secondes maximum entre dtCallConnect et dtCallEnd (vers le segment de destination).
ClickToDial_NoAnswer_CountINT
Outbound, click to dial, no answer
Sortant, cliquez pour composer, pas de réponse.
ClickToDial_NoAnswer_Time_CallStart_CallEnd_TotalINT
Outbound, click to dial
Sortant, cliquez pour composer, OK,
total seconds from dtCallStart to dtCallEnd (to destination leg
secondes totales de dtCallStart à dtCallEnd (jusqu'au segment de destination).
ClickToDial_NoAnswer_Time_CallStart_CallEnd_MaxINT
Outbound, click to dial
Sortant, cliquez pour composer, OK,
max seconds from dtCallStart to dtCallEnd (to destination leg
secondes maximum entre dtCallStart et dtCallEnd (jusqu'à l'étape de destination).
ClickToDial_Busy_CountINT
Outbound, click to dial, busy
Sortant, cliquez pour composer, occupé.
ClickToDial_AgentHangup_CountINT
Outbound, click to dial, agent hangup before call connected
Sortant, cliquez pour composer, l'agent raccroche avant que l'appel ne soit connecté.
ClickToDial_Reject_CountINT
Outbound, click to dial, rejected
Sortant, cliquez pour composer, rejeté.
ClickToDial_Failure_CountINT
Outbound, click to dial, failed
Sortant, cliquez pour composer, échoué.
Dialler_CountINT
Outbound, from dialler campaign
Sortants, du campagne composeur, total.
Dialler_OK_CountINT
Outbound, from dialler campaign
Sortants, du campagne composeur, OK.
Dialler_OK_Time_CallStart_CallConnect_TotalINT
Outbound, from dialler campaign
Sortants, du campagne composeur, OK,
total seconds from dtCallStart to
secondes totales de dtCallStart à dtCallConnect (
to
au tronçon de destination
leg
).
Dialler_OK_Time_CallStart_CallConnect_MaxINT
Outbound, from dialler campaign
Sortants, du campagne composeur, OK,
max seconds from dtCallStart to dtCallConnect (to destination leg
secondes maximum entre dtCallStart et dtCallConnect (vers le segment de destination).
Dialler_OK_Time_CallConnect_CallEnd_TotalINT
Outbound, from dialler campaign
Sortants, du campagne composeur, OK,
total seconds from dtCallConnect to
secondes totales de dtCallConnect à dtCallEnd (
to
au tronçon de destination
leg
).
Dialler_OK_Time_CallConnect_CallEnd_MaxINT
Outbound, from dialler campaign
Sortants, du campagne composeur, OK,
max seconds from dtCallConnect to dtCallEnd (to destination leg
secondes maximum entre dtCallConnect et dtCallEnd (vers le segment de destination).
Dialler_NoAnswer_CountINT
Outbound, from dialler campaign, no answer
Sortants, du campagne composeur, pas de réponse.
Dialler_NoAnswer_Time_CallStart_CallEnd_TotalINT
Outbound, from dialler campaign
Sortants, du campagne composeur, OK,
total seconds from dtCallStart to dtCallEnd (to destination leg
secondes totales de dtCallStart à dtCallEnd (jusqu'au segment de destination).
Dialler_NoAnswer_Time_CallStart_CallEnd_MaxINT
Outbound, from dialler campaign
Sortants, du campagne composeur, OK,
max seconds from dtCallStart to dtCallEnd (to destination leg
secondes maximum entre dtCallStart et dtCallEnd (jusqu'à l'étape de destination).
Dialler_Busy_CountINT
Outbound, from dialler campaign, busy
Sortants, du campagne composeur, occupé.
Dialler_AgentHangup_CountINT
Outbound, from dialler campaign, agent hangup before call connected
Sortants, du campagne composeur, l'agent raccroche avant que l'appel ne soit connecté.
Dialler_Reject_CountINT
Outbound, from dialler campaign, rejected
Sortants, du campagne composeur, rejeté.
Dialler_Failure_CountINT
Outbound, from dialler campaign, failed
Sortants, du campagne composeur, échoué.