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.
Freshpaint will create the following tables in your warehouse for your HubSpot data:
​deals​
​companies​
​contact_identities​
​contact_lists​
​contacts​
​email_campaigns​
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. |
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 |
saved_at_timestamp | The Unix time in milliseconds this contact was last saved. |
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 |
value | The value of the identity. Can be either the contact's email or lead GUID. |
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 |
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. |
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. |
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. |
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. |
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. |
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. |
