CustomerLists
Get a set of customer lists including id and name based on the filters provided. Customer lists are a type of audience.
Table Specific Information
Select
The 本製品 uses the Pinterest API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the 本製品.
- AdAccountID supports the '=' operator.
- ID supports the '=' operator.
- Order supports the '=' operator.
Select * from CustomerLists Select * from CustomerLists where AdAccountId = '547362621403' Select * from CustomerLists where Id = '12575858432' Select * from CustomerLists where [Order] = 'ASCENDING'
Columns
| Name | Type | References | Description |
| AdAccountID | String |
AdAccounts.Id | Associated ad account ID. |
| Id | String | Customer list ID. | |
| Name | String | Customer list name. | |
| CreatedTime | Datetime | Creation time. Unix timestamp in seconds. | |
| UpdatedTime | Datetime | Last update time. Unix timestamp in seconds. | |
| NumBatches | Integer | Total number of list updates. | |
| NumRemovedUserRecords | Integer | Number of removed user records. | |
| NumUploadedUserRecords | Integer | Number of uploaded user records. | |
| Status | String | Customer list status. TOO_SMALL - the list has less than 100 Pinterest users.
使用できる値は次のとおりです。PROCESSING, READY, TOO_SMALL, UPLOADING | |
| Type | String | Always customerlist |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| Order | String | The order in which to sort the items returned: ASCENDING or DESCENDING by ID.
使用できる値は次のとおりです。ASCENDING, DESCENDING |