Hubspot: Most-used fields

Hubspot: Most-used fields#

The table below gives information about most-used fields that you can import from Hubspot. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name

Adverity UI name

Description

Use in Adverity

ab

ab

Identifies a characteristic related to A/B testing, which allows for testing two variations of content (e.g., emails, landing pages) to determine performance.

dimension

abVariation

abVariation

Indicates if the email is an A/B test variation.

dimension

absoluteUrl

absoluteUrl

The absolute URL of the published content.

dimension

amount

amount

The monetary value associated with a deal.

metric

analyticsPageId

analyticsPageId

The unique identifier for the analytics page associated with the content.

metric

analyticsPageType

analyticsPageType

The type of analytics page associated with the content.

dimension

archivedAt

archivedAt

The timestamp when the record was archived.

metric

associatedcompanyid

associatedcompanyid

This field historically represented the ID of the primary company associated with a contact. It is now a read-only property, with associations managed through HubSpot’s CRM Associations API.

dimension

author

author

The author of the content.

dimension

authorName

authorName

The display name of the author.

dimension

blogEmailType

blogEmailType

The type of blog email, such as instant, daily, or weekly digest.

dimension

blogRssSettings

blogRssSettings

Settings related to RSS feed for blog subscriptions.

dimension

campaign

campaign

The name or ID of a marketing campaign.

dimension

campaignName

campaignName

The name of a marketing campaign.

dimension

campaignUtm

campaignUtm

The UTM campaign parameter value associated with an event or record.

dimension

campaign_name

campaign_name

The name of the marketing campaign an email or other content belongs to.

dimension

canonical-vid

canonical-vid

The canonical (primary) unique identifier for a website visitor, used to link their activities to a specific contact record in HubSpot.

dimension

categoryId

categoryId

The unique identifier for the category of the content.

metric

channel

channel

This field identifies the communication channel through which an interaction occurred, such as email, social media, chat, or a custom messaging service.

dimension

channel_drill_down_{NUM}

channel_drill_down_{NUM}

This field captures a granular detail (drill-down level) about the channel through which an interaction (e.g., contact creation, latest activity) occurred. For example, if the channel is ‘Organic Search’, a drill-down might specify the search engine or a specific keyword.

dimension

clonedFrom

clonedFrom

The ID of the original object from which this record was cloned.

metric

closedate

closedate

The date and time when a deal was closed.

dimension

companies.city

companies.city

The city where the associated company is located.

dimension

companies.closedate

companies.closedate

For companies, this field indicates the date when the company achieved ‘customer’ lifecycle stage, automatically set by HubSpot. For deals, it represents the anticipated or actual date a deal is expected to close or was closed.

metric

companies.country

companies.country

The country where the associated company is located.

dimension

companies.hs_pipeline

companies.hs_pipeline

The unique identifier for the sales or service pipeline to which the company record is currently associated.

dimension

companies.hubspot_team_id

companies.hubspot_team_id

This property identifies the unique ID of the HubSpot team associated with a company record, indicating which team is responsible for or primarily manages the company.

dimension

companies.name

companies.name

The name of the associated company.

dimension

companies.recent_deal_close_date

companies.recent_deal_close_date

This field automatically records the date of the last associated deal that was closed as ‘won’ for a specific company.

metric

company

company

This field refers to the Company object in HubSpot, which stores data about businesses and organizations that interact with your business.

dimension

company.city

company.city

The city where the company is located.

dimension

company.country

company.country

The country where the company is located.

dimension

company.name

company.name

The name of the company.

dimension

company_id

company_id

The unique identifier for a company record.

dimension

contact_id

contact_id

The unique identifier for a contact record.

dimension

content.widgets.hs_email_body.body.html

content.widgets.hs_email_body.body.html

The HTML content of the email body, specifically within a HubSpot email widget.

dimension

contentTypeCategory

contentTypeCategory

The category or type of the content, such as ‘BLOG_POST’, ‘EMAIL’, or ‘LANDING_PAGE’.

metric

createdAt

createdAt

The timestamp when the record was created.

dimension

createdById

createdById

The ID of the user who created the record.

metric

createdate

createdatetime

This field stores the date and time when a record (e.g., deal, contact, company) was initially created in HubSpot. It is automatically set by HubSpot, but can sometimes be set or updated via API.

dimension

currentState

currentState

The current state of the content or object.

dimension

currentlyPublished

currentlyPublished

Indicates if the content is currently published.

dimension

customReplyTo

customReplyTo

The custom ‘reply-to’ email address set for an email campaign or send.

dimension

customReplyToEnabled

customReplyToEnabled

A boolean indicating if a custom ‘reply-to’ email address is enabled for an email.

dimension

date

date

This field represents a specific calendar date, typically without a time component, and is formatted according to ISO 8601 (YYYY-MM-DD) or as a UTC midnight aligned Unix millisecond timestamp.

dimension

dealId

dealId

The unique identifier for a deal record.

metric

dealIds

associated_deal_ids

A list of unique identifiers for associated deal records.

dimension

deal_source

deal_source

This field indicates the original source or channel through which a deal was acquired, providing insight into where the sales opportunity originated.

dimension

dealname

dealname

The name of the deal.

dimension

dealstage

dealstage

The current stage of the deal in the sales pipeline.

dimension

domain

domain

The domain associated with the content or email.

dimension

email

email

The email address associated with a contact or record.

dimension

emailBody

emailBody

The HTML body content of the email.

dimension

emailCampaignGroupId

emailCampaignGroupId

The unique identifier for the email campaign group to which an email belongs.

metric

emailTemplateMode

emailTemplateMode

The mode or type of an email template used for a marketing email.

dimension

emailbodyPlaintext

emailbodyPlaintext

The plain text body content of the email.

dimension

feedbackSurveyId

feedbackSurveyId

The unique identifier for a feedback survey.

dimension

firstname

firstname

The first name of a person associated with a record.

dimension

folderId

folderId

The unique identifier for a folder where assets or files are organized.

metric

form.createdAt

form.createdAt

The timestamp when the form was created.

dimension

form.formType

form.formType

The type of the form, such as ‘hubspot’ for standard forms, ‘captured’ for non-HubSpot forms, or ‘flow’ for pop-up forms.

dimension

form.guid

form.guid

The unique identifier (GUID) for the form.

dimension

form.name

form.name

The name of the form.

dimension

form.portalId

form.portalId

The unique identifier for the HubSpot portal where the form resides.

metric

from.replyTo

from.replyTo

The email address designated for replies to the sender.

dimension

fromName

fromName

The display name of the sender for marketing emails.

dimension

full_name

full_name

This field represents the combined first and last names of an individual, typically derived from separate firstname and lastname properties.

dimension

gender

gender

The gender of the contact.

dimension

hs_additional_emails

hs_additional_emails

This field stores secondary or additional email addresses associated with a contact. It is a read-only property via API v3, with modifications typically requiring legacy v1 endpoints or specific workflows.

dimension

hs_analytics_first_referrer

hs_analytics_first_referrer

This field records the URL of the first website or source that referred a visitor to your site, capturing the initial point of contact for a lead.

dimension

hs_analytics_first_url

hs_analytics_first_url

This field records the URL of the very first page a contact visited on your website, automatically set by HubSpot. It is a read-only property.

dimension

hs_analytics_source

hs_analytics_source

The original source through which a contact or company was acquired (e.g., Organic Search, Social Media, Referral). This is a HubSpot internal analytics property.

dimension

hs_analytics_source_data_{NUM}

hs_analytics_source_data_{NUM}

Detailed data about the source through which a contact or company was acquired, with ‘{NUM}’ representing a specific data point or index. This is a HubSpot internal analytics property.

dimension

hs_closed_amount

hs_closed_amount

The monetary amount of a closed deal.

metric

hs_email_optout

hs_email_optout

A boolean property that indicates whether the contact’s email address has opted out of all email communications.

dimension

hs_is_closed

hs_is_closed

This boolean field indicates whether a deal has reached a closed status, meaning it has either been won or lost. It is a calculated property and typically read-only.

dimension

hs_is_closed_lost

hs_is_closed_lost

This boolean field indicates whether a deal has been moved to a ‘closed lost’ stage in the sales pipeline. It is a calculated and typically read-only property.

dimension

hs_is_closed_won

hs_is_closed_won

This boolean field indicates whether a deal has been successfully moved to a ‘closed won’ stage, signifying a successful transaction. It is a calculated and typically read-only property.

dimension

hs_latest_source

hs_latest_source

This field indicates the most recent source or channel through which a contact or company interacted with your content or website.

dimension

hs_latest_source_data_{NUM}

hs_latest_source_data_{NUM}

This field provides additional granular details or a drill-down level about the latest source of interaction, offering more context beyond the primary hs_latest_source field.

dimension

hs_open_deal_create_date

hs_open_deal_create_date

The creation date of a deal that is currently in an open stage within the sales pipeline.

dimension

htmlTitle

htmlTitle

The HTML title of the content.

dimension

hubspot_owner_id

hubspot_owner_id

The unique identifier of the HubSpot user assigned as the owner of the record.

dimension

hubspot_team_id

hubspot_team_id

This field contains the unique identifier for the HubSpot team assigned to an owner or associated with an object like a deal or contact.

dimension

hubspotscore

hubspotscore

This field represents the HubSpot Score, a calculated property reflecting a contact’s engagement and fit, often used for lead scoring. It is typically a read-only, calculated property.

metric

id

id

The unique identifier for the record.

dimension

industry

industry

The industry in which the company or contact operates.

dimension

isGraymailSuppressionEnabled

isGraymailSuppressionEnabled

A boolean indicating if graymail suppression is enabled for email campaigns to avoid sending to less engaged recipients.

dimension

isPublished

isPublished

Indicates whether the content (e.g., an email) has been published.

dimension

isRecipientFatigueSuppressionEnabled

isRecipientFatigueSuppressionEnabled

A boolean indicating if recipient fatigue suppression is enabled to prevent over-mailing contacts.

dimension

jobtitle

jobtitle

The job title of the contact.

dimension

label

label

The user-friendly name or display label for a property or item.

dimension

language

language

The language preference of a contact or the language of a content asset.

dimension

lastname

lastname

The last name of a person associated with a record.

dimension

list.archived

list.archived

A boolean indicating if the list is archived.

dimension

list.authorId

list.authorId

The unique identifier of the user who created the list.

metric

list.createdAt

list.createdAt

The date and time when the list was created.

dimension

list.deleted

list.deleted

A boolean indicating if the list has been deleted.

dimension

list.dynamic

list.dynamic

A boolean indicating if the list is a dynamic (active) list that updates automatically.

dimension

list.internal

list.internal

A boolean indicating if the list is an internal HubSpot list.

dimension

list.internalListId

list.internalListId

The internal unique identifier for the list.

metric

list.limitExempt

list.limitExempt

Indicates if a specific list is exempt from certain API rate limits or restrictions.

dimension

list.listId

list.listId

The unique identifier for the list.

metric

list.listType

list.listType

The type of list, such as ‘STATIC’ or ‘ACTIVE’.

dimension

list.name

list.name

The name of the list.

dimension

list.portalId

list.portalId

The HubSpot portal ID where the list resides.

metric

list.readOnly

list.readOnly

A boolean indicating if the list is read-only.

dimension

list.teamIds

list.teamIds

A list of team IDs that have access to or are associated with a particular list.

dimension

list.updatedAt

list.updatedAt

The date and time when the list was last updated.

dimension

liveDomain

liveDomain

The live domain where the content is published.

dimension

maxRssEntries

maxRssEntries

The maximum number of RSS entries to display in an email.

metric

name

name

The name of the record or content (e.g., email name, form name).

dimension

ownerIds

associated_owner_ids

A list of unique identifiers for all associated owners of the record.

dimension

page.id

page.id

The unique identifier for a specific page in HubSpot’s CMS.

metric

page.name

page.name

The name or title of a specific page in HubSpot’s CMS.

dimension

pageExpiryDate

pageExpiryDate

The date and time when a HubSpot content page is scheduled to expire.

metric

pageExpiryEnabled

pageExpiryEnabled

Indicates whether an expiry date is enabled for a specific content page in HubSpot.

dimension

pageExpiryRedirectUrl

pageExpiryRedirectUrl

The URL to which visitors are redirected after a HubSpot content page expires.

dimension

pageRedirected

pageRedirected

Indicates if a page or web version is configured to redirect to another URL.

dimension

portalId

portalId

The unique identifier for the HubSpot portal (account).

metric

previewKey

previewKey

A key used to access a preview of content, such as an email or page.

dimension

primaryEmailCampaignId

primaryEmailCampaignId

The unique identifier of the primary email campaign associated with an object or event.

metric

processingStatus

processingStatus

The current processing status of the content or task.

dimension

publishDate

publishDate

The date and time when the content (e.g., email, page) was published.

dimension

publish_date

publish_date

The date when content (e.g., blog post, page, email) was published.

dimension

publishedAt

publishedAt

The timestamp when the content was published.

dimension

publishedByEmail

publishedByEmail

The email address of the user who published a piece of content.

dimension

publishedById

publishedById

The user ID of the person who published a piece of content.

metric

publishedByName

publishedByName

The name of the user who published a piece of content.

dimension

rssEmailAuthorLineTemplate

rssEmailAuthorLineTemplate

A template used to define the format of the author’s line in an RSS-to-email feed.

dimension

rssEmailBlogImageMaxWidth

rssEmailBlogImageMaxWidth

The maximum width allowed for blog images within an RSS-to-email campaign.

metric

rssEmailByText

rssEmailByText

The text used to denote the author in an RSS-driven email.

dimension

rssEmailClickThroughText

rssEmailClickThroughText

The click-through text used in an RSS-driven email.

dimension

rssEmailCommentText

rssEmailCommentText

The comment text used in an RSS-driven email.

dimension

rssEmailEntryTemplate

rssEmailEntryTemplate

A template used to define the structure and content of an individual entry within an RSS-to-email feed.

dimension

rssEmailEntryTemplateEnabled

rssEmailEntryTemplateEnabled

Indicates if an RSS email entry template is enabled.

dimension

rssEmailImageMaxWidth

rssEmailImageMaxWidth

The maximum width for images in an RSS-driven email.

metric

rssEmailUrl

rssEmailUrl

The URL of the RSS feed used for an RSS-driven email.

dimension

rssToEmailTiming

rssToEmailTiming

The scheduling or frequency settings for sending out RSS-to-email updates.

dimension

rssUrl

rssUrl

The URL of the RSS feed used for pulling content into RSS-to-email campaigns.

dimension

securityState

securityState

The security status or state of an object or account.

dimension

sendOnPublish

sendOnPublish

A boolean indicating if the content (e.g., email, social post) should be sent or published immediately upon creation.

dimension

slug

slug

The URL slug for the content.

dimension

state

state

The current state or status of the content (e.g., DRAFT, PUBLISHED).

dimension

stats.counters.bounce

stats.counters.bounce

The count of emails that bounced during a campaign send.

metric

stats.counters.click

stats.counters.click

The total number of clicks on links within the email.

metric

stats.counters.contactslost

stats.counters.contactslost

The number of contacts lost (e.g., unsubscribed or hard bounced).

metric

stats.counters.delivered

stats.counters.delivered

The total number of emails successfully delivered to recipients.

metric

stats.counters.dropped

stats.counters.dropped

The number of emails that were not sent by HubSpot due to various reasons (e.g., invalid email, unengaged).

metric

stats.counters.hardbounced

stats.counters.hardbounced

The number of emails that resulted in a permanent delivery failure.

metric

stats.counters.notsent

stats.counters.notsent

The number of emails that were not sent for various reasons.

metric

stats.counters.open

stats.counters.open

The total number of times the email was opened by recipients.

metric

stats.counters.pending

stats.counters.pending

The number of emails that are currently awaiting delivery.

metric

stats.counters.reply

stats.counters.reply

The total number of replies received for the email.

metric

stats.counters.selected

stats.counters.selected

The number of contacts selected as recipients for the email.

metric

stats.counters.sent

stats.counters.sent

The total number of emails sent.

metric

stats.counters.softbounced

stats.counters.softbounced

The number of emails that resulted in a temporary delivery failure.

metric

stats.counters.spamreport

stats.counters.spamreport

The number of times the email was marked as spam by recipients.

metric

stats.counters.suppressed

stats.counters.suppressed

The number of emails that were suppressed (not sent) due to various reasons (e.g., unsubscribed, bounced).

metric

stats.counters.unsubscribed

stats.counters.unsubscribed

The number of recipients who unsubscribed from the email list.

metric

stats.deviceBreakdown.click_device_type.computer

stats.deviceBreakdown.click_device_type.computer

The number of clicks from computer devices.

metric

stats.deviceBreakdown.click_device_type.mobile

stats.deviceBreakdown.click_device_type.mobile

The number of clicks from mobile devices.

metric

stats.deviceBreakdown.click_device_type.unknown

stats.deviceBreakdown.click_device_type.unknown

The number of clicks from unknown device types.

metric

stats.deviceBreakdown.open_device_type.computer

stats.deviceBreakdown.open_device_type.computer

The number of opens from computer devices.

metric

stats.deviceBreakdown.open_device_type.mobile

stats.deviceBreakdown.open_device_type.mobile

The number of opens from mobile devices.

metric

stats.deviceBreakdown.open_device_type.unknown

stats.deviceBreakdown.open_device_type.unknown

The number of opens from unknown device types.

metric

stats_failedToLoad

stats_failedToLoad

Indicates if statistics or an asset failed to load, commonly seen in email marketing performance data.

dimension

stats_ratios_bounceratio

stats_ratios_bounceratio

The ratio of total bounced emails to the total emails sent.

metric

stats_ratios_clickratio

stats_ratios_clickratio

The ratio of unique clicks on marketing emails to unique email opens.

metric

stats_ratios_clickthroughratio

stats_ratios_clickthroughratio

The click-through rate, representing the ratio of unique clicks to total emails delivered.

metric

stats_ratios_contactslostratio

stats_ratios_contactslostratio

The ratio of contacts lost (e.g., unsubscribed, bounced) from an email list.

metric

stats_ratios_deliveredratio

stats_ratios_deliveredratio

The ratio of successfully delivered marketing emails to the total emails sent.

metric

stats_ratios_hardbounceratio

stats_ratios_hardbounceratio

The ratio of hard bounced emails to the total emails sent, indicating permanent delivery failures.

metric

stats_ratios_notsentratio

stats_ratios_notsentratio

The ratio of emails that were not sent to the intended recipients.

metric

stats_ratios_openratio

stats_ratios_openratio

The ratio of unique marketing email opens to the total emails delivered.

metric

stats_ratios_pendingratio

stats_ratios_pendingratio

The ratio of emails that are currently in a pending state before sending.

metric

stats_ratios_replyratio

stats_ratios_replyratio

The ratio of replies received for marketing emails relative to the number of emails delivered.

metric

stats_ratios_softbounceratio

stats_ratios_softbounceratio

The ratio of soft bounced emails to the total emails sent, indicating temporary delivery failures.

metric

stats_ratios_spamreportratio

stats_ratios_spamreportratio

The ratio of spam reports to the total emails delivered.

metric

stats_ratios_unsubscribedratio

stats_ratios_unsubscribedratio

The ratio of contacts who unsubscribed from marketing emails to the total emails delivered.

metric

subcategory

subcategory

A more specific classification under a main category for an object or content.

dimension

subject

subject

The subject line of the email or communication.

dimension

subscriptionBlogId

subscriptionBlogId

The unique identifier of the blog to which a subscription is associated.

metric

subscriptionDetails.officeLocationId

subscriptionDetails.officeLocationId

The unique identifier for the office location associated with a subscription.

metric

subscriptionDetails.subscriptionId

subscriptionDetails.subscriptionId

The unique identifier for a subscription.

metric

subscriptionName

subscriptionName

The name of the email subscription type.

dimension

templatePath

templatePath

The file path to the email or content template used.

dimension

testing.abSampleSizeDefault

testing.abSampleSizeDefault

The default sample size percentage used for A/B testing variations.

dimension

testing.abSamplingDefault

testing.abSamplingDefault

The default sampling method for A/B testing.

dimension

testing.abStatus

testing.abStatus

The current status of an A/B test.

dimension

testing.abSuccessMetric

testing.abSuccessMetric

The metric used to determine the winner of an A/B test (e.g., open rate, click-through rate).

dimension

testing.abTestPercentage

testing.abTestPercentage

The percentage of recipients included in the A/B test.

metric

testing.hoursToWait

testing.hoursToWait

The number of hours to wait before automatically choosing an A/B test winner.

metric

testing.testId

testing.testId

The unique identifier for an A/B test.

metric

ticketIds

associated_ticket_ids

A list of unique identifiers for associated ticket records.

dimension

transactional

transactional

Indicates if an email is a transactional email, used for non-marketing communications such as order confirmations.

dimension

type

type

The type of an object or property (e.g., string, number, email for properties; EMAIL, CALL for engagements).

dimension

unpublishedAt

unpublishedAt

The timestamp when content, such as an email or page, was unpublished.

metric

updatedAt

updatedAt

The timestamp when the record was last updated.

dimension

updatedById

updatedById

The ID of the user who last updated the record.

metric

url

url

The URL associated with the record or content.

dimension

useRssHeadlineAsSubject

useRssHeadlineAsSubject

A boolean indicating whether the RSS feed headline should be used as the email subject line for blog subscription emails.

dimension

version_date

version_date

This field refers to the date of the HubSpot API version used for data collection, following a YYYY-MM format, indicating the release date of the API specification.

dimension

version_timestamp

version_timestamp

This field represents the timestamp, likely in Unix milliseconds, corresponding to the version_date of the HubSpot API used for data collection.

dimension

webversion.domain

webversion.domain

The domain used for the web version of an email or landing page.

dimension

webversion.metaDescription

webversion.metaDescription

The meta description for the web version of the content.

dimension

webversion.url

webversion.url

The URL for the web version of the content.

dimension