Companies contains details of the Companies in HubSpot CRM.
Data Dictionary
Field | Type | Notes |
About Us | Text | |
Additional Domains | Text | |
Address Line 1 | Text | Address |
Address Line 2 | Text | Address2 |
Annual Revenue | Number | Annualrevenue |
Archived | Boolean | True if the Company has been archived |
City | Text | |
Company ID | Integer | HubSpot's unique ID for the Company. |
Company Name | Text | Name |
Company Type | Text | One of {PROSPECT, PARTNER, RESELLER, VENDOR, OTHER} |
Connection Name | Text | The name of the Connection. Typically the name of the HubSpot Organisation. |
Country | Text | |
Created | Datetime | The date and time that the record was created. |
Created By | Integer | The Owner ID of the person that created the record. Find related details in the Owners table. |
Created Date | Date | The date that the record was created. This is useful so you can create a relationship with the Dates table, and analyze data over days, weeks, months and so on. |
Data current as of | Datetime | Gives the date and time that this record was taken from HubSpot. |
Description | Text | |
Domain | Text | |
Founded Year | Integer | |
ID | Integer | |
Industry | Text | |
Internal Link | Text | The link to the Company record - only available to those that have access to HubSpot. |
Number of Employees | Integer | The HubSpot determined numberofemployees value. |
Owner ID | Integer | The Owner ID of the person that owns/is responsible for the record. Not necessarily the same as the Created By Owner ID. Find related details in the Owners table. |
Phone | Text | |
Pipeline | Text | |
Postal Code | Text | aka Zip Code |
State | Text | |
Updated | Datetime | The date and time that the record was updated. |
Updated By | Integer | The Owner ID of the person that updated the record. |
Updated Date | Date | The date that the record was updated. This is useful so you can create a relationship with the Dates table, and analyze data over days, weeks, months and so on. |
Website | Text |