TypeError: Cannot find function AdGroup in object AdWordsApp. (line 6)

[aitor.uda...@gmail.com]

function main() {

  var SPREADSHEET_URL = "https://docs.google.com/spreadsheets/d/178Qi4UK8BUZYuuwn8CZ3qB10qk86uUg88ilNwbTOj3I/edit#gid=0";

 var sheetprueba = SpreadsheetApp.openByUrl(SPREADSHEET_URL);//abrimos sheet 

 //var sheet = SpreadsheetApp.getActiveSpreadsheet();

// var keywordsIterator = AdWordsApp.keywords().get();

var adGroupIterator = AdWordsApp.AdGroup().get();/*

 var campaignIterator = AdWordsApp.campaign().get();

 var TargetedLocationIterator = AdWordsApp.TargetedLocation().get();*/

  sheetprueba.getRange("A1").setValue("Campaña");

  sheetprueba.getRange("B1").setValue("Grupo");

  sheetprueba.getRange("C1").setValue("Keyword");

  sheetprueba.getRange("D1").setValue("Localización");

  

  for (var row = 2; adGroupIterator.hasNext(); row ++) {

   // var keyword = keywordsIterator.next();

var group = adGroupIterator.next();/*

/*var campaign=campaignIterator.next();

var localizacion=TargetedLocationIterator.net();*/

    /*sheetprueba.getRange("C" + row).setValue(keyword.getText());*/

    sheetprueba.getRange("A" + row).setValue(group.getName());/*

   /* sheetprueba.getRange("B" + row).setValue(campaign.getName());

sheetprueba.getRange("D" + row).setValue(localizacion.getName());*/

  }

  Logger.log("Report ready! Visit the following URL to see it:");

  Logger.log("https://docs.google.com/spreadsheet/ccc?key=" + spreadsheet.getId());

}

Hello, I have made a script by first making him to take me the keywords and it worked but when testing if you can catch me groups gives me an error and not why

Thanks

[Tyler Sidell (AdWords Scripts Team)]

Hi,

Please make sure that you are using adGroups() instead of AdGroup on line 6.  Your code should be as follows:

var adGroupIterator = AdWordsApp.adGroups().get();

Thanks,

Tyler Sidell

AdWords Scripts Team

[aitor.uda...@gmail.com]

Thanks Tyler Sidell.

I have another question,
I want to do is take the ad groups and put them on a sheet , then take those campaigns ad groups and put them in another column of the same sheet and then get the keywords of the ads and put it on a sheet .

For now I could only pick ad groups and keywords all account , but that's not what I wanted .

Not if you can help me ?

Thank you

[Tyler Sidell (AdWords Scripts Team)]

Hi,

Have you thought about simplifying the process and using Reports instead?  You could cross-check the type of report along with the fields needed.  Here is an example of a Keyword Performance Report that will output the information that you asked for.

function main() {
 var SPREADSHEET_URL = "REPLACE_WITH_YOUR_SPREADSHEET_URL";

 var sheetprueba = SpreadsheetApp.openByUrl(SPREADSHEET_URL);//abrimos sheet

 var sheet = sheetprueba.getActiveSheet();
 
  var report = AdWordsApp.report("SELECT CampaignName, AdGroupName, Criteria FROM KEYWORDS_PERFORMANCE_REPORT during LAST_MONTH");

  report.exportToSheet(sheet);

  Logger.log("Report ready! Visit the following URL to see it:");

  Logger.log("https://docs.google.com/spreadsheet/ccc?key=" + sheetprueba.getId());
}

Thanks,
Tyler Sidell

AdWords Scripts Team

[aitor.uda...@gmail.com]

Hello, again not because my message was deleted ? The question I have is how do I get the values ​​of name, phone, and email form through gclid ? regards

[Tyler Sidell (AdWords Scripts Team)]

Hi,

Would you mind opening a new thread pertaining to this new question?  Please provide as much detail as possible.

Thanks,
Tyler Sidell
AdWords Scripts Team

[Aitor Udabe]

Hi this is a url of new topic https://groups.google.com/forum/#!topic/adwords-scripts/dxANiv0mc5E