📗 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.
How it is calculated. base_score = (CTR × CTR_weight) + (%Conv × Conv_weight) + CPC_adjustment
CPC_adjustment = +D5 if the term CPC < average CPC of the ad group CPC_adjustment = -D6 if the term CPC > average CPC of the ad group
final_score = base_score + semantic_bonus - negative_penalty
If final_score ≥ D8 → the term is accepted
Order in which it is applied. 1. Quality filters: impressions, min CTR, min %Conv, min conversions 2. Base score calculation 3. Positive semantic bonus (added) 4. Penalty for negative words (subtracted) 5. Comparison against the D8 threshold 6. Whitelist filter (only if A18 = 'Yes')
Semantic relevance system
Switching it on. A22 = 'Yes' switches on semantic relevance using the local words in columns D and E (from row 23).
If A18 = 'Yes' as well, the words in the NKNS whitelist are also added to the positive semantic pool, widening the matches automatically.
How it works. For every search term it counts how many words match the positive list (col D) and how many match the negative one (col E).
The bonus/penalty is applied in steps according to the number of matches: • 1 match → D18 / E18 • 2 matches → D19 / E19 • 3 or more → D20 / E20
Spanish stemming. The system recognises variants of the same word: plurals (curso/cursos), derived forms (deuda/endeudado/endeudamiento), common suffixes (-ción, -miento, -ado, -oso, etc.).
Matches by stem are marked with an asterisk (*) in the Test sheet.