best practice setting keyword bids

[Matthias Baader]

Hi,

as a result of some calculation in my script, I end up with an object like this, containing all individual bids, I want to set for each keyword in all the adGroups of a campaign:

map[campaignId][adGroupId][id]["bid"]=0.5

Now: what is considered as best practice to set the individual keyword bids (with regard to speed), if we talk about thousands of keywords, each with an individual bid? 

Best regards

Matthias

[Tyler Sidell (AdWords Scripts Team)]

Hi Matthias,

Thanks for reaching out with your inquiry about speed and best practices.  We do have a Best Practices page that discusses topics such as speed.  if you are looking for best practices for setting keyword bids in bulk, you may want to take a look at the example we provide under the batch changes section.

Let us know if you have any questions.

Thanks,
Tyler Sidell

AdWords Scripts Team

[Matthias Baader]

Thank you Tyler for providing that solution.

The point is, not to set a common CPC for all keywords, like in that batch change solution, but an individual one for each. Currently, my script is looping through the above mentioned object like

for (var campaignId in map){

for (var adGroupId in map[campaignId]){

for (var id in map[campaignId][adGroupId]){

var bid = map[campaignId][adGroupId][id]["bid"];

var keywordId = [[adGroupId, id]];

var keyword = AdWordsApp.keywords()

.withIds(keywordId)

.get()

.next();

keyword.bidding().setCpc(bid);

}

}

}

...and this gives me a pretty good performance. But I was wondering, if there is a better way.

Best regards

Matthias

[Joyce Lava (AdWords Scripts Team)]

Hi Matthias,

Since the value of each bid comes from an array mapping with different values, your current code is the only way to achieve your use-case.

Thanks,

Joyce Lava

AdWords Scripts Team

[Matthias Baader]

Hi Joyce,

thank you very much for the clarification!

Best regards
Matthias

[Trevor]

Alternatively however, you could create a bulk upload, pull a report of every keyword in the account (with campaign ID, ad group ID, and keyword ID as columns), iterate through each row, and one by one use the ids to look up the bid in your map and replace the bid in the row, pushing each into the bulk upload. At the end the script would push the bulk upload all at once.

In more detail, you'd create the upload with newCsvUpload() (setting the column headers as appropriate), then set up a row iterator for the keyword report, and for each row:

var upload = AdWordsApp.bulkUploads().newCsvUpload(---column headers set up here---)
var report = AdWordsApp.report("SELECT CampaignId, AdGroupId, Id, CpcBid FROM KEYWORD_PERFORMANCE_REPORT"); // Something like this, I haven't tested this query

var reportIterator = report.rows();

while (reportIterator.hasNext()) {
  row = rows.next();
  row['CpcBid'] = map[row['CampaignId']][row['AdGroupId'][row['Id']["bid"];
  upload.append(row.formatForUpload());
}

upload.apply;  // or preview

The above code is psuedo-esque code (untested) but hopefully the concept makes sense.

[Trevor]

Forgot a bracket in this line:

row['CpcBid'] = map[row['CampaignId']][row['AdGroupId'][row['Id']]["bid"];

[Matthias Baader]

Thank you Trevor for providing this solution. I will give it a try.

Best regards
Matthias