ListSegments
A list of available segments.
テーブル固有の情報
ListSegments ではSELECT、INSERT、UPDATE、およびDELETE がサポートされています。
Select
SELECT * FROM ListSegments WHERE ListId = '5152'
Insert
INSERT にはName とListId を指定する必要があります。
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
EmailList | String |
A comma-separated list of emails that you want to include in this ListSegment. |