CData BizTalk Adapter for HubSpot 2019 - Online Help
Questions / Feedback?

Companies

CData BizTalk Adapter for HubSpot 2019 - Build 19.0.7424

Retrieve the available Companies in HubSpot.

Columns

Name Type ReadOnly Filterable Description
Id [KEY] Long False true

Unique identifier of the company.

Archived Bool True false

Whether the company is archived or not.

CreatedAt Datetime True false

When the company was created.

UpdatedAt Datetime True false

When the company was last updated.

About_Us String False true

Short about-company

Facebook_Fans Double False true

Number of facebook fans

First_Conversion_Date Datetime True true

The first conversion date across all contacts associated this company or organization

First_Conversion String True true

The first form submitted across all contacts associated this company or organization

First_Deal_Created_Date Datetime True true

The create date of the first deal associated with this company record.

Year_Founded String False true

The year the company was created. Powered by HubSpot Insights.

Additional_Domains String False true

Additional domains belonging to this company

Time_First_Seen Datetime True true

The first activity for any contact associated with this company or organization

First_Touch_Converting_Campaign String True true

The campaign responsible for the first touch creation of the first contact associated with this company

Time_of_First_Session Datetime True true

Time of first session across all contacts associated with this company or organization

Time_Last_Seen Datetime True true

Time last seen across all contacts associated with this company or organization

Last_Touch_Converting_Campaign String True true

The campaign responsible for the last touch creation of the first contact associated with this company

Time_of_Last_Session Datetime True true

Time of the last session attributed to any contacts that are associated with this company record.

Number_of_Pageviews Double True true

Total number of page views across all contacts associated with this company or organization

Number_of_Sessions Double True true

Total number of sessions across all contacts associated with this company or organization

Original_Source_Type String False true

Original source for the contact with the earliest activity for this company or organization

Original_Source_Data_1 String True true

Additional information about the original source for the contact with the earliest activity for this company or organization

Original_Source_Data_2 String True true

Additional information about the original source for the contact with the earliest activity for this company or organization

Avatar_FileManager_key String True true

The path in the FileManager CDN for this company's avatar override image. Automatically set by HubSpot.

Created_by_user_ID Double True true

The user that created this object. This value is automatically set by HubSpot and may not be modified.

Object_create_date_time Datetime True true

The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.

Ideal_Customer_Profile_Tier String False true

This property shows how well a Company matches your Ideal Customer Profile. Companies that are Tier 1 should be a great fit for your products/services where Tier 3 might be acceptable, but low priority

Target_Account Bool False true

The Target Account property identifies the companies that you are marketing and selling to as part of your account-based strategy.

Last_Sales_Activity_Date Datetime True true

The date of the last sales activity with the company.

Last_Modified_Date Datetime True true

The date any property on this company was modified

Merged_object_IDs String True true

The list of object IDs that have been merged into this object. This value is automatically set by HubSpot and may not be modified.

Company_ID Double True true

The unique ID for this company. This unique ID is automatically populated by HubSpot and cannot be changed.

Likelihood_to_close Double True true

The highest probability that a contact associated with this company will become a customer within the next 90 days. This score is based on standard contact properties and behavior.

Target_Account2 String False true

The Target Account property is a means to flag high priority companies if you are following an account based strategy

Updated_by_user_ID Double True true

The user that last updated this object. This value is automatically set by HubSpot and may not be modified.

Owner_Assigned_Date Datetime True true

The timestamp when an owner was assigned to this company

Is_Public Bool False true

Indicates that the company is publicly traded. Powered by HubSpot Insights.

Associated_Contacts Double True true

The number of contacts associated with this company

Associated_Deals Double True true

The number of deals associated with this company

Number_of_Form_Submissions Double True true

The number of forms submission for all contacts associated with this company or organization

Recent_Conversion_Date Datetime True true

The most recent conversion date across all contacts associated this company or organization

Recent_Conversion String True true

The last form submitted across all contacts associated this company or organization

Recent_Deal_Amount Double True true

The amount of the last deal closed

Recent_Deal_Close_Date Datetime True true

The date of the last `closed won` deal associated with this company record.

Time_Zone String False true

The time zone where the company or organization is located. Powered by HubSpot Insights.

Total_Money_Raised String False true

The total amount of money raised by the company. Powered by HubSpot Insights.

Total_Revenue Double True true

The total amount of closed won deals

Name String False true

The name of the company or organization. Powered by HubSpot Insights.

HubSpot_Owner_Email String False true

HubSpot owner email for this company or organization

Twitter_Handle String False true

The main twitter account of the company or organization

HubSpot_Owner_Name String False true

HubSpot owner name for this company or organization

Phone_Number String False true

A company's primary phone number. Powered by HubSpot Insights.

Twitter_Bio String False true

The Twitter bio of the company or organization

Twitter_Followers Double False true

The number of Twitter followers of the company or organization

Street_Address String False true

The street address of the company or organization, including unit number. Powered by HubSpot Insights.

Street_Address_2 String False true

The additional address of the company or organization. Powered by HubSpot Insights.

Facebook_Company_Page String False true

The URL of the Facebook company page for the company or organization

City String False true

The city where the company is located. Powered by HubSpot Insights.

LinkedIn_Company_Page String False true

The URL of the LinkedIn company page for the company or organization

LinkedIn_Bio String False true

The LinkedIn bio for the company or organization

State_Region String False true

The state or region in which the company or organization is located. Powered by HubSpot Insights.

Google_Plus_Page String False true

The URL of the Google Plus page for the company or organization

Date_of_last_meeting_booked_in_meetings_tool Datetime True true

The date of the most recent meeting an associated contact has booked through the meetings tool.

Campaign_of_last_booking_in_meetings_tool String True true

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.

Medium_of_last_booking_in_meetings_tool String True true

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.

Source_of_last_booking_in_meetings_tool String True true

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.

Latest_meeting_activity Datetime True true

The date of the most recent meeting (past or upcoming) logged for, scheduled with, or booked by a contact associated with this company.

Recent_Sales_Email_Replied_Date Datetime True true

The last time a tracked sales email was replied to by this company

Company_owner String False true

The owner of the company

Last_Contacted Datetime True true

The last timestamp when a call, email or meeting was logged for a contact at this company.

Last_Activity_Date Datetime True true

The last time a note, call, meeting, or task was logged for a company. This is set automatically by HubSpot based on user actions in the company record.

Next_Activity_Date Datetime True true

The date of the next upcoming scheduled sales activity for this company record.

Number_of_times_contacted Double True true

The number of times a call, email or meeting was logged for this company

Number_of_Sales_Activities Double True true

Number of sales activities for this company. For example, a call, email or meeting logged.

Postal_Code String False true

The postal or zip code of the company or organization. Powered by HubSpot Insights.

Country_Region String False true

The country/region in which the company or organization is located. Powered by HubSpot Insights.

HubSpot_Team String True true

The team of the owner of the company.

All_owner_ids String True true

The value of all owner referencing properties for this object, both default and custom

Website_URL String False true

The main website of the company or organization. This property is used to identify unique companies. Powered by HubSpot Insights.

Company_Domain_Name String False true

The domain name of the company or organization

All_team_ids String True true

The team ids corresponding to all owner referencing properties for this object, both default and custom

All_accessible_team_ids String True true

The team ids, including up the team hierarchy, corresponding to all owner referencing properties for this object, both default and custom

Number_of_Employees Double False true

The total number of employees who work for the company or organization

Industry String False true

The type of business the company performs. By default, this property has approximately 150 pre-defined options to select from. While these options cannot be deleted as they used by HubSpot Insights, you can add new custom options to meet your needs.

Annual_Revenue Double False true

The actual or estimated annual revenue of the company. Powered by HubSpot Insights.

Lifecycle_Stage String False true

The most advanced lifecycle stage across all contacts associated with this company or organization

Lead_Status String False true

The company's sales, prospecting or outreach status

Parent_Company Double True true

The parent company of this company

Type String False true

The optional classification of this company record - prospect, partner, etc.

Description String False true

A short statement about the company's mission and goals. Powered by HubSpot Insights.

Number_of_child_companies Double True true

The number of child companies of this company

HubSpot_Score Double True true

The sales and marketing score for the company or organization

Create_Date Datetime True true

The date the company or organization was added to the database

Close_Date Datetime False true

The date the company or organization was closed as a customer

First_Contact_Create_Date Datetime True true

The date that the first contact from this company entered the system, which could pre-date the company's create date

Days_to_Close Double True true

The number of days between when the company record was created and when they closed as a customer.

Web_Technologies String False true

The web technologies used by the company or organization. Powered by HubSpot Insights.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7424.0