Nine ways to help you become a website analyst

At present, the website analyst is one has the future and has "the money way" the occupation, if you also want to join in it, then the nine big ability which the following introduces is you must have.

1. Play Excel

Excel is one of the most primitive and easy to start analysis tools, if you have a small amount of data to analyze and summarize, Excel is your choice, combined with rich functions and formulas, you can easily get the data you want, if you know the computer language, will be programmed with VBA that is even more powerful, and can also easily make a bar chart, pie, line charts and other charts. But Excel cannot be the perfect analysis tool, because his data capacity is so small that more than 10,000 rows of data should not be used in Excel.

1.1. Common functions:

1.2. Common functions:

2. Basic knowledge of website analysis

Understand some of the basics of web analytics is necessary, you need to know what is the session, what is PV, what is UU/UV and other indicators value meaning. The following figure (excerpt from the basic Web Analytics Tutorial Chapter II) shows:

3. Knowledge of website development

Site analyst by measuring the pros and cons of various indicators to evaluate the status of the site, as well as to improve the optimization of the countermeasures, if the analyst himself on the development of the site and building knowledge is not understood, it can not be accurate through the analysis of indicators to measure the level of the operating situation of the site.

As a qualified website analyst, you need to know some website construction and operation Knowledge, as well as the knowledge of website design, and user experience related knowledge. In this way, you will be able to present a more highly and in-depth analysis of the report.

4. Network Marketing Knowledge

The scope of the site Analyst's work can be divided into two areas: "Station" and "Outside Station". The focus of the station is to improve the user experience, optimize the transformation path, SEO, analysis of user behavior and other station activities; The focus of work outside the station lies in how to attract users to the website more accurately and more accurate.

The so-called work outside the station is mainly refers to network marketing, network Marketing in accordance with the specific implementation of the way can be divided into: Display ads (display advertising), PPC promotion, SEO, mail marketing, video promotion, QQ Group promotion, blog marketing, microblogging marketing, SNS marketing and so on. If you want to be a website analyst you need to learn the following:

4.1. Advertising Type

Search engine Advertising (PPC)

Exchange links

Banner ads

Mail Marketing

Traditional media advertising

4.2. Advertising related indicators

Show Number (Impressions)

Number of clicks

CTR (Click-through Rate)

CPC (cost per Click)

CPA (cost per acquisition)

Conversion rate (conversion Rate)

Roas (Return on advertising Spend)

4.3.SEO knowledge

The ranking algorithm of the mainstream search engine

TITLE,META,HN,H1 optimization

5. Test methods

When the value of the site Analysis index is not very optimistic, or if you want to do a large-scale promotion, it is also possible that you need to change the site, as an analyst needs to predict whether the effect of improvement can reach the expected, this is a matter of experience is difficult to do, Then need the website analyst clever use the teacher to verify the method, this is the most direct and accurate effective method.

Website analyst needs to learn to use such testing methods as A/b test, multivariable testing, user experience testing, and so on to evaluate the improvement program to reduce the risk of implementing the new scheme.

6. Communication skills

As a website analyst, you need to work with a lot of people to accomplish tasks, including project managers, product managers, operations managers, implementation managers, and tool providers. Efficient, accurate communication is particularly important.

For communication, the ability to express language as the most basic element of ability is indispensable, but want to be able to smooth communication only rely on language is not enough, but also need to have a certain amount of information on the organization and ability to summarize, as well as the sense of teamwork.

7. Ability to speak

When a website is revised or upgraded by a site analyst, the usual approach is to use numbers and graphs to convince policymakers and conservatives, but in fact it is not so easy to convince more people that, in addition to relying on accurate analysis of the data, there is a very inflammatory speech by website analysts and a deliberate response to questioning. Site analysts need to pass on their self-confidence to all the people present at the conference in the form of speeches.

8. Will do PPT

Speech and presentation of the time, the necessary tool! Of course, if you can make a very cool animation effect will be able to infect more.

9. Planning management capacity

If you work as a website analyst in a small company, planning management may seem less important, but if you are a website operations manager for a large company, or if you lead an analyst team of dozens of people, the management capabilities of the program will be particularly important. In order to better communicate with project managers and management, you need to have this skill, even need to learn some project management related knowledge, such as PMP certification.

This article based on the author's work experience and feelings summed up as a site analyst should have 9 big tools to share with you, because the author's ability to experience priority may be omitted or one-sided place, but also hope that the site analysis of the predecessors of the field of advice, thank you!