Labels
See a list of labels for assets that your account owns, filtered by different criteria. If no filter is provided, it defaults to labels associated with the ad account.
View-Specific Information
SELECT
The connector 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 connector.
| Column | Supported Operators |
| AdAccountId | = |
| Id | =, IN |
| LabelType | =, IN |
| Status | =, IN |
| CampaignIds | =, IN |
For example:
SELECT * FROM Labels WHERE AdAccountId = '549768561505'
SELECT * FROM Labels WHERE AdAccountId = '549768561505' AND LabelType = 'CUSTOM' AND Status = 'ACTIVE'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Label ID. | |
| AdAccountId | String |
AdAccounts.Id | The unique identifier of the ad account this label belongs to. |
| Value | String | Label name. 100-character limit. | |
| LabelType | String | Category for the labeled items. Defaults to BRAND server-side when omitted.
The allowed values are BRAND, CUSTOM. | |
| Status | String | Label entity status. Defaults to ACTIVE server-side when omitted.
The allowed values are ACTIVE, ARCHIVED. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| CampaignIds | String | List of campaign IDs to use to filter the results. |