Excel Add-In for MailChimp

Build 20.0.7695

ListMemberActivity

The last 50 member events for a list.

テーブル固有の情報

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

Select

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

Columns

Name Type Description
MemberId [KEY] String The MemberId of the member to get events for.
EmailId [KEY] String The EmailId for the table.
ListId [KEY] String The ListId for the table.
Action String The type of action recorded for the subscriber.
Timestamp Datetime The date and time recorded for the action.
Url String For clicks, the URL the subscriber clicked on.
Type String The type of campaign that was sent.
CampaignId [KEY] String The web-based ID for the campaign.
Title String If set, the campaign's title.
ParentCampaign String The ID of the parent campaign.

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