A qualified seoer should have a qualified Excel table

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

Look at now A5 above a lot of articles, belong to the type of "fast food", pure soft wen, there is no learning value. I try to calm down, serious write about SEO article, I hope to those who want to get started SEO and do not know how to do the novice a little useful, I am not a very cow x seoer, but let me serve the site to obtain a better ranking, here just to share with you.

This article is mainly aimed at the novice, so write a simple and detailed point, there are years of experience in SEO veteran can be a smile. Here we go!

As a seoer, first you should see an Excel table, and then, create 4 worksheets in the Excel table, four worksheets, you can name it, from left to right in order of the chain, keyword ranking, Friendship link worksheet, competitor analysis.

Outside chain

This worksheet is mainly to record the website address of the external chain, specific can be divided into Friendship link platform, question-and-answer class, bar categories, bookmarks, collections, community forums and so on, of course, these are resources, you need to do the chain in the process of accumulating, if you too much address, many forums registered username and password can not remember, You can insert a callout in the name of the website, and write down the password of the account so that you can find it in the form if you forget it.

In addition, after the site name and site URL link also add a list of comments, record the forum/site rules, such as the irrigation mechanism Ah, audit mechanism ah, so that you face so many sites when you can choose to prioritize to which forum to stay outside the chain.

Keyword ranking

Until now I have not found a good record keyword ranking history of the SEO tool, chasing words have this function, but there are 100 keyword restrictions, and I looked at the next is not accurate. I now use the view of its keyword ranking tool, and then each query of the whole station keyword ranking exported Excel format, and then copied to my Keyword ranking worksheet, every day to work will guide once, and record the time, such a period of time down to see the keyword ranking of a trend, can also see you for some time since the effect of SEO.

Links worksheet

Now provide links to query the tools have a lot of, just detect each other there is no link to your site is not enough, you need to know more about your links site more information, such as the site responsible for the contact, such as the link between the key to Chengdu and so on. This way you can ask the person in charge for specific reasons when they remove your link. The exact format can be like this.

Competitor Analysis

This should have been written at the beginning of the article, because when you do SEO for the site, the first step to do is to understand the competitor's information, want to know your site's competitors, you can use advanced search commands in Baidu, such as you want to know what you want to optimize the key words currently have competitors, Can be in the Baidu input intitle: Add keywords to see the same keyword site ranking status, and then can be recorded in the top 10 Baidu home site, and then one by one analysis.

SEO, is a process of accumulation, must have patience, in the work constantly improve their own methods, can not progress, more and more mature, The author at present as Chang Network www.cwddd.com SEO Commissioner, is constantly groping the road of SEO, stumbling is unavoidable, personal views are not necessarily completely correct, I hope that we can learn from the useful things. Also hope that more seoer to communicate with me, share, the author of this article qq:1940754648. (This article is the author original, starting A5, reproduced please specify the Source: www.cwddd.com)