Is there anyway to automatically find complete urls for 301 redirects?

[AdamBohr]

Hello all,

I'm working on a large site that is being prepared for a migration. After scraping on screaming frog, WMT, and deepcrawl, and deduping I have a list of 404 pages that need redirected. Many of these URLs are just incomplete URLs.

For example the incomplete URL would be: "https://moz.com/beginners-guide-to" when it should be "https://moz.com/beginners-guide-to-seo"

I have been finding the correct page manually searching google. With hundreds more to go, I am looking for a way the would be a little less laborious.

Thanks!

https://moz.com/beginners-guide-to-seo

[antonioaraya]

A quite close solution would be an Excel spreadsheet with 3 columns:

• A col: 404 URLs
• B col: 200 URLs from your SF crawl
• C col: This formula on C1 and for the rest of the rows: =VLOOKUP(""&A1&"",$B:$B,1,FALSE)

So, you will get in A col the URL needed to be redirected, and C Col, the URL to point the redirect.

Let me know if this works for you.

[Everett]

Hello Adam,

Screaming Frog should give you the full URL. If you're not getting it something is wrong and you should contact their Support team.

If you're talking about Google Analytics, which tends to do that, try this fix:
https://splitter.uservoice.com/knowledgebase/articles/178552-how-to-show-the-domain-part-of-a-url-in-google-ana