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 |