提供: Bright Pattern Documentation
移動先: 案内検索
(Created page with "特定のメトリックに関して特に注記がない限り、以下に記載されている''call''は、''skill_name''フィールドで指定されたスキルを要求...")
(Created page with "== データの説明 == 次の表には、名前(IDなど)、データタイプ (BIGINT, BINARY, BIT, DATETIME, ENUM, INT, VARCHARなど)、 ''requested_skills'' 表の...")
Line 5: Line 5:
  
  
== 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 ''requested_skills'' table.
+
次の表には、名前(IDなど)、データタイプ (BIGINT, BINARY, BIT, DATETIME, ENUM, INT, VARCHARなど)、  ''requested_skills'' 表の各メトリック(つまり、列)の説明が含まれます。
  
  

Revision as of 15:14, 15 September 2019

• English
• 5.19 • 5.3 • 5.8

requested_skills

requested_skills表には、 特定のスキルを要求した対話のメトリックが含まれています。

特定のメトリックに関して特に注記がない限り、以下に記載されているcallは、skill_nameフィールドで指定されたスキルを要求したコールとして見なされます。


データの説明

次の表には、名前(IDなど)、データタイプ (BIGINT, BINARY, BIT, DATETIME, ENUM, INT, VARCHARなど)、 requested_skills 表の各メトリック(つまり、列)の説明が含まれます。


Column Name Data Type Description
id BINARY (16) Primary key
start_time DATETIME Start time of the aggregation interval; time is given in Universal Coordinated Time (UTC)
end_time DATETIME End time of the aggregation interval; time is given in Universal Coordinated Time (UTC)
agg_run_id BINARY (16) Aggregator run that produced this record
media_type ENUM This is 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.

skill_name VARCHAR Skill name as defined in configuration
skill_group_name VARCHAR Name of the skill group that the skill belongs to as defined in configuration
skill_type ENUM This is the skill type.

Possible values include the following:

  • SERVICE – Primary service skill (a skill that is created automatically for each new service)
  • SKILL – Auxiliary skill (a skill that is not directly associated with any particular service)
total_answer_time BIGINT Total answer time (the sum of times between the moments the calls entered queue and were answered by agents)
num_calls_received BIGINT Total number of received calls
num_calls_queued BIGINT Number of calls that were queued
num_calls_answered BIGINT Number of calls that were answered
num_calls_overflow BIGINT Number of calls that were distributed to overflow destinations
< 前へ | 次へ >