AdAccountAnalyticsReport
Get the ad account analytics report
Table Specific Information
Select
The connector will use the Pinterest API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- 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.
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 | ||
| COSTPEROUTBOUNDCLICKINDOLLAR1 | Decimal | Average cost per paid outbound click. | |
| OUTBOUNDCTR1 | Decimal | Paid outbound clicks divided by paid impressions. |
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. |