Going through a list of prospects can be daunting task, whether it be for guest posts, infographic posting or any other form of link building. Especially if you have hundreds or even thousands of potential prospects. That’s why anything that can make your life easier is a must have. I covered breifly at the bottom of this post on using the BuzzBar from BuzzStream which is life saver when prospecting, but not everyone has BuzzStream perhaps they just don’t have the budget. So for you guys and girls here, is the alternative way to prospecting using the SeoTools for Excel plugin.
Download / Install
So you have Excel (I hope) if not go get it.Next you need to install the SeoTools for Excel plugin.
- Go here to download.
- Follow the intructions on the download page to install
Now your installed and ready to go you should have a new tab appear inside of Excel called “SeoTools”.
So you have your list of sites you potentially want links from, scraped or however you got them! Next its time to prospect them further and get rid of the bad eggs.
I have 6 columns in my Excel doc for this as follows;
URL | PageRank | CitationFlow | TrustFlow | IP | Title
Here is how to set up the Excel document (for you lazy people download download it here).
In the URL column enter your URLs you want to prospect.
For PageRank select the cell you want the data in and go to the SeoTool bar and click Offpage > GooglePageRank.
Then a window will appear you need to enter the cell of the URL to get the PageRank.
Click ok and the PageRank will populate in the cell for the URL.
If using Majestic SEOs Citation Flow and Trust Flow metrics you’ll need click on the Majestic SEO icon in the SeoTools bar and select the two fields “CitationFlow” and “TrustFlow”. It is not nessacery to use Majestic as its a paid service to use their API but I like to use it. Then copy and paste your URLs into the URLs field, select the cell where you want the data to go and click insert.
In the IP column enter the formula =ResolveIp(A2) and press enter.
For the title column you need to go back onto the SeoTools toolbar, click Onpage > HtmlTitle.
A window will popup you need to click on the URL cell you want to get the title for.
Next you want double click or drag the bottom right of the cells for PageRank, IP and Title so it populates the column.
Below is what you should end up with.
It’s Time To Filter!
Now you have a list of prospects start start filtering them to remove the bad eggs. First off lets filter the PageRank column to get rid of the websites with PageRank equal to or less than 1. *note* before this copy and paste the columns using formulas/SeoTools for Excel otherwise the forumula will recalculate and you will have to wait for it to get through the entire list again. Make sure you paste as text.
To filter the the data go to the Data tab in Excel, select the column headers and click filter. This will add a drop down button next to the column header text.
So lets get rid of all the low quality sites with PageRank of -1, 0 or 1. To do this click on the drop down button next to the header PageRank, uncheck select all and tick the -1, 0 and 1 check boxes. You will notice the data filtering before eyes. Next select all the rows left after the filter and delete them!
Now we have a filtered list of all the websites with some PageRank authority. If you included the CitationFlow and TrustFlow metrics then filter them also and get of any that are 20 or below.
That then leaves us with the IP address and Title columns. To make sure there are no network type links in the list go select the whole of the sheet and under Data to go Remove Duplicates. Click Unselect All then just check the IP box and click ok. This will remove any websites on the same IP address. This step is not 100% required it is up to you.
Next you can quickly review each title in the title column and remove any that don’t fit the niche your working with. Then load them all up into Flem a Firefox addon so you can easily go through a list of URL’s by going from one to the next for outreach.
SeoTools for Excel is pretty nifty hey?