To share some practical use of SEO report template

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

Whether you are serving the immediate boss of the party seoer or the personal work of the party B Seoer, who escaped the SEO report? believe that every month or even weekly, we spend a lot of time in data capture and form import bar. Today, the teacher will share a dry document with you, save you a lot of time to create and can suddenly be blinded by your friends.

First of all, to show you the SEO weekly. In fact, whether it is a weekly or monthly report or quarterly, focus on different, the core of the weekly report is what (work), the monthly reports are what (effect), the quarterly test achieved what (performance). We can according to the template of my article to make adjustments and improvements, of course, you can use directly, but a little sense of accomplishment.

The first part: Weekly Excel sheet can have 5 sections:

1) Overview (Overview): Use visual structure to show all the data, the customer in principle look at this page to understand what happened this week.

2 keyword ranking (KW ranking): The key keywords in the project or the Contract keyword to carry out regular ranking tracking, generally will automatically run every day.

3 Natural Flow (Organic traffic): Natural flow tracking can be UV or visits, set up a good collection of data units and standards, each week to import the original data.

4 keyword Flow ratio (incoming KW traffic%): Statistics of all natural flow of brand words and the possession of the word, because these 2 sets of data can tell us the form of traffic.

5) station data (on-site Usage): Only concerned about the natural flow and ranking of the data is only the appearance, must be at the same time the customer site to keep the status of the tracking (such as bounce rate, online time, p/v, landing page number, number of brand words, etc.)

6 Competitors (competitors): Horizontal comparison of competitor data is equally important, help to objectively understand the external forces, so that we can make timely adjustments in tactics, not in the frog.

Part II: Specific understanding of the use of the overview

I just said the overview is the summary page of the whole weekly, in principle your client or leader will not spend much time looking at the specific data or instructions in the report. They are more of a conclusion, so the overview page is to the conclusion, and must use visual design, at a glance to understand what is. So the teacher had these elements in the form:

The work plan is mainly divided into "summary last week" and "plan for the Week", the former tells the customer what you have done, what is the description of the specific matter, his importance is a few stars, the current percentage of the completion ratio is the person responsible for this matter who is the next move is what? The same goes for this week's plan.

Then in the lower right corner, it's a very important part of project management to have the customer responsible confirm. There is no customer-confirmed schedule, there is no plan to say, there is no collaboration can be said, easy to follow the project on the implementation of delays and customers do not know, such as to make you angina pectoris problems. To try to avoid these problems, you have to do your own work, you know!

Then is the SEO keyword Home rankings number table, I am here to calculate the key keywords in the project into a number of search engine home page. You can also design multiple dimensions, such as the number of the first page, the first 2 pages, or the number of 3 pages, in order to tell the customer how the current keyword ranking is progressing.

The third is the graph of natural flow, which is usually used by everyone. You can put in different units, such as visits (GA-oriented), UV (mainly Baidu statistics). This figure can also be made daily, weekly, monthly, if you do not, then you must come to the school study study!

SEO Station Data center is to let customers know the significance of the flow of light, there is no amount of traffic is futile, is the surface Kung Fu. Three-dimensional station data can show the status of the site. So you can put in the bounce rate, online time, p/v, landing page number, brand word number, intention leads number and so on data. Sometimes when our traffic data meets bottlenecks, you need to shift your performance perspective to see if there are better data to reflect your overall optimization. Remember that SEO is not just traffic up, more is the effect of big marketing, the market is good.

The fifth figure is the proportion of the type of keywords, understand the number of brand words to know our traffic is from what kind of users. is the new customer or the old guest, is not our marketing led the brand search, or our optimization aroused the brand exposed? You need to be in the data description after stating the meaning of the data, not just to tell a proportion, this is the test of your market awareness and your sense of marketing, if you do not have the ability and awareness, that should refuel Oh!

The last is the contrast of the opponent's data, mainly the performance of the whole station data. Can be PR,BR, included, backlinks, Alexa rankings, etc. any data that you think is of reference value to your customers. From some side to understand our site status, know the pros and cons of the opponent where. These data must be collected regularly, otherwise some data will be out of date.

Part III: Raw Data form template

Keyword ranking this form is basically the machine running data, and then manually imported. Each keyword can be set by the chain control, green representative rose, yellow representative down. Let you know which days are positive, which is the cup with day.

Web traffic forms, mainly statistics Baidu traffic (single out) + other search traffic, then calculate daily, in the calculation of weekly. So when you do the graph, the data dimension is much. Remember to make sure the unit is well.

Keyword flow ratio is the "Brand word" and "non-brand Words" flow calculation separate. You can then insert the pie chart. As for how to split out, the simplest way is to include the keyword "brand words" filtered out, the rest is not brand words. What if you don't? Burst the teacher to anger ~ ~

Site data suggest you divide into "This Week", "Month" and "monthly" three small forms, here I have helped you to divide (how good ~). In the weekly report you just use this week's data and use this month's data in monthly reports. As to exactly which station data you can change, do not need to go through the teacher's approval.

Competitor data in the same way, I've helped you frame the bottom of the data as long as the graphics will change.

Well, the above template is useful for an ordinary or even intermediate seoer. The form that teacher makes is always not soil, you can use in actual combat immediately. Then you have to ask, where can I download this form? Well, if the teacher doesn't give it to me, you're giving me a grass-mud horse, right?

Article source: http://www.zvenue.cn/zarticle/seo-weekly-report-template.html have any questions can be exploded teacher micro-letter: Bosonstyle