Monitoring Customer Service Performance with a Zendesk Dashboard

Zendesk is well-known for its product offerings in customer service and engagement. Since it meets many business needs, it has been adopted by many organizations worldwide. With Zendesk, communicating with customers will be easy and efficient making the customer experience better. For companies doing any kind of business, customer service plays a key role in their success in the market, so it is necessary for them to improve themselves by monitoring their customer service performance. To accomplish this, they can get the support data they need from Zendesk and do the analytics with Syncfusion Dashboards. This article will walk you through building a customer service performance-monitoring dashboard with your Zendesk support data using Syncfusion Dashboards.

If you are new to Syncfusion Dashboardsregister for a free trial on our website. At the end of the registration process, you will reach the following page view.

homepage view of syncfusion dashboards for monitoring the customer service performance with zendesk data
Homepage of Syncfusion Dashboards

Defining metrics for support performance monitoring

Support team performance can be measured by customers’ experiences with your support and their level of expectations met. To monitor the support performance of your team, let us consider the following metrics.

  • Support tickets created over time.
  • Support tickets closed over time.
  • Satisfaction score and comment for each closed ticket.
  • Tickets handled by priority.
  • Tickets by status over a time period.
  • Closed tickets ratio by satisfaction score.
  • Satisfaction score received by support agent.

Getting Zendesk data

The Zendesk Support API allows you to read, update and create data in Zendesk support instances through API requests.

The base URL format for the Zendesk Support API is,
https://<domainname>.zendesk.com/api/v2/<yourendpoint>

Assuming you have a verified user account, authorize against the Zendesk Support API using basic authentication with your email address and password.

For our demo dashboard data preparation, the tickets and users endpoints need to be utilized as illustrated in the following table.

Endpoint Used for
GET /api/v2/tickets.json Getting the list of support tickets created and assigned.
GET /api/v2/users.json Getting the list of ticket creators and agents to whom the tickets were assigned.

Creating a dashboard and data sources

Creating a new blank dashboard

  1. Select the New Dashboard tile in the homepage of Syncfusion Dashboards. The Create Dashboard window opens with two thumbnails: Blank Dashboard and Templates.

    templates view in create dashboard window to create twilio dashboard with syncfusion dashboards
    Templates view in Create Dashboard window
  2. Choose Blank Dashboard. As a result, the Dashboard Designer page opens with a new blank dashboard created.

    blank dashboard in editing view to create twilio dashboard using syncfusion dashboards
    Blank dashboard in editing view

Connecting to Zendesk

  1. Select the data source icon at the right. The data source panel will expand as shown in the following.

    empty data source panel to create twilio dashboard using syncfusion dashboards
    An empty data source panel
  2. Select CREATE NEW in the previous panel. This shows the list of data connectors like in the following.

    supported data connections listing in syncfusion dashboards
    Supported Data Connections
  3. Choose the category Sales & CRM in the Categories drop-down list. This shows the data connectors available under this category like in the following.

    supported data connections in sales & crm category to create zendesk dashboard using syncfusion dashboards
    Supported Data Connections in Sales & CRM category
  4. Choose the Zendesk connector. As a result, the Zendesk data connection window will be displayed in the panel.

    new zendesk data source window of syncfusion dashboards
    New Zendesk Data source Window

For the required metrics, you need to create three data sources using Zendesk connection for specific purposes listed below.

Data source Purpose
ZendeskTicketUsers To create a users table from the users.json API endpoint for joining with tickets.json table data through other listed data sources.
ZendeskSupportTickets To create a tickets table from tickets.json API endpoint and join with ZendeskTicketUsers data source table for ticket creator details.
ZendeskSupportAgents To create a tickets table from tickets.json API endpoint and join with ZendeskTicketUsers data source table for support agent details.

Creating a data source with Zendesk support data

  1. To start with first data source, name it ZendeskSupportTickets in the Name field of the NEW DATA SOURCE window.
  2. In the URL section, fill in the users endpoint URL as shown in the following and replace the {domainname} placeholder with your account domain name.
    https://{domainname}.zendesk.com/api/v2/tickets.json
  3. Leave the default value GET selected under the Method section. Also, leave the Header(s) section empty.
  4. Define the refresh settings with an interval. This way, the dashboard can refresh itself with the latest data updates.
  5. Let the Data Format be JSON since the Users and Tickets API endpoints return result in JSON format.
  6. Set the Authentication Type to Basic Http Authentication.
  7. Fill the User Name with the email address of your account and Password with your password like in the following.

    data source created with zendesk support api endpoint using syncfusion dashboards
    A data source named ZendeskSupportTickets
  8. Click Preview & Connect. Now, a window opens listing the data results, categorized into a table and columns like in the following.

    preview window showing tickets detail for zendesk dashboard creating using syncfusion dashboards
    Preview window showing tickets detail
  9. Choose the desired columns. Click Connect. As a result, the data source with the selected table and columns is created.
  10. Similarly, create the other two data sources ZendeskSupportAgents with the Tickets API and ZendeskTicketUsers with the Users API as shown in the following.
    https://{domainname}.zendesk.com/api/v2/users.json

    data sources panel listing all zendesk data sources in syncfusion dashboards
    Data sources panel listing all Zendesk data sources

Editing the data source

To find out the names of the users who submitted tickets and their attending agents, join the tickets table with the users table. To do so:

  1. Navigate to the dashboard design page and expand the DATA SOURCES panel at the right.
  2. Click the Edit icon near the ZendeskSupportTickets data source to open it. Consequently, the data source window opens.
  3. To join the users table with tickets table, expand the Shared Tables panel at the bottom of the tree view panel at left like in the following.

    shared tables listing to choose users table for joining with tickets table of zendesk data in syncfusion dashboards
    Shared tables listing to choose a table for joining
  4. This panel lists the data sources you created previously or that were shared with you. Scroll down to see the ZendeskTicketUsers data source. Expand, select and drag the table usersjson to the table design view. Now, the join editor window opens like in the following.

    join editor showing tables mapped with related fields of zendesk data in syncfusion dashboards
    Join editor showing tables mapped with related fields
  5. First, select the requester_id field under ticketsjson table and the id field under usersjson table. Then, click Update.
  6. To consolidate the different statuses of closed tickets, like resolved or closed into one to be considered for measurement, two expressions are needed. For that, open the expression editor from the icon in the toolbar and create the expression columns listed in the following table.
    Name Expression
    Closed Tickets IF([status]=’solved’ OR [status]=’closed’,1,0)
    Status Name IF([status]=’solved’,’closed’,[status])
  7. Save the data source.
  8. Similarly, edit the ZendeskSupportAgents data source. However, in the join editor window, select assignee_id field under ticketsjson table and id field under usersjson table. Then, click Update.
  9. To assess the support agent performance, scores need to be classified as good or bad. For that, two expressions are needed like in the following.
    Name Expression
    Good Score IF([score]=’good’,1,0)
    Bad Score IF([score]=’bad’,1,0)

    expression editor with columns created for zendesk support agents data source in syncfusion dashboards
    Expression editor with columns created for ZendeskSupportAgents data source
  10. Save the data source.

Configuring widgets in the dashboard

Configure the widgets in the dashboard with corresponding data sources as described in the following table. First, select the widget in the design canvas to configure using mouse. Then, click the Widget Settings icon at the top-right corner of the focused border. The panel on the right side expands left. After that, choose the ASSIGN DATA tab and start configuring the mentioned fields at corresponding sections.

Widget Data Configuration
Tickets created over time (Type: Column Chart)
  • Data source: ZendeskSupportTickets
  • Value(s): id (tickets) => Aggregation: Distinct Count
  • Column(s): created_at => Format: Date
Tickets closed over time (Type: Column Chart)
  • Data source: ZendeskSupportTickets
  • Value(s): Closed Tickets => Aggregation: Sum
  • Column(s): updated_at => Format: Date
Tickets breakdown by priority (Type: Pie Chart)
  • Data source: ZendeskSupportTickets
  • Value(s): id (tickets) => Aggregation: Distinct Count
  • Column(s): priority
Closed tickets with satisfaction score and comment (Type: Grid)
  • Data source: ZendeskSupportTickets
  • Column:
    • id (tickets) => Aggregation: None
    • name
    • email
    • created_at => Format: Date
    • score
    • comment
Closed tickets breakdown by satisfaction score (Type: Pie Chart)
  • Data source: ZendeskSupportTickets
  • Value(s): Closed Tickets => Aggregation: Sum
  • Column(s): score
Tickets breakdown by status (Type: Doughnut Chart)
  • Data source: ZendeskSupportTickets
  • Value(s): id (tickets) => Aggregation: Distinct Count
  • Column(s): status
Support agent performance by satisfaction score (Type: Bar Chart)
  • Data source: ZendeskSupportAgents
  • Value(s):
    • Good Score => Aggregation: Sum
    • Bad Score => Aggregation: Sum
  • Column(s):
    • name

Finally the dashboard is ready.

customer service monitoring dashboard with zendesk data using syncfusion dashboards
Customer Service Monitoring Dashboard with Zendesk data

Sharing the dashboard

Now, share this dashboard with your customer service team to show them their performance and customers’ experiences with them and so that they can find areas to improve.

We hope this article helps you build a support team performance monitoring dashboard with Zendesk data using Syncfusion Dashboards. If you have any questions or require clarification, please let us know in the comments section below. You can also contact us through this contact page. Syncfusion Dashboards now comes with a 30-day free trial with no credit card information required. Give it a try on your own and let us know what you think! We are happy to assist you. Design with a smile!

Tags:

Share this post:

Related Posts

Leave a comment