Aggregation function for Ads Script Reports

ads_report_aggregation.js

function report2Set(query, idKey, optArgs) {
  var reg = /SELECT\s+(.+)\s+FROM.*/
  var list  = query.match(reg)
  if (!list && !list[1]) throw 'Error parsing parameters from %q'.replace('%q', query)
  list = list[1].replace(/\s+/, '').split(',')
  if (list.length < 1) throw 'Error parsing parameters from %q'.replace('%q', query)
  if (typeof idKey == 'string') {
    if (!idKey.match(/id/i)) throw 'Bad idKey argument %id'.replace('%id', idKey)
    if (list.indexOf(idKey) == -1) throw '%id not founf in %q parameters'.replace('%q', query).replace('%id', idKey)
  }
  var report = AdsApp.report(query, optArgs), aggregation = null
  var rows = report.rows()
  if (rows.hasNext()) { aggregation = {} } else { return null }
  while (rows.hasNext()) {
    var row = rows.next()
    var id = (typeof idKey != 'function') ? row[idKey] : idKey(row)
    // debug ('typeof idKey "%s"', typeof idKey)
    var wrap = list.reduce(function(agg, key) { agg[key] = row[key]; return agg }, {})
    if (aggregation[id] && !aggregation[id].push) aggregation[id] = [aggregation[id]]
    if (aggregation[id] && aggregation[id].push) {
      aggregation[id].push(wrap)
    } else {
      aggregation[id] = wrap
    }
  }
  return aggregation
}