If you run a grant account, low quality scores and low CTRs are a real pain. Anything below a QS of three or a CTR of 5% and you’re bust! This script is tailored for grant accounts needing a bit of extra help.
This is a modified version of our n-gram performance script, with the goal of preventing grant accounts from being suspended with the inclusion of quality scores.
It produces a search query report with impressions, average CTR, and calculates an average quality score of search queries containing the n-grams. You can then use filters on the spreadsheet, so it only displays results with CTR < 5% or an average QS < 3.
This will help inform you where strategic 1 or 2 word negatives, for example, could increase your CTR, by ensuring your ad won’t appear on searches with a low chance of getting a click. If you see instances of high performance, you might instead make new ad groups around the n-gram.
It can also help you identify common themes in keywords that give a consistently low-quality score, so you can deal with them more easily by improving ad copy or simply removing any underperforming terms from the account.
The report shows data at campaign-level as well as ad group-level. You’ll also get a word count analysis, showing what amount of words performs best.
Go to your account in the Google Ads interface, go to Bulk Actions, choose Scripts, then make a new script and paste in the code at the end of this article.
Then make a new Google spreadsheet, and copy and paste its URL in the code options (where it says ‘var spreadsheetUrl = “https://docs.google.com/YOUR-SPREADSHEET-URL”).
You can also edit the following variables according to your needs:
If you have any issues with the script timing out because your account is too big, try running it a few times using campaignNameContains and campaignNameDoesNotContain to look at different campaigns.