AdAccountAnalyticsReport
Get the ad account analytics report
Table Specific Information
Select
The cmdlet 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 cmdlet.
- 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
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, PRODUCT_ITEM_TARGETING. 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, 14, 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, 14, 30, 60. The default value is 1. | |
EngagementWindowDays | Integer | Number of days to use as the conversion attribution window for an engagement action.
The allowed values are 1, 7, 14, 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, DRAFT, DELETED_DRAFT. | |
CampaignObjectiveTypes | String | List of status values for filtering
The allowed values are 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.
The allowed values are RUNNING, PAUSED, NOT_STARTED, COMPLETED, ADVERTISER_DISABLED, ARCHIVED, DRAFT, DELETED_DRAFT. | |
AdIds | String | List of ad ids | |
AdStatuses | String | List of values for filtering.
The allowed values are APPROVED, PAUSED, PENDING, REJECTED, ADVERTISER_DISABLED, ARCHIVED, DRAFT, DELETED_DRAFT. | |
ProductGroupIds | String | List of product group ids. | |
ProductGroupStatuses | String | List of values for filtering.
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, AGE_BUCKET_AND_GENDER. | |
AdsAnalyticsMetricsFilter | String | List of metrics filters | |
ProductItemIds | String | List of product item ids. | |
AdsAnalyticsMetricsFilter | String | List of metrics filters |