Diễn Đàn SEO Panda - SEO Panda Forum

Diễn Đàn SEO Panda Dành Cho Các SEOers Tự Do Thảo Luận SEO - SEO Panda Forum - Free SEO Forum to share your knowledge to the world
HomeCalendarFAQSearchMemberlistUsergroupsRegisterLog in

Display results as :
Rechercher Advanced Search
Latest topics

Share | 

 Http Status Reports With Open Site Explorer, Xenu and VLookup

Go down 

Posts : 1016
Points : 14445
Join date : 2012-03-27

PostSubject: Http Status Reports With Open Site Explorer, Xenu and VLookup   Tue Apr 17, 2012 8:57 am

Open Site Explorer is a really nice tool to enable quick and easy reviews of your best inbound links, most linked to pages and most frequently occurring anchors in text links. One of my favourite tools in OSE has always been the classic “Top Pages” report, allowing for deeper visibility on your most linked to pages.

Image credit: Br1dotcom

With the top pages report, you may find that lower authority sites with many pages get less crawl bandwidth than sites with higher authority. This can lead to URLs in the report with “No Data” in the HTTP status field. No problem, here’s a tip to get the most out of that data using Xenu’s Link Sleuth and a simple VLOOKUP in Excel.
Collect your Open Site Explorer data

First, you’ll need to navigate over to the Top Pages tab in Open Site Explorer, and export all of the data into Excel via CSV.

Paste the exported data in to Excel and make a table

I like working with Excel tables, so highlight the exported data from the CSV and press “CTRL + L” to make your table:

Grab a refreshed and up to date list of HTTP headers

Now you have your list of internal pages, copy the list and paste what you’ve got into Notepad (Or Notepad++, Programmers Notepad or whatever else you use). We’re going to save that list and upload to Xenu via “Check URL list”.

With the list of URLs saved, open Xenu and head to “Options > Preferences“.

It’s really important to set “Maximum level” to 0, that way only the list of URLs you’ve provided will get crawled and Xenu won’t discover and follow any new URLs.

Next, head to “File > Check URL list” ready to upload your URL list. Xenu will get straight on with the business of crawling that URL list. If you’ve got thousands of URLs, this part could take a while, so make yourself a coffee or get on with some other work for a few hours… As soon as Xenu is finished, export the crawl results into a TAB separated file.
Import the crawl data in to the Excel spreadsheet and perform a VLOOKUP

Import your new list of URLs into Excel by pasting the data into a new tab. If you’re using tables, be sure to create a table with your new data. The new table should be called “Table2″. Next, you need to VLOOKUP the URL and fetch Xenu’s recorded server header response. The query will look something like this:

=VLOOKUP(Table1[[#This Row],[URL]],Table2,2,0)

If you’re not familiar with Excel, try reading using tables in Excel 2007, and this post explaining VLOOKUP. The end result should be a table that has a new column with your up to date Xenu server header results making for a powerful, highly actionable review of your site’s most linked to pages.
Back to top Go down
View user profile
Http Status Reports With Open Site Explorer, Xenu and VLookup
Back to top 
Page 1 of 1
 Similar topics
» open every link in a new tab?
» start selenium 2 with Internet Explorer.
» Internet Explorer 11 tabs are not working
» Sample UI Element file for google site.
» Did you commit to Selenium-Stack Exchange site?

Permissions in this forum:You cannot reply to topics in this forum
Diễn Đàn SEO Panda - SEO Panda Forum :: Search Engine Optimization :: SEO Tools & SEO Tips-
Jump to: