So, I've been lurking for a long while and figured I should quit being a douchebag and start giving back.
First up - a quick and easy excel file that I use to generate huge feed lists for cycle sites.
All you need to do is fire up your favorite keyword research tool (I've been using the adwords external tool almost exclusively since they started providing volume estimates) and paste your keyword list into column A. Could be 10 keywords, could be 10,000 - however many you'd like.
Then just auto-fill column B all the way down, and you've got yourself google blog search links for each keyword, displaying 100 results in each feed (assuming there is 100 results, of course). Copy and paste that list into your auto-blog script of choice, and turn your filthy cycle site loose on the interwebs.
Now, I know this is simple as hell, but I've been asked how I generate a feed list via email three times in the last week and a half so I'm assuming this can help somebody. Kind of a head smacking tip if you've been looking for feeds by hand.
The excel file can be downloaded here: halo18.com/keywords-to-feed-list.xls
Hopefully it makes building a little quicker.
First up - a quick and easy excel file that I use to generate huge feed lists for cycle sites.
All you need to do is fire up your favorite keyword research tool (I've been using the adwords external tool almost exclusively since they started providing volume estimates) and paste your keyword list into column A. Could be 10 keywords, could be 10,000 - however many you'd like.
Then just auto-fill column B all the way down, and you've got yourself google blog search links for each keyword, displaying 100 results in each feed (assuming there is 100 results, of course). Copy and paste that list into your auto-blog script of choice, and turn your filthy cycle site loose on the interwebs.
Now, I know this is simple as hell, but I've been asked how I generate a feed list via email three times in the last week and a half so I'm assuming this can help somebody. Kind of a head smacking tip if you've been looking for feeds by hand.
The excel file can be downloaded here: halo18.com/keywords-to-feed-list.xls
Hopefully it makes building a little quicker.
