How to use Excel to easily analyze IIS logs

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

Everyone good, as a A5 webmaster platform loyal fans, every day regularly to see the contribution has become my habit, in this platform to learn a lot of useful knowledge, so today want to write a piece of their own experience to feedback the vast number of webmaster friends.

As an SEO, should be encountered every day such as the problem, in the emergence of various problems, there is a common sense is to first analyze the Web site log, through the Web log can record the search engine spider robot crawling site details, such as: Which IP Baidu Spider robot in the day visited the site how many times, Which pages are accessed, and the HTTP status codes that are returned when the page is accessed.

Of course, this article is not about how to analyze problems by logging, and on the various parameters of the log on behalf of what, online has a lot of technical articles, here just for you to share a more clear and intuitive view of the log, some people say there are a variety of log analysis tools on the Web, some people say directly through the search to analyze, However, there are certain limitations, log analysis tools can not let you distinguish between true and false spiders (many tools have simulated spiders crawling), and many tools have restrictions on the number of display, and direct lookup is not a lot of analysis and statistical data.

In fact, we simply through the Excel table can get very intuitive data interface, and very easy to analyze, now say stadia biography, to see How to operate:

1. The first text to open the log file, delete data before the text (including spaces), as shown in the red box for the text that must be deleted, so as to import after the show no dislocation. Save, exit.

2. Create a new Excel table, such as the "data" → "Import external data" → "Import data".

3. Locate the folder where the log resides, select "All Files" in the file type, then display log files, double-click to import.

4. In the Jump Into the Import Wizard dialog box, select the separator symbol, click Next. Then, in the separator symbol, select the space option, and then the next step. Click Finish directly and click OK in the New dialog box.

5. At this time, we can see the log data very clearly appear in the table, at this point we have to do is to make the data easier to retrieve, select the first row of data, click "Data" → "Filter" → "AutoFilter." We can see that the first row appears with a drop-down arrow, in this, we can easily select the data we want to see, for example, to see the details of a page is visited, you can find the corresponding page in the "Cs-uri-stem" drop-down box, if the page is too much can also be in the dropdown box to select "Custom" To carry out various operations, convenient and intuitive. If you want to see Baidu spider data can be in the "CS (user)" Choose Baidu Robot.

At the same time, this filter also supports the check, for example, you can select a spider's status code by combination, you can also see the front of the spider IP, unwanted parameters, you can select that column to delete or shrink, so that the entire data interface more intuitive.

Today to share is so much, I hope to webmaster data analysis has some help, if there are other better ways, hope to be able to communicate on the A5 platform. This article is made by Http://www.shushi100.com Comfort Home Network editor, the first published in A5 website, such as in case of reprint please keep the link, thank you.