Google广告脚本(AWQL)获取用于报告的自定义日期范围

Question

我需要拉一个谷歌广告报告，将从一个固定的日期（5月28日）到今天的数据，并把数据推到一个电子表格。我不知道如何定义这个查询的日期范围

我试过谷歌搜索和阅读谷歌文档，但我还是搞不清楚

function main() {
  var spreadsheet = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/XXX');
  var sheet = spreadsheet.getSheetByName('Data')  
  var report = AdsApp.report(
    'SELECT Date, CampaignName, AverageFrequency, Impressions, ImpressionReach ' +
    'FROM   CAMPAIGN_PERFORMANCE_REPORT ' +
    'WHERE  Impressions > 0 ' +
    'DURING 20190528,TODAY');

  sheet.clearContents();
  report.exportToSheet(sheet);
}

请让我知道是否有一种方法使查询工作。谢谢！

Answer 1

TODAY关键字充当DURING属性的“全范围”，不能用作结束部分（据我所知）。以下方法应该起作用。

php prettyprint-override">function main() {
    var endDate = new Date();
    var endRange = Utilities.formatDate(endDate, 'America/Chicago', 'YYYYMMdd');

    var spreadsheet = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/XXX');
    var sheet = spreadsheet.getSheetByName('Data')  
    var report = AdsApp.report(
        'SELECT Date, CampaignName, AverageFrequency, Impressions, ImpressionReach ' +
        'FROM   CAMPAIGN_PERFORMANCE_REPORT ' +
        'WHERE  Impressions > 0 ' +
        'DURING 20190528,' + endRange);

    sheet.clearContents();
    report.exportToSheet(sheet);
}