Campaign Monitor fields

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Campaign Monitor data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

15 metrics32 dimensions

CAMPAIGN

campaigns__campaign_id
Field label Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaigns__campaign_name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaigns__from_name
Field label From name
Description From name
Field type dimension
Data type string.text.value
campaigns__from_email
Field label From email
Description From email
Field type dimension
Data type string.text.value
campaigns__subject
Field label Subject
Description Campaign subject
Field type dimension
Data type string.text.value
campaigns__reply_to
Field label Reply to
Description Email for replying
Field type dimension
Data type string.text.value
campaigns__web_version_url
Field label Web version URL
Description Link to the web version
Field type dimension
Data type string.text.url
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

CAMPAIGN SENT TIME

campaigns__year
Field label Year
Description Year
Field type dimension
Data type string.time.year
campaigns__year_month
Field label Year & month
Description Year & month
Field type dimension
Data type string.time.yearmonth
campaigns__month
Field label Month
Description Month
Field type dimension
Data type string.time.month
campaigns__year_week_iso
Field label Year & week (Mon-Sun)
Description Year & week (Monday-Sunday)
Field type dimension
Data type string.time.yearweekiso
campaigns__year_week
Field label Year & week (Sun-Sat)
Description Year & week (Sunday-Saturday)
Field type dimension
Data type string.time.yearweek
campaigns__week_iso
Field label Week (Mon-Sun)
Description Week (Monday-Sunday)
Field type dimension
Data type string.time.weekiso
campaigns__week
Field label Week (Sun-Sat)
Description Week (Sunday-Saturday)
Field type dimension
Data type string.time.week
campaigns__day_of_month
Field label Day of month
Description Day of month
Field type dimension
Data type string.time.dayofmonth
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
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
campaigns__date
Field label Date
Description Date
Field type dimension
Data type string.time.date
campaigns__atom
Field label Datetime
Description Date and time
Field type dimension
Data type string.time.datetime

CAMPAIGN SUMMARY

campaigns__campaign_summary__recipients
Field label Recipients
Description Number of recipients
Field type metric
Data type int.number.value
campaigns__campaign_summary__total_opened
Field label Opens
Description Total number of opened campaigns
Field type metric
Data type int.number.value
campaigns__campaign_summary__unique_opened
Field label Unique opens
Description Number of unique opened campaigns
Field type metric
Data type int.number.value
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
campaigns__campaign_summary__clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
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
campaigns__campaign_summary__unsubscribed
Field label Unsubscribed
Description Number of unsubscribed campaigns
Field type metric
Data type int.number.value
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
campaigns__campaign_summary__bounced
Field label Bounces
Description Number of bounced campaigns
Field type metric
Data type int.number.value
campaigns__campaign_summary__bounce_rate
Field label Bounce rate
Description Percentage of bounced campaigns (bounced / recipients)
Field type metric
Data type float.number.ratio
campaigns__campaign_summary__spam_complaints
Field label Spam complaints
Description Number of spam complaints
Field type metric
Data type int.number.value
campaigns__campaign_summary__forwards
Field label Forwards
Description Number of forwarded campaigns
Field type metric
Data type int.number.value
campaigns__campaign_summary__forward_rate
Field label Forward rate (forwards / recipients)
Description Percentage of forwarded campaigns
Field type metric
Data type float.number.ratio
campaigns__campaign_summary__likes
Field label Likes
Description Number of likes
Field type metric
Data type int.number.value
campaigns__campaign_summary__mentions
Field label Mentions
Description Number of mentions
Field type metric
Data type int.number.value

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse