Uses ChatGPT to score how well each search term matches the ad copy it triggered, with short AI explanations, so you can spot relevance gaps and messaging misfires.
by Charles Bannister (shabba.io)·shabba.io/google_ads_scripts/ai-search-terms-vs-ad-copy
Proofreads every enabled RSA for outdated years, double spaces, repeated punctuation, placeholder text, policy-risky ALL-CAPS words and stray spaces — the embarrassing details reviews always miss.
Ad Strength distribution across all enabled RSAs plus a worklist of POOR and AVERAGE ads ranked by impressions — so rewriting effort goes where the traffic actually is.
Write RSAs in a Google Sheet — one row per ad, 15 headline and 4 description columns — and the script validates character limits and creates them in bulk. Copywriters work in the sheet; nobody pastes ads into the UI one by one.
Finds the silently broken ad insertions: countdowns pointing at past dates, keyword-insertion defaults that are empty or too long, and malformed braces that serve literally as ad text.
Finds RSAs with identical headline sets reused across multiple ad groups — the copy-paste ads that show the same generic message everywhere regardless of each ad group's keywords.
Finds promotion assets whose redemption window has passed but that are still attached to campaigns, plus promotions expiring within the week — so ad real estate never quietly goes dark.
Pulls recent search terms with their triggering ads and asks ChatGPT to rate the relevance between the query intent and your ad copy, returning a short explanation for each. Results land in a Google Sheet so you can prioritize ad rewrites or negatives. Useful for finding where your ads promise the wrong thing.
| Variable | Default |
|---|---|
SPREADSHEET_URL | YOUR_SPREADSHEET_URL_HERE |
LOOKBACK_WINDOW_DAYS | 30 |
MINIMUM_CLICKS | 1 |
OPENAI_SETTINGS_SHEET | settings |
OUTPUT_SHEET_NAME | results |
DEBUG_MODE | true |
Evaluated 60 search terms with ChatGPT. "emergency plumber near me" vs ad "Book a Plumber Online" — 6/10: ad omits emergency/urgency. Wrote scores + explanations to the results tab.
EXTERNAL API REQUIRED: needs your own OpenAI API key (stored in the sheet) and calls the OpenAI API — usage is billed by OpenAI. Quality and cost depend on the model and volume of terms.