Leads

Lists all lead records available in HubSpot, supporting lead management workflows.

Table-Specific Information

In HubSpot, leads are contacts or companies that are potential customers.

SELECT

When selecting leads, they can be filtered by columns marked below as 'Filterable'. For those columns, the supported server-side operators are: =, !=, <, <=, >, >=, IN

Further filtering is available using AND and OR combinations. A maximum of 3 OR operators are supported server-side, with each of these operators supporting up to 3 AND operators inside of them. For example:

SELECT * FROM Leads;
SELECT * FROM Leads WHERE [Id] = '385815394826';
SELECT * FROM Leads WHERE [Workflow updated lifecycle stage of company] = true OR [Associated Company Domain] = 'http://HubTest.com';

In the below server-offloading examples, "{Column}" represents any column you'd like to filter and "{Value}" represents any value you want to filter it on:

SELECT * FROM Leads WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM Leads WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}
SELECT * FROM Leads WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})
SELECT * FROM Leads WHERE ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}) OR ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value}) OR ({Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value})

INSERT

When creating Leads, either the 'Primary Associated Contact Object ID' column or the 'Primary Associated Company Object ID' column (these names can change based on UseDisplayNames and UseSimpleNames) must be specified in the INSERT statement, otherwise the query will fail. For example:

INSERT INTO Leads (`Lead Name`, `Primary Associated Contact Object ID`) VALUES ('Inserted Lead 1', 31501492998);
INSERT INTO Leads (`Lead Name`, `Primary Associated Company Object ID`) VALUES ('Inserted Lead 1', 21960329051);
INSERT INTO Leads (`Lead Name`, `Primary Associated Contact Object ID`, `Primary Associated Company Object ID`) VALUES ('Inserted Lead 1', 31501492998, 21960329051);

The same applies for bulk INSERTs:

INSERT INTO Leads#TEMP (`Lead Name`, `Primary Associated Contact Object ID`) VALUES ('Inserted Lead 1', 31501492998);
INSERT INTO Leads#TEMP (`Lead Name`, `Primary Associated Contact Object ID`) VALUES ('Inserted Lead 1', 31501492998);
INSERT INTO Leads#TEMP (`Lead Name`, `Primary Associated Contact Object ID`) VALUES ('Inserted Lead 1', 31501492998);
INSERT INTO Leads (`Lead Name`, `Primary Associated Contact Object ID`) SELECT * FROM Leads#TEMP;

UPDATE

UPDATE statements use the format:

UPDATE Leads SET [Business units] = '10' WHERE [Id] = '3917882265'
UPDATE Leads SET [Lead Disqualification Note] = 'testing note', [Disqualification Reason] = 'BAD_TIMING' WHERE [Id] = '386085073667'

DELETE

DELETE statements use the format:

DELETE FROM Leads WHERE ID = '3917882265'

Columns


Name	Type	ReadOnly	References	Filterable	Description
Id [KEY]	Long	True		True	Unique identifier assigned to each lead record in HubSpot.
Archived	Bool	True		False	Indicates whether the lead record has been archived and is no longer active.
CreatedAt	Datetime	True		False	Timestamp marking when the lead record was first created.
UpdatedAt	Datetime	True		False	Timestamp marking when the lead record was most recently updated.
All teams	String	True		False	List of all team IDs, including hierarchical teams, associated with the ownership properties for this lead.
Business units	String	False		False	Business units assigned to the lead for organizational categorization and reporting.
All owner ids	String	True		False	List of all owner user IDs associated with the lead, covering both default and custom owner properties.
All team ids	String	True		False	List of team IDs associated with all owner properties of the lead, excluding hierarchy.
Associated Company Domain	String	True		True	Domain name of the company associated with the lead, if available.
Associated Company Name	String	True		True	Company name linked to the lead, if available.
Associated Contact Email	String	True		True	Email address of the primary contact associated with the lead, if available.
Associated Contact First Name	String	True		True	First name of the primary contact associated with the lead, if available.
Associated Contact Last Name	String	True		True	Last name of the primary contact associated with the lead, if available.
Calls Connected Count	String	True		True	Total number of calls made to the lead that resulted in a successful connection.
Primary company analytics source	String	True		True	Most recent analytics source from the primary associated company at the time the company was linked to the lead. This value does not update after creation.
Primary company analytics source first drilldown	String	True		True	First level of analytics source detail for the primary company associated with the lead. This value does not update after creation.
Primary company analytics source second drilldown	String	True		True	Second level of analytics source detail for the primary company associated with the lead. This value does not update after creation.
Company Avatar FileManager key	String	True		False	Path to the custom avatar image of the associated company, stored in HubSpot's FileManager.
Is Target Account	String	True		True	Indicates whether the associated company is flagged as a target account for marketing or sales purposes.
Company Last Activity Date	Datetime	True		True	Most recent activity date recorded for the primary associated company.
Company Last Engagement Date	Datetime	True		True	Most recent tracked engagement by a contact at the associated company. Excludes marketing emails and bulk communications.
Company Last Engagement Type	String	True		False	Type of the last tracked engagement performed by a contact at the associated company. Excludes marketing and mass emails.
Company Time of Last Session	Datetime	True		True	Timestamp for the most recent web session attributed to any contacts associated with the primary company.
Company Next Activity Date	Datetime	True		True	Scheduled date of the next activity associated with the primary company.
Company Next Activity Type	String	True		False	Type of the next scheduled activity related to the primary associated company.
Company Number of Pageviews	String	True		True	Total number of website pageviews from all contacts linked to the primary associated company.
Associated company timezone	String	True		True	Timezone of the primary associated company, if available.
Primary contact analytics source	String	True		True	Most recent analytics source from the primary contact at the time of association with the lead. This value does not update after creation.
Primary contact analytics source first drilldown	String	True		True	First level of analytics source detail from the primary contact associated with the lead. This value does not update after creation.
Primary contact analytics source second drilldown	String	True		True	Second level of analytics source detail from the primary contact associated with the lead. This value does not update after creation.
Contact Avatar FileManager key	String	True		False	Path to the custom avatar image of the associated contact, stored in HubSpot's FileManager.
Contact Buying Role	String	True		True	Role of the associated contact in the buying or decision-making process.
Associated contact job title	String	True		True	Job title of the associated contact, if available.
Contact Last Activity Date	Datetime	True		True	Date of the last recorded activity performed by the associated contact.
Contact Last Engagement Date	Datetime	True		True	Date the contact last engaged with your website or tracked interactions. Excludes marketing emails and bulk communications.
Contact Last Engagement Type	String	True		False	Type of last engagement performed by the contact, excluding marketing and mass emails.
Contact Time of Last Session	Datetime	True		True	Timestamp of the most recent website session initiated by the lead's primary contact.
Contact Next Activity Date	Datetime	True		True	Scheduled date of the next activity planned for the lead's primary contact.
Contact Next Activity Type	String	True		False	Type of the next scheduled activity for the primary contact, such as a call or meeting.
Contact Number of Pageviews	String	True		True	Total number of website pageviews recorded for the lead's primary contact.
Associated contact timezone	String	True		True	Timezone of the primary associated contact, if available.
Created by user ID	Decimal	True		True	HubSpot user ID of the individual who created the lead record. Automatically assigned by HubSpot.
Object create date/time	Datetime	True		True	Date and time when the lead object was created in HubSpot. Automatically generated.
Emails Connected Count	String	True		True	Number of email interactions with the lead that resulted in a successful connection.
Initial Assign Notification State	String	True		False	Status indicating whether an initial assignment notification was sent when the lead was created.
Last Activity Date	Datetime	True		True	Most recent activity date for the lead, defaulting to the associated contact if available, otherwise the associated company.
Last Engagement Date	Datetime	True		True	Most recent engagement date for the lead, based on either the primary contact or associated company.
Last Engagement Type	String	True		False	Type of last engagement for the lead, prioritizing the primary contact, or otherwise the associated company.
Lead Time of Last Session	Datetime	True		True	Timestamp of the last recorded session by the primary associated contact or, if unavailable, the associated company.
Object last modified date/time	Datetime	True		True	Most recent timestamp of any update made to the lead object, including internal property changes.
Associated Deal Pipeline Stage	String	True		False	Sales pipeline stage of the primary associated deal linked to the lead.
Associated deals	Decimal	True		True	Total number of deals associated with the lead.
Call Count	Decimal	True		True	Total number of calls logged against the lead.
Closed won deal amount	Decimal	True		True	Total monetary value of all closed-won deals associated with the lead.
Message Thread Count	Decimal	True		True	Total number of message threads (such as SMS, LinkedIn, or WhatsApp) involving the lead.
Currency	String	True		False	Currency code associated with the most recent deal linked to the lead.
Lead Disqualification Note	String	False		True	Free-text note explaining why the lead was disqualified.
Disqualification Reason	String	False		False	Dropdown field listing the reason for lead disqualification.
Email Count	Decimal	True		True	Total number of emails sent to the lead.
First Outreach Date	Datetime	True		True	Date of the first recorded outreach (such as a call, email, or meeting) initiated toward the lead.
Lead Inferred Pseudostage	String	True		True	Inferred lead pipeline pseudostage based on the lead's activities and interactions.
Is Disqualified	Decimal	True		True	Flag indicating whether the lead is disqualified (1 = yes, 0 = no). Used for internal reporting.
In progress leads	Decimal	True		True	Flag indicating whether the lead is actively being worked on (1 = yes, 0 = no). Used for reporting.
Is New	Decimal	True		True	Flag indicating whether the lead is newly created (1 = yes, 0 = no). Used internally for reporting.
Open leads	Decimal	True		True	Indicates whether the lead is in an open stage, meaning not yet qualified or disqualified.
Is Qualified	Decimal	True		True	Flag indicating whether the lead has been qualified (1 = yes, 0 = no). Used for reporting purposes.
Lead Label	String	False		False	Current sales status label assigned to the lead.
Meeting Count	Decimal	True		True	Total number of meetings booked with the lead.
Lead Name	String	False		True	Full name of the lead, as entered in HubSpot.
Lead name calculated	String	True		True	Automatically calculated full name for the lead based on associated contact properties.
Outreach activity count	Decimal	True		True	Total number of outbound activities (calls, emails, meetings, or other communications) performed toward the lead.
Open deal amount	Decimal	True		True	Combined value of all currently open deals associated with the lead.
Primary Company Owner	String	True		False	Owner ID of the primary associated company linked to the lead.
Primary Contact Owner	String	True		False	Owner ID of the primary associated contact linked to the lead.
Lead Source	String	True		False	Analytics source indicating how the lead was originally acquired, based on associated contact or company.
Initial company lifecycle stage	String	True		True	First recorded lifecycle stage of the primary associated company when linked to the lead. This value does not update.
Initial contact lifecycle stage	String	True		True	First recorded lifecycle stage of the primary associated contact when linked to the lead. This value does not update.
Lead Source DrillDown 1	String	True		True	Second tier of detail about how the lead was sourced.
Lead Source DrillDown 2	String	True		True	Third tier of detail about how the lead was sourced.
Initial source lifecycle stage	String	True		True	Lifecycle stage of the associated contact or company at the time of the lead's creation.
Time to First Touch	Decimal	True		True	Elapsed time between lead creation and first outreach activity logged against the lead.
Lead Title (DEPRECATEDUse hsLeadName)	String	True		True	Deprecated lead title field. Use hsLeadName instead.
Lead Type	String	False		False	Categorization of the lead, such as New Business, Existing Business, or Re-attempting.
Meetings Connected Count	String	True		True	Total number of meetings associated with the lead that were considered connected.
Merged record IDs	String	True		False	List of record IDs that have been merged into this lead record. Automatically generated by HubSpot.
Next Activity Date	Datetime	True		True	Scheduled date of the next activity, prioritized by the primary contact or associated company.
Next Activity Type	String	True		False	Type of the next scheduled activity, based on the primary associated contact or company.
Lead Number of Pageviews	Decimal	True		True	Number of website pageviews recorded for the primary contact or, if unavailable, for the associated company.
Record ID	Decimal	True		True	Unique HubSpot-generated ID assigned to the lead record.
Record Creation Source	String	True		True	Internal metadata field indicating the source system where the lead record originated.
Record Source Detail 1	String	True		True	Primary detail level describing how the lead record was created.
Record Source Detail 2	String	True		True	Secondary detail level describing how the lead record was created.
Record Source Detail 3	String	True		True	Tertiary detail level describing how the lead record was created.
Record Creation Source ID	String	True		True	Internal source ID representing how the lead record was created.
Record Source	String	True		False	Summary of the creation method for the lead record, based on internal metadata.
Record Creation Source User ID	Decimal	True		True	User ID associated with the creation of the lead, if available.
Lead owner calculated	String	True		False	Automatically determined owner of the lead, based on ownership of the primary contact or company.
Lead Pipeline	String	False		False	Pipeline in which the lead is currently categorized.
Lead Pipeline Stage	String	False		False	Current stage of the lead within its assigned pipeline.
Pipeline Stage Category	String	True		True	Category assigned to the lead's current pipeline stage for segmentation purposes.
Pipeline Stage Category Last Updated At	Datetime	True		True	Timestamp marking the most recent update to the lead's pipeline stage category.
Primary Associated Object Name	String	True		True	Name of the primary associated contact or company linked to the lead.
Primary Associated Company Object ID	Decimal	False		True	HubSpot object ID of the primary associated company connected to the lead.
Primary contact enrolled in sequence	Bool	True		True	Indicates whether the lead's primary associated contact is currently enrolled in a HubSpot sequence.
Primary Associated Contact Object ID	Decimal	False		True	HubSpot object ID of the primary associated contact linked to the lead.
Read Only Object	Bool	True		True	Indicates whether the lead record is read-only and cannot be modified.
Shared Team IDs	String	True		False	List of team IDs with shared access to the lead record.
Shared User IDs	String	True		False	List of user IDs with shared access permissions to the lead record.
Lead tags	String	True		False	List of tag IDs automatically assigned to the lead for segmentation or categorization.
Time in Attempting (Lead Pipeline)	Decimal	True		False	Total time in seconds that the lead spent in the 'Attempting' stage of the 'Lead pipeline'.
Time in Connected (Lead Pipeline)	Decimal	True		False	Total time in seconds that the lead spent in the 'Connected' stage of the 'Lead pipeline'.
Time in New (Lead Pipeline)	Decimal	True		False	Total time in seconds that the lead spent in the 'New' stage of the 'Lead pipeline'.
Time in Qualified (Lead Pipeline)	Decimal	True		False	Total time in seconds that the lead spent in the 'Qualified' stage of the 'Lead pipeline'.
Time in Disqualified (Lead Pipeline)	Decimal	True		False	Total time in seconds that the lead spent in the 'Disqualified' stage of the 'Lead pipeline'.
Unique creation key	String	True		True	Unique property used for idempotent creation of lead records to prevent duplication.
Updated by user ID	Decimal	True		True	User ID of the person who most recently updated the lead record. Automatically managed by HubSpot.
User IDs of all notification followers	String	True		False	List of user IDs who chose to follow this lead and receive notifications.
User IDs of all notification unfollowers	String	True		False	List of user IDs who opted out of receiving notifications for this lead.
User IDs of all owners	String	True		False	List of all user IDs assigned as owners of the lead record.
Cumulative time in Attempting (Lead pipeline)	Decimal	True		True	Cumulative total time spent by the lead in the 'Attempting' stage of the 'Lead pipeline'.
Cumulative time in Connected (Lead pipeline)	Decimal	True		True	Cumulative total time spent by the lead in the 'Connected' stage of the 'Lead pipeline'.
Cumulative time in New (Lead pipeline)	Decimal	True		True	Cumulative total time spent by the lead in the 'New' stage of the 'Lead pipeline'.
Cumulative time in Qualified (Lead pipeline)	Decimal	True		True	Cumulative total time spent by the lead in the 'Qualified' stage of the 'Lead pipeline'.
Cumulative time in Disqualified (Lead pipeline)	Decimal	True		True	Cumulative total time spent by the lead in the 'Disqualified' stage of the 'Lead pipeline'.
Date entered Attempting (Lead pipeline)	Datetime	True		True	Date and time when the lead entered the 'Attempting' stage of the 'Lead pipeline'.
Date entered Connected (Lead pipeline)	Datetime	True		True	Date and time when the lead entered the 'Connected' stage of the 'Lead pipeline'.
Date entered New (Lead pipeline)	Datetime	True		True	Date and time when the lead entered the 'New' stage of the 'Lead pipeline'.
Date entered Qualified (Lead pipeline)	Datetime	True		True	Date and time when the lead entered the 'Qualified' stage of the 'Lead pipeline'.
Date entered Disqualified (Lead pipeline)	Datetime	True		True	Date and time when the lead entered the 'Disqualified' stage of the 'Lead pipeline'.
Date exited Attempting (Lead pipeline)	Datetime	True		True	Date and time when the lead exited the 'Attempting' stage of the 'Lead pipeline'.
Date exited Connected (Lead pipeline)	Datetime	True		True	Date and time when the lead exited the 'Connected' stage of the 'Lead pipeline'.
Date exited New (Lead pipeline)	Datetime	True		True	Date and time when the lead exited the 'New' stage of the 'Lead pipeline'.
Date exited Qualified (Lead pipeline)	Datetime	True		True	Date and time when the lead exited the 'Qualified' stage of the 'Lead pipeline'.
Date exited Disqualified (Lead pipeline)	Datetime	True		True	Date and time when the lead exited the 'Disqualified' stage of the 'Lead pipeline'.
Latest time in Attempting (Lead pipeline)	Decimal	True		True	Total time in seconds spent in the 'Attempting' stage since the last time the lead entered it.
Latest time in Connected (Lead pipeline)	Decimal	True		True	Total time in seconds spent in the 'Connected' stage since the last time the lead entered it.
Latest time in New (Lead pipeline)	Decimal	True		True	Total time in seconds spent in the 'New' stage since the last time the lead entered it.
Latest time in Qualified (Lead pipeline)	Decimal	True		True	Total time in seconds spent in the 'Qualified' stage since the last time the lead entered it.
Latest time in Disqualified (Lead pipeline)	Decimal	True		True	Total time in seconds spent in the 'Disqualified' stage since the last time the lead entered it.
Performed in an import	Bool	True		True	Indicates whether the lead record was created as part of a data import process.
Workflow updated lifecycle stage of company	Bool	False		True	Indicates whether a workflow automatically updated the lifecycle stage of the associated company.
Workflow updated lifecycle stage of contact	Bool	False		True	Indicates whether a workflow automatically updated the lifecycle stage of the associated contact.
Owner Assigned Date	Datetime	True		True	Date and time when ownership of the lead was most recently assigned or changed.
Lead Owner	String	False		True	Primary owner assigned to the lead. Defaults to the primary contact's owner or, if not available, the company's owner.
HubSpot Team	String	True		False	Primary HubSpot team associated with the owner of the lead.