HubSpot Contacts metrics and dimensions

  • Updated on Apr 2, 2026
  • Published on Apr 2, 2026
Prev Next

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

Early Access41 metrics242 dimensionsCustom fields

ADS PROPERTIES

date_of_birth
Field label Date of birth
Description The date of birth as provided through a lead ad form, set by the ads tool
Field type dimension
Data type string.time.date
gender
Field label Gender
Description The gender as provided through a lead ad form, set by the ads tool
Field type dimension
Data type string.person.gender
marital_status
Field label Marital status
Description The marital status as provided through a lead ad form, set by the ads tool
Field type dimension
Data type string.text.value
relationship_status
Field label Relationship status
Description The relationship status as provided through a lead ad form, set by the ads tool
Field type dimension
Data type string.text.value
military_status
Field label Military status
Description The military status as provided through a lead ad form, set by the ads tool
Field type dimension
Data type string.text.value
work_email
Field label Work email
Description The work email as provided through a lead ad form, set by the ads tool
Field type dimension
Data type string.text.email
job_function
Field label Job function
Description The job function as provided through a lead ad form, set by the ads tool
Field type dimension
Data type string.text.value
seniority
Field label Seniority
Description The seniority in the company as provided through a lead ad form, set by the ads tool
Field type dimension
Data type string.text.value
company_size
Field label Company size
Description The size of the company as provided through a lead ad form, set by the ads tool
Field type dimension
Data type string.text.value
degree
Field label Degree
Description The degree as provided through a lead ad form, set by the ads tool
Field type dimension
Data type string.text.value
field_of_study
Field label Field of study
Description The field of study as provided through a lead ad form, set by the ads tool
Field type dimension
Data type string.text.value
school
Field label School
Description The school as provided through a lead ad form, set by the ads tool
Field type dimension
Data type string.text.value
start_date
Field label Start date
Description The start date of education as provided through a lead ad form, set by the ads tool
Field type dimension
Data type string.time.date
graduation_date
Field label Graduation date
Description The graduation date of education as provided through a lead ad form, set by the ads tool
Field type dimension
Data type string.time.date

CONTACT

record_id
Field label Record ID
Description The unique identifier for the contact. This value is set automatically by HubSpot
Field type dimension
Data type string.text.value
first_name
Field label First name
Description The contact's first name
Field type dimension
Data type string.text.value
last_name
Field label Last name
Description The contact's last name
Field type dimension
Data type string.text.value
salutation
Field label Salutation
Description The title used to address the contact
Field type dimension
Data type string.text.value
email
Field label Email
Description The contact's primary email address
Field type dimension
Data type string.text.email
email_domain
Field label Email domain
Description The contact's email domain
Field type dimension
Data type string.text.value
phone_number
Field label Phone number
Description The contact's primary phone number
Field type dimension
Data type string.text.phone
mobile_phone_number
Field label Mobile phone number
Description The contact's mobile phone number
Field type dimension
Data type string.text.phone
fax_number
Field label Fax number
Description The contact's primary fax number
Field type dimension
Data type string.text.phone
company_name
Field label Company name
Description The name of the contact's company
Field type dimension
Data type string.text.value
linkedin_url
Field label LinkedIn URL
Description The URL of the contact's LinkedIn page
Field type dimension
Data type string.text.url
website_url
Field label Website URL
Description The contact's company website
Field type dimension
Data type string.text.url
message
Field label Message
Description A default property to be used for any message or comments the contact may want to leave on a form
Field type dimension
Data type string.text.value
persona
Field label Persona
Description The contact's persona
Field type dimension
Data type string.text.value
job_title
Field label Job title
Description The contact's job title
Field type dimension
Data type string.text.value
employment_role
Field label Employment role
Description The contact's job role (e.g., Operations)
Field type dimension
Data type string.text.value
employment_seniority
Field label Employment seniority
Description The contact's job seniority (e.g., Executive)
Field type dimension
Data type string.text.value
employment_sub_role
Field label Employment sub role
Description The contact's second level job role (e.g., General Manager)
Field type dimension
Data type string.text.value
industry
Field label Industry
Description The contact's industry
Field type dimension
Data type string.text.value
brands
Field label Brands
Description The brands the contact is assigned to
Field type dimension
Data type string.text.value
street_address
Field label Street address
Description The contact's street address, including apartment or unit
Field type dimension
Data type string.geo.street
city
Field label City
Description The contact's city of residence
Field type dimension
Data type string.geo.city
state_region
Field label State/Region
Description The contact's state of residence
Field type dimension
Data type string.geo.region
state_region_code
Field label State/Region code
Description The two letter state code where the contact is located (e.g., TX for Texas)
Field type dimension
Data type string.text.value
postal_code
Field label Postal code
Description The contact's zip code
Field type dimension
Data type string.geo.zip
country_region
Field label Country/Region
Description The contact's country of residence
Field type dimension
Data type string.geo.country
country_region_code
Field label Country/Region code
Description The two letter country code where the contact is located (e.g., UK)
Field type dimension
Data type string.geo.country.twolettercode
time_zone
Field label Time zone
Description The contact's time zone, set manually by selecting a pre-defined time zone. The property's options are static and do not update based on daylight savings time
Field type dimension
Data type string.time.timezone
preferred_language
Field label Preferred language
Description The contact's preferred language for communications
Field type dimension
Data type string.language.value
contact_unworked
Field label Contact unworked
Description An indication if the contact has been worked. If it is true, the contact has not been assigned to an owner, or does not have a sales activity logged in its timeline since the contact was assigned its latest owner
Field type dimension
Data type bool
description_of_first_engagement
Field label Description of first engagement
Description A description of the current contact owner's first engagement with the contact
Field type dimension
Data type string.text.value
id_of_first_engagement
Field label ID of first engagement
Description The object ID of the current contact owner's first engagement with the contact
Field type dimension
Data type string.text.value
first_engagement_datetime
Field label First engagement datetime
Description The datetime the current contact owner first engaged with the contact
Field type dimension
Data type string.time.datetime
first_engagement_date
Field label First engagement date
Description The date the current contact owner first engaged with the contact
Field type dimension
Data type string.time.date
create_datetime
Field label Create datetime
Description The datetime that the contact was created in your HubSpot account
Field type dimension
Data type string.time.datetime
create_date
Field label Create date
Description The date that the contact was created in your HubSpot account
Field type dimension
Data type string.time.date
created_by_user_id
Field label Created by user ID
Description The user who created the contact. This value is set automatically by HubSpot
Field type dimension
Data type string.text.value
last_modified_datetime
Field label Last modified datetime
Description The most recent datetime that any property on a contact record was updated
Field type dimension
Data type string.time.datetime
last_modified_date
Field label Last modified date
Description The most recent date that any property on a contact record was updated
Field type dimension
Data type string.time.date
updated_by_user_id
Field label Updated by user ID
Description The user who last updated the contact. This value is set automatically by HubSpot
Field type dimension
Data type string.text.value
contact_owner_id
Field label Contact owner ID
Description The contact's owner
Field type dimension
Data type string.text.value
owner_assigned_datetime
Field label Owner assigned datetime
Description The most recent datetime of when an owner was assigned to the contact. This value is set automatically by HubSpot
Field type dimension
Data type string.time.datetime
owner_assigned_date
Field label Owner assigned date
Description The most recent date of when an owner was assigned to the contact. This value is set automatically by HubSpot
Field type dimension
Data type string.time.date
shared_teams
Field label Shared teams
Description Additional teams whose users can access the contact based on their permissions
Field type dimension
Data type string.text.value
shared_users
Field label Shared users
Description Additional users can access the contact based on their permissions
Field type dimension
Data type string.text.value
member_email
Field label Member email
Description The email address used to send private content information to members
Field type dimension
Data type string.text.email
merged_contact_ids
Field label Merged contact IDs
Description The Record IDs of contacts that were merged into the contact record. This is automatically set by HubSpot once a contact merge is completed
Field type dimension
Data type string.text.value
lead_status
Field label Lead status
Description The contact and company property that indicates where the contact or company is within a buying cycle as a lead
Field type dimension
Data type string.text.value
lifecycle_stage
Field label Lifecycle stage
Description A property used to indicate at what point the contact is within the marketing/sales process
Field type dimension
Data type string.text.value
last_sequence_enrolled
Field label Last sequence enrolled
Description The unique ID of the last sequence that the contact was enrolled in
Field type dimension
Data type string.text.value
last_sequence_enrolled_datetime
Field label Last sequence enrolled datetime
Description the datetime the contact was enrolled into a sequence. This is the date a user enrolled a contact in a sequence, not necessarily the date of the first step that executed
Field type dimension
Data type string.time.datetime
last_sequence_enrolled_date
Field label Last sequence enrolled date
Description The date the contact was enrolled into a sequence. This is the date a user enrolled a contact in a sequence, not necessarily the date of the first step that executed
Field type dimension
Data type string.time.date
last_sequence_ended_datetime
Field label Last sequence ended datetime
Description The datetime that the contact was last unenrolled from a sequence
Field type dimension
Data type string.time.datetime
last_sequence_ended_date
Field label Last sequence ended date
Description The date that the contact was last unenrolled from a sequence
Field type dimension
Data type string.time.date
prospecting_agent_last_enrolled_datetime
Field label Prospecting agent last enrolled datetime
Description The last datetime the contact was enrolled in the prospecting agent
Field type dimension
Data type string.time.datetime
prospecting_agent_last_enrolled_date
Field label Prospecting agent last enrolled date
Description The last date the contact was enrolled in the prospecting agent
Field type dimension
Data type string.time.date
currently_enrolled_in_prospecting_agent
Field label Currently enrolled in prospecting agent
Description Indicates whether or not the contact is enrolled in the prospecting agent
Field type dimension
Data type bool
type_of_first_engagement
Field label Type of first engagement
Description The object type of the current contact owner's first engagement with the contact
Field type dimension
Data type string.text.value
marketing_contact_status
Field label Marketing contact status
Description Indicates if the contact is currently a marketing or non-marketing contact
Field type dimension
Data type string.text.value
marketing_contact_status_source_type
Field label Marketing contact status source type
Description Indicates the tool that set the latest value in the contact's marketing contact status
Field type dimension
Data type string.text.value
marketing_contact_status_source_name
Field label Marketing contact status source name
Description Indicates the ID of the specific activity that set the latest value in the contact's marketing contact status
Field type dimension
Data type string.text.value
marketing_contact_until_next_update
Field label Marketing contact until next update
Description Specifies if this contact will be set as non-marketing on the next update date. When you set an existing marketing contact as non-marketing, the property value will change to Yes, which indicates that the non-marketing status will take effect on the next update date
Field type dimension
Data type bool
enrichment_opt_out
Field label Enrichment opt out
Description Indicates if contact is opted out of being included in the HubSpot Enrichment database
Field type dimension
Data type bool
enrichment_opt_out_timestamp_datetime
Field label Enrichment opt out datetime
Description Datetime of when the contact opted out of being included in the HubSpot enrichment database
Field type dimension
Data type string.time.datetime
enrichment_opt_out_timestamp
Field label Enrichment opt out timestamp
Description Date of when the contact opted out of being included in the HubSpot enrichment database
Field type dimension
Data type string.time.date
legal_basis_for_processing_contacts_data
Field label Legal basis for processing contact's data
Description The legal reasoning for your company's ability to process the contact's data. If this is set to Not applicable, it will exempt the contact from GDPR protections
Field type dimension
Data type string.text.value
has_been_enriched
Field label Has been enriched
Description Indicates whether the contact has ever had enriched properties written to it
Field type dimension
Data type bool
record_source
Field label Record source
Description How the contact was created. This is automatically set by HubSpot
Field type dimension
Data type string.text.value
record_source_detail_1
Field label Record source detail 1
Description The first level of detail on how the contact was created. This is automatically set by HubSpot
Field type dimension
Data type string.text.value
record_source_detail_2
Field label Record source detail 2
Description The second level of detail on how the contact was created. This is automatically set by HubSpot
Field type dimension
Data type string.text.value
record_source_detail_3
Field label Record source detail 3
Description The third level of detail on how the contact was created. This is automatically set by HubSpot
Field type dimension
Data type string.text.value
number_of_contacts
Field label Number of contacts
Description Total number of contacts
Field type metric
Data type int.number.value
number_of_employees
Field label Number of employees
Description The number of company employees
Field type metric
Data type int.number.value
Aggregation Non-aggregatable metric
hubspot_score
Field label HubSpot score
Description The number that shows qualification of contacts to sales readiness based on the criteria set in HubSpot's lead scoring tool
Field type metric
Data type float.number.value
Aggregation Non-aggregatable metric
lead_response_time
Field label Lead response time
Description Time it took the current owner to do first qualifying engagement (ms)
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
number_of_sequences_enrolled
Field label Number of sequences enrolled
Description The number of times a contact was enrolled into a sequence
Field type metric
Data type int.number.value
number_of_sales_activities
Field label Number of sales activities
Description The total number of sales activities logged for the contact. Sales activities include a call, chat conversation, LinkedIn message, postal mail, meeting, note, sales email, SMS message, task, or WhatsApp message
Field type metric
Data type int.number.value
number_of_times_contacted
Field label Number of times contacted
Description The total number of logged sales activities on a contact record. Possible activities include calls, chat conversations, LinkedIn messages, postal mail, meetings, sales emails, SMS, or WhatsApp messages logged on the contact record. Unlike in the Number of sales activities property, tasks and notes are not included in this property
Field type metric
Data type int.number.value
time_between_contact_creation_and_deal_close
Field label Time between contact creation and deal close
Description The amount of time in milliseconds between when a contact was created and when the contact's lifecycle stage became Customer
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
time_between_contact_creation_and_deal_creation
Field label Time between contact creation and deal creation
Description The amount of time in milliseconds between when a contact was created and when the contact was associated with a deal
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
prospecting_agent_total_enrolled_count
Field label Prospecting agent total enrolled count
Description The total number of times a contact has been enrolled in the prospecting agent
Field type metric
Data type int.number.value
annual_revenue
Field label Annual revenue
Description Annual company revenue
Field type metric
Data type float.currency.value
Aggregation Non-aggregatable metric

CONTACT ACTIVITY

contact_priority
Field label Contact priority
Description A ranking system of contacts evenly assigned into four tiers. Contacts in tier one are more likely to become customers than contacts in tier four
Field type dimension
Data type string.text.value
first_conversion
Field label First conversion
Description The first landing page and form the contact submitted on
Field type dimension
Data type string.text.value
first_conversion_datetime
Field label First conversion datetime
Description The datetime the contact first submitted a form
Field type dimension
Data type string.time.datetime
first_conversion_date
Field label First conversion date
Description The date the contact first submitted a form
Field type dimension
Data type string.time.date
last_activity_datetime
Field label Last activity datetime
Description The most recent already past date and time a note, call, tracked and logged sales email, meeting, linkedin/sms/whatsapp message, or chat was logged on the contact record. It also includes completed tasks
Field type dimension
Data type string.time.datetime
last_activity_date
Field label Last activity date
Description The most recent already past date a note, call, tracked and logged sales email, meeting, linkedin/sms/whatsapp message, or chat was logged on the contact record. It also includes completed tasks
Field type dimension
Data type string.time.date
last_contacted_datetime
Field label Last contacted datetime
Description The last date and time a chat conversation, call, non-forwarded one-to-one email, meeting, or manually entered linkedin/sms/whatsapp message was logged for the contact
Field type dimension
Data type string.time.datetime
last_contacted_date
Field label Last contacted date
Description The last date a chat conversation, call, non-forwarded one-to-one email, meeting, or manually entered linkedin/sms/whatsapp message was logged for the contact
Field type dimension
Data type string.time.date
last_nps_survey_datetime
Field label Last NPS survey datetime
Description The datetime that the contact last submitted a NPS survey response
Field type dimension
Data type string.time.datetime
last_nps_survey_date
Field label Last NPS survey date
Description The date that the contact last submitted a NPS survey response
Field type dimension
Data type string.time.date
last_nps_survey_rating
Field label Last NPS survey rating
Description The last NPS survey rating that the contact gave
Field type dimension
Data type string.text.value
last_nps_survey_comment
Field label Last NPS survey comment
Description The last NPS survey comment that the contact gave
Field type dimension
Data type string.text.value
likelihood_to_close
Field label Likelihood to close
Description The probability that the contact will become a customer within the next 90 days. This score is based on demographic information in standard contact properties and interactions logged in the contact timeline such as tracked email clicks and meetings booked
Field type dimension
Data type string.text.value
next_activity_datetime
Field label Next activity datetime
Description The datetime of the next upcoming activity for the contact. This includes logging a future call, sales email, or meeting, or scheduling a future meeting
Field type dimension
Data type string.time.datetime
next_activity_date
Field label Next activity date
Description The date of the next upcoming activity for the contact. This includes logging a future call, sales email, or meeting, or scheduling a future meeting
Field type dimension
Data type string.time.date
recent_sales_email_opened_datetime
Field label Recent sales email opened datetime
Description The datetime of the last time that the contact opened a sales email. This property does not update for emails that were sent to more than one contact
Field type dimension
Data type string.time.datetime
recent_sales_email_opened_date
Field label Recent sales email opened date
Description The date of the last time that the contact opened a sales email. This property does not update for emails that were sent to more than one contact
Field type dimension
Data type string.time.date
recent_sales_email_clicked_datetime
Field label Recent sales email clicked datetime
Description The datetime of the last time that the contact clicked on a sales email
Field type dimension
Data type string.time.datetime
recent_sales_email_clicked_date
Field label Recent sales email clicked date
Description The date of the last time that the contact clicked on a sales email
Field type dimension
Data type string.time.date
recent_sales_email_replied_datetime
Field label Recent sales email replied datetime
Description The datetime of the last time that the contact sent an email to your connected personal or team email
Field type dimension
Data type string.time.datetime
recent_sales_email_replied_date
Field label Recent sales email replied date
Description The date of the last time that the contact sent an email to your connected personal or team email
Field type dimension
Data type string.time.date
campaign_of_last_booking_in_meetings_tool
Field label Campaign of last booking in meetings tool
Description This utm parameter shows which marketing campaign (e.g. a specific email) referred the contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link
Field type dimension
Data type string.text.value
last_meeting_booked_in_meetings_tool_datetime
Field label Last meeting booked in meetings tool datetime
Description The datetime of the meeting that is booked the farthest out from the current date. For example, if a meeting is booked for december 1st, and another meeting is booked for december 7th, the property value will appear as december 7th
Field type dimension
Data type string.time.datetime
last_meeting_booked_in_meetings_tool_date
Field label Last meeting booked in meetings tool date
Description The date of the meeting that is booked the farthest out from the current date. For example, if a meeting is booked for december 1st, and another meeting is booked for december 7th, the property value will appear as december 7th
Field type dimension
Data type string.time.date
medium_of_last_booking_in_meetings_tool
Field label Medium of last booking in meetings tool
Description This utm parameter shows which channel (e.g. email) referred the contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link
Field type dimension
Data type string.text.value
source_of_last_booking_in_meetings_tool
Field label Source of last booking in meetings tool
Description This utm parameter shows which site (e.g. linkedin) referred the contact to the meetings tool for their most recent booking. This property is only populated when you add tracking parameters to your meeting link
Field type dimension
Data type string.text.value
currently_in_sequence
Field label Currently in sequence
Description Indicates whether or not the contact is enrolled in a sequence. This is set automatically to true when the contact is currently enrolled in a sequence
Field type dimension
Data type bool
last_engagement_datetime
Field label Last engagement datetime
Description The last date and time of one-to-one email opens and clicks, lead revisit notifications, meeting bookings, and form submissions on the contact record. This is set automatically by HubSpot based on the date/time set for an activity when it's logged on the record only when the contact owner property has a value
Field type dimension
Data type string.time.datetime
last_engagement_date
Field label Last engagement date
Description The last date of one-to-one email opens and clicks, lead revisit notifications, meeting bookings, and form submissions on the contact record. This is set automatically by HubSpot based on the date/time set for an activity when it's logged on the record only when the contact owner property has a value
Field type dimension
Data type string.time.date

CONTACT CALCULATED

sources
Field label Sources
Description The offline sources or online sources where the contact is derived from and can be used when building a custom report to show you a count of contacts who originated from either source type
Field type dimension
Data type string.text.value

CONVERSION

facebook_click_id
Field label Facebook click ID
Description A value that indicates a contact's visit to your site came from a facebook ad. This is automatically set by hubspot based on a url identifier provided by facebook ads
Field type dimension
Data type string.text.value
google_ad_click_id
Field label Google ad click ID
Description A value that indicates a contact's visit to your site came from a google ad. This is automatically set by hubspot based on a google click identifier (gclid) provided by google ads
Field type dimension
Data type string.text.value
ip_city
Field label IP city
Description The city reported by the contact's ip address. This is automatically set by hubspot and can be used for segmentation and reporting
Field type dimension
Data type string.geo.city
ip_country
Field label IP country
Description The country reported by the contact's ip address. This is automatically set by hubspot and can be used for segmentation and reporting
Field type dimension
Data type string.geo.country
ip_country_code
Field label IP country code
Description The country code (in alpha-2 format) reported by the contact's ip address. This is automatically set by hubspot and can be used for segmentation and reporting
Field type dimension
Data type string.geo.country.twolettercode
ip_state_region
Field label IP state/region
Description The state or region reported by the contact's ip address. This is automatically set by hubspot and can be used for segmentation and reporting
Field type dimension
Data type string.geo.region
ip_state_region_code
Field label IP state/region code (IP State Code/Region Code)
Description The state code or region code reported by the contact's ip address. This is automatically set by hubspot and can be used for segmentation and reporting
Field type dimension
Data type string.text.value
ip_time_zone
Field label IP time zone (IP Timezone)
Description The timezone reported by the contact's ip address. This is automatically set by hubspot and can be used for segmentation and reporting. This property is used to determine the contact's time zone for the time zone send email feature
Field type dimension
Data type string.time.timezone
recent_conversion
Field label Recent conversion
Description The last form the contact submitted. This is formatted as the name of the page the form was submitted on, followed by a colon, then the name of the submitted form (i.e., page title: name of form)
Field type dimension
Data type string.text.value
recent_conversion_datetime
Field label Recent conversion datetime
Description The datetime the contact last submitted a form
Field type dimension
Data type string.time.datetime
recent_conversion_date
Field label Recent conversion date
Description The date the contact last submitted a form
Field type dimension
Data type string.time.date
number_of_form_submissions
Field label Number of form submissions
Description The number of forms the contact has submitted. This includes both marketing form submissions and meetings scheduling page form submissions
Field type metric
Data type int.number.value
number_of_unique_forms_submitted
Field label Number of unique forms submitted
Description The number of different hubspot forms, pop-up forms, and collected forms the contact has submitted
Field type metric
Data type int.number.value

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DEAL

buying_role
Field label Buying role
Description The role that the contact plays during the sales process. You can select more than one role. The property value plays a part in HubSpot's account-based marketing features
Field type dimension
Data type string.text.value
close_datetime
Field label Close datetime
Description The date that the contact became a customer. This will be automatically set by HubSpot based on associated deals only if the set lifecycle stage when a deal is won setting is turned on and the contact is moved to the default customer stage (i.e. not a custom stage)
Field type dimension
Data type string.time.datetime
close_date
Field label Close date
Description The date that the contact became a customer. This will be automatically set by HubSpot based on associated deals only if the set lifecycle stage when a deal is won setting is turned on and the contact is moved to the default customer stage (i.e. not a custom stage)
Field type dimension
Data type string.time.date
first_deal_created_datetime
Field label First deal created datetime
Description The create date of the first deal the contact is associated to
Field type dimension
Data type string.time.datetime
first_deal_created_date
Field label First deal created date
Description The create date of the first deal the contact is associated to
Field type dimension
Data type string.time.date
recent_deal_close_datetime
Field label Recent deal close datetime
Description The date of the last associated deal that was closed as won
Field type dimension
Data type string.time.datetime
recent_deal_close_date
Field label Recent deal close date
Description The date of the last associated deal that was closed as won
Field type dimension
Data type string.time.date
days_to_close
Field label Days to close
Description The number of days between the day the contact was added to your account and the day they became a customer. This is set automatically by HubSpot based on the contact's values for the create date and close date properties
Field type metric
Data type int.number.value
Aggregation Non-aggregatable metric
number_of_associated_deals
Field label Number of associated deals
Description The total number of all associated deals
Field type metric
Data type int.number.value
recent_deal_amount
Field label Recent deal amount
Description The value of the last closed-won deal associated with that contact
Field type metric
Data type float.currency.value
Aggregation Non-aggregatable metric
total_revenue
Field label Total revenue
Description Total dollar amount of all associated deals that have been closed as won
Field type metric
Data type float.currency.value

EMAIL

email_address_quarantined
Field label Email address quarantined
Description Indicates that the current email address has been quarantined for anti-abuse reasons. HubSpot will not send any marketing emails to quarantined email addresses
Field type dimension
Data type bool
email_hard_bounce_reason
Field label Email hard bounce reason
Description The last reason why an email hard bounced for the contact
Field type dimension
Data type string.text.value
invalid_email_address
Field label Invalid email address
Description Whether the email address is invalid
Field type dimension
Data type bool
marketing_email_confirmation_status
Field label Marketing email confirmation status
Description The status of the contact's eligibility to receive email. This property is automatically set by HubSpot based on a contact's interaction with the double opt-in email and their confirmation status
Field type dimension
Data type string.text.value
first_marketing_email_send_datetime
Field label First marketing email send datetime
Description The datetime of the earliest email delivery for any marketing email
Field type dimension
Data type string.time.datetime
first_marketing_email_send_date
Field label First marketing email send date
Description The date of the earliest email delivery for any marketing email
Field type dimension
Data type string.time.date
first_marketing_email_open_datetime
Field label First marketing email open datetime
Description The datetime of the earliest email open for any marketing email
Field type dimension
Data type string.time.datetime
first_marketing_email_open_date
Field label First marketing email open date
Description The date of the earliest email open for any marketing email
Field type dimension
Data type string.time.date
first_marketing_email_click_datetime
Field label First marketing email click datetime
Description The datetime of the earliest link click for any marketing email
Field type dimension
Data type string.time.datetime
first_marketing_email_click_date
Field label First marketing email click date
Description The date of the earliest link click for any marketing email
Field type dimension
Data type string.time.date
first_marketing_email_reply_datetime
Field label First marketing email reply datetime
Description The datetime of the earliest reply for any marketing email
Field type dimension
Data type string.time.datetime
first_marketing_email_reply_date
Field label First marketing email reply date
Description The date of the earliest reply for any marketing email
Field type dimension
Data type string.time.date
last_marketing_email_send_datetime
Field label Last marketing email send datetime
Description The datetime of the most recent email delivery for any marketing email
Field type dimension
Data type string.time.datetime
last_marketing_email_send_date
Field label Last marketing email send date
Description The date of the most recent email delivery for any marketing email
Field type dimension
Data type string.time.date
last_marketing_email_open_datetime
Field label Last marketing email open datetime
Description The datetime of the most recent email open for any marketing email
Field type dimension
Data type string.time.datetime
last_marketing_email_open_date
Field label Last marketing email open date
Description The date of the most recent email open for any marketing email
Field type dimension
Data type string.time.date
last_marketing_email_click_datetime
Field label Last marketing email click datetime
Description The datetime of the most recent link click for any marketing email
Field type dimension
Data type string.time.datetime
last_marketing_email_click_date
Field label Last marketing email click date
Description The date of the most recent link click for any marketing email
Field type dimension
Data type string.time.date
last_marketing_email_reply_datetime
Field label Last marketing email reply datetime
Description The datetime of the most recent reply for any marketing email
Field type dimension
Data type string.time.datetime
last_marketing_email_reply_date
Field label Last marketing email reply date
Description The date of the most recent reply for any marketing email
Field type dimension
Data type string.time.date
last_marketing_email_name
Field label Last marketing email name
Description The name of the last marketing email sent
Field type dimension
Data type string.text.value
unsubscribed_from_all_email
Field label Unsubscribed from all email
Description Indicates that the current email address has opted out of all email from the account
Field type dimension
Data type bool
opted_out_of_email_one_to_one
Field label Opted out of email: one to one
Description Indicates that the current email address has opted out from emails of the specified type
Field type dimension
Data type string.text.value
opted_out_of_email_marketing_information
Field label Opted out of email: marketing information
Description Indicates that the current email address has opted out from emails of the specified type
Field type dimension
Data type string.text.value
marketing_emails_delivered
Field label Marketing emails delivered
Description The number of unique marketing email delivered events for the current email address. This value is incremented at most once per campaign id. Regular emails have one campaign id. Automated emails have one campaign id per workflow they are sent through. This means one automated email delivered to a contact via two separate workflows can increment the value by two
Field type metric
Data type int.number.value
marketing_emails_bounced
Field label Marketing emails bounced
Description The number of marketing emails sent from your account that hard or soft bounced (this does not include global bounces, that are bounces in any account in HubSpot's system for a permanent reason, such as an invalid recipient)
Field type metric
Data type int.number.value
marketing_emails_opened
Field label Marketing emails opened
Description The number of marketing emails opened. This value is incremented at most once per email so if the same email is opened multiple times, this value will only increase by one. Transactional email interactions do not count towards opens
Field type metric
Data type int.number.value
marketing_emails_clicked
Field label Marketing emails clicked
Description The number of marketing emails which have had link clicks. This value is incremented at most once per email so if the same link is clicked multiple times, or multiple links in the same email are clicked, this value will only increase by one. Transactional email interactions do not count towards clicks
Field type metric
Data type int.number.value
sends_since_last_engagement
Field label Sends since last engagement
Description The number of marketing emails that have been sent since the last engagement, specifically email open or link click. Transactional email interactions do not count towards engagement
Field type metric
Data type int.number.value

LIFECYCLE STAGE

entered_subscriber_datetime
Field label Entered subscriber datetime
Description The date and time when the contact entered the subscriber stage
Field type dimension
Data type string.time.datetime
entered_subscriber_date
Field label Entered subscriber date
Description The date when the contact entered the subscriber stage
Field type dimension
Data type string.time.date
entered_lead_datetime
Field label Entered lead datetime
Description The date and time when the contact entered the lead stage
Field type dimension
Data type string.time.datetime
entered_lead_date
Field label Entered lead date
Description The date when the contact entered the lead stage
Field type dimension
Data type string.time.date
entered_marketing_qualified_lead_datetime
Field label Entered marketing qualified lead datetime
Description The date and time when the contact entered the marketing qualified lead stage
Field type dimension
Data type string.time.datetime
entered_marketing_qualified_lead_date
Field label Entered marketing qualified lead date
Description The date when the contact entered the marketing qualified lead stage
Field type dimension
Data type string.time.date
entered_sales_qualified_lead_datetime
Field label Entered sales qualified lead datetime
Description The date and time when the contact entered the sales qualified lead stage
Field type dimension
Data type string.time.datetime
entered_sales_qualified_lead_date
Field label Entered sales qualified lead date
Description The date when the contact entered the sales qualified lead stage
Field type dimension
Data type string.time.date
entered_opportunity_datetime
Field label Entered opportunity datetime
Description The date and time when the contact entered the opportunity stage
Field type dimension
Data type string.time.datetime
entered_opportunity_date
Field label Entered opportunity date
Description The date when the contact entered the Opportunity stage
Field type dimension
Data type string.time.date
entered_customer_datetime
Field label Entered customer datetime
Description The date and time when the contact entered the customer stage
Field type dimension
Data type string.time.datetime
entered_customer_date
Field label Entered customer date
Description The date when the contact entered the customer stage
Field type dimension
Data type string.time.date
entered_evangelist_datetime
Field label Entered evangelist datetime
Description The date and time when the contact entered the evangelist stage
Field type dimension
Data type string.time.datetime
entered_evangelist_date
Field label Entered evangelist date
Description The date when the contact entered the evangelist stage
Field type dimension
Data type string.time.date
exited_subscriber_datetime
Field label Exited subscriber datetime
Description The date and time when the contact exited the subscriber stage
Field type dimension
Data type string.time.datetime
exited_subscriber_date
Field label Exited subscriber date
Description The date and time when the contact exited the subscriber stage
Field type dimension
Data type string.time.date
exited_lead_datetime
Field label Exited lead datetime
Description The date and time when the contact exited the lead stage
Field type dimension
Data type string.time.datetime
exited_lead_date
Field label Exited lead date
Description The date and time when the contact exited the lead stage
Field type dimension
Data type string.time.date
exited_marketing_qualified_lead_datetime
Field label Exited marketing qualified lead datetime
Description The date and time when the contact exited the marketing qualified lead stage
Field type dimension
Data type string.time.datetime
exited_marketing_qualified_lead_date
Field label Exited marketing qualified lead date
Description The date and time when the contact exited the marketing qualified lead stage
Field type dimension
Data type string.time.date
exited_sales_qualified_lead_datetime
Field label Exited sales qualified lead datetime
Description The date and time when the contact exited the sales qualified lead stage
Field type dimension
Data type string.time.datetime
exited_sales_qualified_lead_date
Field label Exited sales qualified lead date
Description The date and time when the contact exited the sales qualified lead stage
Field type dimension
Data type string.time.date
exited_opportunity_datetime
Field label Exited opportunity datetime
Description The date and time when the contact exited the opportunity stage
Field type dimension
Data type string.time.datetime
exited_opportunity_date
Field label Exited opportunity date
Description The date and time when the contact exited the opportunity stage
Field type dimension
Data type string.time.date
exited_customer_datetime
Field label Exited customer datetime
Description The date and time when the contact exited the customer stage
Field type dimension
Data type string.time.datetime
exited_customer_date
Field label Exited customer date
Description The date and time when the contact exited the customer stage
Field type dimension
Data type string.time.date
exited_evangelist_datetime
Field label Exited evangelist datetime
Description The date and time when the contact exited the evangelist stage
Field type dimension
Data type string.time.datetime
exited_evangelist_date
Field label Exited evangelist date
Description The date and time when the contact exited the evangelist stage
Field type dimension
Data type string.time.date
cumulative_time_in_subscriber
Field label Cumulative time in (subscriber)
Description The cumulative time in milliseconds spent by the contact in the subscriber stage
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
cumulative_time_in_lead
Field label Cumulative time in (lead)
Description The cumulative time in milliseconds spent by the contact in the lead stage
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
cumulative_time_in_marketing_qualified_lead
Field label Cumulative time in (marketing qualified lead)
Description The cumulative time in milliseconds spent by the contact in the marketing qualified lead stage
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
cumulative_time_in_sales_qualified_lead
Field label Cumulative time in (sales qualified lead)
Description The cumulative time in milliseconds spent by the contact in the sales qualified lead stage
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
cumulative_time_in_opportunity
Field label Cumulative time in (opportunity)
Description The cumulative time in milliseconds spent by the contact in the opportunity stage
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
cumulative_time_in_customer
Field label Cumulative time in (customer)
Description The cumulative time in milliseconds spent by the contact in the customer stage
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
cumulative_time_in_evangelist
Field label Cumulative time in (evangelist)
Description The cumulative time in milliseconds spent by the contact in the evangelist stage
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
latest_time_in_subscriber
Field label Latest time in (subscriber)
Description The total time in milliseconds spent by the contact in the stage since it last entered the subscriber stage
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
latest_time_in_lead
Field label Latest time in (lead)
Description The total time in milliseconds spent by the contact in the stage since it last entered the lead stage
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
latest_time_in_marketing_qualified_lead
Field label Latest time in (marketing qualified lead)
Description The total time in milliseconds spent by the contact in the stage since it last entered the marketing qualified lead stage
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
latest_time_in_sales_qualified_lead
Field label Latest time in (sales qualified lead)
Description The total time in milliseconds spent by the contact in the stage since it last entered the sales qualified lead stage
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
latest_time_in_opportunity
Field label Latest time in (opportunity)
Description The total time in milliseconds spent by the contact in the stage since it last entered the opportunity stage
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
latest_time_in_customer
Field label Latest time in (customer)
Description The total time in milliseconds spent by the contact in the stage since it last entered the customer stage
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric
latest_time_in_evangelist
Field label Latest time in (evangelist)
Description The total time in milliseconds spent by the contact in the stage since it last entered the evangelist stage
Field type metric
Data type int.duration.seconds
Aggregation Non-aggregatable metric

PRIVATE CONTENT ACCESS PROPERTIES

domain_to_which_registration_email_was_sent
Field label Domain to which registration email was sent
Description The domain to which the registration invitation email for content membership was sent to
Field type dimension
Data type string.text.value
email_confirmed
Field label Email confirmed
Description The confirmation from the contact
Field type dimension
Data type bool
membership_notes
Field label Membership notes
Description The notes relating to the contact's content membership
Field type dimension
Data type string.text.value
registered_at_datetime
Field label Registered at datetime
Description The datetime at which the contact set up his content membership
Field type dimension
Data type string.time.datetime
registered_at_date
Field label Registered at date
Description The date at which the contact set up his content membership
Field type dimension
Data type string.time.date
status
Field label Status
Description The status of the contact's content membership
Field type dimension
Data type string.text.value
registration_email_was_sent_datetime
Field label Registration email was sent datetime
Description The datetime when the registration email was sent to the contact
Field type dimension
Data type string.time.datetime
registration_email_was_sent_date
Field label Registration email was sent date
Description The date when the registration email was sent to the contact
Field type dimension
Data type string.time.date

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json
system_metadata.query_excluded_accounts
Field label Excluded invalid accounts
Description A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting
Field type dimension
Data type string.text.json

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Field type dimension
Data type string.time.year
year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
atom
Field label Datetime
Field type dimension
Data type string.time.datetime

WEB ANALYTICS HISTORY

first_page_seen
Field label First page seen
Description The first page the contact saw on your website. This is automatically set by HubSpot for each contact
Field type dimension
Data type string.text.url
first_referring_site
Field label First referring site
Description The first website that referred the contact to your website. This is automatically set by HubSpot for each contact
Field type dimension
Data type string.text.url
first_touch_converting_campaign
Field label First touch converting campaign
Description The first campaign the visitor interacted with before being created as a contact. When using this property in other HubSpot tools (e.g., filters, segments), use the campaign id rather than name
Field type dimension
Data type string.text.value
last_page_seen
Field label Last page seen
Description The last page the contact saw on your website. This is automatically set by HubSpot for each contact
Field type dimension
Data type string.text.url
last_referring_site
Field label Last referring site
Description The last website that referred the contact to your website. This is automatically set by HubSpot for each contact. This analytics property looks at the last page viewed, so this site can be internal or external
Field type dimension
Data type string.text.url
last_touch_converting_campaign
Field label Last touch converting campaign
Description The most recent campaign the visitor interacted with before being created as a contact. When using this property in other HubSpot tools (e.g., filters, segments), use the campaign id rather than name
Field type dimension
Data type string.text.value
latest_traffic_source
Field label Latest traffic source
Description The source of the most recent interaction a contact had with your business. This is automatically set by HubSpot. The property options are not editable, but an individual's latest traffic source value can be manually changed to any of the options
Field type dimension
Data type string.text.value
latest_traffic_source_datetime
Field label Latest traffic source datetime
Description The datetime of the most recent interaction a contact had with your business. This is automatically set by HubSpot based on the latest traffic source property, but can also be manually edited
Field type dimension
Data type string.time.datetime
latest_traffic_source_date
Field label Latest traffic source date
Description The date of the most recent interaction a contact had with your business. This is automatically set by HubSpot based on the latest traffic source property, but can also be manually edited
Field type dimension
Data type string.time.date
latest_traffic_source_drill_down_1
Field label Latest traffic source drill-down 1
Description Additional information about the most recent source for the last interaction the contact had with your business. This is automatically set by HubSpot and can't be manually changed for the contact
Field type dimension
Data type string.text.value
latest_traffic_source_drill_down_2
Field label Latest traffic source drill-down 2
Description Additional information about the most recent source for the last interaction the contact had with your business. This is automatically set by HubSpot and can't be manually changed for the contact
Field type dimension
Data type string.text.value
original_traffic_source
Field label Original traffic source (Original source)
Description The first known source through which the contact interacted with your business. This is automatically set by HubSpot. The property options are not editable, but an individual's original source value can be manually changed to any of the options
Field type dimension
Data type string.text.value
original_traffic_source_drill_down_1
Field label Original traffic source drill-down 1 (Original Source Drill-Down 1)
Description Additional information about the traffic source through which the contact first interacted with your business. This is automatically set by hubspot and cannot be manually changed for the contact
Field type dimension
Data type string.text.value
original_traffic_source_drill_down_2
Field label Original traffic source drill-down 2 (Original Source Drill-Down 2)
Description Additional information about the traffic source through which the contact first interacted with your business. This is automatically set by HubSpot and cannot be changed for the contact
Field type dimension
Data type string.text.value
first_seen_datetime
Field label First seen datetime
Description The first date and time the contact has viewed a page on your website. This is automatically set by HubSpot for each contact
Field type dimension
Data type string.time.datetime
first_seen_date
Field label First seen date
Description The first date the contact has viewed a page on your website. This is automatically set by HubSpot for each contact
Field type dimension
Data type string.time.date
last_seen_datetime
Field label Last seen datetime
Description The last date and time the contact has viewed a page on your website. This is automatically set by HubSpot for each contact
Field type dimension
Data type string.time.datetime
last_seen_date
Field label Last seen date
Description The last date the contact has viewed a page on your website. This is automatically set by HubSpot for each contact
Field type dimension
Data type string.time.date
first_session_datetime
Field label First session datetime
Description The first datetime when the contact interacted with your website (website visit, form submission, cta click). This is automatically set by HubSpot for each contact
Field type dimension
Data type string.time.datetime
first_session_date
Field label First session date
Description The first date when the contact interacted with your website (website visit, form submission, cta click). This is automatically set by HubSpot for each contact
Field type dimension
Data type string.time.date
last_session_datetime
Field label Last session datetime
Description The last time and date the contact interacted with your website (website visit, form submission, cta click). This is automatically set by HubSpot for each contact
Field type dimension
Data type string.time.datetime
last_session_date
Field label Last session date
Description The last date the contact interacted with your website (website visit, form submission, cta click). This is automatically set by HubSpot for each contact
Field type dimension
Data type string.time.date
average_page_views
Field label Average page views
Description The average number of pages a contact sees per session. This is automatically set by HubSpot for each contact
Field type metric
Data type float.number.value
event_revenue
Field label Event revenue
Description Event revenue can be set on the contact using HubSpot's events tool
Field type metric
Data type float.currency.value
number_of_event_completions
Field label Number of event completions
Description The sum of all events the contact has experienced. This is automatically set by HubSpot for each contact
Field type metric
Data type int.number.value
number_of_page_views
Field label Number of page views
Description The sum of all pages the contact has seen on your website. This is automatically set by HubSpot for each contact
Field type metric
Data type int.number.value
number_of_sessions
Field label Number of sessions
Description The number of sessions the contact has had on your website. This is automatically set by HubSpot for each contact
Field type metric
Data type int.number.value

© Supermetrics 2025