UserTopPinAnalytics
Get analytics data about a user's top pins.
Table Specific Information
Select
The connector 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 connector.
- 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 UserTopPinAnalytics WHERE SortBy = 'IMPRESSION'
SELECT * FROM UserTopPinAnalytics WHERE AppType = 'ALL'
SELECT * FROM UserTopPinAnalytics 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.
使用できる値は次のとおりです。ENGAGEMENT, IMPRESSION, OUTBOUND_CLICK, PIN_CLICK, SAVE | |
| Engagement | Integer | Engagement. | |
| EngagementRate | Double | The engagement rate. | |
| Impression | Integer | Impression. | |
| OutboundClick | Integer | Outboundclick. | |
| OutboundClickRate | Integer | OUTBOUNDCLICKRATE. | |
| PinClick | Integer | PINCLICK. | |
| PinClickRate | Integer | PINCLICKRate. | |
| Save | Integer | Save. | |
| SaveRate | Integer | SAVE RATE. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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.
使用できる値は次のとおりです。ENGAGEMENT, ENGAGEMENT_RATE, IMPRESSION, OUTBOUND_CLICK, OUTBOUND_CLICK_RATE, PIN_CLICK, PIN_CLICK_RATE, SAVE, SAVE_RATE | |
| AppType | String | Apps or devices to get data for, default is all.
使用できる値は次のとおりです。ALL, MOBILE, TABLET, WEB デフォルト値はALLです。 | |
| PinFormat | String | Pin formats to get data for, default is all.
使用できる値は次のとおりです。ALL, ORGANIC_IMAGE, ORGANIC_PRODUCT, ORGANIC_VIDEO, ADS_STANDARD, ADS_PRODUCT, ADS_VIDEO, ADS_IDEA デフォルト値はALLです。 | |
| FromClaimedContent | String | Filter on Pins that match your claimed domain.
使用できる値は次のとおりです。OTHER, CLAIMED, BOTH デフォルト値はBOTHです。 |