Diễn Đàn SEO Panda - SEO Panda Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

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
 
HomeLatest imagesSearchRegisterLog in
Search
 
 

Display results as :
 
Rechercher Advanced Search
Latest topics
» Top 10 SEO Tools ( fresh links )
Http Status Reports With Open Site Explorer, Xenu and VLookup EmptyWed Feb 04, 2015 10:56 pm by tranvanchienhn

» Bán Textlink Pr4-Pr6 (1PR9)
Http Status Reports With Open Site Explorer, Xenu and VLookup EmptyWed Feb 04, 2015 10:54 pm by tranvanchienhn

» Google’s Penguin Update: What it is, What it isn’t, and What to Do
Http Status Reports With Open Site Explorer, Xenu and VLookup EmptyTue Apr 22, 2014 3:23 pm by johnaclayton

» Free Click Bank Affiliate Tool
Http Status Reports With Open Site Explorer, Xenu and VLookup EmptyTue Apr 22, 2014 3:21 pm by johnaclayton

» SEO is Dead – Long Live SEO
Http Status Reports With Open Site Explorer, Xenu and VLookup EmptyTue Apr 22, 2014 3:17 pm by johnaclayton

» Local SEO là gì - 10 Thủ thuật Local SEO
Http Status Reports With Open Site Explorer, Xenu and VLookup EmptyWed Apr 02, 2014 3:31 pm by bao.seoinet

» Get High Rankings by Building Authoritative, Irrelevant links?
Http Status Reports With Open Site Explorer, Xenu and VLookup EmptySat Sep 21, 2013 9:32 pm by kyostyle1

» The best Engineering software
Http Status Reports With Open Site Explorer, Xenu and VLookup EmptySat Sep 14, 2013 2:12 pm by read2

» Tuxedos- Traditional Interest Trend
Http Status Reports With Open Site Explorer, Xenu and VLookup EmptyWed Sep 11, 2013 2:16 pm by taiiwin


 

 Http Status Reports With Open Site Explorer, Xenu and VLookup

Go down 
AuthorMessage
khiemsound




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

Http Status Reports With Open Site Explorer, Xenu and VLookup Empty
PostSubject: Http Status Reports With Open Site Explorer, Xenu and VLookup   Http Status Reports With Open Site Explorer, Xenu and VLookup EmptyTue 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
 
Http Status Reports With Open Site Explorer, Xenu and VLookup
Back to top 
Page 1 of 1
 Similar topics
-
» SEOmoz Launch a Brand New Toy: Open Site Explorer
» Categorising Your Links with Excel and Open Site Explorer
» Yahoo Tắt Site Explorer trong năm nay!
» Yahoo Tắt Site Explorer trong năm nay!
» Yahoo Site Explorer chính thức khai tử

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: