Description
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.
Sample Execution (Input) → Sample Report (Output)
This report is optimised for the following output formats: PDFHTML
Column
The following columns are provided.
Legend
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 |