DSA Search Term Audit
Shows what your Dynamic Search Ads decided on their own: waste queries to negate, the landing pages absorbing DSA spend, and converting queries to promote into real keywords.
by Dmytro Tonkikh·chiliad.io
Shows what your Dynamic Search Ads decided on their own: waste queries to negate, the landing pages absorbing DSA spend, and converting queries to promote into real keywords.
by Dmytro Tonkikh·chiliad.io
Uses Claude AI to analyze your search terms and recommend negative keywords with clear reasoning. Each term is evaluated for business relevance, intent, and conversion potential — then exported to a Google Sheet with actionable suggestions.
Finds brand search terms leaking into non-brand campaigns (inflating their stats and misleading Smart Bidding) and generic traffic riding in brand campaigns — with the misrouted spend quantified.
Measures how much of your exact-match spend actually flows through close variants and lists the zero-conversion variants — the most surgical negative keyword candidates in the account.
Reads negative keywords and placement exclusions from a Google Sheet and syncs them to multiple campaigns via shared negative keyword and placement lists. Optionally filters to campaigns with a specific label.
Quantifies spend on search queries containing competitor names, with conversion performance and a period-over-period trend — whether competitor bidding is your strategy or your broad-match accident.
Finds identical keywords (same text and match type) active in multiple ad groups or campaigns, with per-instance performance so the keeper is obvious — ending the internal competition that splits history and muddies results.
Dynamic Search Ads pick their own queries and landing pages — this audit reports what they picked. Three lists, each ranked by cost: WASTE (DSA queries spending with zero conversions — the negatives that stop DSA drift), TOP PAGES (the landing pages DSA sends traffic to, where blog posts, careers pages and out-of-stock products surface fast), and HARVEST (converting DSA queries worth adding as real keywords in standard campaigns, which automatically stops DSA from serving them).
| Variable | Default |
|---|---|
DATE_RANGE | LAST_30_DAYS |
MIN_COST | 5 |
TOP_N | 25 |
EMAIL_ADDRESS | (empty) |
=== DSA Search Term Audit (LAST_30_DAYS) === DSA queries: 2841 DSA spend: 1840.20 --- WASTE QUERIES - zero conversions (negative candidates) --- "acme careers" (DSA — All Pages) cost: 68.40 clicks: 84 conversions: 0.0 --- TOP LANDING PAGES by DSA spend --- https://example.com/blog/how-to-choose-shoes cost: 112.75 clicks: 96 conversions: 0.0 --- HARVEST - converting queries to add as real keywords --- "trail running shoes women 42" cost: 84.10 clicks: 61 conversions: 6.0 Email sent to you@example.com
Only accounts with active DSA campaigns or ad groups produce data. For unwanted pages, exclude the URL (or fix the page feed); for waste queries, add DSA negatives — DSA negatives are ordinary negative keywords in the DSA ad group/campaign.