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

Become a Chiliad patron

/******************************************
 * 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

Support us on Patreon. Support Ukraine 🇺🇦 !