Tuesday, February 26, 2013

Update Your Bids from a Google Spreadsheet

Today we have a little script to help adjust bids at a large scale.  This is an example of how you can use the integration with Google Spreadsheets to update some of your bids for keywords.  I have provided a sample spreadsheet which you can make a copy of.

As long as the Adwords Account and the Google Docs account use the same login, it will be able to access any spreadsheet you have.  I suggest opening my sample spreadsheet and then making a copy if it in your account.  You can then replace the URL from the script below with the url of your copy of the spreadsheet.

Link to my sample spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0Aotb6eheEOpodEhDM2hqQmhfeTdHT3BLMl80aDRxTkE

 * Update Bids Using a Google Spreadsheet
 * Version 1.1
 * Created By: Russ Savage
 * FreeAdWordsScripts.com
function main() {
  var SPREADSHEET_URL = "Insert Url Here";
  var spreadsheet = SpreadsheetApp.openByUrl(SPREADSHEET_URL);
  var sheet = spreadsheet.getSheetByName('KeywordBids');
  var data = sheet.getRange("A:E").getValues();
  var kwBidHash = {};
  for(var i in data) {
    if(i == 0) { continue; }
    if(data[i][0] === '') { break; }
    var kwKey = Utilities.base64Encode([data[i][0],data[i][1],data[i][2]].join('~~!~~'));
    kwBidHash[kwKey] = data[i];
  var kwIter = AdWordsApp.keywords()
    .withCondition("Status = ENABLED")
  while(kwIter.hasNext()) {
    var kw = kwIter.next();
    var campName = kw.getCampaign().getName();
    var kwKey = Utilities.base64Encode([campName,kw.getText(),kw.getMatchType()].join('~~!~~'));
    if(kwBidHash[kwKey]) {
      if(kwBidHash[kwKey][3] === "FIXED") {
        kw.setMaxCpc(kw.getMaxCpc() * (1+kwBidHash[kwKey][4]));


  1. Do you know how to motivate students on coding? Here are https://pro-essay-writer.com/blog/motivating-students some tips!

  2. The writer guarantees that his book will train how one can promote on Google AdWords (infact any PPC) for ZERO expense. With his systems, the writer guarantees that he has effectively earned $87 million in free ads.https://www.ppc-agency.london/post/tips-for-making-your-pay-per-click-ppc-campaigns-more-profitable

  3. Thanks for sharing this post. This blog was amazing. I am impressed with your thoughts. I got the best information about this topic here and is very useful for all of us. Please visit Online Shopping Coupons , and I hope you may also like our services.

  4. Are you looking forward to getting the best quality and high standard HEMPWORX products? HempWorx products are a triple treat - pure, and extremely effective which will give you a healthy lifestyle. For a Limited Time Enjoy a FREE Sample Pack on Us. Get It Here Free Sample

  5. Translate this to the internet and you've got the Google Free Ads strategy for getting free advertising. Obviously DR. Jon had to do a lot of testing and tweaking to make this work and he actually came up with a mathematical formula for how much you need to pay and sell your ad space for.Negative keyword idea

  6. Be that as it may, with as of late settled auditing techniques set up by an association called The Interactive Advertising Bureau (IAB), Free Google Ads Audit

  7. On the off chance that it was your issue, guarantee full duty regarding whatever occurred and issue a sincere statement of regret
    buy reviews on google

  8. If you are doing research, developing a hypothesis is one of the most challenging elements. With our guideline, you can learrn how to write a hypothesis and other assignments.

  9. I really loved reading your blog. It was very well authored and easy to understand. Calgary SEO Agency

  10. Today's business marketplace is driven by tons of data. In fact, data is an important aspect of all industries as date offers plenty of useful information that helps businesses make important decisions. data science course in hyderabad

  11. This means whenever you make a Google search, your small picture would come next to the valid link of webpage or title of the post. This is exactly what would award you with an edge over others in the engine search results. Data Scraper - Easy Web Scraping

  12. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. excel budget spreadsheets

  13. G Suite offers a stunning measure of capacities for your business beginning at $5 each client/month. Utilizing G Suite for your business permits you to make and oversee clients for you. This not just gives your group admittance to messages and schedules in any case, other Google applications as well. Lead generation website

  14. I love your creativity. Are you also searching for nursing writing services? we are the best solution for you. We are best known for delivering nursing writing services to students without having to break the bank.

  15. Your blogs are great. Are you also searching for Help with my Math assignment? we are the best solution for you. We are best known for delivering quality essay writing services to students without having to break the bank

  16. At the point when a pot is connected to a plug and turned on the electric momentum moves through a metal curl, which is arranged either inside or under the water. The loop is, as a result, a warming component and its opposition (the material's endeavors to stop power coursing through it) transforms the electrical energy into heat. kettlesboiler.com