Cool PPC Keyword Generator Excel Macro + Screencast

For any interested pay per click advertisers, ppc affiliates or mildly interested Internet marketing aficionados – here’s a neat little macro for excel which generates a list of keyword permutations based on 2 lists of data (columns A and B).

Check out the screencast I made to see how you might benefit from it and how to set it up.

Here is the code itself -

Sub MyConcatenate()
Dim rng As Range
Dim LastRow As Long
Dim I As Long

LastRow = Range(“A” & Rows.Count).End(xlUp).Row

Set rng = Range(“B1″)

While rng.Value “”

Range(“C1″).Offset(I).Resize(LastRow) = “=A1 & CHAR(32) &” & rng.Address

Set rng = rng.Offset(1)
I = I + LastRow

Wend

End Sub

There’s a wide variety of uses for this, especially when generating long geotargeted lists of keywords, or when you have a long list of “keyword + {attribute}.” They’ll be grouped somewhat logically the way the macro is written so you can simply just generate some dynamic URLs using the keywords immediately after generating them if you’re sending traffic to a dynamic template.

It doesn’t name the adgroups for you but if you’re brazen enough and the keywords are similar enough you have 2,000 keywords per adgroup and {KeyWord:Is Your Friend}.

Cheers!

Jeff