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

IDTypeNameDescription
ab_testingBOOLEANA/B testingStatus of A/B Test for the campaign. abTesting = false means it is disabled, & abTesting = true means it is enabled
clickersNUMERICNumber of total clicksNumber of total clicks for the campaign
complaintsNUMERICNumber of complaintsNumber of complaints (Spam reports) for the campaign
created_atTIMESTAMPCreated atCreation UTC date-time of the campaign
dateDATEDateThe Date
deferredNUMERICNumber of deferred emails for the campaignNumber of deferred emails
deliveredNUMERICNumber of delivered emailsNumber of delivered emails for the campaign
estimated_viewsNUMERICRate 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
TEXTFooterFooter of the campaign
hard_bouncesNUMERICNumber of harbounceNumber of harbounce for the campaign
TEXTHeaderHeader of the campaign
inline_image_activationBOOLEANInline image activationStatus of inline image. inlineImageActivation = false means image can’t be embedded, & inlineImageActivation = true means image can be embedded, in the email
mirror_activeBOOLEANMirror activeStatus of mirror links in campaign. mirrorActive = false means mirror links are deactivated, & mirrorActive = true means mirror links are activated, in the campaign
modified_atDATEModified atUTC date-time of last modification of the campaign
nameTEXTNameName of the campaign
recurringBOOLEANRecurringType 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_toTEXTReply toEmail defined as the "Reply to" of the campaign
return_bounceNUMERICTotal number of non-delivered campaignsTotal number of non-delivered campaigns for a particular campaign id
scheduled_atDATEScheduled atUTC date-time on which campaign is scheduled
send_at_best_timeBOOLEANSend at best timeIt is true if you have chosen to send your campaign at best time, otherwise it is false
sender_emailTEXTsender_email
sender_idNUMERICSender id
sender_nameTEXTsender_name
sentNUMERICNumber of sent emailsNumber of sent emails for the campaign
sent_dateDATESent dateSent UTC date-time of the campaign. Only available if 'status' of the campaign is 'sent'
TEXTShare linkLink to share the campaign on social medias
soft_bouncesNUMERICNumber of softbounceNumber of softbounce for the campaign
split_ruleNUMERICSplit ruleThe size of your ab-test groups. Only available if `abTesting` flag of the campaign is `true`
statusTEXTStatusStatus of the campaign
subjectTEXTSubjectSubject of the campaign. Only available if `abTesting` flag of the campaign is `false`
subject_aTEXTSubject ASubject A of the ab-test campaign. Only available if `abTesting` flag of the campaign is `true`
subject_bTEXTsubject BSubject B of the ab-test campaign. Only available if `abTesting` flag of the campaign is `true`
tagTEXTTagTag of the campaign
test_sentBOOLEANTest sentRetrieved the status of test email sending
to_fieldTEXTTo fieldCustomisation of the "to" field of the campaign
trackable_viewsNUMERICRecipients without privacy protectionRecipients without any privacy protection option enabled in their email client
trackable_views_rateNUMERICRate of recipients without privacy protectionRate of recipients without any privacy protection option enabled in their email client
typeTEXTTypeType of campaign
unique_clicksNUMERICNumber of unique clicksNumber of unique clicks for the campaign
unique_viewsNUMERICNumber of unique openings for the campaignNumber of unique openings
unsubscriptionsNUMERICNumber of unsubscriptionNumber of unsubscription for the campaign
viewedNUMERICNumber of openingsNumber of openings for the campaign
winner_criteriaTEXTWinner criteriaCriteria for the winning version. Only available if `abTesting` flag of the campaign is `true`