Skip to main content
Last updated: February 11, 2026
80 dimensions
34 metrics
This reference covers all available dimensions and metrics for HubSpot data through Detrics. Use this guide to understand what data you can extract and how to structure your queries.
Supported destinations:
Google Sheets

​
Dimensions

Dimensions are the attributes you can use to segment and group your HubSpot data.

​
Account

Account ID
The unique identifier for the HubSpot account

Field Name: accountId
Type: dimension
Account name
The name of the HubSpot account

Field Name: accountName
Type: dimension
Account timezone
The timezone configured for the HubSpot account

Field Name: accountTimezone
Type: dimension
Account currency
The default currency for the HubSpot account

Field Name: accountCurrency
Type: dimension

​
Contact

Contact ID
The unique identifier for the contact in HubSpot

Field Name: contactId
Type: dimension
Contact email
The primary email address of the contact

Field Name: contactEmail
Type: dimension
Contact first name
The first name of the contact

Field Name: contactFirstName
Type: dimension
Contact last name
The last name of the contact

Field Name: contactLastName
Type: dimension
Contact full name
The full name of the contact (first + last)

Field Name: contactFullName
Type: dimension
Contact phone
The primary phone number of the contact

Field Name: contactPhone
Type: dimension
Contact mobile phone
The mobile phone number of the contact

Field Name: contactMobilePhone
Type: dimension
Contact company
The company name associated with the contact

Field Name: contactCompany
Type: dimension
Contact job title
The job title of the contact

Field Name: contactJobTitle
Type: dimension
Contact lifecycle stage
The lifecycle stage of the contact (e.g., subscriber, lead, customer)

Field Name: contactLifecycleStage
Type: dimension
Contact lead status
The lead status of the contact (e.g., new, open, in progress)

Field Name: contactLeadStatus
Type: dimension
Contact city
The city from the contact’s address

Field Name: contactCity
Type: dimension
Contact state
The state or region from the contact’s address

Field Name: contactState
Type: dimension
Contact country
The country from the contact’s address

Field Name: contactCountry
Type: dimension
Contact zip
The zip or postal code from the contact’s address

Field Name: contactZip
Type: dimension
Contact owner ID
The ID of the HubSpot user who owns this contact

Field Name: contactOwnerId
Type: dimension
Contact owner name
The name of the HubSpot user who owns this contact

Field Name: contactOwnerName
Type: dimension
Contact create date
The date the contact was created in HubSpot

Field Name: contactCreateDate
Type: dimension
Contact last modified date
The date the contact was last modified

Field Name: contactLastModifiedDate
Type: dimension
Contact last activity date
The date of the last activity on the contact

Field Name: contactLastActivityDate
Type: dimension
Contact source
The original traffic source that created the contact (e.g., organic, paid, referral)

Field Name: contactSource
Type: dimension
Contact source detail 1
Additional detail about the contact source

Field Name: contactSourceData1
Type: dimension
Contact source detail 2
Further detail about the contact source

Field Name: contactSourceData2
Type: dimension

​
Company

Company ID
The unique identifier for the company in HubSpot

Field Name: companyId
Type: dimension
Company name
The name of the company

Field Name: companyName
Type: dimension
Company domain
The primary domain name of the company

Field Name: companyDomain
Type: dimension
Company industry
The industry the company belongs to

Field Name: companyIndustry
Type: dimension
Company type
The type of company (e.g., prospect, partner, reseller, vendor)

Field Name: companyType
Type: dimension
Company city
The city from the company’s address

Field Name: companyCity
Type: dimension
Company state
The state or region from the company’s address

Field Name: companyState
Type: dimension
Company country
The country from the company’s address

Field Name: companyCountry
Type: dimension
Company zip
The zip or postal code from the company’s address

Field Name: companyZip
Type: dimension
Company phone
The primary phone number of the company

Field Name: companyPhone
Type: dimension
Company website
The website URL of the company

Field Name: companyWebsite
Type: dimension
Company lifecycle stage
The lifecycle stage of the company

Field Name: companyLifecycleStage
Type: dimension
Company lead status
The lead status of the company

Field Name: companyLeadStatus
Type: dimension
Company owner ID
The ID of the HubSpot user who owns this company

Field Name: companyOwnerId
Type: dimension
Company owner name
The name of the HubSpot user who owns this company

Field Name: companyOwnerName
Type: dimension
Company create date
The date the company was created in HubSpot

Field Name: companyCreateDate
Type: dimension
Company last modified date
The date the company was last modified

Field Name: companyLastModifiedDate
Type: dimension
Company last activity date
The date of the last activity on the company

Field Name: companyLastActivityDate
Type: dimension
Company source
The original traffic source that created the company

Field Name: companySource
Type: dimension

​
Deal

Deal ID
The unique identifier for the deal in HubSpot

Field Name: dealId
Type: dimension
Deal name
The name of the deal

Field Name: dealName
Type: dimension
Deal stage ID
The internal ID of the current deal stage

Field Name: dealStage
Type: dimension
Deal stage name
The display name of the current deal stage

Field Name: dealStageName
Type: dimension
Deal pipeline ID
The internal ID of the deal pipeline

Field Name: dealPipeline
Type: dimension
Deal pipeline name
The display name of the deal pipeline

Field Name: dealPipelineName
Type: dimension
Deal type
The type of deal (e.g., new business, existing business)

Field Name: dealType
Type: dimension
Deal description
A text description of the deal

Field Name: dealDescription
Type: dimension
Deal owner ID
The ID of the HubSpot user who owns this deal

Field Name: dealOwnerId
Type: dimension
Deal owner name
The name of the HubSpot user who owns this deal

Field Name: dealOwnerName
Type: dimension
Deal create date
The date the deal was created in HubSpot

Field Name: dealCreateDate
Type: dimension
Deal last modified date
The date the deal was last modified

Field Name: dealLastModifiedDate
Type: dimension
Deal close date
The expected or actual close date of the deal

Field Name: dealCloseDate
Type: dimension
Deal closed won date
The date the deal was marked as closed won

Field Name: dealClosedWonDate
Type: dimension
Deal closed lost reason
The reason the deal was lost

Field Name: dealClosedLostReason
Type: dimension
Deal closed won reason
The reason the deal was won

Field Name: dealClosedWonReason
Type: dimension
Deal source
The original traffic source for the deal

Field Name: dealSource
Type: dimension
Deal source detail 1
Additional detail about the deal source

Field Name: dealSourceData1
Type: dimension
Deal source detail 2
Further detail about the deal source

Field Name: dealSourceData2
Type: dimension
Deal priority
The priority level of the deal

Field Name: dealPriority
Type: dimension

​
Ticket

Ticket ID
The unique identifier for the ticket in HubSpot

Field Name: ticketId
Type: dimension
Ticket name
The subject/name of the support ticket

Field Name: ticketName
Type: dimension
Ticket status
The current status of the ticket in its pipeline

Field Name: ticketStatus
Type: dimension
Ticket pipeline ID
The internal ID of the ticket pipeline

Field Name: ticketPipeline
Type: dimension
Ticket pipeline name
The display name of the ticket pipeline

Field Name: ticketPipelineName
Type: dimension
Ticket category
The category of the support ticket

Field Name: ticketCategory
Type: dimension
Ticket priority
The priority level of the ticket (e.g., low, medium, high)

Field Name: ticketPriority
Type: dimension
Ticket description
The content/description of the support ticket

Field Name: ticketDescription
Type: dimension
Ticket owner ID
The ID of the HubSpot user who owns this ticket

Field Name: ticketOwnerId
Type: dimension
Ticket owner name
The name of the HubSpot user who owns this ticket

Field Name: ticketOwnerName
Type: dimension
Ticket create date
The date the ticket was created in HubSpot

Field Name: ticketCreateDate
Type: dimension
Ticket last modified date
The date the ticket was last modified

Field Name: ticketLastModifiedDate
Type: dimension
Ticket close date
The date the ticket was closed

Field Name: ticketCloseDate
Type: dimension
Ticket source
The source/channel the ticket was created from

Field Name: ticketSource
Type: dimension

​
Metrics

Metrics are the numerical values you can measure and analyze from your HubSpot campaigns.

​
Contact

Number of contacts
The total number of contacts returned

Field Name: contactCount
Type: metric
Contact associated deals
The number of deals associated with the contact

Field Name: contactNumAssociatedDeals
Type: metric
Contact notes
The number of notes on the contact record

Field Name: contactNumNotes
Type: metric
Contact page views
The number of page views tracked for this contact

Field Name: contactNumPageViews
Type: metric
Contact visits
The number of website visits tracked for this contact

Field Name: contactNumVisits
Type: metric
Contact days to close
The number of days it took for the contact to become a customer

Field Name: contactDaysToClose
Type: metric
Contact total revenue
The total revenue attributed to this contact

Field Name: contactTotalRevenue
Type: metric
Contact recent deal amount
The amount of the contact’s most recent deal

Field Name: contactRecentDealAmount
Type: metric

​
Company

Number of companies
The total number of companies returned

Field Name: companyCount
Type: metric
Company employees
The number of employees at the company

Field Name: companyNumberOfEmployees
Type: metric
Company annual revenue
The annual revenue of the company

Field Name: companyAnnualRevenue
Type: metric
Company associated contacts
The number of contacts associated with this company

Field Name: companyNumAssociatedContacts
Type: metric
Company associated deals
The number of deals associated with this company

Field Name: companyNumAssociatedDeals
Type: metric
Company notes
The number of notes on the company record

Field Name: companyNumNotes
Type: metric
Company total deal value
The total value of all deals associated with this company

Field Name: companyTotalDealValue
Type: metric
Company days to close
The average number of days to close deals for this company

Field Name: companyDaysToClose
Type: metric
Company total revenue
The total revenue from deals associated with this company

Field Name: companyTotalRevenue
Type: metric
Company recent deal amount
The amount of the company’s most recent deal

Field Name: companyRecentDealAmount
Type: metric

​
Deal

Number of deals
The total number of deals returned

Field Name: dealCount
Type: metric
Deal amount
The monetary amount of the deal

Field Name: dealAmount
Type: metric
Deal amount (home currency)
The deal amount converted to the account home currency

Field Name: dealAmountInHomeCurrency
Type: metric
Deal forecast amount
The weighted forecast amount based on deal probability

Field Name: dealForecastAmount
Type: metric
Deal days to close
The number of days from deal creation to close

Field Name: dealDaysToClose
Type: metric
Deal associated contacts
The number of contacts associated with this deal

Field Name: dealNumAssociatedContacts
Type: metric
Deal notes
The number of notes on the deal record

Field Name: dealNumNotes
Type: metric
Deals closed won
The number of deals that have been closed as won

Field Name: dealClosedWonCount
Type: metric
Deal MRR
Monthly recurring revenue associated with the deal

Field Name: dealMrr
Type: metric
Deal ARR
Annual recurring revenue associated with the deal

Field Name: dealArr
Type: metric
Deal ACV
Annual contract value of the deal

Field Name: dealAcv
Type: metric
Deal TCV
Total contract value of the deal

Field Name: dealTcv
Type: metric

​
Ticket

Number of tickets
The total number of tickets returned

Field Name: ticketCount
Type: metric
Ticket time to close
The time in milliseconds from ticket creation to close

Field Name: ticketTimeToClose
Type: metric
Ticket time to first response
The time in milliseconds from ticket creation to the first agent reply

Field Name: ticketTimeToFirstResponse
Type: metric
Ticket notes
The number of notes on the ticket record

Field Name: ticketNumNotes
Type: metric