Here is a lookup table of HubSpot’s default deal properties.
-
name
: the internal name for data analysis, which is like variable name in a data frame; -
label
: the label name on HubSpot platform, which is easy to remember; -
description
: more information about a property;
Feel free to use it but please be aware that these are just the default deal properties from my test developer account. As such, please check HubSpot API if you want to have a full list of all your properties.
name | label | description |
---|---|---|
amount_in_home_currency | Amount in company currency | The amount of the deal, using the exchange rate, in your company’s currency |
days_to_close | Days to close | The number of days the deal took to close |
deal_currency_code | Currency | Currency code for the deal. |
hs_acv | Annual contract value | The annual contract value (ACV) of this deal. |
hs_all_assigned_business_unit_ids | Business units | The business units this record is assigned to. |
hs_analytics_source | Original Source Type | Original source for the contact with the earliest activity for this deal. |
hs_analytics_source_data_1 | Original Source Data 1 | Additional information about the original source for the associated contact, or associated company if there is no contact, with the oldest value for the Time first seen property. |
hs_analytics_source_data_2 | Original Source Data 2 | Additional information about the original source for the associated contact, or associated company if there is no contact, with the oldest value for the Time first seen property. |
hs_arr | Annual recurring revenue | The annual recurring revenue (ARR) of this deal. |
hs_campaign | HubSpot Campaign | The marketing campaign the deal is associated with |
hs_closed_amount | Closed Deal Amount | Returns the amount if the deal is closed. Else, returns 0. |
hs_closed_amount_in_home_currency | Closed Deal Amount In Home Currency | Returns the amount in home currency if the deal is closed. Else, returns 0. |
hs_created_by_user_id | Created by user ID | The user that created this object. This value is automatically set by HubSpot and may not be modified. |
hs_date_entered_appointmentscheduled | Date entered ‘Appointment Scheduled (Sales Pipeline)’ | The date and time when the deal entered the ‘Appointment Scheduled’ stage, ‘Sales Pipeline’ pipeline |
hs_date_entered_closedlost | Date entered ‘Closed Lost (Sales Pipeline)’ | The date and time when the deal entered the ‘Closed Lost’ stage, ‘Sales Pipeline’ pipeline |
hs_date_entered_closedwon | Date entered ‘Closed Won (Sales Pipeline)’ | The date and time when the deal entered the ‘Closed Won’ stage, ‘Sales Pipeline’ pipeline |
hs_date_entered_contractsent | Date entered ‘Contract Sent (Sales Pipeline)’ | The date and time when the deal entered the ‘Contract Sent’ stage, ‘Sales Pipeline’ pipeline |
hs_date_entered_decisionmakerboughtin | Date entered ‘Decision Maker Bought-In (Sales Pipeline)’ | The date and time when the deal entered the ‘Decision Maker Bought-In’ stage, ‘Sales Pipeline’ pipeline |
hs_date_entered_presentationscheduled | Date entered ‘Presentation Scheduled (Sales Pipeline)’ | The date and time when the deal entered the ‘Presentation Scheduled’ stage, ‘Sales Pipeline’ pipeline |
hs_date_entered_qualifiedtobuy | Date entered ‘Qualified To Buy (Sales Pipeline)’ | The date and time when the deal entered the ‘Qualified To Buy’ stage, ‘Sales Pipeline’ pipeline |
hs_date_exited_appointmentscheduled | Date exited ‘Appointment Scheduled (Sales Pipeline)’ | The date and time when the deal exited the ‘Appointment Scheduled’ stage, ‘Sales Pipeline’ pipeline |
hs_date_exited_closedlost | Date exited ‘Closed Lost (Sales Pipeline)’ | The date and time when the deal exited the ‘Closed Lost’ stage, ‘Sales Pipeline’ pipeline |
hs_date_exited_closedwon | Date exited ‘Closed Won (Sales Pipeline)’ | The date and time when the deal exited the ‘Closed Won’ stage, ‘Sales Pipeline’ pipeline |
hs_date_exited_contractsent | Date exited ‘Contract Sent (Sales Pipeline)’ | The date and time when the deal exited the ‘Contract Sent’ stage, ‘Sales Pipeline’ pipeline |
hs_date_exited_decisionmakerboughtin | Date exited ‘Decision Maker Bought-In (Sales Pipeline)’ | The date and time when the deal exited the ‘Decision Maker Bought-In’ stage, ‘Sales Pipeline’ pipeline |
hs_date_exited_presentationscheduled | Date exited ‘Presentation Scheduled (Sales Pipeline)’ | The date and time when the deal exited the ‘Presentation Scheduled’ stage, ‘Sales Pipeline’ pipeline |
hs_date_exited_qualifiedtobuy | Date exited ‘Qualified To Buy (Sales Pipeline)’ | The date and time when the deal exited the ‘Qualified To Buy’ stage, ‘Sales Pipeline’ pipeline |
hs_deal_amount_calculation_preference | Deal amount calculation preference | Specifies how deal amount should be calculated from line items |
hs_deal_stage_probability | Deal probability | The probability a deal will close. This defaults to the deal stage probability setting. |
hs_deal_stage_probability_shadow | Deal stage probability shadow | Fall back property for calculating the deal stage when no customer override exist. Probability between 0 and 1 of deal stage. Defaults to 0 for unknown deal stages. |
hs_forecast_amount | Forecast amount | The custom forecasted deal value calculated by multiplying the forecast probability and deal amount. |
hs_forecast_probability | Forecast probability | The custom percent probability a deal will close. |
hs_is_closed | Is Deal Closed? | True if the deal was won or lost. |
hs_is_closed_won | Is Closed Won | True if the deal is in the closed won state, false otherwise |
hs_is_deal_split | Is Deal Split | Indicates if the deal is split between multiple users. |
hs_lastmodifieddate | Last Modified Date | Most recent timestamp of any property update for this deal. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically. |
hs_likelihood_to_close | Likelihood to close by the close date | Hubspot predicted likelihood between 0 and 1 of the deal to close by the close date. |
hs_line_item_global_term_hs_discount_percentage | Global Term Line Item Discount Percentage | For internal HubSpot Application use only. Global term for the discount percentage applied. |
hs_line_item_global_term_hs_discount_percentage_enabled | Global Term Line Item Discount Percentage Enabled | For internal HubSpot Application use only. Indicates if the Global term for the discount percentage is enabled. |
hs_line_item_global_term_hs_recurring_billing_period | Global Term Line Item Recurring Billing Period | For internal HubSpot Application use only. Global term for product recurring billing duration. |
hs_line_item_global_term_hs_recurring_billing_period_enabled | Global Term Line Item Recurring Billing Period Enabled | For internal HubSpot Application use only. Indicates if the Global term for product recurring billing duration is enabled. |
hs_line_item_global_term_hs_recurring_billing_start_date | Global Term Line Item Recurring Billing Start Date | For internal HubSpot Application use only. Global term for recurring billing start date for a line item. |
hs_line_item_global_term_hs_recurring_billing_start_date_enabled | Global Term Line Item Recurring Billing Start Date Enabled | For internal HubSpot Application use only. Indicates if the Global term for recurring billing start date for a line item is enabled. |
hs_line_item_global_term_recurringbillingfrequency | Global Term Line Item Recurring Billing Frequency | For internal HubSpot Application use only. Global term for how frequently the product is billed. |
hs_line_item_global_term_recurringbillingfrequency_enabled | Global Term Line Item Recurring Billing Frequency Enabled | For internal HubSpot Application use only. Indicates if the Global term for how frequently the product is billed is enabled |
hs_manual_forecast_category | Forecast category | The likelihood a deal will close. This property is used for manual forecasting your deals. |
hs_merged_object_ids | Merged object IDs | The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified. |
hs_mrr | Monthly recurring revenue | The monthly recurring revenue (MRR) of this deal. |
hs_next_step | Next step | A short description of the next step for the deal |
hs_num_associated_active_deal_registrations | Number of Active Deal Registrations | The number of active deal registrations associated with this deal. This property is set automatically by HubSpot. |
hs_num_associated_deal_registrations | Number of Deal Registrations | The number of deal registrations associated with this deal. This property is set automatically by HubSpot. |
hs_num_associated_deal_splits | Number of Deal Splits | The number of deal splits associated with this deal. This property is set automatically by HubSpot. |
hs_num_target_accounts | Number of target accounts | The number of target account companies associated with this deal. This property is set automatically by HubSpot. |
hs_object_id | Deal ID | The unique ID for this deal. This unique ID is automatically populated by HubSpot and cannot be changed. |
hs_predicted_amount | The predicted deal amount | Returns the multiplication of the deal amount times the predicted likelihood of the deal to close by the close date. |
hs_predicted_amount_in_home_currency | The predicted deal amount in your company’s currency | Returns the multiplication of the deal amount in your company’s currency times the predicted likelihood of the deal to close by the close date. |
hs_priority | Priority | |
hs_projected_amount | Weighted amount | Returns the multiplication of the amount times the probability of the deal closing. |
hs_projected_amount_in_home_currency | Weighted amount in company currency | Returns the multiplication of the amount in home currency times the probability of the deal closing. |
hs_tcv | Total contract value | The total contract value (TCV) of this deal. |
hs_time_in_appointmentscheduled | Time in ‘Appointment Scheduled (Sales Pipeline)’ | The total time in seconds spent by the deal in the ‘Appointment Scheduled’ stage, ‘Sales Pipeline’ pipeline |
hs_time_in_closedlost | Time in ‘Closed Lost (Sales Pipeline)’ | The total time in seconds spent by the deal in the ‘Closed Lost’ stage, ‘Sales Pipeline’ pipeline |
hs_time_in_closedwon | Time in ‘Closed Won (Sales Pipeline)’ | The total time in seconds spent by the deal in the ‘Closed Won’ stage, ‘Sales Pipeline’ pipeline |
hs_time_in_contractsent | Time in ‘Contract Sent (Sales Pipeline)’ | The total time in seconds spent by the deal in the ‘Contract Sent’ stage, ‘Sales Pipeline’ pipeline |
hs_time_in_decisionmakerboughtin | Time in ‘Decision Maker Bought-In (Sales Pipeline)’ | The total time in seconds spent by the deal in the ‘Decision Maker Bought-In’ stage, ‘Sales Pipeline’ pipeline |
hs_time_in_presentationscheduled | Time in ‘Presentation Scheduled (Sales Pipeline)’ | The total time in seconds spent by the deal in the ‘Presentation Scheduled’ stage, ‘Sales Pipeline’ pipeline |
hs_time_in_qualifiedtobuy | Time in ‘Qualified To Buy (Sales Pipeline)’ | The total time in seconds spent by the deal in the ‘Qualified To Buy’ stage, ‘Sales Pipeline’ pipeline |
hs_unique_creation_key | Unique creation key | Unique property used for idempotent creates |
hs_updated_by_user_id | Updated by user ID | The user that last updated this object. This value is automatically set by HubSpot and may not be modified. |
hs_user_ids_of_all_notification_followers | User IDs of all notification followers | The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications |
hs_user_ids_of_all_notification_unfollowers | User IDs of all notification unfollowers | The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications |
hs_user_ids_of_all_owners | User IDs of all owners | The user IDs of all owners of this object |
hubspot_owner_assigneddate | Owner Assigned Date | The date the most recent deal owner was assigned to a deal. This is updated automatically by HubSpot. |
dealname | Deal Name | The name given to this deal. |
amount | Amount | The total amount of the deal |
dealstage | Deal Stage | The stage of the deal. Deal stages allow you to categorize and track the progress of the deals that you are working on. |
pipeline | Pipeline | The pipeline the deal is in. This determines which stages are options for the deal. |
closedate | Close Date | Date the deal was closed. This property is set automatically by HubSpot. |
createdate | Create Date | Date the deal was created. This property is set automatically by HubSpot. |
engagements_last_meeting_booked | Date of last meeting booked in meetings tool | The date of the most recent meeting an associated contact has booked through the meetings tool. |
engagements_last_meeting_booked_campaign | Campaign of last booking in meetings tool | This UTM parameter shows which marketing campaign (e.g. a specific email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link. |
engagements_last_meeting_booked_medium | Medium of last booking in meetings tool | This UTM parameter shows which channel (e.g. email) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link. |
engagements_last_meeting_booked_source | Source of last booking in meetings tool | This UTM parameter shows which site (e.g. Twitter) referred an associated contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link. |
hs_latest_meeting_activity | Latest meeting activity | The date of the most recent meeting (past or upcoming) logged for, scheduled with, or booked by a contact associated with this deal. |
hs_sales_email_last_replied | Recent Sales Email Replied Date | The last time a tracked sales email was replied to for this deal |
hubspot_owner_id | Deal owner | User the deal is assigned to. Assign additional users to a deal record by creating a custom user property. |
notes_last_contacted | Last Contacted | The last time a call, sales email, or meeting was logged for this deal. This is set automatically by HubSpot based on user actions. |
notes_last_updated | Last Activity Date | The last time a note, call, email, meeting, or task was logged for a deal. This is updated automatically by HubSpot. |
notes_next_activity_date | Next Activity Date | The date of the next upcoming activity for a deal. This property is set automatically by HubSpot based on user action. This includes logging a future call, sales email, or meeting using the Log feature, as well as creating a future task or scheduling a future meeting. This is updated automatically by HubSpot. |
num_contacted_notes | Number of times contacted | The total number of sales activities (notes, calls, emails, meetings, or tasks) logged for a deal. This is updated automatically by HubSpot. |
num_notes | Number of Sales Activities | The total number of times a sales email or call has been logged for a deal. This is updated automatically by HubSpot. |
hs_createdate | HubSpot Create Date | The date the deal was created. This property is set automatically by HubSpot. |
hubspot_team_id | HubSpot Team | Primary team of the deal owner. This property is set automatically by HubSpot. |
dealtype | Deal Type | The type of deal. By default, categorize your deal as either a New Business or Existing Business. |
hs_all_owner_ids | All owner ids | The value of all owner referencing properties for this object, both default and custom |
description | Deal Description | Description of the deal |
hs_all_team_ids | All team ids | The team ids corresponding to all owner referencing properties for this object, both default and custom |
hs_all_accessible_team_ids | All accessible team ids | The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom |
num_associated_contacts | Number of Associated Contacts | The number of contacts associated with this deal. This property is set automatically by HubSpot. |
closed_lost_reason | Closed Lost Reason | Reason why this deal was lost |
closed_won_reason | Closed Won Reason | Reason why this deal was won |