ReportSentTo
Returns subscribers who were sent a specific 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 |
| EmailId | = |
| CampaignId | = |
SELECT * FROM ReportSentTo WHERE EmailId = '45a' AND CampaignId = '458'
Columns
| Name | Type | References | Description |
| EmailId [KEY] | String | The list-specific ID for the given email address. | |
| EmailAddress | String | The email address of the subscriber. | |
| Status | String | The status of the member ('sent', 'hard' for hard bounce, or 'soft' for soft bounce).
The allowed values are sent, hard, soft. | |
| 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 a part of ('a', 'b', or 'winner').
The allowed values are a, b, winner. | |
| GmtOffset | Integer | For campaigns sent with timewarp, the time zone group the member is a part of. | |
| CampaignId [KEY] | String |
Campaigns.Id | The Id of the campaign. |
| ListId [KEY] | String |
Lists.Id | The Id of the list. |
| ListIsActive | Boolean | Indicates whether the list used for this campaign is active. A value of false indicates the list is 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 | Indicates whether the subscriber has VIP status. |