Customer information processing method and device based on introduction conversion
By using the introduction relationship rating algorithm and data model in the insurance industry, the problem of inaccurate ratings of new and pro-customers is solved, and the accuracy of customer matching and business efficiency are improved.
Patent Information
- Application Number
- CN202410924598.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-11
- Publication Date
- 2024-11-08
AI Technical Summary
It is difficult for the existing technology to effectively use customer rating algorithms to achieve precise hierarchical operations of new and prospective customers in the insurance industry, resulting in poor customer matching results.
By receiving customer rating calculation instructions, determining the introduction relationship and querying the pre-set configuration table, obtaining the rating correspondence between the introduction relationship, creating a temporary table, calculating the identity level results of the introduction rating, and combining algorithms such as logistic regression models and decision trees. , generate a new customer data model that matches the customer characteristics of the insurance industry and realizes customer level rating.
It has achieved accurate ratings for new and prospective customers, improved customer matching effect, and enhanced the operating efficiency and customer satisfaction of insurance companies.
Smart Images

Figure CN118917950A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of computer technology, and in particular to a customer information processing method based on referral, a customer information processing device based on referral, a computer device and a storage medium. Background Art
[0002] Develop a customer rating algorithm based on referrals, use the introducer's level, the social relationship between the introducer and the referrer, and the new customers and prospective customers' insurance policy value and financial management concepts and other attributes to score and rate, and combine with the customer data model to form the customer level of new customers and prospective customers, so as to achieve the company's graded management of new customers and prospective customers, better match the insurance protection needs of new customers and prospective customers, achieve better operating results, and bring a steady stream of fresh water to the company's operations. The innovation of this algorithm is that the level that new customers and prospective customers can obtain is strongly related to the introducer, which is consistent with the operating characteristics of the insurance industry. The insurance industry belongs to the financial industry with higher requirements for customer quality. The introducer's customer level has a large difference in weight on the level that the new customers and prospective customers introduced by him can obtain. Summary of the invention
[0003] In view of the above problems, embodiments of the present invention are proposed to provide a customer information processing method based on referral, a customer information processing apparatus based on referral, a computer device and a storage medium that overcome the above problems or at least partially solve the above problems.
[0004] In order to solve the above problems, an embodiment of the present invention discloses a method for processing customer information based on referral, comprising:
[0005] Upon receiving a customer rating calculation instruction, determining the referral relationship and searching for the corresponding referral relationship rating correspondence in a pre-set main configuration table, and determining the premise for the referral relationship rating correspondence;
[0006] Using the premise of the referral relationship rating correspondence as a keyword, a subquery is performed on the pre-set secondary configuration table to obtain valid information for the algorithm, create a temporary table, and then store the referral rating algorithm and the valid information and other valid information entered by the front end in the temporary table in the form of rows and columns;
[0007] The referral rating algorithm and the above-mentioned valid information are read from the temporary table, and the identity level result of the referral rating is calculated.
[0008] Preferably, the main configuration table mainly records the correspondence between the referral relationship and the gender rating algorithm, and the sub-configuration table mainly records the specific attribute information of the referral relationship.
[0009] Preferably, the temporary table includes a main configuration table and a sub-configuration table, and the related contents of the main configuration table and the sub-configuration table are associated and stored in the temporary table in a row-to-column manner.
[0010] Preferably, the method further comprises:
[0011] Based on the basic information, insurance information, business trajectory information, and settlement information of existing customers, descriptive statistical analysis is performed, and data cleaning is performed to improve data quality; a logistic regression model is used for learning to generate a feasibility analysis report; a combination model of decision tree and logistic regression and a combination model of random forest and logistic regression are used for training and verification, and parameters are tuned to above the stable threshold to generate a new customer data model that matches the customer characteristics of the insurance industry, and apply customer rating in the new customer operation stage.
[0012] Preferably, the method further comprises:
[0013] By preprocessing, standardizing, and discretizing the basic information, insurance information, business track information, and clearing information of existing customers, the correlation of multiple feature variables is measured, the features with low correlation are eliminated, and the correlation between indicators is analyzed to obtain accuracy and feasibility analysis reports;
[0014] First, use the decision tree to check the impact of each indicator on the model, select the indicators that have a greater impact on the model, and use these indicators to make predictions; then divide the data set into a training set and a test set according to the principle of a 7:3 ratio of positive and negative samples. The training set is used to train the model, and the test set is used to test and evaluate the model. The effect of the model is checked through the evaluation report. Finally, the feature screening is carried out and brought into the logistic regression model to obtain the accuracy and evaluation report;
[0015] The model is tested and evaluated through random forest, and the features are screened and brought into the logistic regression model to obtain the accuracy and evaluation report.
[0016] The embodiment of the present invention discloses a client information processing device based on referral, comprising:
[0017] A determination module, for determining the referral relationship upon receiving a customer rating calculation instruction, and querying the corresponding referral relationship rating correspondence in a pre-set main configuration table, and determining the premise of the referral relationship rating correspondence;
[0018] A creation module is used to perform a sub-query on a preset secondary configuration table using the premise of the referral rating correspondence as a keyword, obtain valid information for the algorithm, create a temporary table, and then store the referral rating algorithm and the valid information and other valid information entered by the front end in the temporary table in the form of rows and columns;
[0019] The calculation module is used to read the referral rating algorithm and valid information from the temporary table and calculate the identity level result of the referral rating.
[0020] Preferably, the main configuration table mainly records the correspondence between the referral relationship and the gender rating algorithm, and the sub-configuration table mainly records the specific attribute information of the referral relationship.
[0021] Preferably, the temporary table includes a main configuration table and a sub-configuration table, and the related contents of the main configuration table and the sub-configuration table are associated and stored in the temporary table in a row-to-column manner.
[0022] An embodiment of the present invention discloses a computer device, including a memory and a processor, wherein the memory stores a computer program, and the processor implements the above-mentioned steps of processing customer information based on referral when executing the computer program.
[0023] The embodiment of the present invention discloses a computer-readable storage medium on which a computer program is stored. When the computer program is executed by a processor, the steps of processing customer information based on referral are implemented.
[0024] The embodiments of the present invention include the following advantages:
[0025] In the embodiment of the present invention, the system functions supporting this algorithm can be divided into two parts: the front-end and the back-end. The front-end provides the functions of customer referral and new customer entry, and the back-end is the storage of new customer and prospective customer data and the customer data model and customer rating algorithm. Field partners use the front-end functions to collect referral customers and new customer entry, and enter multiple attributes such as the social relationships of new customers and prospective customers, the value of insurance policies in the same industry, and financial management concepts. The back-end combines the customer data model that matches the characteristics of insurance industry customers and the customer rating algorithm to generate the customer's identity level, thereby providing technical support for the precise operation of this customer group. BRIEF DESCRIPTION OF THE DRAWINGS
[0026] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.
[0027] Figure 1 It is a flowchart of the steps of an embodiment of a method for processing customer information based on referral according to an embodiment of the present invention;
[0028] Figure 2 It is a structural block diagram of an embodiment of a customer information processing device based on referral according to an embodiment of the present invention;
[0029] Figure 3 The diagram is a diagram of the internal structure of a computer device according to an embodiment. DETAILED DESCRIPTION
[0030] In order to make the technical problems, technical solutions and beneficial effects solved by the embodiments of the present invention more clearly understood, the embodiments of the present invention are further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.
[0031] Reference Figure 1 , shows a flowchart of a method for processing customer information based on referral according to an embodiment of the present invention, which may specifically include the following steps:
[0032] Step 101, upon receiving a customer rating calculation instruction, determining a referral relationship and searching a preset master configuration table for a corresponding referral relationship rating correspondence relationship, and determining a prerequisite for the referral relationship rating correspondence relationship;
[0033] In the embodiment of the present invention, the method can be applied to various terminals such as tablet computers. The embodiment of the present invention does not limit the specific type of the terminal. The operating system of the terminal may include Android, Harmony OS, IOS, Windows Phone, Windows, etc., and the present invention does not impose too many restrictions on this.
[0034] When receiving a customer rating calculation instruction, determining the referral relationship and searching the corresponding referral relationship rating correspondence in a pre-set main configuration table, and determining the premise of the referral relationship rating correspondence, the referral relationship rating correspondence may be determined by a referral relationship rating algorithm;
[0035] The main configuration table mainly records the correspondence between the referral relationship and the gender rating algorithm, and the sub-configuration table mainly records the specific attribute information of the referral relationship.
[0036] Step 102, using the premise of the referral relationship rating correspondence as a keyword to perform a sub-query on the pre-set secondary configuration table, obtain valid information for the algorithm, create a temporary table, and then store the referral rating algorithm and the valid information together with other valid information entered by the front end in the temporary table in the form of rows and columns;
[0037] In the embodiment of the present invention, the temporary table includes a main configuration table and a secondary configuration table, and the related contents of the main configuration table and the secondary configuration table are associated and stored in the temporary table in a row-to-column manner. The main configuration table is shown in Table 1, and the secondary configuration table is shown in Table 2.
[0038] relation gender algorithm A F F1 A M F2
[0039] Table 1: Main configuration table
[0040] relation gender property Lower limit Upper limit character A F age 0 20 A F age 20 30 A F Financial management concept 0 20 Robust A F Financial management concept 20 30 Aggressive
[0041] Table 2: Secondary configuration table
[0042] The related contents of the main configuration table and the secondary configuration table are associated and stored in the temporary table in the form of rows and columns, which is convenient for query and calculation. The basic field structure of the temporary table is shown in Table 3:
[0043]
[0044] Table 3: Basic field structure of temporary list
[0045] Step 103, reading the referral rating algorithm and valid information from the temporary table, and calculating the identity level result of the referral rating.
[0046] The referral rating algorithm and valid information are read from the temporary table, and the identity level result of the referral rating is calculated.
[0047] In the embodiment of the present invention, the system functions supporting this algorithm can be divided into two parts: the front-end and the back-end. The front-end provides the functions of customer referral and new customer entry, and the back-end is the storage of new customer and prospective customer data and the customer data model and customer rating algorithm. Field partners use the front-end functions to collect referral customers and new customer entry, and enter multiple attributes such as the social relationships of new customers and prospective customers, the value of insurance policies in the same industry, and financial management concepts. The back-end combines the customer data model that matches the characteristics of insurance industry customers and the customer rating algorithm to generate the customer's identity level, thereby providing technical support for the precise operation of this customer group.
[0048] In a preferred embodiment of the embodiments of the present invention, the method also includes: performing descriptive statistical analysis based on the basic information, insurance information, business trajectory information, and settlement information of existing customers, and cleaning the data to improve data quality; using a logistic regression model for learning to generate a feasibility analysis report; using a combination model of decision tree and logistic regression and a combination model of random forest and logistic regression for training and verification, respectively, tuning parameters to above a stable threshold, generating a new customer data model that matches the customer characteristics of the insurance industry, and applying customer ratings in the new customer operation stage.
[0049] Furthermore, the method further includes: measuring the correlation of multiple characteristic variables by preprocessing, standardizing, and discretizing the basic information, insurance information, business track information, and clearing information of existing customers, eliminating the characteristics with low correlation, and then analyzing the correlation between indicators to obtain an accuracy and feasibility analysis report;
[0050] First, use the decision tree to check the impact of each indicator on the model, select the indicators that have a greater impact on the model, and use these indicators to make predictions; then divide the data set into a training set and a test set according to the principle of a 7:3 ratio of positive and negative samples. The training set is used to train the model, and the test set is used to test and evaluate the model. The effect of the model is checked through the evaluation report. Finally, the feature screening is performed and brought into the logistic regression model to obtain the accuracy and evaluation report.
[0051] The model is tested and evaluated through random forest, and the features are screened and brought into the logistic regression model to obtain the accuracy and evaluation report.
[0052] It should be noted that, for the sake of simplicity, the method embodiments are described as a series of action combinations, but those skilled in the art should be aware that the embodiments of the present invention are not limited by the order of the actions described, because according to the embodiments of the present invention, certain steps can be performed in other orders or simultaneously. Secondly, those skilled in the art should also be aware that the embodiments described in the specification are all preferred embodiments, and the actions involved are not necessarily required by the embodiments of the present invention.
[0053] Reference Figure 2 , shows a structural block diagram of an embodiment of a customer information processing device based on referral according to an embodiment of the present invention, which may specifically include the following modules:
[0054] The determination module 301 is used to determine the referral relationship and query the corresponding referral relationship rating correspondence in the pre-set main configuration table when receiving the customer rating calculation instruction, and determine the premise of the referral relationship rating correspondence;
[0055] A creation module 302 is used to perform a sub-query on a preset secondary configuration table using the premise of the referral rating correspondence as a keyword, obtain valid information for the algorithm, create a temporary table, and then store the referral rating algorithm and the valid information and other valid information entered by the front end in the temporary table in the form of rows and columns;
[0056] The calculation module 303 is used to read the referral rating algorithm and valid information from the temporary table, and calculate the identity level result of the referral rating.
[0057] Preferably, the main configuration table mainly records the correspondence between the referral relationship and the gender rating algorithm, and the sub-configuration table mainly records the specific attribute information of the referral relationship.
[0058] Preferably, the temporary table includes a main configuration table and a sub-configuration table, and the related contents of the main configuration table and the sub-configuration table are associated and stored in the temporary table in a row-to-column manner.
[0059] Preferably, the device further comprises:
[0060] The learning module is used to conduct descriptive statistical analysis based on the basic information, insurance information, business trajectory information, and liquidation information of existing customers, and to clean the data to improve data quality; use the logistic regression model for learning and generate a feasibility analysis report; use the combination model of decision tree and logistic regression and the combination model of random forest and logistic regression for training and verification, optimize the parameters to above the stable threshold, generate a new customer data model that matches the customer characteristics of the insurance industry, and apply customer ratings in the new customer operation stage.
[0061] Preferably, the device further comprises:
[0062] The analysis module is used to measure the correlation of multiple feature variables by preprocessing, standardizing, and discretizing the basic information, insurance information, business track information, and clearing information of existing customers, eliminating features with low correlation, and then analyzing the correlation between indicators to obtain accuracy and feasibility analysis reports;
[0063] The prediction module is used to view the influence of each indicator on the model through the decision tree, select the indicators that have a greater impact on the model, and use these indicators for prediction; then the data set is divided into a training set and a test set according to the principle of a positive and negative sample ratio of 7:3. The training set is used to train the model, and the test set is used to test and evaluate the model. The effect of the model is checked through the evaluation report. Finally, the feature screening is carried out and the logistic regression model is introduced to obtain the accuracy and evaluation report.
[0064] The evaluation report acquisition module is used to test and evaluate the model through random forest, and bring the feature screening into the logistic regression model to obtain the accuracy and evaluation report.
[0065] Each module in the above-mentioned client information processing device based on referral can be implemented in whole or in part by software, hardware or a combination thereof. Each module can be embedded in or independent of a processor in a computer device in the form of hardware, or can be stored in a memory in a computer device in the form of software, so that the processor can call and execute the operations corresponding to each module.
[0066] The above-mentioned customer information processing device based on referral can be used to execute the customer information processing method based on referral provided in any of the above-mentioned embodiments, and has corresponding functions and beneficial effects.
[0067] In one embodiment, a computer device is provided. The computer device may include a servo-control integrated device, and its internal structure diagram may be as follows: Figure 3As shown. The computer device includes a processor, a memory, a network interface, a display screen and an input device connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a customer information processing method based on referral is implemented. The display screen of the computer device can be a liquid crystal display screen or an LED (light emitting diode) display screen, and the input device of the computer device can be a touch layer covering the display screen, or a key, trackball or touchpad set on the computer device housing, or an external keyboard, touchpad or mouse, etc.
[0068] Those skilled in the art will understand that Figure 3 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.
[0069] In one embodiment, a computer device is provided, including a memory and a processor, wherein a computer program is stored in the memory, and when the processor executes the computer program, the following steps are implemented:
[0070] Upon receiving a customer rating calculation instruction, determining the referral relationship and searching for the corresponding referral relationship rating correspondence in a pre-set main configuration table, and determining the premise for the referral relationship rating correspondence;
[0071] Using the premise of the referral relationship rating correspondence as a keyword, a subquery is performed on the pre-set secondary configuration table to obtain valid information for the algorithm, create a temporary table, and then store the referral rating algorithm and the valid information and other valid information entered by the front end in the temporary table in the form of rows and columns;
[0072] The referral rating algorithm and the above-mentioned valid information are read from the temporary table, and the identity level result of the referral rating is calculated.
[0073] In a preferred embodiment, the processor implements the following steps when executing the computer program:
[0074] Based on the basic information, insurance information, business trajectory information, and settlement information of existing customers, descriptive statistical analysis is performed, and data cleaning is performed to improve data quality; a logistic regression model is used for learning to generate a feasibility analysis report; a combination model of decision tree and logistic regression and a combination model of random forest and logistic regression are used for training and verification, and parameters are tuned to above the stable threshold to generate a new customer data model that matches the customer characteristics of the insurance industry, and apply customer rating in the new customer operation stage.
[0075] In a preferred embodiment, the processor implements the following steps when executing the computer program:
[0076] By preprocessing, standardizing, and discretizing the basic information, insurance information, business track information, and clearing information of existing customers, the correlation of multiple feature variables is measured, the features with low correlation are eliminated, and the correlation between indicators is analyzed to obtain accuracy and feasibility analysis reports;
[0077] First, use the decision tree to check the impact of each indicator on the model, select the indicators that have a greater impact on the model, and use these indicators to make predictions; then divide the data set into a training set and a test set according to the principle of a 7:3 ratio of positive and negative samples. The training set is used to train the model, and the test set is used to test and evaluate the model. The effect of the model is checked through the evaluation report. Finally, the feature screening is carried out and brought into the logistic regression model to obtain the accuracy and evaluation report;
[0078] The model is tested and evaluated through random forest, and the features are screened and brought into the logistic regression model to obtain the accuracy and evaluation report.
[0079] In one embodiment, a computer readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, the following steps are implemented:
[0080] Upon receiving a customer rating calculation instruction, determining the referral relationship and searching for the corresponding referral relationship rating correspondence in a pre-set main configuration table, and determining the premise for the referral relationship rating correspondence;
[0081] Using the premise of the referral relationship rating correspondence as a keyword, a subquery is performed on the pre-set secondary configuration table to obtain valid information for the algorithm, create a temporary table, and then store the referral rating algorithm and the valid information and other valid information entered by the front end in the temporary table in the form of rows and columns;
[0082] The referral rating algorithm and the above-mentioned valid information are read from the temporary table, and the identity level result of the referral rating is calculated.
[0083] In a preferred embodiment, the computer program implements the following steps when executed by a processor:
[0084] Based on the basic information, insurance information, business trajectory information, and settlement information of existing customers, descriptive statistical analysis is performed, and data cleaning is performed to improve data quality; a logistic regression model is used for learning to generate a feasibility analysis report; a combination model of decision tree and logistic regression and a combination model of random forest and logistic regression are used for training and verification, and parameters are tuned to above the stable threshold to generate a new customer data model that matches the customer characteristics of the insurance industry, and apply customer rating in the new customer operation stage.
[0085] In a preferred embodiment, the computer program implements the following steps when executed by a processor:
[0086] By preprocessing, standardizing, and discretizing the basic information, insurance information, business track information, and clearing information of existing customers, the correlation of multiple feature variables is measured, the features with low correlation are eliminated, and the correlation between indicators is analyzed to obtain accuracy and feasibility analysis reports;
[0087] First, use the decision tree to check the impact of each indicator on the model, select the indicators that have a greater impact on the model, and use these indicators to make predictions; then divide the data set into a training set and a test set according to the principle of a 7:3 ratio of positive and negative samples. The training set is used to train the model, and the test set is used to test and evaluate the model. The effect of the model is checked through the evaluation report. Finally, the feature screening is carried out and brought into the logistic regression model to obtain the accuracy and evaluation report;
[0088] The model is tested and evaluated through random forest, and the features are screened and brought into the logistic regression model to obtain the accuracy and evaluation report.
[0089] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the various embodiments can be referenced to each other.
[0090] It will be appreciated by those skilled in the art that the embodiments of the present invention may be provided as methods, devices, or computer program products. Therefore, the embodiments of the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the embodiments of the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program codes.
[0091] The embodiments of the present invention are described with reference to the flowcharts and / or block diagrams of the methods, terminal devices (systems), and computer program products according to the embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of the processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing terminal device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing terminal device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.
[0092] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing terminal device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce a manufactured product including an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.
[0093] These computer program instructions can also be loaded onto a computer or other programmable data processing terminal device so that a series of operating steps are executed on the computer or other programmable terminal device to produce a computer-implemented process, thereby providing instructions for executing on the computer or other programmable terminal device to implement the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.
[0094] Although the preferred embodiments of the present invention have been described, those skilled in the art may make additional changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the embodiments of the present invention.
[0095] Finally, it should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or terminal device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or terminal device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the existence of other identical elements in the process, method, article or terminal device including the elements.
[0096] The above describes in detail a customer information processing method based on referral, a customer information processing device based on referral, a computer device and a storage medium provided by the present invention. Specific examples are used herein to illustrate the principles and implementation methods of the present invention. The description of the above embodiments is only used to help understand the method of the present invention and its core idea. At the same time, for those skilled in the art, according to the idea of the present invention, there will be changes in the specific implementation methods and application scope. In summary, the content of this specification should not be understood as a limitation on the present invention.
Claims
1. A customer information processing method based on referral, characterized in that: include: Upon receiving a customer rating calculation instruction, determining the referral relationship and searching for the corresponding referral relationship rating correspondence in a pre-set main configuration table, and determining the premise for the referral relationship rating correspondence; Using the premise of the referral relationship rating correspondence as a keyword, a subquery is performed on the pre-set secondary configuration table to obtain valid information for the correspondence, create a temporary table, and then store the referral rating algorithm and the valid information and other valid information entered by the front end in the temporary table in the form of rows and columns; The referral rating algorithm and the above-mentioned valid information are read from the temporary table, and the identity level result of the referral rating is calculated.
2. The method for processing customer information based on referral according to claim 1, characterized in that: The main configuration table mainly records the correspondence between the referral relationship and the gender rating algorithm, and the sub-configuration table mainly records the specific attribute information of the referral relationship.
3. The method for processing customer information based on referral according to claim 1, characterized in that: The temporary table includes a main configuration table and a secondary configuration table. The related contents of the main configuration table and the secondary configuration table are associated and stored in the temporary table in a row-to-column manner.
4. The method for processing customer information based on referral according to claim 1, characterized in that: The method further comprises: Based on the basic information, insurance information, business trajectory information, and settlement information of existing customers, descriptive statistical analysis is performed, and data cleaning is performed to improve data quality; a logistic regression model is used for learning to generate a feasibility analysis report; a combination model of decision tree and logistic regression and a combination model of random forest and logistic regression are used for training and verification, and parameters are tuned to above the stable threshold to generate a new customer data model that matches the customer characteristics of the insurance industry, and apply customer rating in the new customer operation stage.
5. The method for processing customer information based on referral according to claim 4, characterized in that: The method further comprises: By preprocessing, standardizing, and discretizing the basic information, insurance information, business track information, and clearing information of existing customers, the correlation of multiple feature variables is measured, the features with low correlation are eliminated, and the correlation between indicators is analyzed to obtain accuracy and feasibility analysis reports; First, use the decision tree to check the impact of each indicator on the model, select the indicators that have a greater impact on the model, and use these indicators to make predictions; then divide the data set into a training set and a test set according to the principle of a 7:3 ratio of positive and negative samples. The training set is used to train the model, and the test set is used to test and evaluate the model. The effect of the model is checked through the evaluation report. Finally, the feature screening is carried out and brought into the logistic regression model to obtain the accuracy and evaluation report; The model is tested and evaluated through random forest, and the features are screened and brought into the logistic regression model to obtain the accuracy and evaluation report.
6. A customer information processing device based on referral, characterized in that: include: A determination module, for determining the referral relationship upon receiving a customer rating calculation instruction, and querying the corresponding referral relationship rating correspondence in a pre-set main configuration table, and determining the premise of the referral relationship rating correspondence; A creation module is used to perform a sub-query on a preset secondary configuration table using the premise of the referral rating correspondence as a keyword, obtain valid information for the algorithm, create a temporary table, and then store the referral rating algorithm and the valid information and other valid information entered by the front end in the temporary table in the form of rows and columns; The calculation module is used to read the referral rating algorithm and valid information from the temporary table and calculate the identity level result of the referral rating.
7. The customer information processing device based on referral according to claim 6, characterized in that: The main configuration table mainly records the correspondence between the referral relationship and the gender rating algorithm, and the sub-configuration table mainly records the specific attribute information of the referral relationship.
8. The customer information processing device based on referral according to claim 6, characterized in that: The temporary table includes a main configuration table and a secondary configuration table. The related contents of the main configuration table and the secondary configuration table are associated and stored in the temporary table in a row-to-column manner.
9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of processing customer information based on referral according to any one of claims 1 to 5 are implemented.
10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of processing customer information based on referral according to any one of claims 1 to 5 are implemented.
