blog post

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

Florian Cabirol
January 31, 2024
Import your Brevo emailing data to Google Sheets : How-to, metrics 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

In this comprehensive tutorial, you're about to learn how you can seamlessly integrate your Brevo marketing data with Google Sheets. By following these straightforward steps, you will be able to visualize your email campaign metrics directly in Google Sheets, allowing for better analysis, reporting, and decision-making.

How to connect your Brevo account to Google Sheets

Add a source on Catchr

To start, navigate to the Catchr homepage. On the left side menu, find and click on Source, then at the top right corner, click on Add a Source. From here, select Brevo as your platform and complete the identification process to connect Catchr with Brevo.

Adding a source on Catchr

Create a New Query

Launch Google Sheets and access the Catchr menu option. From there, select "New Query" to kickstart the process of importing your Brevo data.

Select Your Data Source

In the query setup, select Brevo as your data source from the available list. If Brevo doesn't appear, simply add it by clicking the "+" button.

Selecting your data source

Select Your Account(s)

Proceed to the "Select account(s)" section and pick the Brevo account(s) you aim to retrieve data from.

Selecting Brevo accounts

Choose Metrics and Dimensions

Now, navigate to the Metric and Dimensions tabs to select the precise data points for your query. Relevant options may include:

Metrics:

  • Total Clicks: The sum of clicks across your campaigns.
  • Delivered: The total emails successfully delivered.
  • Unique Views: The count of unique email views.
Choosing Metrics

Dimensions:

  • Campaign Name: The name of your email campaign.
  • Date: Specific dates for analysis.
  • Platform Name: Identifies the Brevo platform.
Choosing Dimensions

Set Date Range

After selecting metrics and dimensions, switch to the "Date Range" tab. Choose from predefined or custom date ranges for your data.

Setting the Date Range

Apply Filters

To refine your data, use the Filters tab. Insert details in the three fields below for precise data curation:

  • Field: Campaign Name
  • Operator: equals
  • Value: Specific campaign name, like "Summer Sale"
Applying Filters

Schedule & Customize Data Refreshness

Finally, access the "Options" tab to set automatic data refresh schedules. Choose to either append new rows or combine them as needed.

Scheduling Data Refreshes

By following these steps, you've successfully set up your Google Sheets to receive and display data from your Brevo campaigns, facilitating enhanced data analysis and reporting.

Example of Google Sheets you can create to use with the Brevo source

With the data from Brevo (formerly SendInBlue) at your fingertips, the possibilities for creating insightful Google Sheets dashboards are endless. Here are some examples to inspire your next project:

Campaign Performance Report: Design a dashboard that shows key metrics such as Total Clicks, Delivered Emails, and Unique Views. Use charts to compare campaign performance over time or against other campaigns.

Email Engagement Report: Craft a report focusing on engagement metrics like Click-through Rates and Open Rates by different dimensions such as Campaign Name, Date, and Platform. This allows you to identify which types of campaigns are driving the most engagement.

Delivery and Bounce Rate Analysis: Create a sheet that highlights your delivery success and challenges by examining Delivered, Soft Bounces, and Hard Bounces. This analysis can help pinpoint issues in your email list or content that may be causing delivery problems.

Combining Catchr with Google Sheets provides the flexibility to build custom reports that meet your unique business needs. By utilizing the data from Brevo, you can gain deeper insights into your email marketing efforts, aiding you in making data-driven decisions to enhance your campaigns.

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