Versions Compared

Key

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

...

Either 1 if the type of set is Done or 0 if another type chosend instead or empty it no result code was set.WHEN DiallerContactsHistory.DiallerResultCodesTypesID IS NULL THEN NULL
WHEN DiallerContactsHistory.DiallerResultCodesTypesID = 1 THEN 1
ELSE 0Either 1 if the type of set is or 0 if another type chosend instead or empty it no result code was set.Either 1 if the type of set is or 0 if another type was chosend instead or empty it no result code was set.Either 1 if the type of set is or 0 if another type was chosend instead or empty it no result code was set.WHEN DiallerContactsHistory.DiallerResultCodesTypesID IS NULL THEN NULL
WHEN DiallerContactsHistory.DiallerResultCodesTypesID = 4 THEN 1
ELSE 0
NameDesciptionCriteria Used

Campaign Times - Start

The time stamp when the dialler campaign started.

Campaign Times - End

The time stamp when the dialler campaign ended

Call Attempts  

The total call time duration.

WHEN a.CONNRES = 1 THEN (a.dtCallEnd - a.dtCallConnect)

See also Value Reference - CONNRES

number of calls initated in the current dialler campaign over the selected granularity and within a particular time slice.

SUM( nTriesConnected ) + SUM( nTriesNoAnswer ) + SUM( nTriesBusy ) + SUM( nTriesInvalid ) + SUM( nTriesAborted ) + SUM( nTriesAnsweringMachine ) + SUM( nTriesError )

Call Attempts - Connected

1 if the call was The total number of call successfully connected to the destionation Else 0the destination in the current dialler campaign over the selected granularity and within a particular time slice.

SUM( nTriesConnected )

WHEN a.CONNRES = 1 THEN 1 ELSE 0

See also Value Reference - CONNRES

Call Attempts  - No Answer

1 if the called The total number of call initated in the current dialler campaign over the selected granularity and within a particular time slice and was not connected because the destination did not answeranswered. Else 0

SUM( nTriesNoAnswer )

IF a.CONNRES = 2 THEN 1 ELSE 0

See also Value Reference - CONNRES

Call Attempts - Busy

1 if the called The total number of call initated in the current dialler campaign over the selected granularity and within a particular time slice and was not connected because the destination was busy. Else 0

IF a.CONNRES = 3 THEN 1 ELSE 0

See also Value Reference - CONNRES

SUM( nTriesBusy )

Call Attempts - Invalid

1 if the called destination number was either Unallocated (unassigned) or the destination rejected the call of the destinaion number format is invalid. Else 0

IF a.CauseCodesID IN ( 1, 21, 28) THEN 1 ELSE 0

See also Value Reference - CauseCodes

Call Attempts - Aborted

1 if the outdial was aborted. Else 0

IF a.CONNRES = 4 THEN 1 ELSE 0

See also Value Reference - CONNRES

The total number of call initated in the current dialler campaign over the selected granularity and within a particular time slice and was not connected because the destination number was invalid.

SUM( nTriesInvalid )

Call Attempts - Aborted

The total number of call initated in the current dialler campaign over the selected granularity and within a particular time slice and was not connected because the call was rejected by the destination.

SUM( nTriesAborted )

Call Attempts - Ans. Machine

1 if the call ended for any other reason. Else 0

IF a.CONNRES NOT IN (1, 2, 3, 4)  AND a.CauseCodesID NOT IN ( 1, 21, 28) THEN 1 ELSE 0

See also Value Reference - CONNRES and Value Reference - CauseCodes

The total number of call initated in the current dialler campaign over the selected granularity and within a particular time slice and was not connected because the destination number was invalid.

SUM( nTriesAnsweringMachine )

Call Attempts - Error

Name of the service number through which the call was made.
The total number of call initated in the current dialler campaign over the selected granularity and within a particular time slice and was not connected because an error occured.SUM( nTriesError )

Contact Results - Done

Total amount of the the result code "done" was set in the current dialler campaign over the selected granularity and within a particular time slice.

SUM( nContactsDone )

Contact Results - Aborted

Total amount of the the result code "Aborted" was WHEN DiallerContactsHistory.DiallerResultCodesTypesID IS NULL THEN NULL
WHEN DiallerContactsHistory.DiallerResultCodesTypesID = 2 THEN 1
ELSE 0
set in the current dialler campaign over the selected granularity and within a particular time slice.SUM( nContactsAborted )

Contact Results - Appointment

Total amount of the the result code "Appointment" WHEN DiallerContactsHistory.DiallerResultCodesTypesID IS NULL THEN NULL
WHEN DiallerContactsHistory.DiallerResultCodesTypesID = 3 THEN 1
ELSE 0
was set in the current dialler campaign over the selected granularity and within a particular time slice.SUM( nContactsAppointment )

Contact Results - Delay

Total amount of the the result code "Delay" was set in the current dialler campaign over the selected granularity and within a particular time slice.SUM( nContactsDelayed 


Table of Contents
maxLevel2
outlinetrue
typeflat