Process finished with exit code 0
get metrics sql===> SELECT [DatasetId], [Id], [Name], [Description] FROM [customreport.General].[system].[T_Reporting_Metric] where datasetId='Chat'
chat_metrics_from_db===> [['The number of chat requests abandoned by visitors before connecting with agents.', 'Abandoned Chats'], ['The number of messages sent by agents on chat.', 'Agent Chat Messages'], ['The response time for an agent to respond to the chat message from the visitor.', 'Agent Response Time'], ['The total number of chats that occurred between visitors and chatbot only.', 'Bot Only Chats'], ['The percentage of the chatbot only chats out of all chats.', '% of Bot Only Chats'], ['The number of chat requests abandoned by visitors before connecting with agents from bot.', 'Bot to Abandoned Chats'], ['The percentage of chat requests accepted by agents out of all chat requests from bot to agent.', '% Bot to Agent Chat Acceptance Rate'], ['The number of chat requests from bot to agent.', 'Bot to Agent Chat Requests'], ['The number of chats from bot to agent.', 'Bot To Agent Chats'], ['The number of chats refused by agents when visitor is escalating from bot to agent.', 'Bot to Agent Refused Chats'], ['The number of chats which is escalating from bot to agent but visitor choose to leave offline message while waiting.', 'Bot to Offline Messages'], ['The number of canned messages sent in a chat.', 'Canned Messages Usage'], ['The percentage of accepted chats out of all chat requests.', '% Chat Acceptance Rate'], ['The number of chat requests waiting in the queue and then be connected to agents.', 'Chats From Queue'], ['The number of chat requests from visitors.', 'Chat Requests'], ['The number of chats.', 'Chats'], ['The number of chats initiated by rule-based auto invitations and accepted by visitors.', 'Chats From Auto Invitation'], ['The number of answered chats initiated by visitors, except for chats from manual invitation or auto invitation.', 'Chats From Chat Button'], ["The number of chats initiated by agents' manual invitations and accepted by visitors.", 'Chats From Manual Invitation'], ['The number of visitors who chatted with your agents.', 'Chatted Visitors'], ['The time of chats from start to end.', 'Chat Time'], ['The number of co-browsing request.', 'Co-browsing Request'], ['The number of co-browsing sessions.', 'Co-browsing Sessions'], ['The time duration of co-browsing sessions.', 'Co-browsing Session Time'], ['The number of chats where the last chat message is sent by the agent.', 'Last Message Sent by Agent Chats'], ['The number of chat requests missed by agents. This metric is the sum of abandoned chats and switched to offline messages.', 'Missed Chats'], ['The number of chat requests waiting in the queue to be connected to agents, abandoned or switched to offline message.', 'Queued Chat Requests'], ['The number of chats rated by visitors.', 'Rated Chats'], ['The percentage of rated chats out of all chats.', '% Rated Chats'], ['The average rating score agents have received from visitors.', 'Rating Score'], ['The number of chat with rating score at 1.', 'Rating Score 1 Chats'], ['The number of chat with rating score at 2.', 'Rating Score 2 Chats'], ['The number of chat with rating score at 3.', 'Rating Score 3 Chats'], ['The number of chat with rating score at 4.', 'Rating Score 4 Chats'], ['The number of chat with rating score at 5.', 'Rating Score 5 Chats'], ['The number of chats refused by agents.', 'Refused Chats'], ['The number of chat requests switched to offline messages by visitors while waiting in the queue.', 'Switch To Offline Messages'], ['The number of messages sent by visitors on chat.', 'Visitor Chat Messages'], ['The time visitors waited in the queue until the chats were answered, abandoned, rejected by agents or switched to offline messages.', 'Wait Time'], ['The time visitors waited in the queue until they abandoned the queue or switched to leaving a message.', 'Wait Time of Missed Chats'], ['The number of chats that have wrap-ups.', 'Wrapped-up Chats'], ["The percentage of chats where agents' wrap-up comments were completed.", '% Wrapped-up Completion Rate']]
chat_metrics_from_excel===> [['The number of chats.', 'Chats'], ['The number of chat requests from visitors.', 'Chat Requests'], ['The number of chats refused by agents.', 'Refused Chats'], ['The number of chat requests missed by agents. This metric is the sum of abandoned chats and switched to offline messages.', 'Missed Chats'], ['The percentage of accepted chats out of all chat requests.', '% Chat Accpetance Rate'], ['The number of chat requests abandoned by visitors before connecting with agents.', 'Abandoned Chats'], ['The number of chat requests switched to offline messages by visitors while waiting in the queue.', 'Switch to Offline Messages'], ['The number of chats refused by agents when visitor is escalating from bot to agent.', 'Bot to Agent Refused Chats'], ['The number of chats which is escalating from bot to agent but visitor choose to leave offline message while waiting.', 'Bot to Offline Messages'], ['The number of chat requests abandoned by visitors before connecting with agents from bot.', 'Bot to Abandoned Chats'], ['The number of chat requests from bot to agent.', 'Bot to Agent Chat Requests'], ['The percentage of chat requests accpeted by agents out of all chat reuqests from bot to agent.', '% Bot to Agent Chat Acceptance Rate'], ['The total number of chats that occurred between visitors and chatbot only.', 'Bot Only Chats'], ['The percentage of the chatbot only chats out all all chats.', '% of Bot Only Chats'], ['The number of chats from bot to agent.', 'Bot to Agent Chats'], ['The time visitors waited in the queue until the chats were answered, abandoned, rejected by agents or switched to offline messages.', 'Wait Time'], ['The time visitors waited in the queue until they abandoned the queue or switched to leaving a message.', 'Wait Time of Missed Chats'], ['The time of chats from start to end.', 'Chat Time'], ['The response time for an agent to respond to the chat message from the visitor.', 'Agent Response Time'], ['The number of canned messages sent in a chat.', 'Canned Messages Usage'], ['The number of messages sent by agents on chat.', 'Agent Chat Messages'], ['The number of messages sent by visitors on chat.', 'Visitor Chat Messages'], ['The number of chats where the last chat message is sent by the agent.', 'Last Message Sent by Agent Chats'], ['The number of chats that have wrap-ups.', 'Wrapped Up Chats'], ['The percentage of chats where agents’ wrap-up comments were completed.', '% Wrap-up Completion Rate'], ['The number of chats rated by visitors.', 'Rated Chats'], ['The number of chat with rating score at 1.', 'Rating Score 1 Chats'], ['The number of chat with rating score at 2.', 'Rating Score 2 Chats'], ['The number of chat with rating score at 3.', 'Rating Score 3 Chats'], ['The number of chat with rating score at 4.', 'Rating Score 4 Chats'], ['The number of chat with rating score at 5.', 'Rating Score 5 Chats'], ['The average rating score agents have received from visitors.', 'Rating Score'], ['The percentage of rated chats out of all chats.', '% Rated Chats'], ['The number of answered chats initiated by visitors, except for chats from manual invitation or auto invitation.', 'Chats from Chat Button'], ['The number of chats initiated by agents’ manual invitations and accepted by visitors.', 'Chats from Manual Invitation'], ['The number of chats initiated by rule-based auto invitations and accepted by visitors.', 'Chats from Auto Invitation'], ['The number of chats transferred to other departments, agents or sites.', 'Transferred Chats'], ['The number of chats transferred from one department to another.', 'Inter-Department Transferred Chats'], ['The number of co-browsing request.', 'Co-browisng Request'], ['The number of co-browsing sessions.', 'Co-browisng Sessions'], ['The time duration of co-browsing sessions.', 'Co-browsing Session Time'], ['The number of chat requests waiting in the queue to be connected to agents, abandoned or switched to offline message.', 'Queued Chat Requests'], ['The number of chat requests waiting in the queue and then be connected to agents.', 'Chats from Queue'], ['The number of visitors who chatted with your agents.', 'Chatted Visitors']]
exception===> The percentage of accepted chats out of all chat requests. 或者 % Chat Accpetance Rate doesn't exists in expected db, metrics is % Chat Accpetance Rate,index is 4
The percentage of accepted chats out of all chat requests. % Chat Acceptance Rate
assert False
exception===> The number of chat requests switched to offline messages by visitors while waiting in the queue. 或者 Switch to Offline Messages doesn't exists in expected db, metrics is Switch to Offline Messages,index is 6
The number of chat requests switched to offline messages by visitors while waiting in the queue. Switch To Offline Messages (**)
assert False
exception===> The percentage of chat requests accpeted by agents out of all chat reuqests from bot to agent. 或者 % Bot to Agent Chat Acceptance Rate doesn't exists in expected db, metrics is % Bot to Agent Chat Acceptance Rate,index is 11
The percentage of chat requests accepted by agents out of all chat requests from bot to agent. % Bot to Agent Chat Acceptance Rate (***)
assert False
exception===> The percentage of the chatbot only chats out all all chats. 或者 % of Bot Only Chats doesn't exists in expected db, metrics is % of Bot Only Chats,index is 13
assert False 文档拼写错误
exception===> The number of chats from bot to agent. 或者 Bot to Agent Chats doesn't exists in expected db, metrics is Bot to Agent Chats,index is 14
Bot To Agent Chats (**)
assert False
exception===> The number of chats that have wrap-ups. 或者 Wrapped Up Chats doesn't exists in expected db, metrics is Wrapped Up Chats,index is 23
Wrapped-up Chats
assert False
exception===> The percentage of chats where agents’ wrap-up comments were completed. 或者 % Wrap-up Completion Rate doesn't exists in expected db, metrics is % Wrap-up Completion Rate,index is 24
The percentage of chats where agents' wrap-up comments were completed. % Wrapped-up Completion Rate
assert False
exception===> The number of answered chats initiated by visitors, except for chats from manual invitation or auto invitation. 或者 Chats from Chat Button doesn't exists in expected db, metrics is Chats from Chat Button,index is 33
The number of answered chats initiated by visitors, except for chats from manual invitation or auto invitation. Chats From Chat Button
assert False
exception===> The number of chats initiated by agents’ manual invitations and accepted by visitors. 或者 Chats from Manual Invitation doesn't exists in expected db, metrics is Chats from Manual Invitation,index is 34
The number of chats initiated by agents' manual invitations and accepted by visitors. Chats From Manual Invitation
assert False
exception===> The number of chats initiated by rule-based auto invitations and accepted by visitors. 或者 Chats from Auto Invitation doesn't exists in expected db, metrics is Chats from Auto Invitation,index is 35
The number of chats initiated by rule-based auto invitations and accepted by visitors. Chats From Auto Invitation
assert False
exception===> The number of chats transferred to other departments, agents or sites. 或者 Transferred Chats doesn't exists in expected db, metrics is Transferred Chats,index is 36
assert False
exception===> The number of chats transferred from one department to another. 或者 Inter-Department Transferred Chats doesn't exists in expected db, metrics is Inter-Department Transferred Chats,index is 37
assert False
exception===> The number of co-browsing request. 或者 Co-browisng Request doesn't exists in expected db, metrics is Co-browisng Request,index is 38
The number of co-browsing request. Co-browsing Request
assert False 文档拼写错误
exception===> The number of co-browsing sessions. 或者 Co-browisng Sessions doesn't exists in expected db, metrics is Co-browisng Sessions,index is 39
assert False 文档拼写错误
exception===> The number of chat requests waiting in the queue and then be connected to agents. 或者 Chats from Queue doesn't exists in expected db, metrics is Chats from Queue,index is 42
assert False The number of chat requests waiting in the queue and then be connected to agents. Chats From Queue
PASSEDget metrics sql===> SELECT [DatasetId], [Id], [Name], [Description] FROM [customreport.General].[system].[T_Reporting_Metric] where datasetId='OfflineMessage'
offlineMessage_metrics_from_db===> [['The number of offline messages.', 'Offline Messages'], ['The number of offline messages from the offline auto invitation.', 'Offline Messages from Auto Invitation'], ['The number of offline messages left during the Chatbot chats when visitors switch to an agent while no agents were online.', 'Offline Messages from Chatbot'], ['The number of offline messages from the offline chat queue.', 'Offline Messages from Chat Queue'], ['The number of offline messages from the offline chat button.', 'Offline Messages from Offline Button']]
offlineMessage_metrics_from_excel===> [['The number of offline messages', 'Offline Messages'], ['The number of offline messages from the offline chat button', 'Offline Messages from Offline Button'], ['The number of offline messages from the offline chat queue', 'Offline Messages from Chat Queue'], ['The number of offline messages left during the Chatbot chats when visitors switch to an agent while no agents were online.', 'Offline Message from Chatbot'], ['The number of offline messages from the offline auto invitation', 'Offline Message from Auto Invitation']]
exception===> The number of offline messages 或者 Offline Messages doesn't exists in expected db, metrics is Offline Messages,index is 0
The number of offline messages.
assert False
exception===> The number of offline messages from the offline chat button 或者 Offline Messages from Offline Button doesn't exists in expected db, metrics is Offline Messages from Offline Button,index is 1
The number of offline messages from the offline chat button.
assert False
exception===> The number of offline messages from the offline chat queue 或者 Offline Messages from Chat Queue doesn't exists in expected db, metrics is Offline Messages from Chat Queue,index is 2
The number of offline messages from the offline chat queue.
assert False
exception===> The number of offline messages left during the Chatbot chats when visitors switch to an agent while no agents were online. 或者 Offline Message from Chatbot doesn't exists in expected db, metrics is Offline Message from Chatbot,index is 3
The number of offline messages left during the Chatbot chats when visitors switch to an agent while no agents were online.
assert False
exception===> The number of offline messages from the offline auto invitation 或者 Offline Message from Auto Invitation doesn't exists in expected db, metrics is Offline Message from Auto Invitation,index is 4
assert False Offline Messages from Auto Invitation
PASSEDget metrics sql===> SELECT [DatasetId], [Id], [Name], [Description] FROM [customreport.General].[system].[T_Reporting_Metric] where datasetId='Visit'
offlineMessage_metrics_from_db===> [['The number of visits.', 'Visits']]
offlineMessage_metrics_from_excel===> [['The number of visits.', 'Visits']]
exception===> The number of visits. 或者 Visits doesn't exists in expected db, metrics is Visits,index is 0
assert False
PASSEDget metrics sql===> SELECT [DatasetId], [Id], [Name], [Description] FROM [customreport.General].[system].[T_Reporting_Metric] where datasetId='Queue'
offlineMessage_metrics_from_db===> [['The number of chat requests in queue over a given time range.', 'Queue Size']]
offlineMessage_metrics_from_excel===> [['The number of chat requests in queue over a given time range.', 'Queue Size']]
PASSEDget metrics sql===> SELECT [DatasetId], [Id], [Name], [Description] FROM [customreport.General].[system].[T_Reporting_Metric] where datasetId='AutoInvitation'
offlineMessage_metrics_from_db===> [['The number of auto invitations accepted by visitors.', 'Auto Invitation Accepted'], ['The number of auto invitations accepted by visitors out of all auto invitations sent.', '% Auto Invitation Accepted Rate'], ['The number of auto invitations sent to visitors.', 'Auto Invitation Sent']]
offlineMessage_metrics_from_excel===> [['The number of auto invitations sent to visitors.', 'Auto Invitation Sent'], ['The number of auto invitations accepted by visitors.', 'Auto Invitation Accepted']]
PASSED