Monday, April 22, 2013

Store Account, Campaign, AdGroup, and Keyword Level Quality Score

UPDATE: 2014-02-15 - I updated the script to v2.0 which speeds the script up dramatically, includes the ability to store data into a CSV and use whatever date range you like for the stats.

I've had a lot of good feedback on my previous script: Store Account Level Quality Score. To that end, I've been asked a few times about storing Campaign and/or AdGroup level quality scores as well so I figured it would be a good time for an update.

Below is a script that will attempt to store Account, Campaign, and AdGroup level quality scores for the top 50000 keywords in your account. It will store the results in a google spreadsheet. In order for this to work, you will need to set up a new google spreadsheet. with three sheets named Account, Campaign, and AdGroup. You can simply make a copy of my spreadsheet found here (File > Make a copy...) : Account, Campaign, AdGroup Quality Score Spreadsheet (No longer needed as of v1.1)

Thanks,
Russ

17 comments:

  1. Hi Russ, thanks for this awesome script. For some reason however, when I specify the date range to being the last 30 days, it only gives me yesterday's and today's data for the keywords in my account? To you know why this might be happening?

    Thanks

    Aniruddha

    ReplyDelete
    Replies
    1. It only start to collect data from the day you run it

      Delete
  2. Hi Russ! Thanks for the script! I'm trying to run the script, but I'm receveing this warning:
    "Invalid reporting query: KEYWORDS_PERFORMANCE_REPORT. (file Code.gs, line 165)"

    ReplyDelete
  3. I am also getting this error

    "Invalid reporting query: KEYWORDS_PERFORMANCE_REPORT. (file Code.gs, line 165)"

    ReplyDelete
  4. Hello,
    I got these 2 different errors in 2 different accounts:
    1. TypeError: Cannot read property "length" from undefined. (file Code.gs, line 106)
    2. This action would increase the number of cells in the workbook above the limit of 5000000 cells. (file Code.gs, line 104)

    Thanks for your amazing work.

    ReplyDelete
  5. I'm getting this error too - "TypeError: Cannot read property "length" from undefined. (file Code.gs, line 106)"

    ReplyDelete
    Replies
    1. Me too. I don't get it, because in older accounts the script still works.

      Delete
  6. Do you know where to submit a dissertation for proofreading? Here is https://dissertation-center.co.uk/dissertation-proofreading-services a good place!

    ReplyDelete
  7. Eliminate keywords which have search volumes so small that they could not generate enough traffic to our site to make them worthwhile. I usually toss keywords that have less than 3000 monthly global searches.keyword wrapper tool

    ReplyDelete
  8. I have recently started a blog, the info you provide on this site has helped me greatly. Thanks for all of your time & work.WordPress

    ReplyDelete
  9. Custom Healthcare Essay Writing Services is very popular for students in search for healthcare assignment writing services and healthcare research paper services.

    ReplyDelete
  10. English literature assignment writing services are essential for English literature coursework writing service students and English Literature Writing Services seekers.

    ReplyDelete
  11. this blog is a gold mine, tracking my clients Vitalefy Quality score has never been more eaiser

    ReplyDelete
  12. This article is enlightening lastly I got what I needed. Thanks much for this sort of data and keep it up. Audit firm in Delhi

    ReplyDelete