Hubspot

Configuration details for the Hubspot integration

Via the Hubspot destination, Hightouch can both create and update standard or custom objects.

The Hubspot destination has three different possible modes.

  • Insert — Insert mode pushes new objects to Hubspot, and does not update the objects as they change in your warehouse.

  • Upsert — Upsert mode pushes new objects to Hubspot and updates fields that change in your warehouse.

  • Update — Update mode updates particular fields on existing objects in Hubspot.

Modes

Insert

Insert is the simplest of modes for pushing to Hubspot. In this mode new objects will be inserted into Hubspot, but future changes to columns of those objects will not be reflected in Hubspot.

This mode is good for the following scenarios:

  • You want to push objects into Hubspot, but don't care if the data within each row remains up to date

  • Hubspot data where each row is never updated, such as events

Insert has two configuration parameters:

Name

Description

Hubspot Object Name

The name of the object (Account, Contact, etc..) that will be pushed into Hubspot

Hightouch to Hubspot Field Mappings

A list of columns that will be pushed to new objects in Hubspot

Upsert

In this mode, new objects will be inserted into Hubspot and all designated columns will be kept up-to-date within Hubspot.

This mode is good for the following scenarios:

  • You want to push objects into Hubspot and want to keep the data up-to-date

Upsert has three configuration parameters:

Name

Description

Hubspot Object Name

The name of the object (Account, Contact, etc..) that will be pushed into Hubspot and kept up-to-date.

Hightouch to Hubspot External Unique Identifier Column Mapping

The name of the column on the Hightouch query, and the name of an external ID for the object in Hubspot.

Hightouch to Hubspot Field Mappings

A list of columns that will be pushed to new objects in Hubspot. Each time a sync occurs in Hightouch these columns will be updated.

Update

In this mode, selected columns will be updated for an object within Hubspot. For example, you could add an LTV column to an account or contact. This mode does not create new rows for an object within Hubspot. Instead, it updates columns on existing objects.

Update mode requires you to have access to the IDs of the objects you want to update within your warehouse.

This mode is good for the following scenarios:

  • You have objects in Hubspot that you want to add additional information / columns to

  • You want to continuously sync data from your warehouse and add this data to existing objects within Hubspot.

  • You already have access to Hubspot object IDs within your warehouse

Update has three configuration parameters:

Name

Description

Hubspot Object Name

The name of the object (Account, Contact, etc..) that will be updated into Hubspot.

Hightouch ID Column

The name of the column of the Hightouch query that contains a Hubspot object ID.

Hightouch to Hubspot Field Mappings

A list of columns that will be updated for objects in Hubspot. Each time a sync occurs in Hightouch these columns will be updated.