Responsive search Adsのheadlineとdescriptionのtextとasset idを取得するAdwords Script

exportResponsiveSearchAdsToSheet.gs

function main() {
  const sheetUrl = "SHEET_URL";
  const spreadsheet = SpreadsheetApp.openByUrl(sheetUrl);
  const targetSheet = spreadsheet.getSheetByName("RSA");
  const report = AdWordsApp.report(
    'SELECT ResponsiveSearchAdDescriptions, ResponsiveSearchAdHeadlines ' +
    'FROM  AD_PERFORMANCE_REPORT ' +
    'WHERE AdType = RESPONSIVE_SEARCH_AD ' +
    'DURING LAST_7_DAYS'
  );
  const rows = report.rows();
  const descriptionData = [];
  const headlineData = [];
  while (rows.hasNext()) {
    const row = rows.next();
    const descriptions = JSON.parse(row['ResponsiveSearchAdDescriptions']);
    descriptions.forEach(function(v){
      targetSheet.appendRow(['description', v['assetId'], v['assetText']])
    })
    
    const headlines = JSON.parse(row['ResponsiveSearchAdHeadlines']);
    headlines.forEach(function(v){
      targetSheet.appendRow(['headline', v['assetId'], v['assetText']])
    })
  }
}