TrendingProductCategories
Get a list of growing shopping product categories in ranked order, with filtering by engagement type, vertical, age, and gender.
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.
Region is a required column to query this view.
| Column | Supported Operators |
| Region | = |
| EngagementType | = |
| Verticals | =, IN |
| Ages | =, IN |
| Genders | =, IN |
For example:
SELECT * FROM TrendingProductCategories WHERE Region = 'US'
SELECT * FROM TrendingProductCategories WHERE Region = 'US' AND EngagementType = 'SAVE' AND Verticals = 'FASHION'
Columns
| Name | Type | References | Description |
| PinterestProductCategoryId [KEY] | Integer | Pinterest product category ID. | |
| Region | String | The geographic region of interest, formatted as ISO 3166-2 country codes delimited by '+' (for example US, GB+IE, CA). | |
| ProductCategory | String | Product category name. | |
| EngagementType | String | Type of engagement metric to analyze.
The allowed values are ENGAGEMENT, OUTBOUND_CLICK, SAVE. The default value is ENGAGEMENT. | |
| PctChangeMom | Decimal | Month-over-month change percentage. | |
| PercentRelativeVolume | Decimal | Relative volume percentage. | |
| Verticals | String | Vertical names associated with the product category.
The allowed values are FASHION, HOME_DECOR, BEAUTY. |
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 | |
| Ages | String | Age buckets to filter by. If not provided, all ages are included.
The allowed values are 18-24, 25-34, 35-44, 45-49, 50-54, 55-64, 65+. | |
| Genders | String | Genders to filter by. If not provided, all genders are included.
The allowed values are MALE, FEMALE, UNSPECIFIED. |