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.
PMax Placement Cleaner scans your Performance Max placement report for new website placements, fetches each page title, and matches them against your keyword and domain blocklists stored in a Google Sheet. Matching placements are automatically added as account-level negative placements. All checked placements are logged to the sheet so they are not re-processed.
Setup
1The script will auto-create a Google Drive folder structure: '๐ค chiliad scripts / {Account Name} / Placement Cleaner'.
2On first run it copies a template spreadsheet with three sheets: 'results' (checked placements), 'keywords' (title blocklist), and 'domains' (domain blocklist).
3Add unwanted keywords to the 'keywords' sheet (one per row) โ e.g. 'casino', 'adult', 'torrent'. The script matches these against page titles.
4Add unwanted domains to the 'domains' sheet (one per row) โ e.g. 'example.com'. The script matches these against placement URLs.
5
Ready to Use This Script?
Sign up to install this script with one click and manage it across all your Google Ads accounts.
In your Google Ads account, go to Tools & Settings โ Scripts.
6Click the + button to create a new script and paste the code.
7Authorize the script when prompted (it needs access to Google Drive, Sheets, and external URLs).
The script processes up to 500 new placements per run to stay within Google Ads script execution limits. It skips mobile app and YouTube placements. The template spreadsheet is copied from a shared Google Drive file on first run.