Solve Google Webmaster tool data export garbled problem

This is a well-known SEO a big weapon, in the use of the time can really help me improve the efficiency of SEO, should be every seoer should go to apply for the use of SEO basic tools. I myself also Google Webmaster Tools a big fan, feel that this tool is really in the work to help me solve a lot of problems, such as simple HTML error to the complex site by others malicious attack and so on, Google Webmaster tools can find out when the problem, and give a reasonable change of opinion , thus saving unnecessary time and improving the efficiency of SEO.

Google Webmaster Tool I personally like to export data to analyze, because this is more detailed, can also be recorded to avoid the need when the time is not found. Individuals prefer to view and export data with the following several:

1, capture the data in the statistical report

The number of pages crawled daily, the amount of data downloaded per day, time to download the page this three data is very important, through these three data you can know your site is Googlebot crawl every day and download the situation, when there is a crawl problem when this report can be timely response to problems, not only that, These three data have a cross relationship, due to the problem of space or later in writing this section alone.

2, point to your site link

This data is stronger than any outside chain query tool, can know the site each page of the external link number and source domain name, from the above one can see your external link is consistent with the principle of universality. Not only that, it also tells the site's location text, which is usually what we call the anchor text concept.

3. Internal links

This data can see the site's internal links, whether the important pages get more internal links? Do you have a good internal link assignment? It can be clearly seen here, combined with the site's ranking index and the external links mentioned above to know that those pages to obtain external links is not enough, There is data to guide the site's SEO.

A cursory look at these three data must be needed. Of course, if you want to carefully diagnose the site, you need to use other data, here is simple to say that these 3.

Then have data need to export how to do it? Personally think that Google Webmaster tools only bad is that the export of data is not our usual format, and some people use the Code conversion tool to achieve normal format view, but personally think that this method is slow, the following introduce my own method.

Take the search query data for example:

In general, the data exported is as follows:

　　

Processing method:

1, will download the file with Word open, at this time see is the normal situation shows.

2, copied to the original Excel, at this time all the data of the next together.

3, select the entire column of data, and then click on the data-disaggregation, choose the appropriate method of disaggregation.

After the modification as shown:

　　

It's a lot more convenient to look at this time.

This article from Guangzhou seo-Chen Yulong Blog, reproduced please specify: http://www.yulong89.com/