In the second article of my online promotion training series, "Wu Jian: Make Weibo the Ultimate, You Can Too," I mainly share my experience after completing Master Mou Changqing's first Weibo task and some tips for increasing the audience. Skills, after the article was published, it attracted the attention of many colleagues in the industry, and they also added me on QQ to communicate. During the communication process, the word "execution ability" was mentioned most often.
In fact, in that article, I also focused on the importance of execution in online promotion work, and this importance was even more profound when I completed Master Changqing’s second task of data collection and analysis. . In this article, I will also share with you my thoughts and experiences on link platform data collection and analysis.
1. Task experience
Data collection is a physically demanding task, and it is also a task that tests the perseverance of each of us. Small data contains great insights, small data verifies the meaning of execution, and small data reflects the struggle of each of us.
(1) The tortoise and the hare race, the battle is perseverance
When attending company meetings, leaders repeatedly emphasized the need to improve execution; when communicating with peers and friends, the word that appeared most frequently was execution; in the process of completing tasks, the core of the promotion method taught by Master Changqing was also execution; it can be seen that execution has already It has become one of the criteria for assessing work. In my opinion, execution ability can be roughly equal to perseverance. This is like the tortoise and the hare race. It doesn’t matter if the foundation is poor. As long as there is such courage and perseverance to work hard, the tortoise can also do it. Become the ultimate champion. This time the data collection of the link platform tested our perseverance the most, and this kind of perseverance can be measured by the time you spend. Sleeping at two or three o'clock in the morning every night has become commonplace in the past week, and it is this kind of Daily meals make me more convinced that as long as I work hard, I will succeed. The result of completing the task this time also strongly proves this famous saying of success.
(2) Pay attention to details and focus on thinking
The collection of link platforms is only one-third of the content of this task, and the next two-thirds have become the focus of competition among our 28 brothers. How to organize and analyze the data in an organized manner is also a problem we all face, because Master Changqing pays more attention to how we grasp the entry point of data analysis. It is not so much a competition of analytical skills as a competition of thinking.
What I use is reverse thinking, looking for the root of the purpose of the webmaster or promoter publishing links, pushing forward from back to front, and finally finding several major parameters for judging a link platform, and then analyzing in depth through dialectical thinking, so I organize the analysis like this The data that comes out does not have very professional vocabulary and numerical values. Ordinary webmasters and promoters without too many technical skills can clearly distinguish which platforms have high weight, which platforms publish links to find links that are suitable for them more quickly, and which platforms can It is to meet the needs other than finding friend links.
In fact, to put it bluntly, it means to put yourself in another person's shoes and look at the problem from the perspective of an ordinary webmaster. This is what we often call role reversal.
(3) In the end, success or failure depends on attitude.
I remember the first lesson after joining the evergreen preparatory student exchange group two weeks ago. I learned the importance of attitude. This is also one of the criteria for assessing whether students can become his official disciples. If execution ability can enable you to strike later , then your attitude can reflect your essence.
In my opinion, a good attitude is to treat every mission as a real thing, just like Xu Sanduo in "Soldier Assault" said, "To live well is to live meaningfully, and to live meaningfully is to live well." "Especially when a senior brother fell behind after this mission, I realized the importance of completing every mission seriously. From the beginning of the training to now, I have always believed that all this is for my own future, and I can muddle through. In the end, you will be the one who suffers. It is precisely because of this attitude that after two missions, I was temporarily ahead of the other 27 brothers with a score of 19 points. The brother who quit did not lose in execution and skills, but in Attitude. As I mentioned in the previous article, there is no magic weapon to win in online promotion. Only constant persistence, thinking, and summary can we continue to improve. Data collection integrates the three. Those who make excuses for their laziness will also lose because of laziness.
2. Experience Sharing
The reason why nearly half of this article talks about my experience of this data collection and analysis task is because I think skills and experience can be learned anywhere, but not everyone will have this kind of practical experience, even if someone has It is also very different. Of course, if you just express your thoughts without sharing your experience, it will be boring. Just like collecting and analyzing data, it is worthless if you just collect without thinking. Before sharing my experience, I will first post the results of this week's work in graphic form to share with you.
Table 1-1 (the screenshot tool cannot capture all the parameters due to too many parameters)
This link platform data mainly includes website name, address, Baidu/Google included number, Alexa ranking, PR value, website snapshot update interval, total number of platform links, link update frequency (daily update volume), Baidu (Google) keywords Ranking, user experience, these parameter values are clear and clear. You can tell at a glance which platforms are the most worthy of publishing links. So how can you compile a piece of data that benefits others and yourself? I divide it into three parts:
(1) How to collect complete and accurate data?
In fact, when collecting data, we need to pursue a "complete and refined" platform. "Complete" refers to the completeness of the data, measured by "much"; "fine" refers to the quality of the link platform, measured by "weight". In fact, the data collection methods I currently use include the following three:
1. Skillful use of keyword search: This is the method I use most when collecting platforms, that is, searching through search engines for keywords common to the required collection websites or other products. For example, my task this time is to collect link platforms, then I Directly search for the keyword "link platform" in all current search engines, and naturally more accurate search results will appear on the first 20 pages.
2. Good use of programming language "inurl": The above method is to retrieve the keywords contained in the website through search engines. However, although searching in this way can achieve the purpose of "completeness", it is difficult to achieve "fast" efficiency, so directly Baidu "inurl" The phrase ":exchange link" will retrieve websites made using this program. The specific working principle does not require too much explanation here.
3. Tricky linking platforms themselves: In addition to the above two methods, you can also quickly find forty or fifty platforms through keyword searches on the first and second-ranked platforms, and the emphasis here is on "keywords" and "ranking." "One, two", because it is a platform with very low weight and popularity, other websites in the same industry rarely hang its links on it and change links. Before collecting data, I followed the method guided by Master Changqing to rank No. 1 in the industry. On the go9go friendly link platform, I quickly found more than 40 websites that I needed through keyword search.
(2) How to organize data in an orderly manner?
The data sorting here actually refers to moving the found website data into EXCLE tables, and how to create eye-catching and clearly formatted data summary tables, and the focus is how to avoid duplicate data and reduce labor workload. The methods I use are the following two:
1. Learn to use browser favorites: Most browsers will have network favorites, especially 360 Browser, which gives me the best experience. I will "add favorites" to "network favorites" for every website I find. "Folder", which makes it convenient to use different search engines to collect data, because as long as the browser has the same keyword or domain name, it will prompt, thus avoiding a lot of duplicate data.
2. Learn to use the advanced filtering function of EXCLE: This method is more suitable for friends who are accustomed to collecting and organizing synchronization. Save all websites in EXCLE tables, and then use the advanced filtering function to directly delete duplicate data. It is simple and convenient.
(3) How to analyze interesting data?
In my opinion, the collection and organization of data is a physically demanding job, while the analysis of data tests thinking and analytical skills. Using the above two methods, you can collect and organize relatively complete data, and the following two methods will Help you make all data more accurate.
1. Role reversal, reverse thinking: In fact, I have already mentioned this in the first half of the article. This is the key point of data collection and analysis, and also the key point of the quality of the data. How to set up the weight and popularity of the website Parameters can be realized by swapping roles. What needs special attention is that its core is a data report that can be understood by ordinary webmasters and promoters and can be simplified. Careful friends can see that each of the parameters in the data analysis summary table I made is very simple, but they also directly reflect the key points of the link platform. During the analysis process, it is not analysis for the sake of analysis, but for future analysis. It can be analyzed to meet certain needs of users. This need mainly includes finding friendly links, increasing external links, creating keywords, and increasing IP.
2. Brief analysis, the icing on the cake: In fact, the reverse thinking above is more suitable for use in the process of organizing data. However, from the purpose of collecting data, this thinking also runs through the entire process. In order to make a data summary table more perfect, We need to note a brief explanation below the data, especially the crucial parameters. For example, in my data table, do I specifically explain Baidu (Google) keyword rankings, platform link daily update volume, etc., so Easier to understand.
The above experience sharing is applicable to any other data collection and analysis work, because the core content is the same. Finally, I still end this sharing with a classic statement from teacher Mou Changqing, "Do the basic work to the extreme." You can also make an interesting and high-quality data report.
Finally, friends who like my blog are welcome to leave me a message or add me on QQ (1242865272 note for experience exchange) to exchange website promotion experiences with me.
The original address of this article is Wu Jian’s website experience blog: http://www.wujianblog.com/index.php/2010/10/tuiguangjixun3/ (please keep it for reprinting)
The personal space of the author Wu Jian’s experience sharing. This article only represents the author’s views and has nothing to do with the position of Webmaster.com.