Longtail

function main() {
  
 
  var report = AdWordsApp.report(
    'SELECT OfferId, Cost, ConversionValue, Conversions ' +
    'FROM   SHOPPING_PERFORMANCE_REPORT ' +
    'WHERE ConversionValue > 0 ' +
    'DURING LAST_30_DAYS');
 
  var longtailSum = 0;
  var shortheadSum = 0;
  var rows = report.rows();
  while (rows.hasNext()) {
    var row = rows.next();
    var conv = row['Conversions'];
    var value = parseInt(row['ConversionValue'].replace(/,/g,""));
    if (conv <= 2) {
    longtailSum = longtailSum + value
    }
    else {
    shortheadSum = shortheadSum + value
    }
   Logger.log("Umsatz aus dem Shorthead: " + shortheadSum + " Euro\n" + "Umsatz aus dem Longtail: " + longtailSum + " Euro")
   Logger.log("Longtail in Prozent des Gesamtumsatzes: " + longtailSum/(longtailSum+shortheadSum)*100 + " %")  
  }
  
 
}