Create and update a spreadsheet with basic campaign data
<p>I've just started experimenting with Google Adwords Scripts and Google Spreadsheet. I'm trying to pull basic campaign data from our manager account and send that data to a sheet. </p>

<p>I've written the following but every time I run the script, a spreadsheet is created that includes the headers/column names but not the actual data. </p>

<p>Where have I gone wrong? </p>

<p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
<div class="snippet-code">
<pre class="snippet-code-js lang-js prettyprint-override"><code>function main() {
  var spreadsheet = SpreadsheetApp.create('Adwords Testing');
  var report = AdWordsApp.report(
      'SELECT CampaignName, Clicks, Conversions, Cost, Ctr, AverageCpc, Impressions ' +
      'FROM   CAMPAIGN_PERFORMANCE_REPORT ' +
      'WHERE  CampaignStatus = ENABLED ' +
      'DURING LAST_7_DAYS');

  var rows = report.rows();
  while (rows.hasNext()){
    var row = rows.next();
    var campaignName = ['CampaignName'];
    var clicks = ['Clicks'];
    var conversions = ['conversions'];
    var cost = ['Cost'];
    var avgcpc = ['AverageCpc'];
    var ctr = ['Ctr'];
    var impressions = ['Impressions'];
  }
  report.exportToSheet(spreadsheet.getActiveSheet());
  Logger.log('your sheet is available at ' + spreadsheet);
  
}</code></pre>
</div>
</div>
</p>