x

Ethan Lyon for the 12 Days of Linkmas

Extra Special Thank You to Ethan Lyon (of SEER Interactive) for his contribution to the 12 Days of Christmas. Signup for our mailing list and make sure you don’t miss a tip! Sign up for our Email Newsletter For Email Newsletters you can trust


Link Reclamation Using Screaming Frog

Directions

  1. Export links from any or all of the above listed resources
  2. Compile those links into one spreadsheet
  3. Remove duplicates in the target page column (i.e. the pages where people are linking to on your site)
  4. Create a new spreadsheet with just those links and save it as a CSV
  5. Run Screaming Frog in list mode, opening the CSV you’ve just saved
  6. Export the data to a new CSV, copy it to a new sheet in your original Workbook of compiled links.
  7. Perform a VLookup on URL column vs. the original target page column to bring the status code values into the original spreadsheet.
  8. Add a Filter to the Original Spreadsheet and filter out all the response codes that are 200 or 301
  9. Bring in the Domain Authority of all those links using this function =SEOMOZ_URLMetrics([URL],”68719476736″)
  10. Visits those sites and reach out to the webmasters that fit your criteria requesting that they update the links or provide new ones
Extra Special Thank You to Ethan Lyon (of SEER Interactive) for his contribution to the 12 Days of Christmas. Signup for our mailing list and make sure you don’t miss a tip!

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon
Sign up for our Email Newsletter


For Email Newsletters you can trust

Comments are closed.