---
title: "HubSpot Marketing Emails metrics and dimensions"
slug: "hubspot-marketing-emails-fields"
description: "Explore the complete list of HubSpot Marketing Emails metrics and dimensions available through Supermetrics."
updated: 2026-04-02T09:01:27Z
published: 2026-04-02T09:01:27Z
canonical: "docs.supermetrics.com/hubspot-marketing-emails-fields"
---

> ## 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

> Supermetrics brings all your HubSpot Marketing Emails data into [Google Sheets](https://workspace.google.com/marketplace/app/supermetrics/523876908005), [Looker Studio](https://supermetrics.com/products/looker-studio), [Power BI](https://supermetrics.com/products/power-bi), [Excel](https://supermetrics.com/products/excel), [BigQuery](https://supermetrics.com/products/bigquery), [Snowflake](https://supermetrics.com/products/snowflake), [Redshift](https://supermetrics.com/products/amazon-redshift), [Azure](https://supermetrics.com/products/azure-synapse)

Early Access21 metrics49 dimensionsSearch fields

### CAMPAIGNS

| \| campaign_name \| \| --- \| \| \\| Field label \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| The name of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Campaign name \| \| Description \| The name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| campaign_name |
| \| Field label \| Campaign name \| \| --- \| --- \| \| Description \| The name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Campaign name |
| Description | The name of the campaign |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| Field label \| Campaign ID \| \| Description \| The ID of the campaign this email is associated to \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| Field label | Campaign ID |
| Description | The ID of the campaign this email is associated to |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### 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](/apidocs/field-data-types#text) \\| \\| Destinations \\| API, Data warehouse \\| \| \| 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](/apidocs/field-data-types#text) \| \| Destinations \| API, Data warehouse \| |
| --- |
| 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](/apidocs/field-data-types#text) \| \| Destinations \| API, Data warehouse \| |
| 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](/apidocs/field-data-types#text) |
| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |

### 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](/apidocs/field-data-types#text) \\| \| \| Field label \| Email name \| \| Description \| The name of the email, as displayed on the email dashboard \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| 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](/apidocs/field-data-types#text) \| |
| Field label | Email name |
| Description | The name of the email, as displayed on the email dashboard |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| email_id \| \| --- \| \| \\| Field label \\| Email ID \\| \\| --- \\| --- \\| \\| Description \\| The email ID \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Email ID \| \| Description \| The email ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| email_id |
| \| Field label \| Email ID \| \| --- \| --- \| \| Description \| The email ID \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Email ID |
| Description | The email ID |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| subject \| \| --- \| \| \\| Field label \\| Subject \\| \\| --- \\| --- \\| \\| Description \\| The subject of the email \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Subject \| \| Description \| The subject of the email \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| subject |
| \| Field label \| Subject \| \| --- \| --- \| \| Description \| The subject of the email \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Subject |
| Description | The subject of the email |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| preview_text \| \| --- \| \| \\| Field label \\| Preview text \\| \\| --- \\| --- \\| \\| Description \\| Preview text displayed in email clients \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Preview text \| \| Description \| Preview text displayed in email clients \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| preview_text |
| \| Field label \| Preview text \| \| --- \| --- \| \| Description \| Preview text displayed in email clients \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Preview text |
| Description | Preview text displayed in email clients |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |
| \| from_name \| \| --- \| \| \\| Field label \\| From name \\| \\| --- \\| --- \\| \\| Description \\| The name recipients will see \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| From name \| \| Description \| The name recipients will see \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| from_name |
| \| Field label \| From name \| \| --- \| --- \| \| Description \| The name recipients will see \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | From name |
| Description | The name recipients will see |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| Field label \| From address \| \| Description \| The from address and reply to email address recipients will see \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| Field label | From address |
| Description | The from address and reply to email address recipients will see |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| publish_status \| \| --- \| \| \\| Field label \\| Publish status \\| \\| --- \\| --- \\| \\| Description \\| Returns the published status of the email \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Publish status \| \| Description \| Returns the published status of the email \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| publish_status |
| \| Field label \| Publish status \| \| --- \| --- \| \| Description \| Returns the published status of the email \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Publish status |
| Description | Returns the published status of the email |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| publish_author \| \| --- \| \| \\| Field label \\| Publish author \\| \\| --- \\| --- \\| \\| Description \\| Name of the user who published the email \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Publish author \| \| Description \| Name of the user who published the email \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| publish_author |
| \| Field label \| Publish author \| \| --- \| --- \| \| Description \| Name of the user who published the email \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Publish author |
| Description | Name of the user who published the email |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| Field label \| Publish by email \| \| Description \| Email of the user who published/sent the email \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| Field label | Publish by email |
| Description | Email of the user who published/sent the email |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| sent \| \| --- \| \| \\| Field label \\| Sent \\| \\| --- \\| --- \\| \\| Description \\| Total number of emails sent \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Sent \| \| Description \| Total number of emails sent \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| sent |
| \| Field label \| Sent \| \| --- \| --- \| \| Description \| Total number of emails sent \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Sent |
| Description | Total number of emails sent |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| not_sent \| \| --- \| \| \\| Field label \\| Not sent \\| \\| --- \\| --- \\| \\| Description \\| Total number of emails not sent \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Not sent \| \| Description \| Total number of emails not sent \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| not_sent |
| \| Field label \| Not sent \| \| --- \| --- \| \| Description \| Total number of emails not sent \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Not sent |
| Description | Total number of emails not sent |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| delivered \| \| --- \| \| \\| Field label \\| Delivered \\| \\| --- \\| --- \\| \\| Description \\| Total number of emails successfully delivered \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Delivered \| \| Description \| Total number of emails successfully delivered \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| delivered |
| \| Field label \| Delivered \| \| --- \| --- \| \| Description \| Total number of emails successfully delivered \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Delivered |
| Description | Total number of emails successfully delivered |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| delivery_rate \| \| --- \| \| \\| Field label \\| Delivery rate \\| \\| --- \\| --- \\| \\| Description \\| Percentage of emails successfully delivered. Calculated as: delivered / sent \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| Delivery rate \| \| Description \| Percentage of emails successfully delivered. Calculated as: delivered / sent \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| delivery_rate |
| \| Field label \| Delivery rate \| \| --- \| --- \| \| Description \| Percentage of emails successfully delivered. Calculated as: delivered / sent \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| Field label | Delivery rate |
| Description | Percentage of emails successfully delivered. Calculated as: delivered / sent |
| Field type | metric |
| Data type | [float.number.ratio](/apidocs/field-data-types#number) |
| \| opened \| \| --- \| \| \\| Field label \\| Opened \\| \\| --- \\| --- \\| \\| Description \\| Total number of emails opened by recipients \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Opened \| \| Description \| Total number of emails opened by recipients \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| opened |
| \| Field label \| Opened \| \| --- \| --- \| \| Description \| Total number of emails opened by recipients \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Opened |
| Description | Total number of emails opened by recipients |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| open_rate \| \| --- \| \| \\| Field label \\| Open rate \\| \\| --- \\| --- \\| \\| Description \\| Percentage of emails opened. Calculated as: opened / sent \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| Open rate \| \| Description \| Percentage of emails opened. Calculated as: opened / sent \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| open_rate |
| \| Field label \| Open rate \| \| --- \| --- \| \| Description \| Percentage of emails opened. Calculated as: opened / sent \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| Field label | Open rate |
| Description | Percentage of emails opened. Calculated as: opened / sent |
| Field type | metric |
| Data type | [float.number.ratio](/apidocs/field-data-types#number) |
| \| clicked \| \| --- \| \| \\| Field label \\| Clicked \\| \\| --- \\| --- \\| \\| Description \\| Total number of emails where a link was clicked \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Clicked \| \| Description \| Total number of emails where a link was clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| clicked |
| \| Field label \| Clicked \| \| --- \| --- \| \| Description \| Total number of emails where a link was clicked \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Clicked |
| Description | Total number of emails where a link was clicked |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#number) \\| \| \| Field label \| Click rate \| \| Description \| Percentage of emails with link clicks. Calculated as: clicked / sent \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| 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](/apidocs/field-data-types#number) \| |
| Field label | Click rate |
| Description | Percentage of emails with link clicks. Calculated as: clicked / sent |
| Field type | metric |
| Data type | [float.number.ratio](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#number) \\| \| \| 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](/apidocs/field-data-types#number) \| |
| 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](/apidocs/field-data-types#number) \| |
| 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](/apidocs/field-data-types#number) |
| \| replied \| \| --- \| \| \\| Field label \\| Replied \\| \\| --- \\| --- \\| \\| Description \\| Total number of emails that received a reply \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Replied \| \| Description \| Total number of emails that received a reply \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| replied |
| \| Field label \| Replied \| \| --- \| --- \| \| Description \| Total number of emails that received a reply \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Replied |
| Description | Total number of emails that received a reply |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#number) \\| \| \| Field label \| Reply rate \| \| Description \| Percentage of emails that received a reply. Calculated as: replied / sent \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| 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](/apidocs/field-data-types#number) \| |
| Field label | Reply rate |
| Description | Percentage of emails that received a reply. Calculated as: replied / sent |
| Field type | metric |
| Data type | [float.number.ratio](/apidocs/field-data-types#number) |
| \| bounces \| \| --- \| \| \\| Field label \\| Bounces \\| \\| --- \\| --- \\| \\| Description \\| Total number of emails that bounced \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Bounces \| \| Description \| Total number of emails that bounced \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| bounces |
| \| Field label \| Bounces \| \| --- \| --- \| \| Description \| Total number of emails that bounced \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Bounces |
| Description | Total number of emails that bounced |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| bounce_rate \| \| --- \| \| \\| Field label \\| Bounce rate \\| \\| --- \\| --- \\| \\| Description \\| Percentage of emails that bounced. Calculated as: bounces / sent \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| Bounce rate \| \| Description \| Percentage of emails that bounced. Calculated as: bounces / sent \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| bounce_rate |
| \| Field label \| Bounce rate \| \| --- \| --- \| \| Description \| Percentage of emails that bounced. Calculated as: bounces / sent \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| Field label | Bounce rate |
| Description | Percentage of emails that bounced. Calculated as: bounces / sent |
| Field type | metric |
| Data type | [float.number.ratio](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#number) \\| \| \| Field label \| Hard bounced \| \| Description \| Total number of emails that hard bounced (permanent delivery failure) \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| 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](/apidocs/field-data-types#number) \| |
| Field label | Hard bounced |
| Description | Total number of emails that hard bounced (permanent delivery failure) |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#number) \\| \| \| 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](/apidocs/field-data-types#number) \| |
| 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](/apidocs/field-data-types#number) \| |
| 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](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#number) \\| \| \| Field label \| Soft bounced \| \| Description \| Total number of emails that soft bounced (temporary delivery failure) \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| 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](/apidocs/field-data-types#number) \| |
| Field label | Soft bounced |
| Description | Total number of emails that soft bounced (temporary delivery failure) |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#number) \\| \| \| 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](/apidocs/field-data-types#number) \| |
| 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](/apidocs/field-data-types#number) \| |
| 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](/apidocs/field-data-types#number) |
| \| unsubscribed \| \| --- \| \| \\| Field label \\| Unsubscribed \\| \\| --- \\| --- \\| \\| Description \\| Total number of recipients who unsubscribed \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Unsubscribed \| \| Description \| Total number of recipients who unsubscribed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| unsubscribed |
| \| Field label \| Unsubscribed \| \| --- \| --- \| \| Description \| Total number of recipients who unsubscribed \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Unsubscribed |
| Description | Total number of recipients who unsubscribed |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| unsubscribe_rate \| \| --- \| \| \\| Field label \\| Unsubscribe rate \\| \\| --- \\| --- \\| \\| Description \\| Percentage of recipients who unsubscribed. Calculated as: unsubscribed / sent \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| Unsubscribe rate \| \| Description \| Percentage of recipients who unsubscribed. Calculated as: unsubscribed / sent \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| unsubscribe_rate |
| \| Field label \| Unsubscribe rate \| \| --- \| --- \| \| Description \| Percentage of recipients who unsubscribed. Calculated as: unsubscribed / sent \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| Field label | Unsubscribe rate |
| Description | Percentage of recipients who unsubscribed. Calculated as: unsubscribed / sent |
| Field type | metric |
| Data type | [float.number.ratio](/apidocs/field-data-types#number) |
| \| spam_report \| \| --- \| \| \\| Field label \\| Spam report \\| \\| --- \\| --- \\| \\| Description \\| Total number of spam reports received \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Spam report \| \| Description \| Total number of spam reports received \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| spam_report |
| \| Field label \| Spam report \| \| --- \| --- \| \| Description \| Total number of spam reports received \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Field label | Spam report |
| Description | Total number of spam reports received |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| 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](/apidocs/field-data-types#number) \\| \| \| Field label \| Spam rate \| \| Description \| Percentage of emails reported as spam. Calculated as: spam_report / sent \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| 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](/apidocs/field-data-types#number) \| |
| Field label | Spam rate |
| Description | Percentage of emails reported as spam. Calculated as: spam_report / sent |
| Field type | metric |
| Data type | [float.number.ratio](/apidocs/field-data-types#number) |

### PORTAL

| \| portal_id \| \| --- \| \| \\| Field label \\| Portal ID \\| \\| --- \\| --- \\| \\| Description \\| The unique identifier for the HubSpot portal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Portal ID \| \| Description \| The unique identifier for the HubSpot portal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| portal_id |
| \| Field label \| Portal ID \| \| --- \| --- \| \| Description \| The unique identifier for the HubSpot portal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Portal ID |
| Description | The unique identifier for the HubSpot portal |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| portal_domain \| \| --- \| \| \\| Field label \\| Portal domain \\| \\| --- \\| --- \\| \\| Description \\| The domain name associated with the HubSpot portal \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Portal domain \| \| Description \| The domain name associated with the HubSpot portal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| portal_domain |
| \| Field label \| Portal domain \| \| --- \| --- \| \| Description \| The domain name associated with the HubSpot portal \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Field label | Portal domain |
| Description | The domain name associated with the HubSpot portal |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |

### 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](/apidocs/field-data-types#time) \\| \| \| Field label \| Start date \| \| Description \| The start date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| --- |
| 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](/apidocs/field-data-types#time) \| |
| Field label | Start date |
| Description | The start date of the requested query |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| 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](/apidocs/field-data-types#time) \\| \| \| Field label \| End date \| \| Description \| The end date of the requested query \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| 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](/apidocs/field-data-types#time) \| |
| Field label | End date |
| Description | The end date of the requested query |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| system_metadata.query_timezone \| \| --- \| \| \\| Field label \\| Timezone \\| \\| --- \\| --- \\| \\| Description \\| The timezone that is supplied to the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.timezone](/apidocs/field-data-types#time) \\| \| \| Field label \| Timezone \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| |
| system_metadata.query_timezone |
| \| Field label \| Timezone \| \| --- \| --- \| \| Description \| The timezone that is supplied to the query \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| |
| Field label | Timezone |
| Description | The timezone that is supplied to the query |
| Field type | dimension |
| Data type | [string.time.timezone](/apidocs/field-data-types#time) |
| \| system_metadata.query_filters \| \| --- \| \| \\| Field label \\| Filters \\| \\| --- \\| --- \\| \\| Description \\| All filters used in the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.json](/apidocs/field-data-types#text) \\| \| \| Field label \| Filters \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| system_metadata.query_filters |
| \| Field label \| Filters \| \| --- \| --- \| \| Description \| All filters used in the query \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| Field label | Filters |
| Description | All filters used in the query |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| system_metadata.query_date_start \| \| --- \| \| \\| Field label \\| Start \\| \\| --- \\| --- \\| \\| Description \\| When the query was started \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Start \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| system_metadata.query_date_start |
| \| Field label \| Start \| \| --- \| --- \| \| Description \| When the query was started \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Start |
| Description | When the query was started |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| system_metadata.query_date_end \| \| --- \| \| \\| Field label \\| End \\| \\| --- \\| --- \\| \\| Description \\| When the query completed \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| End \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| system_metadata.query_date_end |
| \| Field label \| End \| \| --- \| --- \| \| Description \| When the query completed \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | End |
| Description | When the query completed |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| system_metadata.query_duration \| \| --- \| \| \\| Field label \\| Duration \\| \\| --- \\| --- \\| \\| Description \\| The duration in seconds of the query \\| \\| Field type \\| dimension \\| \\| Data type \\| [int.duration.seconds](/apidocs/field-data-types#duration) \\| \| \| Field label \| Duration \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| |
| system_metadata.query_duration |
| \| Field label \| Duration \| \| --- \| --- \| \| Description \| The duration in seconds of the query \| \| Field type \| dimension \| \| Data type \| [int.duration.seconds](/apidocs/field-data-types#duration) \| |
| Field label | Duration |
| Description | The duration in seconds of the query |
| Field type | dimension |
| Data type | [int.duration.seconds](/apidocs/field-data-types#duration) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| Field label \| Accounts \| \| Description \| A list of accounts of which the data was pulled from \| \| Field type \| dimension \| \| Data type \| [string.text.json](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| Field label | Accounts |
| Description | A list of accounts of which the data was pulled from |
| Field type | dimension |
| Data type | [string.text.json](/apidocs/field-data-types#text) |
| \| 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](/apidocs/field-data-types#text) \\| \| \| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) \| |
| 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](/apidocs/field-data-types#text) |

### TIME

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

### TIMESTAMP

| \| created_date \| \| --- \| \| \\| Field label \\| Created date \\| \\| --- \\| --- \\| \\| Description \\| The date of the email's creation \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Created date \| \| Description \| The date of the email's creation \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| --- |
| created_date |
| \| Field label \| Created date \| \| --- \| --- \| \| Description \| The date of the email's creation \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Created date |
| Description | The date of the email's creation |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| created_datetime \| \| --- \| \| \\| Field label \\| Created datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time of the email's creation \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Created datetime \| \| Description \| The date and time of the email's creation \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| created_datetime |
| \| Field label \| Created datetime \| \| --- \| --- \| \| Description \| The date and time of the email's creation \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Created datetime |
| Description | The date and time of the email's creation |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| 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](/apidocs/field-data-types#time) \\| \| \| 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](/apidocs/field-data-types#time) \| |
| 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](/apidocs/field-data-types#time) \| |
| 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](/apidocs/field-data-types#time) |
| \| 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](/apidocs/field-data-types#time) \\| \| \| 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](/apidocs/field-data-types#time) \| |
| 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](/apidocs/field-data-types#time) \| |
| 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](/apidocs/field-data-types#time) |
| \| updated_date \| \| --- \| \| \\| Field label \\| Updated date \\| \\| --- \\| --- \\| \\| Description \\| The date of the last update to the email \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Updated date \| \| Description \| The date of the last update to the email \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| updated_date |
| \| Field label \| Updated date \| \| --- \| --- \| \| Description \| The date of the last update to the email \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Updated date |
| Description | The date of the last update to the email |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| 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](/apidocs/field-data-types#time) \\| \| \| Field label \| Updated datetime \| \| Description \| The date and time of the last update to the email \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| 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](/apidocs/field-data-types#time) \| |
| Field label | Updated datetime |
| Description | The date and time of the last update to the email |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| deleted_date \| \| --- \| \| \\| Field label \\| Deleted date \\| \\| --- \\| --- \\| \\| Description \\| The date the email was deleted at \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Deleted date \| \| Description \| The date the email was deleted at \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| deleted_date |
| \| Field label \| Deleted date \| \| --- \| --- \| \| Description \| The date the email was deleted at \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Field label | Deleted date |
| Description | The date the email was deleted at |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| deleted_datetime \| \| --- \| \| \\| Field label \\| Deleted datetime \\| \\| --- \\| --- \\| \\| Description \\| The date and time the email was deleted at \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Deleted datetime \| \| Description \| The date and time the email was deleted at \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| deleted_datetime |
| \| Field label \| Deleted datetime \| \| --- \| --- \| \| Description \| The date and time the email was deleted at \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Field label | Deleted datetime |
| Description | The date and time the email was deleted at |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |