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 connector 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 connector.
- 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. |