AdsApp.​Report

  • The Report object represents a Google Ads report and provides methods to interact with its data.

  • You can export report data into a Google Sheet using the exportToSheet method.

  • The rows method enables iteration through each row of the report's data.

 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.