function main() { const spreadsheet = SpreadsheetApp.create('GCLID Report-26-09-24'); const report = AdsApp.report(`SELECT click_view.gclid, click_view.keyword, click_view.location_of_presence.city, click_view.location_of_presence.country, click_view.location_of_presence.region, metrics.clicks, segments.click_type, segments.device FROM click_view WHERE segments.date = '2024-09-26'`); report.exportToSheet(spreadsheet.getActiveSheet()); }