AdsApp.​SearchRow

  • A SearchRow represents a row of a report and is a JavaScript Object holding all requested values.

  • The values within a SearchRow are nested inside the row object.

  • You can access values in a SearchRow like an associative array, for example, row.campaign.id to get the campaign ID.

 Represents a row of a report.

NOTE: The SearchRow is a JavaScript Object, holding all values requested. These values are nested inside the row object.

Typical usage: 

  var query = 'SELECT campaign.id, campaign.name FROM campaign';
  var rows = AdsApp.search(query);
  while (rows.hasNext()) {
    var row = rows.next();
    // The row works as an associative array
    var campaign = row.campaign;
    var id = campaign.id;
    var name = campaign.name;
  }