Campaign Monitor data warehouse table groups

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

Table: CAMPAIGN

campaigns__atom
Display name Datetime
Description Date and time
Field type dimension
Data type string.time.datetime
campaigns__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaigns__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaigns__campaign_summary__bounced
Display name Bounces
Description Number of bounced campaigns
Field type metric
Data type int.number.value
campaigns__campaign_summary__clicks
Display name Clicks
Description Number of clicks
Field type metric
Data type int.number.value
campaigns__campaign_summary__forwards
Display name Forwards
Description Number of forwarded campaigns
Field type metric
Data type int.number.value
campaigns__campaign_summary__likes
Display name Likes
Description Number of likes
Field type metric
Data type int.number.value
campaigns__campaign_summary__mentions
Display name Mentions
Description Number of mentions
Field type metric
Data type int.number.value
campaigns__campaign_summary__recipients
Display name Recipients
Description Number of recipients
Field type metric
Data type int.number.value
campaigns__campaign_summary__spam_complaints
Display name Spam complaints
Description Number of spam complaints
Field type metric
Data type int.number.value
campaigns__campaign_summary__total_opened
Display name Opens
Description Total number of opened campaigns
Field type metric
Data type int.number.value
campaigns__campaign_summary__unique_opened
Display name Unique opens
Description Number of unique opened campaigns
Field type metric
Data type int.number.value
campaigns__campaign_summary__unsubscribed
Display name Unsubscribed
Description Number of unsubscribed campaigns
Field type metric
Data type int.number.value
campaigns__from_email
Display name From email
Description From email
Field type dimension
Data type string.text.value
campaigns__from_name
Display name From name
Description From name
Field type dimension
Data type string.text.value
campaigns__reply_to
Display name Reply to
Description Email for replying
Field type dimension
Data type string.text.value
campaigns__subject
Display name Subject
Description Campaign subject
Field type dimension
Data type string.text.value
campaigns__web_version_text_url
Display name Web version text URL
Description Link to the web version in text
Field type dimension
Data type string.text.url
campaigns__web_version_url
Display name Web version URL
Description Link to the web version
Field type dimension
Data type string.text.url
dataSourceName
Display name 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