Sendinblue Looker Studio connector by Windsor.ai
+
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.
Our privacy policy and terms of use.
Available 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` |