Skip to main content

Ticket Stage Timing

Written by Nick Maxwell

Details of when a ticket has been in it's different lifecycle stages

Data Dictionary

Field

Type

Notes

Archived

Boolean

True if the Ticket has been archived, Derived from text_to_boolean Archived

Company Name

Text

API: properties.name

Connection Name

Text

The name of the Connection. Typically the name of the HubSpot Organisation., Derived from clean_name Connection Name

Contact Name

Text

This is derived from the Firstname and Lastname, Derived from concat First Name and Last Name

Content

Text

API: properties.content

Created

Datetime

The date and time that the record was created., Derived from text_to_timestamptz Created

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., Derived from timestamptz_as_text_to_date Created

Cumulative Time In

Interval

Derived from text_milliseconds_to_interval Cumulative Time In

Data current as of

Datetime

Gives the date and time that this record was taken from HubSpot.

Date Entered

Date

Derived from timestamptz_to_date

Date Exited

Date

Derived from timestamptz_to_date

Datetime Entered

JSON

Derived from choosing the first non-null

Datetime Exited

JSON

Derived from choosing the first non-null

Internal URL

Text

The URL to the Ticket record - only available to those that have access to HubSpot., Derived from create_deeplink 'ticket' and Ticket ID

Latest Time In

Interval

Derived from text_milliseconds_to_interval Latest Time In

Owner ID

Integer

The Owner of the Ticket. Find related details in the Owners table., Derived from text_to_bigint properties.hubspot_owner_id

Owner Name

Text

Derived from concat First Name and Last Name

Pipeline ID

Text

API: properties.hs_pipeline

Pipeline Label

Text

Pipeline Sort Order

Integer

Pipeline Stage ID

Text

Derived from generate_hash Pipeline ID and Stage ID

Pipeline Stage Label

Text

Derived from clean_name

Pipeline Stage Sort Order

Integer

Derived from make_sort_order Pipeline Sort Order and Stage Sort Order

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., Derived from first_id Results

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., Derived from first_id Results

Stage ID

Text

API: Ticket Stage Properties.stage_id

Stage Label

Text

API: stages.label

Stage Sort Order

Integer

API: stages.displayOrder

Subject

Text

API: properties.subject

Ticket ID

Integer

HubSpot's unique ID for the Ticket., Derived from text_to_bigint Ticket ID

Time In

Interval

Derived from text_milliseconds_to_interval Time In

Did this answer your question?