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 add-in 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 add-in.

AdAccountID supports the '=' operator.
ID supports the '=' operator.
Order supports the '=' operator.

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

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.

Excel Add-In for Pinterest

CustomerLists

Table Specific Information

Select

Columns

Pseudo-Columns