AdsApp.​Report

Stay organized with collections Save and categorize content based on your preferences.
Represents a Google Ads report.

Methods:

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

exportToSheet(sheet)

Exports the content of the report into a External.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.