--- title: "Campaign Monitor metrics and dimensions" slug: "campaign-monitor-fields" description: "Explore the Campaign Monitor metrics and dimensions available through Supermetrics. Find the fields you need for your ideal marketing reports." updated: 2026-03-05T14:17:56Z published: 2026-03-05T14:17:56Z canonical: "docs.supermetrics.com/campaign-monitor-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. # Campaign Monitor metrics and dimensions > Supermetrics brings all your Campaign Monitor 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) 15 metrics33 dimensionsSearch fields ### CAMPAIGN | \| campaigns__campaign_id \| \| --- \| \| \\| Field label \\| Campaign ID \\| \\| --- \\| --- \\| \\| Description \\| ID of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Campaign ID \| \| Description \| ID of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | --- | | campaigns__campaign_id | | \| Field label \| Campaign ID \| \| --- \| --- \| \| Description \| ID of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Campaign ID | | Description | ID of the campaign | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaigns__campaign_name \| \| --- \| \| \\| Field label \\| Campaign name \\| \\| --- \\| --- \\| \\| Description \\| Name of the campaign \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Campaign name \| \| Description \| Name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaigns__campaign_name | | \| Field label \| Campaign name \| \| --- \| --- \| \| Description \| Name of the campaign \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Campaign name | | Description | Name of the campaign | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaigns__from_name \| \| --- \| \| \\| Field label \\| From name \\| \\| --- \\| --- \\| \\| Description \\| From name \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| From name \| \| Description \| From name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaigns__from_name | | \| Field label \| From name \| \| --- \| --- \| \| Description \| From name \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | From name | | Description | From name | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaigns__from_email \| \| --- \| \| \\| Field label \\| From email \\| \\| --- \\| --- \\| \\| Description \\| From email \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| From email \| \| Description \| From email \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaigns__from_email | | \| Field label \| From email \| \| --- \| --- \| \| Description \| From email \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | From email | | Description | From email | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaigns__subject \| \| --- \| \| \\| Field label \\| Subject \\| \\| --- \\| --- \\| \\| Description \\| Campaign subject \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Subject \| \| Description \| Campaign subject \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaigns__subject | | \| Field label \| Subject \| \| --- \| --- \| \| Description \| Campaign subject \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Subject | | Description | Campaign subject | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaigns__reply_to \| \| --- \| \| \\| Field label \\| Reply to \\| \\| --- \\| --- \\| \\| Description \\| Email for replying \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Field label \| Reply to \| \| Description \| Email for replying \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | campaigns__reply_to | | \| Field label \| Reply to \| \| --- \| --- \| \| Description \| Email for replying \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| | | Field label | Reply to | | Description | Email for replying | | Field type | dimension | | Data type | [string.text.value](/apidocs/field-data-types#text) | | \| campaigns__web_version_url \| \| --- \| \| \\| Field label \\| Web version URL \\| \\| --- \\| --- \\| \\| Description \\| Link to the web version \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| Web version URL \| \| Description \| Link to the web version \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | campaigns__web_version_url | | \| Field label \| Web version URL \| \| --- \| --- \| \| Description \| Link to the web version \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | Field label | Web version URL | | Description | Link to the web version | | Field type | dimension | | Data type | [string.text.url](/apidocs/field-data-types#text) | | \| campaigns__web_version_text_url \| \| --- \| \| \\| Field label \\| Web version text URL \\| \\| --- \\| --- \\| \\| Description \\| Link to the web version in text \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Field label \| Web version text URL \| \| Description \| Link to the web version in text \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | campaigns__web_version_text_url | | \| Field label \| Web version text URL \| \| --- \| --- \| \| Description \| Link to the web version in text \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| | | Field label | Web version text URL | | Description | Link to the web version in text | | Field type | dimension | | Data type | [string.text.url](/apidocs/field-data-types#text) | ### CAMPAIGN SENT TIME | \| campaigns__year \| \| --- \| \| \\| Field label \\| Year \\| \\| --- \\| --- \\| \\| Description \\| Year \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.year](/apidocs/field-data-types#time) \\| \| \| Field label \| Year \| \| Description \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | --- | | campaigns__year | | \| Field label \| Year \| \| --- \| --- \| \| Description \| Year \| \| Field type \| dimension \| \| Data type \| [string.time.year](/apidocs/field-data-types#time) \| | | Field label | Year | | Description | Year | | Field type | dimension | | Data type | [string.time.year](/apidocs/field-data-types#time) | | \| campaigns__year_month \| \| --- \| \| \\| Field label \\| Year & month \\| \\| --- \\| --- \\| \\| Description \\| Year & month \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & month \| \| Description \| Year & month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | campaigns__year_month | | \| Field label \| Year & month \| \| --- \| --- \| \| Description \| Year & month \| \| Field type \| dimension \| \| Data type \| [string.time.yearmonth](/apidocs/field-data-types#time) \| | | Field label | Year & month | | Description | Year & month | | Field type | dimension | | Data type | [string.time.yearmonth](/apidocs/field-data-types#time) | | \| campaigns__month \| \| --- \| \| \\| Field label \\| Month \\| \\| --- \\| --- \\| \\| Description \\| Month \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.month](/apidocs/field-data-types#time) \\| \| \| Field label \| Month \| \| Description \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| | | campaigns__month | | \| Field label \| Month \| \| --- \| --- \| \| Description \| Month \| \| Field type \| dimension \| \| Data type \| [string.time.month](/apidocs/field-data-types#time) \| | | Field label | Month | | Description | Month | | Field type | dimension | | Data type | [string.time.month](/apidocs/field-data-types#time) | | \| campaigns__year_week_iso \| \| --- \| \| \\| Field label \\| Year & week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Description \\| Year & week (Monday-Sunday) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & week (Mon-Sun) \| \| Description \| Year & week (Monday-Sunday) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| | | campaigns__year_week_iso | | \| Field label \| Year & week (Mon-Sun) \| \| --- \| --- \| \| Description \| Year & week (Monday-Sunday) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweekiso](/apidocs/field-data-types#time) \| | | Field label | Year & week (Mon-Sun) | | Description | Year & week (Monday-Sunday) | | Field type | dimension | | Data type | [string.time.yearweekiso](/apidocs/field-data-types#time) | | \| campaigns__year_week \| \| --- \| \| \\| Field label \\| Year & week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Description \\| Year & week (Sunday-Saturday) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.yearweek](/apidocs/field-data-types#time) \\| \| \| Field label \| Year & week (Sun-Sat) \| \| Description \| Year & week (Sunday-Saturday) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweek](/apidocs/field-data-types#time) \| | | campaigns__year_week | | \| Field label \| Year & week (Sun-Sat) \| \| --- \| --- \| \| Description \| Year & week (Sunday-Saturday) \| \| Field type \| dimension \| \| Data type \| [string.time.yearweek](/apidocs/field-data-types#time) \| | | Field label | Year & week (Sun-Sat) | | Description | Year & week (Sunday-Saturday) | | Field type | dimension | | Data type | [string.time.yearweek](/apidocs/field-data-types#time) | | \| campaigns__week_iso \| \| --- \| \| \\| Field label \\| Week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Description \\| Week (Monday-Sunday) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.weekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Mon-Sun) \| \| Description \| Week (Monday-Sunday) \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| | | campaigns__week_iso | | \| Field label \| Week (Mon-Sun) \| \| --- \| --- \| \| Description \| Week (Monday-Sunday) \| \| Field type \| dimension \| \| Data type \| [string.time.weekiso](/apidocs/field-data-types#time) \| | | Field label | Week (Mon-Sun) | | Description | Week (Monday-Sunday) | | Field type | dimension | | Data type | [string.time.weekiso](/apidocs/field-data-types#time) | | \| campaigns__week \| \| --- \| \| \\| Field label \\| Week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Description \\| Week (Sunday-Saturday) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.week](/apidocs/field-data-types#time) \\| \| \| Field label \| Week (Sun-Sat) \| \| Description \| Week (Sunday-Saturday) \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| | | campaigns__week | | \| Field label \| Week (Sun-Sat) \| \| --- \| --- \| \| Description \| Week (Sunday-Saturday) \| \| Field type \| dimension \| \| Data type \| [string.time.week](/apidocs/field-data-types#time) \| | | Field label | Week (Sun-Sat) | | Description | Week (Sunday-Saturday) | | Field type | dimension | | Data type | [string.time.week](/apidocs/field-data-types#time) | | \| campaigns__day_of_month \| \| --- \| \| \\| Field label \\| Day of month \\| \\| --- \\| --- \\| \\| Description \\| Day of month \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofmonth](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of month \| \| Description \| Day of month \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| | | campaigns__day_of_month | | \| Field label \| Day of month \| \| --- \| --- \| \| Description \| Day of month \| \| Field type \| dimension \| \| Data type \| [string.time.dayofmonth](/apidocs/field-data-types#time) \| | | Field label | Day of month | | Description | Day of month | | Field type | dimension | | Data type | [string.time.dayofmonth](/apidocs/field-data-types#time) | | \| campaigns__day_of_week_name_iso \| \| --- \| \| \\| Field label \\| Day of week (Mon-Sun) \\| \\| --- \\| --- \\| \\| Description \\| Day of week (Monday-Sunday) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweekiso](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Mon-Sun) \| \| Description \| Day of week (Monday-Sunday) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| | | campaigns__day_of_week_name_iso | | \| Field label \| Day of week (Mon-Sun) \| \| --- \| --- \| \| Description \| Day of week (Monday-Sunday) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweekiso](/apidocs/field-data-types#time) \| | | Field label | Day of week (Mon-Sun) | | Description | Day of week (Monday-Sunday) | | Field type | dimension | | Data type | [string.time.dayofweekiso](/apidocs/field-data-types#time) | | \| campaigns__day_of_week_name \| \| --- \| \| \\| Field label \\| Day of week (Sun-Sat) \\| \\| --- \\| --- \\| \\| Description \\| Day of week (Sunday-Saturday) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.dayofweek](/apidocs/field-data-types#time) \\| \| \| Field label \| Day of week (Sun-Sat) \| \| Description \| Day of week (Sunday-Saturday) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| | | campaigns__day_of_week_name | | \| Field label \| Day of week (Sun-Sat) \| \| --- \| --- \| \| Description \| Day of week (Sunday-Saturday) \| \| Field type \| dimension \| \| Data type \| [string.time.dayofweek](/apidocs/field-data-types#time) \| | | Field label | Day of week (Sun-Sat) | | Description | Day of week (Sunday-Saturday) | | Field type | dimension | | Data type | [string.time.dayofweek](/apidocs/field-data-types#time) | | \| campaigns__date \| \| --- \| \| \\| Field label \\| Date \\| \\| --- \\| --- \\| \\| Description \\| Date \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Field label \| Date \| \| Description \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | campaigns__date | | \| Field label \| Date \| \| --- \| --- \| \| Description \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| | | Field label | Date | | Description | Date | | Field type | dimension | | Data type | [string.time.date](/apidocs/field-data-types#time) | | \| campaigns__atom \| \| --- \| \| \\| Field label \\| Datetime \\| \\| --- \\| --- \\| \\| Description \\| Date and time \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Field label \| Datetime \| \| Description \| Date and time \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | campaigns__atom | | \| Field label \| Datetime \| \| --- \| --- \| \| Description \| Date and time \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| | | Field label | Datetime | | Description | Date and time | | Field type | dimension | | Data type | [string.time.datetime](/apidocs/field-data-types#time) | ### CAMPAIGN SUMMARY | \| campaigns__campaign_summary__recipients \| \| --- \| \| \\| Field label \\| Recipients \\| \\| --- \\| --- \\| \\| Description \\| Number of recipients \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Recipients \| \| Description \| Number of recipients \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | --- | | campaigns__campaign_summary__recipients | | \| Field label \| Recipients \| \| --- \| --- \| \| Description \| Number of recipients \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Recipients | | Description | Number of recipients | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaigns__campaign_summary__total_opened \| \| --- \| \| \\| Field label \\| Opens \\| \\| --- \\| --- \\| \\| Description \\| Total number of opened campaigns \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Opens \| \| Description \| Total number of opened campaigns \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaigns__campaign_summary__total_opened | | \| Field label \| Opens \| \| --- \| --- \| \| Description \| Total number of opened campaigns \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Opens | | Description | Total number of opened campaigns | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaigns__campaign_summary__unique_opened \| \| --- \| \| \\| Field label \\| Unique opens \\| \\| --- \\| --- \\| \\| Description \\| Number of unique opened campaigns \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Unique opens \| \| Description \| Number of unique opened campaigns \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaigns__campaign_summary__unique_opened | | \| Field label \| Unique opens \| \| --- \| --- \| \| Description \| Number of unique opened campaigns \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Unique opens | | Description | Number of unique opened campaigns | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaigns__campaign_summary__open_rate \| \| --- \| \| \\| Field label \\| Open rate \\| \\| --- \\| --- \\| \\| Description \\| Percentage of opened campaigns (unique opened / (recipients - bounced)) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| Open rate \| \| Description \| Percentage of opened campaigns (unique opened / (recipients - bounced)) \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | campaigns__campaign_summary__open_rate | | \| Field label \| Open rate \| \| --- \| --- \| \| Description \| Percentage of opened campaigns (unique opened / (recipients - bounced)) \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Field label | Open rate | | Description | Percentage of opened campaigns (unique opened / (recipients - bounced)) | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| campaigns__campaign_summary__clicks \| \| --- \| \| \\| Field label \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| Number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Clicks \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaigns__campaign_summary__clicks | | \| Field label \| Clicks \| \| --- \| --- \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Clicks | | Description | Number of clicks | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaigns__campaign_summary__click_rate \| \| --- \| \| \\| Field label \\| Click rate \\| \\| --- \\| --- \\| \\| Description \\| Percentage of campaign clicks (emails clicked / (recipients - bounced)) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| Click rate \| \| Description \| Percentage of campaign clicks (emails clicked / (recipients - bounced)) \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | campaigns__campaign_summary__click_rate | | \| Field label \| Click rate \| \| --- \| --- \| \| Description \| Percentage of campaign clicks (emails clicked / (recipients - bounced)) \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Field label | Click rate | | Description | Percentage of campaign clicks (emails clicked / (recipients - bounced)) | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| campaigns__campaign_summary__unsubscribed \| \| --- \| \| \\| Field label \\| Unsubscribed \\| \\| --- \\| --- \\| \\| Description \\| Number of unsubscribed campaigns \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Unsubscribed \| \| Description \| Number of unsubscribed campaigns \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaigns__campaign_summary__unsubscribed | | \| Field label \| Unsubscribed \| \| --- \| --- \| \| Description \| Number of unsubscribed campaigns \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Unsubscribed | | Description | Number of unsubscribed campaigns | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaigns__campaign_summary__unsubscribe_rate \| \| --- \| \| \\| Field label \\| Unsubscribe rate \\| \\| --- \\| --- \\| \\| Description \\| Percentage of unsubscribed campaigns ( unsubscribed / (recipients - bounced)) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| Unsubscribe rate \| \| Description \| Percentage of unsubscribed campaigns ( unsubscribed / (recipients - bounced)) \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | campaigns__campaign_summary__unsubscribe_rate | | \| Field label \| Unsubscribe rate \| \| --- \| --- \| \| Description \| Percentage of unsubscribed campaigns ( unsubscribed / (recipients - bounced)) \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Field label | Unsubscribe rate | | Description | Percentage of unsubscribed campaigns ( unsubscribed / (recipients - bounced)) | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| campaigns__campaign_summary__bounced \| \| --- \| \| \\| Field label \\| Bounces \\| \\| --- \\| --- \\| \\| Description \\| Number of bounced campaigns \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Bounces \| \| Description \| Number of bounced campaigns \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaigns__campaign_summary__bounced | | \| Field label \| Bounces \| \| --- \| --- \| \| Description \| Number of bounced campaigns \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Bounces | | Description | Number of bounced campaigns | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaigns__campaign_summary__bounce_rate \| \| --- \| \| \\| Field label \\| Bounce rate \\| \\| --- \\| --- \\| \\| Description \\| Percentage of bounced campaigns (bounced / recipients) \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| Bounce rate \| \| Description \| Percentage of bounced campaigns (bounced / recipients) \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | campaigns__campaign_summary__bounce_rate | | \| Field label \| Bounce rate \| \| --- \| --- \| \| Description \| Percentage of bounced campaigns (bounced / recipients) \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Field label | Bounce rate | | Description | Percentage of bounced campaigns (bounced / recipients) | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| campaigns__campaign_summary__spam_complaints \| \| --- \| \| \\| Field label \\| Spam complaints \\| \\| --- \\| --- \\| \\| Description \\| Number of spam complaints \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Spam complaints \| \| Description \| Number of spam complaints \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaigns__campaign_summary__spam_complaints | | \| Field label \| Spam complaints \| \| --- \| --- \| \| Description \| Number of spam complaints \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Spam complaints | | Description | Number of spam complaints | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaigns__campaign_summary__forwards \| \| --- \| \| \\| Field label \\| Forwards \\| \\| --- \\| --- \\| \\| Description \\| Number of forwarded campaigns \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Forwards \| \| Description \| Number of forwarded campaigns \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaigns__campaign_summary__forwards | | \| Field label \| Forwards \| \| --- \| --- \| \| Description \| Number of forwarded campaigns \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Forwards | | Description | Number of forwarded campaigns | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaigns__campaign_summary__forward_rate \| \| --- \| \| \\| Field label \\| Forward rate (forwards / recipients) \\| \\| --- \\| --- \\| \\| Description \\| Percentage of forwarded campaigns \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Field label \| Forward rate (forwards / recipients) \| \| Description \| Percentage of forwarded campaigns \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | campaigns__campaign_summary__forward_rate | | \| Field label \| Forward rate (forwards / recipients) \| \| --- \| --- \| \| Description \| Percentage of forwarded campaigns \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| | | Field label | Forward rate (forwards / recipients) | | Description | Percentage of forwarded campaigns | | Field type | metric | | Data type | [float.number.ratio](/apidocs/field-data-types#number) | | \| campaigns__campaign_summary__likes \| \| --- \| \| \\| Field label \\| Likes \\| \\| --- \\| --- \\| \\| Description \\| Number of likes \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Likes \| \| Description \| Number of likes \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaigns__campaign_summary__likes | | \| Field label \| Likes \| \| --- \| --- \| \| Description \| Number of likes \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Likes | | Description | Number of likes | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | | \| campaigns__campaign_summary__mentions \| \| --- \| \| \\| Field label \\| Mentions \\| \\| --- \\| --- \\| \\| Description \\| Number of mentions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Field label \| Mentions \| \| Description \| Number of mentions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | campaigns__campaign_summary__mentions | | \| Field label \| Mentions \| \| --- \| --- \| \| Description \| Number of mentions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| | | Field label | Mentions | | Description | Number of mentions | | Field type | metric | | Data type | [int.number.value](/apidocs/field-data-types#number) | ### 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) | ### 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 |