TLC SEO: The Linking Man's Blog

Link Prospecting with Pivot Tables

I have a lot of tools in my SEO toolbelt, but I only consider a few of them to be absolutely necessary – Link Prospector from Garrett French is one of them. LP takes all the grunt work out of advanced queries and scraping SERPs. But just like when you prospect by hand, you are going to find some garbage that you will need to remove from your data set.

 

By using Excel tables with filters and throwing the filtered data into a pivot tables  – you can create easily navigable documents filled with high value link opportunities.

 

Here’s a step by step process to cut down Link Prospector exports to just the meat and potatoes

Image via Flickr user Paul Keller

Image via Flickr user Paul Keller

[Read more…]

Scaling Internal Link Building with Screaming Frog & Majestic

I have a tool crush on Screaming Frog. I consider it one of the keys to scalability and I don’t know what I would do without it. Dan Sharp deserves a medal because his tool has saved SEOs countless hours of manual work. Screaming Frog can be used for a variety of things, but my new favorite use is for identifying  internal link building opportunities.

sf_majestic_equation

[Read more…]