blog post

Explore your Brevo (ex Sendinblue) emailing KPI with PowerBI : How-to, templates and more

Florian Cabirol
January 29, 2024
Explore your Brevo (ex Sendinblue) emailing KPI with PowerBI : How-to, templates and more

Quick steps to create a Brevo (ex SendInBlue) report with Google Sheets:

You can easiliy create a Brevo (ex SendInBlue) report following this step :

  1. Get informations from the data integration from our Brevo (ex SendInBlue) connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your Brevo (ex SendInBlue) data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a Brevo (ex SendInBlue) report with Looker Studio:

You can easiliy create a Brevo (ex SendInBlue) report following this step :

  1. Get informations from the data integration from our Brevo (ex SendInBlue) connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for Brevo (ex SendInBlue) at the end of the page.

The tutorial

Quick steps to create a Brevo (ex SendInBlue) report with PowerBI:

You can easiliy create a Brevo (ex SendInBlue) report following this step :

  1. Get informations from the data integration from our Brevo (ex SendInBlue) connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for Brevo (ex SendInBlue) at the end of the page.

The tutorial

This comprehensive guide aims to empower marketing professionals with the knowledge to seamlessly connect their Brevo marketing data with PowerBI. By the end of this tutorial, you'll be equipped to import, visualize, and manage your marketing metrics through a dynamic PowerBI dashboard.

How to connect your Brevo account to PowerBI

Add a source on Catchr

Navigate to the Catchr homepage, and from the left sidebar, select Source. Click on Add a Source in the upper-right corner. Choose Brevo as your marketing platform and proceed with the authentication step to establish a connection between Catchr and Brevo.

Adding a source on Catchr

Create the request to transfer Brevo data to PowerBI

  • Inside Catchr, find and click on API in the left-hand menu.
API selection in Catchr
  • Adjust the export format to "PowerBI".
Setting export format to PowerBI
  • In the "Source" section, pick Brevo as your desired platform.
Selecting the Brevo platform
  • Next, select the specific Brevo accounts from which you want to extract data. It's possible to include multiple accounts.
Selecting Brevo accounts
  • Choose the metrics and dimensions you want included in your request. You can select several options.
Choosing metrics and dimensions
Additional metrics and dimensions selection
  • Tip: For template use, ensure to include all required dimensions and metrics indicated on Catchr's template page to prompt the template's automatic loading.
Template warning
  • Define the time period for the data you want to pull from Brevo, either by selecting a set interval or customizing your own.
Setting the time period
  • Add any necessary filters to refine your data request. You have the option to apply multiple filters.
Adding filters to the request
  • If available, apply specific options to tailor your request to the platform's features.
Adding platform-specific options
  • Once finalized, an URL will be displayed in the upper section. You can preview the output by clicking Preview to the top-right.
Previewing the data
  • After a brief pause, you'll be presented with a data preview.
Data preview
  • Satisfied with the setup? Copy the URL as you will need it later to bridge Brevo with PowerBI.
Copy the generated URL

Import the Brevo data and KPI to PowerBI

In PowerBI Desktop, go to Get Data, then Web. Remain in basic mode and insert the request URL you previously copied. Confirm by clicking OK. PowerBI may require some time to import your data completely. You can then edit your imported data using PowerBI Query Editor before designing and sharing your dashboards.

Importing data into PowerBI

In the PowerBI Web App, publish your dataset from the PowerBI Desktop to make it accessible via your browser. Create a new report and choose from your existing datasets to start crafting your online report.

By connecting Catchr's data consolidation capabilities with the analytical power of PowerBI, your data's narrative will come to life in visual storytelling that drives decisions and action.

Example of metrics you can use with the PowerBI Integration for Brevo

PowerBI revolutionizes how marketing teams interpret their data, converting complex datasets into actionable insights. When integrating Brevo with PowerBI, a plethora of metrics become readily available. Capturing metrics like Campaign Name, Sender Details, and Comprehensive Email Performance Criteria, allows marketers to construct an extensive narrative around each campaign's success. To grasp the full scope of metrics accessible from Brevo, please visit our field listing page.

Imagine being able to dissect campaign effectiveness by analyzing Total Clicks juxtaposed with Complaints or Unsubscriptions to better understand user engagement and content resonance. The marriage of Brevo with PowerBI equips businesses with the means to iterate on successful strategies and discontinue those that do not yield desirable results.

The strategic value extends to temporal slicing of data, where Year, Quarter, Month, and even Hour can shed light on the optimum moments for campaign launches. Maligned campaigns can spell disaster; well-timed ones can propel a brand to new heights.

In conclusion, the integration of PowerBI with Brevo data unleashes a suite of powerful cross-query functionalities and visualization tools that enhance a marketing team's ability to communicate, reason, and persuade through data. This tutorial represents just the beginning; the true depth of PowerBI is realized in its daily use, turning routine reporting into a craft of strategic storytelling.

Bonus : Your free Template Brevo Campaign Insight Template

In this Brevo (ex SendInBlue) template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

Bonus : Your free Brevo Campaign InsightTemplate for PowerBI

In this Brevo (ex SendInBlue) template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about Brevo (ex SendInBlue)

Import your Brevo emailing data to Google Sheets : How-to, metrics and more...

Master the art of integrating Brevo marketing data into Google Sheets with our detailed tutorial. Learn how to connect your Brevo account, select relevant metrics and dimensions, and set up automated data refreshes for real-time analysis. Ideal for marketers aiming to boost their email campaign strategies through enhanced reporting and insightful decision-making.

Florian Cabirol

Explore your Brevo (ex Sendinblue) emailing KPI with PowerBI : How-to, templates and more

Discover how to seamlessly integrate Brevo marketing data with PowerBI using Catchr for dynamic dashboard creation and data analysis. This guide covers the entire process, from data importation to visualization, helping marketers unlock powerful insights for strategic decision-making.

Florian Cabirol