Zendesk: Ticket Enriched

Description

• Each record represents a Zendesk ticket, enriched with data about it's tags, assignees, requester, submitter, organization and group.

Supported Data Sources

• Zendesk Support

Columns

Type	Name	Description
INTEGER	ticket_id	Automatically assigned when the ticket is created
DATETIME	_fivetran_synced
INTEGER	assignee_id	The agent currently assigned to the ticket
INTEGER	brand_id	Enterprise only. The id of the brand this ticket is associated with
DATETIME	created_at	When this record was created
DATETIME	updated_at	When this record last got updated
STRING	description	Read-only first comment on the ticket
DATETIME	due_at	If this is a ticket of type "task" it has a due date. Due date format uses ISO 8601 format.
INTEGER	group_id	The group this ticket is assigned to
STRING	external_id	The external id of the ticket
BOOLEAN	is_public	Is true if any comments are public, false otherwise
INTEGER	organization_id	The organization of the requester
STRING	priority	The urgency with which the ticket should be addressed, possible values are urgent, high, normal and low
STRING	recipient	The original recipient e-mail address of the ticket
INTEGER	requester_id	The user who requested this ticket
STRING	status	The state of the ticket, possible values are new, open, pending, hold, solved and closed
STRING	subject	The value of the subject field for this ticket
INTEGER	problem_id	The reference to the problem if the ticket is listed as a problem
INTEGER	submitter_id	The user who submitted the ticket. The submitter always becomes the author of the first comment on the ticket
INTEGER	ticket_form_id	Enterprise only. The id of the ticket form to render for the ticket
STRING	type	The type of this ticket, possible values are problem, incident, question or task
STRING	url	The API url of this ticket
STRING	created_channel	The channel the ticket was created from
INTEGER	source_from_id	The channel the ticket was created from
STRING	source_from_title	The channel the ticket was created from
STRING	source_rel	The rel the ticket was created from
STRING	source_to_address	The address of the source the ticket was created from
STRING	source_to_name	The name of the source the ticket was created from
BOOLEAN	is_incident	Boolean indicating whether the ticket is listed as an incident
STRING	ticket_brand_name	The brand name of with the ticket
STRING	ticket_tags	A list of all tags assigned to this ticket
STRING	ticket_form_name	The form name of the ticket
INTEGER	ticket_total_satisfaction_scores	The total number of satisfaction scores the ticket received.
STRING	ticket_first_satisfaction_score	The first satisfaction score the ticket received.
STRING	ticket_satisfaction_score	The latest satisfaction score the ticket received.
STRING	ticket_satisfaction_comment	The ticket satisfaction comment
STRING	ticket_satisfaction_reason	The ticket satisfaction reason
BOOLEAN	is_good_to_bad_satisfaction_score	Boolean indicating if the ticket had a satisfaction score went from good to bad.
BOOLEAN	is_bad_to_good_satisfaction_score	Boolean indicating if the ticket had a satisfaction score went from bad to good.
STRING	ticket_organization_domain_names	The organization associated with the ticket domain names
STRING	requester_organization_domain_names	The ticket requesters organization domain names
STRING	requester_external_id	The ticket requester external id
DATETIME	requester_created_at	The date the ticket requester was created
DATETIME	requester_updated_at	The date the ticket requester was last updated
STRING	requester_role	The role of the user who requested this ticket
STRING	requester_email	The email of the user who requested this ticket
STRING	requester_name	The name of the user who requested this ticket
BOOLEAN	is_requester_active	Boolean indicating whether the requester is currently active
STRING	requester_locale	The locale of the ticket requester
STRING	requester_time_zone	The timezone of the ticket requester
INTEGER	requester_ticket_update_count	The number of times the requester has updated the ticket
DATETIME	requester_ticket_last_update_at	The last date the requester updated the ticket
DATETIME	requester_last_login_at	The last login of the ticket requester
INTEGER	requester_organization_id	The organization id of the ticket requester
STRING	requester_organization_name	The organization name of the ticket requester
STRING	requester_organization_tags	The organization tags of the ticket requester
STRING	requester_organization_external_id	The organization external id of the ticket requester
DATETIME	requester_organization_created_at	The date the ticket requesters organization was created
DATETIME	requester_organization_updated_at	The date the ticket requesters organization was last updated
STRING	submitter_external_id	The ticket submitter external id
STRING	submitter_role	The role of the user who submitted the ticket.
BOOLEAN	is_agent_submitted	Boolean indicating if the submitter has an agent role
STRING	submitter_email	The email of the user who submitted the ticket.
STRING	submitter_name	The name of the user who submitted the ticket.
BOOLEAN	is_submitter_active	Boolean indicating if the ticket submitter is active
STRING	submitter_locale	The locale of the ticket submitter
STRING	submitter_time_zone	The time zone of the ticket submitter
STRING	assignee_external_id	The external id of the ticket assignee
STRING	assignee_role	The role of the agent currently assigned to the ticket
STRING	assignee_email	The email of the agent currently assigned to the ticket
STRING	assignee_name	The name of the agent currently assigned to the ticket
BOOLEAN	is_assignee_active	Boolean indicating if the ticket assignee is active
STRING	assignee_locale	The locale of the ticket assignee
STRING	assignee_time_zone	The time zone of the ticket assignee
INTEGER	assignee_ticket_update_count	The number of times the ticket assignee has updated the ticket
DATETIME	assignee_ticket_last_update_at	The last date the ticket assignee updated the ticket
DATETIME	assignee_last_login_at	The date the ticket assignee last logged in
STRING	group_name	The name of the group this ticket is assigned to
STRING	organization_name	The name of the organization of the requester
STRING	requester_tag	The tags associated with the ticket requester.
STRING	submitter_tag	The tags associated with the ticket submitter.
STRING	assignee_tag	The tags associated with the ticket assignee.