Using the variables LopMostSpecificTargetId AoiMostSpecificTargetId I have tried to include it in the script to get those fields and in the sheet I get the results Unspecified an Other.
Do you know why I get this data and not the location or country of the user?
I put the script
function main() {
var spreadsheeturl = 'Hoja del Sheet';
var sheet = SpreadsheetApp.openByUrl(spreadsheeturl);
var active = sheet.getActiveSheet();
var report = AdWordsApp.report("SELECT AoiMostSpecificTargetId,LopMostSpecificTargetId FROM CLICK_PERFORMANCE_REPORT DURING YESTERDAY");
report.exportToSheet(active);
}