Sendinblue Field Reference

Sample
https://connectors.windsor.ai/sendinblue?api_key=[your API key]&date_preset=last_7d&fields=date,name,viewed,delivered,clickers,sent
Fields
ID | Type | Name | Description |
---|---|---|---|
ab_testing | BOOLEAN | A/B testing | Status of A/B Test for the campaign. abTesting = false means it is disabled, & abTesting = true means it is enabled |
clickers | NUMERIC | Number of total clicks | Number of total clicks for the campaign |
complaints | NUMERIC | Number of complaints | Number of complaints (Spam reports) for the campaign |
created_at | TIMESTAMP | Created at | Creation UTC date-time of the campaign |
date | DATE | Date | The Date |
deferred | NUMERIC | Number of deferred emails for the campaign | Number of deferred emails |
delivered | NUMERIC | Number of delivered emails | Number of delivered emails for the campaign |
estimated_views | NUMERIC | Rate of recipients without privacy protection (all emails) | Rate of recipients without any privacy protection option enabled in their email client, applied to all delivered emails |
footer | TEXT | Footer | Footer of the campaign |
hard_bounces | NUMERIC | Number of harbounce | Number of harbounce for the campaign |
header | TEXT | Header | Header of the campaign |
inline_image_activation | BOOLEAN | Inline image activation | Status of inline image. inlineImageActivation = false means image can’t be embedded, & inlineImageActivation = true means image can be embedded, in the email |
mirror_active | BOOLEAN | Mirror active | 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 | Modified at | UTC date-time of last modification of the campaign |
name | TEXT | Name | Name of the campaign |
recurring | BOOLEAN | Recurring | 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 | Reply to | Email defined as the "Reply to" of the campaign |
return_bounce | NUMERIC | Total number of non-delivered campaigns | Total number of non-delivered campaigns for a particular campaign id |
scheduled_at | DATE | Scheduled at | UTC date-time on which campaign is scheduled |
send_at_best_time | BOOLEAN | Send at best time | It is true if you have chosen to send your campaign at best time, otherwise it is false |
sender_email | TEXT | sender_email | |
sender_id | NUMERIC | Sender id | |
sender_name | TEXT | sender_name | |
sent | NUMERIC | Number of sent emails | Number of sent emails for the campaign |
sent_date | DATE | Sent date | Sent UTC date-time of the campaign. Only available if 'status' of the campaign is 'sent' |
share_link | TEXT | Share link | Link to share the campaign on social medias |
soft_bounces | NUMERIC | Number of softbounce | Number of softbounce for the campaign |
split_rule | NUMERIC | Split rule | The size of your ab-test groups. Only available if `abTesting` flag of the campaign is `true` |
status | TEXT | Status | Status of the campaign |
subject | TEXT | Subject | Subject of the campaign. Only available if `abTesting` flag of the campaign is `false` |
subject_a | TEXT | Subject A | Subject A of the ab-test campaign. Only available if `abTesting` flag of the campaign is `true` |
subject_b | TEXT | subject B | Subject B of the ab-test campaign. Only available if `abTesting` flag of the campaign is `true` |
tag | TEXT | Tag | Tag of the campaign |
test_sent | BOOLEAN | Test sent | Retrieved the status of test email sending |
to_field | TEXT | To field | Customisation of the "to" field of the campaign |
trackable_views | NUMERIC | Recipients without privacy protection | Recipients without any privacy protection option enabled in their email client |
trackable_views_rate | NUMERIC | Rate of recipients without privacy protection | Rate of recipients without any privacy protection option enabled in their email client |
type | TEXT | Type | Type of campaign |
unique_clicks | NUMERIC | Number of unique clicks | Number of unique clicks for the campaign |
unique_views | NUMERIC | Number of unique openings for the campaign | Number of unique openings |
unsubscriptions | NUMERIC | Number of unsubscription | Number of unsubscription for the campaign |
viewed | NUMERIC | Number of openings | Number of openings for the campaign |
winner_criteria | TEXT | Winner criteria | Criteria for the winning version. Only available if `abTesting` flag of the campaign is `true` |