ProductCategoryDetails
Retrieve demographic information, related pins, and trend lines for specified product categories.
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.
ProductCategory and Region are required columns to query this view.
| Column | Supported Operators |
| ProductCategory | =, IN |
| Region | = |
| LookbackWindow | = |
| EngagementType | = |
For example:
SELECT * FROM ProductCategoryDetails WHERE ProductCategory = 'DRESSES' AND Region = 'US'
SELECT * FROM ProductCategoryDetails WHERE ProductCategory IN ('DRESSES', 'SHOES') AND Region = 'US' AND LookbackWindow = 90
Columns
| Name | Type | References | Description |
| ProductCategory [KEY] | String | The product category. Maps to the product_categories request parameter (up to 20 categories). | |
| Region | String | The geographic region of interest, formatted as ISO 3166-2 country codes delimited by '+' (for example US, GB+IE, CA). | |
| HasPrediction | Boolean | Indicates whether the product category has a prediction available for the next 90 days. | |
| Demographics | String | Demographic distribution for the product category. | |
| MetricsHighlights | String | Highlighted trend metrics for the product category. | |
| RelatedSearches | String | Related search terms for this product category. | |
| TimeSeries | String | Time series data showing trend values over time, indexed between 0 and 100. | |
| PredictedTimeSeries | String | Weekly observations of the predicted relative search volume over the next 3 months. |
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 | |
| LookbackWindow | Integer | Time period for historical data analysis in days.
The allowed values are 90, 180, 365, 730. The default value is 365. | |
| EngagementType | String | Type of engagement metric to analyze.
The allowed values are ENGAGEMENT, OUTBOUND_CLICK, SAVE. The default value is ENGAGEMENT. |