Home / Connectors / HubSpot
Connector

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.

8 datasets24 metric definitionsRead-onlyRefreshes 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

DatasetWhat it holds
[HubSpot] CompaniesCompanies
16 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] DealsDeals
32 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] ContactsContacts
23 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 historyStage history
12 columnsdeal_id, dealname, pipeline, deal_owner, stage, stage_order, entered_date, exited_date, days_in_stage, is_current_stage, deal_won, amount
[HubSpot] Pipeline snapshotsPipeline snapshots
9 columnssnapshot_date, deal_id, dealname, pipeline, stage, amount, weighted_amount, closedate, deal_owner
[HubSpot] TicketsOne 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 emailsOne 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] CampaignsOne 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

MetricHow it is calculatedDated byNotes
Pipeline valueSum of amount, where hs_is_closed = 0createdateOpen deal amount, by create date. Excludes closed won and closed lost.
Win rateShare of rows where hs_is_closed_won is 1, where hs_is_closed = 1closedateClosed-won deals divided by all closed deals, by close date. Shown as a decimal (0.25 = 25%).
Average deal sizeAverage of amount, where hs_is_closed_won = 1closedateMean amount of closed-won deals, by close date.
Sales cycle (days)Average of days_to_close, where hs_is_closed_won = 1closedateMean days from create to close for closed-won deals.
Closed-won revenueSum of amount, where hs_is_closed_won = 1closedateSum of closed-won deal amounts, by close date.
Weighted pipelineSum of weighted_amount, where hs_is_closed = 0createdateOpen deal amount times stage probability, in the home currency, by create date.
Closed-won ARRSum of hs_arr, where hs_is_closed_won = 1closedateAnnual recurring revenue of closed-won deals (from line items), by close date. Empty when the portal does not use line items.
Lost dealsCount of distinct hs_object_id, where hs_is_closed = 1 AND hs_is_closed_won = 0closedateDeals closed lost, by close date. Group by closed_lost_reason for why.

[HubSpot] Deal stage history

MetricHow it is calculatedDated byNotes
Average days in stageAverage of days_in_stageentered_dateMean days a deal spent in a stage, by the date it entered. Group by stage.
Deals entering stageCount of distinct deal_identered_dateDeals that entered a stage, by entry date. Next stage divided by this stage is the stage conversion rate.

[HubSpot] Tickets

MetricHow it is calculatedDated byNotes
Tickets createdCount of distinct hs_object_idcreatedateSupport tickets opened, by create date.
Tickets closedCount of distinct hs_object_id, where is_closed = 1closed_dateSupport tickets closed, by close date.
Average days to close a ticketAverage of days_to_close, where is_closed = 1closed_dateMean days from open to close for closed tickets, by close date.
Average hours to first replyAverage of hours_to_first_replycreatedateMean hours until an agent first replied, by ticket create date. Tickets with no reply yet are left out.

[HubSpot] Marketing emails

MetricHow it is calculatedDated byNotes
HubSpot emails sentSum of sentpublish_dateMarketing emails sent, by publish date.
HubSpot emails deliveredSum of deliveredpublish_dateMarketing emails delivered (sent minus bounces), by publish date.
HubSpot email opensSum of openspublish_dateOpens of marketing emails, by publish date. Apple Mail privacy pre-opens inflate it.
HubSpot email clicksSum of clickspublish_dateClicks in marketing emails, by publish date.
HubSpot email unsubscribesSum of unsubscribespublish_dateUnsubscribes from marketing emails, by publish date.
HubSpot email open rateHubSpot email opens ÷ HubSpot emails deliveredpublish_dateOpens per delivered email, as a decimal (0.25 = 25%).
HubSpot email click rateHubSpot email clicks ÷ HubSpot emails deliveredpublish_dateClicks per delivered email, as a decimal (0.02 = 2%).
HubSpot email unsubscribe rateHubSpot email unsubscribes ÷ HubSpot emails deliveredpublish_dateUnsubscribes per delivered email, as a decimal.

[HubSpot] Campaigns

MetricHow it is calculatedDated byNotes
Campaign new contactsSum of new_contacts_first_touchstart_dateNew contacts whose first touch was the campaign (first-touch attribution), by campaign start date.
Campaign influenced contactsSum of influenced_contactsstart_dateContacts who interacted with the campaign, by campaign start date. One contact can count in several campaigns.

Works with other connectors

Questions to ask

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?
No. The HubSpot connector is read-only. Quiriz reads the data into datasets and never writes back to HubSpot.
How often does the HubSpot data refresh?
Once a day. Each dataset shows when it was last updated, and answers use the latest refresh.
Can I change how a metric is calculated?
Yes. The definitions are added to Company Context, where an admin can edit the formula, the filter or the date it uses. A daily refresh never overwrites a definition someone has changed.
Can I combine HubSpot with other sources?
Yes. An admin can also define a metric from metrics on different datasets. See cross-source metrics.

All connectors: Quiriz connectors. Definitions on this page are generated from the product’s own connector code.