Supermetrics brings all your HubSpot data into Google Sheets, Looker Studio, Excel, BigQuery, Snowflake, Redshift, Azure

HubSpot Updates

Updates on the HubSpot data source, including new metrics, dimensions, and other features.

April 2021

2021-04-15 -

Added new fields:

  • Deal owner's team name
  • Ticket owner's team name

Renamed two fields:

  • Deal HubSpot team => Deal owner's team ID
  • Ticket hubspot team => Ticket owner's team ID

March 2021

2021-03-10 -

The following fields were originally incorrectly defined as dimensions. We have now changed them to be metrics:

  • Company page views
  • Number of sessions
  • Number of form submissions
  • Sends since last engagement
  • Average page views
  • Event revenue

The following dimension has been added:

  • Contact company name

Feb. 2021

2021-02-10 -

Added a new dimension:

  • Contact added to list date

New advanced setting added to control which dates are used for Ticket-based data. See this article for more information.

July 2020

2020-07-10 -

New fields have been added to support Workflows:

  • Workflow ID
  • Workflow name
  • Workflow description
  • Workflow type
  • Is workflow enabled
  • Only executed on business days
  • Is workflow listening
  • Is workflow segment based
  • Workflow create date
  • Workflow last update date
  • Allow contact to trigger multiple times
  • Allow enrollment from merge
  • Only enrolls manually
  • Workflow starting list is done processing
  • Total workflow enrolled contacts
  • Total workflow active contacts
  • Total workflow completed contacts
  • Total workflow succeeded contacts
  • Total workflow starting contacts
  • Workflow conversion rate (%)
  • Contacts enrolled
  • Contacts lost
  • Contacts completed
  • Contacts met goals
  • Ongoing conversion rate (%)

2020-07-22 -

New fields have been added:

  • Deal currency
  • Portal currency

2020-07-29 -

New fields have been added to support Tickets:

  • Ticket category
  • Ticket close date
  • Ticket create date
  • Ticket first email response date
  • Ticket HubSpot team
  • Ticket last activity date
  • Ticket last contacted date
  • Ticket last customer reply date
  • Ticket last modified date
  • Ticket next activity date
  • Ticket number of times contacted
  • Ticket owner assigned date
  • Ticket pipeline
  • Ticket priority
  • Ticket source
  • Ticket description
  • Ticket id
  • Ticket name
  • Ticket owner
  • Ticket status
  • Ticket time to close (minutes)
  • Ticket time to first reply (minutes)

Support also added for custom Ticket-related fields/properties.

June 2020

2020-06-24 -

New metrics added:

  • Instant blog subscribers
  • Daily blog subscribers
  • Weekly blog subscribers
  • Monthly blog subscribers

May 2020

2020-05-13:

New advanced setting added to control which dates are used for Email-based data. See this article for more information.

April 2020

2020-04-07-

The following fields have been added for traffic analytics:

  • Traffic sessions
  • Traffic bounces
  • Traffic bounce rate (%)
  • Traffic page views

The following existing fields have been renamed to make it clear they are traffic analytics-specific:

Old Field Name New Field Name
New visitor sessions Traffic new visitor sessions
Avg. session length (seconds) Avg. traffic session length (seconds)
Session to contact rate Traffic session to contact rate
Contact to customer rate Traffic contact to customer rate
New sessions (%) New traffic sessions (%)
Avg. page views per session Avg. traffic page views per session

Feb. 2020

2020-02-03 - new Analytics Sources fields added:

  • Sessions
  • New visitor sessions
  • Avg. session length (seconds)
  • Session to customer rate
  • New sessions (%)
  • Avg. page views per session

2020-02-25 -

The following fields have had their display names adjusted to increase clarity of what they are:

Current Display Name New Display Name
Campaign ID Email campaign ID
Campaign name Email campaign name
Campaign type Email campaign type
Campaign subtype Email campaign subtype
Campaign group ID Email campaign group ID
Campaign subject Email campaign subject
Content ID Email campaign content ID
Link to campaign in Hubspot UI Link to email campaign in Hubspot UI

Jan. 2020

2020-01-23:

"Deal stage" and "Deal pipeline" fields now display the friendly label, making them easier to read and use.

New dimension added:

  • Link ID

2020-01-30 - new field added:

  • Contact hubspot score

Dec. 2019

2019-12-10 - two new options added to control what dates are used for Deals and Contacts (more info here).

  • Contacts dates based on
  • Deal dates based on

Nov. 2019

2019-11-13:

Added owner-related dimensions added for Contacts and Companies:

  • Contact owner ID
  • Contact owner type
  • Contact owner name
  • Company owner ID
  • Company owner type
  • Company owner name

New metrics added for avg. days between various contact stages:

  • Became a subscriber avg. contact time (days)
  • Became a MQL avg. contact time (days)
  • Became a SQL avg. contact time (days)
  • Became an opportunity avg. contact time (days)
  • Became a customer avg. contact time (days)
  • Became an evangelist avg. contact time (days)
  • Became a lead avg. subscriber time (days)
  • Became a MQL avg. subscriber time (days)
  • Became a SQL avg. subscriber time (days)
  • Became an opportunity avg. subscriber time (days)
  • Became a customer avg. subscriber time (days)
  • Became an evangelist avg. subscriber time (days)
  • Became an evangelist avg. lead time (days)
  • Became a SQL avg. MQL time (days)
  • Became an opportunity avg. MQL time (days)
  • Became a customer avg. MQL time (days)
  • Became an evangelist avg. MQL time (days)
  • Became an opportunity avg. SQL time (days)
  • Became a customer avg. SQL time (days)
  • Became an evangelist avg. SQL time (days)
  • Became a customer avg. opportunity time (days)
  • Became an evangelist avg. opportunity time (days)
  • Became an evangelist avg. customer time (days)

Added new count fields for deal types:

  • "Appointment scheduled" deals
  • "Qualified to buy" deals
  • "Presentation scheduled" deals
  • "Decision maker bought-in" deals
  • "Contact sent" deals

2019-11-22 - new metrics added for recurring revenue:

  • Recurring revenue amount
  • Recurring revenue deal type
  • Recurring revenue inactive date
  • Recurring revenue inactive reason

2019-11-26 - new dimension added:

  • Blog post author

Oct. 2019

2019-10-02 - New metric added:

  • Conversion rate (%)

2019-10-24 - Support for custom fields in  "Contacts", "Companies", and "Deals".

2019-10-31 - 

New dimensions added to support Blogs endpoint:

  • Blog ID
  • Blog Name
  • Blog URL
  • Blog description

New email dimensions added:

  • A/B variation
  • Marketing email name