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

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