Freshpaint Help Center
What is Freshpaint?
Web Quickstart Guide
React Native Quickstart Guide
iOS Quickstart Guide
Android Quickstart Guide
Building Out Your Account
Overview of Features
Event Schema Dashboard
Projects & Environments
Frequently Asked Questions
How Do I Switchover From Segment?
Is Freshpaint GDPR & CCPA Compliant?
How do I QA or debug my data?
Why Do My Numbers Differ Across Different Tools?
Billing: How Does Freshpaint Determine MTUs?
Can I Use Freshpaint on Multiple Sites?
How Can I Export Data From Freshpaint?
How Does Freshpaint Identify Users?
How Many Events Should I Create?
What Should I Name My Events?
How do I track scroll depth?
What Data Does Freshpaint Collect?
Does Freshpaint's Autotrack slow my site down?
Running Freshpaint with a Proxy
Freshpaint Web SDK Reference
Freshpaint React Native SDK Reference
Freshpaint iOS SDK Reference
Freshpaint Android SDK Reference
The HubSpot source pulls data from your HubSpot account and sends it to your data warehouse. To setup the HubSpot source, contact us at
Data from the HubSpot source can only be sent to the
Freshpaint will create the following tables in your warehouse for your HubSpot data:
The unique identifier for the company.
The date the company record was created.
Whether or not the company record is deleted.
The name of the company.
The ID of the HubSpot portal the company is in.
table contains the different identities for a contact. When two contacts are merged together, that creates a single contact with multiple identity profiles.
The ID of the contact these identities belong to.
An array of JSON objects, each representing an identity of the contact. You can also access the individual identities in the
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.
The ID of the contact the identity belongs to.
Whether or not this identity is the primary identity of the contact.
Whether or not this identity is the secondary identity of the contact.
The Unix time in milliseconds the identity was created.
The type of the identity. It can be either
The value of the identity. Can be either the contact's email or lead GUID.
The unique identifier for the contact list.
The Unix time in milliseconds the contact list was created.
True if the list is deletable. If the list is a system list, the list is not deletable and this column will be false.
Whether or not the list is dynamic.
An array of filters used to determine membership int he list.
The Unix time in milliseconds when the processing time of the list was last changed.
The Unix time in milliseconds when the size of the list last changed.
A string representing whether or not the contact list is has finished processing. Can be
The approximate number of members in the contact list.
The name of the contact list.
The HubSpot portal the contact list belongs to.
The Unix time in milliseconds when the list was last updated.
The unique identifier for the contact.
The Unix time in milliseconds the contact was added.
The contact ID of the contact this contact was merged into.
The email of the contact.
An array of JSON objects representing the forms the user has submitted.
Is the contact a valid contact. This is false for records that have placeholder data.
The lead GUID of the contact.
An array of JSON objects representing the contact lists the contact is a member of.
An array of contact IDs that have been merged into the contact.
The ID of the HubSpot portal the contact is in.
A token that can be used to view the contact.
A URL that can be used to view the contact.
The company the contact belongs to.
The first name of the contact.
The Unix time in milliseconds the contact was last modified.
The last name of the contact.
The unique identifier for the deal.
The amount the deal is for.
An array of IDs for companies that are associated with the deal.
An array of IDs for contacts that are associated with the deal.
The name of the deal.
The stage the deal is currently in.
Whether or not the deal record has been deleted.
The pipeline the deal record is a part of.
The ID of the HubSpot portal the deal is in.
The unique identifier for the email campaign.
The ID of the HubSpot app that sent the email campaign.
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.
The unique identifier for the email event.
The Unix timestamp in milliseconds the event was created.
The type of the event. It can be one of the 12 different events generated during an emails lifecycle.
The email address of the recipient of the message.
The ID of the HubSpot portal the email event is in.
The ID of the HubSpot app that sent the email.
The name of the HubSpot app that sent the email.
The ID of the email campaign the email was a part of.