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 connector will use 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 connector.
- 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.
The allowed values are PROCESSING, READY, TOO_SMALL, UPLOADING. | |
| Type | String | Always customerlist |
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 | |
| Order | String | The order in which to sort the items returned: ASCENDING or DESCENDING by ID.
The allowed values are ASCENDING, DESCENDING. |