Excel Add-In for Pinterest

Build 24.0.9062

AdAccountAnalyticsReport

Get the ad account analytics report

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 本製品.

  • 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

使用できる値は次のとおりです。TOTAL, DAY, HOUR, WEEK, MONTH

Level String Level of the report.

使用できる値は次のとおりです。ADVERTISER, ADVERTISER_TARGETING, CAMPAIGN, CAMPAIGN_TARGETING, AD_GROUP, AD_GROUP_TARGETING, PIN_PROMOTION, PIN_PROMOTION_TARGETING, KEYWORD, PRODUCT_GROUP, PRODUCT_GROUP_TARGETING, PRODUCT_ITEM, PRODUCT_ITEM_TARGETING

デフォルト値は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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
ClickWindowDays Integer Number of days to use as the conversion attribution window for a pin click action.

使用できる値は次のとおりです。1, 7, 14, 30, 60

デフォルト値は30です。

ViewWindowDays Integer Number of days to use as the conversion attribution window for a view action.

使用できる値は次のとおりです。1, 7, 14, 30, 60

デフォルト値は1です。

EngagementWindowDays Integer Number of days to use as the conversion attribution window for an engagement action.

使用できる値は次のとおりです。1, 7, 14, 30, 60

デフォルト値は30です。

ConversionReportTime String The date by which the conversion metrics returned from this endpoint will be reported.

使用できる値は次のとおりです。TIME_OF_AD_ACTION, TIME_OF_CONVERSION

デフォルト値はTIME_OF_AD_ACTIONです。

AttributionTypes String List of types of attribution for the conversion report

使用できる値は次のとおりです。INDIVIDUAL, HOUSEHOLD

CampaignIds String Id of the campaign.
CampaignStatuses String List of status values for filtering

使用できる値は次のとおりです。RUNNING, PAUSED, NOT_STARTED, COMPLETED, ADVERTISER_DISABLED, ARCHIVED, DRAFT, DELETED_DRAFT

CampaignObjectiveTypes String List of status values for filtering

使用できる値は次のとおりです。AWARENESS, CONSIDERATION, VIDEO_VIEW, WEB_CONVERSION, CATALOG_SALES, WEB_SESSIONS, VIDEO_COMPLETION

AdGroupIds String Id of the ad group.
AdGroupStatuses String List of values for filtering.

使用できる値は次のとおりです。RUNNING, PAUSED, NOT_STARTED, COMPLETED, ADVERTISER_DISABLED, ARCHIVED, DRAFT, DELETED_DRAFT

AdIds String List of ad ids
AdStatuses String List of values for filtering.

使用できる値は次のとおりです。APPROVED, PAUSED, PENDING, REJECTED, ADVERTISER_DISABLED, ARCHIVED, DRAFT, DELETED_DRAFT

ProductGroupIds String List of product group ids.
ProductGroupStatuses String List of values for filtering.

使用できる値は次のとおりです。RUNNING, PAUSED, EXCLUDED, ARCHIVED

TargetingTypes String Targeting type

使用できる値は次のとおりです。KEYWORD, APPTYPE, GENDER, LOCATION, PLACEMENT, COUNTRY, TARGETED_INTEREST, PINNER_INTEREST, AUDIENCE_INCLUDE, GEO, AGE_BUCKET, REGION, AGE_BUCKET_AND_GENDER

AdsAnalyticsMetricsFilter String List of metrics filters
ProductItemIds String List of product item ids.
AdsAnalyticsMetricsFilter String List of metrics filters

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