Brevo
Overview
Lytics Customer Data Platform allows you to use real-time customer activity across various channels to trigger Brevo workflows. Instead of a static, list-based approach to automation workflows, Lytics allows you to create dynamic audience segments that sync with Brevo and update in real-time as customers flow in and out of them. For example, a segment of known visitors with an affinity for a certain topic could trigger an email workflow with targeted messaging.
Authorization
To set up and authorize the Lytics Brevo integration, log into your Lytics account and click on the Data menu tab. Then, click on the Jobs tab. Here, you will see existing jobs and have the option to create a new one.
If you choose to create a new job, you’ll see a list of available integrations organized alphabetically in tiles. Scroll down and click on the Brevo tile.
You will always have two options, to Export Users from Lytics into Brevo or to Import Users & Activity from Brevo. Either option will prompt you to setup the integration if it’s your first time. You should see this setup screen after clicking one of the options:
Click on “Create New Authorization” and you’ll be prompted to enter your a label, an API key, and a short description. You can describe your authorization in any way you like. This can be a useful way to tell multiple integrations apart.
The initial account authorization only needs to be performed one time.
Configure Your Sync:
Now that the account is authorized, you can begin exporting or importing your users.
Exporting Users
In the export scenario, you’ll click on the “Export Audience” button. From there, select the Brevo List that you want to import and the Lytics audience segment that you want to sync them into from the dropdowns. You should also select the Email field. Finally, you'll want to map each Lytics field to a Brevo field.
By default, the advanced options are set to continuously import and to add users who already exist in the selected Lytics segment.
Finally, click on the “Complete” button located below the advanced options section.
Note: You can export segments by clicking on the Brevo tile within the Integration section of the Data menu tab (as demonstrated above). Alternatively, if you are within the Audience tab, you can also click on a specific segment and then click on the export button in the upper righthand corner to begin the export workflow.
Import Users & Activity
In the Import scenario, you’ll click on the “Import Audiences and Activity Data” button. Next, you’ll select the individual Brevo List(s) that you want to import by clicking on them. As you click on a list it moves from the left column to the right column. You can also click on the blue + and - buttons to do this.
By default, campaign activity data and transactional data will be synced.
In the advanced options tab, you can also specify a certain time of day and timezone for the sync.
Finally, click on the “Complete” button located below the advanced options section
Once import has started a new data stream will be created called brevo_users
Fields
The following fields are included in the default mapping of the brevo_users
stream:
Source Field | Lytics User Field | Description | Type |
---|---|---|---|
FIRSTNAME | first_name | First Name | string |
NAME | name | Full Name | string |
SMS | mobile_phone unique id | Mobile Phone Number | string |
blacklist | bv_blacklist | Brevo Email Blacklist | string |
email(EMAIL) | email unique id | Email Address | string |
emaildomain(EMAIL) | email_domain | Email Domain | string |
set(list_id) | bv_lists | Brevo lists the email belongs to | []string |
sms_blacklist | bv_sms_blacklist | Brevo SMS Blacklist | string |
The following fields are included in the default mapping of the brevo_activity
stream:
Source Field | Conditional | Lytics User Field | Description | Type |
---|---|---|---|---|
count(event) | IF eq(event, "click") | bv_clickct | Brevo click count | int |
count(event) | IF eq(event, "opened") | bv_openct | Brevo Open count | int |
count(event) | IF eq(event, "delivery") | bv_sendct | Brevo Send Count | int |
email(email) | email unique id | Email Address | string | |
emaildomain(email) | email_domain | Email Domain | string | |
max(epochms()) | IF eq(event, "click") | bv_lastclick_ts | Brevo Last click | date |
max(epochms()) | IF eq(event, "opened") | bv_lastopen_ts | Brevo Last Open | date |
max(epochms()) | IF eq(event, "unsubscribed") OR eq(event, "unsubscribe") | bv_unsub_ts | Brevo Unsub date | number |
max(epochms()) | IF eq(event, "opened") | last_active_ts | Last Active | date |
min(epochms()) | IF eq(event, "click") | bv_firstclick_ts | Brevo First click | date |
min(epochms()) | IF eq(event, "opened") | bv_firstopen_ts | Brevo First Open | date |
reason | IF eq(event, "unsubscribed") OR eq(event, "unsubscribe") | bv_unsubreason | Brevo Unsubscribe Reason | string |
set(camp_id) | bv_campaigns | Brevo Campaign the send was a part of | []string | |
set(custom) | bv_custom_tags | Brevo X-mailing custom | []string | |
set(list_id) | bv_lists | Brevo lists the email belongs to | []string | |
set(message_id) | bv_messages | Brevo Message Id | []string | |
set(tag) | bv_tags | Brevo Email Tag | []string | |
url | bv_email_url | Brevo Url | string | |
valuect(event) | bv_email_event | Brevo Email Events | map[string]intsum | |
valuect(hash(urlmain(url))) | IF eq(event, "click") | hashedurls | Hashed Urls Visited | map[string]intsum |
valuect(hourofday()) | IF eq(event, "opened") | bv_hourlyopen | Brevo Hourly Events | map[string]intsum |
valuect(hourofweek()) | IF eq(event, "opened") | bv_hourofweek | Brevo Hour of Week Events | map[string]intsum |
valuect(yymm()) | IF eq(event, "opened") | bv_monthly | Brevo Opens By Month | map[string]intsum |
The following fields are included in the default mapping of the brevo_sms_activity
stream:
Source Field | Conditional | Lytics User Field | Description | Type |
---|---|---|---|---|
count(event) | IF eq(event, "blocked") | bv_sms_blockedct | Brevo Blocked Count | int |
count(event) | IF event IN ("softBounces", "hardBounces", "bounces") | bv_sms_bouncedct | Brevo Bounced Count | int |
count(event) | IF eq(event, "delivered") | bv_sms_deliveredct | Brevo Delivered Count | int |
count(event) | IF eq(event, "replies") | bv_sms_replyct | Brevo Reply Count | int |
count(event) | IF eq(event, "sent") | bv_sms_sentct | Brevo SMS Sent Count | int |
count(event) | IF eq(event, "unsubscription") | bv_sms_unsubct | Brevo Unsub Count | int |
event | bv_sms_last_event | Brevo Last SMS Event | string | |
max(epochms()) | IF eq(event, "blocked") | bv_sms_lastblocked_ts | Brevo Last SMS Blocked | date |
max(epochms()) | IF event IN ("softBounces", "hardBounces", "bounces") | bv_sms_lastbounced_ts | Brevo Last SMS Bounced | date |
max(epochms()) | IF eq(event, "delivered") | bv_sms_lastdelivered_ts | Brevo Last SMS Delivered | date |
max(epochms()) | IF eq(event, "replies") | bv_sms_lastreply_ts | Brevo Last SMS Reply | date |
max(epochms()) | IF eq(event, "sent") | bv_sms_lastsent_ts | Brevo Last SMS Sent | date |
max(epochms()) | IF eq(event, "unsubscription") | bv_sms_lastunsub_ts | Brevo Last SMS Unsub | date |
min(epochms()) | IF eq(event, "blocked") | bv_sms_firstblocked_ts | Brevo First SMS Blocked | date |
min(epochms()) | IF event IN ("softBounces", "hardBounces", "bounces") | bv_sms_firstbounced_ts | Brevo First SMS Bounced | date |
min(epochms()) | IF eq(event, "delivered") | bv_sms_firstdelivered_ts | Brevo First SMS Delivered | date |
min(epochms()) | IF eq(event, "replies") | bv_sms_firstreply_ts | Brevo First SMS Reply | date |
min(epochms()) | IF eq(event, "sent") | bv_sms_firstsent_ts | Brevo First SMS Sent | date |
min(epochms()) | IF eq(event, "unsubscription") | bv_sms_firstunsub_ts | Brevo First SMS Unsub | date |
phoneNumber | bv_mobile_phone unique id | Brevo Mobile Phone Number | string | |
reason | IF event IN ("softBounces", "hardBounces", "bounces") | bv_sms_bounce_reason | Brevo Bounce Reason | string |
set(messageId) | bv_messages | Brevo Message Id | []string | |
valuect(event) | bv_sms_event | Brevo SMS Events | map[string]intsum |
Updated 11 months ago