Where do you want to go?
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());
}