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 driver 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 driver.


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		The email address for the subscriber.
UniqueEmailId [KEY]	String	True		The unique identifier for the email address across all of Mailchimp.
EmailType	String	True		The type of email the member asked to receive. The allowed values are html, text.
Status	String	True		The current status of the subscriber. The allowed values are subscribed, unsubscribed, cleaned, pending, transactional.
StatusIfNew	String	True		The status of the subscriber, 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		The average open rate for the subscriber.
Stats_AvgClickRate	Double	True		The average clickthrough rate for the subscriber.
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		The latitude of the subscriber's location.
Location_Longitude	Double	True		The longitude of the subscriber's location.
Location_Gmtoff	Integer	True		The GMT offset for the subscriber's location.
Location_Dstoff	Integer	True		The daylight saving time offset for the subscriber's location.
Location_CountryCode	String	True		The country code for the subscriber's location.
Location_Timezone	String	True		The time zone for the subscriber's location.
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 Mailchimp Merge Fields documentation for more about the structure.
FullName	String	True		The full name of the list member.

Pseudocolumns

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