Omnisend fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

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

35 metrics66 dimensions

A/B TEST DETAILS

ab_test__id
Field label Campaign ID
Description Campaign ID
Field type dimension
Data type string.text.value
ab_test__campaign_name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
ab_test__start_date
Field label A/B test start date
Description The start date of the A/B test
Field type dimension
Data type string.time.date
ab_test__start_datetime
Field label A/B test start datetime
Description The start datetime of the A/B test
Field type dimension
Data type string.time.datetime
ab_test__end_date
Field label A/B test end date
Description The end date of the A/B test
Field type dimension
Data type string.time.date
ab_test__end_datetime
Field label A/B test end datetime
Description The end datetime of the A/B test
Field type dimension
Data type string.time.datetime
ab_test__ab_test_details__from_name
Field label A/B test sender name
Description The name of the sender of the A/B test
Field type dimension
Data type string.text.value
ab_test__ab_test_details__subject
Field label A/B test subject
Description The subject of the A/B test
Field type dimension
Data type string.text.value
ab_test__ab_test_details__is_winner
Field label Is the winning A/B test
Description Whether or not this is the winning A/B test variant
Field type dimension
Data type bool
ab_test__ab_test_details__sent
Field label A/B test sends
Description The amount of times the A/B test email has been sent
Field type metric
Data type int.number.value
ab_test__ab_test_details__opened
Field label A/B test opens
Description The amount of times the A/B test email has been opened
Field type metric
Data type int.number.value
ab_test__ab_test_details__open_rate
Field label A/B test open rate
Description The amount of opened emails divided by the amount sent
Field type metric
Data type float.number.ratio
ab_test__ab_test_details__clicks
Field label A/B test clicks
Description The amount of times the A/B test email links have been clicked
Field type metric
Data type int.number.value
ab_test__ab_test_details__click_rate
Field label A/B test click rate
Description The amount of link clicks divided by the amount sent
Field type metric
Data type float.number.ratio
ab_test__ab_test_details__bounces
Field label A/B test bounces
Description The amount of times the A/B test email has bounced
Field type metric
Data type int.number.value
ab_test__ab_test_details__bounce_rate
Field label A/B test bounce rate
Description The amount of bounces divided by the amount sent
Field type metric
Data type float.number.ratio
ab_test__ab_test_details__complaints
Field label A/B test complaints
Description The amount of complaints the A/B test has received
Field type metric
Data type int.number.value
ab_test__ab_test_details__complaint_rate
Field label A/B test complaint rate
Description The amount of complaints divided by the amount sent
Field type metric
Data type float.number.ratio
ab_test__ab_test_details__unsubscribes
Field label A/B test unsubscribes
Description The amount of contacts who have unsubscribed from the A/B test
Field type metric
Data type int.number.value
ab_test__ab_test_details__unsubscribe_rate
Field label A/B test unsubscribe rate
Description The amount of unsubscribed contacts divided by the amount sent
Field type metric
Data type float.number.ratio

CAMPAIGN

campaign__campaign_id
Field label Campaign ID
Description Campaign_id
Field type dimension
Data type string.text.value
campaign__campaign_name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign__subject
Field label Subject
Description Subject of the campaign
Field type dimension
Data type string.text.value
campaign__from_name
Field label Sender name
Description Name of the campaign sender
Field type dimension
Data type string.text.value
campaign__type
Field label Type
Description The campaign type
Field type dimension
Data type string.text.value
campaign__status
Field label Status
Description The status of the campaign
Field type dimension
Data type string.text.value
campaign__url
Field label URL
Description The URL of the campaign
Field type dimension
Data type string.text.url
campaign__all_contacts
Field label Sent to all subscribers
Description Whether or not the campaign was sent to all subscribers instead of specific segments
Field type dimension
Data type bool
campaign__segments
Field label Segments
Description The segments the campaign was sent to
Field type dimension
Data type string.text.value
campaign__created_at
Field label Creation date
Description The date when the campaign was created
Field type dimension
Data type string.time.date
campaign__created_at_datetime
Field label Creation datetime
Description The datetime when the campaign was created
Field type dimension
Data type string.time.datetime
campaign__updated_at
Field label Last updated date
Description The date when the campaign was last updated
Field type dimension
Data type string.time.date
campaign__updated_at_datetime
Field label Last updated datetime
Description The datetime when the campaign was last updated
Field type dimension
Data type string.time.datetime
campaign__start_date
Field label Start date
Description The date when the campaign started
Field type dimension
Data type string.time.date
campaign__start_datetime
Field label Start datetime
Description The datetime when the campaign started
Field type dimension
Data type string.time.datetime
campaign__end_date
Field label End date
Description The date when the campaign ended
Field type dimension
Data type string.time.date
campaign__end_datetime
Field label End datetime
Description The datetime when the campaign ended
Field type dimension
Data type string.time.datetime
campaign__campaign_details__sent
Field label Sends
Description The amount of times the campaign email has been sent
Field type metric
Data type int.number.value
campaign__campaign_details__opened
Field label Opens
Description The amount of times the campaign email has been opened
Field type metric
Data type int.number.value
campaign__campaign_details__open_rate
Field label Open rate
Description The amount of opened emails divided by the amount sent
Field type metric
Data type float.number.ratio
campaign__campaign_details__clicks
Field label Clicks
Description The amount of times the campaign email links have been clicked
Field type metric
Data type int.number.value
campaign__campaign_details__click_rate
Field label Click rate
Description The amount of link clicks divided by the amount sent
Field type metric
Data type float.number.ratio
campaign__campaign_details__bounces
Field label Bounces
Description The amount of times the campaign email has bounced
Field type metric
Data type int.number.value
campaign__campaign_details__bounce_rate
Field label Bounce rate
Description The amount of bounces divided by the amount sent
Field type metric
Data type float.number.ratio
campaign__campaign_details__complaints
Field label Complaints
Description The amount of complaints the campaign has received
Field type metric
Data type int.number.value
campaign__campaign_details__complaint_rate
Field label Complaint rate
Description The amount of complaints divided by the amount sent
Field type metric
Data type float.number.ratio
campaign__campaign_details__unsubscribes
Field label Unsubscribes
Description The amount of contacts who have unsubscribed from the campaign
Field type metric
Data type int.number.value
campaign__campaign_details__unsubscribe_rate
Field label Unsubscribe rate
Description The amount of unsubscribed contacts divided by the amount sent
Field type metric
Data type float.number.ratio
campaign__campaign_details__number_of_campaigns
Field label Number of campaigns
Description Total number of campaigns
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

DEVICE BREAKDOWN

campaign__campaign_details__opened_mobile
Field label Opens (mobile)
Description The amount of times the campaign email has been opened on mobile devices
Field type metric
Data type int.number.value
campaign__campaign_details__opened_desktop
Field label Opens (desktop)
Description The amount of times the campaign email has been opened on desktop devices
Field type metric
Data type int.number.value
campaign__campaign_details__opened_tablet
Field label Opens (tablet)
Description The amount of times the campaign email has been opened on tablet devices
Field type metric
Data type int.number.value
campaign__campaign_details__open_rate_mobile
Field label Open rate (mobile)
Description The amount of opened emails on mobile devices divided by the amount sent
Field type metric
Data type float.number.ratio
campaign__campaign_details__open_rate_desktop
Field label Open rate (desktop)
Description The amount of opened emails on desktop devices divided by the amount sent
Field type metric
Data type float.number.ratio
campaign__campaign_details__open_rate_tablet
Field label Open rate (tablet)
Description The amount of opened emails on tablet devices divided by the amount sent
Field type metric
Data type float.number.ratio
campaign__campaign_details__clicks_mobile
Field label Clicks (mobile)
Description The amount of times the campaign email links have been clicked on mobile devices
Field type metric
Data type int.number.value
campaign__campaign_details__clicks_desktop
Field label Clicks (desktop)
Description The amount of times the campaign email links have been clicked on desktop devices
Field type metric
Data type int.number.value
campaign__campaign_details__clicks_tablet
Field label Clicks (tablet)
Description The amount of times the campaign email links have been clicked on tablet devices
Field type metric
Data type int.number.value
campaign__campaign_details__click_rate_mobile
Field label Click rate (mobile)
Description The amount of link clicks on mobile devices divided by the amount sent
Field type metric
Data type float.number.ratio
campaign__campaign_details__click_rate_desktop
Field label Click rate (desktop)
Description The amount of link clicks on desktop devices divided by the amount sent
Field type metric
Data type float.number.ratio
campaign__campaign_details__click_rate_tablet
Field label Click rate (tablet)
Description The amount of link clicks on tablet devices divided by the amount sent
Field type metric
Data type float.number.ratio

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
campaign__year
Field label Year
Field type dimension
Data type string.time.year
campaign__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
campaign__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
campaign__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
campaign__month
Field label Month
Field type dimension
Data type string.time.month
campaign__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
campaign__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
campaign__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
campaign__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
campaign__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
campaign__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
campaign__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
campaign__date
Field label Date
Field type dimension
Data type string.time.date
campaign__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
ab_test__year
Field label Year
Field type dimension
Data type string.time.year
ab_test__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
ab_test__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
ab_test__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
ab_test__month
Field label Month
Field type dimension
Data type string.time.month
ab_test__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
ab_test__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
ab_test__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
ab_test__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
ab_test__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
ab_test__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
ab_test__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
ab_test__date
Field label Date
Field type dimension
Data type string.time.date
ab_test__atom
Field label Datetime
Field type dimension
Data type string.time.datetime