📗 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.
📅 Cell A2. Date range for the analysis: 'LAST_7_DAYS', 'LAST_30_DAYS', 'LAST_90_DAYS', 'ALL_TIME', 'SMART' (combines ALL_TIME + LAST_30_DAYS with weights). It only applies to Mode 1. Modes 2 and 3 ALWAYS use LAST_30_DAYS.
🔬 Cell A4. Test mode: 'ON' = only writes to the Test sheet without adding real keywords / 'OFF' = normal operation.
🎛️ Cell A6 🆕 v9.0. OPERATING MODE: • 'Mode 1' (default) → classic logic: score + semantics + whitelist • 'Mode 2' → term CTR > average CTR of the ad group + no negative semantic words • 'Mode 3' → terms that generate 75% of the impressions of each keyword + no negative semantic words • 'Full Mode' → runs the 3 modes in order (1→2→3) and deduplicates (the most restrictive mode wins) If it is empty or the value is not recognised, Mode 1 is used.
🏷️ Cell A9. Label applied to the keywords added. It lets you identify and filter them. IMPORTANT: this label is used in the monthly report to compare the performance of the script keywords against the rest of the account.
⏸️ Cell A11. 'Yes' to add keywords paused / 'No' to add them active.
🎯 Cell A13. Match type. Options: 'Exact', 'Phrase', 'Broad', 'Exact,Phrase', 'Exact,Broad', 'Exact,Phrase,Broad'. It applies when you tick ☐ Add.
✅ Cell A18. NKNS whitelist filter: 'Yes' = only adds keywords whose words are in the whitelist / 'No' = no filter. (Mode 1 only).
📋 Cell A20. Name of the tab inside the NKNS spreadsheet that holds the whitelist (when A18 = 'Yes').
🧠 Cell A22. Semantic relevance: 'Yes' = applies a bonus/penalty based on the words in columns D and E from row 23. INDEPENDENT of the NKNS. (Mode 1 only; Modes 2 and 3 use the negative words in column E even if A22 is 'No').
📊 Cells D3, D4. Scoring weights (Mode 1): D3 = CTR weight, D4 = conversion rate weight. They must add up to 100 (or 1.0).
📊 Cells D5, D6. Score adjustments by CPC (Mode 1): D5 = bonus if the term CPC < average CPC of the ad group, D6 = penalty if the CPC is higher.
📊 Cell D8. Minimum score (threshold) for a term to be accepted in Mode 1.
📊 Cells D11, D12. Minimum filters (Mode 1): D11 = minimum CTR, D12 = minimum conversion rate. They can be automatic (set E11/E12 to 'Automatic' to calculate them from the range in F11/F12).
📊 Cells D13, E13 🆕 v9.0. D13 = minimum number of conversions / E13 = 'ON' to switch the filter on or 'OFF' to switch it off. IT APPLIES to all 3 modes.
📊 Cells D14, E14 🆕 v9.0. D14 = minimum number of impressions / E14 = 'ON'/'OFF' to switch it on or off. IT APPLIES to all 3 modes.
➕ Cells D18, D19, D20. Semantic relevance bonus (Mode 1): D18 if 1 positive word matches, D19 if 2 words, D20 if 3 or more.
➖ Cells E18, E19, E20. Penalty for negative words (Mode 1): E18 if 1 matches, E19 if 2, E20 if 3 or more.
🟢 Column D, row 23+. List of POSITIVE words that give a bonus to the score (one per cell, e.g. 'opportunity', 'law', 'seizure', 'in debt'). They are processed with Spanish stemming. (Mode 1 only).
🔴 Column E, row 23+. List of NEGATIVE words. In Mode 1 they penalise the score; in Modes 2 and 3 they drop the term outright if any of them matches. Also with stemming.
⚖️ Cells G3-G8 (SMART mode). When A2 = 'SMART', these are the weights used to combine ALL_TIME and LAST_30_DAYS: • G3 + G4 = CTR weights • G5 + G6 = % Conversion weights • G7 + G8 = CPC weights Each pair must add up to 100.