FeaturedTopics
Pull the top trending topics by interest and market, at full parity with the Pinterest Trends UI.
View-Specific Information
SELECT
The add-in 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 add-in.
Region is a required column to query this view.
| Column | Supported Operators |
| Region | = |
| Interest | = |
For example:
SELECT * FROM FeaturedTopics WHERE Region = 'US'
SELECT * FROM FeaturedTopics WHERE Region = 'US' AND Interest = 'BEAUTY'
Columns
| Name | Type | References | Description |
| Region | String | The geographic region of interest, formatted as ISO 3166-2 country codes delimited by '+' (for example US, GB+IE, CA). | |
| Interest | String | The main interest category.
The allowed values are ALL, ANIMALS, ARCHITECTURE, ART, BEAUTY, DIY_AND_CRAFTS, EDUCATION, EVENT_PLANNING, FASHION, FOOD_AND_DRINKS, GARDENING, HEALTH, HOME_DECOR, PARENTING, TRAVEL, WEDDING. | |
| Market | String | Market code of the trending topics (for example US, GB+IE, CA).
The allowed values are US, GB+IE, CA. | |
| Trends | String | List of trending topics within this interest category. |