ReportUnsubscribes
Lists members who unsubscribed from a specific campaign, including timestamps and reasons.
View-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| EmailId | = |
| CampaignId | = |
SELECT * FROM ReportUnsubscribes WHERE EmailId = '45a' AND CampaignId = '458'
Columns
| Name | Type | References | Description |
| EmailId [KEY] | String | The unique list-specific identifier for the subscriber's email address. It is used to link the unsubscribe event to the member within the mailing list. | |
| EmailAddress | String | The email address of the subscriber who opted out of receiving further campaign messages. | |
| Timestamp | Datetime | The exact date and time when the subscriber unsubscribed from the campaign. | |
| Reason | String | If provided, the subscriber's stated reason for unsubscribing. This can help identify common causes of opt-outs and improve future campaigns. | |
| CampaignId [KEY] | String |
Campaigns.Id | The unique identifier of the campaign associated with the unsubscribe event. |
| ListId [KEY] | String |
Lists.Id | The unique identifier of the mailing list from which the subscriber unsubscribed. |
| ListIsActive | Boolean | Indicates whether the associated mailing list is currently active ('true') or has been deleted or disabled ('false'). | |
| MergeFields | String | A set of dynamic data fields containing personalized subscriber information. Each key represents a merge tag used in the campaign, such as name or location. | |
| VIP | Boolean | Indicates whether the subscriber was marked as a VIP member of the list prior to unsubscribing. |