Brevo data warehouse table groups

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

Table: CAMPAIGN

email_campaigns__campaign__ab_testing
Display name A/B testing
Description Status of A/B test for the campaign. False means it is disabled and true means it is enabled
Field type dimension
Data type bool
email_campaigns__campaign__created_at
Display name Created at date-time
Description UTC date-time on which campaign is created
Field type dimension
Data type string.time.datetime
email_campaigns__campaign__exclusion_lists
Display name Exclusion lists
Description Exclusions lists set for the campaign
Field type dimension
Data type string.text.value
email_campaigns__campaign__footer
Display name Campaign footer
Description The footer of the email campaign
Field type dimension
Data type string.text.value
email_campaigns__campaign__header
Display name Campaign header
Description The header of the email campaign
Field type dimension
Data type string.text.value
email_campaigns__campaign__inline_image_activation
Display name Status of inline image
Description Status of inline image. False means image can’t be embedded and true means image can be embedded in the email
Field type dimension
Data type bool
email_campaigns__campaign__mirror_active
Display name Status of mirror links
Description Status of mirror links in campaign. False means mirror links are deactivated and true means mirror links are activated in the campaign
Field type dimension
Data type bool
email_campaigns__campaign__modified_at
Display name Modified at date-time
Description UTC date-time of last modification of the campaign
Field type dimension
Data type string.time.datetime
email_campaigns__campaign__name
Display name Campaign name
Description The name of the email campaign
Field type dimension
Data type string.text.value
email_campaigns__campaign__recipient_lists
Display name Recipient lists
Description Recipient lists the campaign was sent to
Field type dimension
Data type string.text.value
email_campaigns__campaign__recurring
Display name Recurring
Description FOR TRIGGER ONLY ! Type of trigger campaign.recurring = false means contact can receive the same Trigger campaign only once, & recurring = true means contact can receive the same Trigger campaign several times
Field type dimension
Data type bool
email_campaigns__campaign__reply_to
Display name Reply to address
Description The email defined as the reply to address of the campaign
Field type dimension
Data type string.text.value
email_campaigns__campaign__send_at_best_time
Display name Send at best time
Description It is true if you have chosen to send your campaign at best time, otherwise it is false
Field type dimension
Data type bool
email_campaigns__campaign__send_date
Display name Send date
Description Date when the campaign was sent
Field type dimension
Data type string.time.date
email_campaigns__campaign__send_datetime
Display name Send date-time
Description Date and time when the campaign was sent
Field type dimension
Data type string.time.datetime
email_campaigns__campaign__sender_email
Display name Sender email
Description The email address of the sender
Field type dimension
Data type string.text.value
email_campaigns__campaign__sender_id
Display name Sender ID
Description The unique ID of the sender
Field type dimension
Data type string.text.value
email_campaigns__campaign__sender_name
Display name Sender name
Description The name of the sender
Field type dimension
Data type string.text.value
email_campaigns__campaign__split_rule
Display name Split rule
Description The size of your ab-test groups. Only available if abTesting flag of the campaign is true
Field type dimension
Data type int.number.value
email_campaigns__campaign__status
Display name Campaign status
Description The status of the email campaign
Field type dimension
Data type string.text.value
email_campaigns__campaign__subject
Display name Subject
Description The subject of the campaign. Only available if A/B testing flag of the campaign is false
Field type dimension
Data type string.text.value
email_campaigns__campaign__subject_a
Display name Subject A
Description Subject A of the ab-test campaign. Only available if abTesting flag of the campaign is true
Field type dimension
Data type string.text.value
email_campaigns__campaign__subject_b
Display name Subject B
Description Subject B of the ab-test campaign. Only available if abTesting flag of the campaign is true
Field type dimension
Data type string.text.value
email_campaigns__campaign__tag
Display name Tag
Description The tag of the campaign
Field type dimension
Data type string.text.value
email_campaigns__campaign__test_sent
Display name Status of the test email sending
Description Retrieved the status of test email sending. True means that the test email has been sent and false that the test email has not been sent
Field type dimension
Data type bool
email_campaigns__campaign__to_field
Display name To field
Description To field customisation
Field type dimension
Data type string.text.value
email_campaigns__campaign__type
Display name Campaign type
Description The type of the email campaign
Field type dimension
Data type string.text.value
email_campaigns__campaign__winner_criteria
Display name Winner criteria
Description Criteria for the winning version. Only available if abTesting flag of the campaign is true
Field type dimension
Data type string.text.value
email_campaigns__campaign_recipient_list__bounces
Display name Bounces
Description Total number of all bounced emails. Hard bounces + Soft bounces
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__clicks_total
Display name Clicks (total)
Description Total number of clicks on the email
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__clicks_unique
Display name Clicks (unique)
Description Number of unique recipients who clicked the email
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__complaints
Display name Complaints
Description Number of complaints (Spam reports)
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__deferred
Display name Deferred emails
Description Number of deferred emails
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__delivered
Display name Emails delivered
Description Number of emails delivered
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__hard_bounces
Display name Hard bounces
Description Number of hard bounced emails
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__list_id
Display name List ID
Description The unique ID of the recipient list
Field type dimension
Data type string.text.value
email_campaigns__campaign_recipient_list__opens_total
Display name Opens (total)
Description Number of total openings
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__opens_trackable
Display name Opens (trackable)
Description Number of unique opens by recipients without privacy protection enabled
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__opens_unique
Display name Opens (unique)
Description Number of unique openings
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__recipients
Display name Email recipients
Description Number of recipients
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__soft_bounces
Display name Soft bounces
Description Number of soft bounced emails
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__unsubscribes
Display name Unsubscribes
Description Number of users who unsubscribed from this campaign
Field type metric
Data type int.number.value
email_campaigns__id
Display name Campaign ID
Description The unique ID of the email campaign
Field type dimension
Data type string.text.value
email_campaigns__scheduled_at
Display name Scheduled at date-time
Description UTC date-time on which campaign is scheduled
Field type dimension
Data type string.time.datetime