• English

• 5.19 • 5.3 • 5.8

agent_activity

agent_activity表の各行には、一つのエージェントアクティビティに関連する一連のデータが含まれています。対話処理に関わるアクティビティの場合、このデータには、エージェントの通話時間や保留時間などのいくつかの基本的な集計データが含まれます。複数の集約間隔に入ってしまう一つのエージェントアクティビティは、これらの集約間隔ごとに個別に報告され、時間に関連するすべてのメトリックは、指定された間隔内の時間のみをカウントします。レポートを生成する際に、 activity_id フィールドを使って、複数の間隔に入ってしまうアクティビティの時間関連メトリックを組み合わせることができます。

特定のメトリックに関して特に注記がない限り、この表に記載されているコールは、特定のアクティビティ中にlogin_id フィールドで識別されるエージェントによって処理されたコールとして見なされます。

データの説明

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

列名	データタイプ	内容
アクティビティ	ENUM	アクティビティ はアクティビティタイプを意味します。 設定可能な値には、 INBOUND_CALL, LOGIN, LOGOUT, OUTBOUND_CALL, NOT_READY, PREVIEW, READY, SUPERVISIONが含まれます。 Note the following: Handling of both preview and predictive campaign calls is reported as activity OUTBOUND_CALL. Only the record preview phase (time before dialing begins) is reported as PREVIEW activity for agents participating in preview campaigns. Time spent doing after-call work is reported as part of INBOUND_CALL and OUTBOUND_CALL activities. Internal calls received by the agent are reported as activity INBOUND_CALL. Internal calls made by the agent are reported as activity OUTBOUND_CALL. The Supervisor state of "Supervising" in the Agent Desktop is reported as activity SUPERVISION. Value of the other_party_phone_type field can be used to distinguish between service and internal calls. Handling of a service chat is reported as activity INBOUND_CALL. Handling of an inbound email is reported as activity INBOUND_CALL. Handling of a follow-up or unsolicited email is reported as activity OUTBOUND_CALL. The value of the media_type and/or service_name field can be used to distinguish between interactions of different media types.
activity_id	BINARY (16)	activity_id is the unique identifier assigned to the activity. If a single activity lasts through several adjacent aggregation intervals, it will have the same value of activity_id in each of those intervals.
acw_time	BIGINT	After-call work time for activity types INBOUND_CALL and OUTBOUND_CALL within the aggregation interval
agent_disposition_code	INT	For activity types INBOUND_CALL and OUTBOUND_CALL, the numerical code (if defined) of the disposition that the agent assigned to the call
agent_disposition_name	VARCHAR	For activity types INBOUND_CALL and OUTBOUND_CALL, the name of the disposition that the agent assigned to the call
agent_disposition_notes	LONGTEXT	For activity types INBOUND_CALL and OUTBOUND_CALL, the text notes that the agent wrote regarding the call
agg_run_id	BINARY (16)	Aggregator run that produced this record
call_detail_id	BINARY	Reference to the record in the call_detail table created for the interaction handled by the agent during this activity
case_number	VARCHAR	For activity types INBOUND_CALL and OUTBOUND_CALL, number of the case with which this interaction is associated; applies to emails only
destination_number	VARCHAR	For activity types INBOUND_CALL and OUTBOUND_CALL, the phone number dialed by the party that initiated the call.
detail	VARCHAR	For activity type NOT_READY, detail specifies the Not Ready reason. For activity type OUTBOUND_CALL, detail specifies the login ID of the called party if the call was made internally and was answered.
disposition	ENUM	For activity types INBOUND_CALL and OUTBOUND_CALL, disposition specifies how the call-handling activity ended. The term call in the following descriptions indicates that the given value may be applicable to calls and chats. Possible values include the following: CALLER_TERMINATED – Call terminated by the party that made the call CALLEE_TERMINATED – Call terminated by the party that answered the call REJECTED – Agent rejected the incoming call ABANDONED – For inbound calls, abandoned by the remote party while ringing at the agent desktop; for outbound calls, terminated by the agent before it was answered by the remote party TRANSFERRED – Agent transferred the interaction CONFERENCED – Call became a conference (the conference phase is reported a separate activity) SYSTEM_DISCONNECTED – Call was disconnected by the system CALLER_TRANSFERRED – Remote party transferred the call (i.e., this agent stayed on the call but with another party); the after-transfer part of the call will be reported as the next activity NO_ANSWER – Agent did not accept an incoming interaction REPLIED – Agent replied to the email; applies to inbound emails only CLOSED – Agent finished processing of the email without a reply (e.g., the email was a spam or no follow-up was necessary); applies to inbound emails only SERVICE_CHANGED – Agent changed the service associated with the email and continued processing it (the after-service-change phase is reported as the next activity) SAVED – Agent saved an email draft SENT – Agent sent the email; applies to outbound emails only DISCARDED – Agent discarded an email draft; applies to outbound emails only
duration	BIGINT	Activity duration within the aggregation interval.
email_completion_time	BIGINT	Email completion time from the moment the email interaction was accepted by the agent or entered his personal queue and until it was completed (including ACW if any) or transferred
held	BIGINT	The number of times the agent placed the call on hold during this activity; for emails and chats, the number of times the agent had the interaction out of focus during this activity)
max_hold	BIGINT	The duration of the longest of the number of times the agent placed the call on hold during this activity; for emails and chats, duration of the longest of the number of times the agent had the interaction out of focus during this activity
external_number	VARCHAR	For activity type INBOUND_CALL, external_number is the access number through which the inbound call entered the system. For activity type OUTBOUND_CALL, external_number is the Caller ID assigned to the outbound call.
first_name	VARCHAR	Agent first name as defined in configuration
has_screen_recording	BIT	Indication of whether agent's screen was recorded during this activity
hold_time	BIGINT	Total hold time for activity types INBOUND_CALL and OUTBOUND_CALL within the aggregation interval
id	BINARY (16)	Reserved
last_name	VARCHAR	Agent last name as defined in configuration
login_id	VARCHAR	Agent login as defined in configuration
media_type	ENUM	For activity types INBOUND_CALL and OUTBOUND_CALL, this is the media type of the interaction that the agent handled during this activity. Possible values include VOICE, CHAT, and EMAIL.
origination_number	VARCHAR	For activity types INBOUND_CALL and OUTBOUND_CALL, the phone number from which the call was made.
other_party_phone_type	ENUM	For activity types INBOUND_CALL and OUTBOUND_CALL, other_party_phone_type specifies the location of the remote party on the call. Possible values include INTERNAL and EXTERNAL.
pending_time	BIGINT	For activity type INBOUND_CALL, pending_time specifies the duration of the call ringing phase from the moment the call was distributed to this agent and until it was either answered or abandoned. For activity type OUTBOUND_CALL, pending_time specifies the duration of the call dialing phase from the moment the number dialed by the agent was received by the system and until the call was either answered or abandoned.
pkid	INT	Primary key
rank	VARCHAR	Agent rank as defined in configuration
service_name	VARCHAR	For activity types INBOUND_CALL and OUTBOUND_CALL, service_name is the name of the service associated with the call. It is not specified for internal calls. For services of media type chat, any call mentioned in this table shall be interpreted as a service chat interaction in the same context.
session_id	BINARY	session_id is the agent login session identifier. A new identifier is assigned to each new LOGIN activity. The same identifier is assigned to the corresponding LOGOUT and all READY and NOT_READY activities that happened in between.
start_time	DATETIME	Activity start time; time is given in Coordinated Universal Time (UTC)
talk_time	BIGINT	talk_time is the total talk time for activity types INBOUND_CALL and OUTBOUND_CALL within the aggregation interval. It does not include hold times.
team_name	VARCHAR	Name of the team that the agent is assigned to as defined in configuration
workitem_id	VARCHAR	Identifier of the outbound work item associated with this activity.\
agent_country	VARCHAR	Agent country as defined in User configuration
agent_city	VARCHAR	Agent city as defined in User configuration

< 前へ | 次へ >