ReportAbuse
Displays records of abuse complaints for a specific list or campaign.
Table Specific Information
SELECT is supported for ReportAbuse.
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.
- CampaignId supports the '=' operator.
SELECT * FROM ReportAdvice WHERE CampaignId = 'abc' and Id = '556'
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier of the abuse report within the Mailchimp account. |
| CampaignId [KEY] | String | The unique identifier of the campaign that received the abuse complaint. |
| ListId [KEY] | String | 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 | String | 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. |