What an awesome album cover eh? O.k so this is one of those things that can be used in a million ways so I’m passing on just one way to skin an SEO, guest blogging cat. Today we are looking into how we can quickly scrape Google to find guest blogging link opportunities. If you are looking on tips for how to write content for guest posting or how to get in contact with the websites once you have a list you may be disappointed but anywho…
Tool(s) required:
- Scraper (Google Chrome) – Scraper is a Google Chrome extension for getting data out of web pages and into spreadsheets.
- SEOmoz toolbar – This SEO Toolbar gives you quick access to many on-page SEO factors but it’s the PA (page authority) and DA (domain authority) data that we will be using for this exersize.
Lets get down to it, how fast could I get a list of related blogs that I could guest post on?
- Remove Google Instant and changing search preferences to 100 – Click the Google Options button (top right in Google homepage, chrome). Click on Search Settings, display 100 results per page and choose do not use Google instant, save.
- Search in Google for – keyword inurl:”write for us” for example if you were looking for SEO blogs to write on then you would go for SEO inurl:”write for us” (Once you have exhausted the list under “write for us” then review other areas like “contribute to”, “guest blogger”, “submit content”, “submit post”, “blog for us”. I’m sure that you guys can think of one or two others…)
- Highlight the page title for the number one result, right click and click on “scrape similar”
- Export to Google docs
- Copy and paste the results into Excel
Hey presto you have 100 websites that are eager, desperate, keen and zealous for you to write some excellent content for their website.
So what was the SEOmoz toolbar for?! Well I’m glad you asked. Once you have got your excel sheet add a column marked DA (domain authority), go manually through the 100 google results and add the DA to each website. Put the list in order of DA (largest first ;-)) and there you have it a list of 100 relevant SEO blogs who are looking for writers in order of domain authority.
Not bad for 5 minutes work… 🙂
Interested to see the list? Here you go (granted the quality of domains may not be the finest but lets not forget it’s the SEO industry!)
| URL | DA |
| http://www.zimbio.com/SEO/articles/ykmv7kniML5/Want+to+Write+For+Us | 92 |
| http://allboutwebsites.blogspot.com/p/write-for-us.html | 76 |
| http://www.scoop.it/t/seo-with-salim/p/325346756/write-for-us | 69 |
| http://www.blogengage.com/blogger/write-for-us-and-guest-blog-at-blog-engage/ | 68 |
| http://www.freelancewritinggigs.com/2010/01/75-write-for-us-pages/ | 67 |
| http://www.designyourway.net/blog/write-for-us/ | 66 |
| http://www.webdesignbooth.com/write-for-us/ | 64 |
| http://www.smartbloggerz.com/write-for-us/ | 64 |
| http://skyje.com/write-for-us/ | 60 |
| http://www.richerornot.com/write-for-us/ | 59 |
| http://www.seoservicesgroup.com/blog/write-for-us/ | 58 |
| http://offshoreally.com/support-services-outsourcing/write-for-us | 54 |
| http://www.netchunks.com/write-for-us/ | 51 |
| http://www.allblogtools.com/write-for-us/ | 47 |
| http://www.screamingtips.com/write-for-us | 47 |
| http://www.techmaish.com/write-for-us/ | 46 |
| http://www.babapandey.com/write-for-us/ | 42 |
| http://www.todaytricks.com/write-for-us/ | 41 |
| http://www.evolutionarydesigns.net/blog/write-for-us/ | 41 |
| http://www.techntricksonline.com/write-for-us/ | 40 |
| http://www.techncom.net/p/write-for-us.html | 38 |
| http://eblogtip.com/write-for-us | 38 |
| http://www.fmsseo.com/write-for-us/ | 37 |
| http://inforids.com/write-for-us/ | 37 |
| http://techchunks.com/write-for-us/ | 36 |
| http://www.webtricksblog.com/write-for-us/ | 36 |
| http://www.magnet4marketing.net/2010/07/20/write-for-us-at-magnet4marketing/ | 36 |
| http://webincomejournal.com/guest-post-write-for-us | 36 |
| http://sadiakomal.com/write-for-us/ | 36 |
| http://bloggingpark.com/write-for-us/ | 36 |
| http://www.smartfatblogger.in/p/write-for-us.html | 36 |
| http://techozens.com/write-for-us | 35 |
| http://www.xmakemoneyonline.com/write-for-us/ | 34 |
| http://www.geeks4share.com/write-for-us/ | 34 |
| http://techgopal.com/tag/write-for-us-seo/ | 34 |
| http://www.newbloggingtipz.com/p/write-for-us.html | 33 |
| http://adsenseurdu.com/write-for-us/ | 33 |
| http://techsharing.net/write-for-us/ | 32 |
| http://www.seobloggingtips.com/write-for-us/ | 32 |
| http://tricks.oshogarg.com/p/write-for-us.html | 32 |
| http://www.socialmedianews.com.au/write-for-us/ | 32 |
| http://www.geekshub.com/write-for-us-2/ | 32 |
| http://www.techifire.com/write-for-us/ | 32 |
| http://thetechaddicts.com/write-for-us/ | 32 |
| http://www.hacktik.com/write-for-us/ | 31 |
| http://www.k-director.com/blog/write-for-us/ | 31 |
| http://www.awebdesignblog.com/write-for-us/ | 31 |
| http://camerafund.com/write-for-us | 30 |
| http://www.smashblogtips.com/write-for-us/ | 30 |
| http://www.bayofblog.com/write-for-us | 30 |
| http://www.xinz.org/write-for-us-xinz/ | 30 |
| http://www.hpminiblog.com/write-for-us/ | 30 |
| http://blog.adfed.org/write-for-us/ | 30 |
| http://www.iblognet.com/p/write-for-us.html | 30 |
| http://olalinks.com/tag/seo-write-for-us/ | 30 |
| http://www.ppeso.com/write-for-us/ | 29 |
| http://www.pcperts.com/write-for-us/ | 29 |
| http://www.developerweb.co.uk/write-for-us/ | 28 |
| http://www.geekspalace.com/write-for-us/ | 28 |
| http://hackfile.org/2011/08/want-to-write-for-us/ | 28 |
| http://www.seocenter.com/write-for-us | 27 |
| http://tips4tech.net/write-for-us-guest-blog/ | 27 |
| http://elderkind.com/write-for-us-guest-blogger-wanted/ | 27 |
| http://www.homeforgeeks.com/write-for-us/ | 27 |
| http://techinfoblog.net/write-for-us/ | 26 |
| http://www.ppcforhire.com/blog/write-for-us/ | 26 |
| http://www.tipsandtricksblogger.com/p/write-for-us.html | 25 |
| http://www.explorefeed.com/write-for-us | 25 |
| http://www.techenga.com/write-for-us/ | 25 |
| http://www.moretricks.com/write-for-us | 24 |
| http://tech-sharing.com/write-for-us/ | 24 |
| http://www.affiliatetuts.com/write-for-us/ | 24 |
| http://www.seomistry.com/write-for-us/ | 23 |
| http://www.searchenginemarketing.co.uk/write-for-us/ | 23 |
| http://seinternetmarketing.com/2009/write-for-us/ | 23 |
| http://www.momoneymarketingmentor.com/write-for-us/write-for-us/ | 22 |
| http://moneyfromnet.com/write-for-us | 22 |
| http://www.advertising-nj.com/category/write-for-us/ | 22 |
| http://www.theseoinfo.com/write-for-us/ | 21 |
| http://www.wildwestseo.com/write-for-us/ | 21 |
| http://onlineincometeacher.com/write-for-us/ | 21 |
| http://seocasestudy.org/write-for-us/ | 20 |
| http://www.rishitechnology.com/write-for-us/ | 20 |
| http://boblogger.net/write-for-us | 18 |
| http://webdesignseosydney.com/write-for-us | 18 |
| http://www.technispace.com/write-for-us | 17 |
| http://schooldestroyer.com/write-for-us/ | 16 |
| http://www.techsido.com/write-for-us/ | 15 |
| http://www.maverickwebmaster.com/write-for-us/ | 14 |
| http://madhavtripathi.com/write-for-us/ | 13 |
| http://compulsivemarketer.com/write-for-us/ | 11 |
| http://trafficblogsite.info/backlinks-and-seo-news/write-for-us/ | 11 |
| http://www.sediscussion.com/write-for-us/ | 10 |
| http://www.seotution.com/write-for-us/ | 7 |
| http://techflyover.com/write-for-us | 6 |
| http://www.bloggertoolz.net/2011/08/write-for-us.html | 6 |
| http://backlinksrocket.com/Blog/seo-write-for-us | 1 |
| http://www.bloggablestuff.com/write-for-us/ | 1 |
| http://backlinks.tipsaboutseo.com/buy-backlinks-write-for-us/ | 1 |
| http://wpstarters.com/category/contact-us/write-for-us/ | 1 |
Hey, cool tip! Thanks for sharing.
I had a little issue though and didn’t quite get the same results as you:
1. After clicking “scrap similar” on the first listing, only one of search results came up in the extension window for me to export to Google Docs.
I did the same steps with the 2nd and 3rd listings in the search results, but because they export to another Google Doc (not the same one the first listing went onto), I had to manually cut and paste a whole lot of URLs and page titles.
So while this is a great way to quickly find places to guest blog, it’s not quite as automated as I had hoped.
Did I miss something?
Thanks again for sharing 🙂
Hey Alice, no problem!
I’ve added a screenshot of how you should highlight the first result. –> http://i41.tinypic.com/sdiw5d.png
Is this how you did it? If so I’m not sure why it isn’t working!