Jump to: navigation, search

View AG2_CAMPAIGN

Description

This view represents the disposition-based aggregate AGT_CAMPAIGN_HOUR table, which provides a rollup of interactions generated by a particular campaign. Rollups are derived primarily from the CONTACT_ATTEMPT_FACT table with an inner join on CALL_RESULT. Counts and durations are attributed to the interval in which contact attempts were made.

Aggregation is performed along the TENANT, DATE TIME, CAMPAIGN, MEDIA_TYPE, INTERACTION_ DESCRIPTOR, GROUP_ and USER_DATA_CUST_DIM dimensions.

The determination of special information tone (SIT) values in this view depends on the underlying signaling lines, capabilities of the CPD Server, and the dialer, which maps SIT classifications to Genesys enumeration. Refer to the Genesys Outbound Contact documentation set for more information.

The same columns and column descriptions apply to other AG2_CAMPAIGN_* views.

Column List

Column Description
DATE_TIME_KEY The surrogate key that is used to join this aggregate table to the DATE_TIME dimension table to identify the calendar date and 15-minute interval at which the agent’s participation in the interaction began.
INTERACTION_DESCRIPTOR_KEY The surrogate key that is used to join this aggregate table to the INTERACTION_DESCRIPTOR dimension table to identify the business attributes that have been assigned to the interaction.
TENANT_KEY The surrogate key that is used to join this aggregate table to the TENANT view to identify a specific tenant.
CAMPAIGN_GROUP_KEY The surrogate key that is used to join this aggregate table to the GROUP_ view to identify the specific group which the Genesys Outbound Contact campaign was a member of when the interaction was generated.
CAMPAIGN_KEY The surrogate key that is used to join this aggregate table to the CAMPAIGN view to identify a specific Genesys Outbound Contact campaign.
MEDIA_TYPE_KEY The surrogate key that is used to join this aggregate table to the MEDIA_TYPE dimension table.
CALLING_LIST_KEY The surrogate key that is used to join this aggregate table to the CALLING_LIST view to identify a specific Genesys Outbound Contact list from which the interaction originated.
USER_DATA_KEY1 The surrogate key that is used to join this aggregate table to a custom user data dimension table to identify attached data that has been assigned to the interaction.
USER_DATA_KEY2 The surrogate key that is used to join this aggregate table to a custom user data dimension table to identify attached data that has been assigned to the interaction.
ATTEMPTS The total number of contact attempts that the Outbound Contact Server processed for this campaign regardless of the disposition of each attempt or how the attempt was initiated.
ABANDONED The total number of times attributed to the reporting interval that contact attempts from this campaign returned an abandoned call result (CALL_RESULT_CODE='ABANDONED').
ANSW_MACHINE The total number of times attributed to the reporting interval that the system detected an answering machine for contact attempts from this campaign (CALL_RESULT_CODE= 'ANSWERING_MACHINE_DETECTED').
ANSWERS The total number of times attributed to the interval that contact attempts from this campaign returned an answered call result (CALL_RESULT_CODE='ANSWERED').
BUSY The total number of times attributed to the reporting interval that contact attempts from this campaign returned a busy call result (CALL_RESULT_CODE='BUSY').
CALLBKS_COMPL The total number of times attributed to the reporting interval that campaign callbacks were completed by an agent, excluding missed callbacks.
CALLBKS_MISSED The total number of times attributed to the reporting interval that campaign callbacks were missed.
CALLBKS_SCHED The total number of times attributed to the reporting interval that agents rescheduled contact attempts from this campaign.
CANCEL The total number of canceled records that were dialed from this campaign during the reporting interval.
DIAL_DROPPED The total number of times attributed to the interval that the system detected a call drop during contact attempts made from this campaign (CALL_RESULT_CODE='CALL_DROP_ERROR').
DROPPED The total number of times attributed to the interval that the system detected a call drop during contact attempts made from this campaign (CALL_RESULT_CODE='DROPPED').
SILENCE The total number of times attributed to the interval that the system detected silence during contact attempts made from this campaign (CALL_RESULT_CODE='SILENCE').
STALE The total number of times attributed to the interval that the system detected a stale call result during contact attempts made from this campaign (CALL_RESULT_CODE='STALE').
OK The total number of times attributed to the interval that the system detected a call result of OK during contact attempts made from this campaign (CALL_RESULT_CODE='OK').
DIAL_MADE The total number of contact attempts made by this campaign within the interval.
DO_NOT_CALL The total number of times attributed to the interval that the call result of this contact attempt was Do Not Call (CALL_RESULT_CODE='DO_NOT_CALL').

This measure, as well as Canceled, is counted simultaneously with other Outbound call results, such as Answered, Wrong Party, No Answer, No Port Available, and Busy.

FAXMODEM_DETECT The total number of times attributed to the interval that the system detected a fax machine for contact attempts made by this campaign (CALL_RESULT_CODE='FAX_DETECTED').
NO_ANSWER The total number of times attributed to the interval that the call result of contact attempts from this campaign was No Answer (CALL_RESULT_CODE='NO_ANSWER').
NO_RPC The total number of times attributed to the interval that the call result of contact attempts from this campaign was Wrong Party—the right person was not contacted (CALL_RESULT_CODE='WRONG_PARTY').
PER_CALLBK_COMPL The total number of times attributed to the interval that callbacks were completed by the agent who requested them for contact attempts made from this campaign excluding missed callbacks.
PER_CALLBK_MISS The total number of times attributed to the interval that callbacks were missed by the agent who requested them for contact attempts made from this campaign.
PER_CALLBK_SCHED The total number of times attributed to the interval that agents rescheduled callbacks for contact attempts made from this campaign.
SIT_DETECTED The total number of times attributed to the interval that the system detected a special information tone for contact attempts made from a specific calling list from this campaign (CALL_RESULT_CODE='SIT_DETECTED'). A count of either 0 or 1 is attributed to this measure’s value for each contact attempt.
SIT_INVALID_NUM The total number of times attributed to the interval that the system detected a special information tone that indicated an invalid number for contact attempts made from a specific calling list from this campaign (CALL_RESULT_ CODE='SIT_INVALID_NUMBER'). A count of either 0 or 1 is attributed to this measure’s value for each contact attempt.
SIT_NO_CIRCUIT The total number of times attributed to the interval that the system detected a special information tone indicating that all circuits were busy for contact attempts made from a specific calling list from this campaign (CALL_ RESULT_CODE='SIT_NC'). A count of either 0 or 1 is attributed to this measure’s value for each contact attempt.
SIT_OPER_INTER The total number of times attributed to the interval that the system detected a special information tone indicating that the dialed number either had been changed or disconnected for contact attempts made from a specific calling list from this campaign (CALL_RESULT_CODE='SIT_IC'). A count of either 0 or 1 is attributed to this measure’s value for each contact attempt.
SIT_REORDER The total number of times attributed to the interval that the system detected a special information tone indicating incomplete digits, internal office, feature failure, call failure, no wink, or partial digits received for contact attempts made from a specific calling list from this campaign (CALL_RESULT_CODE='SIT_RO'). A count of either 0 or 1 is attributed to this measure’s value for each contact attempt.
SIT_UNKNOWN The total number of times attributed to the interval that the system detected an unknown special information tone for contact attempts made from a specific calling list from this campaign (CALL_RESULT_CODE='SIT_ UNKNOWN_CALL_STATE'). A count of either 0 or 1 is attributed to this measure’s value for each contact attempt.
SIT_VACANT The total number of times attributed to the interval that the system detected a special information tone indicating an N11 code, a class code, or a prefix for contact attempts made from a specific calling list from this campaign (CALL_RESULT_CODE='SIT_VC'). A count of either 0 or 1 is attributed to this measure’s value for each contact attempt.
CPD The total number of contact attempts that were initiated during this reporting interval in which call-progress detection was performed.
CPD_TIME_MS The total duration, in milliseconds, of call-progress detection for contact attempts that were initiated during this reporting interval measured from the moment at which the call was established to the moment at which CPD completed.
CPD_DIAL The total number of dialing events for which the CPD Server provided dial duration.
CPD_DIAL_TIME_MS The total dial duration, in milliseconds, of OCS-initiated calls, measured from the moment at which dialing was initiated to the moment at which either the dialed call was established by the contacted party or it was abandoned or released.

Dial duration for established calls is available only when the CPD Server is used for dialing.

CPD_TRANSFER The total number of transfers that were used to deliver calls from the point of call-progress detection to agents or IVR.
CPD_TRANSFER_TIME_MS The total duration, in milliseconds, of CPD transfers that were completed during the reporting interval measured from the moment at which call-progress detection completed to the moment at which the contact attempts were established on the agent’s or IVR DN.
OVERDIAL The total number of CPD dials that were abandoned or were answered by the called party but not established with an agent or IVR within two seconds of the dialing event.
PORT_UNAVAILABLE The total number of times attributed to the interval that the call result of contact attempts made from this campaign was No Port Available (CALL_RESULT_CODE=‘NO_PORT_AVAILABLE’).

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on April 11, 2017, at 06:12.