200 Places 3000 posts Forum trend analysis

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

Through the collection of local community forum data for half a month, in order to understand the local forum all over the country presents what characteristics, what is the difference and the same, perhaps they will contact the forum in the future so first do some basic data analysis, so according to different places to develop different implementation plan.

Collect these data when I first consider to hao123 360 of the navigation station in the local forum classification to find, and then in the country by provincial classification of the cities are recorded with Notepad, and then through the City + forum These keywords in Baidu to search, Basically the top one or two will almost meet the daily volume and network promotion is also in place in the forum. This collection will soon be able to collect these forums, I am a collection of one to save one in the network favorites, you can use 360 of the favorites, to see personal hobbies bar; I am a collection side filter to meet my requirements of the Forum recorded in the Excel table. Basically, I've read the forums I've collected, some are also registered to understand the situation inside, the overall use of DZ forum accounted for the vast majority, into the forum can see which section of the forum issued more of the inside of the post is fixed some people in the refund is a natural post more, This can judge the membership authenticity of this forum and so on. Also can see this forum which section most popular, the most topic, can see the member in which section active judge this forum to what crowd mainly, so in put advertisement and weak text What can be targeted.

The Forum table of 3000 posts in provinces and cities

Forum table with 3000 posts in provinces and cities (Figure 1)

Provincial and Municipal Forum popularity chart

Provincial and Municipal Forum popularity chart (Figure 2)

From the statement and popularity chart can be seen, the national local Forum is generally based on developed regions and network developed areas of the forum both quantity and quality are relatively high. Geographically, the whole country is better than the West, the south is greater than the north of the general distribution, the main center of gravity in the south of the Forum in the operation of the better, this point from the Forum's daily posts, the total number of posts, as well as members and online number of people have more quality can be seen, there are forums to hang the number of ads and quality can also be seen.

Plate classification Table

Plate classification Table (Figure 3)

Trend Chart of plate classification

Plate Classification Trend Chart (Figure 4)

From the forum to see the words, basic all the forum to local topics, local food, buildings, tourism and other aspects of the content is relatively rich, and there are many forums have friends this piece, but also very hot, from these content can also be seen, The active population of the national forum is probably the number of people aged between 20 and 35, and have the habit of training follow-up people, including the forum also set up a number of game sections, and so on, playing games are 10 years old to 25 years old students for more, and even some forum recruitment section is very successful.

If you look at the ads from the local forum, can also see the region's regional economic model, we take Guangzhou as an example, Guangzhou forum ads to cars, clothing, food, medical, games and so on for many, and then see the Forum-related sections, etc. are also related to the relatively fiery; I think this is because Guangzhou's automobile industry is more developed, including the gathering area of clothing, Cantonese food can be found in Guangzhou, medical care is the most developed places in Guangdong Province, the number of hospitals are countless numbers are not clear how many, and Guangzhou is the most students place, so the combination of ads to see the type of advertising is consistent.

One of the common features of these forums is that they are all based on local topics, entertainment irrigation, food, wedding photography, second-hand information, recruitment and so on, mainly white-collar workers; the difference is that each region's industry and local customs and other related to the appearance of a little bit different, this with the local economic situation and the main pillar industry is different.

But maybe my statistical direction and my collection method is relatively simple, the data should be collected is not complete, but I personally think that the search by this way is the user's direct feeling to do, then can use such a simple way to need to the forum, in the promotion is also done in place, Other in such a way is not collected, but also a promotion is not in place performance bar. In the collection at the same time, I also counted the Baidu included Baidu Snapshot and Google's collection of the situation, mainly to see their optimization in the general situation, a little understanding of the next, did not completely put the entire site optimization analysis. Outside the chain, PR these data I did not go to statistics, because I am not the main analysis of these.

Finally, I think my data statistical analysis of the logic of a single bar, I was also the first time to do data analysis, I think there are a lot of factors I did not consider, after slowly accumulate it, through this analysis, I know that I still have a lot of analysis of the logic is not comprehensive. Everyone can give me some advice and guidance, I improved in one by one.