ReportAbuse
Displays records of abuse complaints for a specific list or campaign.
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 | = |
| CampaignId | = |
SELECT * FROM ReportAbuse WHERE CampaignId = 'abc' AND Id = '556'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier of the abuse report within the Mailchimp account. | |
| CampaignId [KEY] | String |
Campaigns.Id | The unique identifier of the campaign that received the abuse complaint. |
| ListId [KEY] | String |
Lists.Id | The unique identifier of the audience (list) associated with the abuse report. |
| EmailId [KEY] | String | The list-specific identifier for the subscriber's email address that submitted the complaint. | |
| EmailAddress | String | The email address of the subscriber who reported the message as spam or abuse. | |
| Date | Date | The date and time when the abuse complaint was recorded. | |
| MergeFields | String | A set of key-value pairs representing merge fields associated with the subscriber, where keys are merge tags and values contain subscriber data. | |
| VIP | Boolean | If the value is 'true', it indicates that the subscriber has VIP status in the list. | |
| ListIsActive | Boolean | If the value is 'true', it indicates that the associated audience (list) is currently active; if 'false', the list has been deleted or disabled. |