How to parse the site log by using Excel form

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

In today's SEO environment, we can find that a lot of seoer tend to be attached to high-quality outside the chain and content, every day is tired of the chain and the content of the construction, but experienced the latest phase of the Baidu big update, we need more profound understanding of the current environment, For us seoer more need is to have a good analytical ability, analysis what content by the search engine's favorite, what outside the chain can better attract spiders, the near-stage optimization means to the spider just what effect and so on. To get this information we need to use the site log. Because from the log we can get search engine spiders for our site's latest developments. How to better analyze the log of the site? The following author on the use of graphic analysis of how to use some small methods to simplify our log analysis.

First we need to understand the log format of our site, as shown in the following figure

We can see from the log file above the spider to our site crawling situation. which contains spiders crawling frequency, crawling to the whereabouts and so on, with these data we can make more effective SEO strategy. Then how we more convenient analysis of these data, the following author on a simple introduction to a small method, the specific steps are as follows.

First of all: we can select a phase of the log file, and then analysis, we can use a small tool. As shown in the following illustration, this tool can help us analyze our tools and dig out useful data information.

Next, we need to click "Next", select the agent, while we in the custom value of the box input "Baiduspider" (this is the meaning of Baidu spider, if you want to analyze other search engines, such as search, you can enter Sosospider), then click Next, and finally save the file, Then the tool will be more our set, automatically digging out the information we want.

Then open the generated log file, copy the area selected in the following figure, and paste the area information into column A in the Excel table. Then open the Excel menu and do the following: "Data" > ">" "Delimited" > "Space" > "complete", and then you can generate the format we want, as shown in the following figure.

After the three steps above, we have generated an Excel table Form of the Log Analysis table, and then we will be through Excel to analyze the log. We need to use the "PivotTable" function in Excel analysis, the author is using the excel2003 version of the operation, as shown in the following figure, if you are using 2007 or a high version, you can also in the menu bar data options to find the relevant options.

When we click on the "pivot table" we will go to the page shown in the following figure.

We then pull "date" in the field list to the left row field, and then pull "Cs-metbod" into the Center data field. Then we can see a clear, search engine Spider's Daily crawl record form from June 10 to 17th. We can analyze the spider crawling frequently those strips you have to do what optimization work, you can find more consistent with their own optimization strategy.

We can not only analyze the search engine spider's access frequency, also can understand the search engine on your page crawling situation, the principle is very simple, we just change the line field "data" to record access to the page of the field "Cs-uri-stem" can be.

I hope the author to share this small method for everyone to help. Finally, I would like to sum up a word, that is the tool is dead, but people are alive. If you know how to adapt, it will make your optimization more effective.

This article by the plastic bottle manufacturer (http://www.bzping.com/) Stationmaster publishes, welcome everybody reprint, reprint when please retain this link, thanks cooperates!