Analysis on the improvement of medical seoer consultation Quantity

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

As a medical seoer, your job responsibilities are not limited to daily only around the chain, the chain, title, Kewords, description ... These basic things go back and forth. A good seoer should also have sharp data insights and rigorous data analysis capabilities.

A few days ago to get a certain hospital in a portal to buy the channel page of the dialogue effect of the monthly statistics, today I want to use this data report from another perspective to explain the most basic data analysis, some of the process needs attention, the following share for reference only.

The data report is as follows (important data I cover with background, hope you understand):

Report Picture View Address:

Above I will be a screenshot of the report, in fact, this is a hundreds of dialogue with the monthly data report, and the data is messy. Our goal now is to extract data from these messy data that are useful for our optimization.

Obviously, throughout the report, the most important data for us should be the "key words" that generate the dialogues, the "landing pages" of the Dialogue keywords, and the "number of conversations each keyword brings" (because some words bring up multiple conversations within one months). With these three metrics, let's start with Excel with simple data analysis!

The first step: Select all the data cells, the data--filter--and then descending the keyword to get the following effect

Effect Chart view address:

After we sorted the results, the obvious change was that all the same keywords that brought the conversation were lined up in the table. With this effect, and then the second step, we need to count the number of conversations (that is, the number of occurrences of the same keyword) that these words bring

The second step: Select all data cells, data--subtotals--to determine, get the following interface:

We follow the diagram, select the keyword, count, check the keyword these several options, and then determine, and finally get the following count results

Count Result Chart view address:

Obviously, there's a number in each of the same keywords, and that number is the number of times the word is created by a month search.

Step three: So far, these three data we have, and finally we will these "monthly search generated dialogue number" of the key words again descending, even if the completion of the half!

Again in descending order view address:

After descending again, all the data began to be clear, and finally we will make some bold highlighting of the table, the result is clearly present in front of us

Final processing result Chart preview:

Although this table is a portal channel page of the dialogue, but in the specific operation and analysis process, this method is very wide range of applications, both in-station, extrapolation is applicable!

Many friends may think, since sharing is data analysis, the article title also mentions "the Indirect Enhancement website consultation Quantity", up to now, just speaks the operation process, in the end we from this processing table can analyze what data comes out, how to pass these data analysis to enhance our dialogue consultation quantity? Predict how through data analysis to improve the amount of web site visits and dialogue, please continue to keep the attention, thank you! (days can battery http://www.dc0871.com)