如要瞭解需求開發廣告活動的完整報表功能,請參閱 Google Ads API 需求開發廣告活動報表指南。您可以使用 AdsApp.search() 函式,執行該頁面上的任何查詢,以及您建立的任何自訂查詢。
舉例來說,如要執行廣告活動層級報表查詢:
const searchResults = AdsApp.search(`
SELECT
campaign.id,
campaign.status,
campaign.bidding_strategy_type
FROM campaign
WHERE campaign.advertising_channel_type = DEMAND_GEN
`);
while (searchResults.hasNext()) {
const row = searchResults.next();
const campaign = row.campaign;
// Your custom logic here, fetching the selected fields to do your analysis.
}