PinAnalytics
Get analytics for a Pin owned by the operation user account, or on a group board shared with this account.
View-Specific Information
SELECT
The provider 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 provider.
PinId and MetricTypes are required columns to query this view.
| Column | Supported Operators |
| PinId | = |
| StartDate | =, >, >= |
| EndDate | =, <, <= |
| AppTypes | = |
| MetricTypes | = |
| SplitField | = |
| AdAccountId | = |
For example:
SELECT * FROM PinAnalytics WHERE PinId = '813744226420795884' AND MetricTypes = 'VIDEO_MRC_VIEW'
SELECT * FROM PinAnalytics WHERE PinId = '813744226420795884' AND MetricTypes = 'VIDEO_MRC_VIEW' AND StartDate = '2024-01-01' AND EndDate = '2024-03-31'
Columns
| Name | Type | References | Description |
| PinId | String |
Pins.Id | The unique identifier of the Pin. |
| Date | Date | Metrics date (UTC): YYYY-MM-DD. | |
| DataStatus | String | Metrics availability status for the date. | |
| Impression | Integer | Total impressions. | |
| OutboundClick | Integer | Total outbound clicks. | |
| PinClick | Integer | Total Pin clicks. | |
| Save | Integer | Total saves. | |
| SaveRate | Decimal | Save rate. | |
| TotalComments | Integer | Total comments. | |
| TotalReactions | Integer | Total reactions. | |
| UserFollow | Integer | Total follows attributed to the Pin. | |
| ProfileVisit | Integer | Total profile visits attributed to the Pin. | |
| VideoMrcView | Integer | Video views (MRC standard). | |
| Video10sView | Integer | Number of times the video was played for at least 10 seconds. | |
| Quartile95PercentView | Integer | Number of times the video was played to 95 percent completion. | |
| VideoV50WatchTime | Decimal | Total play time (V50 watch time). | |
| VideoStart | Integer | Number of times the video started playing. | |
| VideoAvgWatchTime | Decimal | Average video watch time. | |
| StartDate | Date | Metric report start date (UTC). Format: YYYY-MM-DD. | |
| EndDate | Date | Metric report end date (UTC). Format: YYYY-MM-DD. |
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 | |
| AppTypes | String | Apps or devices to get data for, default is all.
The allowed values are ALL, MOBILE, TABLET, WEB. The default value is ALL. | |
| MetricTypes | String | Pin metric types to get data for. Cannot be ALL when SplitField is set to any value other than NO_SPLIT.
The allowed values are ALL, IMPRESSION, OUTBOUND_CLICK, PIN_CLICK, SAVE, SAVE_RATE, TOTAL_COMMENTS, TOTAL_REACTIONS, USER_FOLLOW, PROFILE_VISIT, VIDEO_MRC_VIEW, VIDEO_10S_VIEW, QUARTILE_95_PERCENT_VIEW, VIDEO_V50_WATCH_TIME, VIDEO_START, VIDEO_AVG_WATCH_TIME. | |
| SplitField | String | How to split the data into groups. Not including this param means data won't be split.
The allowed values are NO_SPLIT, APP_TYPE. The default value is NO_SPLIT. | |
| AdAccountId | String | Unique identifier of an ad account, used for Business Access. |