Data Dictionary
Field | Type | Notes |
Account Creation Date | Datetime | |
Additional Emails | Text | |
Address | Text | |
Archived | Boolean | True if the Contact has been archived |
Billing Address Line 1 | Text | |
Billing Address Line 2 | Text | |
Billing City | Text | |
Billing Country | Text | |
Billing Postal Code | Text | |
Billing State | Text | |
City | Text | |
Company ID | Integer | The Company ID this Contact is associated with. Find related details in the Companies table. |
Company Name | Text | The name of the Company that the Contact is associated with |
Connection Name | Text | The name of the Connection. Typically the name of the HubSpot Organisation. |
Contact ID | Integer | HubSpot's unique ID for the Contact. |
Contact Name | Text | This is derived from the Firstname and Lastname |
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. |
Text | Email is the primary email field for a Contact. | |
Email Domain | Text | |
First Name | Text | |
Internal Link | Text | The link to the Contact record - only available to those that have access to HubSpot. |
Job Title | Text | Jobtitle |
Language | Text | |
Last Name | Text | |
Lead Status | Text | |
Mobile Number | Text | Mobilephone |
Owner ID | Integer | The Owner ID of the person that owns/is responsible for the Contact. Not necessarily the same as the Created By Owner ID. Find related details in the Owners table. |
Phone Number | Text | Phone |
Pipeline | Text | |
Postal Code | Text | aka Zip Code |
Salutation | Text | |
Shipping Address Line 1 | Text | |
Shipping Address Line 2 | Text | |
Shipping City | Text | |
Shipping Country | Text | |
Shipping Postal Code | Text | |
Shipping State | Text | |
State | Text | |
Timezone | 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 | |
Work Email | Text | This is not often populated; Email is the primary email field for a Contact. |