In the previous article, I analyzed and introduced the main module composition of a set of member center applet, aiming to make everyone realize the module distribution and properly explain how to operate a set of member center applet. In this article, I will mainly analyze and explain the data statistics of small programs.
1. Member data
After a variety of offline consumers register and bind to become members through small programs, all dimension data of members (some dimension data can be uploaded by users at their own choice), including but not limited to the name, birthday, gender, location of members, will be persisted to the database table. In this way, the most basic and important data module – member information is formed in the data warehouse.
Secondly, remember in the last article I mentioned that offline users can scan qr codes or search wechat public account? Through this way, we can collect the relevant information of fans, including but not limited to wechat nickname, UNIONID, wechat registered city, attention time, and so on. In this way, the data warehouse of fans has also been established.
2. Integral data
Each member has his own set of detailed points data. Here are the credits of members, the revenue and expenditure of credits, and the types of credits.
When members use points to exchange gifts, there will be a point exchange record. In the exchange process, a data warehouse of member orders will be set up with the order as the center.
3. Other data
With members as the target group and small programs as the entry platform, the role of the database will be to carry out 360° portrait of members, and make full use of the data dimensions of regional dimension, consumption power dimension, consumption direction, participation and activity, small program sharing willingness, product evaluation and feedback, to distinguish different member groups. Products suitable for different groups of members are introduced, and the conversion rate of offline purchases is promoted by means of holidays and celebrations.
This analysis concludes that a set of small program play can not simply stay on the surface, in the atmosphere of big data environment, really use the data, give full play to the value of data can reflect the value of small program. Applet is not “small”!