إعداد التقارير

  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.
  }