HubSpot

HubSpot is an all-in-one inbound marketing, sales, and customer service platform designed to help businesses attract, engage, and delight customers. It offers a suite of tools and features for managing marketing campaigns, generating leads, nurturing customer relationships, and providing support, making it a comprehensive solution for businesses looking to grow and manage their customer base.

Each of the objects has different metrics. All available endpoints from the HubSpot API are listed here.

HubSpot and HubSpot Analytics Connectors Difference

The HubSpot connector is for CRM data (contacts, deals, tickets etc.) whereas the HubSpot Analytics connector is for analytics data (about landing pages, content, blog posts, website performance and other).

Another difference is that it is possible to extract hstorical data for HubSpot Analytics. For HubSpot, you can only use extraction timestamps to build a time series.

How to Create a HubSpot Data Source

Use Data Blending to Associate IDs and Names

We recommend using the data blending feature when creating a flow to have IDs and names in the same table. The most common use cases are:

1. Owner ID and owner name
   • Create an additional source using the Owners object and add the following properties:
     • Owner ID
     • Owner Last/First name
   • Blend your two sources using Owner ID as the join key.
2. Stage ID and stage name
   • Create an additional source using the Deals Pipelines object and add the following properties:
     • Stage ID
     • Stage Label
   • Blend your two sources using Stage ID as the join key.

Limitations

Permissions

To be able to extract your HubSpot data, please make sure that the HubSpot account authorized in Dataddo has permissions of at least the admin level.

No Historical Data

It is not possible to load your historical data as the HubSpot API only allows Dataddo to extract the full list of the selected contacts or deals.

However, you can keep daily snapshots by selecting an object. To keep track of historical records, you can

1. Add Dataddo extraction timestamp to your data, and
2. Choose to append your data to build your time series.

Read more about historical data load here.

Troubleshooting

Retrieve Object ID

To get your Object ID, in your HubSpot account

1. Navigate to Settings.
2. Under the Data Management section, unroll Objects, and click on Custom Objects.
3. Your Object ID will be in the last part of the URL, starting with 2-, for example,
   https://app.hubspot.com/sales-products-settings/yourcustomerID/object/2-12345678.

Uninstall the Integration

When you disconnect your HubSpot account in Dataddo, all your customer data related to HubSpot will be deleted from your account. This does not affect your HubSpot data already loaded into your destination (i.e. dashboard or data warehouse). When uninstalling the app through the HubSpot administration, it is still recommended to delete any HubSpot sources or flows in Dataddo (the data does not get deleted unless the sources are deleted or your account gets disabled).

To uninstall the Dataddo and HubSpot integration, you can choose one of the following methods.

1. Disconnect your HubSpot account

In the Authorizers tab, delete the authorized HubSpot service. As a result, all Dataddo's permissions to extract data from your HubSpot account will be removed.

Please note that you will first need to delete all sources and flows using HubSpot.

2. Delete the installed Dataddo app in your HubSpot administration

1. In your HubSpot account, navigate to Settings.
2. Under Account Setup, unroll the Integrations section and click on Connected Apps.
3. Locate the Dataddo app and click on Actions - Uninstall.

No further data can get extracted and your HubSpot sources in Dataddo will get broken. However, the data already extracted until that point will stay in Dataddo until you delete your HubSpot sources (or until your Dataddo account is disabled).