Column brevo

brevo_tag: Tag of the brevo transactional email. It allows to identify

brevo_template_id: Brevo template id

brevo_email_id: Brevo email sent id

total_delivered: Count of emails successfully delivered to the recipient.

total_opened: Count of emails opened by the recipient.

total_unsubscribed: Count of recipients who unsubscribed after receiving the email.

email_is_delivered: Boolean. True if the email has been delivered, else False.

email_is_opened: Boolean. True if the email has been opened, else False.

user_has_unsubscribed: Boolean. True if the email encouraged the user to unsubscribe, else False.

first_open_date: Date on which a user of this offerer opened a mail from the campaign (brevo tag) for the first time.

last_open_date: Date on which a user of this offerer opened a mail from the campaign (brevo tag) for the last time.

nb_open_days: Number distinct days on which a user of this offerer opened a mail from the campaign (brevo tag).

first_collective_bookable_date_after_mail: First day on which the offerer has a bookable collective offer after he opened a mail from the campaign (brevo tag).

first_individual_bookable_date_after_mail: First day on which the offerer has a bookable individual offer after he opened a mail from the campaign (brevo tag).