Introduction

Datasources and destinations

Fields listing for Brevo (ex SendInBlue)

Campaign Id
Get the Campaign ID.
Field IDcampaign/id
TypeNUMBER
Data Typedimension
Campaign Name
Get the Campaign Name.
Field IDcampaign/name
TypeTEXT
Data Typedimension
Campaign Type
Get the Campaign Type.
Field IDcampaign/type
TypeTEXT
Data Typedimension
Campaign Status
Get the Campaign Status.
Field IDcampaign/status
TypeTEXT
Data Typedimension
Campaign Test Status
Get the Campaign Test Status.
Field IDcampaign/testSent
TypeBOOLEAN
Data Typedimension
Campaign Header
Get the Campaign Header.
Field IDcampaign/header
TypeTEXT
Data Typedimension
Campaign Footer
Get the Campaign Footer.
Field IDcampaign/footer
TypeTEXT
Data Typedimension
Campaign Sender Name
Get the Campaign Sender Name.
Field IDcampaign/sender_name
TypeTEXT
Data Typedimension
Campaign Sender ID
Get the Campaign Sender ID.
Field IDcampaign/sender_id
TypeNUMBER
Data Typedimension
Campaign Sender Email
Get the Campaign Sender Email.
Field IDcampaign/sender_email
TypeTEXT
Data Typedimension
Campaign Reply To
Get the Campaign Reply To.
Field IDcampaign/replyTo
TypeTEXT
Data Typedimension
Campaign To Field
Get the Campaign To Field.
Field IDcampaign/toField
TypeTEXT
Data Typedimension
Campaign Preview Text
Get the Campaign Preview Text.
Field IDcampaign/previewText
TypeTEXT
Data Typedimension
Campaign Tags
Get the Campaign Tags.
Field IDcampaign/tag
TypeTEXT
Data Typedimension
Campaign Inline Activation Image
Get the Inline Activation Image.
Field IDcampaign/inlineImageActivation
TypeBOOLEAN
Data Typedimension
Campaign Mirror Active
Get the Mirror Active status.
Field IDcampaign/mirrorActive
TypeBOOLEAN
Data Typedimension
Campaign HTML Content
Get the HTML Content.
Field IDcampaign/htmlContent
TypeTEXT
Data Typedimension
Campaign Subject
Get the campaign Subject.
Field IDcampaign/subject
TypeTEXT
Data Typedimension
Campaign Share Link
Get the campaign Share Link.
Field IDcampaign/shareLink
TypeTEXT
Data Typedimension
Campaign Scheduled At
Get the campaign scheduled at.
Field IDcampaign/scheduledAt
TypeYEAR_MONTH_DAY
Data Typedimension
Campaign Created At
Get the campaign created at.
Field IDcampaign/createdAt
TypeYEAR_MONTH_DAY
Data Typedimension
Campaign Modified At
Get the campaign modified at.
Field IDcampaign/modifiedAt
TypeYEAR_MONTH_DAY
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Total Clicks
Get the total clicks.
Field IDuniqueClicks
TypeNUMBER
Data Typemetric
Complaints
Get the total complaints.
Field IDcomplaints
TypeNUMBER
Data Typemetric
Delivered
Get the total delivered email.
Field IDdelivered
TypeNUMBER
Data Typemetric
Sent
Get the total sent email.
Field IDsent
TypeNUMBER
Data Typemetric
Soft Bounces
Get the total soft bounces email.
Field IDsoftBounces
TypeNUMBER
Data Typemetric
Hard Bounces
Get the total hard bounces email.
Field IDhardBounces
TypeNUMBER
Data Typemetric
Unique Views
Get the total uniques views.
Field IDuniqueViews
TypeNUMBER
Data Typemetric
Unsubscriptions
Get the total unsubscriptions.
Field IDunsubscriptions
TypeNUMBER
Data Typemetric
Viewed
Get the total viewed.
Field IDviewed
TypeNUMBER
Data Typemetric
Trackable Views
Get the total trackable views.
Field IDtrackableViews
TypeNUMBER
Data Typemetric
Estimated Views
Get the total estimated views.
Field IDestimatedViews
TypeNUMBER
Data Typemetric
Trackable Views Rate
Get the Trackable Views Rate.
Field IDtrackableViewsRate
TypeNUMBER
Data Typemetric
List ID
Get the list ID.
Field IDlist/id
TypeNUMBER
Data Typedimension
List Name
Get the list name.
Field IDlist/name
TypeTEXT
Data Typedimension
List Total Blacklisted
Get the list total blacklisted.
Field IDlist/totalBlacklisted
TypeNUMBER
Data Typedimension
List Total Subscriber
Get the list total subscriber.
Field IDlist/totalSubscribers
TypeNUMBER
Data Typedimension
List Unique Subscribers
Get the list unique subscriber.
Field IDlist/uniqueSubscribers
TypeNUMBER
Data Typedimension
Campaign Sent Date
Get the campaign sent Date.
Field IDcampaign/sentDate
TypeYEAR_MONTH_DAY
Data Typedimension
Campaign Sent Time
Get the campaign sent time.
Field IDcampaign/sentTime
TypeYEAR_MONTH_DAY
Data Typedimension
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
TypeWEEK
Data Typedimension
Segment ID
Get the Segment ID.
Field IDsegment/id
TypeNUMBER
Data Typedimension
Segment Name
Get the Segment Name.
Field IDsegment/segmentName
TypeTEXT
Data Typedimension
Segment Category Name
Get the Segment Category Name.
Field IDsegment/categoryName
TypeTEXT
Data Typedimension
Segment Updated At
Field IDsegment/updatedAt
TypeYEAR_MONTH_DAY
Data Typedimension
Contact ID
Get the Contact ID.
Field IDcontact/id
TypeNUMBER
Data Typedimension
Contact Has Email Blacklisted
Is email blacklisted for this contact.
Field IDcontact/emailBlacklisted
TypeBOOLEAN
Data Typedimension
Contact Has SMS Blacklisted
Is SMS Blacklisted for the contact.
Field IDcontact/smsBlacklisted
TypeBOOLEAN
Data Typedimension
Contact Email
Get the Contact email.
Field IDcontact/email
TypeTEXT
Data Typedimension
Contact Created At
The date of creation of this contact.
Field IDcontact/createdAt
TypeYEAR_MONTH_DAY
Data Typedimension
Contact Modified At
The last date of modification for this contact.
Field IDcontact/modifiedAt
TypeYEAR_MONTH_DAY
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension