Skip to main content
Tickets
Nick Maxwell avatar
Written by Nick Maxwell
Updated over 2 months ago

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.

Did this answer your question?