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.
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.
Select Your Account(s)
Proceed to the "Select account(s)" section and pick the Brevo account(s) you aim to retrieve data from.
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.
Dimensions:
- Campaign Name: The name of your email campaign.
- Date: Specific dates for analysis.
- Platform Name: Identifies the Brevo platform.
Set Date Range
After selecting metrics and dimensions, switch to the "Date Range" tab. Choose from predefined or custom date ranges for your data.
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"
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.
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.
