Getting Started
Data Management
Frequently Asked Questions
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].
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.
Last modified 1yr ago