Brevo Data Connector User Guide

Brevo Data Connector User Guide

Info
Get valuable insights into your email marketing and campaign performance by connecting your Brevo account to Power My Analytics. This guide will walk you through setup, reporting capabilities, and important considerations.

Prerequisites

Before connecting Brevo to Power My Analytics, ensure you have:
  • Created an API key for Power My Analytics in the SMTP & API > API Keys section of your Brevo dashboard
  • Configured your Brevo IP authorization settings to allow API requests from Power My Analytics (see IP Authorization Settings below)

Creating an API Key in Brevo

To generate an API key for Power My Analytics in your Brevo dashboard, follow these steps:
  1. Log in to your Brevo account and click on your account name in the upper right.
  2. Choose SMTP & API, then click on the API keys tab.
  3. Click Create a new API key and enter a name for this key, such as "Power My Analytics".
  4. Click Generate. Copy your new API key.
Notes
Tip: If your organization has strict security policies, consider creating a dedicated API key exclusively for Power My Analytics. This way, you can apply relaxed IP authorization settings to just that key while keeping your other API keys restricted.
For more information, please see Brevo's documentation on Using your API key to authenticate.

IP Authorization Settings

Alert
Important: Power My Analytics requires your Brevo account's IP authorization to be set to "No IP review" in order for data to sync correctly. If IP restrictions are enabled, your reports will fail or return no data.
Power My Analytics processes data requests through Google Cloud Functions, which use a dynamic pool of IP addresses that change frequently. Because these IP addresses are not static, it is not possible to provide a fixed list of IPs to whitelist in Brevo. Enabling IP restrictions in Brevo will block API requests from Power My Analytics and cause your reports to fail.

To configure your Brevo IP authorization settings for use with Power My Analytics:
  1. Go to your Brevo Authorised IPs settings page.
  2. Select "No IP review" to allow requests from all IP addresses.
Notes
Your Brevo account is still protected even with "No IP review" enabled. Every API request still requires your API key for authentication, so only services with your key can access your data.

Alternative: Automatic IP Review and Authorization

If your organization prefers not to fully disable IP review, Brevo offers an "Automatic IP review and authorization" setting. This option automatically authorizes IP addresses used within the first 30 days. However, because Power My Analytics' IP addresses can change over time, this method is not guaranteed to work reliably and may result in intermittent report failures. For the most reliable experience, we recommend using "No IP review".

Adding Brevo as a Data Source

  1. In the Power My Analytics hub, navigate to Sources.
  2. Click + Add new source and select Brevo.
  3. Enter the Brevo API key you created for Power My Analytics.
  4. Click Connect to authenticate.

Creating a Looker Studio Report

Follow these steps to create a Looker Studio report using your Brevo data:

  1. In the PMA hub, navigate to Reports > Looker Studio
  2. Select Brevo under Create Looker Studio Report (this will open the official Looker Studio application in a new window)
    • Step 1:
      • Name your data source (e.g., change “Untitled Data Source” to "Brevo - Organization Name")
      • Power My Analytics Hub: Choose your PMA hub from the dropdown
      • Optional: Leave "Use report template for new reports" checked to use the PMA demo template
      • Click Next
    • Step 2:
      • User Account: Select your Brevo account (for real data) or "Sample Account" (for sample data)
      • Click Next
    • Step 3:
      • Click Connect (top right) to complete the data source configuration
    • Step 4:
      • Click Create Report (top right)

For a quick start, use our pre-built Brevo demo template.

Key Reports and Fields

The Brevo connector provides access to a variety of data, including:

  • Key Performance Metrics: New Contacts, Bounces, Hard Bounces, Soft Bounces, Unsubscribe Rate, Estimated Views, Complaint Rate, Open Rate, Click Rate, Delivery Rate, Click-to-Open Rate

For a full list of available Brevo fields in Power My Analytics, visit the Schema Explorer.

Limitations and Important Considerations

  • Backfilling: Up to 2 years of historical data is available through the Brevo connector.
    • Initial backfill: 13 months of historical data will be backfilled when you first connect your Brevo account as a data source.

Troubleshooting

See our article Basic Troubleshooting for information on issues that may affect the Brevo connector.

If you need further assistance, please submit a ticket.
    • Related Articles

    • Mailchimp Data Connector User Guide

      Are you looking to streamline your email marketing analytics and reporting? Power My Analytics' Mailchimp integration allows you to easily connect your Mailchimp account, automate data collection, and create powerful reports. This guide will walk you ...
    • Criteo Data Connector User Guide

      This guide will walk you through the process of connecting your Criteo account to Power My Analytics and creating reports using the data. Criteo is a powerful advertising platform specializing in retargeting, customer acquisition, and personalized ...
    • Taboola Data Connector User Guide

      Taboola is a powerful native advertising platform that helps marketers reach their target audience through sponsored content and product recommendations. This guide will walk you through the process of connecting your Taboola account to Power My ...
    • CartStack Data Connector User Guide

      Are you looking to streamline your e-commerce analytics and improve your cart abandonment recovery efforts? This guide will walk you through setting up and using the CartStack data source in Power My Analytics. By integrating CartStack with our ...
    • PayPal Data Connector User Guide

      PayPal is a widely used payment processing platform, and integrating its data into your analytics workflow can provide valuable insights into your business performance. This guide will walk you through the process of setting up PayPal as a data ...