Expected 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.