Sendinblue Looker Studio connector by Windsor.ai

sendinblue
+

About the Connector

The connector pulls metrics and dimensions from Sendinblue. The insights are retrieved at campaign level.

Once user successfully logs into the connector its possible to choose the metrics and dimensions to create a report on.

Prerequisites

The user should have a Sendinblue API key in order to use this connector.

Available Metrics and Dimensions

NameTypeDescription
A/B testingBOOLEANStatus of A/B Test for the campaign. abTesting = false means it is disabled, & abTesting = true means it is enabled
Number of total clicksNUMERICNumber of total clicks for the campaign
Number of complaintsNUMERICNumber of complaints (Spam reports) for the campaign
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
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
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
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
TypeTEXTType of campaign
Number of unique clicksNUMERICNumber of unique clicks for the campaign
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`