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 |
