CustomerLists
Get a set of customer lists including id and name based on the filters provided. Customer lists are a type of audience.
View-Specific Information
SELECT
The provider uses the Pinterest API to process WHERE clause conditions built with the following columns and operators. Any remaining filters are processed client-side within the provider.
| Column | Supported Operators |
| AdAccountID | = |
| ID | = |
| Order | = |
For example:
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 |