SEO Competitor Research with Excel

I just found this very useful tool from the Search Engine People blog. This excel file makes competitive research easier to do. You can see who are your strongest competitors as well as know how strong they are.

The best thing about the tool is that you can choose which web server you would want to use, which makes it very handy when you are doing international SEO and geo-targeting.

Thanks to Yoav Ezer for sharing this awesome tool.

How to Perform SEO Competitor Research with Excel | Search Engine People | Toronto.

I Love CommentLuv

I just installed this awesome WordPress comment plugin, the commentluv. This plugin allows a blogger to see somebody’s latest blog post when leaving a comment. It’s two birds in one stone actually. The blogger will get to know the commenter more by clicking on the latest blog post link, and the commenter won’t have to link drop anymore since it’s automatic.

Google Adwords Broad Match Modifier

In my 4 years in PPC campaign management, I sparingly use broad matched keywords. This is because I find it very hard to control how the matches are being done. Somebody has to monitor the search queries that trigger the impression and click, and setup negatives when deemed necessary. A bit tedious task.

Then came the broad match modifier. The description in the article below looks very promising for this match type. This is a “soon to see” thing though since it’s pretty early to tell if this works out some magic.

See the article below from the official Google Adwords blog:

New keyword targeting feature rolling out globally – Inside AdWords.