Zendesk

Zendesk is a cloud-based customer support platform.

Sync Zendesk data to Sourcetable

Build reports once. Connect to Zendesk and start modeling from live data.

Popular Use Cases

Zendesk connector Sourcetable connector
Create automated reports using Zendesk data
Zendesk + Sourcetable
Zendesk connector Salesforce connector
Analyze the impact of Customer Support on closed Salesforce leads
Zendesk + Salesforce
Zendesk connector Segment connector
Segment Zendesk customer support tickets by lead source with Segment data
Zendesk + Segment
Zendesk connector Sourcetable connector
Analyze customer support performance to predict churn
Zendesk + Sourcetable
MySQL connector Zendesk connector
Combine MySQL user table and Zendesk tickets for cohort analysis
MySQL + Zendesk
Here's a sample of the Zendesk data that will be available in your Sourcetable spreadsheets:
AGENT_ATTRIBUTE

Attrbute value containing the name, url and timestamp information of creation and update

ARTICLE

Article is JSON object containing the article information which includes body of article, comments, author id, timestamp information of article and other standard fields describing the state of article

AUDIT_LOG

Audit log is a JSON object representing information of update, delete etc for tracking purpose

BRAND

Brand represent a product or a service of your client.

CALL_METRIC

Page not accessible

CUSTOM_ROLE

The access rights given to a particular user

DOMAIN_NAME

The website of an organisation

FORUM_TOPIC

A collaboration of community posts on a subject is called a topic. They can be managed by agents, end users and anonymous users

GROUP

Group is a building block of a ticket workflow as whenever a support request comes it is assigned to a group.

GROUP_MEMBER

A link between an agent and a group is called a group membership.

ORGANIZATION

Organizations are used to classify customers where customer can be mapped to a particluar organization

ORGANIZATION_MEMBER

A link between user and an organisation, an organisation can have multiple users.

ORGANIZATION_TAG

Customizable fields that are displayed on Organization page. The customization can only be done by admins. Types of fields available are Basic text fields, date fields, as well as customizable drop-down and number fields

POST

A content shared by a user with the community is called post

POST_COMMENT

A comment made on the post is called post comment

SATISFACTION_RATING

A rating object representing the satisfaction score of good, better, worst rating by a customer

SCHEDULE

A timetable object that contains intervals, timezone information and name of the schedule

SKIP_TICKET_HISTORY

A history record that maintains entries when an agent skipped a ticket without responding to an end user

SLA_POLICY_HISTORY

A history record that maintains the logs of SLA's between the support provider and customers

SLA_POLICY_METRIC_HISTORY

A policy metric describes the metric targets of each value of priority

TICKET

A ticket is a mode of communication between end users (customers) and the agents

TICKET_ATTRIBUTE

A list of attribute values of a ticket containing the name of ticket, timestamp of created and modified date and a unique id

TICKET_COMMENT

A comment made on the ticket is called ticket comment, it is an update event which gets stored in the audit logs

TICKET_CUSTOM_FIELD

The fields of ticket comprising of title, description, agent description, timestamp and a tag

TICKET_FIELD_[MULTISELECT_NAME]

The fields of ticket comprising of title, description, agent description, timestamp and a tag

TICKET_FIELD_HISTORY

History of ticket custom fields

TICKET_FIELD_OPTION

A list of options containing name, id, position, url and values of the custom fields

TICKET_SCHEDULE

no information available

TICKET_SLA_POLICY

no information available

TICKET_TAG

A tag which is applied on a ticket

TICKET_TAG_HISTORY

A history table comprising the list of tags being applied to a ticket

TWEET_RECIPIENT

A type of event which gets triggered and is logged in ticket audit table

USER

Three types of users are there: end users (customers), agents and administrators

USER_TAG

Tags applied on user, they are only available if your account has user tagging enabled