ListAbuse
Contains abuse complaints for a specific audience list, typically submitted when a recipient marks an email as spam.
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 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. |