# 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

* <img src="https://fivetran.com/integrations/zendesk/resources/zendesk.svg" alt="" data-size="line"> 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.                                                                 |
