How to count Web traffic from the log

See this topic, perhaps someone will say, we directly install a third party on the website (51, CNZZ) statistic code can not statistic the website traffic, why still want to analyze the log? Oh, I give you a few numbers, you will certainly not say so after reading.

　　

The image above is a certain installation of 51 statistics Code of the website, Baidu Webmaster tools in the page optimization recommendations can be seen, a statistical code needs 3 times request. Let's assume that these 3 requests take 0.01 seconds (perhaps more). If a daily search engine crawls 10,000 pages from your site, it takes 10000*0.01=100 seconds. We follow the search engine to download a page takes 1 seconds, if not the installation of statistical code, search engines can crawl more than 100 pages. See this data, you will also install the third party site statistics code it? My suggestion, if your site has only dozens of or hundreds of articles, the installation of statistical code is a good choice. If your website article more than 1000 articles, I suggest that you still do not install, directly from the log analysis of the site traffic, is also a very fun thing.

The tool you need to analyze Web traffic from the log is Excel. I believe this is also a lot of webmaster analysis log essential tools. Today we want to analyze the content of the log is about the source of the site records, that is, the site traffic, other information is not discussed.

First of all, we need to import the site log into Excel, the specific method can refer to the "Skillfully use Excel Analysis Web log" this article. When you import a log file, you need to be aware of the second step of the Import Wizard, as shown in the following figure

　　

The successful import should be the following format

　　

Among them, the F column is the current IP address access page, I column f column is the source of access, that is, F page is through the I page over traffic. An example is provided:

　　

(Figure I)

　　

(Figure II)

Figure A user of IP address for 125.79.174.154 through http://bbs.admin5.com/thread-8667106-1-1.html this page to visit the homepage of the website. Figure II represents the IP address: 111.36.235.178 users through Baidu search a keyword to visit the homepage of the website. We know from these two examples that the site traffic source information is recorded in the I column. So the I column is the object of our main analysis today.

After the initial understanding of the data, it can be based on this data to calculate the site traffic. The source of the Web site traffic has three parts: direct input to the Web site access traffic, through the search engine over the flow and through other sites to obtain traffic. Below we will analyze these three parts through the log.

We first analyze the direct input of the Web site to visit the traffic, this is relatively good statistics. In the Excel table, select the data--> filter--> AutoFilter. Select Customize at the Drop-down arrow in the I column.

　　

Follow the contents of the red box above (the right box is your website address, and the end must be prefixed with a backslash "/"), and then determine. In addition to the first line, is directly entered the Web site to visit the data. We copy the information to the form Sheel2 and then delete the information in the Sheel1.

Next we analyze the traffic from the search engine. We take Baidu as an example, the other search engine traffic analysis method and Baidu exactly the same. Select Customize at the Drop-down arrow in the I column.

　　

Enter the content in the red box above and then OK. In addition to the first line, it is through Baidu to obtain traffic. We copy this information to the form Sheel3 to save, and the Sheel1 in the Baidu traffic information deleted. According to this method, we filtered out the Google, Sogou, search and other search engine traffic, and are kept in the SHEEL3 (also can be saved separately to other forms), so that all the search engine to the traffic.

Through the above operation, the site log left two parts of information, part of the site in addition to the first page of other pages of information, these are users in the traffic site records information, the other part is from other sites to obtain traffic information. As long as we delete the first part of the information, the rest of the nature is the information we want. Let's see what I'm doing. Select Customize at the Drop-down arrow in the I column.

　　

According to the red box in the above text input (right box for your website address, pay attention to the URL on both sides of the * number OH), and then determine. Remove the filtered content, and the rest is the traffic from other sites. However, we will see that there are many blank lines in the I column, it looks very inconvenient, hehe, it doesn't matter, let's take these blank lines clearly. Let's go ahead and select Custom at the Drop-down arrow in column I.

　　

Follow the contents in the Red box above, and then select and delete the results. This time is not at a glance. The rest of this information, naturally, is the flow of money from other networks, you can clearly see where traffic is coming from the site.

Through the above steps, you can count the traffic information of the website. After reading is not feel very complex, very cumbersome? Even so, I suggest you carefully read this article, but I do not recommend that you do this every time. You can take this article as a original reason article, and then do it yourself, develop a plug-in, automatically to complete this matter. In this way, you have a tool that can be used to count web traffic. As a SEO personnel, I think this tool should still be necessary.

NET Earn http://www.12651.net original, reprint please indicate the source.