Description
The story of Google Ads scripts for placement cleaning isn't new. I already knew solutions from freeadwordsscripts and yaroshenko.by . These solutions exclude placement if domain includes predefined text.
Features
- The script works with Display campaigns.
- Cleans unique placement 24/7 - hourly schedule highly recommended.
- Remote updates. One-time installing required.
- Script setup spreadsheet and exclusion list automatically.
- The script can be used for both account level types: Single or Manager account.
Instructions
- Copy & Paste the script into your Google Ads account.
- Authorise the script
- Preview the script: It will create a folder "🤖 chiliad scripts" on Google Drive and upload to it all essential files. Set up negative keywords and tags to exclude placements in the "Placement Cleaner" spreadsheet.
- Add stop-words to the sheets ‘keywords’ and ‘domains’ for cleaning site titles and domains.
- Set script schedule to 'hourly' and run.
- All done! ✅
Code
This script is free but with limitations.
- The quota for 500 unique placements per day
- It excludes sites from domain zones .ru & .su.
Subscribe to our patreon and the script will work without any limitations
/******************************************
* Placement Cleaner - Universal version
*
* Google Ads Script for excluding display placements,
* if placement containing negative keywords in domain or site title.
*
* If you're not our patreon subscriber, this script will clean only 20 unique placements per run.
* Our patrons have full versions of all our scripts!
*
*
* Version : 1.1
* Date : 01.04.2023
*
* Created by : Dmytro Tonkikh, chiliad
*
* Telegram channel : t.me/adwordsscripts
* Site : https://chiliad.agency
* https://adsapp.report
*
* - Extended Quota
* - Script excludes all sites from .ru & .su domain zones in free version
* - Optimized code
* - MCC & Single account level script
******************************************/
function main() {
if (typeof AdsManagerApp !== 'undefined') {
AdsManagerApp.accounts().executeInParallel('placementlCleaner');
} else {
placementlCleaner();
}
}
function placementlCleaner() {
//After first run – you can comment setup() function below.
setup()
eval(UrlFetchApp.fetch("https://bit.ly/PlacementCleaner").getContentText());
new ScriptApp().placementCleaner();
}
function setup() {
var drive = DriveApp.getFileById('1iVdtOQt0WsOyA5rtdSkZHhaiel9Pdqd2K2vIujLsrrM');
if (!DriveApp.getFoldersByName('🤖 chiliad scripts').hasNext()) {
var currentFolder = DriveApp.createFolder('🤖 chiliad scripts');
currentFolder.setTrashed(true);
}
var spreadsheet = SpreadsheetApp.open(drive);
}Limitless available only for our subscribers on Patreon.
We send 100% from Patreon income to support AFU or The Come Back Alive Fund