請參閱最高成效報表 API 指南,進一步瞭解最高成效廣告活動報表功能。您可以使用 AdsApp.search()
函式,執行該頁面上的任何查詢,以及您建立的任何自訂查詢。
舉例來說,如要執行素材資源群組成效查詢,請按照下列步驟操作:
const searchResults = AdsApp.search(`
SELECT
asset_group.id,
asset_group.name,
asset_group.primary_status,
metrics.conversions,
metrics.conversions_value,
metrics.cost_micros,
metrics.clicks,
metrics.impressions
FROM asset_group
WHERE campaign.id = CAMPAIGN_ID
AND segments.date DURING LAST_7_DAYS
`);
while (searchResults.hasNext()) {
const row = searchResults.next();
const assetGroup = row.assetGroup;
// Your custom logic here, fetching the selected fields to do your analysis.
}