Scoop is able to grab any report data from HubSpot. To do this, use the HubSpot application option in Application Report option when creating a new dataset.

Typical HubSpot Use Cases with HubSpot Only

Typical use cases for Scoop with Hubspot data only include:

  • General HubSpot reporting with better visuals and analysis
  • Weekly forecasting or pipeline views that leverage snapshotting to review changes
  • Snapshotting any/all attributes on any HubSpot object like Opportunities or Leads
  • Analyzing sales and/or marketing processes to understand conversion rates and cycle times
  • Combining HubSpot marketing lead data with HubSpot sales data to understand the full lifecycle and process for a customer from raw lead to closed deal.
    • Conversion rates
    • Cycle times
    • Channel efficiency

Typical Use Cases Combining HubSpot with other Applications

Combining HubSpot data with other types of data opens up very powerful analysis options that can really help a marketer optimize their performance. While HubSpot allows some limited ability to bring in some outside sources, like basic financial data, the integration is much more complex and the data and analysis options are limited. Scoop opens up tremendously rich opportunities to slice and dice HubSpot data in conjunction with data from other applications.

Uncaptured Audience or Channel Data

Because Scoop can easily handle spreadsheets, lookup tables that augment attributes for your campaign are very easy to add. It's exceptionally easy and painless to augment your marketing data with key attributes that likely are either anecdotal or captured in some sort of ad hoc way. Scoop makes it extraordinarily simple to include this data by maintaining it in a spreadsheet and being able to join that spreadsheet to your other marketing data.

Financial Expense Data

Financial applications such as NetSuite, Quickbooks or other accounting applications can bring in expense data very easily into Scoop. This enables some powerful analysis:

  • Dollar cost efficiency of marketing efforts: This analysis allows you to assess by campaign, audience, channel, message, etc. the efficiency of dollars in to dollars out of closed won deals. This use case combines snapshot lead data, snapshot sales data and financial expense data for marketing campaigns.
  • Customer acquisition cost
  • Cost per lead analysis

Service Data

To understand better what audiences might be more expensive to serve, Scoop allows you to blend your marketing or sales data with data from your service desk (e.g. Zendesk)

Product Usage Data

Understand the usage patterns of your customers based on their marketing segmentation.

Engineering Data

Understand what types of customers cost the most in terms of engineering time by integrating with a tool like Jira.

Connecting to HubSpot

To connect to HubSpot as a datasource, create a new dataset linked to HubSpot. First, on the datasets page, select applications as a source:

Next, select Hubspot:


Select API Data Source:

Select whether you are selecting an object that you want to snapshot daily, or an object which is transactional (e.g. an activities object).

After connecting to Hubspot to Scoop, select the object that you wish to extract, and the columns that you wish to extract.

Also, select a dataset name. If you like, certain columns support filtering and you can filter them for specific values. After you save this dialog, you can elect to have Scoop run an immediate extract (by checking the extract data now button). Scoop will automatically run this extract overnight each day after you set this up.

Writing back to HubSpot from a Scoop dataset

With Scoop you can blend data with other datasets and create new fields with ease. Scoop's ability to use spreadsheet logic gives you that same spreadsheet flexibility to add arbitrary and powerful calculations to your dataset. It is often useful to then bring those sophisticated calculations back into your source application. Scoop's API Writeback feature allows you to take any Scoop dataset and write values back into your HubSpot application. This means that you can extract data from HubSpot (which is necessary to extract the HubSpot record ID which is required to write back into HubSpot), blend it with other data or create new calculations and then push those back into your HubSpot application.

In order to write back into HubSpot, you must first establish an API connection to HubSpot and extract records that you wish to augment (see above). The Record ID will be part of your extracted dataset. You can either create calculated columns with that dataset, or you can blend that dataset with others in Scoop to create a new dataset. Be sure to make sure that the Record ID stays with your records as you blend them together (i.e. always select that column when building a new blended dataset).

Once that is done, you can now update HubSpot whenever your dataset in question is processed. When that connection is established, the following option becomes available on the dataset menu:

You can select "Setup Application Writeback" to create a writeback definition for Scoop. This definition tells Scoop what to do each time that dataset is processed. When processing is done, it will use that dataset and take the fields that you map and write them back to HubSpot using the Record IDs that you initially extracted.

The definition essentially allows you to pick fields from one table within your dataset and map those back to fields within HubSpot.

So if, for example, you wanted to map a single column in HubSpot to a Scoop dataset, you simply select from the dropdown which Scoop dataset column you want to use. Once that is done, each time that dataset is processed, Scoop will update HubSpot to ensure that that field will contain the value calculated in Scoop.