It's a model that everyone can get started with, whether you're in operations, sales, finance, marketing, etc. The RFM model is a very versatile business model with a set of scientific theories. This is a tutorial I spent five hours (really write to the collapse, fortunately I stayed down, to share with you the actual hands-on dry goods) data source to prepare only four fields: customer name, date of transaction, the number of transactions / frequency, transaction amount. If you happen to have such a data source at hand may wish to try to do this model. The following three pages are an introduction to what is RFM, followed by all the hands-on tutorials, Tableau and Excel general operation, I guarantee that you look at it can immediately get started. How to analyze the user's basic attributes through the order data, the user's orders have a dining address, through the statistics for the dining address, we can query the distribution of users under different combinations of conditions, and even know that like to seek a dish where the user is. As a simple example, the figure below shows the distribution of users of ordinary Coke and Diet Coke. Similar user data mining can also be used to do more refined analysis based on the composition of reordering, cross-platform usage of reordering users, and gender composition. It is worth noting that the difference between data platforms is still quite large, in addition to cross-platform analysis also needs to be divided into platforms for comparison, which is conducive to making different marketing strategies for different platforms. The above basic user attributes are still not enough for refined operation. Because this information can not help you solve the following four problems -

1. Who is my important value customers, what are their characteristics.

2. Who are the customers I need to focus on keeping in touch with and what are their characteristics.

3. Who are my key development customers and what are their characteristics.

4. Who are my key retention clients and what are their characteristics. To answer this question, we need to use higher-order analytic models to uncover valid information. How to RFM model, for the user sub-groups, to achieve the refinement of the operation RFM model is a widely used customer relationship analysis model, the main user behavior to distinguish between customers, RFM are: R = Recency last consumption F = Frequency consumption frequency M = Monetary consumption amount need to understand in detail the definition of the above three indicators, you can go to the poke Duo Niang, textbook RFM differentiation, will be the dimensions of the subdivided out of 5, so that it can be subdivided into 5x5x5 = 125 categories of users, and then according to the precise marketing of each type of user.