Skip to main content
waffle.svg
Domo Knowledge Base

HubSpot Connector

Intro

HubSpot develops software for social media and email marketing, content management, web analytics, and search engine optimization. Use Domo's HubSpot connector to compile reports about your campaigns, contacts, blogs, lead sources, and the like. To learn about the HubSpot API, visit their website (http://developers.hubspot.com/docs/overview).

The HubSpot connector is a "Cloud App" connector, meaning it retrieves data stored in the cloud. In the Data Center, you can access the connector page for this and other Cloud App connectors by clicking Cloud App in the toolbar at the top of the window.

You connect to your HubSpot account in the Data Center. This topic discusses the fields and menus that are specific to the HubSpot connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

Primary Use Cases

Compiling reports about aspects of social media and email marketing, such as campaigns, contacts, blogs, lead sources, pipeline management, etc.

Primary Metrics

  • Campaign performance

  • Open rates

  • Email bounces

  • Leads

  • MQL

  • SAO

Primary Company Roles

Marketing/sales roles

Average Implementation Time

Less than 1 hour

Ease of Use (on a 1-to-10 scale with 1 being easiest)

2

Best Practices

  • Your Hub ID is valid for one account in Domo. Creating an additional account in Domo will cause the original account to be disconnected.

  • Some reports are marked as beta. Use at your own risk, as these reports do not currently have any documentation on Hubspot's site and may be removed by Hubspot at any time.

Prerequisites

To connect to your HubSpot account and create a DataSet, you must have the following:

Connecting to Your HubSpot Account

This section enumerates the options in the Credentials and Details panes in the HubSpot Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

This pane contains a single field where you enter your HubSpot Hub ID (see "Prerequisites" above for more details).  You are then taken to the HubSpot OAuth page where you are required to enter the email address and password for your HubSpot account. Once you have entered valid credentials, you can use the same account any time you go to create a new HubSpot DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

Details Pane

This pane contains a primary menu in which you select your HubSpot report. One other menu, Contact Fields, may appear depending on the report type you select.

Menu

Description

Report

Select a HubSpot report. The following reports are available:

All Landing Pages

Returns data for all of your landing pages.

Blogs

Returns high-level data for all of your blogs.

Blog Statistics by Month

Returns statistics for all of your blogs.

Blogs with Details

Returns detailed information for all of your blogs.

Campaigns

Returns data about all of your marketing campaigns.

Campaign Events

Returns data about specific marketing campaign events.

Contacts

Returns data about all of your contacts.

Contact Lists

Returns data about all of your contact lists.

Contact Lists with Contacts

Returns customized data about your contact lists.

Contacts with All Form Submissions

Returns data about contacts with form submissions.

Email Campaigns

Returns data about all of your email campaigns.

Forms

Returns high-level data about all forms you have created.

Keywords

Returns statistics for all keywords.

Landing Pages with Campaigns

Returns landing page data by campaign.

Lead Sources by Day

Returns data about all lead sources, broken down by day.

Lead Sources Totals

Returns totals for all lead sources.

Prospects

Returns data about all prospects.

 

Contact Fields

Select all fields that you want to show in your report. You must select at least one field.

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.

Troubleshooting

  1. Review the configuration to make sure all required items have been selected.

  2. Review the connector history for error messages.

  3. To reduce API calls for reports that allow date selections ("Email Events," "Events," "Blog Topics," and "Subscription Timeline"), use Append and choose to pull data from the last successful run instead of all data.

  4. In rare cases, you may be requesting too much information and reaching API limitations or timeouts. If this is the case, you can review the history of the connector run to see the error message and duration. If this is the case, you can reduce the number of accounts that are being pulled, choose a smaller number of metrics for the report that you are pulling, or reduce the time frame that you are trying to pull.