Documentation Index

Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt

Use this file to discover all available pages before exploring further.

HubSpot Marketing Emails metrics and dimensions

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

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

Early Access21 metrics49 dimensions

CAMPAIGNS

campaign_name
Field label Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
campaign_id
Field label Campaign ID
Description The ID of the campaign this email is associated to
Field type dimension
Data type string.text.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

EMAILS

email_name
Field label Email name
Description The name of the email, as displayed on the email dashboard
Field type dimension
Data type string.text.value
email_id
Field label Email ID
Description The email ID
Field type dimension
Data type string.text.value
subject
Field label Subject
Description The subject of the email
Field type dimension
Data type string.text.value
preview_text
Field label Preview text
Description Preview text displayed in email clients
Field type dimension
Data type string.text.value
email_type
Field label Email type
Description The email type, this is derived from other properties on the email such as subcategory
Field type dimension
Data type string.text.value
from_name
Field label From name
Description The name recipients will see
Field type dimension
Data type string.text.value
from_address
Field label From address
Description The from address and reply to email address recipients will see
Field type dimension
Data type string.text.email
publish_status
Field label Publish status
Description Returns the published status of the email
Field type dimension
Data type string.text.value
publish_author
Field label Publish author
Description Name of the user who published the email
Field type dimension
Data type string.text.value
publish_by_email
Field label Publish by email
Description Email of the user who published/sent the email
Field type dimension
Data type string.text.value
sent
Field label Sent
Description Total number of emails sent
Field type metric
Data type int.number.value
not_sent
Field label Not sent
Description Total number of emails not sent
Field type metric
Data type int.number.value
delivered
Field label Delivered
Description Total number of emails successfully delivered
Field type metric
Data type int.number.value
delivery_rate
Field label Delivery rate
Description Percentage of emails successfully delivered. Calculated as: delivered / sent
Field type metric
Data type float.number.ratio
opened
Field label Opened
Description Total number of emails opened by recipients
Field type metric
Data type int.number.value
open_rate
Field label Open rate
Description Percentage of emails opened. Calculated as: opened / sent
Field type metric
Data type float.number.ratio
clicked
Field label Clicked
Description Total number of emails where a link was clicked
Field type metric
Data type int.number.value
click_rate
Field label Click rate
Description Percentage of emails with link clicks. Calculated as: clicked / sent
Field type metric
Data type float.number.ratio
ctr
Field label CTR
Description The percentage of recipients who clicked a CTA, out of those who opened your email
Field type metric
Data type float.number.ratio
replied
Field label Replied
Description Total number of emails that received a reply
Field type metric
Data type int.number.value
reply_rate
Field label Reply rate
Description Percentage of emails that received a reply. Calculated as: replied / sent
Field type metric
Data type float.number.ratio
bounces
Field label Bounces
Description Total number of emails that bounced
Field type metric
Data type int.number.value
bounce_rate
Field label Bounce rate
Description Percentage of emails that bounced. Calculated as: bounces / sent
Field type metric
Data type float.number.ratio
hard_bounced
Field label Hard bounced
Description Total number of emails that hard bounced (permanent delivery failure)
Field type metric
Data type int.number.value
hard_bounce_rate
Field label Hard bounce rate
Description Percentage of emails that hard bounced. Calculated as: hard_bounced / sent
Field type metric
Data type float.number.ratio
soft_bounced
Field label Soft bounced
Description Total number of emails that soft bounced (temporary delivery failure)
Field type metric
Data type int.number.value
soft_bounce_rate
Field label Soft bounce rate
Description Percentage of emails that soft bounced. Calculated as: soft_bounced / sent
Field type metric
Data type float.number.ratio
unsubscribed
Field label Unsubscribed
Description Total number of recipients who unsubscribed
Field type metric
Data type int.number.value
unsubscribe_rate
Field label Unsubscribe rate
Description Percentage of recipients who unsubscribed. Calculated as: unsubscribed / sent
Field type metric
Data type float.number.ratio
spam_report
Field label Spam report
Description Total number of spam reports received
Field type metric
Data type int.number.value
spam_rate
Field label Spam rate
Description Percentage of emails reported as spam. Calculated as: spam_report / sent
Field type metric
Data type float.number.ratio

PORTAL

portal_id
Field label Portal ID
Description The unique identifier for the HubSpot portal
Field type dimension
Data type string.text.value
portal_domain
Field label Portal domain
Description The domain name associated with the HubSpot portal
Field type dimension
Data type string.text.value

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

TIMESTAMP

created_date
Field label Created date
Description The date of the email's creation
Field type dimension
Data type string.time.date
created_datetime
Field label Created datetime
Description The date and time of the email's creation
Field type dimension
Data type string.time.datetime
published_date
Field label Published date
Description The date the email is scheduled for. This is only used in local time or scheduled emails
Field type dimension
Data type string.time.date
published_datetime
Field label Published datetime
Description The date and time the email is scheduled for. This is only used in local time or scheduled emails
Field type dimension
Data type string.time.datetime
updated_date
Field label Updated date
Description The date of the last update to the email
Field type dimension
Data type string.time.date
updated_datetime
Field label Updated datetime
Description The date and time of the last update to the email
Field type dimension
Data type string.time.datetime
deleted_date
Field label Deleted date
Description The date the email was deleted at
Field type dimension
Data type string.time.date
deleted_datetime
Field label Deleted datetime
Description The date and time the email was deleted at
Field type dimension
Data type string.time.datetime

© Supermetrics 2026