Wednesday, March 20, 2013

Store Account Performance Report in a Google Doc

Day 2 and I'm still playing around with the new reporting API. I figured I'd post something that people started asking a little about from my previous post about Storing Account Level Quality Score which is storing all account level performance in a spreadsheet.

All you need to do is create a brand new Google Doc to store your data and paste that url into the script. The first time the script runs, it will create column headings. You can add, remove, or rearrange columns as you like by moving the column names around. You should reset your spreadsheet after doing this though.


* Store Account Performance Report in a Google Doc
* Version 1.1
* Changelog v1.1 - Removed apiVersion, Removed get spreadsheet
* Created By: Russ Savage
function main() {
  var spreadsheet_url = "Your Spreadsheet Url Goes Here";
  var date_range = 'YESTERDAY';
  var columns = ['Date',
  var columns_str = columns.join(',') + " ";
  var sheet = SpreadsheetApp.openByUrl(spreadsheet_url).getActiveSheet();
  if(sheet.getRange('A1:A1').getValues()[0][0] == "") {
  var report_iter =
    'SELECT ' + columns_str +
    'DURING ' +date_range).rows();
  while(report_iter.hasNext()) {
    var row =;
    var row_array = [];
    for(var i in columns) {


  1. i see computer, mobile and table populate...

    any way to get each of those 3 in their own sheet?

    ps - any way to post this data into a sheet that is outside the adwords account?

  2. Hi Russel,

    How to use "CONTAINS" (or equivalent) in "SELECT" statement?


    1. Hi Renjith, Sorry for not getting back to you. You can find more information about writing AWQL queries here: The AdWords Query Language (AWQL).

      The short answer to your question is to add a WHERE clause just before the DURING in the query above. Then you put your conditions. For example, "WHERE CampaignName IN ['Campaign 1','Campaign 2']".


  3. Nice article. I have read the whole article.It is nicely explained. People who are stuck in storing account level quality score should read this to clear their doubts. If you have any problem regarding Norton, please visit Norton Setup

  4. I would try to make a report for this page as an example given. Thanks!

  5. You can likewise disclose to Google how regularly your pages are refreshed and the date that each page was last adjusted. For instance your landing page may be refreshed each day, while a specific item page may just be refreshed on a yearly premise. finance

  6. I gotta favorite this website it seems very helpful . clenbuterol achat

  7. I am looking for and I love to post a comment that "The content of your post is awesome" Great work! Agentur für Google Adwords

  8. Quickbooks support is a tech help assistance provider for the issues in quickbooks like installation error, setup fails, login id fails, etc and in order to fix them you need to contact quickbooks support and they will provide you quickbooks customer support number and from there you will get Quickbooks support

  9. QuickBooks support is a reliable accounting software that makes the workflow super easy for the accountants. With numerous automated features, it allows the users to save precious time. Many firms use the QuickBooks suppoort program to manage their accounts effectively. There are some issues that such as the code H202 and issues related to QuickBooks desktop, which can be fixed by connecting with QuickBooks desktop support. Quickbooks Support | Quickbooks Desktop Support

    another link | | office setup | office com setup

  10. includes applications like PowerPoint, Outlook, to install on your device. Everything you need is to install Every application is key to reduce the work. This software is made with the latest features so you can easily install it. You can easily make a presentation with this software.
    It gives a complete set of tools that you need to get the work done. | | office setup | office com setup

    another link:

    Quickbooks Support | Quickbooks Desktop Support

  11. You possess lifted an essential offspring..Blesss for using..I would want to study better latest transactions from this blog..preserve posting.. In this particular article, you will see a summary, satisfy browse this post.

  12. I've heard some people say that your ads need to go here or they're on your Website. To a certain point they are correct. What works in offline ads often does the same online. Draw an imaginary "Z" on your monitor's screen. Where the path of the "Z" is at is where you want your ads to fall on the page.Free Negative Keyword List Generator

  13. free robux is the best online gaming currency generation website to unlock new gaming accessories and characters in the game.
    This is because of the free robux hack found by us.

  14. This comment has been removed by the author.

  15. Don't worry about tax slab you can get all your information from the site viewmypaycheck in easy step just check the website you will learn all thing viewmypaycheck

  16. immediately discovered that those ads are set by Google who just engages publicizing spending plans of huge extent.Free Google Ads Audit

  17. An AdWords account review is the way toward assessing the general adequacy of your showcasing efforts and make your record run easily so as to build your ROI. Google Ads Expert

  18. Any numbers of tokens can be drawn. All you need to do is to choose with the type of Chaturbate tokens that you need the most.
    use of the coinmaster free spins to keep moving ahead of your enemies.

  19. If you are using the software of QuickBooks and if you face any kind of issue or error in QuickBooks then use QuickBooks support number.

  20. Quickbooks software provide Business Account related problem. If you have any problem in your Account related. visit Quickbooks online Support

  21. we have access to free Xbox Live Gold accounts on this site, so many can find these codes and our subscribers will be very tired
    xbox live codes reddit

  22. Nice to be visiting your blog again, it has been months for me. Well this article that i’ve been waited for so long. I need this article to complete my assignment in the college, and it has same topic with your article. Thanks, great

  23. Well the guidelines have changed. The web currently gives a disappointed voice a scope of thousands with a practically interminable time breaking point to reviews on google

  24. for any business, accounting is an important factor and you can do that with the help of Quickbooks which is an advanced accounting tool that offers multiple accounting features and in case you need any help assistance regarding Quickbooks you can contact Quickbooks support and ask for Quickbooks support

  25. Nice blog and it is very helpful!
    QuickBooks Proadvisor Support Phone Number
    Facing problem or Error with QuickBooks Get Instant tech support with 24*7 QuickBooks Proadvisor Support Phone Number 844-908-0801

  26. We are here to solve your problem related to QuickBooks just make a call get instant solution Quickbooks Payroll Support Phone Number 844-908-0801

  27. if you are facing any kind of error while using McAfee activate then you can simply visit our website where we cover all-most each and every error in details, also you can get help from our technical assistant. we are 24*7 available for our users.

  28. Nice blog and very helpful!
    Facing Error and any glitch with QuickBooks Dial On Our 24*7Quickbooks Support Phone Number844-908-0801

  29. Arrival of technical errors in QuickBooks is a common issue. But don’t fret, Our QuickBooks experts come to the rescue by giving quick response. Dial QuickBooks Technical Support Number 855-9O7-O4O6.

  30. Nice content!
    Getting Error and issue with QuickBooks.
    Get solution with our Quickbooks Support Phone Number 844-908-0801

  31. We provide technical help for all of the QuickBooks issues that are users are facing. We deliver solutions taking just a few seconds only.Avail benefits from our support team dial QuickBooks For Mac Support Phone Number 1-855-907-0406.

  32. Thank you very much for sharing this kind of beautiful article! Please keep share more article like this. If you want to play Bubble Shooter game online without paying any extra charge, so just follow our bubble games website free bubble shooter and enjoy this entertaining game.

  33. Nice content and well explained!
    QuickBooks provide 24*7 tech Support to resolve any QuickBooks issues and problem.
    Dial our QuickBooks technical Support Phone Number +1-844-908-0801

  34. Facing issues and error with QuickBooks.Get instant solution with our expert.
    Visit for more info QuickBooks error 6073
    Dial on tech Support Number +1-844-908-0801.

  35. Nice blog!
    Get solution regarding QuickBooks with our Expert.
    Dial on our QuickBooks Support Phone Number +1-844-908-0801.

  36. QuickBooks Online Support || +1-888-308-0575 || New Jersey(USA)~how to contact customer care
    Our Technical expert give the solution immediately. QuickBooks Support is an accounting Software. You can take help our QuickBooks Online Support. Which is help you to efile your tax. If you have any technical issue regarding installation of QuickBooks Support Accounting Software. You can contact our technical Expert 24/7. They resolve your query immediately.

  37. QuickBooks Online Support || +1-888-308-0575 || Oregon(USA)~Customer care Number
    If you have any technical issue regarding installation of QuickBooks Support Accounting Software. You can contact our QuickBooks Online Support 24/7. They resolve your query immediately. Our Technical expert give the solution immediately. QuickBooks Support is an accounting Software.

  38. Quickbooks customer service is an international support service that helps you to get instant help, advice and answers from the Quickbooks online team, for any query you can call us, you can also check our site and click on help there, you get solutions to your @ You can contact us from anywhere (Quickbooks customer service provides you phone numbers according to your state/country) . We are 24/7 available for you. If you want solutions to all your problems then can’t wait, just call us and you get the solution to all your problems.

  39. QuickBooks Payroll Support service helps you to build your business, track your inventory and manage your profits. In their advanced inventory management helps to track items by serial number, bin location and transfer between warehouses. For any kind of information call us on our QuickBooks Payroll Support toll-free number +1-888-308-0575 on 24/7. Our expert team helps you to solve any kind of problem.

  40. QuickBooks Help +1-805-617-3111 that helps to manage your business Account and company from one device or computer.that software manages any time anywhere. Quickbooks Cloud-based Accounting software with the help of advance online Accounting Application software. You can easily track and manage your Account.

  41. In this era, QuickBooks comes under the best accounting software if you are working on QB cloud based accounting software and start facing issues while performing financial accounting tasks then connect rapidly on our QuickBooks Help +1-805-617-3111 to solve the issues instantly.

  42. Quick Help? Instant Help? If you are willing for appropriate results by Quick and reliable solutions just call on ourQuickBooks Help +1-805-617-3111 and settle down the queries in just a few seconds, All QB users can contact us whether beginners or experienced users. There is no discrimination in our service.

  43. QuickBooks error support number can be very useful if you are using QuickBooks account software for your small and medium sized business. Accounting software plays an important role in business accounting and makes your business accounting easy. So it is also important that you should take care of your accounting software as your business. If you are using QuickBooks accounting software then we are here to take care of it at our QuickBooks technical support service to resolve all your technical and functional errors through our toll-free QuickBooks phone number.
    QuickBooks Online Support

  44. Well explained!
    QuickBooks provide 24*7 live support get instant solution with Our expert.
    Dial QuickBooks Support Number +1-844-908-0801.

  45. Well explained
    Get effective Solution of QuickBooks best accounting software just get in touch with expert for instant solution.
    Dial QuickBooks Customer Service Number +1-844-908-0801.

  46. Nice Blog !
    Reach us whenever you feel difficulty in solving any QuickBooks issues. The experts will assist you 24*7. Just take your phone and dial our QuickBooks Support Phone Number Inidiana 1-855-6OO-4O6O.

  47. Nice Blog & Informative Blog !
    Resolve QuickBooks Error 6123 0 with effective solution. If you want instant aid, contact us at 1-855-6OO-4O6O. The error 6123 0 usually arrives while upgrading the software, restoring a back-up or opening a company file over a network.

  48. Mcafee activate product key Antivirus software works to block viruses from entering your computer system and kill or quarantine viruses that have some broken.Download, Install and Activate your mcafee product card from mcafee live safe, mcafee total protection, internet security, mcafee removal tool

  49. Nice Blog!
    Know More About How to Delete Deposits in QuickBooks? Get live support 24*7 from QuickBooks expert on tool-free Number.
    Click here to know How to Delete Deposits in QuickBooks
    Dial for any tech support: 1-844-908-0801

  50. QuickBooks Payroll Error 61102 occurs mainly when users send the payroll information to Intuit without giving PIN or password.If you still have any doubt or query regarding the process, you can consult our QuickBooks experts at 1-855-6OO-4O6O.

  51. if you are playing fortnite but don't have enough vbucks to unlock favorite character then you can download v-bucks generator by this you can create unlimited vbucks and unlock your all favorite characters.

  52. if you are playing roblox game. you can try free robux generator to create robux


  53. QuickBooks provide Premier Support for QuickBooks User to make QuickBooks more easy and fruitful.
    Dial +1-855-511-6911 QuickBooks Enterprise Support Phone Number

  54. Accountants always want to get help from those experts who are able to provide assistance with 100% satisfaction, then you can simply dial the QuickBooks Phone Number. QuickBooks Support is committed to serve 100% satisfaction and give extraordinary and the best QuickBooks services. And QuickBooks Accounting Software has many of the services and tools by which you can get complete support for handling all the easy & tough business accounting tasks.

  55. Many people say go with top packers and movers Pune but the truth is they are very expensive. So you can go with a local packers and movers pune / packers and movers Chennai near you.

  56. Well explained and informative blog. To get QuickBooks Support click bellow or dial our Support Phone Number.

    QuickBooks Customer Service Phone Number 1-855-600-4060
    QuickBooks Phone Number 1-855-600-4060
    QuickBooks Support Number 1-855-600-4060
    QuickBooks Customer Service Number 1-855-600-4060
    QuickBooks Customer Service 1-855-600-4060
    QuickBooks Customer Support Number 1-855-600-4060
    QuickBooks Customer Support 1-855-600-4060

  57. Really interesting Article , if want to play Roblox then you can try free robux hacks


  58. Superb website you have here but I was wondering if you
    knew of any community forums that cover the same topics
    discussed in this article? I’d really like to be a part
    of community where I can get advice from other knowledgeable individuals that
    share the same interest. If you have any suggestions, please let me know.
    Bless you!

    Tamil Songs

  59. Sign up for a matka game if you want to make extra money. You will get perfect guessing by top guesser and fast matka result at dpboss

  60. Initiating from the data gathering stage, the whole process requires performance indicators or performance evaluation metrics that could measure the steps time to time that will stop the issue at an early stage. data science course in hyderabad

  61. It is very significant to invest in a little time and energy to market yourself and product power in the Google + search results. The good part is that it is free and being pictorial, it is your image setter. internet email address extractor

  62. After you input your telephone number and country, Google will hunt to ascertain if your listing currently is out there. Bear in mind you're able to change an active listing anytime to present fresh information about your business. how to extract email addresses from google

  63. Nice Blog !
    Are you getting frustrated while experiencing technical glitches & issues in QuickBooks For Mac? Don’t get troubled!! Here is the solution!! By just dialing our QuickBooks For Mac Support Phone Number 1-888-597-O22O.

  64. Thanks for the post keep sharing great stuff


  65. If bugs and technical glitches troubling you then one and foremost thing to do is to dial
    QuickBooks Support Toll-free Number +1(844)233-3033 . A number that will lead you to the team of QuickBooks experts who are ready to help users like you at any time of the day with their best of knowledge and experience.

  66. Is your smooth-running work-process getting hindered by encountering technical faults & issues in QuickBooks on a frequent basis? Don’t get puzzled!! Here is your answer!! By just getting connected with our QuickBooks Customer Support 24/7 +1(844)233-3O33, you can fix all your QuickBooks concerning hassles.

  67. دانلود آهنگ جدید ایرانی و ترکی با بهترین کیفیت و لینک مستقیم از سایت موزیکدل

  68. In case you're inexperienced with utilizing G Suite for your business, you will need to look at it. Particularly since I'll be looking at utilizing Google Drive and G Suite to rank your neighborhood business. Lead generation website

  69. Want to submit the well-made SPSS assignments? No worries, get the SPSS Assignment Help here.

  70. Informative post. Quickbooks is an accounting software used to maintain or create accounts details and records for the business and companies and in case you need any assistance contactquickbooks tool hub tech support and ask for sloution

  71. Quickbooks is the software that used for accounting and bookkeeping . It is very simple process to create new account on Quickbooks just click this How to set up Quickbooks direct deposit

  72. Wow! What information is? I have no words to how to appreciate your knowledge. It’s such an outstanding post for all. Please keep sharing again with us this type of information.
    AOL is a popular email service provider all over the world. Users can easily set up their AOL Email account on your Windows 10 operating system. But Certainly, some users have complained about AOL Mail Not Working On Windows 10. If you are experiencing this issue in Windows 10, then you can contact our AOL Email Supports Technical Team via a toll-free number. They will provide you simple instructions to fix AOL Mail Not Working issues. For More Information, you may visit our website.