ListSegmentMembers

Returns the members of a specific list segment, including those who have bounced or unsubscribed.

Table-Specific Information

SELECT, INSERT, and DELETE are supported for ListSegmentMembers.

Select

The add-in 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 add-in.


Column	Supported Operators
ListId	=
SegmentId	=
IncludeCleaned	=
IncludeTransactional	=
IncludeUnsubscribed	=

For example, the following queries are processed server-side:

SELECT * FROM ListSegmentMembers WHERE ListId = '5152' AND SegmentId = '2623'
SELECT * FROM ListSegmentMembers WHERE IncludeCleaned = 'true'
SELECT * FROM ListSegmentMembers WHERE IncludeTransactional = 'true'
SELECT * FROM ListSegmentMembers WHERE IncludeUnsubscribed = 'true'

Insert

The Name and ListId columns are required for INSERT operations.

INSERT INTO ListSegmentMembers (EmailAddress, ListId, SegmentId) VALUES ('[email protected]', '44a64c46cb', '7032720')

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The MD5 hash of the list member's email address.
EmailAddress	String	False		Email address for a subscriber.
UniqueEmailId [KEY]	String	True		A unique identifier for the email address across all of Mailchimp.
EmailType	String	True		Type of email this member asked to get ('html' or 'text'). The allowed values are html, text.
Status	String	True		Subscriber's current status ('subscribed', 'unsubscribed', 'cleaned', or 'pending'). The allowed values are subscribed, unsubscribed, cleaned, pending.
StatusIfNew	String	True		Subscriber's status ('subscribed', 'unsubscribed', 'cleaned', or 'pending'), to be used only on a PUT request if the email is not already present on the list. The allowed values are subscribed, unsubscribed, cleaned, pending.
Interests	String	True		A dictionary of interest Ids indicating which interests the subscriber has opted into.
Stats_AvgOpenRate	Double	True		A subscriber's average open rate.
Stats_AvgClickRate	Double	True		A subscriber's average clickthrough rate.
IpSignup	String	True		The IP address the subscriber signed up from.
TimestampSignup	Datetime	True		The date and time the subscriber signed up for the list.
IpOpt	String	True		The IP address from which the subscriber confirmed their opt-in status.
TimestampOpt	Datetime	True		The date and time the subscriber confirmed their opt-in status.
MemberRating	Integer	True		The star rating for this member, on a scale of 1 to 5.
LastChanged	Datetime	True		The date and time the member's information was last changed.
Language	String	True		The language of the subscriber, if set or detected.
Vip	Boolean	True		Indicates whether the subscriber has VIP status.
EmailClient	String	True		The email client the subscriber was using.
Location_Latitude	Double	True
Location_Longitude	Double	True
Location_Gmtoff	Integer	True
Location_Dstoff	Integer	True
Location_CountryCode	String	True
Location_Timezone	String	True
LastNote_NoteId	Integer	True	ListMemberNotes.Id	The unique Id of the note.
LastNote_CreatedAt	String	True		The date the note was created.
LastNote_CreatedBy	String	True		The author of the note.
LastNote_Note	String	True		The content of the note.
ListId [KEY]	String	False	Lists.Id	The Id of the list.
SegmentId [KEY]	String	False	ListSegments.Id	The Id of the segment.
MergeFields	String	True		A dictionary of merge fields where the keys are the merge tags. See the Merge Fields documentation for more about the structure.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.