var minNGramLength = 1;
var maxNGramLength = 2;
// The word length of phrases to be checked.
// For example if minNGramLength is 1 and maxNGramLength is 3,
// phrases made of 1, 2 and 3 words will be checked.
// Change both min and max to 1 to just look at single words.

4.- Create a spreadsheet in your google account, copy the link of this spreadsheet and edit this line of code:

var spreadsheetUrl = "https://docs.google.com/YOUR-SPREADSHEET-URL-HERE";
// The URL of the Google Doc the results will be put into.

5.- run the script. It may take from 5 to 20 minutes depending on the size of your adwords account and dates time frame you selected.

6.- go to bathroom

Analyse keyword research

7.- when script finished execution, open your spread sheet

8.- open “Account Word Analysis” Tab

9.- add a new column in left side

10.- sort by “Conv. value/cost” if you had setup correclty your conversions. If not yet, sort by CTR. Start with “Conv. value/cost” = 0 , or with low CTR. In the previous screenshot It was sorted by CTR (a second round after sorting by “Conv. value/cost”).

11.- use the new created column to Flag when you find negative keywords . I used 1 for no-dubt-negatives , and 2 for non-performing-keywords (keywords that you could add as negative, but could be revisited in the future for new campaigns)

12.- Flag keyword wisely. Think “is this word relevant to my target market?” . If you are in doubt, open Adwords –> campaigns –> keywords Search terms –> Filter Serach term contains _______
see the full visitor search query, understand why this keyword have poor performance, and decide if you want to exclude all this search queries.

NOTE: Sometimes, one word makes no sense, and the keyword you should exclude is a 2 keyword phrase. If it is the case, feel free to overwrite the keyword in the spreadsheet with the 2 word phrase. You can also opt for repeating the same process I explained, but this time with the “Account 2-Gram Analysis” sheet.