Tableau Connector for Mailchimp

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062