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’). |