# 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` | `varchar2` | Creation Date | ☐ | Creation UTC date-time of the list (YYYY-MM-DDTHH:mm:ss.SSSZ) | | `dynamicList` | `char` | 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` | `varchar2` | Name | ☐ | Name of the list | | `stats_appleMppOpens` | `int64` | | ☐ | Numbers of times your email has been opened automatically through Apple MPP. | | `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_estimatedViews` | `int64` | | ☐ | Rate of recipients without any privacy protection option enabled in their email client, applied to all delivered emails | | `stats_hardBounces` | `int64` | #Hard-bounces | ☐ | Number of hard bounces 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_opensRate` | `double` | | ☐ | Percentage of recipients who open the email out of your total number of recipients. Depending on your Campaign settings, they may include Apple MPP opens. | | `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 email client | | `stats_trackableViewsRate` | `double` | | ☐ | Rate of 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 | | `uniqueSubscribers` | `int64` | #Unique Subscribers | ☐ | Number of unique contacts in the list |