AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Ads
5.4K members online now
5.4K members online now
Dive into advanced features like Remarketing, Flexible Bid Strategies, AdWords Editor, and AdWords Scripts
Guide Me
star_border
Reply

Keyword Performance Script returns incorrect numbers

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

When running the Keyword Performance Script (the one here) in an account of a client I see in the spreadsheet that there's a keyword with a Quality Score of 1, which is incorrect as I can't find a keyword with such a Quality Score. What do I miss or could there be a bug in the script ? Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Pieter De Weirt
March 2016

Re: Keyword Performance Script returns incorrect numbers

[ Edited ]
Explorer ✭ ☆ ☆
# 2
Explorer ✭ ☆ ☆

Hello Pieter.


I trust that you searched through the account with the correct filters and didn't find the keyword with QS 1.

But since it was an Adwords script that found there is such a keyword, maybe you could use another script to actually find that exact keyword location.

Try this script:

function main() {
  
  // Run over the whole account's keywords
  var keywordIterator = AdWordsApp.keywords().get();
  
  while (keywordIterator.hasNext()) {
    var keyword = keywordIterator.next();
    var keywordQualityScore = keyword.getQualityScore(); //Get the keyword QS
    
    // Log keywords with QS 1 (could be changed to any other number or operator, e.g <=3)
    if (keywordQualityScore==1){
      var keywordText = keyword.getText();
      var keywordCampaign = keyword.getCampaign().getName();
      var keywordAdGroup = keyword.getAdGroup().getName();
      Logger.log("%s \t(Campaign '%s', Adgroup '%s') has QS: %s", keywordText, keywordCampaign, keywordAdGroup, keywordQualityScore);
    }
  }
}



This should give you the keyword, with the campaign and ad group its located in.
Let me know if it worked for you.

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Pieter De Weirt
March 2016

Re: Keyword Performance Script returns incorrect numbers

[ Edited ]
Explorer ✭ ☆ ☆
# 2
Explorer ✭ ☆ ☆

Hello Pieter.


I trust that you searched through the account with the correct filters and didn't find the keyword with QS 1.

But since it was an Adwords script that found there is such a keyword, maybe you could use another script to actually find that exact keyword location.

Try this script:

function main() {
  
  // Run over the whole account's keywords
  var keywordIterator = AdWordsApp.keywords().get();
  
  while (keywordIterator.hasNext()) {
    var keyword = keywordIterator.next();
    var keywordQualityScore = keyword.getQualityScore(); //Get the keyword QS
    
    // Log keywords with QS 1 (could be changed to any other number or operator, e.g <=3)
    if (keywordQualityScore==1){
      var keywordText = keyword.getText();
      var keywordCampaign = keyword.getCampaign().getName();
      var keywordAdGroup = keyword.getAdGroup().getName();
      Logger.log("%s \t(Campaign '%s', Adgroup '%s') has QS: %s", keywordText, keywordCampaign, keywordAdGroup, keywordQualityScore);
    }
  }
}



This should give you the keyword, with the campaign and ad group its located in.
Let me know if it worked for you.

Re: Keyword Performance Script returns incorrect numbers

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Thanks Arik for the useful script!

I found out that a keyword with QS 1 that was paused earlier this week, is counted by the keyword performance script.
The script checks for last week's performance numbers. I guess last week here is from Monday till Sunday ?
Guess I'll have to keep that in mind when checking the report next time.