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
Overview
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).
Setup
- 1Open your Google Ads account and go to Tools → Bulk Actions → Scripts.
- 2Click the + button to create a new script and paste the code below.
- 3Adjust MIN_COST to your account's scale.
- 4Set EMAIL_ADDRESS to receive the report; leave blank for logs only.
- 5Preview once to verify, then schedule weekly.
Configuration Variables
| Variable | Default |
|---|---|
DATE_RANGE | LAST_30_DAYS |
MIN_COST | 5 |
TOP_N | 25 |
EMAIL_ADDRESS | (empty) |
Expected Output
=== 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
Notes
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.