Omnisend data warehouse table groups

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

Table: ABTEST

Table: AB_TEST

ab_test__ab_test_details__bounces
Display name 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__clicks
Display name 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__complaints
Display name 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__from_name
Display name 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__is_winner
Display name 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__opened
Display name 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__sent
Display name 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__subject
Display name 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__unsubscribes
Display name 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__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
ab_test__end_date
Display name A/B test end date
Description The end date of the A/B test
Field type dimension
Data type string.time.date
ab_test__id
Display name Campaign ID
Description Campaign ID
Field type dimension
Data type string.text.value
ab_test__start_date
Display name A/B test start date
Description The start date of the A/B test
Field type dimension
Data type string.time.date
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

Table: CAMPAIGN

campaign__all_contacts
Display name 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__campaign_details__bounces
Display name Bounces
Description The amount of times the campaign email has bounced
Field type metric
Data type int.number.value
campaign__campaign_details__clicks
Display name Clicks
Description The amount of times the campaign email links have been clicked
Field type metric
Data type int.number.value
campaign__campaign_details__clicks_desktop
Display name 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_mobile
Display name 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_tablet
Display name 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__complaints
Display name Complaints
Description The amount of complaints the campaign has received
Field type metric
Data type int.number.value
campaign__campaign_details__number_of_campaigns
Display name Number of campaigns
Description Total number of campaigns
Field type metric
Data type int.number.value
campaign__campaign_details__opened
Display name Opens
Description The amount of times the campaign email has been opened
Field type metric
Data type int.number.value
campaign__campaign_details__opened_desktop
Display name 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_mobile
Display name 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_tablet
Display name 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__sent
Display name Sends
Description The amount of times the campaign email has been sent
Field type metric
Data type int.number.value
campaign__campaign_details__unsubscribes
Display name Unsubscribes
Description The amount of contacts who have unsubscribed from the campaign
Field type metric
Data type int.number.value
campaign__campaign_id
Display name Campaign ID
Description Campaign_id
Field type dimension
Data type string.text.value
campaign__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign__created_at
Display name Creation date
Description The date when the campaign was created
Field type dimension
Data type string.time.date
campaign__end_date
Display name End date
Description The date when the campaign ended
Field type dimension
Data type string.time.date
campaign__from_name
Display name Sender name
Description Name of the campaign sender
Field type dimension
Data type string.text.value
campaign__segments
Display name Segments
Description The segments the campaign was sent to
Field type dimension
Data type string.text.value
campaign__start_date
Display name Start date
Description The date when the campaign started
Field type dimension
Data type string.time.date
campaign__status
Display name Status
Description The status of the campaign
Field type dimension
Data type string.text.value
campaign__subject
Display name Subject
Description Subject of the campaign
Field type dimension
Data type string.text.value
campaign__type
Display name Type
Description The campaign type
Field type dimension
Data type string.text.value
campaign__updated_at
Display name Last updated date
Description The date when the campaign was last updated
Field type dimension
Data type string.time.date
campaign__url
Display name URL
Description The URL of the campaign
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