Brevo fields

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

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

19 metrics58 dimensions

A/B TEST

email_campaigns__campaign__ab_testing
Field label 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__subject_a
Field label 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
Field label 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__split_rule
Field label 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__winner_criteria
Field label 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

CONTENT

email_campaigns__campaign__sender_id
Field label Sender ID
Description The unique ID of the sender
Field type dimension
Data type string.text.value
email_campaigns__campaign__sender_name
Field label Sender name
Description The name of the sender
Field type dimension
Data type string.text.value
email_campaigns__campaign__sender_email
Field label Sender email
Description The email address of the sender
Field type dimension
Data type string.text.value
email_campaigns__campaign__subject
Field label 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__reply_to
Field label 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__to_field
Field label To field
Description To field customisation
Field type dimension
Data type string.text.value
email_campaigns__campaign__header
Field label Campaign header
Description The header of the email campaign
Field type dimension
Data type string.text.value
email_campaigns__campaign__footer
Field label Campaign footer
Description The footer of the email campaign
Field type dimension
Data type string.text.value
email_campaigns__campaign__inline_image_activation
Field label 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
Field label 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__share_link
Field label Share link
Description Link to share the campaign on social medias
Field type dimension
Data type string.text.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

EMAIL CAMPAIGNS

email_campaigns__id
Field label Campaign ID
Description The unique ID of the email campaign
Field type dimension
Data type string.text.value
email_campaigns__scheduled_at
Field label Scheduled at date-time
Description UTC date-time on which campaign is scheduled
Field type dimension
Data type string.time.datetime
email_campaigns__campaign__name
Field label Campaign name
Description The name of the email campaign
Field type dimension
Data type string.text.value
email_campaigns__campaign__status
Field label Campaign status
Description The status of the email campaign
Field type dimension
Data type string.text.value
email_campaigns__campaign__type
Field label Campaign type
Description The type of the email campaign
Field type dimension
Data type string.text.value
email_campaigns__campaign__send_date
Field label Send date
Description Date when the campaign was sent
Field type dimension
Data type string.time.date
email_campaigns__campaign__send_datetime
Field label Send date-time
Description Date and time when the campaign was sent
Field type dimension
Data type string.time.datetime
email_campaigns__campaign__send_at_best_time
Field label 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__created_at
Field label Created at date-time
Description UTC date-time on which campaign is created
Field type dimension
Data type string.time.datetime
email_campaigns__campaign__modified_at
Field label 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__tag
Field label Tag
Description The tag of the campaign
Field type dimension
Data type string.text.value
email_campaigns__campaign__test_sent
Field label 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__recurring
Field label 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_recipient_list__list_id
Field label List ID
Description The unique ID of the recipient list
Field type dimension
Data type string.text.value
email_campaigns__campaign_recipient_list__recipients
Field label Email recipients
Description Number of recipients
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__delivered
Field label Emails delivered
Description Number of emails delivered
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__list_delivery_rate
Field label Delivery rate
Description Delivery rate. Emails delivered / Email recipients
Field type metric
Data type float.number.ratio
email_campaigns__campaign_recipient_list__opens_unique
Field label Opens (unique)
Description Number of unique openings
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__opens_trackable
Field label 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_total
Field label Opens (total)
Description Number of total openings
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__open_rate
Field label Open rate
Description Open rate. Number of email opened / Number of email delivered
Field type metric
Data type float.number.ratio
email_campaigns__campaign_recipient_list__clicks_unique
Field label Clicks (unique)
Description Number of unique recipients who clicked the email
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__clicks_total
Field label Clicks (total)
Description Total number of clicks on the email
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__click_rate
Field label Click rate
Description Click rate. Clicks (unique) / Emails delivered
Field type metric
Data type float.number.ratio
email_campaigns__campaign_recipient_list__click_to_open_rate
Field label Click-to-open rate
Description Rate of openers who clicked the emall. Clicks (unique) / Opens (trackable)
Field type metric
Data type float.number.ratio
email_campaigns__campaign_recipient_list__soft_bounces
Field label Soft bounces
Description Number of soft bounced emails
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__hard_bounces
Field label Hard bounces
Description Number of hard bounced emails
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__bounces
Field label 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__unsubscribes
Field label Unsubscribes
Description Number of users who unsubscribed from this campaign
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__unsubscribe_rate
Field label Unsubscribe rate
Description Unsubscribe rate. Unsubscribes / Emails delivered
Field type metric
Data type float.number.ratio
email_campaigns__campaign_recipient_list__complaints
Field label Complaints
Description Number of complaints (Spam reports)
Field type metric
Data type int.number.value
email_campaigns__campaign_recipient_list__complaint_rate
Field label Complaint rate
Description Complaint rate. Complaints / Emails delivered
Field type metric
Data type float.number.ratio
email_campaigns__campaign_recipient_list__deferred
Field label Deferred emails
Description Number of deferred emails
Field type metric
Data type int.number.value

LIST

email_campaigns__campaign__recipient_lists
Field label Recipient lists
Description Recipient lists the campaign was sent to
Field type dimension
Data type string.text.value
email_campaigns__campaign__exclusion_lists
Field label Exclusion lists
Description Exclusions lists set for the campaign
Field type dimension
Data type string.text.value

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
email_campaigns__year
Field label Year
Field type dimension
Data type string.time.year
email_campaigns__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
email_campaigns__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
email_campaigns__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
email_campaigns__month
Field label Month
Field type dimension
Data type string.time.month
email_campaigns__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
email_campaigns__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
email_campaigns__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
email_campaigns__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
email_campaigns__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
email_campaigns__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
email_campaigns__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
email_campaigns__date
Field label Date
Field type dimension
Data type string.time.date
email_campaigns__atom
Field label Datetime
Field type dimension
Data type string.time.datetime