Collects placement data from Performance Max, Display and YouTube campaigns into a Google Sheet with checkboxes, then excludes the placements you tick — with optional ChatGPT content analysis.
by Charles Bannister & Erik Arter (shabba.io)·shabba.io/google_ads_scripts/placement-exclusions
Ensures all Search, Shopping, Display, Video, and PMax campaigns have required placement exclusion lists and negative keyword lists associated, automatically adding missing ones.
Finds Display and YouTube placements with low CTR or high CPA and excludes them from campaigns. Runs in dry-run mode so you can review the list before applying.
Audits every Performance Max asset group for weak Ad Strength, missing uploaded video (before Google auto-generates one), and thin headline/description/image counts.
Automatically identifies and excludes undesirable placements from Performance Max campaigns. Fetches placement URLs, checks page titles against keyword and domain blocklists, and adds negative placements in bulk.
Automatically identifies and excludes YouTube channels that contain kids content, blacklisted keywords in titles, or blacklisted tags from your video campaign placements.
The video metrics that matter per campaign: view rate, CPV, quartile retention (25/50/75/100%) and conversions — showing exactly where each creative loses its audience.
Gathers where your ads actually showed across Performance Max, Display and Video/YouTube, writes them to a Google Sheet with checkboxes (YouTube channels/videos on their own tab), and on the next run excludes everything you ticked. Optional ChatGPT integration analyzes website content to help you decide. Use it to clean up junk placements without hunting through the UI.
| Variable | Default |
|---|---|
SPREADSHEET_URL | YOUR_SPREADSHEET_URL_HERE |
DEBUG_MODE | false |
DISABLE_REPORTING | false |
Collected placements: 320 website, 45 YouTube channels, 12 mobile apps. Wrote to Output tabs with checkboxes for review. Next run: excluded 28 ticked placements across PMax/Display/YouTube.
EXTERNAL API OPTIONAL: ChatGPT website analysis needs your own OpenAI API key (billed by OpenAI); the script works without it. Requires a copied Google Sheet template. Co-authored by Erik Arter (idea via the God Tier Ads community). PMax placement exclusions apply account-level negative placements.