UserAccountTopVideoPinAnalytics
Get analytics data about a user's top pins.
Table Specific Information
Select
The add-in will use the Pinterest API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the add-in.
- StartDate supports the '=,>,>=' operator.
- EndDate supports the '=,<,<=' operator.
- SortBy supports the '=' operator.
- CreatedInLastNDays supports the '=' operator.
- NumOfPins supports the '=' operator.
- MetricTypes supports the '=' operator.
- AppType supports the '=' operator.
- PiFormat supports the '=' operator.
- FromClaimedContent supports the '=' operator.
SELECT * FROM UserAccountTopVideoPinAnalytics WHERE SortBy = 'IMPRESSION'
SELECT * FROM UserAccountTopVideoPinAnalytics WHERE AppType = 'ALL'
SELECT * FROM UserAccountTopVideoPinAnalytics WHERE AdAccountId = '3457832451' and StartDate >= '2024-01-06' and EndDate <= '2024-04-05'
Columns
| Name | Type | References | Description |
| StartDate | Date | Metric report start date. | |
| EndDate | Date | Metric report end date. | |
| SortBy | String | Specify sorting order for metrics.
The allowed values are IMPRESSION, SAVE, OUTBOUND_CLICK, VIDEO_MRC_VIEW, VIDEO_AVG_WATCH_TIME, VIDEO_V50_WATCH_TIME, QUARTILE_95_PERCENT_VIEW, VIDEO_10S_VIEW, VIDEO_START. | |
| Impression | Integer | Impression. | |
| Save | Integer | Save. | |
| VideoMrcView | Integer | Video second Views. | |
| VideoAvgWatchTime | Integer | Video second Views. | |
| VideoV50WatchTime | Integer | Video 50 Seond Views. | |
| Quartile95PercentView | Integer | Video 95 percent Views. | |
| Video10SView | Integer | Video 10 second Views. | |
| VideoStart | Integer | VIDEO_START. | |
| OutboundClick | Integer | Outboundclick. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| CreatedInLastNDays | Integer | Get metrics for pins created in the last | |
| NumOfPins | Integer | Number of pins to include, default is 10. Max is 50. | |
| MetricTypes | String | Metric types to get data for, default is all.
The allowed values are IMPRESSION, OUTBOUND_CLICK, SAVE, VIDEO_MRC_VIEW, VIDEO_AVG_WATCH_TIME, VIDEO_V50_WATCH_TIME, QUARTILE_95_PERCENT_VIEW, VIDEO_10S_VIEW, VIDEO_START. | |
| AppType | String | Apps or devices to get data for, default is all.
The allowed values are ALL, MOBILE, TABLET, WEB. The default value is ALL. | |
| PinFormat | String | Pin formats to get data for, default is all.
The allowed values are ALL, ORGANIC_IMAGE, ORGANIC_PRODUCT, ORGANIC_VIDEO, ADS_STANDARD, ADS_PRODUCT, ADS_VIDEO, ADS_IDEA. The default value is ALL. | |
| FromClaimedContent | String | Filter on Pins that match your claimed domain.
The allowed values are OTHER, CLAIMED, BOTH. The default value is BOTH. |