การรายงาน

  const searchResults = AdsApp.search(`
SELECT
  campaign.id,
  campaign.name,
  campaign.status,
  campaign.bidding_strategy_type,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros
FROM campaign
WHERE campaign.advertising_channel_type = SEARCH
  AND segments.date DURING LAST_7_DAYS
  `);

  while (searchResults.hasNext()) {
    const row = searchResults.next();
    const campaign = row.campaign;
    // Your custom logic here, fetching the selected fields to do your analysis.
  }