It's easier than ever to analyze your Zendesk data with Panoply's Zendesk Snap Connector. Consolidate Zendesk, plus all other business data in a secure data warehouse, then explore it with our SQL workbench and in-product graphs and charts. You can also connect your favorite BI tools for more advanced Zendesk reporting and analysis.
Some of the available tables Panoply can collect from Zendesk include:
Brands
Brands are your customer-facing identities. They might represent multiple products or services, or they might literally be multiple brands owned and represented by your company.
Groups
When support requests arrive in Zendesk Support, they can be assigned to a Group. A ticket can never be assigned to an agent without also being assigned to a Group.
NPS Invitations
You can send an invitation to one or multiple recipients to take an NPS survey. You can use an API to set up a continuous delivery of NPS survey invites to your defined recipients.
NPS Recipients
Every NPS survey is delivered to one or multiple recipients. For most businesses that use Zendesk Support, the recipients are customers. Agents and admins will never receive surveys.
NPS Responses
When a recipient responds to an NPS survey, their rating, comment, and last survey date are captured. You can export the responses for your individual NPS survey by using this resource.
NPS Surveys
This resource can be used to list all surveys or retrieve and update an existing one. You can customize the content and settings of the survey before using the NPS Invitations resource to automate survey delivery.
Organization Fields
This resource allows you to work with organization fields. These are fields that admins can customize and display on an Organization page. You can add custom fields to organizations to store additional details.
Organization Memberships
An organization can have many users, and each user is linked to it through membership. Also, users can be in many organizations if the account supports multiple organizations.
Organizations
Just as agents can be segmented into groups in Zendesk Support, your customers (end-users) can be segmented into organizations. You can manually assign customers to an organization or automatically assign them to an organization by their email address domain.
Satisfaction Rating
This resource allows you to work with satisfaction ratings. These ratings are the feedback provided by your customers about their support experience. Satisfaction rating is per ticket and not per customer.
Satisfaction Reasons
When satisfaction reasons are enabled in your Zendesk Support account, and a user gives a negative rating to a solved ticket, a follow-up question is presented to the user. The question includes a list menu of possible reasons for the negative rating.
SLA Policies
A Service Level Agreement is a documented agreement between a support provider and its customers that specify performance measures for support. There can be multiple SLA policies per Zendesk Support account, and they are listed here.
Suspended Tickets
When an end-user submits a support request by email, in most cases, the email becomes a new ticket or adds a comment to an existing ticket. In some instances, though, the email is suspended.
Ticket Comments
Ticket comments represent the conversation between requesters, collaborators, and agents. Comments can be public or private. You have the right to configure those comments in your settings to appear as either category.
Ticket Fields
This resource is used to get the system and custom ticket fields. You can also use it to create custom ticket fields. System fields are the standard fields that agents see in a ticket.
Ticket Metric Events
Use the Ticket Metric Events resource to track reply times, agent work times, and requester wait times. For example, if you want to measure reply times, you can get the time a ticket was created and the time an agent first replied to it.
Ticket Metrics
This resource allows you to retrieve metrics about a ticket. These metrics include the date when a ticket was solved (solved_at), the total number of times the ticket was replied to (replies), the total number of times the ticket was reopened (reopens), and a lot more.
Tickets
Tickets are the means through which your end-users (customers) communicate with agents in Zendesk Support. Tickets can originate from several channels, including email, Help Center, chat, phone call, Twitter, Facebook, or the API. All tickets have a core set of properties.
User Fields
This resource allows admins to customize fields displayed on a User profile page. Basic text fields, date fields, as well as customizable dropdown and number fields are available. These fields are currently only visible to agents.
Users
This resource represents the three types of users in Zendesk Support: end-users (your customers), agents, and administrators. End-users request support through tickets. Agents work in Zendesk Support to solve tickets.
Sync Zendesk data with multiple sources in Panoply, then access it via your BI tool
“ Panoply has given us drastic improvements in query speed and brought all our data in one place. Our visualizations are much more fast and efficient.