I am a fan of Blogger Linkup and have used the service both to find sites to place guest posts on and to accept posts on my own sites. For those unfamiliar, Blogger Linkup is a service where you can request or offer guest posts to other bloggers in your industry/niche and no one is allowed to charge for accepting or hosting the posts.
I know a lot of people are hailing the end of guest posting but I think it still has merit. Big content pieces take time to develop and going after low hanging fruit and steady links is a smart play in my opinion. That’s especially true if it’s just one of multiple SEO strategies you are implementing.
Although I love the service I have been getting frustrated with how much time it takes me to look through it to find quality opportunities. I’m doing SEO for five different sites between clients and my own projects and every category offered except travel is relevant to me. That means I’m looking through the descriptions of 50 to 100 offers three times a week.
Often i’ll find a description that seems relevant and click through to the site only to find that it has no page rank and a domain authority under 15. Or the site will be a fit but i’ll have already submitted a post to them a few months back and have forgotten (casualty of working on multiple projects and looking at hundreds of sites every week).
- Cut down on the amount of time it takes me to find quality opportunities on Blogger Linkup.
- Weed out any sites that I’ve already submitted to.
Who This is Post is For
I want to say up front that this post will only be relevant for those who use Blogger Linkup frequently and have sites in more than one category. If you have one site that fits into a specific category like finance or travel then you’re better off just scanning that category.
Step 1: Go to the current issue of Blogger Linkup on the actual site (not the e-mail version). Go to the first link at the top of the page that says “view the current issue”. Using the scrape similar chrome plugin highlight the URL, right click and choose scrape similar then open the results in Google Docs.
NOTE: Other areas on the page have been giving me issues with the scraper but this first link has consistently worked.
Step 2: Open up your data in Google Docs. The top rows of links in your data will be internal links from Blogger Linkup. The last row of the internal links that we want to eliminate will always be “Guest Posts Needed” so highlight and delete all rows down to there.
Step 3: Go back to the current issue of Blogger Linkup and find the 1st available guest posts URL (easy to do using Control + F). The available guest posts are people offering already written guest posts that you can claim. Since our focus is on building links we need to remove all of those URL’s from our list.
Once you have the URL go back to your Google doc and delete everything from that URL down to the bottom of doc. This will leave us with just data on the sites requesting guest posts.
Step 4: At this point I highlight the first column in my Google doc titled links and move thedata over to excel.
Step 5: You may have noticed that in addition to the site’s URL’s, we have the contact e-mail addresses in our data as well. To get rid of the e-mails’s we’ll set a filter on our column.
Filter –> Text Filters –> Contains –> @
By filtering for all the rows that have @ we’ll get all the e-mail addresses. Delete them all and the remove the filter
Step 6: Now that we have just site URL’s and need to clean them up. Use find and replace to remove the http:// and then the www. of the URL’s. Then use find and replace again and in find what use /* and leave replace blank. This will remove everything at the end of the URL leaving us with just the root domain.
Step 7: Go to the data tab in excel and remove duplicates. This will leave us with a clean list of URL’s. For the example I’m using, I’m left with 70 sites.
Step 8: Use SEO Tools for excel to pull in the page rank of all the sites. This is by far the fastest way to complete this step
Alternative Option: Use a similar tool like NetPeak checker or any tool of your choice to get other kinds of metrics. I actually prefer using NetPeak checker to get SEOMoz data so I can make my decision based off of PA & DA instead of page rank.
Step 9: I like to eliminate anything below PR 3 but use whatever metric you like.
We want to keep the sites in roughly the same order for when we go back to Blogger Linkup so instead of sorting them by page rank we’ll set a filter.
Filter –> Number Filters –> Less Than –> The page rank you want to remove below (I use 3)
Highlight and delete all the filtered low page rank URL’s. Make sure to actually delete the rows and not just the data.
For the edition of Blogger Linkup I am using as an example, that takes me from 70 URL’s down to 12.
I’ll reiterate once more that I actually prefer to use SEOMoz metrics so I can make a cut off closer to DA 25 especially depending on how many sites that will cut out.
Step 10: If you have a list of sites you have gotten links from on blogger linkup in the past then you should drop them in a doc with this round of URL’s and use conditional formatting to highlight any duplicates.
I use Buzzstream and created a tag for Blogger LInkup that I add every time I get a link. All I have to do is export all links with those tag and keep them in a doc. Every few weeks i’ll export the links again to update the doc. I also plan on adding a black list of either sites that rejected my pitches or who I have decided are not a good fit.
Step 11: Now with my clean list I go back and look at the available options of the remaining sites and make my guest post pitches when I think I can offer value.
Summary: I’ve been using this approach for the last two weeks and when you combine my DA requirements and sites I’ve gotten links from in the past then it usually takes me down from 75 sites to between 5 and 10 to have to look through.
I know this is a lot of steps but really the process is fast especially after you’ve done it a few times. Sometimes I’ll do two blogger linkups at a time to really condense the process and how long it takes me to review.