What i see is after executing the script - Only two sheets('camp_perf_mtd','camp_perf_last_month'') from the tab array are getting written in the spreadsheet. Rest other report is not getting generated . Script seems ok to me. Appreciate inputs. Also the Ads is running since last 2days and the data is there in adword so it should generate last_7_days related report.