V3 Default Reports



In this section you'll find the list of the Reports immediately available when you install XCALLY Motion.
















These Default Reports can be used as they are or copied in the Custom Report area and properly modified according your organization needs.



Anytime you install a new XCALLY Motion server from scratch you'll find these reports in the Motion Reports folder, and a copy of them is also saved in the Custom Reports area, for being viewed and changed by you.


Eventually, if we from time to time issue new reports in a newer version of XCALLY Motion, the update process will not copy them in the Custom area, but just in the Motion Reports area: you can do it yourself anytime using the Copy command.





Voice Reports

In this section you find the Reports useful to monitor the voice channel performance.

Queues

The Queues general reports are:

idnamedescriptionparenttablejoinsresults
1DetailsDetailed queues reportmotion_voice_queuesreport_queue
UniqueId
CallerIdNum
CallerIdName
Queue
QueueJoinAt
QueueLeaveAt
QueueAbandon
QueueAbandonAt
Complete
CompleteAt
QueueExit
QueueExitAt
QueueExitReason
DID
TalkTime
AbandonTime
AnswerTime
2Calls ResultSimple queue calls overviewmotion_voice_queuesreport_queue
CallerID
Queue
StartTime
EndTime
HoldTime
Answered
17SummaryCalls distribution by queuemotion_voice_queuesreport_queue
Queue
Offered
Answered
Answer Rate
Abandoned
Unmanaged
Tot TalkTime
AvgTalkTime
AvgAbandonTime

Then we have the following other reports grouped by the context of the queue calls management.

Answered

idnamedescriptionparenttablejoinsresults
3DetailsDetailed report about answered queue callsmotion_voice_queues_answeredreport_agent
UniqueId
CallerIdNum
CallerIdName
Queue
Agent
AgentCalledAt
AgentConnectAt
AgentCompleteAt
AnswerTime
TalkTime
AgentACW
AgentACWTime
AgentComplete
HangupReason
LastEvent
DID
4Calls by AgentAgent calls timer Handle time= talk time + ACW timemotion_voice_queues_answeredreport_agent
Agent
Completed
TotTalkTime
TotACWTime
TotHandleTime
AvgTalkTime
AvgACWTime
AvgHandleTime
5Calls by QueueQueue timer Handle Time= Talk Time + AVG TImemotion_voice_queues_answeredreport_agent
Queue
Completed
Tot TalkTime
Tot HoldTime
Tot ACWTime
Tot Handle Time
Avg TalkTime
Avg HoldTime
Avg ACWTime
Avg Handle Time
6Answer Time by QueueQueues answer time performancemotion_voice_queues_answeredreport_agent
Queue
Tot Answered
Answered <10s
Answer Rate <10s
Answered 10-20s
Answer Rate 10-20s
Answered 20-30s
Answer Rate 20-30s
Answered >30s
Answer Rate >30s
7Disconnection CauseSummary of the calls disconnection causesmotion_voice_queues_answeredreport_agent
Reason
Calls
8Answer Time by HourAnswer time  by hourmotion_voice_queues_answeredreport_agent
Hour
Tot Answered
Answered <10s
Answered 10-20s
Answered 20-30s
Answered >30s

Unanswered

idnamedescriptionparenttablejoinsresults
9DetailsDetailed report about the unanswered callsmotion_voice_queues_unansweredreport_queue
UniqueId
CallerIdNum
Queue
JoinAt
LeaveAt
Abandon
AbandonAt
Unmanaged
UnmanagedAt
UnmanagedReason
QueuePosition
DID
Abandon Time
Unmanaged HoldTime
10Unanswered by QueueUnanswered calls summary by queuemotion_voice_queues_unansweredreport_queue
Queue
Abandoned
Unmanaged
Tot AbandonTime
AvgAbandonTime
Tot Unmanaged Time
Avg Unmanaged TIme
11Unmanaged callsUnmanaged calls summarymotion_voice_queues_unansweredreport_queue
Reason
Calls
Tot Unmanaged Time
12Abandon Time by QueueAbandon time performance by queuemotion_voice_queues_unansweredreport_queue
Queue
Tot Abandoned
Abandoned<10s
Abandoned Rate<10s
Abandoned 10-60s
Abandoned Rate 10-60s
Abandoned 60-120s
Abandoned Rate 60-120s
Abandoned>120s
Abandoned Rate>120s

Distribution

idnamedescriptionparenttablejoinsresults
13Calls by DateQueue calls summary by datemotion_voice_queues_distributionreport_queue
Date
Offered
Completed
Abandoned
Unmanaged
Tot TalkTime
AvgTalkTime
AvgAbandonTime
14Calls by HourCalls distribution by hourmotion_voice_queues_distributionreport_queue
Hour
Offered
Answered
Answer Rate
Abandoned
Unmanaged
Tot TalkTime
AvgTalkTime
AvgAbandonTime
15Calls by DayCalls distribution by day of the monthmotion_voice_queues_distributionreport_queue
Day
Offered
Answered
Answer Rate
Abandoned
Unmanaged
Tot TalkTime
AvgTalkTime
AvgAbandonTime
16Calls by WeekdayCalls distribution by day of the weekmotion_voice_queues_distributionreport_queue
DayOfWeek
Offered
Answered
Answer Rate
Abandoned
Unmanaged
Tot TalkTime
AvgTalkTime
AvgAbandonTime


Calls

idnamedescriptionparenttablejoinsresults
18DetailsCalls detail (cdr)motion_voice_callsreport_call
UniqueID
Type
Tag
Source
Destination
CallerID
DestChannel
LastApp
LastData
StartTime
AnswerTime
EndTime
Duration
Disposition
19OutboundManual outbound calls detailed reportmotion_voice_callsreport_call
UniqueID
AgentExtension
Source
Destination
CallerId
StartTime
AnswerTime
EndTime
Duration
Billsec
Disposition
Tag
20Calls by TypeSummary report of the calls typemotion_voice_callsreport_call
Type
Calls
Tot Duration
Avg Duration
21Outbound Calls DispositionOutbound calls grouped by dispositionmotion_voice_callsreport_call
Disposition
Calls
Tot Duration
Avg Duration
22Outbound Calls by AgentSummary of outbound calls grouped by agentmotion_voice_callsreport_call
Agent
Calls
Tot Duration
Avg Duration
23Outbound Calls by DateSummary of outbound calls grouped by datemotion_voice_callsreport_call
Date
Calls
Tot Duration
Avg Duration


Agents

idnamedescriptionparenttablejoinsresults
25Activities SummaryAgent's activities reportmotion_voice_agentsreport_member
Agent
Login Time
Talk Time
Pause Time
26Pause DetailsAgents status detailsmotion_voice_agentsreport_member
Agent
EnterAt
ExitAt
Pause
Duration
27DetailsAgent's status detailmotion_voice_agentsreport_member
Agent
Interface
Event
Type
EnterAt
ExitAt
Duration
28Pause TimeAgent's pause timemotion_voice_agentsreport_member
Agent
PauseType
Duration


Cally Square

idnamedescriptionparenttablejoinsresults
29SummaryCallySquare Summarymotion_voice_callysquarereport_square
Project Name
UniqueId
CallerId
DID
Start Time
End Time
Duration
30BlocksCallySquare Blocks Detailmotion_voice_callysquarereport_square_details


Unique Id
Project Name
Caller Id
Block
Data


Recordings

idnamedescriptionparenttablejoinsresults
31Rating by AgentRecords rating by agentmotion_voice_recordingsvoice_recordings
Agent
Recorded Calls
Total Rating
Avg Rating
32Rating by QueueRecords rating by queuemotion_voice_recordingsvoice_recordings
Queue
Rated Calls
Total Rating
Avg Rating



Motion Bull

Queue Campaigns

idnamedescriptionparenttablejoinsresults
33Details
motion_bull_queue_campaignscm_hopper_final
Campaign Name
CallerIdNum
LastCallAt
State
Global Count
Drop Reason
BlackList
Agent
Talk Time
Disposition
UniqueId
34Calls Summary
motion_bull_queue_campaignscm_hopper_history
State
Calls
Calls (%)
35Campaign Calls
motion_bull_queue_campaignscm_hopper_final
Campaign Name
State
Total Calls
36List Penetration Rate
motion_bull_queue_campaignscm_hopper_final
ListId
Contacts
Managed
Penetration Rate
37Agent Calls
motion_bull_queue_campaignscm_hopper_final
Agent
Calls
AVG Talk Time
38Disposition Rate
motion_bull_queue_campaignscm_hopper_final
Disposition
Total
Total (%)
39Agent Disposition Rate
motion_bull_queue_campaignscm_hopper_final
Agent
Disposition
Total
Total (%)


IVR Campaigns

idnamedescriptionparenttablejoinsresults
40Details
motion_bull_ivr_campaignscm_hopper_final
Campaign Name
CallerIdNum
LastCallAt
State
Global Count
Drop Reason
BlackList
Agent
Talk Time
UniqueId
41Calls Summary
motion_bull_ivr_campaignscm_hopper_history
State
Calls
Calls (%)
42Campaign Calls
motion_bull_ivr_campaignscm_hopper_final
Campaign Name
State
Total Calls
43List Penetration Rate
motion_bull_ivr_campaignscm_hopper_final
ListId
Contacts
Managed
Penetration Rate



Chat

idnamedescriptionparenttablejoinsresults
44Website SummaryChat interactions by websitemotion_chatchat_interactionschat_websitesWeb Site
Interactions
Open
Closed
Unmanaged
Abandoned
45Website TimesChat interaction times by websitemotion_chatchat_interactionschat_websitesWeb Site
Interaction Time
AVG Interaction Time
46Chat By AgentChat interactions by agentmotion_chatchat_interactionsusersAgent
Closed
Interaction Time
AVG Interaction Time
47Chat By DateChat interactions by datemotion_chatchat_interactions
Date
Interactions
Completed
Completed (%)
Unmanaged
Unmanaged (%)
Abandoned
Abandoned (%)
Interaction Time
AVG Interaction Time
48Chat By QueueChat interactions by queuemotion_chatreport_chat_queuechat_queuesQueue
Interactions
Accepted
Timeout
Hold Time
AVG Hold Time



Email

idnamedescriptionparenttablejoinsresults
49Email Account SummaryEmail interactions by accountmotion_mailmail_interactionsmail_accountsEmail Account
Interactions
Open
Closed
50Email Account TimesEmail interaction times by accountmotion_mailmail_interactionsmail_accountsEmail Account
Interaction Time
AVG Interaction Time
51Email By AgentEmail interactions by agentmotion_mailmail_interactionsusersAgent
Closed
Interaction Time
AVG Interaction Time
52Email By DateEmail interactions by datemotion_mailmail_interactions
Date
Interactions
Completed
Completed (%)
Interaction Time
AVG Interaction Time
53Email By QueueEmail interactions by queuemotion_mailreport_mail_queue

mail_queues

Queue
Interactions
Accepted
Timeout
Hold Time
AVG Hold Time



Openchannel

idnamedescriptionparenttablejoinsresults
54Openchannel Account SummaryOpenchannel interactions by accountmotion_openchannelopenchannel_interactionsopenchannel_accountsOpenchannel Account
Interactions
Open
Closed
55Openchannel Account TimesOpenchannel interaction times by accountmotion_openchannelopenchannel_interactionsopenchannel_accountsOpenchannel Account
Interaction Time
AVG Interaction Time
56Openchannel By AgentOpenchannel interactions by agentmotion_openchannelopenchannel_interactionsusersAgent
Closed
Interaction Time
AVG Interaction Time
57Openchannel By DateOpenchannel interactions by datemotion_openchannelopenchannel_interactions
Date
Interactions
Completed
Completed (%)
Interaction Time
AVG Interaction Time
58Openchannel By QueueOpenchannel interactions by queuemotion_openchannelreport_openchannel_queueopenchannel_queuesQueue
Interactions
Accepted
Timeout
Hold Time
AVG Hold Time



SMS

idnamedescriptionparenttablejoinsresults
59Sms Account SummarySms interactions by accountmotion_smssms_interactionssms_accountsSMS
Interactions
Open
Closed
60Sms Account TimesSms interaction times by accountmotion_smssms_interactionssms_accountsSMS Account
Interaction Time
AVG Interaction Time
61Sms By AgentSms interactions by agentmotion_smssms_interactionsusers

Agent
Closed
Interaction Time
AVG Interaction Time

62Sms By DateSms interactions by datemotion_smssms_interactions
Date
Interactions
Completed
Completed (%)
Interaction Time
AVG Interaction Time
63Sms By QueueSms interactions by queuemotion_smsreport_sms_queuesms_queuesQueue
Interactions
Accepted
Timeout
Hold Time
AVG Hold Time



FAX

idnamedescriptionparenttablejoinsresults
64Fax Account SummaryFax interactions by accountmotion_faxfax_interactionsfax_accountsFAX Accounts
Interactions
Open
Closed
65Fax Account TimesFax interaction times by accountmotion_faxfax_interactions

fax_accounts

FAX Account
Interaction Time
AVG Interaction Time
66Fax By AgentFax interactions by agentmotion_faxfax_interactionsusers

Agent
Closed
Interaction Time
AVG Interaction Time

67Fax By DateFax interactions by datemotion_faxfax_interactions
Date
Interactions
Completed
Completed (%)
Interaction Time
AVG Interaction Time
68Fax By QueueFax interactions by queuemotion_faxreport_fax_queuefax_queuesQueue
Interactions
Accepted
Timeout
Hold Time
AVG Hold Time


WhatsApp Connectors

idnamedescriptionparenttablejoinsresults
64WhatsApp Account SummaryWhatsapp interactions by accountmotion_whatsappwhatsapp_interactionswhatsapp_accountsWhatsApp Accounts
Interactions
Open
Closed
65WhatsApp Account TimesWhatsapp interaction times by accountmotion_whatsappfwhatsapp_interactions

whatsapp_accounts

WhatsApp Account
Interaction Time
AVG Interaction Time
66WhatsApp By AgentWhatsapp interactions by agentmotion_whatsappwhatsapp_interactionsusers

Agent
Closed
Interaction Time
AVG Interaction Time

67WhatsApp By DateWhatsapp interactions by datemotion_whatsappwhatsapp_interactions
Date
Interactions
Completed
Completed (%)
Interaction Time
AVG Interaction Time
68WhatsApp By QueueWhatsapp interactions by queuemotion_whatsappreport_whatsapp_queuewhatsapp_queuesQueue
Interactions
Accepted
Timeout
Hold Time
AVG Hold Time



Agents

idnamedescriptionparenttablejoinsresults
24Login TimeAgent's login timemotion_agentsreport_member
Agent
Duration