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

IDTypeNameDescriptionReport
ab_testingBOOLEANA/B testingStatus of A/B Test for the campaign. abTesting = false means it is disabled, & abTesting = true means it is enabledcampaign
clickersNUMERICNumber of total clicksNumber of total clicks for the campaigncampaign
complaintsNUMERICNumber of complaintsNumber of complaints (Spam reports) for the campaigncampaign
created_atDATECreated atCreation UTC date-time of the campaign
dateDATEDateThe Date
deferredNUMERICNumber of deferred emails for the campaignNumber of deferred emailscampaign
deliveredNUMERICNumber of delivered emailsNumber of delivered emails for the campaigncampaign
emailTEXTEmailEmail address of the contact for which you requested the detailscontacts
email_blacklistedBOOLEANBlacklist status for Email.Blacklist status for email campaigns (true=blacklisted, false=not blacklisted)contacts
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 emailscampaign
firstnameTEXTFirstnameFirstnamecontacts
TEXTFooterFooter of the campaigncampaign
hard_bouncesNUMERICNumber of harbounceNumber of harbounce for the campaigncampaign
TEXTHeaderHeader of the campaigncampaign
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 emailcampaign
lastnameTEXTLastnameLastnamecontacts
mirror_activeBOOLEANMirror activeStatus of mirror links in campaign. mirrorActive = false means mirror links are deactivated, & mirrorActive = true means mirror links are activated, in the campaigncampaign
modified_atDATEModified atUTC date-time of last modification of the campaign
nameTEXTNameName of the campaigncampaign
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 timescampaign
reply_toTEXTReply toEmail defined as the "Reply to" of the campaigncampaign
return_bounceNUMERICTotal number of non-delivered campaignsTotal number of non-delivered campaigns for a particular campaign idcampaign
scheduled_atDATEScheduled atUTC date-time on which campaign is scheduledcampaign
send_at_best_timeBOOLEANSend at best timeIt is true if you have chosen to send your campaign at best time, otherwise it is falsecampaign
sender_emailTEXTsender_emailcampaign
sender_idNUMERICSender idcampaign
sender_nameTEXTsender_namecampaign
sentNUMERICNumber of sent emailsNumber of sent emails for the campaigncampaign
sent_dateDATESent dateSent UTC date-time of the campaign. Only available if 'status' of the campaign is 'sent'campaign
TEXTShare linkLink to share the campaign on social mediascampaign
smsTEXTSMSSMScontacts
sms_blacklistedBOOLEANBlacklist status for SMS.Blacklist status for SMS campaigns (true=blacklisted, false=not blacklisted)contacts
soft_bouncesNUMERICNumber of softbounceNumber of softbounce for the campaigncampaign
split_ruleNUMERICSplit ruleThe size of your ab-test groups. Only available if `abTesting` flag of the campaign is `true`campaign
statusTEXTStatusStatus of the campaigncampaign
subjectTEXTSubjectSubject of the campaign. Only available if `abTesting` flag of the campaign is `false`campaign
subject_aTEXTSubject ASubject A of the ab-test campaign. Only available if `abTesting` flag of the campaign is `true`campaign
subject_bTEXTsubject BSubject B of the ab-test campaign. Only available if `abTesting` flag of the campaign is `true`campaign
tagTEXTTagTag of the campaigncampaign
test_sentBOOLEANTest sentRetrieved the status of test email sendingcampaign
to_fieldTEXTTo fieldCustomisation of the "to" field of the campaigncampaign
trackable_viewsNUMERICRecipients without privacy protectionRecipients without any privacy protection option enabled in their email clientcampaign
trackable_views_rateNUMERICRate of recipients without privacy protectionRate of recipients without any privacy protection option enabled in their email clientcampaign
typeTEXTTypeType of campaigncampaign
unique_clicksNUMERICNumber of unique clicksNumber of unique clicks for the campaigncampaign
unique_viewsNUMERICNumber of unique openings for the campaignNumber of unique openingscampaign
unsubscriptionsNUMERICNumber of unsubscriptionNumber of unsubscription for the campaigncampaign
viewedNUMERICNumber of openingsNumber of openings for the campaigncampaign
winner_criteriaTEXTWinner criteriaCriteria for the winning version. Only available if `abTesting` flag of the campaign is `true`campaign