Tableau Connector for HubSpot

Build 25.0.9434

Companies

Retrieves company records available 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, 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 Companies WHERE [Associated Deals] > 1 AND [Recent Deal Close Date] < '2020-01-31'
SELECT * FROM Companies WHERE [Associated Contacts] < 50 OR [Last Contacted] > '2020-01-01 15:00:00'

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 Companies WHERE {Column} = {Value} AND {Column} < {Value} AND {Column} > {Value}
SELECT * FROM Companies WHERE {Column} != {Value} AND {Column} >= {Value} AND {Column} <= {Value} AND {Column} = {Value}
SELECT * FROM Companies WHERE ({Column} = {Value} AND {Column} = {Value}) OR ({Column} != {Value} AND {Column} >= {Value})
SELECT * FROM Companies 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


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 True True

Unique numeric identifier for the company record.

Archived Bool True False

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 True

Short description or mission statement summarizing the company's purpose.

ClosedateTimestampEarliestValue Datetime True True

Earliest closed deal date across all contacts associated with the company, calculated via rollup.

Facebook Fans Decimal False True

Total number of Facebook followers or fans associated with the company's official page.

FirstContactCreatedateTimestampEarliestValue Datetime True True

Timestamp of the earliest contact creation date linked to this company, calculated via rollup.

First Conversion Date Datetime True True

Date of the first conversion event (such as a form submission) across any contact associated with the company.

FirstConversionDateTimestampEarliestValue Datetime True True

Timestamp showing the earliest recorded conversion date across contacts associated with the company.

First Conversion String True True

The first form or event that a contact associated with the company converted on.

FirstConversionEventNameTimestampEarliestValue Datetime True True

Timestamp of the earliest recorded first conversion event name for contacts associated with this company.

First Deal Created Date Datetime True True

Date when the first deal was created and linked to the company.

Year Founded String False True

Year when the company was founded, sourced automatically by HubSpot Insights.

Additional Domains String False True

List of additional domains owned by the company, if applicable.

Business units String False True

Business units assigned to the company for segmentation and reporting.

Time First Seen Datetime True True

Timestamp of the first recorded activity by any contact associated with the company.

HsAnalyticsFirstTimestampTimestampEarliestValue Datetime True True

Earliest timestamp for a recorded activity across contacts associated with the company, based on rollup.

First Touch Converting Campaign String True True

Marketing campaign responsible for the first touch conversion of the first associated contact.

HsAnalyticsFirstTouchConvertingCampaignTimestampEarliestValue Datetime True True

Timestamp showing the earliest first-touch converting campaign across associated contacts.

Time of First Session Datetime True True

Timestamp of the first session logged by any contact linked to the company.

HsAnalyticsFirstVisitTimestampTimestampEarliestValue Datetime True True

Earliest recorded timestamp for the first session involving any associated contact.

Time Last Seen Datetime True True

Timestamp of the most recent activity recorded by any contact associated with the company.

HsAnalyticsLastTimestampTimestampLatestValue Datetime True True

Latest recorded activity timestamp across associated contacts, aggregated through rollup.

Last Touch Converting Campaign String True True

Marketing campaign responsible for the last-touch conversion of the first associated contact.

HsAnalyticsLastTouchConvertingCampaignTimestampLatestValue Datetime True True

Timestamp of the most recent last-touch converting campaign across associated contacts.

Time of Last Session Datetime True True

Timestamp of the most recent session logged by any contact associated with the company.

HsAnalyticsLastVisitTimestampTimestampLatestValue Datetime True True

Timestamp providing the latest session recorded across all associated contacts.

Latest Source String True True

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 True

Additional details about the source of the most recent session for associated contacts.

Latest Source Data 2 String True True

Further descriptive details regarding the latest session source for contacts linked to the company.

Latest Source Timestamp Datetime True True

Timestamp showing when the most recent source interaction occurred across associated contacts.

Number of Pageviews Decimal True True

Total number of website pageviews recorded across contacts associated with the company.

HsAnalyticsNumPageViewsCardinalitySum Decimal True True

Aggregated total pageviews for all associated contacts, calculated by summing rollups.

Number of Sessions Decimal True True

Total number of website sessions recorded across contacts linked to the company.

HsAnalyticsNumVisitsCardinalitySum Decimal True True

Aggregated number of sessions across all associated contacts, based on a rollup calculation.

Original Source Type String False True

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 True

Additional descriptive information related to the original source for the earliest recorded activity.

HsAnalyticsSourceData1TimestampEarliestValue Datetime True True

Timestamp for the earliest occurrence of original source data 1 across associated contacts.

Original Source Data 2 String True True

Supplementary descriptive information providing more context about the original source of the earliest contact activity.

HsAnalyticsSourceData2TimestampEarliestValue Datetime True True

Timestamp for the earliest occurrence of original source data 2 across associated contacts.

HsAnalyticsSourceTimestampEarliestValue Datetime True True

Earliest timestamp indicating when the original source type was recorded for any associated contact.

Avatar FileManager key String True True

Path to the company's avatar image stored in HubSpot's FileManager CDN. Set automatically.

Created by user ID Decimal True True

ID of the user who originally created the company record. Automatically assigned by HubSpot.

Object create date_time Datetime True True

Timestamp of the company's creation. Automatically populated and not manually editable.

Date entered Customer (Lifecycle Stage Pipeline) Datetime True True

Date and time when the company entered the 'Customer' stage of the Lifecycle Stage Pipeline.

Date entered Evangelist (Lifecycle Stage Pipeline) Datetime True True

Date and time when the company entered the 'Evangelist' stage of the Lifecycle Stage Pipeline.

Date entered Lead (Lifecycle Stage Pipeline) Datetime True True

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 True

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 True

Date and time when the company entered the 'Opportunity' stage of the Lifecycle Stage Pipeline.

Date entered Other (Lifecycle Stage Pipeline) Datetime True True

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 True

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 True

Date and time when the company entered the 'Subscriber' stage of the Lifecycle Stage Pipeline.

Date exited Customer (Lifecycle Stage Pipeline) Datetime True True

Date and time when the company exited the 'Customer' stage of the Lifecycle Stage Pipeline.

Date exited Evangelist (Lifecycle Stage Pipeline) Datetime True True

Date and time when the company exited the 'Evangelist' stage of the Lifecycle Stage Pipeline.

Date exited Lead (Lifecycle Stage Pipeline) Datetime True True

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 True

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 True

Date and time when the company exited the 'Opportunity' stage of the Lifecycle Stage Pipeline.

Date exited Other (Lifecycle Stage Pipeline) Datetime True True

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 True

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 True

Date and time when the company exited the 'Subscriber' stage of the Lifecycle Stage Pipeline.

Ideal Customer Profile Tier String False True

Classification of how closely the company matches your Ideal Customer Profile, typically Tier 1, Tier 2, or Tier 3.

Target Account Bool False True

Indicates whether the company is designated as a target account for account-based marketing efforts.

Last Booked Meeting Date Datetime True True

Date when the most recent meeting was booked with any contact associated with the company.

Last Logged Call Date Datetime True True

Date when the most recent call was logged for any contact linked to the company.

Last Open Task Date Datetime True True

Due date of the most recently opened task assigned to the company or associated contacts.

last sales activity date old Datetime True True

Timestamp in seconds of the most recent sales activity involving the company. Used in legacy tracking.

Last Engagement Date Datetime True True

Timestamp of the most recent engagement action, such as a form submission or meeting, excluding marketing emails.

Last Engagement Type String True True

Type of the most recent engagement performed by a contact at the company, excluding bulk marketing emails.

Last Modified Date Datetime True True

Timestamp of the latest property update made to the company record, including hidden and visible properties.

Latest create date of active subscriptions Datetime True True

Timestamp when the most recent active subscription linked to this company was created.

Merged object IDs String True True

List of company record IDs that have been merged into this record. Set automatically by HubSpot.

Number of blockers Decimal True True

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 True

Total number of contacts associated with this company who have a designated buying role.

Number of decision makers Decimal True True

Total number of contacts linked to this company who are marked as decision makers.

Number of open deals Decimal True True

Total number of open deals currently associated with this company.

Record ID Decimal True True

Unique ID assigned automatically to the company record in HubSpot.

Pinned Engagement ID Decimal True True

ID of the engagement pinned at the top of the company's timeline for easy reference. Set automatically.

Pipeline String False True

Pipeline associated with the company, often used for account-based sales processes.

Likelihood to close Decimal True True

Calculated probability that a contact linked to this company will convert to a customer within the next 90 days.

HsPredictivecontactscoreV2NextMaxMax Decimal True True

Maximum predictive lead score aggregated from all contacts associated with this company.

Read Only Object Bool True True

Indicates whether this company record is read-only and cannot be manually edited.

Target Account2 String False True

Secondary field indicating target account status based on different account-based marketing programs.

Target Account Probability Decimal True True

Probability score indicating how likely the company is to qualify as a target account.

Target Account Recommendation Snooze Time Datetime False True

Timestamp recording when a recommendation to target this company was snoozed.

Target Account Recommendation State String False True

Current recommendation status for targeting the company, such as Active or Snoozed.

Time in Customer (Lifecycle Stage Pipeline) Decimal True True

Total time in seconds the company spent in the 'Customer' stage of the Lifecycle Stage Pipeline.

Time in Evangelist (Lifecycle Stage Pipeline) Decimal True True

Total time in seconds the company spent in the 'Evangelist' stage of the Lifecycle Stage Pipeline.

Time in Lead (Lifecycle Stage Pipeline) Decimal True True

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 True

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 True

Total time in seconds the company spent in the 'Opportunity' stage of the Lifecycle Stage Pipeline.

Time in Other (Lifecycle Stage Pipeline) Decimal True True

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 True

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 True

Total time in seconds the company spent in the 'Subscriber' stage of the Lifecycle Stage Pipeline.

Total open deal value Decimal True True

Sum of the values of all open deals linked to the company, calculated in the company's default currency.

Unique creation key String True True

Property used to uniquely identify the company during import or integration processes to avoid duplicates.

Updated by user ID Decimal True True

User ID of the last user who updated the company record. Set automatically by HubSpot.

User IDs of all notification followers String True True

List of user IDs who opted to receive notifications about updates to this company.

User IDs of all notification unfollowers String True True

List of user IDs who opted out of receiving notifications about updates to this company.

User IDs of all owners String True True

List of all owner user IDs assigned to this company.

Owner Assigned Date Datetime True True

Timestamp of the most recent assignment of an owner to this company record.

Is Public Bool False True

Indicates whether the company is publicly traded, as determined by HubSpot Insights or user input.

Number of Associated Contacts Decimal True True

Total number of contact records currently linked to this company.

Number of Associated Deals Decimal True True

Total number of deal records currently associated with this company.

Number of Form Submissions Decimal True True

Total number of form submissions completed by contacts associated with this company.

NumConversionEventsCardinalitySum Decimal True True

Aggregated sum of all conversion events across contacts linked to this company, calculated via rollup.

Recent Conversion Date Datetime True True

Most recent date a conversion event, such as a form submission, was completed by a contact associated with the company.

RecentConversionDateTimestampLatestValue Datetime True True

Timestamp of the most recent conversion event aggregated across all associated contacts.

Recent Conversion String True True

Name of the most recent form or event submitted by a contact associated with this company.

RecentConversionEventNameTimestampLatestValue Datetime True True

Timestamp of the latest recorded event name for a recent conversion associated with this company.

Recent Deal Amount Decimal True True

Monetary amount of the most recently closed deal associated with the company.

Recent Deal Close Date Datetime True True

Date when the most recent deal associated with this company was marked as closed-won.

Time Zone String False True

Time zone associated with the company's primary address, populated via HubSpot Insights if available.

Total Money Raised String False True

Total amount of capital raised by the company, based on external data sources such as HubSpot Insights.

Total Revenue Decimal True True

Sum of all revenue from closed-won deals associated with the company.

Company name String False True

Official name of the company as stored in HubSpot.

HubSpot Owner Email String False True

Email address of the HubSpot user assigned as the primary owner of the company.

Twitter Handle String False True

Primary Twitter username or handle associated with the company.

HubSpot Owner Name String False True

Full name of the HubSpot user assigned as the company's owner.

Phone Number String False True

Primary phone number for the company, typically populated from HubSpot Insights or manually entered.

Twitter Bio String False True

Biography text pulled from the company's Twitter profile.

Twitter Followers Decimal False True

Total number of followers on the company's official Twitter account.

Street Address String False True

Street address of the company, including building, suite, or unit number if applicable.

Street Address 2 String False True

Additional address information for the company such as a second line for building or floor information.

Facebook Company Page String False True

URL link to the company's official Facebook page.

City String False True

City where the company's headquarters or main office is located.

LinkedIn Company Page String False True

URL link to the company's LinkedIn page.

LinkedIn Bio String False True

Company description as displayed on its LinkedIn profile.

State_Region String False True

State, province, or region where the company is located.

Google Plus Page String False True

URL link to the company's Google Plus page (historical, for older records).

Date of last meeting booked in meetings tool Datetime True True

Date of the last meeting scheduled by an associated contact via HubSpot's meetings tool.

Campaign of last booking in meetings tool String True True

Urchin Tracking Module (UTM) campaign parameter representing the marketing campaign that led to the last meeting booked.

Medium of last booking in meetings tool String True True

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 True

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 True

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 True

Date when the most recent reply to a tracked sales email was received from the company.

Company owner String False True

Name of the HubSpot user assigned as the owner of the company record.

Last Contacted Datetime True True

Timestamp when the last call, one-to-one email, or meeting was logged for this company.

Last Activity Date Datetime True True

Timestamp when the most recent note, call, email, meeting, or task was logged for the company.

Next Activity Date Datetime True True

Scheduled date for the next sales activity associated with this company, such as a call or meeting.

Number of times contacted Decimal True True

Total number of communication attempts, such as calls, emails, or meetings, logged for the company.

Number of Sales Activities Decimal True True

Total number of sales-related activities recorded for the company, including calls and meetings.

Postal Code String False True

Postal or ZIP code associated with the company's primary business address.

Country_Region String False True

Country or region where the company's main office is located.

HubSpot Team String True True

Name of the HubSpot team assigned to the company's primary owner.

All owner ids String True True

List of owner property IDs, including default and custom, assigned to the company.

Website URL String False True

Official website URL of the company, used for engagement and deduplication purposes.

Company Domain Name String False True

Primary domain name associated with the company, used to link records and deduplicate companies.

All team ids String True True

List of team IDs associated with ownership of the company, including default and custom teams.

All accessible team ids String True True

List of team IDs, including inherited teams, that can access the company's ownership properties.

Number of Employees Decimal False True

Total number of employees working at the company, based on HubSpot Insights or user entry.

Industry String False True

Industry sector in which the company operates, based on predefined categories or custom entries.

Annual Revenue Decimal False True

Annual revenue generated by the company, either provided manually or sourced from HubSpot Insights.

Lifecycle Stage String False True

Stage representing the company's current sales or marketing qualification, such as Lead, Customer, or Evangelist.

Lead Status String False True

Sales status assigned to the company, typically used during prospecting and qualification processes.

Parent Company Decimal True True

Record ID of the parent company associated with this company if part of a corporate hierarchy.

Type String False True

Optional classification indicating the type of company, such as Partner, Prospect, Customer, or Reseller.

Description String False True

Brief narrative or summary describing the company's business or background.

Number of child companies Decimal True True

Number of child company records linked to this parent company record.

HubSpot Score Decimal True True

Score representing the company's sales-readiness, calculated based on engagement and profile attributes.

Create Date Datetime True True

Timestamp marking when the company was created in HubSpot.

Close Date Datetime False True

Date when the company was marked as a customer within HubSpot.

First Contact Create Date Datetime True True

Date when the first contact associated with this company was created.

Days to Close Decimal True True

Number of days elapsed between when the company record was created and when it was marked as a customer.

Web Technologies String False True

List of web technologies detected on the company's website, such as CRM platforms, marketing tools, or analytics services.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434