Video Ranking Money Making Method – Keyword Research pt. 1

In the first part of this article series, we introduced you to our money making method and explains how to find an affiliate network which will work well with this method. In this article, we are going to explain how to do a thorough keyword research so that you will find the best keywords to go after.

2)     Keyword research

Now it is time for our keyword research. You can use our Traffic Travis articles as a reference though this keyword research will not be as in depth. What you want to do first is obtained the list of products. A lot of the time, you’ll be able to get a data feed from the network. If you can, import the feed into Excel (Data>From Web>WebPage) and you should be left with a column full of products. If they do not have feed, copy and paste (paste values) the entire list of products into Excel and use the Data>Text to Columns and Filter functions to manipulate the paste job into a list of products.

Look through your list and add in any generic and more broad versions of the product. For example, if you have foot-fungus-be-gone, you can add terms like fungus cream and foot fungus.

Once you have the list, paste all of the products into the harvester in scrapebox. Then, open up a notepad and paste the following:

%kw%

%kw% scam

%kw% review

%kw% reviews

Review %kw%

Buy %kw%

%kw% vs

%kw% discount

%kw% sale

Compare %kw%

%kw% online

Save the .txt and use the merge “M” function in Scrapebox to generate the list of keywords.

These are buyer keywords. Long tail versions of our product name that are mainly searched by people that are looking to buy the product or a similar counterpart. When you are done, you should be left with 11*(# of products)= amount of keywords.

Save this large list of keywords.

If you don’t have scrapebox, do not worry. Below, I will show you how to generate the same list with Excel, just with a bit more work.

Open Excel and paste your first 5 keywords in column 1.

Right click on sheet 1 and click view code

Paste the code below into the window and click run

Sub Macro1()

‘ Macro1 Macro

Range(“A1”).Select

Selection.Copy

Range(“F1”).Select

ActiveSheet.Paste

Range(“D5”).Select

Application.CutCopyMode = False

ActiveCell.FormulaR1C1 = “review”

Range(“D6”).Select

ActiveCell.FormulaR1C1 = “buy”

Range(“D10”).Select

ActiveCell.FormulaR1C1 = “compare”

Range(“H2”).Select

ActiveCell.FormulaR1C1 = “scam”

Range(“H3”).Select

ActiveCell.FormulaR1C1 = “review”

Range(“H4”).Select

ActiveCell.FormulaR1C1 = “reviews”

Range(“H7”).Select

ActiveCell.FormulaR1C1 = “vs”

Range(“H8”).Select

ActiveCell.FormulaR1C1 = “discount”

Range(“H9”).Select

ActiveCell.FormulaR1C1 = “sale”

Range(“H11”).Select

ActiveCell.FormulaR1C1 = “online”

Range(“G1”).Select

ActiveCell.FormulaR1C1 = ” “

Range(“G1”).Select

Selection.Copy

Range(“G2:G11”).Select

ActiveSheet.Paste

Range(“E1:E11”).Select

ActiveSheet.Paste

Range(“F1”).Select

Application.CutCopyMode = False

Selection.Copy

Range(“F2:F11”).Select

ActiveSheet.Paste

Range(“I1”).Select

Application.CutCopyMode = False

ActiveCell.FormulaR1C1 = “=RC[-5]&RC[-4]&RC[-3]&RC[-2]&RC[-1]”

Range(“I1”).Select

Selection.Copy

Range(“I2:I11”).Select

ActiveSheet.Paste

Columns(“I:I”).Select

Application.CutCopyMode = False

Selection.Copy

Range(“L1”).Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=False, Transpose:=False

Range(“A1”).Select

Application.CutCopyMode = False

Selection.Delete Shift:=xlUp

Range(“A1”).Select

Selection.Copy

Range(“F1:F11”).Select

ActiveSheet.Paste

Range(“I1:I11”).Select

Application.CutCopyMode = False

Selection.Copy

Application.Width = 868.5

Application.Height = 652.5

Range(“L12”).Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=False, Transpose:=False

Range(“A1”).Select

Application.CutCopyMode = False

Selection.Delete Shift:=xlUp

Range(“A1”).Select

Selection.Copy

Range(“F1:F11”).Select

ActiveSheet.Paste

Range(“I1:I11”).Select

Application.CutCopyMode = False

Selection.Copy

Range(“L23”).Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=False, Transpose:=False

Range(“A1”).Select

Application.CutCopyMode = False

Selection.Delete Shift:=xlUp

Selection.Copy

Range(“F1:F11”).Select

ActiveSheet.Paste

Range(“I1:I11”).Select

Application.CutCopyMode = False

Selection.Copy

ActiveWindow.SmallScroll Down:=8

Range(“L34”).Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=False, Transpose:=False

ActiveWindow.SmallScroll Down:=-12

Range(“A1”).Select

Application.CutCopyMode = False

Selection.Delete Shift:=xlUp

Range(“A1”).Select

Selection.Copy

Range(“F1:F11”).Select

ActiveSheet.Paste

Range(“I1:I11”).Select

Application.CutCopyMode = False

Selection.Copy

ActiveWindow.SmallScroll Down:=20

Range(“L45”).Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=False, Transpose:=False

ActiveWindow.SmallScroll Down:=-28

Columns(“K:K”).Select

End Sub

Click Run (the play button) in the toolbar and exit the code window. You will see the list of keywords in column L. Copy that list into a new notepad file and add your next 5 keywords in column A. Repeat he process until you have the entire keyword list complete.

That is enough for day 2. In part 3, we are going to use Google’s keyword tool to sort through these keywords and filter out the worthless ones.