Excel Add-In for Pinterest

Build 24.0.9062

UserAccountTopVideoPinAnalytics

Get analytics data about a user's top pins.

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.
  • 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.
For example:
	
	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.

使用できる値は次のとおりです。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

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.

使用できる値は次のとおりです。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.

使用できる値は次のとおりです。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です。

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062