Salesforce Service Cloud – Contact Center Reports

by Sudipta Deb | Jun 26, 2017 | Agent Productivity, Case Management, Contact Center, dashboard, KPIs, Metrics, Reports, service cloud | 21 comments

As a call center manager, it is very important to monitor team’s case performances targets, train new support agents, analyze team’s open case performance and etc. There are multiple matrices which a call center manager normally monitor to improve contact center’s performance.

Call center manager can use Salesforce reports to monitor critical support metrics such as –

  • Total open cases by agents
  • Total cases created by agents and status
  • Total cases created by agents and products
  • Total average age by agent
  • Total closed cases by agent
Let’s start with few important reports here –

Agent Open Case Load by Origin/Type:
This report will help call center manager to determine his/her team’s bandwidth/workload. The report will be grouped based on Agent and Case Origin/Type(based on your business operation). From here call center manager can easily get real time view of his/her team’s current work pressure. Here comes the report –
Average Age of Open Case:
Another very important report to understand your team’s performance – how long your agents are taking to serving customers and thus meeting the service-level agreements (SLAs). To create this report, you can customize the out-of-the-box report “Total Open Cases By Agent” and then summarize the Age column (Summarize by Average). Below is how the report will look like –


Average Age of Closed Case by Agent:
Call center managers can use this report to monitor their agent’s productivity in terms of how quickly agents are closing the cases. This report will give a very good comparative study of the agents in terms of their productivity. To create this report, you can customize the out-of-the-box report “Total Open Cases By Agent“. Remove the Open equals True filter and add Closed equals True filter, then summarize the Age column (Summarize by Average). Below is how the report will look like –


Monitor Email Queues:
If you have email-2-case configured in your organization and your email cases are routed to individual queues as per the case assignment configuration, then you might need to monitor your email queues to understand how many cases violated, what is the percentage of cases(in standard and out of standard) per queue etc.

In order to do that, use the below details in the report –

  • Use Filter: Case Owner contains
  • Drag the field – Violation from Milestone in the report.
  • Create formula field – (attaching the individual screenshots below)
    • # in standard (# of cases without violation)
    • % in standard (% of cases without violation)
    • # out of standard (# of cases with violation)

 












Below is how the report will look like –

Knowledge Reports:
If you have implemented Knowledge in your organization, then you can install Knowledge base Dashboards and Reports from Appexchange. From there you can go to the report folder – Knowledge Reports Package and get all the important reports available to you. Few important reports are –

  • Case count by Article
  • Cases with Articles
  • Recently created Articles
  • Recently Searches by Keyword
  • Article views
  • Article scores
Omni-Channel Reports:
If you have implemented Omni-Channel in your organization, then below are the reports you might need in your organization. 
  • Omni-Channel – Active Users – This report will give the status of all users currently logged into Omni-Channel.
  • Omni-Channel – Agent Email Metrics – This report will give the summary of email average handle time by Agent.
  • Omni-Channel – Agent Time-Outs – This report will give the summary of email cases that Agents did not accept prior to time out.
  • Omni-Channel – Queue Email Metrics – This report will give the summary of email average handle time by Queue.

Written by

Related Posts

21 Comments

  1. SALESFORCE

    I recognize the author for his dazzling work for creation this extraordinarily helpful and instructive content to guide us.
    salesforce form builder

    Reply
  2. Kamalakar

    very usefull informatation.and iam looking for more posts like this please keep updating us……..

    Reply
  3. Unknown

    I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site.
    digital training in chennai

    Reply
  4. Unknown

    Thanks for sharing.

    Reply
  5. saivenkat

    I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
    Contact Center App

    Reply
  6. Unknown

    Great Article Cloud Computing Projects

    Networking Projects

    Final Year Projects for CSE

    JavaScript Training in Chennai

    JavaScript Training in Chennai

    The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    Reply
  7. kosmik Technology

    Nice article, thanks for sharing it with us

    Reply
  8. Chaitu Viswa

    Beautiful information. Really inspired me to do something TODAY!.

    Reply
    • Sudipta Deb

      Thank you Chaitu. I am happy that my blog inspired you to learn/try something new.

      Reply
    • Sudipta Deb

      Happy that you liked it Kosmik Technologies

      Reply
  9. Bharath

    Thanks For the Informations

    Reply

Leave a Reply