Application of AWQL in real reports

//SETTINGS - Spreadsheet URL//
var spreadsheet = SpreadsheetApp.openByUrl('');
 
function main(){
 
spreadsheet.setSpreadsheetLocale('en');
var sheetSettings = createOrGetSheet(spreadsheet, 'Settings', 0);
var settingRange = sheetSettings.getRange(1,1,1,2);
if(sheetSettings.getRange(1,2).isBlank()) {
  settingRange.setValues([['How many days back for the report',90]]);
}
var daysBack = sheetSettings.getRange(1,2).getValue();
var sheet = createOrGetSheet(spreadsheet, 'KW report', 1);
var sheet2 = createOrGetSheet(spreadsheet, 'Terms report', 2);
 
var to = lynt_get_date(1);
var from = lynt_get_date(daysBack);
var dateRange = from + ',' + to;
 
 
var report = AdWordsApp.report(
  " SELECT Criteria, CampaignName, AdGroupName,Impressions,Clicks,AverageCpc,Ctr,Cost,AllConversions,CostPerAllConversion,AllConversionValue,QualityScore,CpcBid,FirstPageCpc,TopOfPageCpc,AveragePosition,CreativeQualityScore,SearchPredictedCtr, PostClickQualityScore,EstimatedAddCostAtFirstPositionCpc,EstimatedAddClicksAtFirstPositionCpc,FirstPositionCpc,KeywordMatchType, SearchImpressionShare, SearchRankLostImpressionShare " + 
  " FROM KEYWORDS_PERFORMANCE_REPORT"+
  " WHERE Impressions > 10"+
  " AND AdGroupStatus = ENABLED" + 
  " AND CampaignStatus = ENABLED" + 
  " AND Status = ENABLED" +
  " DURING " + dateRange);
 
var report2 = AdWordsApp.report(
  " SELECT Query,KeywordTextMatchingQuery,CampaignName,AdGroupName,Impressions,Clicks,AverageCpc,Ctr,Cost,AllConversions,CostPerAllConversion,AllConversionValue " + 
  " FROM SEARCH_QUERY_PERFORMANCE_REPORT"+
  " WHERE Impressions > 0"+
  " AND AdGroupStatus = ENABLED" + 
  " AND CampaignStatus = ENABLED" +
  " AND Impressions > 20" +
  " DURING " + dateRange);
  
report.exportToSheet(sheet);
report2.exportToSheet(sheet2);
}
 
 
function lynt_DST(datum, offset){
  var yr = datum.getFullYear();
  var dst_start = new Date("March 14, " + yr +" 02:00:00");
  var dst_end = new Date("November 07, " + yr +" 02:00:00");
  var day = dst_start.getDay();
  dst_start.setDate(14-day);
  day = dst_end.getDay();
  dst_end.setDate(7-day);
  if (datum >= dst_start && datum < dst_end){
    return offset+1;
  } else {
  return offset;
  }
}
 
//Creating or returning selected sheet 
function createOrGetSheet(reportSpreadsheet, name, position) {
  var sheet = reportSpreadsheet.getSheetByName(name);
  if(sheet == null) {
    return reportSpreadsheet.insertSheet(name,position);
  } else {
    return sheet;
  }
}
 
//Getting data for x days back in right format for AWQL query
function lynt_get_date(pocet_dni) {
  var minule = new Date(); 
  //kdyz je letni cas, tak o hodinu dele (GMT+1)
  var offset = lynt_DST(minule,1);
  minule.setTime(minule.getTime() - (1000 * 60 * 60 * (24) * pocet_dni) + offset);
  return lynt_format_awql_date(minule);
}
 
//Getting always last sunday with right formats for AWQL
function lynt_get_sunday() {
  var minule = new Date();
  //kdyz je letni cas, tak o hodinu dele (GMT+1)
  var offset = lynt_DST(minule,1);
  minule.setTime(minule.getTime() - (1000 * 60 * 60 * (24) * (minule.getDay())) + offset);
  return lynt_format_awql_date(minule);
}
 
//Getting x days from last sunday right formated for AWQL
function lynt_get_xdays_back_from_sunday(pocet_dni) {
  var minule = new Date();
  //kdyz je letni cas, tak o hodinu dele (GMT+1)
  var offset = lynt_DST(minule,1);
  minule.setTime(minule.getTime() - (1000 * 60 * 60 * (24) * pocet_dni) - (1000 * 60 * 60 * 24 * (minule.getDay()))+ offset);
  return lynt_format_awql_date(minule);
}
 
//Format date for AWQL
function lynt_format_awql_date(datum){
  return datum.getUTCFullYear()+("0"+(datum.getUTCMonth()+1)).slice(-2)+("0"+datum.getUTCDate()).slice(-2);
}