function main() {
  const spreadsheetId = '149614961496';		//スプレッドシートID
  reportDataToSpreadsheet_YEAR(spreadsheetId,'YEAR','ALL_TIME');			//年別レポート
  reportDataToSpreadsheet_MONTH(spreadsheetId,'MONTH','ALL_TIME');		//月別レポート
  reportDataToSpreadsheet_DAY(spreadsheetId,'DAY','ALL_TIME');		//日別レポート
  reportDataToSpreadsheet_CAMPAIGN(spreadsheetId,'CAMPAIGN','THIS_MONTH_EXCEPT_TODAY');		//キャンペーン別レポート
  reportDataToSpreadsheet_ADGROUP(spreadsheetId,'ADGROUP','THIS_MONTH_EXCEPT_TODAY');		//広告グループ別レポート
  reportDataToSpreadsheet_AD(spreadsheetId,'AD','THIS_MONTH_EXCEPT_TODAY');		//レスポンシブ検索広告別レポート  
  reportDataToSpreadsheet_KEYWORD(spreadsheetId,'KEYWORDS','THIS_MONTH_EXCEPT_TODAY');		//キーワード別レポート  
  reportDataToSpreadsheet_SEARCH_QUERY(spreadsheetId,'SEARCH_QUERY','THIS_MONTH_EXCEPT_TODAY');		//検索クエリ別レポート  
  reportDataToSpreadsheet_KEYWORDLESS_QUERY(spreadsheetId,'KEYWORDLESS_QUERY','THIS_MONTH_EXCEPT_TODAY');		//動的検索広告クエリ別レポート  
}

function reportDataToSpreadsheet_YEAR(variable_spreadsheetId,variable_sheetName,variable_reportDateRangeType){
  const spreadsheetId = variable_spreadsheetId;
  const sheetName = variable_sheetName;
  const ss = SpreadsheetApp.openById(spreadsheetId);
  let sh = ss.getSheetByName(sheetName);
  sh.clear();
  const reportData = AdsUtilities.getSearchReport({
    accountId: AdsUtilities.getCurrentAccountId(),
    fields: [
      'YEAR','IMPS','CLICKS','CLICK_RATE','AVG_CPC','COST','CONVERSIONS','CONV_RATE','COST_PER_CONV','CONV_VALUE','CONV_VALUE_PER_COST','VALUE_PER_CONV','IMPRESSION_SHARE'
    ],
    reportDateRangeType: variable_reportDateRangeType,
    reportType: 'ACCOUNT',
    reportSkipColumnHeader : 'FALSE',
    sortFields: [
      {
        field:'YEAR',
        reportSortType: 'ASC'
      },
    ]
  }).reports[0].rows;
  sh.getRange('A1').setValues(reportData);
}

function reportDataToSpreadsheet_MONTH(variable_spreadsheetId,variable_sheetName,variable_reportDateRangeType){
  const spreadsheetId = variable_spreadsheetId;
  const sheetName = variable_sheetName;
  const ss = SpreadsheetApp.openById(spreadsheetId);
  let sh = ss.getSheetByName(sheetName);
  sh.clear();
  const reportData = AdsUtilities.getSearchReport({
    accountId: AdsUtilities.getCurrentAccountId(),
    fields: [
      'MONTH','IMPS','CLICKS','CLICK_RATE','AVG_CPC','COST','CONVERSIONS','CONV_RATE','COST_PER_CONV','CONV_VALUE','CONV_VALUE_PER_COST','VALUE_PER_CONV','IMPRESSION_SHARE'
    ],
    reportDateRangeType: variable_reportDateRangeType,
    reportType: 'ACCOUNT',
    reportSkipColumnHeader : 'FALSE',
    sortFields: [
      {
        field:'MONTH',
        reportSortType: 'ASC'
      },
    ]
  }).reports[0].rows;
  sh.getRange('A1').setValues(reportData);
}

function reportDataToSpreadsheet_DAY(variable_spreadsheetId,variable_sheetName,variable_reportDateRangeType){
  const spreadsheetId = variable_spreadsheetId;
  const sheetName = variable_sheetName;
  const ss = SpreadsheetApp.openById(spreadsheetId);
  let sh = ss.getSheetByName(sheetName);
  sh.clear();
  const reportData = AdsUtilities.getSearchReport({
    accountId: AdsUtilities.getCurrentAccountId(),
    fields: [
      'DAY','IMPS','CLICKS','CLICK_RATE','AVG_CPC','COST','CONVERSIONS','CONV_RATE','COST_PER_CONV','CONV_VALUE','CONV_VALUE_PER_COST','VALUE_PER_CONV','IMPRESSION_SHARE'
    ],
    reportDateRangeType: variable_reportDateRangeType,
    reportType: 'ACCOUNT',
    reportSkipColumnHeader : 'FALSE',
    sortFields: [
      {
        field: 'DAY',
        reportSortType: 'ASC'
      },
    ]
  }).reports[0].rows;
  sh.getRange('A1').setValues(reportData);
}

function reportDataToSpreadsheet_CAMPAIGN(variable_spreadsheetId,variable_sheetName,variable_reportDateRangeType){
  const spreadsheetId = variable_spreadsheetId;
  const sheetName = variable_sheetName;
  const ss = SpreadsheetApp.openById(spreadsheetId);
  let sh = ss.getSheetByName(sheetName);
  sh.clear();
  const reportData = AdsUtilities.getSearchReport({
    accountId: AdsUtilities.getCurrentAccountId(),
    fields: [
      'CAMPAIGN_NAME','IMPS','CLICKS','CLICK_RATE','AVG_CPC','COST','CONVERSIONS','CONV_RATE','COST_PER_CONV','CONV_VALUE','CONV_VALUE_PER_COST','VALUE_PER_CONV','IMPRESSION_SHARE'
    ],
    reportDateRangeType: variable_reportDateRangeType,
    reportType: 'CAMPAIGN',
    reportSkipColumnHeader : 'FALSE',
    sortFields: [
      {
        field: 'CONVERSIONS',
        reportSortType: 'DESC'
      },
      {
        field: "COST",
        reportSortType: 'DESC'
      },
      {
        field: "CLICKS",
        reportSortType: 'DESC'
      },
    ]
  }).reports[0].rows;
  sh.getRange('A1').setValues(reportData);
}

function reportDataToSpreadsheet_ADGROUP(variable_spreadsheetId,variable_sheetName,variable_reportDateRangeType){
  const spreadsheetId = variable_spreadsheetId;
  const sheetName = variable_sheetName;
  const ss = SpreadsheetApp.openById(spreadsheetId);
  let sh = ss.getSheetByName(sheetName);
  sh.clear();
  const reportData = AdsUtilities.getSearchReport({
    accountId: AdsUtilities.getCurrentAccountId(),
    fields: [
      'CAMPAIGN_NAME','ADGROUP_NAME','IMPS','CLICKS','CLICK_RATE','AVG_CPC','COST','CONVERSIONS','CONV_RATE','COST_PER_CONV','CONV_VALUE','CONV_VALUE_PER_COST','VALUE_PER_CONV','IMPRESSION_SHARE'
    ],
    reportDateRangeType: variable_reportDateRangeType,
    reportType: 'ADGROUP',
    reportSkipColumnHeader : 'FALSE',
    sortFields: [
      {
        field: 'CONVERSIONS',
        reportSortType: 'DESC'
      },
      {
        field: "COST",
        reportSortType: 'DESC'
      },
      {
        field: "CLICKS",
        reportSortType: 'DESC'
      },
    ]
  }).reports[0].rows;
  sh.getRange('A1').setValues(reportData);
}

function reportDataToSpreadsheet_AD(variable_spreadsheetId,variable_sheetName,variable_reportDateRangeType){
  const spreadsheetId = variable_spreadsheetId;
  const sheetName = variable_sheetName;
  const ss = SpreadsheetApp.openById(spreadsheetId);
  let sh = ss.getSheetByName(sheetName);
  sh.clear();
  const reportData = AdsUtilities.getSearchReport({
    accountId: AdsUtilities.getCurrentAccountId(),
    fields: [
      'CAMPAIGN_NAME','ADGROUP_NAME','AD_NAME','ASSET_TEXT',"ASSET_TYPE",'PERFORMANCE','IMPS'
    ],
    reportDateRangeType: variable_reportDateRangeType,
    reportType: 'RESPONSIVE_ADS_FOR_SEARCH_ASSET',
    reportSkipColumnHeader : 'FALSE',
    sortFields: [
      {
        field: 'CAMPAIGN_NAME',
        reportSortType: 'ASC'
      },
      {
        field: 'ADGROUP_NAME',
        reportSortType: 'ASC'
      },
      {
        field: "AD_NAME",
        reportSortType: 'ASC'
      },
      {
        field: 'IMPS',
        reportSortType: 'DESC'
      },
    ]
  }).reports[0].rows;
  sh.getRange('A1').setValues(reportData);
}

function reportDataToSpreadsheet_KEYWORD(variable_spreadsheetId,variable_sheetName,variable_reportDateRangeType){
  const spreadsheetId = variable_spreadsheetId;
  const sheetName = variable_sheetName;
  const ss = SpreadsheetApp.openById(spreadsheetId);
  let sh = ss.getSheetByName(sheetName);
  sh.clear();
  const reportData = AdsUtilities.getSearchReport({
    accountId: AdsUtilities.getCurrentAccountId(),
    fields: [
      'CAMPAIGN_NAME','ADGROUP_NAME','KEYWORD','KEYWORD_MATCH_TYPE','IMPS','CLICKS','CLICK_RATE','AVG_CPC','COST','CONVERSIONS','CONV_RATE','COST_PER_CONV','CONV_VALUE','CONV_VALUE_PER_COST','VALUE_PER_CONV','IMPRESSION_SHARE'
    ],
    reportDateRangeType: variable_reportDateRangeType,
    reportType: 'KEYWORDS',
    reportSkipColumnHeader : 'FALSE',
    sortFields: [
      {
        field: 'CONVERSIONS',
        reportSortType: 'DESC'
      },
      {
        field: "COST",
        reportSortType: 'DESC'
      },
      {
        field: "CLICKS",
        reportSortType: 'DESC'
      },
    ]
  }).reports[0].rows;
  sh.getRange('A1').setValues(reportData);
}

function reportDataToSpreadsheet_SEARCH_QUERY(variable_spreadsheetId,variable_sheetName,variable_reportDateRangeType){
  const spreadsheetId = variable_spreadsheetId;
  const sheetName = variable_sheetName;
  const ss = SpreadsheetApp.openById(spreadsheetId);
  let sh = ss.getSheetByName(sheetName);
  sh.clear();
  const reportData = AdsUtilities.getSearchReport({
    accountId: AdsUtilities.getCurrentAccountId(),
    fields: [
      'CAMPAIGN_NAME','ADGROUP_NAME','KEYWORD','SEARCH_QUERY','SEARCH_QUERY_MATCH_TYPE','IMPS','CLICKS','CLICK_RATE','AVG_CPC','COST','CONVERSIONS','CONV_RATE','COST_PER_CONV','CONV_VALUE','CONV_VALUE_PER_COST','VALUE_PER_CONV'
    ],
    reportDateRangeType: variable_reportDateRangeType,
    reportType: 'SEARCH_QUERY',
    reportSkipColumnHeader : 'FALSE',
    sortFields: [
      {
        field: 'CONVERSIONS',
        reportSortType: 'DESC'
      },
      {
        field: "COST",
        reportSortType: 'DESC'
      },
      {
        field: "CLICKS",
        reportSortType: 'DESC'
      },
    ]
  }).reports[0].rows;
  sh.getRange('A1').setValues(reportData);
}

function reportDataToSpreadsheet_KEYWORDLESS_QUERY(variable_spreadsheetId,variable_sheetName,variable_reportDateRangeType){
  const spreadsheetId = variable_spreadsheetId;
  const sheetName = variable_sheetName;
  const ss = SpreadsheetApp.openById(spreadsheetId);
  let sh = ss.getSheetByName(sheetName);
  sh.clear();
  const reportData = AdsUtilities.getSearchReport({
    accountId: AdsUtilities.getCurrentAccountId(),
    fields: [
      'CAMPAIGN_NAME','ADGROUP_NAME','SEARCH_QUERY','IMPS','CLICKS','CLICK_RATE','AVG_CPC','COST','CONVERSIONS','CONV_RATE','COST_PER_CONV','CONV_VALUE','CONV_VALUE_PER_COST','VALUE_PER_CONV'
    ],
    reportDateRangeType: variable_reportDateRangeType,
    reportType: 'KEYWORDLESS_QUERY',
    reportSkipColumnHeader : 'FALSE',
    sortFields: [
      {
        field: 'CONVERSIONS',
        reportSortType: 'DESC'
      },
      {
        field: "COST",
        reportSortType: 'DESC'
      },
      {
        field: "CLICKS",
        reportSortType: 'DESC'
      },
    ]
  }).reports[0].rows;
  sh.getRange('A1').setValues(reportData);
}