Data Dictionary
Field | Type | Notes |
Archived | Boolean | True if the Ticket has been archived |
Assignment Method | Text | |
Associated Companies | JSON | A JSON array that holds the Company ID and Association Type of any Companies associated with this record. |
Associated Contacts | JSON | A JSON array that holds the Contact ID and Association Type of any Contacts associated with this record. |
Associated Deals | JSON | A JSON array that holds the Deal ID and Association Type of any Deals associated with this record. |
Category | Text | Ticket Category |
Closed Date | Date | The date that the ticket was Closed. Use this to create a relationship with the DatesDates table, and analyze data over days, weeks, months and so on. |
Closed Date and Time | Datetime | The date and time that the ticket was Closed |
Connection Name | Text | The name of the Connection. Typically the name of the HubSpot Organisation. |
Content | Text | |
Created | Datetime | The date and time that the record was created. |
Created By | Integer | The Owner ID of the person that created the record. Find related details in the Owners table. |
Created Date | Date | The date that the record was created. This is useful so you can create a relationship with the Dates table, and analyze data over days, weeks, months and so on. |
Data current as of | Datetime | Gives the date and time that this record was taken from HubSpot. |
Date Entered 1 | Datetime | |
Date Entered 2 | Datetime | |
Date Entered 3 | Datetime | |
Date Entered 4 | Datetime | |
Date Exited 1 | Datetime | |
Date Exited 2 | Datetime | |
Date Exited 3 | Datetime | |
First Agent Message Sent At | Datetime | |
First Agent Reply | Interval | The interval (days, hours, minutes and seconds) that was taken before the first Agent reply. |
First Agent Reply Date | Datetime | |
Internal Link | Text | The link to the Ticket record - only available to those that have access to HubSpot. |
Last Activity | Datetime | Last Activity Date |
Last Contacted | Datetime | |
Last Email Activity | Text | |
Last Email Date | Datetime | |
Last Engagement | Datetime | Last Engagement Date |
Last Reply Date | Datetime | |
MS Teams Message ID | Integer | Msteams Message ID |
Most Relevant SLA Status | Text | Most Relevant Sla Status |
Most Relevant SLA Type | Text | |
Next Activity Date | Text | |
Owner ID | Integer | The Owner of the Ticket. Find related details in the Owners table. |
Pipeline Stage ID | Integer | |
Primary Company ID | Integer | |
Primary Company ID | Integer | If one exists, the Company ID for the primary Company associated with this record. Find related details in the Companies table. |
Primary Company Name | Text | |
Primary Contact ID | Integer | If one exists, the Contact ID for the primary Contact associated with this record. There may not be any associated Contact. Find related details in the Contacts table. |
Primary Deal ID | Integer | If one exists, the Deal ID for the primary Deal associated with this record. Find related details in the Deals table. |
Priority | Text | Ticket Priority |
Resolution | Text | |
Source Type | Text | |
Subject | Text | |
Tags | Text | |
Ticket ID | Integer | HubSpot's unique ID for the Ticket. |
Ticket Pipeline ID | Text | |
Time In 1 | Interval | The interval (days, hours, minutes and seconds) that a ticket spent in pipeline stage 1. |
Time In 2 | Interval | The interval (days, hours, minutes and seconds) that a ticket spent in pipeline stage 2. |
Time In 3 | Interval | The interval (days, hours, minutes and seconds) that a ticket spent in pipeline stage 3. |
Time In 4 | Interval | The interval (days, hours, minutes and seconds) that a ticket spent in pipeline stage 4. |
Time To Close | Interval | The interval (days, hours, minutes and seconds) that a ticket took to close. |
Updated | Datetime | The date and time that the record was updated. |
Updated By | Integer | The Owner ID of the person that updated the record. |
Updated Date | Date | The date that the record was updated. This is useful so you can create a relationship with the Dates table, and analyze data over days, weeks, months and so on. |