Brevo (ex Sendinblue) & Power BI: How to integrate your data and template

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.

Create the request to transfer Brevo data to PowerBI

• Inside Catchr, find and click on API in the left-hand menu.

• Adjust the export format to "PowerBI".

• In the "Source" section, pick Brevo as your desired platform.

• Next, select the specific Brevo accounts from which you want to extract data. It's possible to include multiple accounts.

• Choose the metrics and dimensions you want included in your request. You can select several options.

• 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.

• Define the time period for the data you want to pull from Brevo, either by selecting a set interval or customizing your own.

• Add any necessary filters to refine your data request. You have the option to apply multiple filters.

• If available, apply specific options to tailor your request to the platform's features.

• Once finalized, an URL will be displayed in the upper section. You can preview the output by clicking Preview to the top-right.

• After a brief pause, you'll be presented with a data preview.

• Satisfied with the setup? Copy the URL as you will need it later to bridge Brevo with PowerBI.

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.

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.