Reporting

Consult the Google Ads API guide on reporting for full details about the reporting capabilities for Search campaigns. You can run queries using the AdsApp.search() function.

For example, to run a campaign level reporting query for Search campaigns:

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