Jump to: navigation, search

View AG2_ID

Description

This view represents the interval-based aggregate table AGT_ID_HOUR, which provides a rollup of resource interaction-handling activities for interactions that are assigned a specific business attribute, such as customer segment, business result, service type, and service subtype. Rollups are derived primarily from the INTERACTION_RESOURCE_FACT table and are based on the resource’s first attempt in handling interactions. An inner join to IRF_USER_DATA_GEN_1 provides aggregated data that is dimensioned by revenue and customer satisfaction. Note that within the AG2_ID hierarchy, these two sets of fields are stored as integers. In the source IRF_USER_DATA_GEN_1 table, they are stored in character format. Numeric data only should be written to these fields. Refer to “Check for Incorrect Data Type” in the Reporting and Analytics Aggregates User’s Guide to learn how to recover from situations in which RAA attempts to aggregate nonnumeric data.

This table includes two sets of measures regarding interactions that are assigned a business attribute-namely, measures for:

  • Customer interactions that are distributed to handling resources.
  • Received consult interactions that are distributed to handling resources, where the consultations are associated with customer interactions.

Counts and durations for the first set of measures are attributed to the interval in which the interaction entered the contact center. For consultations, counts and durations are attributed to the interval in which the resource receiving the consult request was offered the interaction.

Records in this table exclude interactions that are routed to and accepted by unmonitored resources and include interactions that are directly routed from the switch or distributed through mediation DNs. Aggregation is performed along the TENANT, DATE_TIME, INTERACTION_TYPE, MEDIA_TYPE, and INTERACTION_ DESCRIPTOR dimensions. The combination of keys to these dimensions uniquely identifies records in this table.

The same columns and column descriptions apply to other AG2_ID_* tables.

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 corresponding to the start of the aggregated interval.
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 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.
MEDIA_TYPE_KEY The surrogate key that is used to join this aggregate table to the MEDIA_TYPE dimension table.
INTERACTION_TYPE_KEY The surrogate key that is used to join this aggregate table to the INTERACTION_TYPE dimension table.
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. If you engage the social-media feature, RAA maps this field to GEN_ES_KEY in the IRF_USER_DATA_KEYS table.
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.
POST_CALL_SURVEY_KEY1 The surrogate key that is used to join this aggregate table to the POST_CALL_SURVEY dimension table.
POST_CALL_SURVEY_KEY2 The surrogate key that is used to join this aggregate table to the POST_CALL_SURVEY dimension table.
ENTERED The total number of customer interactions that entered or began within the contact center and were assigned this business attribute. This count includes abandoned interactions.
ENTERED_THREAD The total number of unique threads of customer interactions of this business attribute that entered or began within the contact center. This measure is attributed to the first interval of the thread.
ENTERED_OBJ_RES The total number of customer interactions that entered or began within the contact center, were assigned this business attribute, and either had a baseline service objective or a response threshold that was greater than zero. This measure relies on the value of the response threshold as configured in the [agg-gim-thld-ID-IXN] section.
ABANDONED The total number of customer interactions of this business attribute that were abandoned or stopped for any reason while the interactions were waiting for the first handling resource. The count includes customer interactions that were abandoned while they were ringing at the agent’s desktop or alerting at the handling resource as well as short-abandoned interactions.
DEFERRED The total number of customer interactions of this business attribute that were deferred while the interactions were waiting for the first handling resource.
ABANDONED_INVITE The total number of customer interactions of this business attribute that were abandoned or dropped for any reason while they were alerting or ringing at the first handling resource. This count includes short-abandoned interactions.
SHORT_ABANDONED The total number of customer interactions of this business attribute that were abandoned or dropped for any reason within the threshold while they were waiting for the first handling resource. This measure relies on the value of the short-abandoned threshold as configured in the [agg-gim-thld-ID-IXN] section.
ACCEPTED_THREAD The total number of customer-interaction threads that were accepted, initiated, or pulled by handling resources. This measure includes a handling resource’s first participation in outbound replies to inbound interactions.
ACCEPTED The total number of customer interactions of this business attribute that were accepted, answered, or pulled by a handling resource.
ACCEPT_TIME The total amount of time, in seconds, that customer interactions of this business attribute were queued and/or alerting or ringing before the interactions were accepted, answered, or pulled by the first-handling resource. Duration starts when the interaction enters or begins within the contact center and ends when the interaction is accepted, answered, or pulled by the handling resource. This measure includes alert (ring) time.
ACCEPTED_THR The total number of times that customer interactions or established warm consultations of this business attribute that were accepted, answered, or pulled by a handling resource within the acceptance threshold. This measure relies on the value of the acceptance threshold as configured in the [agg-gim-thld-ID-IXN] section.
RESPONSES For voice and chat media, the total number of customer interactions of this business attribute that were accepted, answered, or pulled by handling resources.

For e-mail, this measure represents the total number times that resources (e.g., agents) created outbound replies that might or might not have been sent. One handling resource can create multiple replies; this measure’s value reflects each reply.

The value of this measure is greater than or equal to RESPONDED.
RESPONDED For voice and chat media, the total number of customer interactions of this business attribute that had been answered by a handling resource.

For e mail, this measure represents the total number interactions that had a response that had been sent to a customer. One handling resource can send multiple replies; however, this measure’s value is either 0 or 1 for each interaction.

The value of this measure is less than or equal to RESPONSES.
RESPONDED_THR The total number of customer interactions of this business attribute for which a response was created within the service time threshold configured by service-related key-value pairs in the attached user-data mapping.

For online media, a response is considered to have been created when the interaction was accepted. For offline media, the first reply to a given interaction must be sent out in order to increment this measure.

This measure excludes interactions that were routed to and accepted, answered, or pulled by unmonitored resources.

This measure relies on the value of the response threshold as configured in the [agg-gim-thld-ID-IXN] section.
FIRST_RESPONSE_TIME The total amount of time, in seconds, including mediation duration that elapsed before a first response to a customer interaction, that was assigned this business attribute was created.

For online media, a response is considered to have been created when the interaction was accepted by a handling resource. For offline media, the first reply to a given interaction must be sent in order to increment this measure.

The business-attribute assignment can occur at any moment during the interaction’s lifetime for this measure to be tallied.
ACCEPTED_AGENT The total number of customer interactions of this business attribute that were accepted, answered, or pulled by an agent.
ACCEPTED_AGENT_TIME The total amount of time, in seconds, that customer interactions of this business attribute were queued and/or alerting or ringing at agent resources before the interactions were accepted, answered, or pulled by the first-handling agent. Duration starts when an interaction enters or begins within the contact center and ends when the interaction is accepted, answered, or pulled by an agent—thereby, including alert time or ring time.
ACCEPT_TIME_AGENT_MAX The longest amount of time, in seconds, that customer interactions of this business attribute spent in a queue before the interactions were accepted by the first handling resource. The duration starts when the interaction enters or begins within the contact center and ends when the interaction is accepted, answered, or pulled. This measure includes alert (ring) time.
ABANDONED_TIME The total amount of time, in seconds, associated with customer interactions of this business attribute that were abandoned or dropped for any reason. This time includes the duration of customer interactions that were abandoned within the short-abandoned threshold.
ABANDONED_STANDARD_TIME The total amount of time, in seconds, that is associated with interactions of this business attribute that were abandoned by the customer or dropped for any reason before the interactions could be established. This time excludes the duration of customer interactions that were abandoned within the short-abandoned threshold. This measure relies on the value of the short-abandoned threshold as configured in the [agg-gim-thld-ID-IXN] section.
ABANDONED_TIME_MAX The maximum amount of time, in seconds, that customer interactions that entered or began within the contact center and were assigned this business attribute spent in a queue and/or alerting/ringing at the first target before the interactions were abandoned or stopped for any reason.
ENGAGE_TIME The total amount of time, in seconds, that agents were engaged with customers for interactions that were assigned this business attribute. This measure excludes engagement time that is associated with collaborations, simple consultations, and other interaction-related durations, such as hold time, ACW time, and alert (ring) time.
ENGAGE The total number of interactions for which agents were engaged with customers for interactions that the agents received and that were assigned this business attribute. This measure excludes other interaction-related counts, such as holds, instances of ACW, and collaborations and consultations that the agents received.
HOLD_TIME The total amount of time, in seconds, that agents had customers on hold for interactions assigned this business attribute.
HOLD The total number of customer interactions of this business attribute that agents had on hold.
WRAP_TIME The total amount of time, in seconds, that resources spent in ACW state for customer interactions that were received of this business attribute.
WRAP The total number of times that agents entered ACW state for customer interactions that the agents received of this business attribute.
INVITE The total number of customer interactions of this business attribute that alerted or rang at agents before the interactions were accepted, answered, or pulled plus the total number of dials that agents performed, where the interactions were successfully established. This measure is attributed to the interval in which the alerting/dialing first occurred. The dialing component of this measure applies only to voice media.
INVITE_TIME The total amount of time, in seconds, that customer interactions of this business attribute alerted at agents plus the total duration of dialing performed by agents.

For the alerting component of this measure, interactions do not have to be established for this measure to be incremented. For the dialing component, dial duration is measured for established interactions only and is applicable only to voice media.

This measure is attributed to the interval in which the alerting/dialing first occurred.
CONSULT_RECEIVED_ACCEPTED The total number of interactions of this business attribute that included requests for collaboration or consultation where the collaborations/consultations were associated with customer interactions. For voice, this measure is the same as CONSULT_RESPONSES.
CONSULT_RESPONSES For e-mail, the total number of collaboration replies that were initiated within the contact center. For voice, this measure is the same as CONSULT_RECEIVED_ACCEPTED.
CONSULT_RECEIVED_INVITE The total number of simple consult interactions of this business attribute that alerted or rang at agent resources before the agents accepted, answered, or pulled the interactions.
CONSULT_RECEIVED_INVITE_TIME The total amount of time, in seconds, that simple consult interactions of this attribute alerted or rang at agent resources. Consultations do not have to be established for this measure to be incremented.
CONSULT_RECEIVED_ENGAGE_TIME The total amount of time, in seconds, that agents were engaged in collaborations or simple consultations where the collaborations/consultations were associated with customer interactions of this business attribute and the agents were the recipients of the collaboration/consultations requests.
CONSULT_RECEIVED_HOLD_TIME The total amount time, in seconds, that agents had simple consultations on hold where the consultations were associated with customer interactions of this business attributes and the agents were the recipients of the consultation requests.
CONSULT_RECEIVED_HOLD The total number of simple consultations that agents had on hold where the interactions were associated with customer interactions of this business attribute and the agents were the recipients of the consultation requests.
CONSULT_RECEIVED_WRAP_TIME The total amount of time, in seconds, that agents spent in ACW state after consult calls that the agents accepted, where the consultations were associated with customer interactions that were assigned this business attribute.
CONSULT_RECEIVED_WRAP The total number of simple consultations for which agents entered ACW state where the consultations were associated with customer interactions of this business attribute and the agents were the recipients of the consultation requests.
CONSULT_RCV_WARM_ENGAGE_TIME The total amount of time, in seconds, that agents were engaged in consultations where the agents were the recipients of the consultation requests and the interactions were transferred to or conferenced with the agents.
CONSULT_RCV_WARM_INVITE The total number of warm consult interactions of this business attribute that rang at agent resources before the agents answered the calls.
CONSULT_RCV_WARM_INVITE_TIME The total amount of time, in seconds, that warm consult interactions of this business attribute that alerted or rang at agents.
CONSULT_RCV_ACC_WARM The total number of interactions of this business attribute that included requests for collaboration or consultation where the collaborations/consultations were transferred to or conferenced with the agents who accepted them.
CONSULT_RCV_WARM_HOLD_TIME The total amount time, in seconds, that agents had consultations on hold where the interactions were associated with customer interactions of this business attribute, the agents were the recipients of the consultation requests, and the interactions were transferred to or conferenced with the agents.
CONSULT_RCV_WARM_HOLD The total number of consultations that agents had on hold where the consultations were associated with customer interactions of this business attribute, the agents were the recipients of the consultation requests, and the interactions were transferred to or conferenced with the agents.
CONSULT_RCV_WARM_WRAP_TIME The total amount of time, in seconds, that agents spent in ACW state following consultations that the agents requested and received, where the consultations were associated with customer interactions that were assigned this business attribute and the interactions were transferred to or conferenced with the agents.

This measure includes:

  • ACW durations that were associated with conferences, where the customer leaves the interactions.
  • Internal contact center interactions where interactions were transferred to the agents.
In common call-flow scenarios, this measure yields a value of zero.
CONSULT_RCV_WARM_WRAP The total number of consultations that agents received for which agents entered ACW state where the consultations were associated with customer interactions of this attribute, and the interactions were transferred to or conferenced with the agents. In common call-flow scenarios, this measure yields a value of zero.
CONFERENCE_INIT_AGENT The total number of times that agents initiated conferences for customer interactions that the agents received where the interactions were established and were of this business attribute.
TRANSFER_INIT_AGENT The total number of customer interactions of this business attribute that agents transferred. Both warm and blind transfers are reflected in this measure.
FINISHED_RESPONSE The total number of completed customer interactions that were assigned this business attribute and for which non-acknowledgement responses were sent by the system.
FINISH_RESPONSE_TIME The total duration, in seconds, of completed customer interactions that were assigned this business attribute and for which non-acknowledgement responses were sent by the system. The responses can be auto-responses that are generated by system handling resources or responses that are generated by agents. (For synchronous media, a response is counted upon acceptance of the interaction.) This duration includes the entire lifespan of the interaction: processing, queuing, and handling.
FINISHED The total number of completed customer interactions that were assigned this business attribute. This measure is equivalent to ENTERED when there are no remaining active interactions during the interval.
FINISHED_THR The total number of customer interactions of this business attribute that were completed within the finish threshold. This measure relies on the value of the finish threshold as configured in the [agg-gim-thld-ID-IXN] section.
FINISH_TIME The total amount of time, in seconds, that it took to complete customer interactions that were assigned this business attribute. Duration is measured as the end time of a completed interaction minus its start time. Active interactions do not contribute to this measure.
SATISFACTION_ENTERED The total number of times that customer-satisfaction scores were recorded for customer interactions of this business attribute. This measure might yield results that are greater than the total number of interactions that entered or began within the contact center if customer satisfaction scores were attributed more than once to the same interaction.
SATISFACTION The sum of numerical scores of customer satisfaction that were attributed to customer interactions assigned this business attribute.
REVENUE_ENTERED The total number of customer interactions that entered or began within the contact center, were assigned this business attribute, and had associated revenue. Unlike SATISFACTTION_ENTERED, this measure never yields results that are greater than the total number of interactions that entered or began within the contact center. If more than one agent handled the same interaction, revenue is attributed to the first-handling agent only.
REVENUE The total revenue generated during the interval by customer interactions assigned this business attribute.
ACTIONABILITY_ENTERED The total number of times that actionability scores were recorded for customer interactions of this business attribute.
ACTIONABILITY The sum of actionability scores attached to customer interactions that were handled by this agent.
SENTIMENT_ENTERED The total number of times that sentiment scores were recorded for customer interactions of this business attribute.
SENTIMENT The sum of sentiment scores attached to customer interactions that were handled by this agent.
INFLUENCE_ENTERED The total number of times that influence scores were recorded for customer interactions of this business attribute.
INFLUENCE The sum of influence scores attached to customer interactions that were handled by this agent.
This page was last edited on April 11, 2017, at 14:12.
Comments or questions about this documentation? Contact us for support!