Skip to main content

Deal Stage Timing

Written by Nick Maxwell

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

Data Dictionary

Field

Type

Notes

Amount

Number

The Amount in the Currency of the Deal, Derived from text_to_numeric properties.amount

Amount (RC)

Number

The amount of the deal in the home currency for HubSpot (eg the primary currency), Derived from text_to_numeric properties.amount_in_home_currency

Archived

Boolean

True if the Deal 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

Created

Datetime

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

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 properties.hs_createdate

Cumulative Time In

Interval

Derived from text_milliseconds_to_interval Cumulative Time In

Currency

Text

ISO 3 letter Currency Code for the Deal., API: properties.deal_currency_code

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

Deal ID

Integer

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

Deal Name

Text

API: properties.dealname

Description

Text

API: properties.description

Internal URL

Text

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

Latest Time In

Interval

Derived from text_milliseconds_to_interval Latest Time In

Owner ID

Integer

The Owner ID of the person that owns/is responsible for the record. Not necessarily the same as the Created By Owner ID. 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.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

Reporting Currency

Text

None

Stage ID

Text

API: Deal Stage Properties.stage_id

Stage Label

Text

API: stages.label

Stage Sort Order

Integer

API: stages.displayOrder

Time In

Interval

Derived from text_milliseconds_to_interval Time In

Did this answer your question?