Keyword Match Type Efficiency Watchlist
Breaks keyword performance by match type to spotlight costly low-efficiency segments for structure cleanup.
Script Code
Helpful for accounts where broad and phrase growth starts to outpace conversion quality.
Preview is public. Unlock full code with name and email.
/**
* ==========================================================
* Keyword Match Type Efficiency Watchlist
* ==========================================================
* Description: Flags costly low-conversion keyword segments
* by match type.
*
* Copyright (c) 2026 TwoSquares. All Rights Reserved.
* Developed by Kiril Ivanov
*/
function main() {
var SPREADSHEET_URL = "";
var SHEET_NAME = "Match Type Watchlist";
var LOOKBACK_DAYS = 30;
// ... preview shortened
}About This Script
Keyword Match Type Efficiency Watchlist aggregates keyword performance by campaign/ad group/match type and flags segments with weak efficiency signals. It helps teams decide where broad/phrase controls need tightening.
The script applies conversion and spend thresholds and calculates CTR/CVR/CPA context, producing a clean action list for match-type and negative strategy refinement.
Output supports your resilient sheet standard: blank URL auto-creates a spreadsheet; provided URL writes to existing spreadsheet and creates tab when missing.
Implementation Notes
- Set LOOKBACK_DAYS, MIN_CLICKS, and MIN_COST for your account size.
- Run once manually to check signal quality by match type.
- Prioritize high-cost low-conversion rows for keyword structuring.
- Schedule weekly during scaling periods.
More Scripts In This Library
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.
Keyword Quality Score Risk Watchlist
Finds enabled keywords with low Quality Score and meaningful traffic to prioritize relevance and landing page fixes.
Keyword Zero-Conversion Cost Watchlist
Flags enabled keywords with meaningful spend and zero conversions, with optional auto-created sheet logging.
MCC Negative Keyword Conflict Checker
Runs across manager-account children, compares enabled keywords to campaign and ad group negatives, and exports likely conflicts into Google Sheets.
Keyword Match Type Efficiency Watchlist FAQs
Common setup, usage, and troubleshooting questions for this script.