谷歌广告脚本:如何获取30天的数据，然后循环其中的每一天

function main() {
  var dateRange = getDateRange(); // 获取日期范围，可以自定义起始和结束日期
  var reportData = getReportData(dateRange); // 获取报告数据
  
  for (var i = 0; i < reportData.length; i++) {
    var dailyData = reportData[i];
    // 在这里执行每一天的操作
    // 可以将数据保存到数据库、生成报告、进行分析等
  }
}

// 获取日期范围
function getDateRange() {
  var today = new Date();
  var endDate = new Date(today.getTime() - (24 * 60 * 60 * 1000)); // 结束日期为昨天
  var startDate = new Date(endDate.getTime() - (30 * 24 * 60 * 60 * 1000)); // 开始日期为30天前
  
  return {
    startDate: startDate,
    endDate: endDate
  };
}

// 获取报告数据
function getReportData(dateRange) {
  var report = AdsApp.report(
    'SELECT Date, Impressions, Clicks, Cost ' +
    'FROM CAMPAIGN_PERFORMANCE_REPORT ' +
    'DURING ' + formatDate(dateRange.startDate) + ',' + formatDate(dateRange.endDate));
  
  var rows = report.rows();
  var reportData = [];
  
  while (rows.hasNext()) {
    var row = rows.next();
    var dailyData = {
      date: row['Date'],
      impressions: row['Impressions'],
      clicks: row['Clicks'],
      cost: row['Cost']
    };
    
    reportData.push(dailyData);
  }
  
  return reportData;
}

// 格式化日期为YYYY-MM-DD
function formatDate(date) {
  var year = date.getFullYear();
  var month = ('0' + (date.getMonth() + 1)).slice(-2);
  var day = ('0' + date.getDate()).slice(-2);
  
  return year + '-' + month + '-' + day;
}