Companies

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

Table Specific Information

In HubSpot, company records store information about a business or organization.

SELECT

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

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

INSERT

INSERT INTO Companies ([About Us]) VALUES ('description')

UPDATE

UPDATE Companies SET [About Us] = 'new description' WHERE ID = '3917882265'

DELETE

DELETE FROM Companies WHERE ID = '3917882265'

Columns


Name	Type	ReadOnly	References	Filterable	Description
Id [KEY]	Long	False		True	Unique numeric identifier for the company record.
Archived	Bool	True		True	Indicates whether the company record is archived and no longer actively managed.
CreatedAt	Datetime	True		False	Timestamp marking when the company record was first created in HubSpot.
UpdatedAt	Datetime	True		False	Timestamp of the most recent update made to the company record.
ItemURL	String	True		False	Direct URL linking to the company's record within HubSpot for quick access.
About Us	String	False		False	Short description or mission statement summarizing the company's purpose.
ClosedateTimestampEarliestValue	Datetime	True		False	Earliest closed deal date across all contacts associated with the company, calculated via rollup.
Facebook Fans	Decimal	False		False	Total number of Facebook followers or fans associated with the company's official page.
FirstContactCreatedateTimestampEarliestValue	Datetime	True		False	Timestamp of the earliest contact creation date linked to this company, calculated via rollup.
First Conversion Date	Datetime	True		False	Date of the first conversion event (such as a form submission) across any contact associated with the company.
FirstConversionDateTimestampEarliestValue	Datetime	True		False	Timestamp showing the earliest recorded conversion date across contacts associated with the company.
First Conversion	String	True		False	The first form or event that a contact associated with the company converted on.
FirstConversionEventNameTimestampEarliestValue	Datetime	True		False	Timestamp of the earliest recorded first conversion event name for contacts associated with this company.
First Deal Created Date	Datetime	True		False	Date when the first deal was created and linked to the company.
Year Founded	String	False		False	Year when the company was founded, sourced automatically by HubSpot Insights.
Additional Domains	String	False		False	List of additional domains owned by the company, if applicable.
Business units	String	False		False	Business units assigned to the company for segmentation and reporting.
Time First Seen	Datetime	True		False	Timestamp of the first recorded activity by any contact associated with the company.
HsAnalyticsFirstTimestampTimestampEarliestValue	Datetime	True		False	Earliest timestamp for a recorded activity across contacts associated with the company, based on rollup.
First Touch Converting Campaign	String	True		False	Marketing campaign responsible for the first touch conversion of the first associated contact.
HsAnalyticsFirstTouchConvertingCampaignTimestampEarliestValue	Datetime	True		False	Timestamp showing the earliest first-touch converting campaign across associated contacts.
Time of First Session	Datetime	True		False	Timestamp of the first session logged by any contact linked to the company.
HsAnalyticsFirstVisitTimestampTimestampEarliestValue	Datetime	True		False	Earliest recorded timestamp for the first session involving any associated contact.
Time Last Seen	Datetime	True		False	Timestamp of the most recent activity recorded by any contact associated with the company.
HsAnalyticsLastTimestampTimestampLatestValue	Datetime	True		False	Latest recorded activity timestamp across associated contacts, aggregated through rollup.
Last Touch Converting Campaign	String	True		False	Marketing campaign responsible for the last-touch conversion of the first associated contact.
HsAnalyticsLastTouchConvertingCampaignTimestampLatestValue	Datetime	True		False	Timestamp of the most recent last-touch converting campaign across associated contacts.
Time of Last Session	Datetime	True		False	Timestamp of the most recent session logged by any contact associated with the company.
HsAnalyticsLastVisitTimestampTimestampLatestValue	Datetime	True		False	Timestamp providing the latest session recorded across all associated contacts.
Latest Source	String	True		False	Source of the most recent session recorded by contacts linked to the company, such as Direct Traffic or Paid Social.
Latest Source Data 1	String	True		False	Additional details about the source of the most recent session for associated contacts.
Latest Source Data 2	String	True		False	Further descriptive details regarding the latest session source for contacts linked to the company.
Latest Source Timestamp	Datetime	True		False	Timestamp showing when the most recent source interaction occurred across associated contacts.
Number of Pageviews	Decimal	True		False	Total number of website pageviews recorded across contacts associated with the company.
HsAnalyticsNumPageViewsCardinalitySum	Decimal	True		False	Aggregated total pageviews for all associated contacts, calculated by summing rollups.
Number of Sessions	Decimal	True		False	Total number of website sessions recorded across contacts linked to the company.
HsAnalyticsNumVisitsCardinalitySum	Decimal	True		False	Aggregated number of sessions across all associated contacts, based on a rollup calculation.
Original Source Type	String	False		False	Original source category for the earliest recorded activity by a contact associated with the company, such as Organic Search or Direct Traffic.
Original Source Data 1	String	True		False	Additional descriptive information related to the original source for the earliest recorded activity.
HsAnalyticsSourceData1TimestampEarliestValue	Datetime	True		False	Timestamp for the earliest occurrence of original source data 1 across associated contacts.
Original Source Data 2	String	True		False	Supplementary descriptive information providing more context about the original source of the earliest contact activity.
HsAnalyticsSourceData2TimestampEarliestValue	Datetime	True		False	Timestamp for the earliest occurrence of original source data 2 across associated contacts.
HsAnalyticsSourceTimestampEarliestValue	Datetime	True		False	Earliest timestamp indicating when the original source type was recorded for any associated contact.
Avatar FileManager key	String	True		False	Path to the company's avatar image stored in HubSpot's FileManager CDN. Set automatically.
Created by user ID	Decimal	True		False	ID of the user who originally created the company record. Automatically assigned by HubSpot.
Object create date_time	Datetime	True		False	Timestamp of the company's creation. Automatically populated and not manually editable.
Date entered Customer (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company entered the 'Customer' stage of the Lifecycle Stage Pipeline.
Date entered Evangelist (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company entered the 'Evangelist' stage of the Lifecycle Stage Pipeline.
Date entered Lead (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company entered the 'Lead' stage of the Lifecycle Stage Pipeline.
Date entered Marketing Qualified Lead (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company entered the 'Marketing Qualified Lead' stage of the Lifecycle Stage Pipeline.
Date entered Opportunity (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company entered the 'Opportunity' stage of the Lifecycle Stage Pipeline.
Date entered Other (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company entered the 'Other' stage of the Lifecycle Stage Pipeline.
Date entered Sales Qualified Lead (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company entered the 'Sales Qualified Lead' stage of the Lifecycle Stage Pipeline.
Date entered Subscriber (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company entered the 'Subscriber' stage of the Lifecycle Stage Pipeline.
Date exited Customer (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company exited the 'Customer' stage of the Lifecycle Stage Pipeline.
Date exited Evangelist (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company exited the 'Evangelist' stage of the Lifecycle Stage Pipeline.
Date exited Lead (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company exited the 'Lead' stage of the Lifecycle Stage Pipeline.
Date exited Marketing Qualified Lead (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company exited the 'Marketing Qualified Lead' stage of the Lifecycle Stage Pipeline.
Date exited Opportunity (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company exited the 'Opportunity' stage of the Lifecycle Stage Pipeline.
Date exited Other (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company exited the 'Other' stage of the Lifecycle Stage Pipeline.
Date exited Sales Qualified Lead (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company exited the 'Sales Qualified Lead' stage of the Lifecycle Stage Pipeline.
Date exited Subscriber (Lifecycle Stage Pipeline)	Datetime	True		False	Date and time when the company exited the 'Subscriber' stage of the Lifecycle Stage Pipeline.
Ideal Customer Profile Tier	String	False		False	Classification of how closely the company matches your Ideal Customer Profile, typically Tier 1, Tier 2, or Tier 3.
Target Account	Bool	False		False	Indicates whether the company is designated as a target account for account-based marketing efforts.
Last Booked Meeting Date	Datetime	True		False	Date when the most recent meeting was booked with any contact associated with the company.
Last Logged Call Date	Datetime	True		False	Date when the most recent call was logged for any contact linked to the company.
Last Open Task Date	Datetime	True		False	Due date of the most recently opened task assigned to the company or associated contacts.
last sales activity date old	Datetime	True		False	Timestamp in seconds of the most recent sales activity involving the company. Used in legacy tracking.
Last Engagement Date	Datetime	True		False	Timestamp of the most recent engagement action, such as a form submission or meeting, excluding marketing emails.
Last Engagement Type	String	True		False	Type of the most recent engagement performed by a contact at the company, excluding bulk marketing emails.
Last Modified Date	Datetime	True		False	Timestamp of the latest property update made to the company record, including hidden and visible properties.
Latest create date of active subscriptions	Datetime	True		False	Timestamp when the most recent active subscription linked to this company was created.
Merged object IDs	String	True		False	List of company record IDs that have been merged into this record. Set automatically by HubSpot.
Number of blockers	Decimal	True		False	Total number of associated contacts at this company who are classified as blockers in the sales process.
Number of contacts with a buying role	Decimal	True		False	Total number of contacts associated with this company who have a designated buying role.
Number of decision makers	Decimal	True		False	Total number of contacts linked to this company who are marked as decision makers.
Number of open deals	Decimal	True		False	Total number of open deals currently associated with this company.
Record ID	Decimal	True		False	Unique ID assigned automatically to the company record in HubSpot.
Pinned Engagement ID	Decimal	True		False	ID of the engagement pinned at the top of the company's timeline for easy reference. Set automatically.
Pipeline	String	False		False	Pipeline associated with the company, often used for account-based sales processes.
Likelihood to close	Decimal	True		False	Calculated probability that a contact linked to this company will convert to a customer within the next 90 days.
HsPredictivecontactscoreV2NextMaxMax	Decimal	True		False	Maximum predictive lead score aggregated from all contacts associated with this company.
Read Only Object	Bool	True		False	Indicates whether this company record is read-only and cannot be manually edited.
Target Account2	String	False		False	Secondary field indicating target account status based on different account-based marketing programs.
Target Account Probability	Decimal	True		False	Probability score indicating how likely the company is to qualify as a target account.
Target Account Recommendation Snooze Time	Datetime	False		False	Timestamp recording when a recommendation to target this company was snoozed.
Target Account Recommendation State	String	False		False	Current recommendation status for targeting the company, such as Active or Snoozed.
Time in Customer (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the company spent in the 'Customer' stage of the Lifecycle Stage Pipeline.
Time in Evangelist (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the company spent in the 'Evangelist' stage of the Lifecycle Stage Pipeline.
Time in Lead (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the company spent in the 'Lead' stage of the Lifecycle Stage Pipeline.
Time in Marketing Qualified Lead (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the company spent in the 'Marketing Qualified Lead' stage of the Lifecycle Stage Pipeline.
Time in Opportunity (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the company spent in the 'Opportunity' stage of the Lifecycle Stage Pipeline.
Time in Other (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the company spent in the 'Other' stage of the Lifecycle Stage Pipeline.
Time in Sales Qualified Lead (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the company spent in the 'Sales Qualified Lead' stage of the Lifecycle Stage Pipeline.
Time in Subscriber (Lifecycle Stage Pipeline)	Decimal	True		False	Total time in seconds the company spent in the 'Subscriber' stage of the Lifecycle Stage Pipeline.
Total open deal value	Decimal	True		False	Sum of the values of all open deals linked to the company, calculated in the company's default currency.
Unique creation key	String	True		False	Property used to uniquely identify the company during import or integration processes to avoid duplicates.
Updated by user ID	Decimal	True		False	User ID of the last user who updated the company record. Set automatically by HubSpot.
User IDs of all notification followers	String	True		False	List of user IDs who opted to receive notifications about updates to this company.
User IDs of all notification unfollowers	String	True		False	List of user IDs who opted out of receiving notifications about updates to this company.
User IDs of all owners	String	True		False	List of all owner user IDs assigned to this company.
Owner Assigned Date	Datetime	True		False	Timestamp of the most recent assignment of an owner to this company record.
Is Public	Bool	False		False	Indicates whether the company is publicly traded, as determined by HubSpot Insights or user input.
Number of Associated Contacts	Decimal	True		False	Total number of contact records currently linked to this company.
Number of Associated Deals	Decimal	True		False	Total number of deal records currently associated with this company.
Number of Form Submissions	Decimal	True		False	Total number of form submissions completed by contacts associated with this company.
NumConversionEventsCardinalitySum	Decimal	True		False	Aggregated sum of all conversion events across contacts linked to this company, calculated via rollup.
Recent Conversion Date	Datetime	True		False	Most recent date a conversion event, such as a form submission, was completed by a contact associated with the company.
RecentConversionDateTimestampLatestValue	Datetime	True		False	Timestamp of the most recent conversion event aggregated across all associated contacts.
Recent Conversion	String	True		False	Name of the most recent form or event submitted by a contact associated with this company.
RecentConversionEventNameTimestampLatestValue	Datetime	True		False	Timestamp of the latest recorded event name for a recent conversion associated with this company.
Recent Deal Amount	Decimal	True		False	Monetary amount of the most recently closed deal associated with the company.
Recent Deal Close Date	Datetime	True		False	Date when the most recent deal associated with this company was marked as closed-won.
Time Zone	String	False		False	Time zone associated with the company's primary address, populated via HubSpot Insights if available.
Total Money Raised	String	False		False	Total amount of capital raised by the company, based on external data sources such as HubSpot Insights.
Total Revenue	Decimal	True		False	Sum of all revenue from closed-won deals associated with the company.
Company name	String	False		False	Official name of the company as stored in HubSpot.
HubSpot Owner Email	String	False		False	Email address of the HubSpot user assigned as the primary owner of the company.
Twitter Handle	String	False		False	Primary Twitter username or handle associated with the company.
HubSpot Owner Name	String	False		False	Full name of the HubSpot user assigned as the company's owner.
Phone Number	String	False		False	Primary phone number for the company, typically populated from HubSpot Insights or manually entered.
Twitter Bio	String	False		False	Biography text pulled from the company's Twitter profile.
Twitter Followers	Decimal	False		False	Total number of followers on the company's official Twitter account.
Street Address	String	False		False	Street address of the company, including building, suite, or unit number if applicable.
Street Address 2	String	False		False	Additional address information for the company such as a second line for building or floor information.
Facebook Company Page	String	False		False	URL link to the company's official Facebook page.
City	String	False		False	City where the company's headquarters or main office is located.
LinkedIn Company Page	String	False		False	URL link to the company's LinkedIn page.
LinkedIn Bio	String	False		False	Company description as displayed on its LinkedIn profile.
State_Region	String	False		False	State, province, or region where the company is located.
Google Plus Page	String	False		False	URL link to the company's Google Plus page (historical, for older records).
Date of last meeting booked in meetings tool	Datetime	True		False	Date of the last meeting scheduled by an associated contact via HubSpot's meetings tool.
Campaign of last booking in meetings tool	String	True		False	UTM campaign parameter representing the marketing campaign that led to the last meeting booked.
Medium of last booking in meetings tool	String	True		False	UTM medium parameter indicating the marketing channel, such as email or social media, responsible for the last meeting booking.
Source of last booking in meetings tool	String	True		False	UTM source parameter indicating the site or platform, such as LinkedIn or Twitter, that referred the contact for their most recent meeting.
Latest meeting activity	Datetime	True		False	Timestamp of the most recent meeting—past or upcoming—logged, booked, or scheduled with any contact at the company.
Recent Sales Email Replied Date	Datetime	True		False	Date when the most recent reply to a tracked sales email was received from the company.
Company owner	String	False		False	Name of the HubSpot user assigned as the owner of the company record.
Last Contacted	Datetime	True		False	Timestamp when the last call, one-to-one email, or meeting was logged for this company.
Last Activity Date	Datetime	True		False	Timestamp when the most recent note, call, email, meeting, or task was logged for the company.
Next Activity Date	Datetime	True		False	Scheduled date for the next sales activity associated with this company, such as a call or meeting.
Number of times contacted	Decimal	True		False	Total number of communication attempts, such as calls, emails, or meetings, logged for the company.
Number of Sales Activities	Decimal	True		False	Total number of sales-related activities recorded for the company, including calls and meetings.
Postal Code	String	False		False	Postal or ZIP code associated with the company's primary business address.
Country_Region	String	False		False	Country or region where the company's main office is located.
HubSpot Team	String	True		False	Name of the HubSpot team assigned to the company's primary owner.
All owner ids	String	True		False	List of owner property IDs, including default and custom, assigned to the company.
Website URL	String	False		False	Official website URL of the company, used for engagement and deduplication purposes.
Company Domain Name	String	False		False	Primary domain name associated with the company, used to link records and deduplicate companies.
All team ids	String	True		False	List of team IDs associated with ownership of the company, including default and custom teams.
All accessible team ids	String	True		False	List of team IDs, including inherited teams, that can access the company's ownership properties.
Number of Employees	Decimal	False		False	Total number of employees working at the company, based on HubSpot Insights or user entry.
Industry	String	False		False	Industry sector in which the company operates, based on predefined categories or custom entries.
Annual Revenue	Decimal	False		False	Annual revenue generated by the company, either provided manually or sourced from HubSpot Insights.
Lifecycle Stage	String	False		False	Stage representing the company's current sales or marketing qualification, such as Lead, Customer, or Evangelist.
Lead Status	String	False		False	Sales status assigned to the company, typically used during prospecting and qualification processes.
Parent Company	Decimal	True		False	Record ID of the parent company associated with this company if part of a corporate hierarchy.
Type	String	False		False	Optional classification indicating the type of company, such as Partner, Prospect, Customer, or Reseller.
Description	String	False		False	Brief narrative or summary describing the company's business or background.
Number of child companies	Decimal	True		False	Number of child company records linked to this parent company record.
HubSpot Score	Decimal	True		False	Score representing the company's sales-readiness, calculated based on engagement and profile attributes.
Create Date	Datetime	True		False	Timestamp marking when the company was created in HubSpot.
Close Date	Datetime	False		False	Date when the company was marked as a customer within HubSpot.
First Contact Create Date	Datetime	True		False	Date when the first contact associated with this company was created.
Days to Close	Decimal	True		False	Number of days elapsed between when the company record was created and when it was marked as a customer.
Web Technologies	String	False		False	List of web technologies detected on the company's website, such as CRM platforms, marketing tools, or analytics services.