Keyword Quality Score Risk Watchlist
Finds enabled keywords with low Quality Score and meaningful traffic to prioritize relevance and landing page fixes.
Script code
Practical weekly script to focus on low-Quality-Score keywords that are most likely hurting efficiency at scale.
Preview is public. Unlock full code with name and email.
/**
* ==========================================================
* Keyword Quality Score Risk Watchlist
* ==========================================================
* Description: Flags low-Quality-Score keywords with enough
* traffic to justify optimization.
*
* Copyright (c) 2026 TwoSquares. All Rights Reserved.
* Developed by Kiril Ivanov
*/
function main() {
var SPREADSHEET_URL = "";
var SHEET_NAME = "QS Risk Watchlist";
var LOOKBACK_DAYS = 30;
// ... preview shortened
}За този script
Keyword Quality Score Risk Watchlist identifies active keywords with poor Quality Score and significant impression/click volume. It helps teams prioritize improvements where expected CTR, ad relevance, and landing page experience are likely underperforming.
The script combines Quality Score with traffic and conversion context, so prioritization is based on business impact rather than score alone.
Spreadsheet output follows your standard workflow: blank URL auto-creates a file, while a provided URL writes into that file and creates the sheet tab if missing.
Implementation notes
- Set LOOKBACK_DAYS, MAX_QUALITY_SCORE, MIN_IMPRESSIONS, and MIN_CLICKS.
- Run once manually to validate thresholds for your account size.
- Prioritize top rows by impressions and cost impact for copy and LP updates.
- Re-run weekly and track improvement in CTR/CVR and Quality Score.
Още scripts в библиотеката
Предишен script
Keyword Match Type Efficiency Watchlist
Следващ script
Keyword Zero-Conversion Cost Watchlist
Keyword Low-CTR Check
Finds high-volume keywords with weak CTR, ranks them by priority, and can email a daily optimization digest for faster ad relevance fixes.
Hour-of-Day Waste Finder
Finds costly non-converting hours using segments.hour to support ad schedule optimization, with optional sheet output.
Keyword Match Type Efficiency Watchlist
Breaks keyword performance by match type to spotlight costly low-efficiency segments for structure cleanup.
Keyword Zero-Conversion Cost Watchlist
Flags enabled keywords with meaningful spend and zero conversions, with optional auto-created sheet logging.
Keyword Quality Score Risk Watchlist FAQs
Чести setup, usage и troubleshooting въпроси за този script.