Expected Zendesk data
After you have connected your Zendesk account, you can use the Data Warehouse Manager to easily track relevant data fields for analysis.
This topic explores the main data tables that you can import from Zendesk into Adobe Commerce Intelligence, including links to additional documentation about Zendesk data.
Table name
Description
The
Audits
table records activity associated with a ticket, including status changes and both customer and agent responses. This table includes a ticket id which links back to the Tickets
table, which allows you to analyze the time to first response and time to resolution for each ticket.The
audit_~\_events
table is the child of the audits
table and records additional details of a ticket event.The
Organizations
table records company information about your end-users such as the name, ID, associated domain names, tags, and any custom fields.The
Tickets
table records all ticket details, including the created_at
timestamp and the requester\_id
and assignee\_id
, which allows you to link a ticket to an end-user and agent in the Users
table respectively.The
ticket fields
table contains information about the basic text fields and custom ticket fields in your account. Attributes of this table include the field ID
, URL
, type
, title
, description
, position
, requirement setting
, agent and end-user-specific information, and creation and update information.The
Users
table includes all details on end-users and agents, including the individual’s name and email. This allows you to analyze both the engagement of your end-users and the performance of your agents.Groups are how agents are organized in your Zendesk account. The
Groups
table records information such as the group ID
, URL
, name
, and creation and update information.Macros are actions defined by you that modify the values of a ticket’s fields. This table contains attributes such as the macro’s title, ID, actions, restrictions, and creation and update information.
The
Tags
table contains a list of all the tags in your account.This table contains data about ticket metrics. Fields include the
ticket ID
, URL
, and the number of groups, assignees, reopens, replies, reply time (in minutes), full resolution time, and last update (for example, status, assignee, or requester) information.Related
e1f8a7e8-8cc7-4c99-9697-b1daa1d66dbc