AdsApp.​Report

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.