ListAbuse
A collection of abuse complaints for a specific list. An abuse complaint occurs when your recipient clicks to 'report spam' in their email program.
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.
- Id supports the '=' operator.
- ListId supports the '=' operator.
SELECT * FROM ListAbuse WHERE ListId = 'abc' and Id='452'
Columns
| Name | Type | Description |
| Id [KEY] | String | The id for the abuse report |
| CampaignId [KEY] | String | The campaign id for the abuse report |
| ListId [KEY] | String | The list id for the abuse report. |
| EmailId [KEY] | String | The MD5 hash of the list member's email address. |
| EmailAddress | String | Email address for a subscriber |
| Date | String | Date for the abuse report |
| 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. |