Skip to content

Installation Guide

Jump to bottom
John Williams edited this page Jul 16, 2026 · 1 revision

Installation Guide — Google Ads Scripts Setup (2 Minutes)

How to install any of the Unblock Converted Keywords scripts in your Google Ads account. No API tokens, no developer account, no external services — Google Ads Scripts run natively inside your account.

Prerequisites

  • Admin or Standard access to the Google Ads account (or MCC for the MCC version)
  • A blank Google Sheet for the report (optional but strongly recommended)

Step 1 — Open the Scripts Editor

Single account (CID): Google Ads → Tools & Settings (wrench icon) → Bulk Actions → Scripts

Manager account (MCC): same path, but from the MCC — required for mcc_negative_conflict_cleaner.js

Step 2 — Create the Script

  1. Click the blue + button
  2. Name it (e.g. Blocked Search Term Recovery — AHMEEGO)
  3. Delete the placeholder code
  4. Paste the entire script from the scripts/ folder

Step 3 — Authorize

Click Authorize when prompted. The script needs:

  • Google Ads access (to read keywords/negatives and perform removals)
  • Google Sheets access (to write the report)

Step 4 — Configure

At the top of every script is a CONFIG block:

var CONFIG = {
  DRY_RUN: true,                    // ALWAYS start with true
  SPREADSHEET_URL: '',              // paste your blank Google Sheet URL
  LOOKBACK_DAYS: 180,               // recovery script only
  MIN_BLOCKED_CONVERSIONS_TO_REMOVE: 1,
  REMOVE_ACCOUNT_LEVEL: true,
  REMOVE_CAMPAIGN_LEVEL: true,
  REMOVE_ADGROUP_LEVEL: true,
  REMOVE_FROM_SHARED_LISTS: true,
  MAX_BLOCKED_BEFORE_SKIP: 25       // conflict cleaner only
};

Recommended first-run settings:

  • DRY_RUN: true — report only, zero changes
  • Paste your Google Sheet URL so you get a reviewable report

Step 5 — Preview, Review, Run

  1. Click Preview — the script runs read-only and writes its report
  2. Open your Google Sheet and review every row
  3. If the removals look right, set DRY_RUN: false and click Run

Step 6 — Schedule (Optional)

Set a frequency (weekly is typical) in the script's schedule column. If auto-applied recommendations keep re-adding bad negatives, a weekly schedule keeps the account clean.

Reading the Report

Every run writes a new tab to your sheet:

Column Meaning
Level ACCOUNT / CAMPAIGN / AD GROUP / SHARED LIST (PMax flagged explicitly)
Negative Keyword + Match Type Exactly what was evaluated
Blocked Conversions / Value / Clicks What that negative was suppressing (recovery script)
Top Blocked Terms The best queries it was blocking, with per-term conversions
Action REMOVED / KEPT / SKIPPED / DRY RUN — nothing happens silently

The Action column is also your undo log — every removed negative's text, match type, and scope are preserved so re-adding takes seconds.

Next Steps

Part of the AHMEEGO™ open-source Google Ads toolkit by It All Started With A Idea LLC. Questions? Post in r/ppc_.

Clone this wiki locally