Deals

Lists all deal records in HubSpot, supporting both OAuth and private-app token authentication methods.

Table Specific Information

A deal represents an ongoing transaction that a sales team is pursuing with a contact or company. It is tracked through pipeline stages until won or lost.

SELECT

When selecting deals, filtering can be applied to columns marked as "Filterable." For these columns, the only supported server-side operator is =.

SELECT * FROM Deals WHERE ID = '96ec8565-3b73-4ee8-9815-f90566ba9c42';
SELECT * FROM Deals WHERE Archived = TRUE;

INSERT

INSERT INTO Deals (Currency) VALUES ('USD')

UPDATE

UPDATE Deals SET Currency = 'EUR' WHERE ID = '471395623'

DELETE

DELETE FROM Deals WHERE ID = '471395623'

Columns


Name	Type	ReadOnly	References	Filterable	Description
Id [KEY]	Long	False		True	Unique identifier assigned to each deal record in HubSpot.
Archived	Bool	True		True	Indicates whether the deal has been archived and is no longer active.
CreatedAt	Datetime	True		False	Timestamp when the deal record was initially created.
UpdatedAt	Datetime	True		False	Timestamp when the deal record was most recently updated.
ItemURL	String	True		False	URL linking directly to the HubSpot deal record.
Amount in company currency	Decimal	True		False	Deal amount converted into your company's currency using the applicable exchange rate.
Days to close	Decimal	True		False	Number of days between the deal's creation and close date.
Currency	String	False		False	Currency code used for the deal amount, such as USD or EUR.
Annual contract value	Decimal	True		False	Annual contract value (ACV) representing the yearly revenue from the deal.
Business units	String	False		False	Business units assigned to this deal for organizational tracking and reporting.
Deal Collaborator	String	True		False	User IDs of individuals involved in closing the deal.
Deal Split Users	String	True		False	User IDs of associated deal splits, set automatically by HubSpot.
Latest Source	String	True		False	Source of the last session activity from a directly or indirectly associated contact.
Latest Source Company	String	True		False	Source of the last session activity from a company associated with the deal.
Latest Source Contact	String	True		False	Source of the last session activity from the directly associated contact.
Latest Source Data 1	String	True		False	First additional detail about the latest session's source from associated contacts.
Latest Source Data 1 Company	String	True		False	First additional detail about the latest session's source from companies associated indirectly with the deal.
Latest Source Data 1 Contact	String	True		False	First additional detail about the latest session's source from directly associated contacts.
Latest Source Data 2	String	True		False	Second additional detail about the latest session's source from associated contacts.
Latest Source Data 2 Company	String	True		False	Second additional detail about the latest session's source from companies associated indirectly with the deal.
Latest Source Data 2 Contact	String	True		False	Second additional detail about the latest session's source from directly associated contacts.
Latest Source Timestamp	Datetime	True		False	Timestamp when the most recent session source activity occurred for a directly or indirectly associated contact.
Latest Source Timestamp Company	Datetime	True		False	Timestamp when the most recent session source activity occurred for an indirectly associated company.
Latest Source Timestamp Contact	Datetime	True		False	Timestamp when the most recent session source activity occurred for a directly associated contact.
Original Source Type	String	False		False	Original source that first captured the contact associated with this deal.
Original Source Data 1	String	True		False	First level of additional detail about the original source for the associated contact or company.
Original Source Data 2	String	True		False	Second level of additional detail about the original source for the associated contact or company.
Annual recurring revenue	Decimal	True		False	Annual recurring revenue (ARR) generated by this deal, typically for subscription-based sales.
HubSpot Campaign	String	False		False	Marketing campaign associated with this deal for attribution and tracking.
Closed Deal Amount	Decimal	True		False	Deal amount if the deal is closed; otherwise, returns 0.
Closed Deal Amount In Home Currency	Decimal	True		False	Deal amount in the company's home currency if the deal is closed; otherwise, returns 0.
Created by user ID	Decimal	True		False	HubSpot user ID of the individual who originally created this deal. This is set automatically.
Date entered Appointment Scheduled (Sales Pipeline)	Datetime	True		False	Date and time when the deal entered the 'Appointment Scheduled' stage of the 'Sales Pipeline'.
Date entered Closed Lost (Sales Pipeline)	Datetime	True		False	Date and time when the deal entered the 'Closed Lost' stage of the 'Sales Pipeline'.
Date entered Closed Won (Sales Pipeline)	Datetime	True		False	Date and time when the deal entered the 'Closed Won' stage of the 'Sales Pipeline'.
Date entered Contract Sent (Sales Pipeline)	Datetime	True		False	Date and time when the deal entered the 'Contract Sent' stage of the 'Sales Pipeline'.
Date entered Decision Maker BoughtIn (Sales Pipeline)	Datetime	True		False	Date and time when the deal entered the 'Decision Maker Bought-In' stage of the 'Sales Pipeline'.
Date entered Presentation Scheduled (Sales Pipeline)	Datetime	True		False	Date and time when the deal entered the 'Presentation Scheduled' stage of the 'Sales Pipeline'.
Date entered Qualified To Buy (Sales Pipeline)	Datetime	True		False	Date and time when the deal entered the 'Qualified To Buy' stage of the 'Sales Pipeline'.
Date exited Appointment Scheduled (Sales Pipeline)	Datetime	True		False	Date and time when the deal exited the 'Appointment Scheduled' stage of the 'Sales Pipeline'.
Date exited Closed Lost (Sales Pipeline)	Datetime	True		False	Date and time when the deal exited the 'Closed Lost' stage of the 'Sales Pipeline'.
Date exited Closed Won (Sales Pipeline)	Datetime	True		False	Date and time when the deal exited the 'Closed Won' stage of the 'Sales Pipeline'.
Date exited Contract Sent (Sales Pipeline)	Datetime	True		False	Date and time when the deal exited the 'Contract Sent' stage of the 'Sales Pipeline'.
Date exited Decision Maker BoughtIn (Sales Pipeline)	Datetime	True		False	Date and time when the deal exited the 'Decision Maker Bought-In' stage of the 'Sales Pipeline'.
Date exited Presentation Scheduled (Sales Pipeline)	Datetime	True		False	Date and time when the deal exited the 'Presentation Scheduled' stage of the 'Sales Pipeline'.
Date exited Qualified To Buy (Sales Pipeline)	Datetime	True		False	Date and time when the deal exited the 'Qualified To Buy' stage of the 'Sales Pipeline'.
Deal amount calculation preference	String	False		False	Specifies the method for calculating deal amounts from associated line items.
Deal probability	Decimal	False		False	Probability that the deal will close, typically based on the deal stage setting.
Deal stage probability shadow	Decimal	True		False	Fallback probability between 0 and 1 for the deal's stage if no override is applied; defaults to 0 for unknown stages.
Exchange rate	Decimal	True		False	Exchange rate used to convert the deal amount into the company's currency.
Forecast amount	Decimal	True		False	Forecasted deal value calculated by multiplying the forecast probability by the deal amount in company currency.
Forecast probability	Decimal	False		False	Custom probability percentage that predicts the chance of the deal closing.
Is Deal Closed_	Bool	True		False	Indicates whether the deal is marked as closed, either won or lost.
Is Closed Won	Bool	True		False	Indicates whether the deal is marked as 'Closed Won'.
Deal Split Added	Bool	True		False	Indicates whether this deal has an associated deal split among multiple owners.
Last Modified Date	Datetime	True		False	Timestamp of the latest property update to the deal, including internal HubSpot changes.
Likelihood to close by the close date	Decimal	True		False	HubSpot's predicted likelihood, between 0 and 1, that the deal will close by the close date.
Global Term Line Item Discount Percentage	String	False		False	Internal HubSpot value representing the global discount percentage applied to line items.
Global Term Line Item Discount Percentage Enabled	Bool	False		False	Internal HubSpot setting indicating if the global discount percentage is enabled.
Global Term Line Item Recurring Billing Period	String	False		False	Internal HubSpot value representing the global recurring billing duration for products.
Global Term Line Item Recurring Billing Period Enabled	Bool	False		False	Internal HubSpot setting indicating if the recurring billing period is enabled for line items.
Global Term Line Item Recurring Billing Start Date	String	False		False	Internal HubSpot value representing the start date for recurring billing on line items.
Global Term Line Item Recurring Billing Start Date Enabled	Bool	False		False	Internal HubSpot setting indicating if the recurring billing start date is enabled.
Global Term Line Item Recurring Billing Frequency	String	False		False	Internal HubSpot value representing how frequently the line item is billed.
Global Term Line Item Recurring Billing Frequency Enabled	Bool	False		False	Internal HubSpot setting indicating if the billing frequency is enabled for line items.
Forecast category	String	False		False	Manual forecasting category assigned to the deal, indicating its likelihood to close.
Merged object IDs	String	True		False	List of deal record IDs that were merged into this deal. Set automatically by HubSpot.
Monthly recurring revenue	Decimal	True		False	Monthly recurring revenue (MRR) associated with this deal, typically used for subscription sales.
Next step	String	False		False	Brief description of the next planned action or milestone for this deal.
Number of Active Deal Registrations	Decimal	True		False	Number of active deal registrations associated with this deal, tracked automatically by HubSpot.
Number of Deal Registrations	Decimal	True		False	Total number of deal registrations linked to this deal, tracked automatically by HubSpot.
Number of Deal Splits	Decimal	True		False	Total number of deal splits associated with this deal, tracked automatically by HubSpot.
Number of target accounts	Decimal	True		False	Number of target account companies associated with this deal, set automatically by HubSpot.
Record ID	Decimal	True		False	Unique identifier assigned to this deal record by HubSpot.
Pinned Engagement ID	Decimal	True		False	Object ID of the engagement currently pinned to the deal, set automatically by HubSpot.
The predicted deal amount	Decimal	True		False	Predicted deal amount calculated as the deal amount multiplied by the predicted likelihood of closing.
The predicted deal amount in your company's currency	Decimal	True		False	Predicted deal amount in company currency, calculated using the predicted likelihood of closing.
Priority	String	False		False	Priority level assigned to the deal, if configured.
Weighted amount	Decimal	True		False	Deal amount multiplied by the probability of the deal closing.
Weighted amount in company currency	Decimal	True		False	Weighted amount converted into the company's currency, based on the deal's closing probability.
Read Only Object	Bool	True		False	Indicates whether the deal record is read-only and cannot be edited.
Total contract value	Decimal	True		False	Total contract value (TCV) of the deal, representing full revenue over the contract term.
Time in Appointment Scheduled (Sales Pipeline)	Decimal	True		False	Total time in seconds the deal spent in the 'Appointment Scheduled' stage of the 'Sales Pipeline'.
Time in Closed Lost (Sales Pipeline)	Decimal	True		False	Total time in seconds the deal spent in the 'Closed Lost' stage of the 'Sales Pipeline'.
Time in Closed Won (Sales Pipeline)	Decimal	True		False	Total time in seconds the deal spent in the 'Closed Won' stage of the 'Sales Pipeline'.
Time in Contract Sent (Sales Pipeline)	Decimal	True		False	Total time in seconds the deal spent in the 'Contract Sent' stage of the 'Sales Pipeline'.
Time in Decision Maker BoughtIn (Sales Pipeline)	Decimal	True		False	Total time in seconds the deal spent in the 'Decision Maker Bought-In' stage of the 'Sales Pipeline'.
Time in Presentation Scheduled (Sales Pipeline)	Decimal	True		False	Total time in seconds the deal spent in the 'Presentation Scheduled' stage of the 'Sales Pipeline'.
Time in Qualified To Buy (Sales Pipeline)	Decimal	True		False	Total time in seconds the deal spent in the 'Qualified To Buy' stage of the 'Sales Pipeline'.
Unique creation key	String	True		False	Unique key used for idempotent deal creation to prevent duplicate records.
Updated by user ID	Decimal	True		False	User ID of the individual who most recently updated the deal record.
User IDs of all notification followers	String	True		False	List of user IDs who opted to follow this deal for notification updates.
User IDs of all notification unfollowers	String	True		False	List of user IDs who opted out of receiving follow notifications for this deal.
User IDs of all owners	String	True		False	List of all owner user IDs assigned to the deal record.
Owner Assigned Date	Datetime	True		False	Date and time when the most recent owner was assigned to the deal.
Deal Name	String	False		False	Name assigned to the deal for identification and tracking.
Amount	Decimal	False		False	Total monetary value of the deal.
Deal Stage	String	False		False	Current stage of the deal within the associated pipeline.
Pipeline	String	False		False	Sales pipeline to which this deal belongs, determining available deal stages.
Close Date	Datetime	False		False	Date when the deal was closed as either won or lost.
Create Date	Datetime	False		False	Date when the deal record was initially created in HubSpot.
Date of last meeting booked in meetings tool	Datetime	True		False	Date of the most recent meeting booked through the HubSpot meetings tool by an associated contact.
Campaign of last booking in meetings tool	String	True		False	Marketing campaign that referred an associated contact to the meetings tool for their most recent booking, based on UTM parameters.
Medium of last booking in meetings tool	String	True		False	Channel that referred an associated contact to the meetings tool for their most recent booking, based on UTM parameters.
Source of last booking in meetings tool	String	True		False	Website or platform that referred an associated contact to the meetings tool for their most recent booking, based on UTM parameters.
Latest meeting activity	Datetime	True		False	Date of the most recent meeting, either past or upcoming, logged, scheduled, or booked by a contact associated with this deal.
Recent Sales Email Replied Date	Datetime	True		False	Last date a tracked sales email received a reply from an associated contact.
Deal owner	String	False		False	Primary user assigned as the owner of the deal. Additional owners can be assigned via custom properties.
Last Contacted	Datetime	True		False	Most recent time a call, sales email, or meeting was logged for this deal. Automatically updated by HubSpot.
Last Activity Date	Datetime	True		False	Most recent time any sales activity, such as a note, call, email, meeting, or task, was logged for this deal.
Next Activity Date	Datetime	True		False	Next upcoming activity scheduled for the deal, including calls, emails, meetings, or tasks. Automatically updated by HubSpot.
Number of times contacted	Decimal	True		False	Total number of logged sales activities (notes, calls, emails, meetings, tasks) for the deal.
Number of Sales Activities	Decimal	True		False	Total number of tracked sales emails or calls associated with the deal.
HubSpot Create Date	Datetime	True		False	Date the deal was created in HubSpot. Automatically generated.
HubSpot Team	String	True		False	Primary HubSpot team associated with the deal owner.
Deal Type	String	False		False	Classification of the deal, such as New Business or Existing Business.
All owner ids	String	True		False	List of all user IDs linked to ownership properties for this deal, including custom and default owners.
Deal Description	String	False		False	Detailed description of the deal, typically outlining purpose, scope, or background.
All team ids	String	True		False	List of all team IDs corresponding to the ownership properties associated with this deal.
All accessible team ids	String	True		False	List of all team IDs, including hierarchical teams, with access to ownership properties associated with the deal.
Number of Associated Contacts	Decimal	True		False	Total number of contacts associated with the deal. Set automatically by HubSpot.
Closed Lost Reason	String	False		False	Reason provided for why the deal was marked as lost.
Closed Won Reason	String	False		False	Reason provided for why the deal was marked as won.