Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

'acct_id' vs. 'client_id' in Chat Reporting

edited Jun 15, 2015 11:49PM in Reporting & Analytics for B2C Service 2 comments

Content

Can someone please explain to me the difference between the "acct_id" and "client_id" data elements in the chat_agent_sessions table?

 

For example, I've seen these two measurements both attributed to an agent in out-of-box chat reports and custom reports that I inherited, and they produce significantly different results:

  1. sum_distinct(chat_agent_sessions.engaged_secs,chat_agent_sessions.acct_id)
  2. sum_distinct(chat_agent_sessions.engaged_secs,chat_agent_sessions.client_id) 

 

In the reporting, the column with expression #1 has a header of "Total Chat Handle Time" and expression #2 has a header of "Total Time Engaged".

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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