ReportAbuse
Displays records of abuse complaints for a specific list or campaign.
Table Specific Information
SELECT is supported for ReportAbuse.
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.
- 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. |