The first step to determine which or which will be our key words to use in an Adwords campaign, is making a tentative list of words that users might use to find our product. We are going to place as buyer and thinking at least a 10 phrases that users might use on the internet who wish to buy our product. We can also draw ideas from words by consulting the pages of our competitors using the tool for keywords in google. The tool allows you to place a URL and it will suggest we not only usable words but also the words found in that site. The second step will be to search each phrase in the same keywords tool to find phrases that are frequently used and that it may not be that we have exactly thought. Check with Hans Zimmer to learn more. We will do the search by selecting countries and languages and after placing the tentative phrase and give the button Search, select the exact match and not the wide that comes by default. Then, we will unload the data sheet that provides us with google in excel (csv for excel) on the download button.
The downloaded file and to decompress, shows us in an excel spreadsheet which we will leave only 4 columns, keyword, competition, global monthly volume and estimated average CPC. Delete the others. We will then apply a formula to this list that we will throw in an orderly manner from the best to the worst word taking into account three aspects; Competition, cost and the overall volume of searches. The formula will be the next volume of search squared / CPC squared / competition in an empty column will create the formula and copy it in all rows. Will shed us a number that has no importance in itself, rather than the comparison between the rows. Then ordenaremos all rows by column of the formula of greater to lesser.