JDBC Driver for Mailchimp

Build 22.0.8462

ListMemberActivity

The last 50 member events for a list.

Table Specific Information

SELECT is supported for ListMemberActivity.

Select

A ListId 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
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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462