Sync Zendesk Chat data to Sourcetable

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

Popular Use Cases

Create reports using Zendesk Chat data

Zendesk Chat + Sourcetable

Analyze the impact of customer zupport on user retention

Zendesk Chat + MongoDB

Segment Zendesk Chat customer support tickets by lead source with Segment data

Zendesk Chat + Segment

Analyze average customer support response times

Zendesk Chat + Sourcetable

Combine MySQL user table and Zendesk Chat tickets for cohort analysis

MySQL + Zendesk Chat

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

AGENT

An agent contains information like name, email, login account, created date and last login date

AGENT_ROLE

The role which an agent has, roles are the privileges that can be given to agents

BAN_IP

Contains the IP address and the reason of ban

BAN_VISITOR

Contains the visitor id and reason of ban

CHAT

Contains the visitor information, preview, type, started by, response time, session timing information

CHAT_AGENT

Contains the association of chat id and agent id

CHAT_HISTORY

Contains the history information related to a chat

CHAT_TAG

Contains the association of chat id and tag id

DEPARTMENT

Contains the department information like name, description and enabled

DEPARTMENT_MEMBER

Contains the association of a agent id and department id

ENGAGEMENT

Contains the information of chat, agent, department, started by, assigned, comment, timestamp and duration

VISITOR

Contains the information like phone, notes, email and name of visitor

Zendesk Chat

All your business data, synced in a spreadsheet.