Brevo
Your Brevo email campaigns, SMS, contacts and transactional email data.
The Brevo connector brings your email campaigns, SMS, contacts and transactional email (SMTP) data into the sheet.
Authentication works differently from other connectors: instead of an OAuth login, it uses the API key generated from your Brevo account (Settings > SMTP & API > API Keys).
Only one category per report: Email Campaigns, Contacts, SMS Campaigns and Transactional (SMTP) are four separate data sources: you cannot combine metrics/dimensions from different categories in the same report. The category is shown in parentheses for each entry below.
Included email/SMS campaigns are only those already sent (status "sent").
Metriche disponibili
| Metrica | Periodo | Aggregazione | Note |
|---|---|---|---|
| Sent (emailCampaigns) | |||
| Delivered (emailCampaigns) | |||
| Total Openings (emailCampaigns) | |||
| Unique Openings (emailCampaigns) | |||
| Total Clicks (emailCampaigns) | |||
| Unique Clicks (emailCampaigns) | |||
| Unsubscriptions (emailCampaigns) | |||
| Hard Bounces (emailCampaigns) | |||
| Soft Bounces (emailCampaigns) | |||
| Complaints (emailCampaigns) | |||
| Mirror Views (emailCampaigns) | |||
| Tracked Clicks (emailCampaigns) | |||
| Open Rate (%) (emailCampaigns) | Weighted average (not a direct sum of the row values). | ||
| Click-to-Open Rate (%) (emailCampaigns) | Weighted average (not a direct sum of the row values). | ||
| Delivery Rate (%) (emailCampaigns) | Weighted average (not a direct sum of the row values). | ||
| Unsubscribe Rate (%) (emailCampaigns) | Weighted average (not a direct sum of the row values). | ||
| Bounce Rate (%) (emailCampaigns) | Weighted average (not a direct sum of the row values). | ||
| Total Contacts (contacts) | |||
| Blacklisted Contacts (contacts) | |||
| Removed Contacts (contacts) | |||
| Blacklist Rate (%) (contacts) | Weighted average (not a direct sum of the row values). | ||
| SMTP Requests (transactional) | |||
| SMTP Delivered (transactional) | |||
| SMTP Opens (transactional) | |||
| SMTP Clicks (transactional) | |||
| SMTP Hard Bounces (transactional) | |||
| SMTP Soft Bounces (transactional) | |||
| SMTP Blocked (transactional) | |||
| SMTP Invalid (transactional) | |||
| SMTP Open Rate (%) (transactional) | Weighted average (not a direct sum of the row values). | ||
| SMTP Click-through Rate (%) (transactional) | Weighted average (not a direct sum of the row values). | ||
| SMTP Bounce Rate (%) (transactional) | Weighted average (not a direct sum of the row values). | ||
| SMTP Delivery Rate (%) (transactional) | Weighted average (not a direct sum of the row values). | ||
| SMS Sent (smsCampaigns) | |||
| SMS Delivered (smsCampaigns) | |||
| SMS Clicks (smsCampaigns) | |||
| SMS Hard Bounces (smsCampaigns) | |||
| SMS Soft Bounces (smsCampaigns) | |||
| SMS Delivery Rate (%) (smsCampaigns) | Weighted average (not a direct sum of the row values). | ||
| SMS Click Rate (%) (smsCampaigns) | Weighted average (not a direct sum of the row values). | ||
| SMS Bounce Rate (%) (smsCampaigns) | Weighted average (not a direct sum of the row values). |
Dimensioni disponibili
| Dimensione | Note |
|---|---|
| Campaign Name (emailCampaigns) | |
| Campaign ID (emailCampaigns) | |
| Subject Line (emailCampaigns) | |
| Campaign Status (emailCampaigns) | |
| Date (emailCampaigns) | |
| Year (emailCampaigns) | |
| Month (emailCampaigns) | |
| Sender Name (emailCampaigns) | |
| Sender Email (emailCampaigns) | |
| Ab Testing (emailCampaigns) | |
| List Name (contacts) | |
| List ID (contacts) | |
| Folder ID (contacts) | |
| Email (contacts) | |
| Contact ID (contacts) | |
| Date Added (contacts) | |
| Last Updated (contacts) | |
| First Name (Attr) (contacts) | |
| Last Name (Attr) (contacts) | |
| SMS (Attr) (contacts) | |
| Template ID (transactional) | |
| Event Date (transactional) | |
| Tag (transactional) | |
| Message ID (transactional) | |
| SMS Campaign Name (smsCampaigns) | |
| SMS Campaign ID (smsCampaigns) | |
| SMS Sender (smsCampaigns) | |
| SMS Date (smsCampaigns) |
Limiti noti
- Only already-sent campaignsEmail Campaigns and SMS Campaigns only include those with "sent" status: drafts, scheduled or in-progress campaigns do not appear in reports.
- Max rows per call differs by categoryThe maximum number of rows downloaded in a single call varies by category: 500 for Email/SMS Campaigns, 1,000 for Contacts, 2,500 for Transactional (SMTP).