CData Python Connector for Pinterest

Build 23.0.8839

UserAccountTopVideoPinAnalytics

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.
For example:
	
	SELECT * FROM UserAccountTopVideoPinAnalytics WHERE SortBy = 'IMPRESSION'
    SELECT * FROM UserAccountTopVideoPinAnalytics WHERE AppType = 'ALL'

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.
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 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.

The allowed values are ALL, MOBILE, TABLET, WEB.

The default value is ALL.

PiFormat String Pin formats to get data for, default is all.

The allowed values are ALL, PRODUCT, REGULAR, VIDEO.

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.

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