ListCampaignStatistics: Sendinblue List Campaign Statistics |
Catalog: Brevo
Schema: Views
Label: List Campaign Statistics
This is a read-only view. The Sendinblue API may not support changing the data or the Invantive UniversalSQL driver for Sendinblue does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Sendinblue API.
View Columns
The columns of the view ListCampaignStatistics are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
campaignId |
int64 |
Campaign ID |
☐ |
ID of the campaign |
createdAt |
datetime |
Creation Date |
☐ |
Creation UTC date-time of the list (YYYY-MM-DDTHH:mm:ss.SSSZ) |
dynamicList |
boolean |
Dynamic List |
☐ |
Status telling if the list is dynamic or not (true=dynamic, false=not dynamic) |
folderId |
int64 |
Folder ID |
☐ |
ID of the folder |
id |
int64 |
ID |
☐ |
ID of the list |
name |
string |
Name |
☐ |
Name of the list |
stats_clickers |
int64 |
#Clickers |
☐ |
Number of total clicks for the campaign |
stats_complaints |
int64 |
#Complaints |
☐ |
Number of complaints (Spam reports) for the campaign |
stats_deferred |
int64 |
#Deferred |
☐ |
Number of deferred emails for the campaign |
stats_delivered |
int64 |
#Delivered |
☐ |
Number of delivered emails for the campaign |
stats_hardBounces |
int64 |
#Hard-bounces |
☐ |
Number of harbounce for the campaign |
stats_listId |
int64 |
List ID |
☐ |
List Id of email campaign (only in case of get email campaign(s)(not for global stats)) |
stats_returnBounce |
int64 |
#Return-bounces |
☐ |
Total number of non-delivered campaigns for a particular campaign id. |
stats_sent |
int64 |
#Sent |
☐ |
Number of sent emails for the campaign |
stats_softBounces |
int64 |
#Soft-bounces |
☐ |
Number of softbounce for the campaign |
stats_trackableViews |
int64 |
#Trackable Views |
☐ |
Recipients without any privacy protection option enabled in their email client |
stats_uniqueClicks |
int64 |
#Unique Clicks |
☐ |
Number of unique clicks for the campaign |
stats_uniqueViews |
int64 |
#Unique Views |
☐ |
Number of unique openings for the campaign |
stats_unsubscriptions |
int64 |
#Unsubscriptions |
☐ |
Number of unsubscription for the campaign |
stats_viewed |
int64 |
#Viewed |
☐ |
Number of openings for the campaign |
totalBlacklisted |
int64 |
Total Blacklisted |
☐ |
Number of blacklisted contacts in the list |
totalSubscribers |
int64 |
Total Subscribers |
☐ |
Number of contacts in the list |
17-09-2024 15:16 Version 24.1.8-BETA+4877