FeaturedTopicsTrends
Get the individual trending topics within the featured topics for a given interest and market. Child view of FeaturedTopics.
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 | = |
| Interest | = |
For example:
SELECT * FROM FeaturedTopicsTrends WHERE Region = 'US'
SELECT * FROM FeaturedTopicsTrends 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 trending topics belong to.
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. | |
| Id [KEY] | String | Unique identifier for the trending topic. | |
| Title | String | Title of the trending topic. | |
| Description | String | Description of the trending topic. | |
| PercentGrowthMom | Integer | Month-over-month growth percentage. | |
| RelatedInterests | String | List of related interest categories. | |
| RelatedSearches | String | List of related search terms. | |
| TimeSeries | String | Time series data showing trend values over time, with dates as keys and numeric values. | |
| Pins | String | Array of pin images related to this trend (up to 6). |