Zendesk Support plugin

For more information about what this plugin does and the data streams it retrieves, see:

Zendesk Support or check out our sample Zendesk dashboards.

The Zendesk support plugin allows you to easily visualize data from Zendesk to see how agents and support teams are performing, find bottlenecks in your process and get a handle on KPIs.

To add a data source click on the + next to Data Sources on the left-hand menu in SquaredUp. Search for the data source and click on it to open the Configure data source page.

Loom video thumbnail

Before you start

SquaredUp accesses Zendesk via Username and API key so you will need to generate both of these before getting started. API keys can only be generated by a Zendesk admin, so make sure you login to Zendesk with Admin credentials.

Once generated, they can be used in conjunction with a specific user account, and it is the role of the user account that sets the permissions granted.

Generating API keys and adding users (called Team Members by Zendesk) are performed in the Admin center. To access the Admin center, log in to Zendesk with an account that has the Admin role, then click the apps icon in the top-right corner and select Admin Center.

Cover image

Generating an API key

Generic instructions on how to generate an API key are provided by Zendesk here, or you can follow the below steps:

  1. In Zendesk, click Apps & Integrations and select Zendesk API.
  2. Ensure that Token Access is enabled then click Add API token.
    Zendesk API add token
  3. Enter a name for the token in the API token description field.
    Zendesk API create token
  4. Click Copy next to the API token.

    Make sure you have correctly copied the token as you won't be able to access it again.

  5. Click Save to create the token.

Creating a Zendesk user with required permissions

The API key generated earlier can be used with any user account, the permission level that is granted is dependent on the user account specified.

The Zendesk data source requires a permissions level of Agent or higher. To use the Customer Satisfaction (CSAT) data stream the user must be an Admin user.

To create a user account for this purpose, Zendesk provides generic documentation here, or follow the below steps:

  1. From the Zendesk Admin Center navigate to People > Team > Team Members.
  2. Click Create Team Member in the top corner of the window.
  3. Enter the Name and Email address of the user.
    Zendesk create team member
  4. In the Assign role section, select a role of Agent or higher.
    Zendesk assign role
  5. Click Save.
  6. Navigate to the inbox of the created user and verify their email address as valid before attempting to use it.

Configuring the data source

  1. Display Name:
    Enter a name for your data source. This helps you to identify this data source in the list of your data sources.

  2. Organization name:
    Enter the organization name found in your Zendesk URL <organization>.zendesk.com. Don't enter the .zendesk.com part, just the organization name.
  3. Username:
    Zendesk calls its users Team members. Enter the team member’s email address that you would like the data source to use the permissions of. If you want to use the Customer Satisfaction (CSAT) data stream then this user must be an Admin level user.
  4. API Token:
    Enter the API token you previously generated. The API token is used in place of a password and can only be generated by a Zendesk admin. An API token can be used by any user regardless of which account generated it
  5. Import Organizations:
    Select to import your Zendesk organizations as objects. Zendesk organizations are typically collections of your end users, but they can also include team members.
  6. Import Organizations with Personal Email Addresses:
    Select to import your Zendesk organizations not linked to specific domains as objects. Typically these are organizations based around a single email address and can exist in great numbers.
  7. Restrict access to this data source:
    You can enable this option if you only want certain users or groups to have access to the data source, or the permission to link it to new workspaces. See Access control for more information.

  8. Install Sample Dashboards:
    Select whether you would like to install sample dashboards with the data source. By default, this is set to on.

    You can also add a data source from Settings > Data Sources > Add data source, but sample dashboards are not added when using this method.

  9. Click Test and add to validate the data source configuration. SquaredUp will now attempt to connect to SquaredUp using the provided authentication method. If this process fails, see Testing and troubleshooting for assistance with the corresponding errors.

Testing and troubleshooting

The following errors or warnings may be displayed while using the data source. If you encounter an error, refer to the guidance below or contact [email protected] for assistance.

Test
Error if failed
Troubleshooting
Check Zendesk URL is valid
Failed to create a valid url using <the URL created from your organization name>. Please check your organization name.
Check the organization name is correct, see below for more
Check username and token are valid
Your credentials could not be verified. Please check your username and token.
Check username is valid email address and has Agent or higher role and that the API token is correct and valid.
A failure was thrown by Zendesk that doesn’t match any other test
An error occurred. Please contact support.
Try the test again, if you still see the issue, take note of the support code and contact [email protected].
Check organization name is valid
Your organization could not be verified. Please check your organization name.
Check your organization name is correct. This is the part of your Zendesk URL before .zendesk.com when you are logged into Zendesk.

Next Steps

Once you have successfully connected to the Zendesk data source, we will setup the data source by configuring data streams, the method we use to pull real time data back from Zendesk, install sample dashboard (if you chose to do so) and index objects which are used by data streams for scoping.

Cover image

You must allow this process to complete before you use the data source. Closing the popup and then creating dashboards means there is a high chance that indexing will not have completed, resulting in errors and blank dashboards.


To check whether indexing has completed, click on the data source name and look at the data source status in the top left corner. If it says connected then indexing has completed.

Data source states

There are several states that all data sources can be in:

  • Connected: The last data source index was successful. Indexing happens automatically every 12 hours
  • Running: Indexing is in progress, if this is the first time the data source has connected to the source platform you should wait for this to complete to ensure all dashboards work without issues
  • Warning: When something went wrong but that wasn’t terminal for the data source, meaning indexing was successful for some of the objects the data source and some data sources should work. If you hover over Move info you will be shown the reason for the warning
  • Failed: The last graph index failed. If you hover over Move info you will be shown why. Note that each time a data source runs object indexing.
    Zendesk data source failed to connect

Data source capabilities

SquaredUp provides a high-level list of the data streams and object types for each data source, but once you have the data source connected then the data source overview page shows you more. You will then see each object type within your environment, in addition to the data streams available to the plugin.

Zendesk data source overview
Click an object to see the applicable data streams - for example, you can click the drilldown for a Zendesk user Adam to see the relational data:
Zendesk object drilldown example
Alternatively, you can click a data stream to see where it can be scoped to and the sorts of data it returns (which can then be saved to a dashboard if you so choose).
Zendesk object explore scope

Modifying data source settings and connection details

You can modify your data source settings and connection details by clicking the Manage button on the data source overview page.

Zendesk manage details

Graph imported objects

This data source imports the following objects.

Zendesk imported objects
Type
Description
Data streams that can scope to this object
Relationships
User
Represents a Zendesk user account, called a Team Member or Agent in Zendesk itself. Read more.
New Tickets
Active Tickets
On-Hold Tickets
Custom Ticket Search
Open Tickets
Pending Tickets
Solved Tickets
Tickets by Created Date
Tickets by Updated Date
Member of :: Group
Tag
Tags defined in Zendesk. Read more.
New Tickets
Active Tickets
On-Hold Tickets
Custom Ticket Search
Open Tickets
Pending Tickets
Solved Tickets
Tickets by Created Date
Tickets by Updated Date
Brand
A Zendesk customer facing identify, with its own set of contact points (e.g. Ticket Forms) and styling. Read more.
New Tickets
Active Tickets
On-Hold Tickets
Custom Ticket Search
Open Tickets
Pending Tickets
Solved Tickets
Tickets by Created Date
Tickets by Updated Date
Ticket form
Ticket forms contain a pre-configured set of fields users should fill in to submit a ticket in Zendesk. Read more.
New Tickets
Active Tickets
On-Hold Tickets
Custom Ticket Search
Open Tickets
Pending Tickets
Solved Tickets
Tickets by Created Date
Tickets by Updated Date
Used by :: Brand
Group
A collection of users. Read more.
New Tickets
Active Tickets
On-Hold Tickets
Custom Ticket Search
Open Tickets
Pending Tickets
Solved Tickets
Tickets by Created Date
Tickets by Updated Date
Organizations
Organizations are the other side of the coin to groups. Where groups can be used to manage agents, organizations can be used to manage end users.
New Tickets
Active Tickets
On-Hold Tickets
Custom Ticket Search
Open Tickets
Pending Tickets
Solved Tickets
Tickets by Created Date
Tickets by Updated Date
Users
Users and people are essentially equivalent terms; it's the broadest definition for all people who use your Zendesk.
New Tickets
Active Tickets
On-Hold Tickets
Custom Ticket Search
Open Tickets
Pending Tickets
Solved Tickets
Tickets by Created Date
Tickets by Updated Date
Phone Number
Represents a phone number that a customer might be able to call.
Used by: Brand
Used by: Group
(all new)
Talk Agent Availability (when routing is managed with groups)
Talk Statistics
Talk Queues

Data streams

Data streams standardize data from all the different shapes and formats your tools use into a straightforward tabular format. While creating a tile you can tweak data streams by grouping or aggregating specific columns. Depending on the kind of data, SquaredUp will automatically suggest how to visualize the result, for example as a table or line graph.

Data streams can be either global or scoped:

  • Global data streams are unscoped and return information of a general nature (e.g. Get the current number of unused hosts).
  • A scoped data stream gets information relevant to the specific set objects supplied in the tile scope (e.g. Get the current session count for these hosts).

Scoped data streams

Data stream
Description
Objects
New Tickets
Shows all tickets with a status of New
User
Tag
Brand
Ticket form
Group
Active Tickets
Shows all tickets except those with a status of On-Hold or Solved
User
Tag
Brand
Ticket form
Group
On-Hold Tickets
Shows all tickets with a status of On-Hold
User
Tag
Brand
Ticket form
Group
Custom Ticket Search
Allows you to type a Zendesk search query. Any objects you scope can be inserted into your query using mustache syntax {{}}
As an example, if you scope to all users and want to search for tickets in state greater than new you would type:
Type:ticket status>new assignee:{{sourceId}}
sourceId is replaced by the objects you scoped
User
Tag
Brand
Ticket form
Group
Open Tickets
Shows all tickets with a status of Open
User
Tag
Brand
Ticket form
Group
Pending Tickets
Shows all tickets with a status of Pending
User
Tag
Brand
Ticket form
Group
Solved Tickets
Shows all tickets with a status of Solved
User
Tag
Brand
Ticket form
Group
Tickets by Created Date
All tickets regardless of state, sorted by created date
User
Tag
Brand
Ticket form
Group
Tickets by Updated Date
All tickets regardless of state, sorted by updated date
User
Tag
Brand
Ticket form
Group

Global data streams

Unlike with scoped data streams, no objects are required for data to be returned.

Data stream
Description
Ticket Metrics
Returns key metrics on all tickets created within a 7 day timeframe, including:
  • Reply time
  • First resolution time
  • Full resolution time
  • Agent wait time
  • Requester wait time
  • On-hold time
This data stream doesn’t allow for timeframes other than 7 days due to underlying Zendesk API limitations.
Ticket Metrics by Created date
Returns all tickets in your organization created within the configured timeframe
Ticket Metrics by Solved date
Returns all tickets in your organization solved within the configured timeframe
Customer Satisfaction
Returns customer satisfaction (CSAT) scores for all tickets in your organization.
This data stream will only work if the Zendesk data source is configured with a user that is a Zendesk Admin.
When configuring the tile you can optionally choose Parameters > Filter at Source to filter on the property Score.
The property Score is converted to a RAG color and displayed as State.


Was this article helpful?


Have more questions or facing an issue?