ReportSentTo
A list of subscribers who were sent a specific campaign.
Table Specific Information
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.
- EmailId supports the '=' operator.
- CampaignId supports the '=' operator.
SELECT * FROM ReportSentTo where EmailId = '45a' and CampaignId = '458'
Columns
| Name | Type | Description |
| EmailId [KEY] | String | The list-specific ID for the given email address. |
| EmailAddress | String | Email address for a subscriber. |
| Status | String | The status of the member ('sent', 'hard' for hard bounce, or 'soft' for soft bounce). |
| OpenCount | Integer | The number of times a campaign was opened by this member. |
| LastOpen | String | The date and time of the last open for this member. |
| AbsplitGroup | String | For A/B Split Campaigns, the group the member was apart of ('a', 'b', or 'winner'). |
| GmtOffset | Integer | For campaigns sent with timewarp, the time zone group the member is apart of. |
| CampaignId [KEY] | String | The id for the campaign. |
| ListId [KEY] | String | The id for the list. |
| ListIsActive | Boolean | The status of the list used, namely if it's deleted or disabled. |
| MergeFields | String | A dictionary of merge fields where the keys are the merge tags. See the Merge Fields documentation for more about the structure. |
| VIP | Boolean | VIP status for subscriber. |