Adding a Connection to Pinterest

To add a connection to Pinterest:

1. In the application console, navigate to the Connections page.
2. At the Add Connections panel, select the icon for the connection you want to add.
3. If the Pinterest icon is not available, click the Add More icon to download and install the Pinterest connector from the CData site.

For required properties, see the Settings tab.

For connection properties that are not typically required, see the Advanced tab.

Connecting to Pinterest

Pinterest supports OAuth authentication only. To enable this authentication from all OAuth flows, you must create a custom OAuth application, and set AuthScheme to OAuth.

The following subsections describe how to authenticate to Pinterest from three common authentication flows:

• Desktop: a connection to a server on the user's local machine, frequently used for testing and prototyping.
• Web: access to data via a shared website.
• Headless Server: a dedicated computer that provides services to other computers and their users, which is configured to operate without a monitor and keyboard.

For information about how to create a custom OAuth application, see Creating a Custom OAuth Application.

For a complete list of connection string properties available in Pinterest, see Connection.

Automatic refresh of the OAuth access token:

To have the Sync App automatically refresh the OAuth access token:

1. Before connecting to data for the first time, set these connection parameters:
   • InitiateOAuth: REFRESH.
   • OAuthClientId: The client Id in your custom OAuth application settings.
   • OAuthClientSecret: The client secret in your custom OAuth application settings.
   • OAuthAccessToken: The access token returned by GetOAuthAccessToken.
   • OAuthSettingsLocation: The path where you want the Sync App to save the OAuth values, which persist across connections.
2. On subsequent data connections, set:
   • InitiateOAuth
   • OAuthSettingsLocation

Manual refresh of the OAuth access token:

The only value needed to manually refresh the OAuth access token is the OAuth refresh token.

1. To manually refresh the OAuthAccessToken after the ExpiresIn period (returned by GetOAuthAccessToken) has elapsed, call the RefreshOAuthAccessToken stored procedure.
2. Set these connection properties:
   • OAuthClientId: The Client Id in your custom OAuth application settings.
   • OAuthClientSecret: The Client Secret in your custom OAuth application settings.

3. Call RefreshOAuthAccessToken with OAuthRefreshToken set to the OAuth refresh token returned by GetOAuthAccessToken.
4. After the new tokens have been retrieved, set the OAuthAccessToken property to the value returned by RefreshOAuthAccessToken. This opens a new connection.

Store the OAuth refresh token so that you can use it to manually refresh the OAuth access token after it has expired.

Overview

This section shows the available API objects and provides more information on executing SQL to Pinterest APIs.

Key Features

• The Sync App models Pinterest entities like documents, folders, and groups as relational views, allowing you to write SQL to query Pinterest data.
• Stored procedures allow you to execute operations to Pinterest
• Live connectivity to these objects means any changes to your Pinterest account are immediately reflected when using the Sync App.

Views

Views describes the available views. Views are statically defined to model ... here will go view names.

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

Pinterest Connector for CData Sync Views

Name	Description
AdAccountAnalytics	Get analytics for the specified AdAccountId
AdAccountAnalyticsReport	Get the ad account analytics report
AdAccounts	Get a list of the ad_accounts that the User has access to.
AdAccountTargetingAnalytics	Get targeting analytics for an ad account.
AdAnalytics	Get analytics for the ads in the specified AdAccountId
AdCampaignAnalytics	Get analytics for the specified campaigns in the specified AdAccountId
AdGroupAnalytics	Get analytics for the ad groups in the specified AdAccountId
AdGroups	Get a list of the ad_accounts that the User has access to.
AdGroupTargetingAnalytics	Get targeting analytics for one or more ad groups.
Ads	Get a list of the ad_accounts that the User has access to.
AdsTargetingAnalytics	Get targeting analytics for one or more ads.
Boards	Get a list of the boards owned by the User
BoardSections	Get a list of the boards owned by the User
Campaigns	Get account information for the operation user_account
CampaignTargetingAnalytics	Get targeting analytics for one or more campaign.
Pins	Get a Pin owned by the owned by the User or on a group board that has been shared with this account
ProductGroupAnalytics	Get targeting analytics for one or more campaign.
TargetingTypeAgeBucket	Get a list of the age bucket which are available inside the targets.
TargetingTypeAppType	Get a list of the app type which are available inside the targets.
TargetingTypeGender	Get a list of the gender which are available inside the targets.
TargetingTypeGeo	Get a list of the geo which are available inside the targets.
TargetingTypeInterests	Get a list of the interest which are available inside the targets.
TargetingtypeLocale	Get a list of the locale which are available inside the targets.
TargetingTypeLocations	Get a list of the location which are available inside the targets.
UserAccount	Get account information for the operation User Account
UserAccountDailyMetrics	Get Daily Metric of User Account
UserAccountSummaryMetrics	Get Summary Metric of User Account
UserAccountTopVideoPinAnalytics	Get analytics data about a user's top pins.
UserTopPinAnalytics	Get analytics data about a user's top pins.

Get analytics for the specified AdAccountId

Table Specific Information

Select

The Sync App 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 Sync App.

• AdAccountId supports the '=' operator.
• StartDate supports the '=' operator.
• EndDate supports the '=' operator.
• Granularity supports the '=' operator.
• ClickWindowDays supports the '=' operator.
• EngagementWindowDays supports the '=' operator.
• ViewWindowDays supports the '=' operator.
• ConversionReportTime supports the '=' operator.

For example:

	
	SELECT * FROM AdAccountAnalytics WHERE AdAccountId = '3457832451'

Columns

Name	Type	References	Description
AdAccountId	String	AdAccounts.Id	Id of the ad account
Date	Date		Current metrics date. Only returned when granularity is a time-based value.
CampaignEntityStatus	String		Status of the campaign.
AdGroupEntityStatus	String		Status of the ad group.
SpendInDollar	Double		Total spend in dollars.
EcpcInDollar	Double		Ecpc in dollars.
Ctr	Double		Ctr.
Ectr	Double		Ectr.
EcpeInDollar	Double		Ecpe in Dollars.
EngagementRate	Double		The engagement rate.
EengagementRate	Double		E Engagement rate.
RepinRate	Double		The repin rate.
Ctr2	Double		Ctr2
CpmInDollar	Double		Cpm in Dollars.
WebCheckoutCostPerAction	Double		Web checkout cost per action.
WebCheckoutRoas	Double		Web checkout roas
PageVisitCostPerAction	Double		Page visit cost per action.
PageVisitRoas	Double		Page visit roas.
CheckoutRoas	Double		Checkout roas.
Video3secViews2	Integer		Videos with at least 3 seconds of viewing.
VideoP100Complete2	Integer		Videos 100 percent complete
VideoP0Combined2	Integer		Videos 0 percent combined viewed.
VideoP25Combined2	Integer		Videos 25 percent combined viewed.
VideoP50Combined2	Integer		Video 50 percent combined viewed.
VideoP75Combined2	Integer		Video 75 percent combined viewed.
VideoP95Combined2	Integer		Video 95 percent combined viewed.
VideoMrcViews2	Integer		Video Mrc Views.
EcpvInDollar	Double		Ecpv in dollars.
EcpcvInDollar	Double		E Cpcv in Dollars
EcpcvP95InDollar	Double		E Cpcv 95 percent in Dollars.
TotalClickthrough	Integer		Total Clickthrough.
TotalImpressionFrequency	Double		Total Impression Frequency.
TotalEngagementSignup	Integer		Total Engagement Signup.
TotalEngagementCheckout	Integer		Total Engagement Checkout.
TotalClickSignup	Integer		Total Click Signup.
TotalClickCheckout	Integer		Total Click Checkout.
TotalViewSignup	Integer		Total View Signup.
TotalViewCheckout	Integer		Total View Checkout.
TotalConversions	Integer		Total Conversions.
TotalEngagementSignupValueInMicroDollar	Double		Total Engagement Signup Value In Micro Dollar.
TotalEngagementCheckoutValueInMicroDollar	Double		Total Engagement Checkout Value In Micro Dollar.
TotalClickSignupValueInMicroDollar	Double		Total Click Signup Value In Micro Dollar.
TotalClickCheckoutValueInMicroDollar	Double		Total Click Checkout Value In Micro Dollar.
TotalViewSignupValueInMicroDollar	Double		Total View Signup Value In Micro Dollar.
TotalViewCheckoutValueInMicroDollar	Double		Total View Checkout Value In Micro Dollar.
TotalPageVisit	Integer		Total Page Visit.
TotalSignup	Integer		Total Signup.
TotalCheckout	Integer		Total Checkout.
TotalSignupValueInMicroDollar	Double		Total Signup Value In Micro Dollar.
TotalCheckoutValueInMicroDollar	Double		Total Checkout Value In Micro Dollar.
TotalVideo3secViews	Integer		Total Video 3 second Views.
TotalVideoP100Complete	Integer		Total Video 100 percent Complete.
TotalVideoP0Combined	Integer		Total Video 0 percent Combined.
TotalVideoP25Combined	Integer		Total Video 25 percent Combined.
TotalVideoP50Combined	Integer		Total Video 50 percent Combined.
TotalVideoP75Combined	Integer		Total Video 75 percent Combined.
TotalVideoP95Combined	Integer		Total Video 95 percent Combined.
TotalVideoMrcViews	Integer		Total Video Mrc Views.
TotalVideoAvgWatchtimeInSecond	Integer		Total Video Avg Watchtime In Seconds.
TotalRepinRate	Double		Total Repin Rate.
TotalWebCheckout	Integer		Total Web Checkout.
TotalWebCheckoutValueInMicroDollar	Double		Total Web Checkout Value In Micro Dollar.
TotalWebClickCheckout	Integer		Total Web Click Checkout.
TotalWebClickCheckoutValueInMicroDollar	Double		Total Web Click Checkout Value In Micro Dollar.
TotalWebEngagementCheckout	Integer		Total Web Engagement Checkout.
TotalWebEngagementCheckoutValueInMicroDollar	Double		Total Web Engagement Checkout Value In Micro Dollar.
TotalWebViewCheckout	Integer		Total Web View Checkout.
TotalWebViewCheckoutValueInMicroDollar	Double		Total Web View Checkout Value In Micro Dollar.
Clickthrough1	Integer		Clickthrough1.
Clickthrough1Gross	Integer		Clickthrough1 Gross.
Impression1	Integer		Impression1.
Impression1Gross	Integer		Impression1 Gross.
AdId	String	Ads.Id	Id of the Ad.
CampaignId	String	Campaigns.Id	Id of the Campaign.
StartDate	Date		Metric report start date.
EndDate	Date		Metric report end date.
Granularity	String		Granularity The allowed values are TOTAL, DAY, HOUR, WEEK, MONTH.

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
ClickWindowDays	Integer		Number of days to use as the conversion attribution window for a pin click action. The allowed values are 1, 7, 30, 60.
EngagementWindowDays	Integer		Number of days to use as the conversion attribution window for an engagement action. The allowed values are 1, 7, 30, 60.
ViewWindowDays	Integer		Number of days to use as the conversion attribution window for a view action. The allowed values are 1, 7, 30, 60.
ConversionReportTime	String		The date by which the conversion metrics returned from this endpoint will be reported. The allowed values are TIME_OF_AD_ACTION, TIME_OF_CONVERSION.

Get the ad account analytics report

Table Specific Information

Select

The Sync App 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 Sync App.

• AdAccountId supports the '=' operator.
• StartDate supports the '=' operator.
• EndDate supports the '=' operator.
• Granularity supports the '=' operator.
• Level supports the '=' operator.
• ClickWindowDays supports the '=' operator.
• EngagementWindowDays supports the '=' operator.
• ViewWindowDays supports the '=' operator.
• ConversionReportTime supports the '=' operator.
• AttributionTypes supports the '=' operator.
• CampaignIds supports the '=,IN' operator.
• CampaignStatuses supports the '=,IN' operator.
• CampaignObjectiveTypes supports the '=' operator.
• AdGroupIds supports the '=,IN' operator.
• AdGroupStatuses supports the '=' operator.
• AdIds supports the '=,IN' operator.
• AdStatuses supports the '=' operator.
• ProductGroupIds supports the '=,IN' operator.
• ProductGroupStatuses supports the '=,IN' operator.
• TargetingTypes supports the '=,IN' operator.
• ProductItemIds supports the '=,IN' operator.

For example:

	
	SELECT * FROM AdAccountAnalyticsReport WHERE AdAccountId = '3457832451' AND Level = 'advertiser'

Columns

Name	Type	References	Description
AdAccountId	String	AdAccounts.Id	Id of the ad account.
StartDate	Date		Metric report start date.
EndDate	Date		Metric report end date.
Granularity	String		Granularity The allowed values are TOTAL, DAY, HOUR, WEEK, MONTH.
Level	String		Level of the report. The allowed values are ADVERTISER, ADVERTISER_TARGETING, CAMPAIGN, CAMPAIGN_TARGETING, AD_GROUP, AD_GROUP_TARGETING, PIN_PROMOTION, PIN_PROMOTION_TARGETING, KEYWORD, PRODUCT_GROUP, PRODUCT_GROUP_TARGETING, PRODUCT_ITEM. The default value is ADVERTISER.
AdGroupEntityStatus	String
AdGroupId	String
AdGroupName	String
AdGroupStatus	String
AdId	String
AdName	String
AdStatus	String
AdvertiserId	String
APPINSTALLCOSTPERACTION	Integer
CAMPAIGNDAILYSPENDCAP	Integer
CAMPAIGNENTITYSTATUS	String
CAMPAIGNID	String
CAMPAIGNLIFETIMESPENDCAP	Integer
CAMPAIGNMANAGEDSTATUS	String
CAMPAIGNNAME	String
CAMPAIGNSTATUS	String
CHECKOUTROAS	String
CLICKTHROUGH1	Integer
CLICKTHROUGH1GROSS	Integer
CLICKTHROUGH2	Integer
CPCINMICRODOLLAR	Integer
CPCVINMICRODOLLAR	Integer
CPCVP95INMICRODOLLAR	Integer
CPMINDOLLAR	Integer
CPMINMICRODOLLAR	Integer
CPVINMICRODOLLAR	Integer
CTR	Integer
CTR2	Integer
ECPCINDOLLAR	Integer
ECPCINMICRODOLLAR	Integer
ECPCVINDOLLAR	Integer
ECPCVP95INDOLLAR	Integer
ECPEINDOLLAR	Integer
ECPMINMICRODOLLAR	Integer
ECPVINDOLLAR	Integer
ECTR	Integer
EENGAGEMENTRATE	Integer
ENGAGEMENT1	Integer
ENGAGEMENT2	Integer
ENGAGEMENTRATE	Integer
IDEAPINPRODUCTTAGVISIT1	String
IDEAPINPRODUCTTAGVISIT2	String
IMPRESSION1	Integer
IMPRESSION1GROSS	Integer
IMPRESSION2	Integer
INAPPADDTOCARTCOSTPERACTION	Integer
INAPPADDTOCARTROAS	String
INAPPAPPINSTALLCOSTPERACTION	Integer
INAPPAPPINSTALLROAS	String
INAPPCHECKOUTCOSTPERACTION	Integer
INAPPCHECKOUTROAS	String
INAPPSEARCHCOSTPERACTION	Integer
INAPPSEARCHROAS	String
INAPPSIGNUPCOSTPERACTION	Integer
INAPPSIGNUPROAS	String
INAPPUNKNOWNCOSTPERACTION	Integer
INAPPUNKNOWNROAS	String
OFFLINECHECKOUTCOSTPERACTION	Integer
OFFLINECHECKOUTROAS	String
OFFLINECUSTOMCOSTPERACTION	Integer
OFFLINECUSTOMROAS	String
OFFLINELEADCOSTPERACTION	Integer
OFFLINELEADROAS	String
OFFLINESIGNUPCOSTPERACTION	Integer
OFFLINESIGNUPROAS	String
OFFLINEUNKNOWNCOSTPERACTION	Integer
OFFLINEUNKNOWNROAS	String
ONSITECHECKOUTS1	Integer
OUTBOUNDCLICK1	Integer
OUTBOUNDCLICK2	Integer
PAGEVISITCOSTPERACTION	Integer
PAGEVISITROAS	String
PAIDIMPRESSION	Integer
PINID	String
PINPROMOTIONID	String
PINPROMOTIONNAME	String
PINPROMOTIONSTATUS	String
PRODUCTGROUPID	String
REPIN1	Integer
REPIN2	Integer
REPINRATE	String
SPENDINDOLLAR	Integer
SPENDINMICRODOLLAR	Integer
TOTALADDTOCARTDESKTOPACTIONTODESKTOPCONVERSION	Integer
TOTALADDTOCARTDESKTOPACTIONTOMOBILECONVERSION	Integer
TOTALADDTOCARTDESKTOPACTIONTOTABLETCONVERSION	Integer
TOTALADDTOCARTMOBILEACTIONTODESKTOPCONVERSION	Integer
TOTALADDTOCARTMOBILEACTIONTOMOBILECONVERSION	Integer
TOTALADDTOCARTMOBILEACTIONTOTABLETCONVERSION	Integer
TOTALADDTOCARTTABLETACTIONTODESKTOPCONVERSION	Integer
TOTALADDTOCARTTABLETACTIONTOMOBILECONVERSION	Integer
TOTALADDTOCARTTABLETACTIONTOTABLETCONVERSION	Integer
TOTALAPPINSTALL	Integer
TOTALAPPINSTALLDESKTOPACTIONTODESKTOPCONVERSION	Integer
TOTALAPPINSTALLDESKTOPACTIONTOMOBILECONVERSION	Integer
TOTALAPPINSTALLDESKTOPACTIONTOTABLETCONVERSION	Integer
TOTALAPPINSTALLMOBILEACTIONTODESKTOPCONVERSION	Integer
TOTALAPPINSTALLMOBILEACTIONTOMOBILECONVERSION	Integer
TOTALAPPINSTALLMOBILEACTIONTOTABLETCONVERSION	Integer
TOTALAPPINSTALLTABLETACTIONTODESKTOPCONVERSION	Integer
TOTALAPPINSTALLTABLETACTIONTOMOBILECONVERSION	Integer
TOTALAPPINSTALLTABLETACTIONTOTABLETCONVERSION	Integer
TOTALAPPINSTALLVALUEINMICRODOLLAR	Integer
TOTALCHECKOUT	Integer
TOTALCHECKOUTDESKTOPACTIONTODESKTOPCONVERSION	Integer
TOTALCHECKOUTDESKTOPACTIONTOMOBILECONVERSION	Integer
TOTALCHECKOUTDESKTOPACTIONTOTABLETCONVERSION	Integer
TOTALCHECKOUTMOBILEACTIONTODESKTOPCONVERSION	Integer
TOTALCHECKOUTMOBILEACTIONTOMOBILECONVERSION	Integer
TOTALCHECKOUTMOBILEACTIONTOTABLETCONVERSION	Integer
TOTALCHECKOUTQUANTITY	Integer
TOTALCHECKOUTTABLETACTIONTODESKTOPCONVERSION	Integer
TOTALCHECKOUTTABLETACTIONTOMOBILECONVERSION	Integer
TOTALCHECKOUTTABLETACTIONTOTABLETCONVERSION	Integer
TOTALCHECKOUTVALUEINMICRODOLLAR	Integer
TOTALCLICKADDTOCART	Integer
TOTALCLICKADDTOCARTQUANTITY	Integer
TOTALCLICKADDTOCARTVALUEINMICRODOLLAR	Integer
TOTALCLICKAPPINSTALL	Integer
TOTALCLICKAPPINSTALLVALUEINMICRODOLLAR	Integer
TOTALCLICKCHECKOUT	Integer
TOTALCLICKCHECKOUTQUANTITY	Integer
TOTALCLICKCHECKOUTVALUEINMICRODOLLAR	Integer
TOTALCLICKCUSTOM	Integer
TOTALCLICKCUSTOMQUANTITY	Integer
TOTALCLICKCUSTOMVALUEINMICRODOLLAR	Integer
TOTALCLICKLEAD	Integer
TOTALCLICKLEADQUANTITY	Integer
TOTALCLICKLEADVALUEINMICRODOLLAR	Integer
TOTALCLICKPAGEVISIT	Integer
TOTALCLICKPAGEVISITQUANTITY	Integer
TOTALCLICKPAGEVISITVALUEINMICRODOLLAR	Integer
TOTALCLICKSEARCH	Integer
TOTALCLICKSEARCHQUANTITY	Integer
TOTALCLICKSEARCHVALUEINMICRODOLLAR	Integer
TOTALCLICKSIGNUP	Integer
TOTALCLICKSIGNUPQUANTITY	Integer
TOTALCLICKSIGNUPVALUEINMICRODOLLAR	Integer
TOTALCLICKUNKNOWN	Integer
TOTALCLICKUNKNOWNQUANTITY	Integer
TOTALCLICKUNKNOWNVALUEINMICRODOLLAR	Integer
TOTALCLICKVIEWCATEGORY	String
TOTALCLICKVIEWCATEGORYQUANTITY	Integer
TOTALCLICKVIEWCATEGORYVALUEINMICRODOLLAR	Integer
TOTALCLICKWATCHVIDEO	Integer
TOTALCLICKWATCHVIDEOQUANTITY	Integer
TOTALCLICKWATCHVIDEOVALUEINMICRODOLLAR	Integer
TOTALCLICKTHROUGH	Integer
TOTALCONVERSIONS	Integer
TOTALCONVERSIONSQUANTITY	Integer
TOTALCONVERSIONSVALUEINMICRODOLLAR	Integer
TOTALCUSTOM	Integer
TOTALCUSTOMDESKTOPACTIONTODESKTOPCONVERSION	Integer
TOTALCUSTOMDESKTOPACTIONTOMOBILECONVERSION	Integer
TOTALCUSTOMDESKTOPACTIONTOTABLETCONVERSION	Integer
TOTALCUSTOMMOBILEACTIONTODESKTOPCONVERSION	Integer
TOTALCUSTOMMOBILEACTIONTOMOBILECONVERSION	Integer
TOTALCUSTOMMOBILEACTIONTOTABLETCONVERSION	Integer
TOTALCUSTOMTABLETACTIONTODESKTOPCONVERSION	Integer
TOTALCUSTOMTABLETACTIONTOMOBILECONVERSION	Integer
TOTALCUSTOMTABLETACTIONTOTABLETCONVERSION	Integer
TOTALENGAGEMENT	Integer
TOTALENGAGEMENTADDTOCART	Integer
TOTALENGAGEMENTADDTOCARTQUANTITY	Integer
TOTALENGAGEMENTADDTOCARTVALUEINMICRODOLLAR	Integer
TOTALENGAGEMENTAPPINSTALL	Integer
TOTALENGAGEMENTAPPINSTALLVALUEINMICRODOLLAR	Integer
TOTALENGAGEMENTCHECKOUT	Integer
TOTALENGAGEMENTCHECKOUTQUANTITY	Integer
TOTALENGAGEMENTCHECKOUTVALUEINMICRODOLLAR	Integer
TOTALENGAGEMENTCUSTOM	Integer
TOTALENGAGEMENTCUSTOMQUANTITY	Integer
TOTALENGAGEMENTCUSTOMVALUEINMICRODOLLAR	Integer
TOTALENGAGEMENTLEAD	Integer
TOTALENGAGEMENTLEADQUANTITY	Integer
TOTALENGAGEMENTLEADVALUEINMICRODOLLAR	Integer
TOTALENGAGEMENTPAGEVISIT	Integer
TOTALENGAGEMENTPAGEVISITQUANTITY	Integer
TOTALENGAGEMENTPAGEVISITVALUEINMICRODOLLAR	Integer
TOTALENGAGEMENTSEARCH	Integer
TOTALENGAGEMENTSEARCHQUANTITY	Integer
TOTALENGAGEMENTSEARCHVALUEINMICRODOLLAR	Integer
TOTALENGAGEMENTSIGNUP	Integer
TOTALENGAGEMENTSIGNUPQUANTITY	Integer
TOTALENGAGEMENTSIGNUPVALUEINMICRODOLLAR	Integer
TOTALENGAGEMENTUNKNOWN	Integer
TOTALENGAGEMENTUNKNOWNQUANTITY	Integer
TOTALENGAGEMENTUNKNOWNVALUEINMICRODOLLAR	Integer
TOTALENGAGEMENTVIEWCATEGORY	String
TOTALENGAGEMENTVIEWCATEGORYQUANTITY	Integer
TOTALENGAGEMENTVIEWCATEGORYVALUEINMICRODOLLAR	Integer
TOTALENGAGEMENTWATCHVIDEO	Integer
TOTALENGAGEMENTWATCHVIDEOQUANTITY	Integer
TOTALENGAGEMENTWATCHVIDEOVALUEINMICRODOLLAR	Integer
TOTALIDEAPINPRODUCTTAGVISIT	Integer
TOTALIMPRESSIONFREQUENCY	Integer
TOTALIMPRESSIONUSER	Integer
TOTALINAPPADDTOCART	String
TOTALINAPPADDTOCARTVALUEINMICRODOLLAR	Integer
TOTALINAPPAPPINSTALL	Integer
TOTALINAPPAPPINSTALLVALUEINMICRODOLLAR	Integer
TOTALINAPPCHECKOUT	Integer
TOTALINAPPCHECKOUTVALUEINMICRODOLLAR	Integer
TOTALINAPPCLICKADDTOCART	Integer
TOTALINAPPCLICKADDTOCARTVALUEINMICRODOLLAR	Integer
TOTALINAPPCLICKAPPINSTALL	Integer
TOTALINAPPCLICKAPPINSTALLVALUEINMICRODOLLAR	Integer
TOTALINAPPCLICKCHECKOUT	Integer
TOTALINAPPCLICKCHECKOUTVALUEINMICRODOLLAR	Integer
TOTALINAPPCLICKSEARCH	Integer
TOTALINAPPCLICKSEARCHVALUEINMICRODOLLAR	Integer
TOTALINAPPCLICKSIGNUP	Integer
TOTALINAPPCLICKSIGNUPVALUEINMICRODOLLAR	Integer
TOTALINAPPCLICKUNKNOWN	Integer
TOTALINAPPCLICKUNKNOWNVALUEINMICRODOLLAR	Integer
TOTALINAPPENGAGEMENTADDTOCART	Integer
TOTALINAPPENGAGEMENTADDTOCARTVALUEINMICRODOLLAR	Integer
TOTALINAPPENGAGEMENTAPPINSTALL	Integer
TOTALINAPPENGAGEMENTAPPINSTALLVALUEINMICRODOLLAR	Integer
TOTALINAPPENGAGEMENTCHECKOUT	Integer
TOTALINAPPENGAGEMENTCHECKOUTVALUEINMICRODOLLAR	Integer
TOTALINAPPENGAGEMENTSEARCH	Integer
TOTALINAPPENGAGEMENTSEARCHVALUEINMICRODOLLAR	Integer
TOTALINAPPENGAGEMENTSIGNUP	Integer
TOTALINAPPENGAGEMENTSIGNUPVALUEINMICRODOLLAR	Integer
TOTALINAPPENGAGEMENTUNKNOWN	Integer
TOTALINAPPENGAGEMENTUNKNOWNVALUEINMICRODOLLAR	Integer
TOTALINAPPSEARCH	Integer
TOTALINAPPSEARCHVALUEINMICRODOLLAR	Integer
TOTALINAPPSIGNUP	Integer
TOTALINAPPSIGNUPVALUEINMICRODOLLAR	Integer
TOTALINAPPUNKNOWN	Integer
TOTALINAPPUNKNOWNVALUEINMICRODOLLAR	Integer
TOTALINAPPVIEWADDTOCART	Integer
TOTALINAPPVIEWADDTOCARTVALUEINMICRODOLLAR	Integer
TOTALINAPPVIEWAPPINSTALL	Integer
TOTALINAPPVIEWAPPINSTALLVALUEINMICRODOLLAR	Integer
TOTALINAPPVIEWCHECKOUT	Integer
TOTALINAPPVIEWCHECKOUTVALUEINMICRODOLLAR	Integer
TOTALINAPPVIEWSEARCH	Integer
TOTALINAPPVIEWSEARCHVALUEINMICRODOLLAR	Integer
TOTALINAPPVIEWSIGNUP	Integer
TOTALINAPPVIEWSIGNUPVALUEINMICRODOLLAR	Integer
TOTALINAPPVIEWUNKNOWN	String
TOTALINAPPVIEWUNKNOWNVALUEINMICRODOLLAR	Integer
TOTALLEAD	Integer
TOTALLEADDESKTOPACTIONTODESKTOPCONVERSION	Integer
TOTALLEADDESKTOPACTIONTOMOBILECONVERSION	Integer
TOTALLEADDESKTOPACTIONTOTABLETCONVERSION	Integer
TOTALLEADMOBILEACTIONTODESKTOPCONVERSION	Integer
TOTALLEADMOBILEACTIONTOMOBILECONVERSION	Integer
TOTALLEADMOBILEACTIONTOTABLETCONVERSION	Integer
TOTALLEADTABLETACTIONTODESKTOPCONVERSION	Integer
TOTALLEADTABLETACTIONTOMOBILECONVERSION	Integer
TOTALLEADTABLETACTIONTOTABLETCONVERSION	Integer
TOTALOFFLINECHECKOUT	Integer
TOTALOFFLINECHECKOUTVALUEINMICRODOLLAR	Integer
TOTALOFFLINECLICKCHECKOUT	Integer
TOTALOFFLINECLICKCHECKOUTVALUEINMICRODOLLAR	Integer
TOTALOFFLINECLICKCUSTOM	Integer
TOTALOFFLINECLICKCUSTOMVALUEINMICRODOLLAR	Integer
TOTALOFFLINECLICKLEAD	Integer
TOTALOFFLINECLICKLEADVALUEINMICRODOLLAR	Integer
TOTALOFFLINECLICKSIGNUP	Integer
TOTALOFFLINECLICKSIGNUPVALUEINMICRODOLLAR	Integer
TOTALOFFLINECLICKUNKNOWN	Integer
TOTALOFFLINECLICKUNKNOWNVALUEINMICRODOLLAR	Integer
TOTALOFFLINECUSTOM	Integer
TOTALOFFLINECUSTOMVALUEINMICRODOLLAR	Integer
TOTALOFFLINEENGAGEMENTCHECKOUT	Integer
TOTALOFFLINEENGAGEMENTCHECKOUTVALUEINMICRODOLLAR	Integer
TOTALOFFLINEENGAGEMENTCUSTOM	Integer
TOTALOFFLINEENGAGEMENTCUSTOMVALUEINMICRODOLLAR	Integer
TOTALOFFLINEENGAGEMENTLEAD	Integer
TOTALOFFLINEENGAGEMENTLEADVALUEINMICRODOLLAR	Integer
TOTALOFFLINEENGAGEMENTSIGNUP	Integer
TOTALOFFLINEENGAGEMENTSIGNUPVALUEINMICRODOLLAR	Integer
TOTALOFFLINEENGAGEMENTUNKNOWN	Integer
TOTALOFFLINEENGAGEMENTUNKNOWNVALUEINMICRODOLLAR	Integer
TOTALOFFLINELEAD	Integer
TOTALOFFLINELEADVALUEINMICRODOLLAR	Integer
TOTALOFFLINESIGNUP	Integer
TOTALOFFLINESIGNUPVALUEINMICRODOLLAR	Integer
TOTALOFFLINEUNKNOWN	Integer
TOTALOFFLINEUNKNOWNVALUEINMICRODOLLAR	Integer
TOTALOFFLINEVIEWCHECKOUT	Integer
TOTALOFFLINEVIEWCHECKOUTVALUEINMICRODOLLAR	Integer
TOTALOFFLINEVIEWCUSTOM	Integer
TOTALOFFLINEVIEWCUSTOMVALUEINMICRODOLLAR	Integer
TOTALOFFLINEVIEWLEAD	Integer
TOTALOFFLINEVIEWLEADVALUEINMICRODOLLAR	Integer
TOTALOFFLINEVIEWSIGNUP	Integer
TOTALOFFLINEVIEWSIGNUPVALUEINMICRODOLLAR	Integer
TOTALOFFLINEVIEWUNKNOWN	Integer
TOTALOFFLINEVIEWUNKNOWNVALUEINMICRODOLLAR	Integer
TOTALPAGEVISIT	Integer
TOTALPAGEVISITDESKTOPACTIONTODESKTOPCONVERSION	Integer
TOTALPAGEVISITDESKTOPACTIONTOMOBILECONVERSION	Integer
TOTALPAGEVISITDESKTOPACTIONTOTABLETCONVERSION	Integer
TOTALPAGEVISITMOBILEACTIONTODESKTOPCONVERSION	Integer
TOTALPAGEVISITMOBILEACTIONTOMOBILECONVERSION	Integer
TOTALPAGEVISITMOBILEACTIONTOTABLETCONVERSION	Integer
TOTALPAGEVISITTABLETACTIONTODESKTOPCONVERSION	Integer
TOTALPAGEVISITTABLETACTIONTOMOBILECONVERSION	Integer
TOTALPAGEVISITTABLETACTIONTOTABLETCONVERSION	Integer
TOTALREPINRATE	Integer
TOTALSEARCHDESKTOPACTIONTODESKTOPCONVERSION	Integer
TOTALSEARCHDESKTOPACTIONTOMOBILECONVERSION	Integer
TOTALSEARCHDESKTOPACTIONTOTABLETCONVERSION	Integer
TOTALSEARCHMOBILEACTIONTODESKTOPCONVERSION	Integer
TOTALSEARCHMOBILEACTIONTOMOBILECONVERSION	Integer
TOTALSEARCHMOBILEACTIONTOTABLETCONVERSION	Integer
TOTALSEARCHTABLETACTIONTODESKTOPCONVERSION	Integer
TOTALSEARCHTABLETACTIONTOMOBILECONVERSION	Integer
TOTALSEARCHTABLETACTIONTOTABLETCONVERSION	Integer
TOTALSIGNUP	Integer
TOTALSIGNUPDESKTOPACTIONTODESKTOPCONVERSION	Integer
TOTALSIGNUPDESKTOPACTIONTOMOBILECONVERSION	Integer
TOTALSIGNUPDESKTOPACTIONTOTABLETCONVERSION	Integer
TOTALSIGNUPMOBILEACTIONTODESKTOPCONVERSION	Integer
TOTALSIGNUPMOBILEACTIONTOMOBILECONVERSION	Integer
TOTALSIGNUPMOBILEACTIONTOTABLETCONVERSION	Integer
TOTALSIGNUPTABLETACTIONTODESKTOPCONVERSION	Integer
TOTALSIGNUPTABLETACTIONTOMOBILECONVERSION	Integer
TOTALSIGNUPTABLETACTIONTOTABLETCONVERSION	Integer
TOTALSIGNUPVALUEINMICRODOLLAR	Integer
TOTALUNKNOWNDESKTOPACTIONTODESKTOPCONVERSION	Integer
TOTALUNKNOWNDESKTOPACTIONTOMOBILECONVERSION	Integer
TOTALUNKNOWNDESKTOPACTIONTOTABLETCONVERSION	Integer
TOTALUNKNOWNMOBILEACTIONTODESKTOPCONVERSION	Integer
TOTALUNKNOWNMOBILEACTIONTOMOBILECONVERSION	Integer
TOTALUNKNOWNMOBILEACTIONTOTABLETCONVERSION	Integer
TOTALUNKNOWNTABLETACTIONTODESKTOPCONVERSION	Integer
TOTALUNKNOWNTABLETACTIONTOMOBILECONVERSION	Integer
TOTALUNKNOWNTABLETACTIONTOTABLETCONVERSION	Integer
TOTALVIDEO3SECVIEWS	Integer
TOTALVIDEOAVGWATCHTIMEINSECOND	String
TOTALVIDEOMRCVIEWS	Integer
TOTALVIDEOP0COMBINED	String
TOTALVIDEOP100COMPLETE	String
TOTALVIDEOP25COMBINED	String
TOTALVIDEOP50COMBINED	String
TOTALVIDEOP75COMBINED	String
TOTALVIDEOP95COMBINED	Integer
TOTALVIEWADDTOCART	Integer
TOTALVIEWADDTOCARTQUANTITY	Integer
TOTALVIEWADDTOCARTVALUEINMICRODOLLAR	Integer
TOTALVIEWAPPINSTALL	Integer
TOTALVIEWAPPINSTALLVALUEINMICRODOLLAR	Integer
TOTALVIEWCATEGORYDESKTOPACTIONTODESKTOPCONVERSION	Integer
TOTALVIEWCATEGORYDESKTOPACTIONTOMOBILECONVERSION	Integer
TOTALVIEWCATEGORYDESKTOPACTIONTOTABLETCONVERSION	Integer
TOTALVIEWCATEGORYMOBILEACTIONTODESKTOPCONVERSION	Integer
TOTALVIEWCATEGORYMOBILEACTIONTOMOBILECONVERSION	Integer
TOTALVIEWCATEGORYMOBILEACTIONTOTABLETCONVERSION	Integer
TOTALVIEWCATEGORYTABLETACTIONTODESKTOPCONVERSION	Integer
TOTALVIEWCATEGORYTABLETACTIONTOMOBILECONVERSION	Integer
TOTALVIEWCATEGORYTABLETACTIONTOTABLETCONVERSION	Integer
TOTALVIEWCHECKOUT	Integer
TOTALVIEWCHECKOUTQUANTITY	Integer
TOTALVIEWCHECKOUTVALUEINMICRODOLLAR	Integer
TOTALVIEWCUSTOM	Integer
TOTALVIEWCUSTOMQUANTITY	Integer
TOTALVIEWCUSTOMVALUEINMICRODOLLAR	Integer
TOTALVIEWLEAD	Integer
TOTALVIEWLEADQUANTITY	Integer
TOTALVIEWLEADVALUEINMICRODOLLAR	Integer
TOTALVIEWPAGEVISIT	Integer
TOTALVIEWPAGEVISITQUANTITY	Integer
TOTALVIEWPAGEVISITVALUEINMICRODOLLAR	Integer
TOTALVIEWSEARCH	Integer
TOTALVIEWSEARCHQUANTITY	Integer
TOTALVIEWSEARCHVALUEINMICRODOLLAR	Integer
TOTALVIEWSIGNUP	Integer
TOTALVIEWSIGNUPQUANTITY	Integer
TOTALVIEWSIGNUPVALUEINMICRODOLLAR	Integer
TOTALVIEWUNKNOWN	Integer
TOTALVIEWUNKNOWNQUANTITY	Integer
TOTALVIEWUNKNOWNVALUEINMICRODOLLAR	Integer
TOTALVIEWVIEWCATEGORY	String
TOTALVIEWVIEWCATEGORYQUANTITY	Integer
TOTALVIEWVIEWCATEGORYVALUEINMICRODOLLAR	Integer
TOTALVIEWWATCHVIDEO	Integer
TOTALVIEWWATCHVIDEOQUANTITY	Integer
TOTALVIEWWATCHVIDEOVALUEINMICRODOLLAR	Integer
TOTALWATCHVIDEODESKTOPACTIONTODESKTOPCONVERSION	Integer
TOTALWATCHVIDEODESKTOPACTIONTOMOBILECONVERSION	Integer
TOTALWATCHVIDEODESKTOPACTIONTOTABLETCONVERSION	Integer
TOTALWATCHVIDEOMOBILEACTIONTODESKTOPCONVERSION	Integer
TOTALWATCHVIDEOMOBILEACTIONTOMOBILECONVERSION	Integer
TOTALWATCHVIDEOMOBILEACTIONTOTABLETCONVERSION	Integer
TOTALWATCHVIDEOTABLETACTIONTODESKTOPCONVERSION	Integer
TOTALWATCHVIDEOTABLETACTIONTOMOBILECONVERSION	Integer
TOTALWATCHVIDEOTABLETACTIONTOTABLETCONVERSION	Integer
TOTALWEBADDTOCART	Integer
TOTALWEBADDTOCARTVALUEINMICRODOLLAR	Integer
TOTALWEBCHECKOUT	Integer
TOTALWEBCHECKOUTVALUEINMICRODOLLAR	Integer
TOTALWEBCLICKADDTOCART	Integer
TOTALWEBCLICKADDTOCARTVALUEINMICRODOLLAR	Integer
TOTALWEBCLICKCHECKOUT	Integer
TOTALWEBCLICKCHECKOUTVALUEINMICRODOLLAR	Integer
TOTALWEBCLICKCUSTOM	Integer
TOTALWEBCLICKCUSTOMVALUEINMICRODOLLAR	Integer
TOTALWEBCLICKLEAD	Integer
TOTALWEBCLICKLEADVALUEINMICRODOLLAR	Integer
TOTALWEBCLICKPAGEVISIT	Integer
TOTALWEBCLICKPAGEVISITVALUEINMICRODOLLAR	Integer
TOTALWEBCLICKSEARCH	Integer
TOTALWEBCLICKSEARCHVALUEINMICRODOLLAR	Integer
TOTALWEBCLICKSIGNUP	Integer
TOTALWEBCLICKSIGNUPVALUEINMICRODOLLAR	Integer
TOTALWEBCLICKUNKNOWN	Integer
TOTALWEBCLICKUNKNOWNVALUEINMICRODOLLAR	Integer
TOTALWEBCLICKVIEWCATEGORY	String
TOTALWEBCLICKVIEWCATEGORYVALUEINMICRODOLLAR	Integer
TOTALWEBCLICKWATCHVIDEO	Integer
TOTALWEBCLICKWATCHVIDEOVALUEINMICRODOLLAR	Integer
TOTALWEBCUSTOM	Integer
TOTALWEBCUSTOMVALUEINMICRODOLLAR	Integer
TOTALWEBENGAGEMENTADDTOCART	Integer
TOTALWEBENGAGEMENTADDTOCARTVALUEINMICRODOLLAR	Integer
TOTALWEBENGAGEMENTCHECKOUT	Integer
TOTALWEBENGAGEMENTCHECKOUTVALUEINMICRODOLLAR	Integer
TOTALWEBENGAGEMENTCUSTOM	Integer
TOTALWEBENGAGEMENTCUSTOMVALUEINMICRODOLLAR	Integer
TOTALWEBENGAGEMENTLEAD	Integer
TOTALWEBENGAGEMENTLEADVALUEINMICRODOLLAR	Integer
TOTALWEBENGAGEMENTPAGEVISIT	Integer
TOTALWEBENGAGEMENTPAGEVISITVALUEINMICRODOLLAR	Integer
TOTALWEBENGAGEMENTSEARCH	Integer
TOTALWEBENGAGEMENTSEARCHVALUEINMICRODOLLAR	Integer
TOTALWEBENGAGEMENTSIGNUP	Integer
TOTALWEBENGAGEMENTSIGNUPVALUEINMICRODOLLAR	Integer
TOTALWEBENGAGEMENTUNKNOWN	Integer
TOTALWEBENGAGEMENTUNKNOWNVALUEINMICRODOLLAR	Integer
TOTALWEBENGAGEMENTVIEWCATEGORY	String
TOTALWEBENGAGEMENTVIEWCATEGORYVALUEINMICRODOLLAR	Integer
TOTALWEBENGAGEMENTWATCHVIDEO	Integer
TOTALWEBENGAGEMENTWATCHVIDEOVALUEINMICRODOLLAR	Integer
TOTALWEBLEAD	Integer
TOTALWEBLEADVALUEINMICRODOLLAR	Integer
TOTALWEBPAGEVISIT	Integer
TOTALWEBPAGEVISITVALUEINMICRODOLLAR	Integer
TOTALWEBSEARCH	Integer
TOTALWEBSEARCHVALUEINMICRODOLLAR	Integer
TOTALWEBSESSIONS	Integer
TOTALWEBSIGNUP	Integer
TOTALWEBSIGNUPVALUEINMICRODOLLAR	Integer
TOTALWEBUNKNOWN	String
TOTALWEBUNKNOWNVALUEINMICRODOLLAR	Integer
TOTALWEBVIEWADDTOCART	Integer
TOTALWEBVIEWADDTOCARTVALUEINMICRODOLLAR	Integer
TOTALWEBVIEWCATEGORY	String
TOTALWEBVIEWCATEGORYVALUEINMICRODOLLAR	Integer
TOTALWEBVIEWCHECKOUT	Integer
TOTALWEBVIEWCHECKOUTVALUEINMICRODOLLAR	Integer
TOTALWEBVIEWCUSTOM	Integer
TOTALWEBVIEWCUSTOMVALUEINMICRODOLLAR	Integer
TOTALWEBVIEWLEAD	Integer
TOTALWEBVIEWLEADVALUEINMICRODOLLAR	Integer
TOTALWEBVIEWPAGEVISIT	Integer
TOTALWEBVIEWPAGEVISITVALUEINMICRODOLLAR	Integer
TOTALWEBVIEWSEARCH	Integer
TOTALWEBVIEWSEARCHVALUEINMICRODOLLAR	Integer
TOTALWEBVIEWSIGNUP	Integer
TOTALWEBVIEWSIGNUPVALUEINMICRODOLLAR	Integer
TOTALWEBVIEWUNKNOWN	String
TOTALWEBVIEWUNKNOWNVALUEINMICRODOLLAR	Integer
TOTALWEBVIEWVIEWCATEGORY	String
TOTALWEBVIEWVIEWCATEGORYVALUEINMICRODOLLAR	Integer
TOTALWEBVIEWWATCHVIDEO	Integer
TOTALWEBVIEWWATCHVIDEOVALUEINMICRODOLLAR	Integer
TOTALWEBWATCHVIDEO	Integer
TOTALWEBWATCHVIDEOVALUEINMICRODOLLAR	Integer
VIDEO3SECVIEWS1	String
VIDEO3SECVIEWS2	String
VIDEOAVGWATCHTIMEINSECOND1	String
VIDEOAVGWATCHTIMEINSECOND2	String
VIDEOLENGTH	String
VIDEOMRCVIEWS1	String
VIDEOMRCVIEWS2	String
VIDEOP0COMBINED1	String
VIDEOP0COMBINED2	String
VIDEOP100COMPLETE1	String
VIDEOP100COMPLETE2	String
VIDEOP25COMBINED1	String
VIDEOP25COMBINED2	String
VIDEOP50COMBINED1	String
VIDEOP50COMBINED2	String
VIDEOP75COMBINED1	String
VIDEOP75COMBINED2	String
VIDEOP95COMBINED1	String
VIDEOP95COMBINED2	String
WEBADDTOCARTCOSTPERACTION	Integer
WEBADDTOCARTROAS	String
WEBCHECKOUTCOSTPERACTION	String
WEBCHECKOUTROAS	String
WEBCUSTOMCOSTPERACTION	Integer
WEBCUSTOMROAS	String
WEBLEADCOSTPERACTION	Integer
WEBLEADROAS	String
WEBPAGEVISITCOSTPERACTION	Integer
WEBPAGEVISITROAS	String
WEBSEARCHCOSTPERACTION	Integer
WEBSEARCHROAS	String
WEBSESSIONS1	String
WEBSESSIONS2	String
WEBSIGNUPCOSTPERACTION	Integer
WEBSIGNUPROAS	String
WEBUNKNOWNCOSTPERACTION	Integer
WEBUNKNOWNROAS	String
WEBVIEWCATEGORYCOSTPERACTION	Integer
WEBVIEWCATEGORYROAS	String
WEBWATCHVIDEOCOSTPERACTION	Integer
WEBWATCHVIDEOROAS	String

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
ClickWindowDays	Integer		Number of days to use as the conversion attribution window for a pin click action. The allowed values are 1, 7, 30, 60. The default value is 30.
ViewWindowDays	Integer		Number of days to use as the conversion attribution window for a view action. The allowed values are 1, 7, 30, 60. The default value is 30.
EngagementWindowDays	Integer		Number of days to use as the conversion attribution window for an engagement action. The allowed values are 1, 7, 30, 60. The default value is 30.
ConversionReportTime	String		The date by which the conversion metrics returned from this endpoint will be reported. The allowed values are TIME_OF_AD_ACTION, TIME_OF_CONVERSION. The default value is TIME_OF_AD_ACTION.
AttributionTypes	String		List of types of attribution for the conversion report The allowed values are INDIVIDUAL, HOUSEHOLD.
CampaignIds	String		Id of the campaign.
CampaignStatuses	String		List of status values for filtering The allowed values are RUNNING, PAUSED, NOT_STARTED, COMPLETED, ADVERTISER_DISABLED, ARCHIVED.
CampaignObjectiveTypes	String		List of status values for filtering The allowed values are AWARENESS, CONSIDERATION, VIDEO_VIEW WEB_CONVERSION, CATALOG_SALES, WEB_SESSIONS.
AdGroupIds	String		Id of the ad group.
AdGroupStatuses	String		Id of the ad group. The allowed values are AWARENESS, CONSIDERATION, VIDEO_VIEW WEB_CONVERSION, CATALOG_SALES, WEB_SESSIONS.
AdIds	String		List of ad ids
AdStatuses	String		List of values for filtering. The allowed values are APPROVED, AUSED, PENDING, REJECTED, ADVERTISER_DISABLED, ARCHIVED.
ProductGroupIds	String		List of product group ids.
ProductGroupStatuses	String		List of product item ids. The allowed values are RUNNING, PAUSED, EXCLUDED, ARCHIVED.
TargetingTypes	String		Targeting type The allowed values are KEYWORD, APPTYPE, GENDER, LOCATION, PLACEMENT, COUNTRY, TARGETED_INTEREST, PINNER_INTEREST, AUDIENCE_INCLUDE, GEO, AGE_BUCKET, REGION.
AdsAnalyticsMetricsFilter	String		List of metrics filters
ProductItemIds	String		List of product item ids.
AdsAnalyticsMetricsFilter	String		List of metrics filters

Get a list of the ad_accounts that the User has access to.

Table Specific Information

Select

The Sync App 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 Sync App.

• IncludeSharedAccounts supports the '=' operator.

For example:

	SELECT * FROM AdAccounts

Columns

Name	Type	References	Description
Id [KEY]	String		Id of the Ad Account.
Name	String		Name of the Ad Account.
OwnerUsername	String		Owner Usernameof the Ad Account.
Country	String		Country of the ad account.
Currency	String		Currency of the ad account.
OwnerId	String		Owner UserId of the ad account.
CreatedTime	Datetime		Created Time of the ad account.
UpdatedTime	Datetime		Updated Time of the ad account.
Permissions	String		Permissions of the ad account.

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
IncludeSharedAccounts	Boolean		Include shared ad accounts

Get targeting analytics for an ad account.

Table Specific Information

Select

The Sync App 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 Sync App.

• AdAccountId supports the '=' operator.
• StartDate supports the '=' operator.
• EndDate supports the '=' operator.
• Granularity supports the '=' operator.
• ClickWindowDays supports the '=' operator.
• EngagementWindowDays supports the '=' operator.
• ViewWindowDays supports the '=' operator.
• TargetingTypes supports the '=' operator.

For example:

	
	SELECT * FROM AdAccountTargetingAnalytics WHERE AdAccountId = '3457832451'

Columns

Name	Type	References	Description
AdAccountId	String	AdAccounts.Id	Unique identifier of an ad account.
AdGroupId	String	AdGroups.Id	Id of the ad group.
TargetingType	String		Targeting type. The allowed values are KEYWORD, APPTYPE, GENDER, LOCATION, PLACEMENT, COUNTRY, TARGETED_INTEREST, PINNER_INTEREST, AUDIENCE_INCLUDE, AUDIENCE_EXCLUDE, GEO, AGE_BUCKET, REGION.
TargetingValues	String		Targeting type value.
Date	Date		Date the analytics row covers.
SpendInDollar	Decimal		Total spend in dollars.
AdvertiserId	Double		Id of the advertiser.
AdGroupEntityStatus	Double		Id of the advertiser.
AdId	Double		Id of the advertiser.
CampaignId	String	Campaigns.Id	Id of the Campaign.
CampaignDailySpendCap	String		Campaign daily spend cap.
CampaignEntityStatus	String		Campaign entity status.
CampaignLifetimeSpendCap	Integer		Campaign Lifetime Spend Cap.
Ctr	Double		Ctr.
Ctr2	Double		Ctr2.
CheckoutRoas	Double		Checkout roas.
Clickthrough1	Integer		Clickthrough1.
Clickthrough2	Integer		Clickthrough2.
Clickthrough1Gross	Integer		Clickthrough1 Gross.
CpcInMicroDollar	Decimal		Cpc In MicroDollar.
CpmInMicroDollar	Decimal		Cpm In MicroDollar.
Ectr	Decimal		Ectr.
EcpeInDollar	Decimal		Ecpe in Dollars.
EngagementRate	Double		The engagement rate.
EengagementRate	Double		E Engagement rate.
EcpvInDollar	Decimal		Ecpv in dollars.
EcpcvInDollar	Decimal		E Cpcv in Dollars.
EcpcvP95InDollar	Decimal		E Cpcv 95 percent in Dollars.
EcpcInMicroDollar	Decimal		Ecpc In MicroDollar.
EcpmInMicroDollar	Decimal		Ecpm In MicroDollar.
Engagement1	Integer		Engagement1.
Engagement2	Integer		Engagement2.
Impression1	Integer		Impression1.
Impression1Gross	Integer		Impression1 Gross.
Impression2	Integer		Impression2.
IdeaPinProductTagVisit1	Integer		Idea Pin Product Tag Visit1.
IdeaPinProductTagVisit2	Integer		Idea Pin Product Tag Visit2.
InAppCheckoutCostPerAction	Double		In App Checkout Cost Per Action.
OutboundClick1	Integer		Outboundclick1.
OutboundClick2	Integer		Outboundclick2.
PinId	String	Pins.Id	Id of the Pins.
PageVisitCostPerAction	Double		Page visit cost per action.
PageVisitRoas	Double		Page visit roas.
PaidImpression	Integer		PaidImpression.
Repin1	Integer		Repin1.
Repin2	Integer		Repin2.
RepinRate	Double		The repin rate.
TotalClickthrough	Integer		Total Clickthrough.
TotalEngagementSignup	Integer		Total Engagement Signup.
TotalEngagementCheckout	Integer		Total Engagement Checkout.
TotalClickSignup	Integer		Total Click Signup.
TotalClickCheckout	Integer		Total Click Checkout.
TotalViewSignup	Integer		Total View Signup.
TotalViewCheckout	Integer		Total View Checkout.
TotalConversions	Integer		Total Conversions.
TotalEngagementSignupValueInMicroDollar	Decimal		Total Engagement Signup Value In Micro Dollar.
TotalEngagementCheckoutValueInMicroDollar	Decimal		Total Engagement Checkout Value In Micro Dollar.
TotalClickSignupValueInMicroDollar	Decimal		Total Click Signup Value In Micro Dollar.
TotalClickCheckoutValueInMicroDollar	Decimal		Total Click Checkout Value In Micro Dollar.
TotalViewSignupValueInMicroDollar	Decimal		Total View Signup Value In Micro Dollar.
TotalViewCheckoutValueInMicroDollar	Decimal		Total View Checkout Value In Micro Dollar.
TotalPageVisit	Integer		Total Page Visit.
TotalSignup	Integer		Total Signup.
TotalCheckout	Integer		Total Checkout.
TotalSignupValueInMicroDollar	Decimal		Total Signup Value In Micro Dollar.
TotalCheckoutValueInMicroDollar	Decimal		Total Checkout Value In Micro Dollar.
TotalVideo3secViews	Integer		Total Video 3 second Views.
TotalVideoP100Complete	Integer		Total Video 100 percent Complete.
TotalVideoP0Combined	Integer		Total Video 0 percent Combined.
TotalVideoP25Combined	Integer		Total Video 25 percent Combined.
TotalVideoP50Combined	Integer		Total Video 50 percent Combined.
TotalVideoP75Combined	Integer		Total Video 75 percent Combined.
TotalVideoP95Combined	Integer		Total Video 95 percent Combined.
TotalVideoMrcViews	Integer		Total Video Mrc Views.
TotalVideoAvgWatchtimeInSecond	Integer		Total Video Avg Watchtime In Seconds.
TotalRepinRate	Double		Total Repin Rate.
TotalWebCheckout	Integer		Total Web Checkout.
TotalWebCheckoutValueInMicroDollar	Decimal		Total Web Checkout Value In Micro Dollar.
TotalWebClickCheckout	Integer		Total Web Click Checkout.
TotalWebClickCheckoutValueInMicroDollar	Decimal		Total Web Click Checkout Value In Micro Dollar.
TotalWebEngagementCheckout	Integer		Total Web Engagement Checkout.
TotalWebEngagementCheckoutValueInMicroDollar	Decimal		Total Web Engagement Checkout Value In Micro Dollar.
TotalWebViewCheckout	Integer		Total Web View Checkout.
TotalWebViewCheckoutValueInMicroDollar	Decimal		Total Web View Checkout Value In Micro Dollar.
Video3secViews2	Integer		Video 3 second Views.
VideoLength	Integer		VideoLength.
VideoMrcViews2	Integer		Video 2 second Views.
VideoP0Combined2	Integer		Video 0 percent Combined Views.
VideoP100Complete2	Integer		Video 100 percent Complete Views.
VideoP25Combined2	Integer		Video 25 percent Complete Views.
VideoP50Combined2	Integer		Video 50 percent Complete Views.
VideoP75Combined2	Integer		Video 75 percent Complete Views.
VideoP95Combined2	Integer		Video 95 percent Complete Views.
WebCheckoutCostPerAction	Double		Web checkout cost per action.
WebCheckoutRoas	Double		Web checkout roas.
WebSessions1	Integer		WebSessions1.
WebSessions2	Integer		WebSessions2.
StartDate	Date		Metric report start date.
EndDate	Date		Metric report end date.
Granularity	String		Granularity. The allowed values are TOTAL, DAY, HOUR, WEEK, MONTH.

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
AttributionTypes	String		List of types of attribution for the conversion report. The allowed values are INDIVIDUAL, HOUSEHOLD.
ClickWindowDays	Integer		Number of days to use as the conversion attribution window for a pin click action. The allowed values are 1, 7, 30, 60.
EngagementWindowDays	Integer		Number of days to use as the conversion attribution window for an engagement action. The allowed values are 1, 7, 30, 60.
ViewWindowDays	Integer		Number of days to use as the conversion attribution window for a view action. The allowed values are 1, 7, 30, 60.
ConversionReportTime	Integer		The date by which the conversion metrics returned from this endpoint will be reported. The allowed values are TIME_OF_AD_ACTION, TIME_OF_CONVERSION.

Get analytics for the ads in the specified AdAccountId

Table Specific Information

Select

The Sync App 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 Sync App.

• AdAccountId supports the '=' operator.
• AdId supports the '=,IN' operator.
• StartDate supports the '=' operator.
• EndDate supports the '=' operator.
• Granularity supports the '=' operator.
• ClickWindowDays supports the '=' operator.
• EngagementWindowDays supports the '=' operator.
• ViewWindowDays supports the '=' operator.
• ConversionReportTime supports the '=' operator.

For example:

	
	SELECT * FROM AdAnalytics WHERE AdAccountId = '3457832451' AND AdId = '3457862457'

Columns

Name	Type	References	Description
AdId	String	Ads.Id	Id of the ad
AdAccountId	String	AdAccounts.Id	Id of the ad account
Date	Date		Current metrics date. Only returned when granularity is a time-based value.
CampaignEntityStatus	String		Status of the campaign.
AdGroupEntityStatus	String		Status of the ad group.
SpendInDollar	Double		Total spend in dollars.
EcpcInDollar	Double		Ecpc in dollars.
Ctr	Double		Ctr.
Ectr	Double		Ectr.
EcpeInDollar	Double		Ecpe in Dollars.
EngagementRate	Double		The engagement rate.
EengagementRate	Double		E Engagement rate.
RepinRate	Double		The repin rate.
Ctr2	Double		Ctr2
CpmInDollar	Double		Cpm in Dollars.
WebCheckoutCostPerAction	Double		Web checkout cost per action.
WebCheckoutRoas	Double		Web checkout roas
PageVisitCostPerAction	Double		Page visit cost per action.
PageVisitRoas	Double		Page visit roas.
CheckoutRoas	Double		Checkout roas.
Video3secViews2	Integer		Videos with at least 3 seconds of viewing.
VideoP100Complete2	Integer		Videos 100 percent complete
VideoP0Combined2	Integer		Videos 0 percent combined viewed.
VideoP25Combined2	Integer		Videos 25 percent combined viewed.
VideoP50Combined2	Integer		Video 50 percent combined viewed.
VideoP75Combined2	Integer		Video 75 percent combined viewed.
VideoP95Combined2	Integer		Video 95 percent combined viewed.
VideoMrcViews2	Integer		Video Mrc Views.
EcpvInDollar	Double		Ecpv in dollars.
EcpcvInDollar	Double		E Cpcv in Dollars
EcpcvP95InDollar	Double		E Cpcv 95 percent in Dollars.
TotalClickthrough	Integer		Total Clickthrough.
TotalImpressionFrequency	Double		Total Impression Frequency.
TotalEngagementSignup	Integer		Total Engagement Signup.
TotalEngagementCheckout	Integer		Total Engagement Checkout.
TotalClickSignup	Integer		Total Click Signup.
TotalClickCheckout	Integer		Total Click Checkout.
TotalViewSignup	Integer		Total View Signup.
TotalViewCheckout	Integer		Total View Checkout.
TotalConversions	Integer		Total Conversions.
TotalEngagementSignupValueInMicroDollar	Double		Total Engagement Signup Value In Micro Dollar.
TotalEngagementCheckoutValueInMicroDollar	Double		Total Engagement Checkout Value In Micro Dollar.
TotalClickSignupValueInMicroDollar	Double		Total Click Signup Value In Micro Dollar.
TotalClickCheckoutValueInMicroDollar	Double		Total Click Checkout Value In Micro Dollar.
TotalViewSignupValueInMicroDollar	Double		Total View Signup Value In Micro Dollar.
TotalViewCheckoutValueInMicroDollar	Double		Total View Checkout Value In Micro Dollar.
TotalPageVisit	Integer		Total Page Visit.
TotalSignup	Integer		Total Signup.
TotalCheckout	Integer		Total Checkout.
TotalSignupValueInMicroDollar	Double		Total Signup Value In Micro Dollar.
TotalCheckoutValueInMicroDollar	Double		Total Checkout Value In Micro Dollar.
TotalVideo3secViews	Integer		Total Video 3 second Views.
TotalVideoP100Complete	Integer		Total Video 100 percent Complete.
TotalVideoP0Combined	Integer		Total Video 0 percent Combined.
TotalVideoP25Combined	Integer		Total Video 25 percent Combined.
TotalVideoP50Combined	Integer		Total Video 50 percent Combined.
TotalVideoP75Combined	Integer		Total Video 75 percent Combined.
TotalVideoP95Combined	Integer		Total Video 95 percent Combined.
TotalVideoMrcViews	Integer		Total Video Mrc Views.
TotalVideoAvgWatchtimeInSecond	Integer		Total Video Avg Watchtime In Seconds.
TotalRepinRate	Double		Total Repin Rate.
TotalWebCheckout	Integer		Total Web Checkout.
TotalWebCheckoutValueInMicroDollar	Double		Total Web Checkout Value In Micro Dollar.
TotalWebClickCheckout	Integer		Total Web Click Checkout.
TotalWebClickCheckoutValueInMicroDollar	Double		Total Web Click Checkout Value In Micro Dollar.
TotalWebEngagementCheckout	Integer		Total Web Engagement Checkout.
TotalWebEngagementCheckoutValueInMicroDollar	Double		Total Web Engagement Checkout Value In Micro Dollar.
TotalWebViewCheckout	Integer		Total Web View Checkout.
TotalWebViewCheckoutValueInMicroDollar	Double		Total Web View Checkout Value In Micro Dollar.
Clickthrough1	Integer		Clickthrough1.
Clickthrough1Gross	Integer		Clickthrough1 Gross.
Impression1	Integer		Impression1.
Impression1Gross	Integer		Impression1 Gross.
CampaignId	String	Campaigns.Id	Id of the Campaign.
AdvertiserId	String		Id of the ad account
AdGroupId	String	AdGroups.Id	Id of the ad group.
CampaignDailySpendCap	Integer		Campaign daily spend cap.
CampaignLifetimeSpendCap	Integer		Campaign Lifetime Spend Cap.
CampaignName	String		Name of the Campaign
Clickthrough2	Integer		Clickthrough2.
CpcInMicroDollar	Decimal		Cpc In MicroDollar.
CpmInMicroDollar	Decimal		Cpm In MicroDollar.
EcpcInMicroDollar	Decimal		Ecpc In MicroDollar.
EcpmInMicroDollar	Decimal		Ecpm In MicroDollar.
Engagement1	Integer		Engagement1.
Engagement2	Integer		Engagement2.
IdeaPinProductTagVisit1	Integer		Idea Pin Product Tag Visit1.
IdeaPinProductTagVisit2	Integer		Idea Pin Product Tag Visit2.
Impression2	Integer		Impression2.
InAppCheckoutCostPerAction	Double		In App Checkout Cost Per Action.
OutboundClick1	Integer		Outboundclick1.
OutboundClick2	Integer		Outboundclick2.
PaidImpression	Integer		PaidImpression.
PinId	String	Pins.Id	Id of the Pins.
Repin1	Integer		Repin1.
Repin2	Integer		Repin2.
SpendInMicroDollar	Decimal		Total spend in dollars.
TotalClickAddToCart	Integer		Total click add to cart.
TotalClickLead	Integer		Total click lead.
TotalCustom	Integer		Total custom.
TotalEngagement	Integer		Total Engagement.
TotalEngagementLead	Integer		Total Engagement Lead.
TotalIdeaPinProductTagVisit	Integer		Total Idea Pin Product Tag Visit.
TotalImpressionUser	Integer		Total Impression User.
TotalLead	Integer		Total Lead.
TotalOfflineCheckout	Integer		Total offline checkout.
TotalViewAddToCart	Integer		Total view add to cart.
TotalViewLead	Integer		Total view Lead.
TotalWebSessions	Integer		Total web sessions.
VideoLength	Integer		VideoLength.
WebSessions1	Integer		WebSessions1.
WebSessions2	Integer		WebSessions2.
StartDate	Date		Metric report start date.
EndDate	Date		Metric report end date.
Granularity	String		Granularity The allowed values are TOTAL, DAY, HOUR, WEEK, MONTH.

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
ClickWindowDays	Integer		Number of days to use as the conversion attribution window for a pin click action. The allowed values are 1, 7, 30, 60.
EngagementWindowDays	Integer		Number of days to use as the conversion attribution window for an engagement action. The allowed values are 1, 7, 30, 60.
ViewWindowDays	Integer		Number of days to use as the conversion attribution window for a view action. The allowed values are 1, 7, 30, 60.
ConversionReportTime	String		The date by which the conversion metrics returned from this endpoint will be reported. The allowed values are TIME_OF_AD_ACTION, TIME_OF_CONVERSION.

Get analytics for the specified campaigns in the specified AdAccountId

Columns

Name	Type	References	Description
CampaignId	String	Campaigns.Id	Id of the campaign.
AdAccountId	String	AdAccounts.Id	Id of the ad account.
Date	Date		Date the analytics row covers.
CampaignEntityStatus	String		Status of the campaign.
AdGroupEntityStatus	String		Status of the ad group.
SpendInDollar	Double		Total spend in dollars.
EcpcInDollar	Double		Ecpc in dollars.
Ctr	Double		Ctr.
Ectr	Double		Ectr.
EcpeInDollar	Double		Ecpe in Dollars.
EngagementRate	Double		The engagement rate.
EengagementRate	Double		E Engagement rate.
RepinRate	Double		The repin rate.
Ctr2	Double		Ctr2
CpmInDollar	Double		Cpm in Dollars.
WebCheckoutCostPerAction	Double		Web checkout cost per action.
WebCheckoutRoas	Double		Web checkout roas
PageVisitCostPerAction	Double		Page visit cost per action.
PageVisitRoas	Double		Page visit roas.
CheckoutRoas	Double		Checkout roas.
Video3secViews2	Integer		Videos with at least 3 seconds of viewing.
VideoP100Complete2	Integer		Videos 100 percent complete
VideoP0Combined2	Integer		Videos 0 percent combined viewed.
VideoP25Combined2	Integer		Videos 25 percent combined viewed.
VideoP50Combined2	Integer		Video 50 percent combined viewed.
VideoP75Combined2	Integer		Video 75 percent combined viewed.
VideoP95Combined2	Integer		Video 95 percent combined viewed.
VideoMrcViews2	Integer		Video Mrc Views.
EcpvInDollar	Double		Ecpv in dollars.
EcpcvInDollar	Double		E Cpcv in Dollars
EcpcvP95InDollar	Double		E Cpcv 95 percent in Dollars.
TotalClickthrough	Integer		Total Clickthrough.
TotalImpressionFrequency	Double		Total Impression Frequency.
TotalEngagementSignup	Integer		Total Engagement Signup.
TotalEngagementCheckout	Integer		Total Engagement Checkout.
TotalClickSignup	Integer		Total Click Signup.
TotalClickCheckout	Integer		Total Click Checkout.
TotalViewSignup	Integer		Total View Signup.
TotalViewCheckout	Integer		Total View Checkout.
TotalConversions	Integer		Total Conversions.
TotalEngagementSignupValueInMicroDollar	Double		Total Engagement Signup Value In Micro Dollar.
TotalEngagementCheckoutValueInMicroDollar	Double		Total Engagement Checkout Value In Micro Dollar.
TotalClickSignupValueInMicroDollar	Double		Total Click Signup Value In Micro Dollar.
TotalClickCheckoutValueInMicroDollar	Double		Total Click Checkout Value In Micro Dollar.
TotalViewSignupValueInMicroDollar	Double		Total View Signup Value In Micro Dollar.
TotalViewCheckoutValueInMicroDollar	Double		Total View Checkout Value In Micro Dollar.
TotalPageVisit	Integer		Total Page Visit.
TotalSignup	Integer		Total Signup.
TotalCheckout	Integer		Total Checkout.
TotalSignupValueInMicroDollar	Double		Total Signup Value In Micro Dollar.
TotalCheckoutValueInMicroDollar	Double		Total Checkout Value In Micro Dollar.
TotalVideo3secViews	Integer		Total Video 3 second Views.
TotalVideoP100Complete	Integer		Total Video 100 percent Complete.
TotalVideoP0Combined	Integer		Total Video 0 percent Combined.
TotalVideoP25Combined	Integer		Total Video 25 percent Combined.
TotalVideoP50Combined	Integer		Total Video 50 percent Combined.
TotalVideoP75Combined	Integer		Total Video 75 percent Combined.
TotalVideoP95Combined	Integer		Total Video 95 percent Combined.
TotalVideoMrcViews	Integer		Total Video Mrc Views.
TotalVideoAvgWatchtimeInSecond	Integer		Total Video Avg Watchtime In Seconds.
TotalRepinRate	Double		Total Repin Rate.
TotalWebCheckout	Integer		Total Web Checkout.
TotalWebCheckoutValueInMicroDollar	Double		Total Web Checkout Value In Micro Dollar.
TotalWebClickCheckout	Integer		Total Web Click Checkout.
TotalWebClickCheckoutValueInMicroDollar	Double		Total Web Click Checkout Value In Micro Dollar.
TotalWebEngagementCheckout	Integer		Total Web Engagement Checkout.
TotalWebEngagementCheckoutValueInMicroDollar	Double		Total Web Engagement Checkout Value In Micro Dollar.
TotalWebViewCheckout	Integer		Total Web View Checkout.
TotalWebViewCheckoutValueInMicroDollar	Double		Total Web View Checkout Value In Micro Dollar.
Clickthrough1	Integer		Clickthrough1.
Clickthrough1Gross	Integer		Clickthrough1 Gross.
Impression1	Integer		Impression1.
Impression1Gross	Integer		Impression1 Gross.
AdId	String	Ads.Id	Id of the Ad.
StartDate	Date		Metric report start date.
EndDate	Date		Metric report end date.
Granularity	String		Granularity The allowed values are TOTAL, DAY, HOUR, WEEK, MONTH.

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
ClickWindowDays	Integer		Number of days to use as the conversion attribution window for a pin click action. The allowed values are 1, 7, 30, 60.
EngagementWindowDays	Integer		Number of days to use as the conversion attribution window for an engagement action. The allowed values are 1, 7, 30, 60.
ViewWindowDays	Integer		Number of days to use as the conversion attribution window for a view action. The allowed values are 1, 7, 30, 60.
ConversionReportTime	String		The date by which the conversion metrics returned from this endpoint will be reported. The allowed values are TIME_OF_AD_ACTION, TIME_OF_CONVERSION.

Get analytics for the ad groups in the specified AdAccountId

Table Specific Information

Select

The Sync App 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 Sync App.

• AdAccountId supports the '=' operator.
• AdGroupId supports the '=,IN' operator.
• StartDate supports the '=' operator.
• EndDate supports the '=' operator.
• Granularity supports the '=' operator.
• ClickWindowDays supports the '=' operator.
• EngagementWindowDays supports the '=' operator.
• ViewWindowDays supports the '=' operator.
• ConversionReportTime supports the '=' operator.

For example:

	
	SELECT * FROM AdGroupAnalytics WHERE AdAccountId = '3457832451' AND AdGroupId = '3457862457'

Columns

Name	Type	References	Description
AdGroupId	String	AdGroups.Id	Id of the ad group.
AdAccountId	String	AdAccounts.Id	Id of the ad account.
Date	Date		Date the analytics row covers.
CampaignEntityStatus	String		Status of the campaign.
AdGroupEntityStatus	String		Status of the ad group.
SpendInDollar	Double		Total spend in dollars.
EcpcInDollar	Double		Ecpc in dollars.
Ctr	Double		Ctr.
Ectr	Double		Ectr.
EcpeInDollar	Double		Ecpe in Dollars.
EngagementRate	Double		The engagement rate.
EengagementRate	Double		E Engagement rate.
RepinRate	Double		The repin rate.
Ctr2	Double		Ctr2
CpmInDollar	Double		Cpm in Dollars.
WebCheckoutCostPerAction	Double		Web checkout cost per action.
WebCheckoutRoas	Double		Web checkout roas
PageVisitCostPerAction	Double		Page visit cost per action.
PageVisitRoas	Double		Page visit roas.
CheckoutRoas	Double		Checkout roas.
Video3secViews2	Integer		Videos with at least 3 seconds of viewing.
VideoP100Complete2	Integer		Videos 100 percent complete
VideoP0Combined2	Integer		Videos 0 percent combined viewed.
VideoP25Combined2	Integer		Videos 25 percent combined viewed.
VideoP50Combined2	Integer		Video 50 percent combined viewed.
VideoP75Combined2	Integer		Video 75 percent combined viewed.
VideoP95Combined2	Integer		Video 95 percent combined viewed.
VideoMrcViews2	Integer		Video Mrc Views.
EcpvInDollar	Double		Ecpv in dollars.
EcpcvInDollar	Double		E Cpcv in Dollars
EcpcvP95InDollar	Double		E Cpcv 95 percent in Dollars.
TotalClickthrough	Integer		Total Clickthrough.
TotalImpressionFrequency	Double		Total Impression Frequency.
TotalEngagementSignup	Integer		Total Engagement Signup.
TotalEngagementCheckout	Integer		Total Engagement Checkout.
TotalClickSignup	Integer		Total Click Signup.
TotalClickCheckout	Integer		Total Click Checkout.
TotalViewSignup	Integer		Total View Signup.
TotalViewCheckout	Integer		Total View Checkout.
TotalConversions	Integer		Total Conversions.
TotalEngagementSignupValueInMicroDollar	Double		Total Engagement Signup Value In Micro Dollar.
TotalEngagementCheckoutValueInMicroDollar	Double		Total Engagement Checkout Value In Micro Dollar.
TotalClickSignupValueInMicroDollar	Double		Total Click Signup Value In Micro Dollar.
TotalClickCheckoutValueInMicroDollar	Double		Total Click Checkout Value In Micro Dollar.
TotalViewSignupValueInMicroDollar	Double		Total View Signup Value In Micro Dollar.
TotalViewCheckoutValueInMicroDollar	Double		Total View Checkout Value In Micro Dollar.
TotalPageVisit	Integer		Total Page Visit.
TotalSignup	Integer		Total Signup.
TotalCheckout	Integer		Total Checkout.
TotalSignupValueInMicroDollar	Double		Total Signup Value In Micro Dollar.
TotalCheckoutValueInMicroDollar	Double		Total Checkout Value In Micro Dollar.
TotalVideo3secViews	Integer		Total Video 3 second Views.
TotalVideoP100Complete	Integer		Total Video 100 percent Complete.
TotalVideoP0Combined	Integer		Total Video 0 percent Combined.
TotalVideoP25Combined	Integer		Total Video 25 percent Combined.
TotalVideoP50Combined	Integer		Total Video 50 percent Combined.
TotalVideoP75Combined	Integer		Total Video 75 percent Combined.
TotalVideoP95Combined	Integer		Total Video 95 percent Combined.
TotalVideoMrcViews	Integer		Total Video Mrc Views.
TotalVideoAvgWatchtimeInSecond	Integer		Total Video Avg Watchtime In Seconds.
TotalRepinRate	Double		Total Repin Rate.
TotalWebCheckout	Integer		Total Web Checkout.
TotalWebCheckoutValueInMicroDollar	Double		Total Web Checkout Value In Micro Dollar.
TotalWebClickCheckout	Integer		Total Web Click Checkout.
TotalWebClickCheckoutValueInMicroDollar	Double		Total Web Click Checkout Value In Micro Dollar.
TotalWebEngagementCheckout	Integer		Total Web Engagement Checkout.
TotalWebEngagementCheckoutValueInMicroDollar	Double		Total Web Engagement Checkout Value In Micro Dollar.
TotalWebViewCheckout	Integer		Total Web View Checkout.
TotalWebViewCheckoutValueInMicroDollar	Double		Total Web View Checkout Value In Micro Dollar.
Clickthrough1	Integer		Clickthrough1.
Clickthrough1Gross	Integer		Clickthrough1 Gross.
Impression1	Integer		Impression1.
Impression1Gross	Integer		Impression1 Gross.
Impression2	Integer		Impression2.
TotalImpressionUser	Integer		Total ImpressionUser.
CampaignDailySpendCap	Integer		Campaign Daily Spend Cap.
CampaignLifetimeSpendCap	Integer		Campaign Lifetime Spend Cap.
Clickthrough2	Integer		Clickthrough2.
CpcInMicroDollar	Double		Cpc In MicroDollar.
CpmInMicroDollar	Double		Cpm In MicroDollar.
EcpcInMicroDollar	Double		Ecpc In MicroDollar.
EcpmInMicroDollar	Double		Ecpm In MicroDollar.
Engagement1	Integer		Engagement1.
Engagement2	Integer		Engagement2.
IdeaPinProductTagVisit1	Integer		Idea Pin Product Tag Visit1.
IdeaPinProductTagVisit2	Integer		Idea Pin Product Tag Visit2.
InAppCheckoutCostPerAction	Double		In App Checkout Cost Per Action.
OutboundClick1	Integer		Outboundclick1.
OutboundClick2	Integer		Outboundclick2.
PaidImpression	Integer		PaidImpression.
Repin1	Integer		Repin1.
Repin2	Integer		Repin2.
SpendInMicroDollar	Double		Spend In MicroDollar.
TotalClickAddToCart	Integer		Total Click Add To Cart.
TotalClickLead	Integer		Total ClickLead.
TotalCustom	Integer		Total Custom.
TotalEngagement	Integer		Total Engagement.
TotalEngagementLead	Integer		Total Engagement Lead.
TotalIdeaPinProductTagVisit	Integer		Total Idea Pin Product Tag Visit.
TotalLead	Integer		Total Lead.
TotalOfflineCheckout	Integer		Total Offline Checkout.
TotalViewAddToCart	Integer		Total View Add To Cart.
TotalViewLead	Integer		Total View Lead.
TotalWebSessions	Integer		Total Web Sessions.
VideoLength	Integer		VideoLength.
WebSessions1	Integer		WebSessions1.
WebSessions2	Integer		WebSessions2.
AdId	String	Ads.Id	Id of the Ad.
CampaignId	String	Campaigns.Id	Id of the Campaign.
StartDate	Date		Metric report start date.
EndDate	Date		Metric report end date.
Granularity	String		Granularity The allowed values are TOTAL, DAY, HOUR, WEEK, MONTH.

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
ClickWindowDays	Integer		Number of days to use as the conversion attribution window for a pin click action. The allowed values are 1, 7, 30, 60.
EngagementWindowDays	Integer		Number of days to use as the conversion attribution window for an engagement action. The allowed values are 1, 7, 30, 60.
ViewWindowDays	Integer		Number of days to use as the conversion attribution window for a view action. The allowed values are 1, 7, 30, 60.
ConversionReportTime	Integer		The date by which the conversion metrics returned from this endpoint will be reported. The allowed values are TIME_OF_AD_ACTION, TIME_OF_CONVERSION.

Get a list of the ad_accounts that the User has access to.

Table Specific Information

Select

The Sync App 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 Sync App.

• AdAccountId supports the '=' operator.
• Id supports the '=,IN' operator.
• Status supports the '=' operator.
• TranslateInterestsToNames supports the '=' operator.

For example:

	
	SELECT * FROM AdGroups WHERE AdAccountId = '3457832451'

Columns

Name	Type	References	Description
Id [KEY]	String		Advertiser ID.
AdAccountId	String	AdAccounts.Id	Ad Account ID.
CampaignId	String	Campaigns.Id	Campaign ID of the ad group.
FeedProfileId	String		Feed Profile ID associated to the adgroup.
AutoTargetingEnabled	Boolean		Enable auto-targeting for ad group.
BidInMicroCurrency	Integer		Bid price in micro currency.
BillableEvent	String		Ad group billable event type.
BudgetInMicroCurrency	Integer		Budget in micro currency.
BudgetType	String		Budget type
ConversionLearningModeType	String		oCPM learn mode
CreatedTime	Datetime		Ad group creation time.
EndTime	Datetime		Ad group end time.
LifetimeFrequencyCap	Integer		Set a limit to the number of times a promoted pin from this campaign can be impressed by a pinner within the past rolling 30 days.
Name	String		Ad group name.
PacingDeliveryType	String		PacingDeliveryType
PlacementGroup	String		PlacementGroup
StartTime	Datetime		Ad group start time
Status	String		Ad group/entity status. The allowed values are ACTIVE, PAUSED, ARCHIVED.
SummaryStatus	String		Ad group summary status.
TargetingSpec	String		Ad group targeting specification defining the ad group target audience.
TrackingUrlsAudienceVerification	String		Third-party tracking URLs.
TrackingUrlsBuyableButton	String		Third-party tracking URLs.
TrackingUrlsClick	String		Third-party tracking URLs.
TrackingUrlsEngagement	String		Third-party tracking URLs.
TrackingUrlsImpression	String		Third-party tracking URLs.
Type	String		Type of ad group.
UpdatedTime	Datetime		Ad group last update time.

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
TranslateInterestsToNames	Boolean		Return interests as text names and not topic IDs?

Get targeting analytics for one or more ad groups.

Table Specific Information

Select

The Sync App 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 Sync App.

• AdAccountId supports the '=' operator.
• AdGroupId supports the '=,IN' operators.
• TargetingType supports the '=' operator.
• StartDate supports the '=' operator.
• EndDate supports the '=' operator.
• Granularity supports the '=' operator.
• ClickWindowDays supports the '=' operator.
• EngagementWindowDays supports the '=' operator.
• ViewWindowDays supports the '=' operator.
• ConversionReportTime supports the '=' operator.

For example:

	
	SELECT * FROM AdGroupTargetingAnalytics WHERE TargetingType = 'LOCATION'

Columns

Name	Type	References	Description
AdAccountId	String	AdAccounts.Id	Unique identifier of an ad account.
AdGroupId	String	AdGroups.Id	Id of the ad group.
TargetingType	String		Targeting type. The allowed values are KEYWORD, APPTYPE, GENDER, LOCATION, PLACEMENT, COUNTRY, TARGETED_INTEREST, PINNER_INTEREST, AUDIENCE_INCLUDE, AUDIENCE_EXCLUDE, GEO, AGE_BUCKET, REGION.
TargetingValues	String		Targeting type value.
Date	Date		Date the analytics row covers.
SpendInDollar	Decimal		Total spend in dollars.
AdvertiserId	Double		Id of the advertiser.
AdGroupEntityStatus	Double		Id of the advertiser.
AdId	Double		Id of the advertiser.
CampaignId	String	Campaigns.Id	Id of the Campaign.
CampaignDailySpendCap	String		Campaign daily spend cap.
CampaignEntityStatus	String		Campaign entity status.
CampaignLifetimeSpendCap	Integer		Campaign Lifetime Spend Cap.
Ctr	Double		Ctr.
Ctr2	Double		Ctr2.
CheckoutRoas	Double		Checkout roas.
Clickthrough1	Integer		Clickthrough1.
Clickthrough2	Integer		Clickthrough2.
Clickthrough1Gross	Integer		Clickthrough1 Gross.
CpcInMicroDollar	Decimal		Cpc In MicroDollar.
CpmInMicroDollar	Decimal		Cpm In MicroDollar.
Ectr	Decimal		Ectr.
EcpeInDollar	Decimal		Ecpe in Dollars.
EngagementRate	Double		The engagement rate.
EengagementRate	Double		E Engagement rate.
EcpvInDollar	Decimal		Ecpv in dollars.
EcpcvInDollar	Decimal		E Cpcv in Dollars.
EcpcvP95InDollar	Decimal		E Cpcv 95 percent in Dollars.
EcpcInMicroDollar	Decimal		Ecpc In MicroDollar.
EcpmInMicroDollar	Decimal		Ecpm In MicroDollar.
Engagement1	Integer		Engagement1.
Engagement2	Integer		Engagement2.
Impression1	Integer		Impression1.
Impression1Gross	Integer		Impression1 Gross.
Impression2	Integer		Impression2.
IdeaPinProductTagVisit1	Integer		Idea Pin Product Tag Visit1.
IdeaPinProductTagVisit2	Integer		Idea Pin Product Tag Visit2.
InAppCheckoutCostPerAction	Double		In App Checkout Cost Per Action.
OutboundClick1	Integer		Outboundclick1.
OutboundClick2	Integer		Outboundclick2.
PinId	String	Pins.Id	Id of the Pins.
PageVisitCostPerAction	Double		Page visit cost per action.
PageVisitRoas	Double		Page visit roas.
PaidImpression	Integer		PaidImpression.
Repin1	Integer		Repin1.
Repin2	Integer		Repin2.
RepinRate	Double		The repin rate.
TotalClickthrough	Integer		Total Clickthrough.
TotalEngagementSignup	Integer		Total Engagement Signup.
TotalEngagementCheckout	Integer		Total Engagement Checkout.
TotalClickSignup	Integer		Total Click Signup.
TotalClickCheckout	Integer		Total Click Checkout.
TotalViewSignup	Integer		Total View Signup.
TotalViewCheckout	Integer		Total View Checkout.
TotalConversions	Integer		Total Conversions.
TotalEngagementSignupValueInMicroDollar	Decimal		Total Engagement Signup Value In Micro Dollar.
TotalEngagementCheckoutValueInMicroDollar	Decimal		Total Engagement Checkout Value In Micro Dollar.
TotalClickSignupValueInMicroDollar	Decimal		Total Click Signup Value In Micro Dollar.
TotalClickCheckoutValueInMicroDollar	Decimal		Total Click Checkout Value In Micro Dollar.
TotalViewSignupValueInMicroDollar	Decimal		Total View Signup Value In Micro Dollar.
TotalViewCheckoutValueInMicroDollar	Decimal		Total View Checkout Value In Micro Dollar.
TotalPageVisit	Integer		Total Page Visit.
TotalSignup	Integer		Total Signup.
TotalCheckout	Integer		Total Checkout.
TotalSignupValueInMicroDollar	Decimal		Total Signup Value In Micro Dollar.
TotalCheckoutValueInMicroDollar	Decimal		Total Checkout Value In Micro Dollar.
TotalVideo3secViews	Integer		Total Video 3 second Views.
TotalVideoP100Complete	Integer		Total Video 100 percent Complete.
TotalVideoP0Combined	Integer		Total Video 0 percent Combined.
TotalVideoP25Combined	Integer		Total Video 25 percent Combined.
TotalVideoP50Combined	Integer		Total Video 50 percent Combined.
TotalVideoP75Combined	Integer		Total Video 75 percent Combined.
TotalVideoP95Combined	Integer		Total Video 95 percent Combined.
TotalVideoMrcViews	Integer		Total Video Mrc Views.
TotalVideoAvgWatchtimeInSecond	Integer		Total Video Avg Watchtime In Seconds.
TotalRepinRate	Double		Total Repin Rate.
TotalWebCheckout	Integer		Total Web Checkout.
TotalWebCheckoutValueInMicroDollar	Decimal		Total Web Checkout Value In Micro Dollar.
TotalWebClickCheckout	Integer		Total Web Click Checkout.
TotalWebClickCheckoutValueInMicroDollar	Decimal		Total Web Click Checkout Value In Micro Dollar.
TotalWebEngagementCheckout	Integer		Total Web Engagement Checkout.
TotalWebEngagementCheckoutValueInMicroDollar	Decimal		Total Web Engagement Checkout Value In Micro Dollar.
TotalWebViewCheckout	Integer		Total Web View Checkout.
TotalWebViewCheckoutValueInMicroDollar	Decimal		Total Web View Checkout Value In Micro Dollar.
Video3secViews2	Integer		Video 3 second Views.
VideoLength	Integer		VideoLength.
VideoMrcViews2	Integer		Video 2 second Views.
VideoP0Combined2	Integer		Video 0 percent Combined Views.
VideoP100Complete2	Integer		Video 100 percent Complete Views.
VideoP25Combined2	Integer		Video 25 percent Complete Views.
VideoP50Combined2	Integer		Video 50 percent Complete Views.
VideoP75Combined2	Integer		Video 75 percent Complete Views.
VideoP95Combined2	Integer		Video 95 percent Complete Views.
WebCheckoutCostPerAction	Double		Web checkout cost per action.
WebCheckoutRoas	Double		Web checkout roas.
WebSessions1	Integer		WebSessions1.
WebSessions2	Integer		WebSessions2.
StartDate	Date		Metric report start date.
EndDate	Date		Metric report end date.
Granularity	String		Granularity. The allowed values are TOTAL, DAY, HOUR, WEEK, MONTH.

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
AttributionTypes	String		List of types of attribution for the conversion report. The allowed values are INDIVIDUAL, HOUSEHOLD.
ClickWindowDays	Integer		Number of days to use as the conversion attribution window for a pin click action. The allowed values are 1, 7, 30, 60.
EngagementWindowDays	Integer		Number of days to use as the conversion attribution window for an engagement action. The allowed values are 1, 7, 30, 60.
ViewWindowDays	Integer		Number of days to use as the conversion attribution window for a view action. The allowed values are 1, 7, 30, 60.
ConversionReportTime	Integer		The date by which the conversion metrics returned from this endpoint will be reported. The allowed values are TIME_OF_AD_ACTION, TIME_OF_CONVERSION.