Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure

Field list for HubSpot

174 metrics and 389 dimensions available

CategoryFieldCodeTypeDescription
TIMEYearyeardim
Year of week (Sun-Sat)yearOfWeekdim
Year of week (Mon-Sun)yearOfWeekIsodim
Year & monthyearMonthdim
Monthmonthdim
Year & week (Sun-Sat)yearWeekdim
Year & week (Mon-Sun)yearWeekIsodim
Week (Sun-Sat)weekdim
Week (Mon-Sun)weekIsodim
Day of monthdayOfMonthdim
Day of week (Sun-Sat)dayOfWeekNamedim
Day of week (Mon-Sun)dayOfWeekNameIsodim
Datedatedim
PORTALPortal IDportal_iddimHubSpot Portal ID. Often called the Hub ID
Portal domainportal_domaindimHubSpot Portal or Hub domain
Portal currencyportal_currencydimHubSpot portal currency
EMAILRecipientrecipientdimThe email address of the recipient of the email message
Subjectemail_subjectdimThe subject line of the email message
Sender emailemail_fromdimThe email in the 'from' field of the email message
Sender nameemail_from_namedimThe name in the 'from' field of the email message
Reply to emailemail_reply_todimThe 'reply-to' field of the email message
Email CCemail_ccdimThe 'cc' field of the email message
Email BCCemail_bccdimThe 'bcc' field of the email message
Click URLemail_click_urldimThe URL within the message that the recipient clicked
Link IDemail_link_iddimEmail URL id that distinguishes between same email URL
Click referer URLemail_click_refererdimThe URL of the webpage that linked to the URL clicked
Recipient IP addressip_addressdimThe IP address where the event originated
Recipient device typedevice_typedimType of the device
EMAIL CAMPAIGNApp IDapp_iddimAn ID referencing the HubSpot Application which sent the email message
App namecampaign_app_namedim
Email campaign IDemail_campaign_iddimAn ID referencing the email campaign which the email message is part of
Link to email campaign in HubSpot UIcampaign_ui_linkdim
Email campaign namecampaign_namedim
Email campaign group IDcampaign_group_iddimAn ID referencing the email campaign group which the email message is part of
Email campaign typecampaign_typedim
Email campaign subtypecampaign_subtypedim
Email campaign subjectcampaign_subjectdim
Email campaign content IDcampaign_content_iddim
EMAIL CLIENTEmail client user agentbrowser_user_agentdimUser agent string of the email client
Email client namebrowser_namedimName of the email client. For example: Firefox 59.0
Email client familybrowser_familydimFamily to which the email client belongs to. For example: Firefox
Email client producerbrowser_producerdimProducer of the email client
Email client producer URLbrowser_producer_urldimWebsite of the email client producer
Email client typebrowser_typedimType of the email client. For example: Browser, Email client, etc
Email client versionbrowser_versiondimVersion of the email client
EMAIL EVENT LOCATIONCountrylocation_countrydimEmail event country
Statelocation_statedimEmail event region
Citylocation_citydimEmail event city
BOUNCEBounce responsebounce_responsedim
Bounce statusbounce_statusdim
DEFERREDDeferred responsedeferred_responsedim
Deferred attemptdeferred_attemptdim
DELIVEREDDelivered responsedelivered_responsedim
Delivered SMTP IDdelivered_smtp_iddim
DROPPEDDrop reasondropped_reasondimThe reason why the email message was dropped
Drop messagedropped_messagedimThe raw message describing why the email message was dropped
STATUS CHANGEStatus change sourcestatus_change_sourcedim
Status change requested bystatus_change_requested_bydim
Status change recipientstatus_change_recipientdim
Portal subscription statusportal_subscription_statusdim
Subscriptionssubscriptionsdim
MARKETING EMAILA/B variationmarketing_email_ab_variationdimA/B variation in marketing email
Marketing email namemarketing_email_namedimName of marketing email
COMPANYCompany IDcompany_iddimID of the company
Company namecompany_namedimThe name of the company
Link to company in HubSpot UIcompany_ui_linkdim
About uscompany_about_usdimA short description of the company
Company descriptioncompany_descriptiondimA short statement about the company`s mission and goals
Company addresscompany_street_address_1dimThe street address of the company
Company address 2company_street_address_2dimAdditional address information for the company
Company postal codecompany_zip_codedimPostal or zip code for the company
Company citycompany_citydimThe city where the company is located
Company state/regioncompany_regiondimThe state or region where the company is located
Company countrycompany_countrydimThe country where the company is located
Company domain namecompany_domain_namedimThe company`s website domain
Company website URLcompany_website_urldimThe company`s web address
Company phone numbercompany_phone_numberdimThe company`s primary phone number
Company industrycompany_industrydimThe type of business the company performs
Is company publiccompany_is_publicdimIndicates that the company is publicly traded
Child companiescompany_child_companiesdimThe number of child companies of this company
Annual revenuecompany_annual_revenuedimThe actual or estimated annual revenue of the company
Employeescompany_employeesdimTotal number of people who work for the company
Company typecompany_typedimThe company`s relationship to you (prospect, partner, reseller, vendor, or other)
Company lead statuscompany_lead_statusdimThe company`s sales, prospecting, or outreach status
Company lifecycle stagecompany_lifecycle_stagedimThe most advanced lifecycle stage (Subscriber, Lead, Marketing Qualified Lead, Sales Qualified Lead, Opportunity, Customer, Evangelist, or Other) of any contact associated with this company
Company ownercompany_ownerdimThe HubSpot user that the company is assigned to
First contact create datecompany_first_contact_create_datedimThe date the first contact for this company was created in your account. This can pre-date the company`s Create date property
First deal create datecompany_first_deal_create_datedimThe date the first deal was created for a contact at this company
Company create datecompany_create_datedimThe date the company was added to your account
Company close datecompany_close_datedimThe date the company became your customer
Company last contactedcompany_last_contacteddimThe timestamp from the most recent chat conversation, call, email, or meeting logged for this company
Company last modified datecompany_last_modifieddimThe last time any property was modified for this company
Company next activity datecompany_next_activitydimThe date of the next upcoming activity for this company
Company last activity datecompany_last_activitydimThe last time a note, call, meeting, or task was logged for a company
Company owner assigned datecompany_owner_assigned_datedimTimestamp for when a company owner was assigned to the company
Parent company IDcompany_parent_company_iddimThe company ID of the company`s parent company
Recent deal datecompany_recent_deal_datedimThe date of the last associated deal closed as won
Company time zonecompany_time_zonedimThe time zone where the company or organization is located
Company money raisedcompany_total_money_raiseddimThe amount of money raised by the company
Year foundedcompany_year_foundeddimThe year the company was created
Facebook company pagecompany_facebook_pagedimThe URL of the company`s Facebook page
Facebook fanscompany_facebook_fansdimThe number of Facebook fans the company has
LinkedIn biocompany_linkedin_biodimThe company`s LinkedIn bio
LinkedIn company pagecompany_linkedin_pagedimThe URL of the company`s LinkedIn page
Twitter biocompany_twitter_biodimThe company`s Twitter bio
Twitter followerscompany_twitter_followersdimThe number of Twitter followers the company has
Twitter handlecompany_twitter_handledimThe company`s Twitter handle
Company days to closecompany_days_to_closedimThe number of days between the day the company was added to your account and the day they became a customer
Company first seen datecompany_first_seen_datedimThe first activity of any contact associated with this company
Company last seen datecompany_last_seen_datedimThe most recent activity of any contact associated with this company
Company first visit datecompany_first_visit_datedimThe time of the first visit by a contact associated with this company
Company last visit datecompany_last_visit_datedimThe time of the most recent session of a contact associated with this company
Company first conversioncompany_first_conversiondimThe first form submitted by any contact associated with the company
Company first conversion datecompany_first_conversion_datedimThe date of the first conversion by any contact associated with the company
Company recent conversioncompany_recent_conversiondimThe last form submitted by a contact associated with the company
Company recent conversion datecompany_recent_conversion_datedimThe date of the most recent conversion by a contact associated with the company
DEAL OWNERDeal owner IDowner_iddimID of deal owner
Deal owner typeowner_typedimType of deal owner
Deal owner nameowner_namedimFull name of deal owner
CONTACT OWNERContact owner IDcontact_owner_iddimID of contact owner
Contact owner typecontact_owner_typedimType of contact owner
Contact owner namecontact_owner_namedimFull name of contact owner
COMPANY OWNERCompany owner IDcompany_owner_iddimID of company owner
Company owner typecompany_owner_typedimType of company owner
Company owner namecompany_owner_namedimFull name of company owner
CONTACTContact VIDcontact_viddimThe unique visitor ID of the contact
Contact canonical VIDcontact_canonical_viddim
Link to contact in HubSpot UIcontact_profile_urldim
CONTACT INFORMATIONFirst namecontact_first_namedimThe contact`s first name
Last namecontact_last_namedimThe contact`s last name
Job titlecontact_job_titledimThe contact`s job title
Contact company namecontact_companydimThe contact's company name
Contact lifecycle stagecontact_lifecycle_stagedimA property used to indicate at what point the contact is within the marketing/sales process
Contact street addresscontact_addressdimThe contact`s street address, including apartment or unit #
Contact postal codecontact_zip_codedimThe contact`s postal (zip) code
Contact citycontact_citydimA contact`s city of residence
Contact state/regioncontact_regiondimThe contact`s state of residence
Contact countrycontact_countrydimThe contact`s country of residence
Emailcontact_emaildimThe contact`s primary email address
Faxcontact_faxdimThe contact`s primary fax number
Messagecontact_messagedimA default property to be used for any message or comments a contact may want to leave on a form
Contact phone numbercontact_phonedimThe contact`s primary phone number
Contact mobile phone numbercontact_mobile_phonedimThe contact`s mobile phone number
Contact create datecontact_create_datedimThe date that a contact entered the system
Became a subscriber datecontact_subscriber_datedimThe date that a contact`s lifecycle stage changed to Subscriber
Became a lead datecontact_lead_datedimThe date that a contact`s lifecycle stage changed to Lead
Became a marketing qualified lead datecontact_marketing_lead_datedimThe date that a contact`s lifecycle stage changed to Marketing Qualified Lead
Became a sales qualified lead datecontact_sales_lead_datedimThe date that a contact`s lifecycle stage changed to Sales Qualified Lead
Became an opportunity datecontact_opportunity_datedimThe date that a contact`s lifecycle stage changed to Opportunity
Became a customer datecontact_customer_datedimThe date that a contact`s lifecycle stage changed to Customer
Became an evangelist datecontact_evangelist_datedimThe date that a contact`s lifecycle stage changed to Evangelist
Became an other lifecycle datecontact_other_datedimThe date that a contact`s lifecycle stage changed to Other
Close datecontact_close_datedimThe date that a contact became a Customer
Contact prioritycontact_prioritydimA ranking system of contacts evenly assigned into four tiers. Contacts in tier one are more likely to become customers than contacts in tier four. Marketing Hub Enterprise, Sales Hub Enterprise, and Service Hub Enterprise only
Likelihood to closecontact_likelihood_to_closedimThe probability that a contact will become a customer within the next 90 days. This score is based on standard contact properties and behavior. Marketing Hub Enterprise, Sales Hub Enterprise, and Sales Hub Enterprise only
Contact days to closecontact_days_to_closedimThe days that elapsed from when a contact was created until they closed as a customer
Contact owner assigned datecontact_owner_assigned_datedimThe most recent date that a contact owner was assigned to a contact
Personacontact_personadimThe contact`s persona
Preferred languagecontact_languagedimThe contact`s preferred language for communications
Salutationcontact_salutationdimThe title used to address the contact
EMAIL INFORMATIONCurrently in workflowcontact_currently_in_workflowdimIndicates if the contact is currently enrolled in any workflow
Email address quarantinedcontact_email_quarantineddimIndicates that the current email address has been quarantined for anti-abuse reasons and any marketing email sends to it will be blocked
Email confirmation statuscontact_email_confirmation_statusdimThe status of the contact`s eligibility to receive email
First marketing email send datecontact_email_first_send_datedimThe date of the earliest email delivery for any marketing email
First marketing email open datecontact_email_first_open_datedimThe date of the earliest email open for any marketing email
First marketing email click datecontact_email_first_click_datedimThe date of the earliest link click for any marketing email
Last marketing email send datecontact_email_last_send_datedimThe date of the most recent email delivery for any marketing email
Last marketing email open datecontact_email_last_open_datedimThe date of the most recent email open for any marketing email
Last marketing email click datecontact_email_last_click_datedimThe date of the most recent link click for any marketing email
Last marketing email namecontact_email_last_email_namedimThe name of the last marketing email sent
CONTACT CONTENT VIEWSFirst page seencontact_first_urldimThe first page the contact saw on your website
First referring sitecontact_first_referrerdimThe first website that referred the contact to your website
First touch converting campaigncontact_first_touch_converting_campaigndimThe campaign responsible for the first touch creation of this contact
Last page seencontact_last_urldimThe last page the contact saw on your website
Last referring sitecontact_last_referrerdimThe last website that referred the contact to your website. This analytics property looks at the last page viewed, so this site can be internal or external
Last touch converting campaigncontact_last_touch_converting_campaigndimThe campaign responsible for the last touch creation of this contact
Contact first seen datecontact_first_seendimThe time and date when the contact first interacted with your business (website visit, form submission, manual contact creation or import)
Contact last seen datecontact_last_seendimThe last time and date the contact has viewed a page on your website
Contact first visit datecontact_first_visitdimThe first time a contact visited your website
Contact last visit datecontact_last_visitdimThe last time and date the contact visited your website
CONVERSION INFORMATIONContact first conversioncontact_first_conversiondimThe first landing page and form the contact submitted on
Contact first conversion datecontact_first_conversion_datedimThe date the contact first submitted a form
Contact recent conversioncontact_recent_conversiondimThe last landing page and form the contact submitted
Contact recent conversion datecontact_recent_conversion_datedimThe date the contact last submitted a form
IP citycontact_ip_citydimThe city reported by the contact`s IP address when they fill out a form
IP state/regioncontact_ip_regiondimThe state or region reported by a contact`s IP address
IP state/region codecontact_ip_region_codedimThe state code or region code reported by a contact`s IP address
IP countrycontact_ip_countrydimThe country reported by the contact`s IP address when they fill out a form
IP country codecontact_ip_country_codedimThe country code reported by a contact`s IP address
IP time zonecontact_ip_time_zonedimThe timezone reported by a contact`s IP address
SALESContact lead statuscontact_lead_statusdimThe contact`s sales, prospecting or outreach status
First deal created datecontact_first_deal_created_datedimThe date of the first deal a contact became associated with
Recent deal close datecontact_recent_deal_close_datedimThe date of the last associated deal that was closed as won
Contact next activity datecontact_next_activity_datedimThe date of the next upcoming activity for a contact. This includes logging a future call, sales email, or meeting using the Log feature, as well as creating a future task or scheduling a future meeting
Contact last contactedcontact_last_contacteddimThe last time a call, sales email, or meeting was done with a contact
Recent sales email clicked datecontact_sales_email_last_clickeddimThe date of the last time that a contact clicked on a sales email. Sales Hub Professional and Enterprise only
Recent sales email opened datecontact_sales_email_last_openeddimThe date of the last time that a contact opened a sales email
Recent sales email replied datecontact_sales_email_last_replieddimThe date of the last time that a contact replied to a sales email sent from your connected G Suite or Outlook 365 email account
Currently in sequencecontact_currently_in_sequencedimIndicates whether or not a contact has been enrolled in a sequence. Sales Hub Starter, Professional, and Enterprise only
Last meeting bookedcontact_last_meeting_bookeddimThe date of the last meeting booked with the contact through a meetings link
Last meeting booked campaigncontact_last_meeting_booked_campaigndimThe campaign of the last meeting booked through the meetings tool (e.g., the specific email that was sent)
Last meeting booked mediumcontact_last_meeting_booked_mediumdimThe medium of the last meeting booked through the meetings tool (e.g., email, website). This property will be populated only if you have UTM tracking parameters added to your meetings link
Last meeting booked sourcecontact_last_meeting_booked_sourcedimThe source of the last meeting booked through the meetings tool (e.g., pql-email, landing-page). This property will be populated only if you have UTM tracking parameters added to your meetings link
LEAD ADSLead date of birthcontact_date_of_birthdimThe date of birth as provided through a lead ad form
Lead gendercontact_genderdimThe gender as provided through a lead ad form
Lead marital statuscontact_marital_statusdimThe marital status as provided through a lead ad form
Lead relationship statuscontact_relationship_statusdimThe relationship status as provided through a lead ad form
Lead military statuscontact_military_statusdimThe military status as provided through a lead ad form
Lead work emailcontact_work_emaildimThe work email as provided through a lead ad form
Lead job functioncontact_job_functiondimThe job function as provided through a lead ad form
Lead senioritycontact_senioritydimThe seniority in the company as provided through a lead ad form
Lead company sizecontact_company_sizedimThe size of the company as provided through a lead ad form
Lead degreecontact_degreedimThe degree as provided through a lead ad form
Lead field of studycontact_field_of_studydimThe field of study as provided through a lead ad form
Lead schoolcontact_schooldimThe school as provided through a lead ad form
Lead education start datecontact_education_start_datedimThe start date of education as provided through a lead ad form
Lead graduation datecontact_graduation_datedimThe graduation date of education as provided through a lead ad form
AUDIENCE ACCESSDomain to which registration email was sentcontact_membership_registration_domain_sent_todimThe domain to which the registration invitation email for content membership was sent to. Marketing Hub Enterprise only
Email confirmedcontact_email_confirmeddimThe confirmation from the contact. Marketing Hub Enterprise only
Membership notescontact_membership_notesdimThe notes relating to the contact`s content membership
Registered atcontact_registered_atdimThe datetime at which the contact set up his content membership
Membership statuscontact_membership_statusdimThe status of the contact`s content membership
Time registration email was sentcontact_membership_email_sent_atdimThe datetime when the registration email was sent to the contact
CONTACT LISTList IDcontact_list_iddimThe unique ID of the list
List namecontact_list_namedimThe name of the list
List typecontact_list_typedimOne of DYNAMIC or STATIC
List processing statuscontact_list_processing_statusdimOne of DONE, REFRESHING, INITIALIZING, or PROCESSING
List processing errorcontact_list_error_messagedimAny errors that happened the last time the list was processed
Processing last status change timecontact_list_last_processing_status_change_timedimThe last time that the processing state changed
List created timecontact_list_created_timedimThe time the list was created
List updated timecontact_list_updated_timedimThe time that the list was last modified
List last size change timecontact_list_last_size_change_timedimLast size change time
List is archivedcontact_list_is_archiveddimIndicated whether the list is archived
List is deletablecontact_list_is_deleteabledimIf this is false, this is a system list and cannot be deleted
Contact added to list datecontact_list_membership_timestampdimDate when the contact was added to the contacts
FORMForm GUIDform_guiddimThe internal ID of the form
Form nameform_namedimThe name of the form
CSS classform_css_classdimThe default css classes added to the form when embedded
Redirect URLform_redirect_urldimThe URL that the visitor is redirected to after filling out the form
Submit textform_submit_textdimThe text used for the submit button
Inline messageform_inline_messagedimA thank you message that is displayed on the page after the form is submitted
Notify recipientsform_notify_recipientsdimA comma-separated list of email addresses that should receive submission notifications
Form created dateform_created_atdimDate when the form was created
Form last modified dateform_updated_atdimDate when the form was last modified
Ignore current valuesform_ignore_current_valuesdimIf true, the form pre-populates fields with known values for know contacts
Is captcha enabledform_captcha_enableddimWill be set to true for forms with captcha enabled
Is cloneableform_is_cloneabledimWhether or not the form can be cloned
Is editableform_is_editabledimWhether or not the form can be edited
Is deletableform_is_deletabledimIf false, the form is a system form (such as a blog comment or subscription form) and cannot be deleted
Submitted onsubmission_datedimDate of the submission
DEALDeal IDdeal_iddimID of the deal
Deal namedeal_namedimName of the deal
Link to deal in HubSpot UIdeal_ui_linkdim
Deal descriptiondeal_descriptiondim
Deal Currencydeal_currencydimThe currency in which the deal was made
Deal owner assigned datedeal_owner_assigned_datedimThe date the most recent deal owner was assigned to a deal
Deal owner's team IDdeal_hubspot_teamdimID of the Primary team assigned to the deal owner for the deal
Deal owner's team nameowner_team_namedimName of the Primary team assigned to the deal owner for the deal
Deal stagedeal_stagedimDeal stages allow you to categorize and track the progress of the deals that you are working on
Deal probabilitydeal_stage_probabilitydimThe probability a deal will close. This defaults to the deal stage probability setting
Deal is deleteddeal_is_deleteddim
Deal typedeal_typedimBy default, categorize your deal as either a New Business or Existing Business
Deal pipelinedeal_pipelinedimThe pipeline a deal is in, which determines the deal stages the deal will move through
Deal created datedeal_createddimThe date the deal was created. This property is set automatically by HubSpot
Deal last modified datedeal_last_modifieddimThe most recent date that any property on a deal was updated
Deal last activity datedeal_last_activity_datedimThe last time a note, call, email, meeting, or task was logged for a deal
Deal last contacteddeal_last_contacteddimThe last time a chat conversation, call, sales email, or meeting was logged for this deal
Deal next activity datedeal_next_activity_datedimThe date of the next upcoming activity for a deal
Deal closed datedeal_closeddimThe day the deal is expected to close, or was closed
Deal lost reasondeal_closed_lost_reasondimReason why the deal was lost
Deal won reasondeal_closed_won_reasondimReason why the deal was won
Original sourceoriginal_sourcedimThe original source for the contact, company or deal (Organic search, Paid search, Email marketing, Social media, Referrals, Other campaigns, Direct traffic, or Offline sources)
Original source Drill-Down 1original_source_data_1dimAdditional information about the original source for the associated contact, or associated company if there is no contact, with the oldest value for the Time first seen property
Original source Drill-Down 2original_source_data_2dimAdditional information about the original source for the associated contact, or associated company if there is no contact, with the oldest value for the Time first seen property
Recurring revenue deal typedeal_recurring_revenue_deal_typedimType of recurring revenue deal
Recurring revenue inactive datedeal_recurring_revenue_inactive_datedimDate of recurring revenue deal becoming inactive
Recurring revenue inactive reasondeal_recurring_revenue_inactive_reasondimReason of recurring revenue deal becoming inactive
LINE ITEMSLine item IDline_item_iddimID of the line item
Line item created dateline_item_created_datedimThe time when line item was created
Line item updated dateline_item_updated_datedimThe time when line item was last modified
Line item product IDline_item_product_iddimID of the product this was copied from
Line item nameline_item_namedimLine item name
Line item SKUline_item_skudimUnique product identifier
Line item descriptionline_item_descriptiondimFull description of the line item
Line item imagesline_item_imagesdimImages of products used in the line item
Line item product URLline_item_urldimProduct URL used in the line item
Line item currencyline_item_currencydimCurrency code for the line item
Line item billing start dateline_item_recurring_billing_start_datedimRecurring billing start date for the line item
Line item billing end dateline_item_recurring_billing_end_datedimRecurring billing end date for the line item
Line item billing termline_item_recurring_billing_termdimProduct recurring billing duration
Line item billing frequencyline_item_recurring_billing_frequencydimHow frequently the line item is billed
PRODUCTProduct IDproduct_iddimID of the product
Product create dateproduct_created_datedimDate when the product was created
Product descriptionproduct_descriptiondimDescription of the product
Product last modified dateproduct_last_modified_datedimDate when the product was last modified
Product nameproduct_namedimName of the product
Product recurring billing frequencyproduct_recurring_billing_frequencydimRecurring billing frequency of the product
Product recurring billing periodproduct_recurring_billing_perioddimRecurring billing period of the product
Product recurring billing start dateproduct_recurring_billing_start_datedimRecurring billing start date of the product
Product SKUproduct_skudimSKU of the product
ANALYTICSPage typeanalytics_page_typedimPage type, i.e. blog-posts
Page IDanalytics_page_iddimID of the page
Pageanalytics_pagedimPage name - blog post, landing page, etc
Page URLanalytics_page_urldimPage URL
Sourceanalytics_sourcedimSource through which people originally found your site
Source Drill-Down 1analytics_source_drill_down_1dimFirst Drill-Down when reporting by source
Source Drill-Down 2analytics_source_drill_down_2dimSecond Drill-Down when reporting by source
BLOGBlog IDblog_iddimID of the blog
Blog nameblog_namedimName of the blog
Blog URLblog_root_urldimRoot URL of the blog
Blog descriptionblog_descriptiondimDescription of the blog
Blog post authorblog_post_author_namedimDisplay name of the blog post author
ENGAGEMENTEngagement IDengagement_iddimThe unique ID for the engagement
Engagement is activeengagement_is_activedimOnly active engagements will appear in the timeline
Engagement create dateengagement_created_datedimDate when the engagement was created
Engagement last updated dateengagement_last_updated_datedimDate when the engagement was last updated
Engagement timeline dateengagement_timestampdimDate when the engagement should appear in the timeline
ENGAGEMENT (NOTE)Engagement note bodyengagement_note_bodydimThe body of the note
ENGAGEMENT (EMAIL)Engagement email senderengagement_email_sender_namedimThe name of the sender
Engagement email sender emailengagement_email_sender_emaildimThe email address of the sender
Engagement email recipientengagement_email_recipient_namedimThe name of the recipient
Engagement email recipient emailengagement_email_recipient_emaildimThe email address of the recipient
Engagement email subjectengagement_email_subjectdimThe subject of the email
Engagement email HTML bodyengagement_email_htmldimThe body of the HTML email
Engagement email text bodyengagement_email_textdimThe body of the text-only email
ENGAGEMENT (TASK)Engagement task titleengagement_task_subjectdimThe subject or title of the task
Engagement task detailsengagement_task_bodydimThe body or details of the task
Engagement task statusengagement_task_statusdimThe status of the task
Engagement task object typeengagement_task_object_typedimOne of CONTACT or COMPANY, what object type the task is for
ENGAGEMENT (MEETING)Engagement meeting titleengagement_meeting_titledimThe title or subject of the meeting
Engagement meeting detailsengagement_meeting_bodydimThe details or body of the meeting
Engagement meeting start timeengagement_meeting_start_timedimThe start time of the meeting
Engagement meeting end timeengagement_meeting_end_timedimThe end time of the meeting
ENGAGEMENT (CALL)Engagement call to numberengagement_call_to_numberdimThe phone number that was called
Engagement call from numberengagement_call_from_numberdimThe phone number from which the call was made
Engagement call statusengagement_call_statusdimWill be COMPLETED once the call is finished
Engagement call external IDengagement_call_external_iddimFor calls made in HubSpot, this will be the internal ID of the call
Engagement call external account IDengagement_call_external_account_iddimFor calls made in HubSpot, this will be the internal ID of the account used to make the call
Engagement call detailsengagement_call_bodydimThe details or notes of the call
Engagement call recording URLengagement_call_recording_urldimThe URL of the recording file
Engagement call outcomeengagement_call_dispositiondimThe outcome of the call
SOCIAL PUBLISHING CHANNELSChannel IDspc_channel_iddim
Channel GUIDspc_channel_guiddim
Account GUIDspc_account_guiddim
Channel keyspc_channel_keydim
Account typespc_account_typedimType of account. For example Facebook for Instagram
Channel typespc_channel_typedimType of the channel. For example Instagram
Display namespc_display_namedimDisplay name of the channel
Usernamespc_usernamedimUsername for the connected account
Profile URLspc_profile_urldimLink to the channel
Avatar URLspc_avatar_urldimLink to the avatar image related to the channel
Createdspc_createddimWhen the channel was added to HubSpot
Updatedspc_updateddimWhen the channel was updated
Activespc_activedimIs the channel active
Sharedspc_shareddimIs the channel shared
TICKETTicket IDticket_iddimThe unique ID for this ticket
Ticket nameticket_namedimShort summary of ticket
Ticket descriptionticket_descriptiondimDescription of the ticket
Ticket ownerticket_ownerdimThe owner of the ticket
Ticket statusticket_statusdimThe pipeline stage that contains this ticket
Ticket categoryticket_categorydimMain reason customer reached out for help
Ticket close dateticket_closed_datedimThe date the ticket was closed
Ticket create dateticket_create_datedimThe date the ticket was created
Ticket owner's team IDticket_hubspot_teamdimID of the Primary team of the ticket owner for the ticket
Ticket owner's team nameticket_owner_team_namedimName of the Primary team assigned to the ticket owner for the ticket
Ticket last activity dateticket_last_activity_datedimThe last time a note, call, email, meeting, or task was logged for a ticket
Ticket last contacted dateticket_last_contacted_datedimThe last time a call, conversation, email, or meeting was logged for this ticket
Ticket last customer reply dateticket_last_customer_reply_datedimThe date of the last customer response
Ticket last modified dateticket_last_modified_datedimThe last time any property on the ticket was modified
Ticket next activity dateticket_next_activity_datedimThe date of the next upcoming activity for a ticket
Ticket owner assigned dateticket_owner_assigned_datedimThe date an owner was assigned to the ticket
Ticket pipelineticket_pipelinedimThe pipeline that contains this ticket
Ticket priorityticket_prioritydimThe level of attention needed on the ticket
Ticket sourceticket_sourcedimChannel where ticket was originally submitted
Ticket first email response dateticket_first_agent_reply_datedimThe date of the first email response from an agent after a ticket was created
WORKFLOWWorkflow IDworkflow_iddimThe ID of the workflow
Workflow nameworkflow_namedimName of the workflow
Workflow descriptionworkflow_descriptiondimDescription of the workflow
Workflow typeworkflow_typedimThe type of the workflow
Is workflow enabledworkflow_enableddimWhether the workflow is enabled or not
Is workflow listeningworkflow_listeningdimWhether the workflow is listening or not
Is workflow segment basedworkflow_is_segment_baseddimWhether the workflow is segment based or not
Workflow create dateworkflow_inserted_atdimDate when the workflow was created
Workflow last update dateworkflow_updated_atdimDate when the workflow was last updated
Allow contact to trigger multiple timesworkflow_allow_multi_triggerdimWhether the workflow allows a contact to trigger multiple times or not
Allow enrollment from mergeworkflow_enroll_from_mergedimWhether the workflow allows enrollment from merge or not
Workflow starting list is done processingworkflow_start_list_donedimWhether the workflow starting list is done processing or not
DEPRECATEDOnly enrolls manuallyworkflow_only_enrolls_manuallydimWhether the workflow enrolls only manually or not. Please note that this field will be removed on 2023-08-09
Only executed on business daysworkflow_only_biz_daysdimWhether the workflow is only executed on business days or not. Please note that this field will be removed on 2023-08-09
CONTACTContactscontact_total_countmetNumber of contacts
Leadscontact_lead_countmetNumber of new leads in the time period
Marketing qualified leadscontact_marketing_qualified_lead_countmetNumber of new marketing qualified in the time period
Sales qualified leadscontact_sales_qualified_lead_countmetNumber of new sales qualified leads in the time period
Customerscontact_customer_countmetNumber of new customers in the time period
Subscriberscontact_subscriber_countmetNumber of new subscribers in the time period
Opportunitiescontact_opportunity_countmetNumber of new opportunities in the time period
Evangelistscontact_evangelist_countmetNumber of new evangelists in the time period
Contact hubspot scorecontact_hubspotscoremetThe number that shows qualification of contacts to sales readiness
COMPANYCompaniescompany_total_countmetNumber of companies
Company page viewscompany_page_viewsmetThe total number of page views for all contacts associated with this company
Number of sessionscompany_sessionsmetThe total number of sessions for all contacts associated with this company
Number of form submissionscompany_form_submissionsmetThe total number of forms submitted by all contacts associated with the company
SALESTimes contactedtimes_contactedmetThe total number of times contacted via a sales email or phone
Sales activitiessales_activitiesmetThe total number of sales activities (notes, calls, emails, meetings, or tasks)
Amountdeal_amountmetThe total value of the sales
Amount wondeal_amount_closed_wonmetThe total value of the won deals
Amount lostdeal_amount_closed_lostmetThe total value of the lost deals
Dealsdeal_total_countmetNumber of deals
Average deal sizeaverage_deal_sizemetAverage value of a deal
"Appointment scheduled" dealsdeal_appointment_countmetThe total count of deals in "Appointment Scheduled" stage
"Qualified to buy" dealsdeal_qualified_to_buy_countmetThe total count of deals in "Qualified To Buy" stage
"Presentation scheduled" dealsdeal_presentation_countmetThe total count of deals in "Presentation Scheduled" stage
"Decision maker bought-in" dealsdeal_decision_maker_in_countmetThe total count of deals with "Decision Maker Bought-In" stage
"Contact sent" dealsdeal_contact_sent_countmetThe total count of deals in "Contact Sent" stage
Closed dealsdeal_closed_countmetThe total count of closed deals
Closed won dealsdeal_closed_wonmetThe total count of won deals
Closed lost dealsdeal_closed_lostmetThe total count of lost deals
Win rate (%)deal_hit_ratemetThe deal win rate
Average days to close on won dealsdeal_avg_time_to_close_closed_wonmet
Recurring revenue amountdeal_recurring_revenue_amountmetDeal recurring revenue amount
FORMForm submissionsform_submissionsmetNumber of form submissions
EMAILSentemail_sentmetNumber of emails sent
Not sentemail_droppedmetNumber of emails dropped
Not sent (%)email_dropped_ratemetDropped rate based on sent
Processedemail_processedmetNumber of emails processed
Processed (%)email_processed_ratemetProcessed rate based on sent
Successful deliveriesemail_deliveredmetNumber of successful email deliveries
Successful deliveries (%)email_delivered_ratemetSuccessful delivery rate based on sent
Deferredemail_deferredmetNumber of emails deferred
Deferred (%)email_deferred_ratemetDeferred rate based on sent
Opensemail_openedmetNumber of emails opened by recipients
Unique opensemail_opened_uniquemet
Opens (%)email_opened_ratemetOpen rate based on successful deliveries
Opens CTR (%)email_ctrmetClick-through rate based on opens
Clicksemail_clickedmetNumber of clicks by recipients
Unique clicksemail_clicked_uniquemetNumber of unique clicks by recipients
Clicks (%)email_clicked_ratemetClick rate based on successful deliveries
Printsemail_printedmetNumber of prints by recipients
Prints (%)email_printed_ratemetPrint rate based on opens
Forwardedemail_forwardedmetNumber of forwards by recipients
Forwarded (%)email_forwarded_ratemetForward rate based on opens
Marked as spamemail_spam_reportmetNumber of recipients that marked the email as spam
Marked as spam (%)email_spam_report_ratemetRate of marked as spam based on successful deliveries
Avg. open durationemail_opened_durationmetThe average approximate number of seconds recipients had opened the email for
Glancedemail_opened_glancedmetNumber of unique recipients that glanced over the email
Glanced (%)email_opened_glanced_ratemetGlanced rate based on opened
Skim reademail_opened_skim_readmetNumber of unique recipients that skim read the email
Skim read (%)email_opened_skim_read_ratemetSkim open rate based on opened
Reademail_opened_readmetNumber of unique recipients that read the email
Read (%)email_opened_read_ratemetRead rate based on opened
Total bouncesemail_bounce_totalmet
Bounce rate (%)email_bounce_ratemet
Hard bouncesemail_bounce_hardmetNumber of hard bounces
Hard bounces (%)email_bounce_hard_ratemetHard bounce rate based on sent
Soft bouncesemail_bounce_softmetNumber of soft bounces
Soft bounces (%)email_bounce_soft_ratemetSoft bounce rate based on sent
Pending bouncesemail_bounce_pendingmetNumber of pending bounces
Pending bounces (%)email_bounce_pending_ratemetPending bounce rate based on sent
UnsubscribesunsubscribesmetThe amount of people who have unsubscribed from the email campaign
Unsubscribe rate (%)unsubscribe_ratemetThe unsubscribe rate based on emails sent
TICKETTicketsticket_total_countmetNumber of tickets
Ticket time to close (average in minutes)ticket_time_to_closemetOn average the time between when the ticket was created and closed
Ticket time to first reply (average in minutes)ticket_time_to_first_agent_replymetOn average the time from the ticket creation date to the first agent email reply
Ticket number of times contacted (average)ticket_number_of_times_contactedmetThe average number of times a call, email, or meeting was logged on the ticket
ANALYTICSSessionsanalytics_sessionsmetThe number of times a user visited your website during this period
Traffic sessionstraffic_analytics_sessionsmetThe number of times a user visited your website during this period
Traffic new visitor sessionsanalytics_new_visitor_sessionsmetThe number of sessions from visitors who have never been to your website before
Bouncesanalytics_bouncesmetThe number of sessions that started on a page and did not move beyond that page
Traffic bouncestraffic_analytics_bouncesmetThe number of sessions that started on a page and did not move beyond that page
Bounce rate (%)analytics_bounce_ratemetThe percentage of sessions that started on a page and did not move beyond that page
Traffic bounce rate (%)traffic_analytics_bounce_ratemetThe percentage of sessions that started on a page and did not move beyond that page
Avg. session length (seconds)analytics_session_avg_timemetThe average time between the start and end of a session in seconds
Avg. traffic session length (seconds)traffic_analytics_session_avg_timemetThe average time between the start and end of a session in seconds
Session to contact rateanalytics_session_contact_ratemetThe number of new contacts divided by the number of sessions
Traffic session to contact ratetraffic_analytics_session_contact_ratemetThe number of new contacts divided by the number of sessions
Traffic contact to customer rateanalytics_contact_customer_ratemetThe number of customers divided by contacts
New session (%)analytics_new_session_ratemetThe percentage of total sessions from new visitors
New traffic sessions (%)traffic_analytics_new_session_ratemetThe percentage of total sessions from new visitors
Page viewsanalytics_page_viewsmetThe total number of page views
Traffic page viewstraffic_analytics_page_viewsmetThe total number of page views
Avg. time on page (seconds)analytics_page_view_avg_timemetThe average amount of time a visitor stays on this page
Avg. page views per sessionanalytics_page_views_per_sessionmetAverage unique page views per session
Avg. traffic page views per sessiontraffic_analytics_page_views_per_sessionmetAverage unique page views per session
Entrancesanalytics_entrancesmetThe number of sessions that started with viewing this page first
Exitsanalytics_exitsmetThe number of sessions that ended with viewing this page last
Exit rate (%)analytics_exit_ratemetThe percentage of sessions that ended with viewing this page last
Submissionsanalytics_submissionsmetThe number of submissions
CTA viewsanalytics_cta_viewsmetThe number of times a call-to-action (CTA) button has been viewed on a website page
CTA clicksanalytics_cta_clicksmetThe number of times a call-to-action (CTA) button has been clicked on a website page
CTA rate (%)analytics_cta_ratemetThe percentage of visitors who view a call-to-action (CTA) button and then click on the same CTA
Conversion rate (%)analytics_conversion_ratemetSubmissions divided by entrances
Instant blog subscribersblog_instant_subscriber_countmetBlog subscribers with subscription type instant
Daily blog subscribersblog_daily_subscriber_countmetBlog subscribers with subscription type daily
Weekly blog subscribersblog_weekly_subscriber_countmetBlog subscribers with subscription type weekly
Monthly blog subscribersblog_monthly_subscriber_countmetBlog subscribers with subscription type monthly
CONTACT CONTENT VIEWSEvent completionscontact_event_completionsmetThe sum of all events the contact has experienced
Event revenuecontact_event_revenuemetEvent revenue can be set on a contact using HubSpot`s events tool (Marketing Hub Enterprise only)
Contact page viewscontact_page_viewsmetThe sum of all pages the contact has seen on your website
Average page viewscontact_avg_page_viewsmetThe average number of pages the contact sees
EMAIL INFORMATIONSends since last engagementcontact_sends_since_last_engagedmetThe number of marketing emails that have been sent since the last engagement (open or link click)
FUNNELBecame a subscriber avg. contact time (days)contact_new_to_subscriber_avgmetAverage number of days it took for a new contact to become a subscriber
Became a lead avg. lead time (days)contact_became_lead_avgmetAverage number of days it took for a new contact to become a lead
Became a MQL avg. contact time (days)contact_new_to_mql_avgmetAverage number of days it took for a new contact to become a marketing qualified lead
Became a SQL avg. contact time (days)contact_new_to_sql_avgmetAverage number of days it took for a new contact to become a sales qualified lead
Became an opportunity avg. contact time (days)contact_new_to_opportunity_avgmetAverage number of days it took for a new contact to become an opportunity
Became a customer avg. contact time (days)contact_new_to_customer_avgmetAverage number of days it took for a new contact to become a customer
Became an evangelist avg. contact time (days)contact_new_to_evangelist_avgmetAverage number of days it took for a new contact to become an evangelist
Became a lead avg. subscriber time (days)contact_subscriber_to_lead_avgmetAverage number of days it took for a subscriber to become a lead
Became a MQL avg. subscriber time (days)contact_subscriber_to_mql_avgmetAverage number of days it took for a subscriber to become a marketing qualified lead
Became a SQL avg. subscriber time (days)contact_subscriber_to_sql_avgmetAverage number of days it took for a subscriber to become a sales qualified lead
Became an opportunity avg. subscriber time (days)contact_subscriber_to_opportunity_avgmetAverage number of days it took for a subscriber to become an opportunity
Became a customer avg. subscriber time (days)contact_subscriber_to_customer_avgmetAverage number of days it took for a subscriber to become a customer
Became an evangelist avg. subscriber time (days)contact_subscriber_to_evangelist_avgmetAverage number of days it took for a subscriber to become an evangelist
Became an MQL avg. lead time (days)contact_became_mql_avgmetAverage number of days it took for a lead to become a marketing qualified lead
Became an SQL avg. lead time (days)contact_became_sql_avgmetAverage number of days it took for a lead to become a sales qualified lead
Became an opportunity lead time (days)contact_became_opportunity_avgmetAverage number of days it took for a lead to become an opportunity
Became a customer avg. lead time (days)contact_became_customer_avgmetAverage number of days it took for a lead to become a customer
Became an evangelist avg. lead time (days)contact_lead_to_evangelist_avgmetAverage number of days it took for a lead to become an evangelist
Became a SQL avg. MQL time (days)contact_mql_to_sql_avgmetAverage number of days it took for a marketing qualified lead to become a sales qualified lead
Became an opportunity avg. MQL time (days)contact_mql_to_opportunity_avgmetAverage number of days it took for a marketing qualified lead to become an opportunity
Became a customer avg. MQL time (days)contact_mql_to_customer_avgmetAverage number of days it took for a marketing qualified lead to become a customer
Became an evangelist avg. MQL time (days)contact_mql_to_evangelist_avgmetAverage number of days it took for a marketing qualified lead to become an evangelist
Became an opportunity avg. SQL time (days)contact_sql_to_opportunity_avgmetAverage number of days it took for a sales qualified lead to become an opportunity
Became a customer avg. SQL time (days)contact_sql_to_customer_avgmetAverage number of days it took for a sales qualified lead to become a customer
Became an evangelist avg. SQL time (days)contact_sql_to_evangelist_avgmetAverage number of days it took for a sales qualified lead to become an evangelist
Became a customer avg. opportunity time (days)contact_opportunity_to_customer_avgmetAverage number of days it took for an opportunity to become a customer
Became an evangelist avg. opportunity time (days)contact_opportunity_to_evangelist_avgmetAverage number of days it took for an opportunity to become an evangelist
Became an evangelist avg. customer time (days)contact_customer_to_evangelist_avgmetAverage number of days it took for a customer to become an evangelist
LINE ITEMSLine item quantityline_item_quantitymetHow many units of a product are in the line item
Line item term in monthsline_item_term_in_monthsmetThe number of months in the term of the line item
Line item net priceline_item_net_pricemetThe amount of the line item
Line item unit priceline_item_unit_pricemetCost of product in the line item
Line item unit costline_item_unit_costmetThe amount that sold goods cost the HubSpot customer
Line item unit discountline_item_unit_discountmetThe discount amount applied
Line item discount percentline_item_discount_percentagemetThe discount percentage applied
ACVline_item_acvmetThe annual contract value (ACV) of the line item
MRRline_item_mrrmetThe monthly recurring revenue (MRR) of the line item
ARRline_item_arrmetThe annual recurring revenue (ARR) of the line item
TCVline_item_tcvmetThe total contract value (TCV) of the line item
Line item marginline_item_marginmetThe margin value of the line item
ACV marginline_item_acv_marginmetThe margin annual contract value of the line item
ARR marginline_item_arr_marginmetThe margin annual recurring revenue of the line item
MRR marginline_item_mrr_marginmetThe margin monthly recurring revenue of the line item
TCV marginline_item_tcv_marginmetThe margin total contract value of the line item
Line item taxline_item_taxmetThe tax amount applied
PRODUCTProduct cost of goods soldproduct_cost_of_goods_soldmetThe amount that sold goods cost the HubSpot customer
Product discountproduct_discountmetDiscount of the product
Product discount percentageproduct_discount_percentagemetDiscount percentage of the product
Product priceproduct_pricemetPrice of the product
Product quantityproduct_quantitymetQuantity of the product
Product taxproduct_taxmetTax of the product
ENGAGEMENT (CALL)Engagement call durationengagement_call_durationmetThe length of the call in seconds
WORKFLOWTotal workflow enrolled contactsworkflow_enrolled_countmetThe total number of contacts that enrolled the workflow
Total workflow active contactsworkflow_active_countmetThe total number of active contacts for the workflow
Total workflow completed contactsworkflow_completed_countmetThe total number of contacts that completed the workflow
Total workflow succeeded contactsworkflow_succeeded_countmetThe total number of contacts that reached the workflow goal
Total workflow starting contactsworkflow_starting_countmetThe total number of contacts that started the workflow
Total workflow conversion rate (%)workflow_conversion_ratemetRatio for contacts that reached the workflow goal
WORKFLOW PERFORMANCEContacts enrolledworkflow_performance_enrolledmetThe number of workflow enrollment events
Contacts lostworkflow_performance_unenrolledmetThe number of workflow unenrollment events
Contacts completedworkflow_performance_completedmetThe number of workflow completion events
Contacts met goalsworkflow_performance_met_goalmetThe number of workflow goals met events
Ongoing conversion rate (%)workflow_performance_conversion_ratemetRatio for workflow enrolled to goals met events