HubSpot connector: datasets and metric definitionsBeta
Bring in deals, contacts, companies, stage history, a daily pipeline snapshot, support tickets, marketing emails and campaigns. Updates daily.
When you connect HubSpot, Quiriz imports the datasets below and adds the metric definitions to Company Context, the one place your company’s definitions live. Every answer that uses one of these metrics uses the same definition, in the app, in Slack and in the Excel, Sheets, PowerPoint, Slides, Word and Docs add-ins. An admin can edit any of them.
DatasetsMetric definitionsWorks withQuestionsFAQ
Datasets
| Dataset | What it holds |
|---|---|
| [HubSpot] Companies | Companies16 columnshs_object_id, name, domain, industry, country, numberofemployees, annualrevenue, lifecyclestage, company_owner, createdate, hs_analytics_source, hs_analytics_source_data_1, hs_analytics_source_data_2, hs_latest_source, hs_latest_source_data_1, hs_latest_source_data_2 |
| [HubSpot] Deals | Deals32 columnshs_object_id, dealname, pipeline, dealstage, hs_is_closed, hs_is_closed_won, amount, amount_original, deal_currency_code, weighted_amount, hs_deal_stage_probability, hs_manual_forecast_category, closedate, createdate, hs_lastmodifieddate, days_to_close, deal_owner, company_id, company_name, dealtype, hs_analytics_source, hs_analytics_source_data_1, hs_analytics_source_data_2, closed_lost_reason, closed_won_reason, hs_arr, hs_mrr, hs_acv, hs_tcv, notes_last_contacted, hs_next_step, num_associated_contacts |
| [HubSpot] Contacts | Contacts23 columnshs_object_id, lifecyclestage, hs_lead_status, createdate, hs_lifecyclestage_lead_date, hs_lifecyclestage_marketingqualifiedlead_date, hs_lifecyclestage_salesqualifiedlead_date, hs_lifecyclestage_opportunity_date, hs_lifecyclestage_customer_date, hs_analytics_source, contact_owner, company_id, country, hs_analytics_source_data_1, hs_analytics_source_data_2, hs_latest_source, hs_latest_source_data_1, hs_latest_source_data_2, first_conversion_event_name, first_conversion_date, recent_conversion_event_name, recent_conversion_date, num_conversion_events |
| [HubSpot] Deal stage history | Stage history12 columnsdeal_id, dealname, pipeline, deal_owner, stage, stage_order, entered_date, exited_date, days_in_stage, is_current_stage, deal_won, amount |
| [HubSpot] Pipeline snapshots | Pipeline snapshots9 columnssnapshot_date, deal_id, dealname, pipeline, stage, amount, weighted_amount, closedate, deal_owner |
| [HubSpot] Tickets | One row per HubSpot support ticket. is_closed is 1 when the ticket sits in a closed stage of its pipeline. days_to_close and hours_to_first_reply are HubSpot's own measures; empty means not closed or not replied yet. Count tickets with count of hs_object_id.16 columnshs_object_id, subject, pipeline, ticket_stage, is_closed, priority, category, source, createdate, closed_date, days_to_close, hours_to_first_reply, ticket_owner, company_id, company_name, hs_lastmodifieddate |
| [HubSpot] Marketing emails | One row per HubSpot marketing email that has been sent (drafts and system emails left out), with HubSpot's lifetime counts: sent, delivered, opens, clicks, bounces, unsubscribes and spam reports. An automated (workflow) email keeps sending, so its counts cover every send since publish_date, not one day. Opens include Apple Mail privacy pre-opens: compare emails by clicks first. Rates are ratios of sums: open rate = sum(opens) / sum(delivered).14 columnsemail_id, name, subject, email_type, state, campaign_name, publish_date, sent, delivered, opens, clicks, bounces, unsubscribes, spam_reports |
| [HubSpot] Campaigns | One row per HubSpot marketing campaign with its lifetime attribution: sessions, new contacts (first and last touch) and influenced contacts. Budget and spend are in the campaign's own currency column; never add them across currencies.15 columnscampaign_id, name, status, start_date, end_date, campaign_owner, audience, goal, currency, budget, spend, sessions, new_contacts_first_touch, new_contacts_last_touch, influenced_contacts |
Metric definitions
Each metric is a total over the period you ask about. A metric built from other metrics, such as a rate, divides the totals for the whole period; it does not average daily rates. Dated by is the date column that decides which period a row belongs to.
[HubSpot] Deals
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Pipeline value | Sum of amount, where hs_is_closed = 0 | createdate | Open deal amount, by create date. Excludes closed won and closed lost. |
| Win rate | Share of rows where hs_is_closed_won is 1, where hs_is_closed = 1 | closedate | Closed-won deals divided by all closed deals, by close date. Shown as a decimal (0.25 = 25%). |
| Average deal size | Average of amount, where hs_is_closed_won = 1 | closedate | Mean amount of closed-won deals, by close date. |
| Sales cycle (days) | Average of days_to_close, where hs_is_closed_won = 1 | closedate | Mean days from create to close for closed-won deals. |
| Closed-won revenue | Sum of amount, where hs_is_closed_won = 1 | closedate | Sum of closed-won deal amounts, by close date. |
| Weighted pipeline | Sum of weighted_amount, where hs_is_closed = 0 | createdate | Open deal amount times stage probability, in the home currency, by create date. |
| Closed-won ARR | Sum of hs_arr, where hs_is_closed_won = 1 | closedate | Annual recurring revenue of closed-won deals (from line items), by close date. Empty when the portal does not use line items. |
| Lost deals | Count of distinct hs_object_id, where hs_is_closed = 1 AND hs_is_closed_won = 0 | closedate | Deals closed lost, by close date. Group by closed_lost_reason for why. |
[HubSpot] Deal stage history
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Average days in stage | Average of days_in_stage | entered_date | Mean days a deal spent in a stage, by the date it entered. Group by stage. |
| Deals entering stage | Count of distinct deal_id | entered_date | Deals that entered a stage, by entry date. Next stage divided by this stage is the stage conversion rate. |
[HubSpot] Tickets
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Tickets created | Count of distinct hs_object_id | createdate | Support tickets opened, by create date. |
| Tickets closed | Count of distinct hs_object_id, where is_closed = 1 | closed_date | Support tickets closed, by close date. |
| Average days to close a ticket | Average of days_to_close, where is_closed = 1 | closed_date | Mean days from open to close for closed tickets, by close date. |
| Average hours to first reply | Average of hours_to_first_reply | createdate | Mean hours until an agent first replied, by ticket create date. Tickets with no reply yet are left out. |
[HubSpot] Marketing emails
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| HubSpot emails sent | Sum of sent | publish_date | Marketing emails sent, by publish date. |
| HubSpot emails delivered | Sum of delivered | publish_date | Marketing emails delivered (sent minus bounces), by publish date. |
| HubSpot email opens | Sum of opens | publish_date | Opens of marketing emails, by publish date. Apple Mail privacy pre-opens inflate it. |
| HubSpot email clicks | Sum of clicks | publish_date | Clicks in marketing emails, by publish date. |
| HubSpot email unsubscribes | Sum of unsubscribes | publish_date | Unsubscribes from marketing emails, by publish date. |
| HubSpot email open rate | HubSpot email opens ÷ HubSpot emails delivered | publish_date | Opens per delivered email, as a decimal (0.25 = 25%). |
| HubSpot email click rate | HubSpot email clicks ÷ HubSpot emails delivered | publish_date | Clicks per delivered email, as a decimal (0.02 = 2%). |
| HubSpot email unsubscribe rate | HubSpot email unsubscribes ÷ HubSpot emails delivered | publish_date | Unsubscribes per delivered email, as a decimal. |
[HubSpot] Campaigns
| Metric | How it is calculated | Dated by | Notes |
|---|---|---|---|
| Campaign new contacts | Sum of new_contacts_first_touch | start_date | New contacts whose first touch was the campaign (first-touch attribution), by campaign start date. |
| Campaign influenced contacts | Sum of influenced_contacts | start_date | Contacts who interacted with the campaign, by campaign start date. One contact can count in several campaigns. |
Works with other connectors
- HubSpot + Google Ads + Meta Ads: Pipeline per ad dollar. HubSpot closed-won revenue against ad spend by month, as your own cross-source metric. Define it as your own metric.
Questions to ask
- What's our win rate by deal owner this quarter?
- Which open deals are past their close date?
- How much pipeline was created each month this year?
- How many contacts reached MQL by source last quarter?
- Why are we losing deals this quarter?
- How long do deals sit in each stage?
- What's the conversion from each stage to the next this year?
- What's our weighted pipeline by owner for deals closing this quarter?
Related guides
- CRM Reporting for HubSpot and Salesforce: Win Rate and Pipeline
- HubSpot AI: Ask Your CRM Questions in Plain English
- HubSpot MCP and Claude: Three Ways to Use Claude or ChatGPT With HubSpot Data
- HubSpot Dashboard Examples: 8 Sales Reports and Their Definitions
- HubSpot Attribution Report: Which Sources Close Deals
- HubSpot to Google Sheets: Join Deals and Companies Without a VLOOKUP That Breaks
- How to Calculate Win Rate (and Break It Down by Sales Rep)
Ask HubSpot in plain words
Try the questions on sample data with no signup, then connect HubSpot read-only and ask your own.
Try Quiriz free →Frequently asked questions
Does Quiriz change anything in HubSpot?
How often does the HubSpot data refresh?
Can I change how a metric is calculated?
Can I combine HubSpot with other sources?
All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.