報表

建立文字報表

function runReport() {
  // Google Ads reports return data faster than campaign management methods
  //   and can be used to retrieve basic structural information on
  //   your Account, Campaigns, AdGroups, Ads, Keywords, etc. You can refer to
  //   https://developers.google.com/google-ads/api/docs/reporting/overview
  //   for more details.

  // See https://developers.google.com/google-ads/api/fields/latest/overview#list-of-all-resources
  //   for all the supported report types.
  // See https://developers.google.com/google-ads/api/docs/query/overview for
  //   details on how to use GAQL, the query language for reports.
  // See https://developers.google.com/google-ads/api/docs/reporting/uireports
  //   for details on how to map an Google Ads UI feature to the corresponding
  //   reporting API feature.
  const searchResults = AdsApp.search(
      'SELECT campaign.name, metrics.clicks, metrics.impressions, metrics.cost_micros ' +
      'FROM   campaign ' +
      'WHERE  metrics.impressions < 10 ' +
      ' AND   segments.date DURING LAST_30_DAYS');

  for (const row of searchResults) {
    const campaignName = row.campaign.name;
    const clicks = row.metrics.clicks;
    const impressions = row.metrics.impressions;
    const cost = row.metrics.costMicros;
    console.log(`${campaignName}, ${clicks}, ${impressions}, ${cost}`);
  }
}

建立試算表報表

function exportReportToSpreadsheet() {
  const spreadsheet = SpreadsheetApp.create('INSERT_REPORT_NAME_HERE');
  const report = AdsApp.report(
      'SELECT campaign.name, metrics.clicks, metrics.impressions, metrics.cost_micros ' +
      'FROM   campaign ' +
      'WHERE  metrics.impressions < 10 ' +
      ' AND   segments.date DURING LAST_30_DAYS');
  report.exportToSheet(spreadsheet.getActiveSheet());
}

按標籤篩選實體

function filterReportByLabelIds() {
  const label = AdsApp.labels().withCondition(
      "label.name = 'High performance campaigns'").get().next();
  const query = `SELECT campaign.name, metrics.clicks, metrics.impressions, metrics.cost_micros from ` +
      `campaign WHERE campaign.labels CONTAINS ANY ` +
      `[${label.getResourceName()}] AND segments.date DURING THIS_MONTH';

  const report = AdsApp.report(query);

  for (const row of report.rows()) {
    const campaignName = row['campaign.name'];
    const clicks = row['metrics.clicks'];
    const impressions = row['metrics.impressions'];
    const cost = row['metrics.cost_micros'];
    Logger.log(`${campaignName}, ${clicks}, ${impressions}, ${cost}`);
  }
}