Connect Sendinblue to Looker Studio

Directly connect Sendinblue to Looker Studio, in minutes, and in an easy-to-use format.

sendinblue looker studio integration

Why integrate Sendinblue with Google Data Studio?

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

 

  • Integrating SendinBlue with Google Data Studio enables you to combine e-mail marketing data with other data sources such as Google Analytics 4 which provide a deeper insight into the performance of their email campaigns, as well as other marketing channels.

 

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

 

  • Google Data Studio allows you to blend data from multiple sources. This means you can combine Sendinblue data with data from other platforms to gain a more holistic view of your marketing efforts..

About the Sendinblue Looker Studio Connector

The Sendinblue Looker 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:

 

How to connect Sendinblue to Looker Studio?

Do you plan to connect and visualize your Sendinblue in Looker Studio? Follow the Tutorial Below:

Select the fields on the right to later use in your data source. For example, you can include metrics such as Cost per Click, Cost per Action or Total Spend.select fields on the right

Go to “Select Destination” and choose Looker Studio.

select looker studio

Once done, select “connect” and authorize access to your data source.

sendinblue looker studio integration

Start Free Trial

Sendinblue metrics & dimensions available for streaming into Looker Studio

nametypedescription
A/B testingBOOLEANStatus of A/B Test for the campaign. abTesting = false means it is disabled, & abTesting = true means it is enabled
CampaignTEXTName of the campaign
Number of total clicksNUMERICNumber of total clicks for the campaign
Number of complaintsNUMERICNumber of complaints (Spam reports) for the campaign
Contact Created AtDATECreation UTC date-time of the contact
Contact IDTEXTID of the contact
Contact List IDsTEXTArray of contact list ids
Contact Modified AtDATELast modification UTC date-time of the contact
Created atDATECreation UTC date-time of the campaign
DateDATEThe Date
Number of deferred emails for the campaignNUMERICNumber of deferred emails
Number of delivered emailsNUMERICNumber of delivered emails for the campaign
EmailTEXTEmail address of the contact for which you requested the details
Blacklist status for Email.BOOLEANBlacklist status for email campaigns (true=blacklisted, false=not blacklisted)
Rate of recipients without privacy protection (all emails)NUMERICRate of recipients without any privacy protection option enabled in their email client, applied to all delivered emails
FirstnameTEXTFirstname
Folder IDTEXTID of the folder
TEXTFooter of the campaign
Number of harbounceNUMERICNumber of harbounce for the campaign
TEXTHeader of the campaign
Inline image activationBOOLEANStatus of inline image. inlineImageActivation = false means image can’t be embedded, & inlineImageActivation = true means image can be embedded, in the email
LastnameTEXTLastname
List Created atDATECreation UTC date-time of the list
List IDTEXTThe unique ID of the recipient list
List NameTEXTThe unique nmae of the recipient list
Mirror activeBOOLEANStatus of mirror links in campaign. mirrorActive = false means mirror links are deactivated, & mirrorActive = true means mirror links are activated, in the campaign
Modified atDATEUTC date-time of last modification of the campaign
NameTEXTName of the campaign
RecurringBOOLEANType 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 toTEXTEmail defined as the "Reply to" of the campaign
Total number of non-delivered campaignsNUMERICTotal number of non-delivered campaigns for a particular campaign id
Scheduled atDATEUTC date-time on which campaign is scheduled
Send at best timeBOOLEANIt is true if you have chosen to send your campaign at best time, otherwise it is false
sender_emailTEXT
Sender idNUMERIC
sender_nameTEXT
Number of sent emailsNUMERICNumber of sent emails for the campaign
Sent dateDATESent UTC date-time of the campaign. Only available if 'status' of the campaign is 'sent'
TEXTLink to share the campaign on social medias
SMSTEXTSMS
Blacklist status for SMS.BOOLEANBlacklist status for SMS campaigns (true=blacklisted, false=not blacklisted)
Number of softbounceNUMERICNumber of softbounce for the campaign
Split ruleNUMERICThe size of your ab-test groups. Only available if `abTesting` flag of the campaign is `true`
StatusTEXTStatus of the campaign
SubjectTEXTSubject of the campaign. Only available if `abTesting` flag of the campaign is `false`
Subject ATEXTSubject A of the ab-test campaign. Only available if `abTesting` flag of the campaign is `true`
subject BTEXTSubject B of the ab-test campaign. Only available if `abTesting` flag of the campaign is `true`
TagTEXTTag of the campaign
Test sentBOOLEANRetrieved the status of test email sending
To fieldTEXTCustomisation of the "to" field of the campaign
Total BlacklistedNUMERICNumber of total blacklisted
Total SubscribersNUMERICNumber of total subscribers
Recipients without privacy protectionNUMERICRecipients without any privacy protection option enabled in their email client
Rate of recipients without privacy protectionNUMERICRate of recipients without any privacy protection option enabled in their email client
Transactional Email Event DateDATEUTC date-time on which the event has been generated
Transactional Email Event EmailTEXTEmail address which generates the event
Transactional Email EventTEXTEvent which occurred
Transactional Email Event Template FromTEXTSender email from which the emails are sent
Transactional Email Event IPTEXTIP from which the user has opened the email or clicked on the link (only available if the event is opened or clicks)
TEXTIP from which the user has opened the email or clicked on the link (only available if the event is opened or clicks)
Transactional Email Event Message IDTEXTMessage ID which generated the event
Transactional Email Event ReasonTEXTReason of bounce (only available if the event is hardbounce or softbounce)
Transactional Email Event SubjectTEXTSubject of the event
Transactional Email Event TagTEXTTag of the email which generated the event
Transactional Email Event Template IDTEXTID of the template (only available if the email is template based)
Transactional Email Report BlockedNUMERICNumber of blocked emails for the date
Transactional Email Report ClicksNUMERICNumber of clicks for the date
Transactional Email Report DateDATEDate of the statistics
Transactional Email Report DeliveredNUMERICNumber of delivered emails for the date
Transactional Email Report Hard BouncesNUMERICNumber of hardbounces for the date
Transactional Email Report InvalidNUMERICNumber of invalid emails for the date
Transactional Email Report OpensNUMERICNumber of openings for the date
Transactional Email Report RequestsNUMERICNumber of requests for the date
Transactional Email Report Soft BouncesNUMERICNumber of softbounces for the date
Transactional Email Report Spam ReportsNUMERICNumber of complaints (spam reports) for the date
Transactional Email Report Unique ClicksNUMERICNumber of unique clicks for the date
Transactional Email Report Unique OpensNUMERICNumber of unique openings for the date
Transactional Email Report UnsubscribedNUMERICNumber of unsubscribed emails for the date
TypeTEXTType of campaign
Number of unique clicksNUMERICNumber of unique clicks for the campaign
Unique SubscribersNUMERICNumber of unique subscribers
Number of unique openings for the campaignNUMERICNumber of unique openings
Number of unsubscriptionNUMERICNumber of unsubscription for the campaign
Number of openingsNUMERICNumber of openings for the campaign
Winner criteriaTEXTCriteria for the winning version. Only available if `abTesting` flag of the campaign is `true`
TodayDATEToday's date

Easily connect Sendinblue to Looker Studio

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your Sendinblue and Looker Studio Integrations