ListAbuse
Contains abuse complaints for a specific audience list, typically submitted when a recipient marks an email as spam.
View-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| Id | = |
| ListId | = |
SELECT * FROM ListAbuse WHERE ListId = 'abc' AND Id = '452'
Columns
| Name | Type | References | 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 |
Campaigns.Id | The unique identifier of the Mailchimp campaign that generated the abuse report, allowing correlation between campaigns and complaint activity. |
| ListId [KEY] | String |
Lists.Id | 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 | Date | 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. |