ReportUnsubscribes
Lists members who unsubscribed from a specific campaign, including timestamps and reasons.
Table Specific Information
SELECT is supported for ReportUnsubscribes.
Table Specific Information
Select
The add-in will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.
- EmailId supports the '=' operator.
- CampaignId supports the '=' operator.
SELECT * FROM ReportUnsubscribes where EmailId = '45a' and CampaignId = '458'
Columns
| Name | Type | 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 | The unique identifier of the campaign associated with the unsubscribe event. |
| ListId [KEY] | String | 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. |