ListAbuse
Contains abuse complaints for a specific audience list, typically submitted when a recipient marks an email as spam.
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.
- 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 unique identifier assigned to the abuse report, used to track and retrieve complaint details for a specific incident. |
| CampaignId [KEY] | String | The unique identifier of the Mailchimp campaign that generated the abuse report, allowing correlation between campaigns and complaint activity. |
| ListId [KEY] | String | The unique identifier of the audience (list) from which the complaint originated, helping identify where the affected subscriber belongs. |
| EmailId [KEY] | String | The MD5 hash of the lowercase version of the subscriber's email address, used for securely referencing the member within the API. |
| EmailAddress | String | The actual email address of the subscriber who reported the message as spam or abuse. |
| Date | String | The date and time when the abuse report was logged, typically captured in ISO 8601 format for accurate event tracking. |
| MergeFields | String | A set of merge field data for the subscriber, represented as key-value pairs where the keys are merge tags (for example, FNAME, LNAME). |
| VIP | Boolean | If the value is 'true', the subscriber is marked as a VIP within the list. This helps identify high-priority contacts when reviewing abuse reports. |