Use Excel table to summarize five aspects data that stationmaster needs to analyze

Source: Internet
Author: User
Keywords Excel five one number of faces

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

As a professional seoer in the early days of optimization, will do a rigorous data analysis report form, the existing situation analysis and analysis of competitors in the same industry, if you can not do data analysis, it allows you to optimize into the "Blind River, Touch the Road" dilemma. So what data do we need to start with? The author will use Excel form to make five points in the following article. Doing well in these five aspects of data analysis will be your optimization is no longer the blind crossing the river.

One: Analyze the competitive strength of keywords

  

In the early days of optimization must have a detailed schedule of keywords, for example, to do the core keywords, do the above statistics, judge the competitiveness of keywords, the keyword optimization of the degree of difficulty ranking, and then according to their own team resources configuration, a slight estimate of each keyword need to row to the first page of time. Finally, in line with the current situation of the key words to optimize the intensity of the corresponding adjustment.

Let's give an example: keyword 1 is big but competitive, keyword 2 Although the flow of small points, but the strength of the general, we according to their own situation, if you want in the shortest possible time to obtain a certain flow of words can do the first keyword 2, if the company to do the bidding rankings, can be ranked with the bidding and optimization combined.

Second, the analysis of competitors in the industry

In the process of optimization competition is necessary, how to make themselves in the competition with peers to obtain large profits, we need to do a good job in the same industry opponents analysis.

  

The analysis of competitors, you can clearly know the gap between themselves and the opponent's site, how long it takes to catch up, of course, analysis of our competitors is not just the above, which also includes the main structure of the site layout, optimization of the reasonable degree of analysis and so on.

If our competitor's site layout is not very reasonable, the optimization is poor, site age is not long, that we can not hesitate in the shortest possible time to overtake him, but the opponents optimized well, at the same time have a certain age, in the business enjoy a good brand reputation, if you want in a short period of time than he is a very difficult thing , this requires us to adopt other strategies, such as avoiding our lack of advantage of the main keyword, to do long tail keyword optimization, to find out the blank area of the opponent optimization, occupy a place.

Third, the analysis of the key words

Analysis of the key words, we can find the main development of site optimization direction, and the Site keyword layout rationality,

Like the author generally divided into several categories of keywords

  

Because of the different key words its conversion rate is also different, we can classify keywords. Detailed according to the industry classification, so we can get a detailed list of keywords. In doing site optimization, first from the conversion rate of the key words to do optimization, so you can increase the maximum volume.

Iv. Daily Site Data analysis

  

Do a good job of the daily website data statistics, understand the daily situation of the site, but also include the IIS log analysis of the spider's trend and the user clicks the graph analysis, etc., because this article many, the author does not introduce.

Data statistics within the site

As shown in the following figure. We can do the following statistics, to understand the dynamics of each link, so that enterprises can be healthy operation, understand the internal defects, and then make corresponding rectification. Detailed table can be based on their own company personnel to make certain adjustments.

  

Optimization work is not based on feeling to do things, optimization needs is the accumulation of technical experience and reasonable data analysis and statistics, do the above five aspects of data statistics, so that the site optimization is not blind river, no longer lost in confusion. Believe that optimization is therefore simple.

This article by Taobao http://www.hza.cn/original, A5 start, reprint please keep the source.

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.