This is the legacy documentation for Google Ads scripts. Go to the current docs.

AdsApp.​ReportRow

Represents a row of a report.

NOTE: The ReportRow works as an associative array indexed by AWQL column name. In addition to working as a normal associative array, ReportRow also has a ReportRow.formatForUpload() method, for convenience when working with bulk uploads.

Typical usage:

   var rows = report.rows();
   while (rows.hasNext()) {
     var row = rows.next();
     // The row works as an associative array
     var clicks = row['Clicks'];
     // Tweak the row and append it to a bulk upload.
     row['MaxCpc'] = row['MaxCpc'] + 1;
     upload.append(row.formatForUpload());
   }

Methods:

MemberTypeDescription
formatForUpload Object Returns the report row as an associative array indexed by display column name.

formatForUpload()

Returns the report row as an associative array indexed by display column name.

For detailed information about the display column name, please see the Display Name column in all types of reports.

NOTE: If you're generating a CsvUpload with Report, make sure to use this method while appending rows. Typical usage:

   var rows = report.rows();
   while (rows.hasNext()) {
     var row = rows.next();
     // ... tweak the row
     upload.append(row.formatForUpload());
   }

Return values:

TypeDescription
Object The report row as associative arrays indexed by display column name.