Zendesk logo

Sync Zendesk data to Sourcetable

Zendesk

Zendesk is a cloud-based customer service solution that allows businesses to enhance productivity, processes, and pipeline visibility for their sales teams. It can be used to track important customer service KPIs such as sales pipeline progress, support tickets and customer SLAs.

Sync Zendesk data to Sourcetable


Zendesk logo
Sourcetable logo

Find out how to make the most of your Zendesk CRM data with Sourcetable

Sourcetable Benefits

Data & analytics

Up-to-date, reliable customer service metrics can make all the difference for business owners looking to gauge their performance over time, and make improvements to guarantee customer retention. Sourcetable is an ideal tool for querying key data from Zendesk and other platforms in one simple, accessible spreadsheet – allowing users to analyze rep performance, build Activity and Campaign Reports and understand user churn at a glance.

Different charts and graphs as an example of data and analytics like Churn, LTV, ROAS, etc.

Accessibility

Syncing your Zendesk data to Sourcetable keeps it centralized and accessible. Everyone on your team will be able to track your business’ customer support data quickly and easily, no knowledge of SQL required.

All your business data in one place

Sourcetable intuitively brings together key data from over 30 different platforms and databases, including Zendesk and Zendesk Chat, allowing product, marketing and finance teams to gauge their ongoing performance at a glance, informing next steps while saving time for what matters most – selling your products.

Icons of example integrations all converging into a sourcetable spreadsheet representing how you can source data from virtually any service

Find out how to get the most from your Zendesk CRM data with Sourcetable

A Magic Wand

Smart Templates

Use out of the box tried and tested templates in order to merge sales and customer data, and improve data collaboration across your entire organisation

A Magic Wand

Quick Analysis

Analyze your Zendesk CRM data alongside findings from separate payment and marketing platforms, generating cross channel reports in the blink of an eye

A Magic Wand

Ease Of use

Compile and query all your Zendesk data in one spreadsheet to identify the business insights behind the numbers and improve customer service

Who uses Zendesk data in Sourcetable

💸 CFOs & Accountants

📈 Marketing and Advertising professionals

👷🏿 Sales and Sales Ops folk

🚀 Founders

🏢 Ecommerce businesses

Here's a sample of the Zendesk data that will be available in your Sourcetable spreadsheets:

Show all (34)

AGENT_ATTRIBUTE

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

Link icon

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

Link icon

AUDIT_LOG

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

Link icon

BRAND

Brand represent a product or a service of your client.

Link icon

CALL_METRIC

Page not accessible

Link icon

CUSTOM_ROLE

The access rights given to a particular user

Link icon

DOMAIN_NAME

The website of an organisation

Link icon

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

Link icon

GROUP

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

Link icon

GROUP_MEMBER

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

Link icon

ORGANIZATION

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

Link icon

ORGANIZATION_MEMBER

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

Link icon

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

Link icon

POST

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

Link icon

POST_COMMENT

A comment made on the post is called post comment

Link icon

SATISFACTION_RATING

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

Link icon

SCHEDULE

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

Link icon

SKIP_TICKET_HISTORY

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

Link icon

SLA_POLICY_HISTORY

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

Link icon

SLA_POLICY_METRIC_HISTORY

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

Link icon

TICKET

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

Link icon

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

Link icon

TICKET_COMMENT

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

Link icon

TICKET_CUSTOM_FIELD

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

Link icon

TICKET_FIELD_[MULTISELECT_NAME]

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

Link icon

TICKET_FIELD_HISTORY

History of ticket custom fields

Link icon

TICKET_FIELD_OPTION

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

Link icon

TICKET_SCHEDULE

no information available

TICKET_SLA_POLICY

no information available

TICKET_TAG

A tag which is applied on a ticket

Link icon

TICKET_TAG_HISTORY

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

Link icon

TWEET_RECIPIENT

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

Link icon

USER

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

Link icon

USER_TAG

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

Link icon

Sample companies

Online businesses integrating Zendesk with Sourcetable have access to all relevant data on accounts, contacts, leads, opportunities, engagement and overall performance.

  • Software as a Service

    (SaaS) companies
  • Retail online stores

    (eCommerce)
  • B2B Platforms

  • B2C Marketplaces

  • Subscription services

What makes Sourcetable special?

A Magic Wand

Interconnectivity

Connect, sync and query data from Zendesk with insights from 30+ other sources, regardless of your level of tech skills.

A Magic Wand

Collaboration

Use Sourcetable to automate manual work like adding tickets to your team's project management app, or creating tickets from form entries.

A Magic Wand

Automation

Create and share workflow templates to drive decisions and improve customer experience based on your Zendesk customer history

Frequently Asked Questions

How do I sync Zendesk data to Sourcetable?
Sourcetable is currently in Closed Beta. Sign up to the Beta here to tell us a little about yourself and request information on how to sync your Zendesk data.
How easy is it to visualize my Zendesk data using Sourcetable?
Sourcetable comes with a full Visualization suite including charts, graphs, conditional formatting, pivot tables and everything you might need to create shareable reports.
What common integrations do people combine with Zendesk?
Sourcetable spreadsheets are designed to be intuitive and user-friendly, so anyone can view key performance metrics from Zendesk - and other CRM platforms such as Salesforce and HubSpot - at a glance, without prior knowledge of SQL or other data languages.




Connect your Zendesk Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.