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

Note: If the keyword is in the template of your site (i.e. on every page) this process will not work, this is optimal for long tail or secondary keywords.

Step 1) Identify the Keywords you want to improve rankings for

Keywords   Conductor
Conductor FTW!

Conductor Searchlight is awesome for this, you can find the KWs with the most search volume that are just shy of ranking well.

Step 2) Put Keywords into Screaming Frog Custom Filters

SEER_SF_Terms_for_Internal_Link_Building

Step 3) Run Screaming Frog & Export your Custom Reports

Screaming_Frog_Visual_of_Export

Step 4) Do a Majestic Bulk Upload of all your URLs to get Metrics

Majetic_Bulk_Upload

You need to run bulk look ups for each export, then once you export it from Majestic, delete all the data you don’t need and add a column with the internal link phrase in each export and combine all the data:

SEER_Data_for_Pivot_Table

Step 5) Clean Up Your Data

Creepy Garbage Man
Image courtesy of Flickr user State Farm

Clean up your data, if a page has zero links pointing towards it, maybe it isn’t worth your time to add that internal link. You need to use your best judgement, but if the page is lacking on link juice, I generally remove it from my data set.

Step 6) Get Your Pivot On

Throw all this data into a pivot table and select just your most powerful pages for internal links. Going off of Trust Flow, Citation Flow and AC Rank metrics allow you to prioritize your internal link building. For those of you wondering how to set up and use pivot tables, you wont find that information here… go to Annielytics for that stuff, she makes data sexy. But if you want to see how I set it up, here is a Pivot Table of SEER Interactive’s internal link opportunities optimizing for the keywords: link building, audit, international and pay per click.

 

Author: jhtscherck

John-Henry Scherck is the owner of Growth Plays, a B2B content strategy and SEO consultancy based in Los Angeles. He works with founders, marketers, and investors to plan, build and refine growth marketing initiatives using a common sense approach.

14 thoughts on “Scaling Internal Link Building with Screaming Frog & Majestic”

    1. @Soy un Gnomo Nope, no facebook fan page – however, I am pretty active on Twitter. Please feel free to follow me there @JHTScherck – thanks for the interest!

  1. Xenu can also come in handy in such case. I usually look for lonely pages with no or less internal links. It is always good to give them new life through internal linking.

    1. @geniusgeeks As far as I know, Xenu doesn’t crawl the on page text, so although you can find pages with only a few internal links – it’s not great for finding specific opportunities that already exist on your site. However, if Xenu can find individual words on a page – please let me know!

  2. for the part about pivot+majestic, you could save time here using Excel for SEO and get the authority data you are looking for.

  3. Great post here JHTScherck — any recs on how to manipulate screaming frog for sites that have > 50,000 pages. I’m looking for ways to speed this process up. It might just be the nature of the beast, in which case I’ll make due!

  4. John-Henry,Excellent step by step guide. Indeed, Screaming Frog is really a very helpful tool. In fact aside from determining link building opportunities, the tool is now – during SEO’s Penguin era – considered as a vital tool to check the status of link removals.

  5. Another way to do this is using Google and MozBar. Set your search settings to 100 results, turn on the SERP overlay and do a search on your site along the lines of [site:mydomain.com ~keyword] or [site:mydomain “keyword”]

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.