提供: Bright Pattern Documentation
< 5.19:Reporting-database-specification‎ | requested skills
Revision as of 15:14, 15 September 2019 by Marina (talk | contribs) (Created page with "== データの説明 == 次の表には、名前(IDなど)、データタイプ (BIGINT, BINARY, BIT, DATETIME, ENUM, INT, VARCHARなど)、 ''requested_skills'' 表の...")
移動先: 案内検索
• 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
< 前へ | 次へ >