Zendesk: Ticket Field History

Description

• A daily historical view of the ticket field values defined in the ticket_field_history_columns variable and the corresponding updater fields defined in the ticket_field_history_updater_columns variable.

Supported Data Sources

• Zendesk Support

Columns

Type	Name	Description
STRING	ticket_day_id	The unique key of the table, a surrogate key of date_day and ticket_id.
DATE	date_day	The date of the day associated with the field values.
INTEGER	ticket_id	A ticket's unique identifier, it is automatically assigned when the ticket is created
STRING	priority	The tickets priority ranking
STRING	assignee_id	The assignee id assigned to the ticket
STRING	status	The status of the ticket