创建并更新包含基本市场活动数据的电子表格

Question

js prettyprint-override">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);
  
}

Answer 1

如果您对进一步编写AdWords帐户脚本感兴趣，请查看AdWords脚本，这是一个嵌入到AdWords界面中的应用程序脚本版本。

我想这就是你的错误所在：

report.exportToSheet(spreadsheet.getActiveSheet());

若要向行添加值，您将使用电子表格服务使用GetRange()、GetValues和SetValues()类。

// The code below will get the values for the range C2:G8
// in the active spreadsheet. Note that this will be a javascript array.
var values = SpreadsheetApp.getActiveSheet().getRange(2, 3, 6, 4).getValues();
Logger.log(values[0][0]);

设置值的矩形网格（必须与此范围的尺寸匹配）。

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];

// The size of the two-dimensional array must match the size of the range.
var values = [
[ "2.000", "1,000,000", "$2.99" ]
];

var range = sheet.getRange("B2:D2");
range.setValues(values);

以下是Iluxa的一个片段：

function main() {
var sheet = SpreadsheetApp.openByUrl(
"https://docs.google.com/spreadsheet/ccc?key=0Aj_Bw31w9s7LdEdLMllQMnZfbW52c3BvcTh0ekVBQ3c#gid=0").getActiveSheet();
var emptyRow = findEmptyRow(sheet);

var yesterday = new Date(new Date().getTime() - (24 * 3600 * 1000));

var range = sheet.getRange(emptyRow + 1, 1, 1, 10);

var row = range.getValues();
row[0][0] = yesterday;
row[0][1] = MONTHS[yesterday.getMonth()];
row[0][2] = DAYS_OF_WEEK[yesterday.getDay()];

var stats = AdWordsApp.report("SELECT Clicks, Impressions, Cost, Conversions " +
"FROM ACCOUNT_PERFORMANCE_REPORT DURING YESTERDAY")
.rows()
.next();
row[0][3] = stats["Clicks"];
row[0][4] = stats["Impressions"];
row[0][7] = stats["Cost"];
row[0][8] = stats["Conversions"];
range.setValues(row);
}

function findEmptyRow(sheet) {
var dates = sheet.getRange(1, 1, 365, 1).getValues();
for (var emptyDate = 0; emptyDate < dates.length; emptyDate ++) {
if (dates[emptyDate][0].length == 0) {
return emptyDate;
}
}
}

希望有帮助！