HubSpot Raw Data Guide

This guide shows you how to use the raw data coming from this specific data source APIs, so we can support you achieve your reporting needs. In this guide, some recommendations are provided as well as examples of use cases for the most commonly used fields. If you’d like to dig deeper into the raw data from each API, we recommend you to refer to our integrations documentation which provides links to each API documentation. For more guidance on how to build your reports and BI metrics, please inquire us about the Beginners Journey, Data Modelling Guide, Marketing Attribution and/or BI Metrics Guide.

Note: There may be several ways to achieve the use cases that has been indicated below, but these columns are the ones commonly used for most of the use cases we've encountered.

 

Most Used Tables

Table Name

Description

deals_by_company

The deals_by_company table contains deals and company ID pairs, allowing you to join deals to relevant company data.

companies

The companies table contains info about the companies your HubSpot contacts belong to.

contacts

The contacts table contains info about individual contacts in HubSpot.

deals

The deals table contains info about the deals in a HubSpot portal.

deal_pipelines

The deal_pipelines table contains info about the deal stage and pipeline properties.

 

Most Used Fields

Column Name

Description

Use Cases

Table Name

from

deal_id

The ID of the deal. It can be used for joining information from different tables, counting total deals in a certain timeframe, or calculating the average deal size, for instance.

deals_by_company

to

company_id

The ID of the company. It can be used for joining information from different tables, grouping by revenue by company, and so on.

deals_by_company

company_id

company_id

The ID of the company. It can be used for joining information from different tables, grouping by revenue by company, and so on.

companies

property_name

Name of the company

The property_name of a company can be used to join the information to other tables containing more metrics

companies

id

deal_id

The ID of the deal. It can be used for joining information from different tables, counting total deals in a certain timeframe, or calculating the average deal size, for instance.

deals

created_at

Date for when deal was created

It may be used for calculating revenue over time, revenue and marketing costs dashboard, and other advanced analysis such as cohort analysis.

deals

amount

deal amount

It may be used for calculating revenue over time, revenue and marketing costs dashboard, and other advanced analysis such as cohort analysis.

deals

contact_id

contact_id

The ID of the company.

contacts

contacts_source

Marketing source that generated the contact

Contains information about the source from where the lead was generated. It can be used for marketing attribution models, for instance, grouping data by source and calculating the sum of revenue generated by each marketing channel.

contacts

first_conversion_date

Date when contact was converted

It may be used for cohort analysis, marketing funnel analysis and other advanced analysis.

contacts

lead_status

Status of the lead

It may be used to analyze the marketing funnel, average time for conversion, for instance.

contacts

total_revenue

Value amount of revenue per contact

It may be used for calculating revenue over time, revenue per contact source, and other advanced analysis such as cohort analysis.

contacts

Was this article helpful?
0 out of 0 found this helpful