ReportSentTo

A list of subscribers who were sent a specific campaign.

Table Specific Information

SELECT is supported for ReportSentTo.

Select

A CampaignId is required to retrieve data from this table. If none is specified in the WHERE clause, the first one available for your account will be used.

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.