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
Thanks,
Russ
/**************************************** * 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") .get(); 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(kwBidHash[kwKey][4]); }else{ kw.setMaxCpc(kw.getMaxCpc() * (1+kwBidHash[kwKey][4])); } } } }
Do you know how to motivate students on coding? Here are https://pro-essay-writer.com/blog/motivating-students some tips!
ReplyDeleteThe 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
ReplyDeleteThanks 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.
ReplyDeleteAre 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
ReplyDeleteTranslate 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
ReplyDeleteBe 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
ReplyDeleteOn the off chance that it was your issue, guarantee full duty regarding whatever occurred and issue a sincere statement of regret
ReplyDeletebuy reviews on google
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.
ReplyDeleteI really loved reading your blog. It was very well authored and easy to understand. Calgary SEO Agency
ReplyDeleteToday'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
ReplyDeleteThis 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
ReplyDeleteI 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
ReplyDeleteI was able to find good info from your articles.
ReplyDeleteدانلود سریال قورباغه دانلود سریال قورباغه دانلود سریال قورباغه دانلود سریال قورباغه دانلود سریال قورباغه
tanx for post
ReplyDeleteدانلود کتاب صوتی هنر شفاف اندیشیدن دانلود کتاب صوتی هنر شفاف اندیشیدن
دانلود کتاب صوتی هنر شفاف اندیشیدن دانلود کتاب صوتی هنر شفاف اندیشیدن
Great article!
ReplyDeleteدانلود کتاب صوتی قدرت عادت
دانلود کتاب صوتی قدرت عادت دانلود کتاب صوتی قدرت عادت
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
ReplyDelete