UserAccountDailyMetrics
Get Daily Metric of User Account
Table Specific Information
Select
The 本製品 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 本製品.
- StartDate supports the '=,>,>=' operator.
- EndDate supports the '=,<,<=' operator.
- FromClaimedContent supports the '=' operator.
- PinFormat supports the '=' operator.
- AppTypes supports the '=' operator.
- MetricTypes supports the '=' operator.
- SplitFields supports the '=' operator.
- AdAccountID supports the '=' operator.
SELECT * FROM UserAccountDailyMetrics WHERE AppTypes = 'MOBILE'
SELECT * FROM UserAccountDailyMetrics WHERE AdAccountId = '3457832451' and StartDate >= '2024-01-06' and EndDate <= '2024-04-05'
Columns
| Name | Type | References | Description |
| OutboundClick | Integer | Total outbound click. | |
| OutboundClickRate | Decimal | Outbound Click Rate. | |
| Engagement | Integer | Total engagements. | |
| EngagementRate | Decimal | Engagement Rate. | |
| PinClick | Integer | Total pin clicks. | |
| PinClickRate | Decimal | Pin Click Rate. | |
| Impression | Integer | Total impressions. | |
| Save | Integer | Total saves. | |
| SaveRate | Decimal | Save Rate. | |
| DataStatus | String | Metrics Availablity. | |
| Date | Date | Metrics Date. | |
| StartDate | Date | Metric report start date. | |
| EndDate | Date | Metric report end date. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| FromClaimedContent | String | Filter on Pins that match your claimed domain.
使用できる値は次のとおりです。OTHER, CLAIMED, BOTH デフォルト値はBOTHです。 | |
| 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です。 | |
| AppTypes | String | Apps or devices to get data for, default is all.
使用できる値は次のとおりです。ALL, MOBILE, TABLET, WEB デフォルト値はALLです。 | |
| 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, ALL デフォルト値はALLです。 | |
| SplitField | String | How to split the data into groups. Not including this param means data won't be split.
使用できる値は次のとおりです。NO_SPLIT, APP_TYPE, CONTENT_TYPE, OWNED_CONTENT, SOURCE, PIN_FORMAT, CONVERSION_TYPE, ATTRIBUTION_EVENT デフォルト値はNO_SPLITです。 | |
| AdAccountID | String | Unique identifier of an ad account. |