I'll teach you to play. Excel Analysis Web Log

Source: Internet
Author: User
Keywords Excel

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

In the popularity of SEO gradually under the big wave, many so-called seoer will be her simple content and the outside chain, in fact, this statement is not wrong, the content and the chain is indeed the most important to do SEO two major means, but it is like a leader in a General Assembly speech: "We want to go forward, we have to be excellent and enterprising!", The future is right, excellent enterprising is right, but rely on what the future, excellent enterprising is unknown. So here I want to say is the scientific rational view seo, content and outside the chain of some methods in the publication of the details here, let's talk about how to effectively analyze the effect of SEO in a stage.

Next, we should know that the search engine on the site to understand the Web spider, so through the analysis of Web site log network Spider's trend, you can clearly understand the spider's access frequency, access to go, so as to analyze the correct SEO optimization methods.

The general Web site log is

66.249.72.250--[16/jun/2012:01:03:44 +0800] "get/skill/skill06/20120501_261_2.html http/1.1 15468"-"" MOZILLA/5 .0 (compatible; googlebot/2.1; +http://www.google.com/bot.html) "tcie.cn html"/usr/home/hmu090204/htdocs/skill/skill06/20120501_261_2.html "

Each data represents what meaning does not introduce each, do not understand can ask Baidu. So we said earlier to analyze a stage of the data, this phase can be half a month, 1 months or even 1 years, and then through the method we introduced to achieve the purpose of data analysis. The specific actions are as follows:

1, the example selected 1 weeks of data, where we need to use a tool-"Light years SEO Log Analysis System" (not ads), using its "log split" function, can achieve the purpose, the following figure.

  

2, click Next, add split conditions, select to the agent, in the custom value to fill in the Baiduspider (here is the analysis of Baidu Spiders, you can also fill in Googlebot to analyze Google spiders), and then next ... Until the save, will eventually generate two. log files, without _exclude is what we need, with _exclude is split after the rest.

  

3, open the log file we need, then start with date fourth to the end, copy the whole to column A in Excel, and then take advantage of Excel's partitioning function, "Data"-"column"-"separator"-tick "space"-"complete", and finally get the tabular data we need ( The table header is shown below).

  

  

4, the first 3 steps is the Web site log data table production process, then need to use excel in the powerful "PivotTable" function of data analysis work, I use here is the excel2003 version, with 07 version of the students can be found in the data.

  

5, click on "PivotTable and PivotChart report", Excel has helped us select a range, and then click Finish, then the "PivotTable" interface.

  

6, we can try to drag "date" in the PivotTable Field list into row fields, and then drag "Cs-method" into the data field, what do you see? as shown in the picture, from June 10 to 17th, every day Baidu spider visit the number of times is obvious, The frequency of the spiders must be related to our operation, recall, in the spider access frequency of the day before you have done something, more to do such a summary, you can draw the law.

  

7, you can not only analyze the frequency of spider visits each day, you can also analyze spiders crawl your site which pages, the method is very simple, "PivotTable" in the "row field" of "date" replaced by "Cs-uri-stem", refresh the PivotTable report can be.

  

Above I mentioned also is only some basic method, or that sentence, the tool is dead, the person is alive, the data analysis dimension lies in you want to know what kind of conclusion. This article by the Network Marketing company Http://www.tcie.cn provides, reprint please indicate the source, the sharing is a kind of virtue, please respect the original.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.