SSIS Components for Pinterest

Build 24.0.9062

UserAccountSummaryMetrics

Get Summary 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.
For example:
	
	SELECT * FROM UserAccountSummaryMetrics WHERE AppTypes = 'MOBILE'
    SELECT * FROM UserAccountSummaryMetrics 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.
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.

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