Data Dictionary
Field | Type | Notes |
Archived | Boolean | True if the Ticket has been archived |
Assignment Method | Text | |
CCO ID | Integer | The Connectorly Connection ID. If you group Connectorly's together, then you will see a CCO ID for each one. Organisations has the corresponding Connection Name for each CCO ID. |
Category | Text | Ticket Category |
Closed Date | Datetime | |
Content | Text | |
Created | Datetime | |
Created By | Integer | The Owner ID of the person that created the record. |
Created Date | Text | Created |
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 | json | The interval (days, hours, minutes and seconds) that was taken before the first Agent reply. |
First Agent Reply Date | Datetime | |
First Company ID | Integer | |
First Contact ID | Integer | |
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 | |
Link | Text | |
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 | |
Pipeline Stage ID | Integer | |
Primary Company ID | Integer | |
Primary Company Name | Text | |
Priority | Text | Ticket Priority |
Resolution | Text | |
Source Type | Text | |
Subject | Text | |
Tags | Text | |
Ticket Pipeline ID | Text | |
Time In 1 | json | The interval (days, hours, minutes and seconds) that a ticket spent in pipeline stage 1. |
Time In 2 | json | The interval (days, hours, minutes and seconds) that a ticket spent in pipeline stage 2. |
Time In 3 | json | The interval (days, hours, minutes and seconds) that a ticket spent in pipeline stage 3. |
Time In 4 | json | The interval (days, hours, minutes and seconds) that a ticket spent in pipeline stage 4. |
Time To Close | json | The interval (days, hours, minutes and seconds) that a ticket took to close. |
Type | Text | |
Type | Text | |
Type | Text | |
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 | Text | The date that a 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. |