ReportSentTo
A list of subscribers who were sent a specific campaign.
Table Specific Information
Select
The provider 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 provider.
- 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. |