MCC Adwords脚本（按市场活动和日期）

Question

我已经写了一个我想要发生的例子，但需要关于如何到达那里的指针

null

var row = 2;
var reportMonth;
var reportYear;
var reportDays;
var reportMonthName;

function main() { 
  var mccAccount = AdWordsApp.currentAccount();
  var childAccounts = MccApp.accounts().get();

  reportMonth = getPreviousMonth();
   Logger.log("Report Month" + reportMonth);

  reportYear = new Date().getFullYear()

  if (reportMonth = 12) {
    reportYear = reportYear - 1;
  }

  Logger.log("Report Year" + reportYear);

  reportDays = daysInMonth(reportMonth,reportYear);
  Logger.log("Report Days" + reportDays);
  reportMonthName = monthNumberToName(reportMonth);
  Logger.log("Month Name" + reportMonthName);

  // Create a new spreadsheet (will have private access for you only).
var reportName = "Weekly QS Report – " + reportMonthName;
var spreadsheet = SpreadsheetApp.create(reportName);

  for (i=1; i < (reportDays+1);i++) {
var reportDay;

if (i < 10) {


reportDay = "" + "0" + i;

}
else
{
reportDay = i;  
}


var reportDate = "" + reportYear + reportMonth + reportDay;


Logger.log("Create Sheet" + reportDate);
var sheet = spreadsheet.insertSheet()
sheet.setName(i)

// Write header row.
sheet.getRange("A1").setValue("Account");
sheet.getRange("B1").setValue("Campaign");
sheet.getRange("C1").setValue("Impressions");
sheet.getRange("D1").setValue("Clicks");
sheet.getRange("E1").setValue("Cost");



while (childAccounts.hasNext()) {

  var childAccount = childAccounts.next();

  MccApp.select(childAccount);

  // Select campaigns under the client account
  var campaignIterator = AdWordsApp.campaigns().get();

  // Write body of report.
  while (campaignIterator.hasNext()) {

    var campaign = campaignIterator.next();

    Logger.log("Report Date" + reportDate);

    var stats = campaign.getStatsFor(reportDate,reportDate);


    sheet.getRange("A" + row).setValue(childAccount.getName());
    sheet.getRange("B" + row).setValue(campaign.getName());
    sheet.getRange("C" + row).setValue(stats.getImpressions());
    sheet.getRange("D" + row).setValue(stats.getClicks());
    sheet.getRange("E" + row).setValue(stats.getCost()); 

    row ++;
  }
}

  }

MccApp.select(mccAccount);          
}

function getDateInfo() {
  var premonth = getPreviousMonth();
  var dayIn = daysInMonth(premonth,year);



}

function daysInMonth(month,year) {
    return new Date(year, month, 0).getDate();
}

function getPreviousMonth() {
    var d = new Date();
    var n = d.getMonth();
    n = n - 1;

  if (n = -1) {
   n = 12;
  }
  return n;
}

function monthNumberToName (monthnum) {

  var months = [];
 months[1] = 'january';
 months[2] = 'february';
 months[3] = 'march';
 months[4] = 'april';
 months[5] = 'may';
 months[6] = 'june';
 months[7] = 'july';
 months[8] = 'august';
 months[9] = 'september';
 months[10] = 'october';
 months[11] = 'november';
 months[12] = 'december';

  var myMonthName = months[monthnum];

  return myMonthName;

};

如果有任何帮助，我们将不胜感激，谢谢你们

Answer 1

如果你能展示你所做的研究（如果有的话），那就好了。但是，我假设你有basic编程语言。因此您可以查看以下链接以供参考，积累您的知识，然后再积累您的代码。

Mcc帐户详细信息和其他操作：