This report displays incoming emails and their values for each incoming mailbox. The report is structured in the style of the itemized bill of lading.
This report is optimised for the following output formats:
The following columns are provided.
Table | Alias |
|---|---|
StatisticsPartA (See also Table Reference - StatisticsPartA (A) ) | a |
AcdStatisticsPartB (See also Table Reference - AcdStatisticsPartB (AcdB) ) | acdb |
| StatisticsPartB (See also Table Reference - StatisticsPartB (B) ) | b |
| AcdStatisticsLogin (See also Table Reference - AcdStatisticsLogin) | login |
| Name | Description | Criteria Used |
|---|---|---|
| Inboxes | Name of the incoming mailbox | |
Sender (AcdGetItemisedEmailSender_Event) | Senders E-mail address for the event | AcdEvents.Sender ( _OldAcdEventStatusID = 0 ) AND ( _NewAcdEventStatusID = 4 ) See also Value Reference - AcdEventStatus |
Qualification Time (AcdGetItemisedEmailQualificated_EventHistory) | Time at which the event was qualified by the system and is ready for distribution to the appropriate ACD group | AcdEventHistory.dtCreated ( _OldAcdEventStatusID = 0 ) AND ( _NewAcdEventStatusID = 4 ) See also Value Reference - AcdEventStatus |
| ACD Group | ACD group to which the event was sent (inbox setting) | |
Agent (AcdGetItemisedEmailAgentName_EventGroup) | Agent name and number | CONCAT (Users.Name, Users.FirstName, Users.AgentNumber) ( AcdEventHistory.OldAcdEventStatusID = 1 ) See also Value Reference - AcdEventStatus |
Qualification Algorithm | Qualification algorithm used (Inbox Setting) | |
| Other | Errors or other occurrences are noted here | AcdGetItemisedEmailOther_Event |
| Incoming Inbox | Time at which the event was received in the inbox | AcdGetItemisedEmailReceived_Event |
| Incoming ACD group | Time at which the event was received in the ACD group after it was qualified and distributed by the Inbox | AcdGetItemisedEmailAcdGroupReceived_EventGroup |
| Agent Delivered | Time at which the event was distributed to an agent | AcdGetItemisedEmailAgentDelivered_Event |
| Agent Answered | Time at which the agent sent a response to the event | AcdGetItemisedEmailAgentAnswered_EventGroup |
| File Reference | Name of the email file located in the data directory | AcdGetItemisedEmailFileReference_Event |
| Transferred Agent Time | Time at which the agent forwarded the event, followed by the agent to which the event was forwarded | dtAgentTransferred |
| Transferred Agent | Agent which the email was transferred to | AcdGetItemisedEmailAgentTransferred_EventGroup |
| Transferred Group Time | Time at which the agent forwarded the event, followed by the group to which the event was forwarded | dtGroupTransferred |
| Transferred Group | Group which the email was transferred to | AcdGetItemisedEmailGroupTransferred_EventGroup |