Excel Add-In for MailChimp

Build 20.0.7695

ReportSentTo

A list of subscribers who were sent a specific campaign.

テーブル固有の情報

ReportSentTo では、SELECT がサポートされています。

Select

このテーブルからデータを取得するにはCampaignId を指定する必要があります。WHERE 句に何も指定されていない場合は、アカウントで使える最初のものが使用されます。

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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695