Prerequisites
Before connecting Brevo to QUANTI, ensure you have:
Brevo Account: An active Brevo (formerly Sendinblue) account
API Access: Access to the API Keys section in your Brevo account settings
Email Campaigns: At least some email campaigns created to retrieve insights
Proper Permissions: Email Campaigns and Contacts read permissions
Setup Instructions
Create API Key
Log in to your Brevo account at https://app.brevo.com/
Navigate to Settings → API Keys
Click on Create a new API key
Give your key a descriptive name (e.g., "QUANTI Integration")
Copy the API key immediately (it will only be shown once)
Store it securely
Configure Authentication
Return to QUANTI
Click on Connect to Brevo
Enter your API key in the authentication field
Click Validate to test the connection
QUANTI will verify your credentials and permissions
Select Pre-built Tables
Review the available pre-built tables (see section below for details)
Select the tables you want to synchronize:
Campaigns: Campaign dimensions and configuration
Campaign Stats: Global campaign metrics
Campaign Lists Stats: Campaign metrics by contact list
Contact Lists: Lists metadata
Contacts: Individual contacts and attributes
Click Next
Finish Setup
Define a sync period and a lookback window
Click Save
For the first sync, you have the following options:
Activate auto-sync for recurring syncs based on your sync settings by clicking the switch button
Launch a historical data recovery by choosing your desired dates in the historical data tab
Launch a manual sync immediately by clicking the Sync now button
Wait for the sync to complete
Navigate to your data warehouse to verify that tables are populated
Check the connector dashboard for sync status and any potential errors
Pre-built Tables
Campaigns: Email campaign dimensions including configuration, sender details, A/B testing setup, and UTM parameters
Campaign Stats: Global aggregated performance metrics for campaigns (all lists combined)
Campaign Lists Stats: Campaign performance metrics decomposed by recipient list with detailed list-level analysis
Contact Lists: Metadata about contact lists including names, folder organization, and list type
Contacts: Individual contacts with email addresses, subscription status, list memberships, and custom attributes
Notes
Data Refresh: Brevo data can be synced multiple times per day. Configure your sync frequency based on your campaign sending schedule
Rate Limits: Brevo enforces a rate limit of 600 requests per 10 minutes. QUANTI automatically manages these limits to ensure reliable data extraction
Historical Data: All historical campaign data is accessible via the API. Use the historical data recovery feature for initial backload
Incremental Sync: The Contacts table supports incremental synchronization using the
modifiedSinceparameter to fetch only updated contactsA/B Testing: Campaign dimensions include complete A/B testing configuration (subjects, split rule, winner criteria)
Custom Attributes: Contact attributes vary by account configuration and are stored as JSON for flexibility
Deferred Emails: The
deferredmetric is only available in Campaign Lists Stats, not in Campaign StatsList Relationships: Contact list memberships are stored within the Contacts table as JSON arrays, making separate junction tables unnecessary
Deprecated Fields: Some API fields (totalBlacklisted, totalSubscribers, uniqueSubscribers) are deprecated by Brevo and not collected
Troubleshooting
Authentication Issues
Authentication Issues
Verify that your API key is correct and hasn't been revoked
Ensure your API key has the required permissions (Email Campaigns and Contacts read access)
Check that your Brevo account is active and not suspended
Generate a new API key if the current one doesn't work
Missing Campaign Data
Missing Campaign Data
Only sent campaigns appear in the statistics tables
Draft, archived, or deleted campaigns may not have complete metrics
Ensure campaigns were sent after your configured lookback window
Check campaign status in the Campaigns dimension table
Rate Limit Errors
Rate Limit Errors
QUANTI automatically handles rate limiting with exponential backoff
If you encounter persistent rate limit issues, consider:
Reducing the number of pre-built tables selected
Increasing the sync interval
Contacting Brevo support to verify your account's rate limits
Missing Contacts
Missing Contacts
Verify that contacts exist in your Brevo account
Check if contacts are in lists that were included in your sync configuration
For incremental syncs, only modified contacts are retrieved
Blacklisted contacts are included but marked with appropriate flags