ReportUnsubscribes
A list of members who have unsubscribed from a specific campaign.
Table Specific Information
SELECT is supported for ReportUnsubscribes.
Table Specific Information
Select
The provider 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 provider.
- 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 list-specific ID for the given email address |
| EmailAddress | String | Email address for a subscriber |
| Timestamp | Datetime | The date and time the member opted-out. |
| Reason | String | If available, the reason listed by the member for unsubscribing. |
| CampaignId [KEY] | String | The id for the campaign. |
| ListId [KEY] | String | The id for the list. |
| ListIsActive | Boolean | The status of the list used, namely if it's deleted or disabled. |
| MergeFields | String | A dictionary of merge fields where the keys are the merge tags. See the Merge Fields documentation for more about the structure. |
| VIP | Boolean | VIP status for subscriber. |