Skip to main content
Contacts
Nick Maxwell avatar
Written by Nick Maxwell
Updated over 2 months ago

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.

Email

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.

Did this answer your question?