Tip Junkie

Excel for SEO: Find links to dead pages

How many times have you changed up site architecture? If you’re in ecommerce or you work on larger sites, this might be a common problem for you. One of the biggest SEO related implications is that old, relevant, authoritative links may have been lost in the process. Learn the process here:

http://www.sgsolutionsllc.com/link-juice-recovery-in-excel-find-links-to-dead-pages-on-your-site/


Excel for SEO: Find links to dead pages
Just a Tip!
Difficulty: Moderate
Budget: Absolutely Free
Estimated Time: Under 30 minutes

You Will Need...

  • Excel, Firefox

Instructions

# 1

Export all your backlinks to CSV.

# 2

Move all the URLs that you will check to Column A. (These are the URLs that are pointing to pages on your site from other sites.)

# 3

Implement this handy code. (Link Juice Recovery Code for Excel) (It is a VBA script that you will implement into your excel doc. For help on getting setup in excel for that, go here.

# 4

Select the cell you would like the result of your test to appear in.

# 5

Enter “=HttpExists(A2)” (without quotes)(“A2″ represents the cell that you are checking. Simply pull down or copy/paste the down the rest of the cells you would like to check.)

Inspired By:

SG Solutions blog

Shared By:




LoadingFavorite
«
0

No Comments

Comments

You must be logged in to post a comment.

Love this?Right Now!