A cool Trick I use to Get Hundreds of Good Keywords & Domains for PPC/PPV

I thought this trick may be of some value to some people doing PPV & PPC keyword research....

This might not be new for some of you but here it is:

On my last campaign I wanted to target "CPA Marketers". So in searching for related keywords for both PPV & PPC I searched google for "List of CPA Networks" cause I know CPA marketers go to these networks...duh....

Finding lists of anything is extremely simple and most of them easily paste into a spreadsheet, also the Google keyword tool works too for long lists of KWs...

Now with the long list of just the networks I was able to paste into a spreadsheet like so:


So I added those keywords to my campaigns but I also turned them all into .com & .org and .net and added all those to my campaign for a nice long list of domains too which actually will result in much more traffic.

Here's how I turn them into domains (ill do .com):
I add: =A2 & ".com" into the box next to the keyword and hit enter like this:



Once I hit enter the keyword in the second box is rocketprofit.com Then I simply drag the formulas all the way down the list and makes them all .com. Then I do the same for .org and .net



This trick saves a ton of time and results in more targeted traffic... instead of trying to get long list of domains to target the old fashioned way (scraper or manually) Also this works for long lists of targeted keywords like from the Google Keyword tool.

This also worked really well on a sporting campaign I did recently on PPV. I looked up a list of all sports and found a list of over 50 sports and then got a list of sports channels, and sports teams, then turned them all into .com, .net and .org - I also do it with lists of keywords the Google tool for niches...