📗 This content is the Keywords Ninja Script user manual, the same one the script writes in the «Manual» tab of its spreadsheet. Here you can search it, listen to it, highlight it and save it to favourites.
Column order (v9.5.0). The positives sheets (ACD, B2B, etc.) have 19 columns: A=Search term · B=Source keyword · C=Mode · D=☐Add · E=☐Exclude · F=☐Ignore · G=AdGroup H=CTR · I=%Conv · J=CPC · K=AvgCPC · L=Score M=Impressions · N=Clicks · O=Cost · P=Conversions · Q=Cost/Conv R=Campaign · S=Date
🆕 v9.5: column C (Mode) sits next to Source keyword so you have all the context of the term (source + how it was detected) before deciding. Mode keeps its background colour: blue=Mode 1, yellow=Mode 2, red=Mode 3.
How it works. Unlike earlier versions, the script NO LONGER adds keywords automatically. It lists the candidates in the positives sheet with THREE checkboxes per row:
• ☐ Add → adds it to Google Ads with the match types from A13 • ☐ Exclude → adds it as an EXACT match NEGATIVE at CAMPAIGN level • ☐ Ignore → drops it (it is not added, just removed from the list)
Every time the script runs it first processes the ticked actions and removes the processed rows from the list. Then it generates new candidates.
Recommended flow. 1. The script lists candidates overnight. 2. You review the sheet in the morning and tick the boxes you want. 3. That same night the script carries out your decisions and removes the processed rows. 4. The Monday weekly email includes a '⏳ Waiting for your approval' block with every keyword without an action so they do not pile up forgotten.
Priority when several boxes are ticked. If you tick more than one box on the same row by mistake, the script applies this priority: Add > Exclude > Ignore.
Match types. When you tick ☐ Add, the keyword is created with ALL the match types listed in A13 at once. For example, if A13 = 'Exact,Phrase', 2 keywords will be created (one exact and one phrase).
Statistics. The processing statistics are written 3 rows below the last keyword listed. They include: candidates generated, waiting for approval, actions applied in this run and a breakdown by mode (with a counter of terms blocked by the triple protection — see the next section).
🛡️ Triple Protection (v9.6). Once you process a keyword (Add/Ignore/Exclude), the script guarantees it will NOT show up again in future runs. Three mechanisms working in parallel:
1️⃣ EXISTING KEYWORDS → if a keyword you added already exists in the AdGroup, the script detects it via the Google Ads API and skips it. 2️⃣ CAMPAIGN NEGATIVES → if an excluded term is already a negative in the campaign, the script skips it. 3️⃣ IGNORED HISTORY → every time you tick '☐ Ignore' it is recorded in the 'Actions' tab. The script checks that tab and drops previously ignored terms.
The counters show up in the statistics as 'Blocked (existing kw / negative / ignored)'.
How to undo an 'Ignore'. If you ignored a term by mistake and want it back as a recommendation, open the 'Actions' tab (grey) and delete that specific row (action='IGNORE'). It will be able to be recommended again on the next run.
⚠️ Actions are ONLY carried out on the script's next run. If you tick a box and open Google Ads straight away, you will not see the changes until the script runs again.
🔄 If your sheet has any earlier column order (v9.0, v9.1.x, v9.2.x, v9.3.x or v9.4.x), the script MIGRATES IT AUTOMATICALLY to the new v9.5.0 order the first time it runs, without losing data. Column B (Source keyword) will be empty in rows migrated from v9.0/v9.1/v9.2/v9.3 (it is only filled in on the new ones the script adds).