ListSegments

A list of available segments.

Table Specific Information

SELECT, INSERT, UPDATE, and DELETE are supported for ListSegments.

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.

Insert

The Name and ListID are required for INSERTs.\

INSERT INTO ListSegments (Name, ListID) VALUES ('myNewListSegment', 'myListID')

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	An integer to uniquely identify the segment.
Name	String	False	The name of the segment.
MemberCount	Integer	True	The number of active subscribers currently included in the segment.
Type	String	True	The type of segment: saved, static, or fuzzy.
CreatedAt	Datetime	True	The time and date the segment was created.
UpdatedAt	Datetime	True	The time and date the segment was last updated.
Options_Match	String	False	Match type of 'any' or 'all'.
Options_Conditions	String	False	An array of segment conditions.
ListId [KEY]	String	False	The id for the list.

Pseudo-Columns

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

Name	Type	Description
EmailList	String	A comma-separated list of emails that you want to include in this ListSegment.