Many of you will have caught this post from Jayson over at SEO Teky where he introduced us to his pretty sweet guest post finding tool.
The “Guest Post Query Generator” fetched keyword derivatives from UberSuggest and then generated the Google search query for each of these in real time. I was really impressed with how brilliantly simple this tool was, you simply put in your search term, wait a couple of seconds and you’re ready to rock.
Not only was I impressed but it made me think, could you use this spreadsheet to generate other queries for link building?
Guest posting is one of the hot tactics on the link building scene, possibly too hot as discussed by Chairman Cutts in the video below (Kudos to AJ Kohn for asking the question!) but it’s not the only tactic in the SEO’s toolbox.
**UPDATE 28 April 2013 – Unfortunately Ubersuggest have needed to add a captcha to the tool which means this spreadsheet no longer works 🙁 I’m currently looking at some alternatives and hope to be up and running again soon**
**UPDATE 11 December 2012 – Chris Dyson dropped a really great tip over on the boom online blog where he talked about link building with blog round ups. Not a tactic that is widely talked about in my experience, so I promptly stole the idea and added it to the query generator!
I’ve been a bit of a spreadsheet geek in a previous life, although mainly Excel rather than Google, but undeterred I set about hacking Jayson’s offering to within an inch of it’s column widths. What I came up with, ripping off pretty much all of Jayson’s original coding it has to be said, was a tool which rather than being specifically to find guest posting opportunities allows you to select one of five popular tactics to hunt down. As follows:
- Guest Posting (Default)
- Authority Domains
You can get the spreadsheet here
I won’t go over the basics of how the spreadsheet works, it’s pretty simple to use but if you are having a hard time jump back over to Jayson’s original post which goes through everything you need to know. There is only one simple change which you need to know about in red below:
In cell B3 you will find a drop down list which allows the selection of the specific opportunity you are looking for. The quality of results will vary dependant on the keyword and opportunity selected in my experience. For example selecting “Giveaways” gives best results when matched with a retail/product query where as the “comments” option works really well with informational keywords.
One thing which Jayson didn’t really cover off in his blog post was how to quickly harvest the results of these queries in order to start prioritising and stripping out the low quality stuff. As he did all the hard work explaining about the tool works I thought this was something I could cover in a bit more detail.
First of all, once you have entered your search term in B2 and selected the desired tactic from the drop down list in B3 you will be presented with a long list of URL’s in column H. You can open these links individually if you wish but for me it was much quicker to paste the 10 best looking queries into a tool such as URLOpener.com to open the queries in multiple windows. Just drop the URL’s in the box provided and hit “Open All”
The reason I suggest selecting the 10 best looking queries is 2 fold.
Firstly, as good as Ubber Suggest is at generating potential keywords it’s inevitable that many of them won’t be suitable for either the type of tactic you have selected to run or they won’t be compatible with the niche you are looking at.
Secondly, I tried to open around 50 of the links at one time and my laptop just looked at me with a “You’re joking me, right?” look and slowed to the pace of a lame tortoise.
Scraper for Chrome
Once you have 10 open windows displaying the results generated by the tool’s queries you can set about scraping those down for further analysis using your favourite scraper, I personally like “Scraper for Chrome” to do this job as it will drop the URL’s into another Google Document for you to work on in a second.
If you’re unsure as to where you should dump this list may I suggest to you the SEOMoz Google docs tool would be a good place to start? I have to admit to only very quickly trying this tool some time ago now but it will append your list of URL’s with all the usual SEOMoz goodness in order for you to quickly sort the wheat from the chaff.
So there it is, hopefully I have made a good enhancement to what was already a great little tool and hopefully the change, along with the other tips will save you guys even more time. Again massive credit goes to Jayson for putting the thing together in the first place, and for being to cool about me hacking it. This tool has already had a long line of credits to (Dan Shure, Dean Cruddace, EvolvingSEO Uberfest of Ubbersuggest post, Tom Anthony and Tom Critchlow) to which I’d also like to add these guys, Cleo Kirkland, my mum, my dog and of course my high school Excel teacher..
I’d love to hear if anybody has further comments on how the tool could grow even further going forward, or indeed if it’s helped you in your efforts so far. Just let me know in the comments, they are much appreciated. If your a member you can also vote this up on Inbound.org!
Post by Gaz Copeland