Line 1: | Line 1: | ||
<translate>= disposition_counters= | <translate>= disposition_counters= | ||
Each row in the ''disposition_counters'' table provides metrics for interactions associated with the service specified in the ''service_name'' field whose processing ended with a particular disposition. | Each row in the ''disposition_counters'' table provides metrics for interactions associated with the service specified in the ''service_name'' field whose processing ended with a particular disposition. | ||
− | |||
== Description of Data == | == Description of Data == | ||
Line 12: | Line 11: | ||
|'''Description''' | |'''Description''' | ||
|- | |- | ||
− | |''' | + | |'''agg_run_id''' |
|BINARY (16) | |BINARY (16) | ||
− | | | + | |Aggregator run that produced this record |
|- | |- | ||
− | |''' | + | |'''disposition_name''' |
− | | | + | |VARCHAR |
− | | | + | |Disposition name |
|- | |- | ||
|'''end_time''' | |'''end_time''' | ||
Line 24: | Line 23: | ||
|End time of the aggregation interval; time is given in the Universal Coordinated Time (UTC) time zone | |End time of the aggregation interval; time is given in the Universal Coordinated Time (UTC) time zone | ||
|- | |- | ||
− | |''' | + | |'''id''' |
|BINARY (16) | |BINARY (16) | ||
− | | | + | |Primary key |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
|'''is_campaign''' | |'''is_campaign''' | ||
Line 48: | Line 39: | ||
If set to CHAT, any ''call'' mentioned in this table shall be interpreted as a service chat interaction in the same context. | If set to CHAT, any ''call'' mentioned in this table shall be interpreted as a service chat interaction in the same context. | ||
|- | |- | ||
− | |''' | + | |'''num_calls_outbound''' |
|BIGINT | |BIGINT | ||
− | | | + | |This metric specifies the number of outbound calls associated with the given service whose processing ended with the disposition specified in the ''disposition_name'' field. |
+ | |||
+ | It includes regular outbound calls and calls of preview campaign calls that were actually dialed by agents. | ||
|- | |- | ||
|'''num_calls_received''' | |'''num_calls_received''' | ||
Line 58: | Line 51: | ||
This included predictive campaign calls. | This included predictive campaign calls. | ||
|- | |- | ||
− | |''' | + | |'''num_campaign_calls''' |
+ | |BIGINT | ||
+ | |Number of campaign calls associated with the given service whose processing ended with the disposition specified in the ''disposition_name'' field | ||
+ | |- | ||
+ | |'''num_non_campaign_calls_inbound''' | ||
+ | |BIGINT | ||
+ | |Number of inbound calls associated with the given service whose processing ended with the disposition specified in the ''disposition_name'' field, excluding predictive campaign calls | ||
+ | |- | ||
+ | |'''num_non_campaign_calls_outbound''' | ||
|BIGINT | |BIGINT | ||
− | | | + | |Number of non-campaign outbound calls associated with the given service whose processing ended with the disposition specified in the ''disposition_name'' field |
− | |||
− | |||
|- | |- | ||
|'''num_preview_items''' | |'''num_preview_items''' | ||
Line 68: | Line 67: | ||
|Number of preview records completed by agents without making a call with the disposition specified in the ''disposition_name'' field | |Number of preview records completed by agents without making a call with the disposition specified in the ''disposition_name'' field | ||
|- | |- | ||
− | |''' | + | |'''num_records_completed''' |
|BIGINT | |BIGINT | ||
− | |Number of | + | |Number of outbound calling records associated with the given service that were completed with the disposition specified in the ''disposition_name'' field |
+ | |- | ||
+ | |'''service_name''' | ||
+ | |VARCHAR | ||
+ | |Name of the service as defined in service configuration | ||
|- | |- | ||
− | |''' | + | |'''start_time''' |
− | + | |DATETIME | |
− | | | + | |Start time of the aggregation interval; time is given in the Universal Coordinated Time (UTC) time zone |
− | | | ||
|- | |- | ||
− | |||
− | |||
− | |||
− | |||
|} | |} | ||
− | + | ||
+ | |||
</translate> | </translate> |
Revision as of 21:05, 7 September 2018
<translate>= disposition_counters= Each row in the disposition_counters table provides metrics for interactions associated with the service specified in the service_name field whose processing ended with a particular disposition.
Description of Data
The following table offers the name (i.e., ID), data type (e.g., BIGINT, BINARY, BIT, DATETIME, ENUM, INT, VARCHAR, etc.), and description for each metric (i.e., column) of the disposition_counters table.
Column Name | Data Type | Description |
agg_run_id | BINARY (16) | Aggregator run that produced this record |
disposition_name | VARCHAR | Disposition name |
end_time | DATETIME | End time of the aggregation interval; time is given in the Universal Coordinated Time (UTC) time zone |
id | BINARY (16) | Primary key |
is_campaign | BIT | Services of blended type will have two rows of metrics: one where this bit is set to TRUE, counting campaign calls only; the other row with this bit set to FALSE, counting inbound and non-campaign outbound calls |
media_type | ENUM | media_type specifies the interaction media type.
Possible values include VOICE, CHAT, and EMAIL. If set to CHAT, any call mentioned in this table shall be interpreted as a service chat interaction in the same context. |
num_calls_outbound | BIGINT | This metric specifies the number of outbound calls associated with the given service whose processing ended with the disposition specified in the disposition_name field.
It includes regular outbound calls and calls of preview campaign calls that were actually dialed by agents. |
num_calls_received | BIGINT | This metric specifies the number of calls associated with the given service received by agents whose processing ended with the disposition specified in the disposition_name field.
This included predictive campaign calls. |
num_campaign_calls | BIGINT | Number of campaign calls associated with the given service whose processing ended with the disposition specified in the disposition_name field |
num_non_campaign_calls_inbound | BIGINT | Number of inbound calls associated with the given service whose processing ended with the disposition specified in the disposition_name field, excluding predictive campaign calls |
num_non_campaign_calls_outbound | BIGINT | Number of non-campaign outbound calls associated with the given service whose processing ended with the disposition specified in the disposition_name field |
num_preview_items | BIGINT | Number of preview records completed by agents without making a call with the disposition specified in the disposition_name field |
num_records_completed | BIGINT | Number of outbound calling records associated with the given service that were completed with the disposition specified in the disposition_name field |
service_name | VARCHAR | Name of the service as defined in service configuration |
start_time | DATETIME | Start time of the aggregation interval; time is given in the Universal Coordinated Time (UTC) time zone |
</translate>