HubSpot

The HubSpot source pulls data from your HubSpot account and sends it to your data warehouse. To setup the HubSpot source, contact us at [email protected].

Data from the HubSpot source can only be sent to the warehouse destinations.

Schema

Freshpaint will create the following tables in your warehouse for your HubSpot data:

companies

Column

Description

id

The unique identifier for the company.

createdate

The date the company record was created.

is_deleted

Whether or not the company record is deleted.

name

The name of the company.

portal_id

The ID of the HubSpot portal the company is in.

contact_identity_profiles

The contact_identity_profiles table contains the different identities for a contact. When two contacts are merged together, that creates a single contact with multiple identity profiles.

Column

Description

contact_id

The ID of the contact these identities belong to.

identities

An array of JSON objects, each representing an identity of the contact. You can also access the individual identities in the contact_identities table.

saved_at_timestamp

The Unix time in milliseconds this contact was last saved.

contact_identities

A contact identity represents one method by which you can get in touch with a contact.

Column

Description

contact_id

The ID of the contact the identity belongs to.

is_primary

Whether or not this identity is the primary identity of the contact.

is_secondary

Whether or not this identity is the secondary identity of the contact.

timestamp

The Unix time in milliseconds the identity was created.

type

The type of the identity. It can be either EMAIL or LEAD_GUID.

value

The value of the identity. Can be either the contact's email or lead GUID.

contact_lists

Column

Description

id

The unique identifier for the contact list.

created_at

The Unix time in milliseconds the contact list was created.

deletable

True if the list is deletable. If the list is a system list, the list is not deletable and this column will be false.

dynamic

Whether or not the list is dynamic.

filters_0_0_filter_family

An array of filters used to determine membership int he list.

meta_data_last_processing_state_change_at

The Unix time in milliseconds when the processing time of the list was last changed.

meta_data_last_size_change_at

The Unix time in milliseconds when the size of the list last changed.

metadata_data_processing

A string representing whether or not the contact list is has finished processing. Can be DONE, REFRESHING, INITIALIZING, or PROCESSING.

meta_data_size

The approximate number of members in the contact list.

name

The name of the contact list.

portal_id

The HubSpot portal the contact list belongs to.

updated_at

The Unix time in milliseconds when the list was last updated.

contacts

Column

Description

vid

The unique identifier for the contact.

added_at

The Unix time in milliseconds the contact was added.

canonical_vid

The contact ID of the contact this contact was merged into.

email

The email of the contact.

form_submissions

An array of JSON objects representing the forms the user has submitted.

is_contact

Is the contact a valid contact. This is false for records that have placeholder data.

lead_guid

The lead GUID of the contact.

list_membership

An array of JSON objects representing the contact lists the contact is a member of.

merged_vids

An array of contact IDs that have been merged into the contact.

portal_id

The ID of the HubSpot portal the contact is in.

profile_token

A token that can be used to view the contact.

profile_url

A URL that can be used to view the contact.

properties_company_value

The company the contact belongs to.

properties_firstname_value

The first name of the contact.

properties_lastmodifieddate_value

The Unix time in milliseconds the contact was last modified.

properties_lastname_value

The last name of the contact.

deals

Column

Description

id

The unique identifier for the deal.

amount

The amount the deal is for.

associated_company_ids

An array of IDs for companies that are associated with the deal.

associated_vids

An array of IDs for contacts that are associated with the deal.

dealname

The name of the deal.

dealstage

The stage the deal is currently in.

is_deleted

Whether or not the deal record has been deleted.

pipeline

The pipeline the deal record is a part of.

portal_id

The ID of the HubSpot portal the deal is in.

email_campaigns

Column

Description

id

The unique identifier for the email campaign.

app_id

The ID of the HubSpot app that sent the email campaign.

app_name

The name of the HubSpot app that sent the email campaign.

email_events

An email event provides information about the different stages of an emails lifecycle. See the HubSpot Email Events API Overview for more information.

Column

Description

id

The unique identifier for the email event.

created

The Unix timestamp in milliseconds the event was created.

type

The type of the event. It can be one of the 12 different events generated during an emails lifecycle.

recipient

The email address of the recipient of the message.

portal_id

The ID of the HubSpot portal the email event is in.

app_id

The ID of the HubSpot app that sent the email.

app_name

The name of the HubSpot app that sent the email.

email_campaign_id

The ID of the email campaign the email was a part of.