提供: Bright Pattern Documentation
(Created page with "= disposition_counters= ''disposition_counters''表の各行には、''service_name''フィールドで指定されたサービスに関連し特定の対話結果で終了し...") |
(Created page with "== データの説明 == 次の表には、名前（IDなど）、データタイプ (BIGINT, BINARY, BIT, DATETIME, ENUM, INT, VARCHARなど)、 ''disposition_counters'' 表...") |
||
| Line 2: | Line 2: | ||
''disposition_counters''表の各行には、''service_name''フィールドで指定されたサービスに関連し特定の対話結果で終了した対話のメトリックが 含まれます。 | ''disposition_counters''表の各行には、''service_name''フィールドで指定されたサービスに関連し特定の対話結果で終了した対話のメトリックが 含まれます。 | ||
| − | == | + | == データの説明 == |
| − | + | 次の表には、名前（IDなど）、データタイプ (BIGINT, BINARY, BIT, DATETIME, ENUM, INT, VARCHARなど)、 ''disposition_counters'' 表の各メトリック（つまり、列）の説明が含まれます。 | |
Revision as of 06:53, 13 September 2019
• English
disposition_counters
disposition_counters表の各行には、service_nameフィールドで指定されたサービスに関連し特定の対話結果で終了した対話のメトリックが 含まれます。
データの説明
次の表には、名前（IDなど）、データタイプ (BIGINT, BINARY, BIT, DATETIME, ENUM, INT, VARCHARなど)、 disposition_counters 表の各メトリック（つまり、列）の説明が含まれます。
| 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 Universal Coordinated Time (UTC) |
| 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 Universal Coordinated Time (UTC) |