What's new in Customer Journeys?

Connect and learn more!
Chat AHT (average handle time) Calculation — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Chat AHT (average handle time) Calculation

Received Response
53
Views
8
Comments
edited Jun 29, 2016 6:11PM in Reporting & Analytics for B2C Service 8 comments

Content

There have been some questions regarding the accuracy of AHT calculation on the chat reports we are using that were all set up by a previous admin. That column in the report is using this formula: avg( if( chats.termination_event IN (1,2,4,13), date_diff(chat_events2.created,chat_events.created) ) )

I found a document in the knowledge base (attached to this post) that states chat_events.created "Occurs when the chat server first receives the chat request from end-user initiating a chat request. The timestamp associated to this event will be the same as the chats.requested timestamp." If I'm understanding that correctly, it would include the time when a customer is waiting for an agent to become available, resulting in a longer AHT than we would like to report on. I set up a new test report and used this formula for Average Handle Time: avg( if( chats.termination_event IN (1,2,4,13), date_diff(chats.completed,chats.first_engaged) ) )

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!