Connect SendinBlue to Google Data Studio with Windsor.ai
Directly connect SendinBlue to Google Data Studio, in minutes, and in an easy-to-use format.
+
All your marketing data in one place, just in a few clicks.
Automate and save time.
Use all your data where and when you need it.
About SendinBlue
SendinBlue is an all-in-one digital marketing platform that provides businesses with tools for managing and optimizing their email campaigns, SMS messaging, chat, CRM, and transactional email messages to build strong customer relationships. The platform also provides integrations with popular e-commerce and CMS platforms, such as Shopify and WordPress, to make it easier for businesses to manage their marketing efforts across different channels. SendinBlue supports more than 500,000 active users across 180 countries.
Learn more about SendinBlue
About Google Data Studio
Looker Studio or formerly known as Google Data Studio is a data visualization platform that helps businesses convert data into customizable informative reports and dashboards. It provides a simple and intuitive interface for users to create interactive reports and visualizations with their data. Data analysis using Google Data Studio provides businesses with valuable information that they can use to make informed decisions about their operations.
Learn more about Google Data Studio
Why integrate SendinBlue with Google Data Studio?
- Google Data Studio allows you to create custom dashboards and reports that show key metrics such as open rates, click-through rates, and conversion rates and monitor the performance of their email campaigns in real-time.
- Google Data Studio offers a range of visualization options that make it easier to identify trends and patterns in the performance of email campaigns that help you make informed decisions about your email marketing strategy.
- Integrating SendinBlue with Google Data Studio enables you to combine e-mail marketing data with other data sources such as Google Analytics which provide a deeper insight into the performance of their email campaigns, as well as other marketing channels.
- By analyzing data from SendinBlue in Google Data Studio, you can able to compare various audiences and personalize your email communications to specific audiences, leading to higher engagement and conversion rates.
About SendinBlue Google Data Studio Connector
The SendinBlue Google Data Studio Connector pulls Metrics and Dimensions for SendinBlue. The insights are retrieved at the campaign level.
Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.
Prerequisites
To set up the connector, the user should have:
- A Sendinblue API key in order to use this connector. (Visit our privacy policy and terms of use)
- A Google account for SendinBlue to Google Data Studio integration.
- A Windsor account. Start your free trial now.
How to connect SendinBlue to Google Data Studio?
You need to select SendinBlue as a Data Source and grant access to Windsor.ai. A Sendinblue API key in order to use this connector.
Select the fields on the right to later use in your data source. For example, you can include metrics such as Number of unique clicks, Number of unique subscription, or Number of sent e-mails.
Go to “Select Destination” and choose Google Data Studio.
Once done, select “connect” and authorize access to your data source.
Windsor.ai: All your marketing data in one place
Power up your marketing performance with result-driven marketing solutions
- Connect all your marketing, CRM, and analytics data from 50+ platforms and stream it to any spreadsheet tool, BI platform, or data warehouse.
- The setup is done in minutes. No coding is required.
- Currently, we support more than 3000 dimensions and metrics.
- See the value and return on every marketing touchpoint.
- Our marketing attribution software platform provides marketers with a 15-44% increase in marketing ROI.
Google Data Studio Templates for SendinBlue
Do you plan to connect and visualize SendinBlue data in Google Data Studio?
These free and customizable Google Data Studio SendinBlue templates will assist you in visualizing your data for easy reporting and analysis.
Google Data Studio Tutorials for SendinBlue
Would you like to take your Google Data Studio SendinBlue dashboards to the next level?
Here are some of our favorite tutorials to help you:
Available SendinBlue Metrics and Dimensions
| Name | Type | Description |
|---|---|---|
| A/B testing | BOOLEAN | Status of A/B Test for the campaign. abTesting = false means it is disabled, & abTesting = true means it is enabled |
| Number of total clicks | NUMERIC | Number of total clicks for the campaign |
| Number of complaints | NUMERIC | Number of complaints (Spam reports) for the campaign |
| Created at | DATE | Creation UTC date-time of the campaign |
| Date | DATE | The Date |
| Number of deferred emails for the campaign | NUMERIC | Number of deferred emails |
| Number of delivered emails | NUMERIC | Number of delivered emails for the campaign |
| TEXT | Email address of the contact for which you requested the details | |
| Blacklist status for Email. | BOOLEAN | Blacklist status for email campaigns (true=blacklisted, false=not blacklisted) |
| Rate of recipients without privacy protection (all emails) | NUMERIC | Rate of recipients without any privacy protection option enabled in their email client, applied to all delivered emails |
| Firstname | TEXT | Firstname |
| Footer | TEXT | Footer of the campaign |
| Number of harbounce | NUMERIC | Number of harbounce for the campaign |
| Header | TEXT | Header of the campaign |
| Inline image activation | BOOLEAN | Status of inline image. inlineImageActivation = false means image can’t be embedded, & inlineImageActivation = true means image can be embedded, in the email |
| Lastname | TEXT | Lastname |
| Mirror active | BOOLEAN | Status of mirror links in campaign. mirrorActive = false means mirror links are deactivated, & mirrorActive = true means mirror links are activated, in the campaign |
| Modified at | DATE | UTC date-time of last modification of the campaign |
| Name | TEXT | Name of the campaign |
| Recurring | BOOLEAN | Type of trigger campaign.recurring = false means contact can receive the same Trigger campaign only once, & recurring = true means contact can receive the same Trigger campaign several times |
| Reply to | TEXT | Email defined as the "Reply to" of the campaign |
| Total number of non-delivered campaigns | NUMERIC | Total number of non-delivered campaigns for a particular campaign id |
| Scheduled at | DATE | UTC date-time on which campaign is scheduled |
| Send at best time | BOOLEAN | It is true if you have chosen to send your campaign at best time, otherwise it is false |
| sender_email | TEXT | |
| Sender id | NUMERIC | |
| sender_name | TEXT | |
| Number of sent emails | NUMERIC | Number of sent emails for the campaign |
| Sent date | DATE | Sent UTC date-time of the campaign. Only available if 'status' of the campaign is 'sent' |
| Share link | TEXT | Link to share the campaign on social medias |
| SMS | TEXT | SMS |
| Blacklist status for SMS. | BOOLEAN | Blacklist status for SMS campaigns (true=blacklisted, false=not blacklisted) |
| Number of softbounce | NUMERIC | Number of softbounce for the campaign |
| Split rule | NUMERIC | The size of your ab-test groups. Only available if `abTesting` flag of the campaign is `true` |
| Status | TEXT | Status of the campaign |
| Subject | TEXT | Subject of the campaign. Only available if `abTesting` flag of the campaign is `false` |
| Subject A | TEXT | Subject A of the ab-test campaign. Only available if `abTesting` flag of the campaign is `true` |
| subject B | TEXT | Subject B of the ab-test campaign. Only available if `abTesting` flag of the campaign is `true` |
| Tag | TEXT | Tag of the campaign |
| Test sent | BOOLEAN | Retrieved the status of test email sending |
| To field | TEXT | Customisation of the "to" field of the campaign |
| Recipients without privacy protection | NUMERIC | Recipients without any privacy protection option enabled in their email client |
| Rate of recipients without privacy protection | NUMERIC | Rate of recipients without any privacy protection option enabled in their email client |
| Type | TEXT | Type of campaign |
| Number of unique clicks | NUMERIC | Number of unique clicks for the campaign |
| Number of unique openings for the campaign | NUMERIC | Number of unique openings |
| Number of unsubscription | NUMERIC | Number of unsubscription for the campaign |
| Number of openings | NUMERIC | Number of openings for the campaign |
| Winner criteria | TEXT | Criteria for the winning version. Only available if `abTesting` flag of the campaign is `true` |