joined:June 7, 2011
I've decided to go down the long tail route to try and get some quick wins for the co. that I work for.
Here's what I've done so far.
We have loads of ad groups running in ad words at the moment so I've found all the broad searches for these ad groups and exported the whole lot into a spreadsheet.
Next I pinched a fancy algorithm off the net to count how many words there are in each cell.
I've then put auto filter on and sorted the new column that shows the number of words ascending.
As a sample I've omitted all results apart from 100 five word keywords that I've isolated and run through the google keyword tool to find out monthly local searches on broad match.
I've then added the keyword tool data to the spreadsheet so I've got the 100 five word keywords with search volume data side by side.
I can then pull out the top 50 keywords by search volume and competition etc.
Next I've run these keywords through Rank Checker to find out the nearest relevant page on my site that thee keywords might already rank for so I know which page is most relevant for targeting.
Now what I want to do is rank for these keywords. I'm talking about a sure fire way to get P 1-3 easily for these terms for my site.
I can't effect much change on the site as it's HUGE and making any changes would be a nightmare..
Here are my options.
1. Add all the keywords and URLs into scrapebox and blast that lot with a pre approved blog commenting list that I've already created.
2. Write an article for each keyword and submit to the top 10 article sites using broad match for linking anchor text.
3. Social bookmarking using some tool like Bookmarking demon (If I can get it to work) I can't imagine getting any benefit from this.
4. Outreach - wont work. No definable anchor text.
I've a few ideas, but I'd really like some input on this. What are the best link building tactics for white hat optimisation for 1000s of long tail keywords at a time. I mean if each keyword gets 1 vist per month, there's no point spending a day on it..