HubSpot

Data Replication

Default Pipeline Frequency	Minimum Pipeline Frequency	Maximum Pipeline Frequency	Custom Frequency Range (Hrs)
1 Hr	30 Mins	24 Hrs	1-24

Note: The custom frequency must be set in hours, as an integer value. For example, 1, 2, 3 but not 1.5 or 1.75.

• Historical Data: In the first run of the Pipeline, Hevo ingests historical data for all the objects on the basis of the historical sync duration selected at the time of creating the Pipeline and loads it to the Destination. Default duration: 3 Months

• Incremental Data: Once the historical load is complete, new and updated records for all objects except Owners and Email Campaigns are synchronized with your Destination as per the ingestion frequency.

Archived Objects

Hevo synchronizes the archived records for all the standard objects in Hubspot. For any archived record fetched from your Hubspot data, the is_archived flag is set to TRUE in the Destination.

The ingestion of archived Events is not coupled with the scheduled Pipeline runs due to the Source consideration around the handling of deletes. To reduce the number of Events being ingested during each Pipeline run, the ingestion frequency for deleted Events is set to 24 Hours. You can change this by reaching out to Hevo Support.

Merged Objects

In HubSpot, whenever two or more objects are merged, a third object with the merged properties is created. The merged objects do not get picked up during ingestion. When Hevo loads this third object to the Destination, it also adds the following fields to the older objects to identify them as merged:

Fields	Data type	Description
__hevo_merged	boolean	Contains the merged status of an object. It is set to TRUE only if the object is merged with another.
__hevo_merged_into	long	Contains the ID of the new object which it has been merged into.

Using these fields, you can identify the stale data, if any, in the Destination.

---

Schema and Primary Keys

Hevo uses the following schema to upload the records in the Destination:

---

Data Model

The following tables (objects) are created in the Destination when you run the Pipeline:

Note:

• Owners and Email Campaigns are Full Load objects, and the entire data is fetched in each run of the Pipeline. This may lead to higher Events quota consumption.

• For Pipelines created from Release 1.98 onwards: Hevo supports the data ingestion of custom objects and their associations. However, to ingest the data for associations, you need to contact Hevo Support.

Object	Description
Contacts	Contains the details about an individual person.
Contact Deal Association	Contains the details about the mapping between a contact and all deals associated with it.
Contact List	Contains the lists of all the contacts in your HubSpot account, grouped by membership.
Companies	Contains the details about an individual business or organization.
Custom Objects	Contains the details about custom objects created in the HubSpot portal for specific business requirements. These are tied to the HubSpot account.
Deals	Contains the details about an ongoing transaction associated with a contact or company. The progress of these deals is tracked till their conclusion.
Deal Company Association	Contains the details about the mapping between a company and all the deals associated with it.
Deal Stage Pipeline	Contains the details about the current progress of a deal.
Deal Line Item Association	Contains the details about the mapping between a deal and all the product line items associated with it.
Email Events	Contains the details about the Events generated by marketing emails, or email campaigns sent through a HubSpot account.
Email Campaigns	Contains the details such as the subject line of an email message, HubSpot application name, event type, activity status, and time of the last update for an email campaign.
Engagements	Contains the details generated from CRM actions, such as notes, tasks, emails, meetings, and calls. At a minimum, engagements should be associated with at least one CRM record.
Engagement Call	Contains the details about the calls made by users on an object record. Each call is linked to an engagement, which could be linked to a contact, deal, or company.
Engagement Contact Association	Contains the details about the mapping between a contact and all the engagements associated with it.
Engagement Company Association	Contains the details about the mapping between a company and all engagements associated with it.
Engagement Deal Association	Contains the details about the mapping between a deal and all engagements associated with it.
Engagement Email	Contains the details about the emails sent on an object record. Each email is linked to an engagement, which could be linked to a contact, deal, or company.
Engagement Meeting	Contains the details about the face-to-face meetings on an object record. Each meeting is linked to an engagement, which could be linked to a contact, deal, or company.
Engagement Note	Contains the details of simple text information about an object record. Each note is linked to an engagement, which could be linked to a contact, deal, or company.
Engagement Task	Contains the details of the tasks and is available on the tasks dashboard as well as on associated object records. Each task is linked to an engagement, which could be linked to a contact, deal, or company.
Form Submissions	Contains the details about the fields in the submissions, the time of the form submission, and the page URL that the form was submitted on.
Owners	Contains the details about the mapping between users and contacts, companies, deals, tickets, or engagements.
Products	Contains the details of the goods or services for sale that are configured in your Hubspot account.
Line Items	Contains the details about the line item-level data associated with each product.
Tickets	Contains the details about the customer requests, raised for help or support.
Ticket Stage Pipeline	Contains the details about the current stage of a ticket.

---