Starting from 0, teach you how to do the first step of data analysis

Intermediary transaction SEO diagnosis Taobao guest Cloud host technology Hall

First of all, I would like to talk about my own use of Excel tools such as analysis, and the use of these off-the-shelf data platform differences.

1, will use tools to do their own analysis, not limited to Taobao, this era of what the industry has data, if mastered, you can do anything to apply. Taobao index or Ali index can only be limited to Taobao this piece.

2, with off-the-shelf data platform, only to be able to read data, almost do not need to do their own analysis of data. Maybe 100 people have 10 people who can read the data and apply the data, and if you have to do it yourself, 100 people may have only 2-3 of them. Often the opportunity to analyze yourself a little bit more than others.

We return to the theme, this article is for small sellers or prospective sellers, prospective sellers is about to become a seller of friends. Because we do not have a data cube this time, there is no e Sutra, but do not fear, still do have analysis.

Put forward a concept: "Risk control"

In fact, at any time, businesses need to control risk and minimize the risk of business activities. But these 4 words, especially for small sellers or prospective sellers, is extremely important, because we can not afford the risk. Like a lonely boat in the sea, a wave of waves, it disappeared, this case I see too much.

Therefore, we must learn to risk control, to minimize the risk.

So, next, look at the data with me.

Taobao index: shu.taobao.com

　　

advanced to the list. Pay attention to the information here, such as statistical time, and ranking type, the following is the search ranking

　　

"Here you can find the keyword in the explosion, the keyword and the product is related, this is a portal." For example, the windbreaker has grown about 5 times times, we choose a product in the growth, with this product demand growth, it is relatively easy to do some. 】

See the things to go to search verification, because we must eliminate the artificially brushed market, if I strayed into this market, may suffer losses. Originally, the word "windbreaker" is Taobao's prop word. No problem.

　　

You should be aware that the first thing you see is search rankings, the data is compared to the previous week's gains. Statistical time in the upper right corner, this should be noted.

================================================

If you are diligent, you can collect data on a regular basis and paste the data into an Excel form. Step I'll show you, select the data, and then right-click the copy

　　

To Excel, right-click, paste selective

　　

Then you see the result, but the result is not the format we want. We're going to change the data in the data.

　　

　　

　　

That's it. Following a lot of data, diligent friends can take down the data.

============================================

Deal ranked inside more than a hot index, there is a geographical choice, according to their own region, you can give priority to choose. This is a category ranking, category is the product category.

In the last 7 days, the top three categories were the bottom shirts, dresses and coats.

　　

Here is the brand ranking, consignment of friends can be compared to find a better brand agent. But sometimes the brand chooses you, not the brand you choose. So find a better one.

　　

The last one is the industry ranking. is the category of Taobao top ranking. Also pay attention to this statistic time.

　　

I casually find a look, on the home service suit.

　　

Click, you can jump to here, the default is the search index, but I generally used to search and deal two index together to reference, you can see an industry's off-season and peak season, this is necessary to understand, not silly to the off-season to kill into the market. Statistical time remember to see, the bottom can adjust the time period of statistics.

There is a growing trend here. But note that this is for search.

　　

Why to search and deal with the reference? Because the search represents the demand, but may not be the real demand point, may be the buyer first in understanding, the time will be a deal. Turnover index is needless to say, for buyers of many places, you can carry out the corresponding promotional strategies, such as the use of rotten to the packet mail, thinking of their own expansion.

　　

Sex and age are important, and we have a lot to do with choosing products and making details pages. Special clothing category, selling Meng Pack and mature pack crowd significantly different, choose the quality of the crowd may be easier to do. Can be seen, the majority of female buyers, more than 35 years of age, turnover is very high (deal preference (TGI) = Search word deal of the crowd accounted for more than 100 of the total network transactions, accounted for is not small

　　

For the following constellation, suitable for special use in the young family, sometimes, playing the constellation Lucky/lucky Money, conversion rate will be exceptionally high.

You can see that Capricorn, Virgo, Sagittarius, Scorpio, white sheep accounted for more than

　　

Buyer's hobby is available on the details page. To improve the conversion rate. For example, when we see a sports group, I can add sports elements to the details page, or send some sporting goods.

　　

Different levels of buyers will have different characteristics, such as novice buyers, they may not look at sales, do not understand the evaluation, do not understand the DSR, as long as you can show in front of him, he felt good on the list, and even will not pay. I prefer novice buyers, as long as we can patiently teach him to pay for shopping, with his sincere exchanges, very easy to develop into hardcore fans. In general, a high level of buyers to be smart a lot, evaluation, sales, and even look at the DSR.

This is mainly for beginners and primary buyers.

　　

Columnar is the consumption base of this word, the consumption base of linear whole net. Basically are the middle level consumption rank majority.

　　

=========================================

Next, let's look at the market segmentation

　　

Here the class of the distribution, very important, related to the keyword matching degree of the class. There is no doubt that, when searching for a home suit, the default display will not appear children's underwear such as baby.

　　

We look down, still pay attention to the statistics time, and fields. There are trends, hot selling indices and average prices. is related to the situation of the brand.

　　

Click on the start to see the relevant baby, here the style can be referred to.

　　

Next, I use the crowd filter to look at my target population. Different people, there will be differences in the selection and pricing strategy. Here I'm sifting through the sex, age, and buyer ratings I've seen before. It will be found that different crowd preferences are different.

　　

Here is the related product, the system according to the product model or category to distinguish.

　　

Here is the related attribute, the property is directly linked to the style, but also a segment of the market, so look carefully. Taobao may prefer to recommend the nature of the popularity of the baby Oh.

　　

"It is useless to look, many friends reflect that can not understand these data, each person from the data read out of the information is different, this is difficult to unify." If I want to make a low price, I see the average price, and I will know that I will have an advantage if I am priced lower than that. If I want to do midrange or above, it will be higher than this price. We should not be credulous of other people's conclusions, we must combine their own resources and ideas to understand the data. There are no shortcuts, more practice. 】

=================================

Then, to the Ali index index.1688.com/

This is the industry market, select the corresponding categories can be seen. You can see the industry is starting to get active by the end of August. Because Taobao's purchasing index is up, the part that is not filled with color is forecast for the future. Well, you have to do it quickly. It may be a slow step now. Still watch the statistical time.

The Ali index even gives a reading of the data.

1. The next one months, pajamas, household clothes, robe and bathrobe industry in the Taobao market: market demand for a small increase.

2. Buyers are advised to pay attention to the market and keep stock.

　　

This is related to the industry, may be able to expand the discovery of some business opportunities.

1. In the last 30 days in pajamas, household clothes, robe, bathrobe-related industries, adult socks in the market demand for the largest Taobao.

2. Forecast for the next one months, there is a big increase in the demand for warm tops and packaged markets. The results of the forecast only for everyone's reference, it is recommended that buyers combine their own actual situation, in the focus on the selected industry, you can focus on the warm jacket, suit.

　　

Let's take a closer look at the attribute subdivision. Here are 30 days of data. Personally feel very strong here, can give sellers reference, combined with the target group, choose products that meet the market. This can greatly reduce the risk.

Light blue bar chart represents the treasure in the rack of treasure number, the more the baby number, the greater the competition. Correspondingly, the smaller the number of babies, the less competition.

　　

　　

　　

Here I noticed that the bow knot should be a popular element.

　　

Look at the price below, Ali gives the interpretation is

1. The last 30 days, all the fabric of pajamas, household clothes, robe, bathrobe, Taobao market transactions most of the commodity price belt for >=78.1 yuan, your peers in the 1688 market purchase the most commodity prices for 31.2~46.9 yuan.

2. It is recommended that buyers control the purchasing cost according to their own situation.

Taobao deals Most is >=78.1 yuan products, this information can guide our pricing.

　　

Below see Ali ranking, this is the product list, you can choose the statistical time is 7 days or 30 days, you can also choose the transaction or flow dimension, traffic dimension is to see more people's products.

　　

This industrial base can understand the industrial distribution of various industries OH. It's also very good! It won't take much time to know what's going on in every place, and maybe you can find a lot of good industry in your place.

　　

==================================

The whole set of serious, careful study for 1-2 days, believe that the understanding of the entire market will be on the floor.

I've been told that it's no use looking at it. In fact, there is no use of sincerity is to look at themselves, data are reference, almost no 100% of data.

In fact, some of the analysis of ideas, applicable to many areas. Only now this tool is only suitable for Taobao this piece. Everything needs to be understood and digested.

Data can be said that we understand the market is the only channel to understand the market can make the corresponding decision, but it must be combined with our own decision-making.