AdsApp.​Report

  • The Google Ads report object represents a report generated by Google Ads.

  • The exportToSheet() method exports the report's content into a Google Sheet.

  • The rows() method returns an iterator to loop through the rows of the report.

 Represents a Google Ads report.

Methods:

MemberTypeDescription
exportToSheet(sheet) void Exports the content of the report into a Sheet.
rows() AdsApp.ReportRowIterator Returns an iterator over the rows of the report.

exportToSheet(sheet)

Exports the content of the report into a Sheet.

Typical usage: 

  var spreadsheet = SpreadsheetApp.create("Report output");
  var report = AdsApp.report("SELECT metrics.clicks, " +
      "metrics.impressions, metrics.average_cpc, segments.hour " +
      "FROM customer " +
      "WHERE segments.date DURING LAST_MONTH");
  report.exportToSheet(spreadsheet.getActiveSheet());
  Logger.log("Report available at " + spreadsheet.getUrl());

Returns nothing.

Arguments:

NameTypeDescription
sheet SpreadsheetApp.Sheet The sheet in a Google Spreadsheet to export the report to.

rows()

Returns an iterator over the rows of the report.

Return values:

TypeDescription
AdsApp.ReportRowIterator An iterator over the rows of the report.