Data processing system and method for reallocating salespersons to customers of insurance companies
By designing a data processing system, finding the recently effective insurance policies under the customer's name and calculating salesperson scores based on policy type indicators, the problem of full-time customer allocation caused by salesperson liquidity in the insurance industry is solved, and the accuracy and efficiency of allocation are improved. Improved user experience.
Patent Information
- Application Number
- CN201911132904.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2019-11-19
- Publication Date
- 2024-11-26
- Estimated Expiration
- 2039-11-19
AI Technical Summary
The liquidity of sales staff in the insurance industry is strong, which makes it difficult for full-time single customers to be assigned to suitable sales staff. The existing manual and computer allocation methods are inefficient and have low accuracy, which is affected by subjective factors and one-sided considerations.
A data processing system is designed, including data query, salesperson scoring and display devices. By finding the recently effective insurance policies under the customer's name, the on-the-job salespersons of the team to which the resigned salesperson is, and the scores of the salesperson are calculated based on the policy type indicators. , assign salesmen according to the best, determine the weights based on customer attributes, and make weight sums to assign the most suitable salesmen.
Improve the accuracy and efficiency of salesperson assignments, avoid the influence of subjective factors of manual assignments and the randomness of computer assignments, ensure that customers get the most suitable salesperson, improve user experience, and update indicators through salesperson feedback, further Improved allocation accuracy.
Smart Images

Figure CN112906998B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of computer technology, and in particular to a data processing system, method and electronic equipment for reallocating salespersons to customers of an insurance company. Background Art
[0002] In the insurance industry, when a salesperson leaves, the policies they were responsible for become dedicated policies, and the clients they were responsible for become dedicated single clients. The high turnover of salespeople in the insurance industry creates a large number of dedicated single clients. Assigning the right salesperson to these numerous dedicated single clients is a common challenge within the industry.
[0003] Currently, life insurance companies use manual or computer methods to assign sales representatives to full-time single customers.
[0004] Manual allocation is a process in which a specialist assigns a salesperson to a full-time single customer. However, manual allocation is inefficient and can easily lead to situations where the customer does not renew their insurance policy due to untimely allocation, which affects the timely follow-up of the customer's policy status. In addition, the results of manual allocation are seriously affected by the specialist's subjective factors, making it difficult to select a salesperson who is suitable for the customer's attributes for a full-time single customer.
[0005] Computer allocation is the process of assigning full-time policies to a computer. However, this current method involves searching the customer's purchase history to identify the current salesperson with the most recent effective date for the policy. If no such person exists, the team corresponding to the salesperson who recently left the company with the policy's most recent effective date is then identified. A salesperson from this team is then randomly assigned, or the salesperson with the highest total premiums for individual policies sold within a pre-set timeframe is selected. Due to the high turnover rate of sales personnel in the insurance industry, a large number of full-time customers are assigned salespeople through this method. While this method ensures the interests of the policy sales team, improves team output, and motivates team managers, it still struggles to optimally assign a salesperson with the right attributes to each full-time customer, resulting in low accuracy in allocations.
[0006] It should be noted that the information disclosed in the above background technology section is only used to enhance the understanding of the background of the present invention, and therefore may include information that does not constitute prior art known to ordinary technicians in this field. Summary of the Invention
[0007] The purpose of the embodiments of the present invention is to provide a data processing system, method and electronic device for reallocating salespersons to customers of an insurance company, so as to overcome the problems existing in the above-mentioned prior art.
[0008] According to a first aspect of an embodiment of the present invention, there is provided a data processing system for reallocating salespersons to customers of an insurance company, wherein none of the insurance policies under the name of the customer have a corresponding incumbent salesperson, and the system comprises: a data query device, a salesperson scoring device, and a display device. The data query device is used to search for the most recently effective policy among all the insurance policies under the name of the customer, determine all the incumbent salespersons in the team to which the resigned salesperson corresponding to the most recently effective policy belongs, and send the information of the determined incumbent salespersons to the salesperson scoring device; the salesperson scoring device is used to calculate the score of each determined incumbent salesperson for the attributes of the customer based on the indicators of each determined incumbent salesperson for each policy type among all policy types, and output the information of the incumbent salesperson with the highest score to be assigned to the customer; the attributes of the customer are determined according to the policy types of all the insurance policies under the name of the customer; and the display device is used to display the information of the incumbent salespersons output by the salesperson scoring device.
[0009] In the above system, the salesperson scoring device includes: a weight setting unit, which is used to set the weight of the indicator for each insurance policy type based on the attributes of the customer and send it to the calculation unit; a calculation unit, which is used to weightedly sum the indicators of each determined in-service salesperson for all insurance policy types based on the set weight of the indicator for each insurance policy type, so as to obtain the score of each determined in-service salesperson for the attributes of the customer.
[0010] In the above system, the calculation unit is used to calculate the score of each active salesperson for the customer's attribute according to the following formula:
[0011]
[0012] Among them, j indicates that the customer's attribute is the jth attribute, i indicates the i-th active salesperson among all active salespeople, Score j,i represents the score of the i-th salesperson for the j-th attribute, w j,k represents the weight of the indicator for the kth type of insurance policy when the customer's attribute is the jth type of attribute, n represents the number of all insurance policy types, a i,k Represents the indicator of the i-th active salesperson for the k-th policy type.
[0013] The above system may also include: an indicator management device for receiving processing feedback from the on-the-job salesperson on the policies of each policy type among all the policies under the customer's name, and updating the on-the-job salesperson's indicators for the corresponding policy type in response to the processing feedback.
[0014] In the above system, the policy types include: pending renewal policies, matured policies and lapsed policies; the indicators include: pending renewal policy processing capacity indicator, matured policy processing capacity indicator and lapsed policy processing capacity indicator.
[0015] The above-mentioned system may further include: a customer attribute determination device for determining the attributes of the customer based on the policy types of all insurance policies under the name of the customer. The customer attribute determination device includes: a policy type determination unit for determining the policy types of all insurance policies under the name of the customer; a customer attribute discrimination unit for determining the attributes of the customer as a renewal customer if it is determined that there are one or more policies to be renewed among all insurance policies under the name of the customer; determining the attributes of the customer as an expired customer if it is determined that there are expired policies and no policies to be renewed among all insurance policies under the name of the customer; and determining the attributes of the customer as an expired customer if it is determined that all insurance policies under the name of the customer are expired policies.
[0016] According to a second aspect of an embodiment of the present invention, there is provided a data processing method for reallocating salespersons to customers of an insurance company, wherein none of the insurance policies under the name of the customer corresponds to an incumbent salesperson, and the method comprises: a data query device searches for the most recently effective policy among all the insurance policies under the name of the customer, determines all incumbent salespersons in the team to which the resigned salesperson corresponding to the most recently effective policy belongs, and sends the information of the determined incumbent salespersons to a salesperson scoring device; the salesperson scoring device calculates the score of each determined incumbent salesperson for the attributes of the customer based on the indicators of each determined incumbent salesperson for each policy type among all policy types, and outputs the information of the incumbent salesperson with the highest score to assign to the customer; wherein the attributes of the customer are determined according to the policy types of all the insurance policies under the name of the customer; and a display device displays the information of the incumbent salespersons output by the salesperson scoring device.
[0017] In the above method, based on the determined indicators of each in-service salesperson for each policy type among all policy types, the score of each in-service salesperson for the attributes of the customer is calculated, and the information of the in-service salesperson with the highest score is output, including: setting the weight of the indicator for each policy type based on the attributes of the customer; for each determined in-service salesperson, weightedly summing the indicators of the in-service salesperson for all policy types based on the set weight of the indicator for each policy type to obtain the score of each determined in-service salesperson for the attributes of the customer.
[0018] According to a third aspect of an embodiment of the present invention, there is provided an electronic device, comprising: a processor and a memory, wherein the memory is used to store executable instructions; the processor is configured to implement, by executing the executable instructions: searching for the most recently effective policy among all insurance policies under a customer, determining all incumbent salespeople in the team to which the resigned salesperson corresponding to the most recently effective policy belongs, and sending information of the determined incumbent salespeople; calculating a score of the attributes of each determined incumbent salesperson for the customer based on an indicator of each of all policy types, and outputting information of the incumbent salesperson with the highest score to assign to the customer; wherein the attributes of the customer are determined according to the policy types of all insurance policies under the customer; and displaying the output information of the incumbent salesperson.
[0019] The technical solution provided by the embodiment of the present invention may have the following beneficial effects:
[0020] In the technical solutions provided by some embodiments of the present invention, when there is no corresponding active salesperson for all policies under the name of a customer, the most recently effective policy among all policies under the name of the customer is searched to determine all active salespeople in the team to which the departing salesperson corresponding to the most recently effective policy belonged; the customer's attributes are determined based on the policy types of all policies under the name of the customer, and based on the indicators of each determined active salesperson for each of all policy types, the scores of each determined active salesperson for the customer's attributes are calculated, and the active salesperson with the highest score is assigned to the customer; thereby, it is ensured that the active salesperson assigned to the customer is obtained after comprehensive consideration of various indicators of the active salesperson, and the problem of the existing manual specialist allocation being greatly affected by the subjective factors of the specialist can be avoided. It can also avoid the problem of the existing computer allocation when randomly selecting salespeople from the team or simply selecting the salesperson with the highest premium for the personal insurance policies sold within the recent preset time range as the corresponding salesperson, thereby improving the accuracy and efficiency of allocation. The system determines a customer's attributes based on the policy types of all their policies. Based on the metrics for each policy type, each agent's score for the customer's attributes is calculated. This allows the customer to be assigned the agent best suited to their attributes, improving the user experience. Furthermore, agents' metrics can be updated based on their feedback, further improving the accuracy of assignments.
[0021] It is to be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the invention. BRIEF DESCRIPTION OF THE DRAWINGS
[0022] The accompanying drawings are incorporated into and constitute a part of the specification, illustrate embodiments consistent with the present invention, and together with the specification, are used to explain the principles of the present invention. Obviously, the drawings described below are only some embodiments of the present invention, and those skilled in the art can derive other drawings based on these drawings without inventive effort. In the drawings:
[0023] Figure 1 A block diagram schematically illustrates a data processing system for reallocating salespersons to customers of an insurance company according to an embodiment of the present invention;
[0024] Figure 2 Schematically shows a flow chart of a data processing method for reallocating salespersons to customers of an insurance company according to one embodiment of the present invention;
[0025] Figure 3 A schematic structural diagram of a computer system suitable for implementing an electronic device according to an embodiment of the present invention is shown. DETAILED DESCRIPTION
[0026] Example embodiments will now be described more fully with reference to the accompanying drawings. However, example embodiments can be implemented in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete and will fully convey the concepts of the example embodiments to those skilled in the art.
[0027] In addition, the described features, structures or characteristics may be combined in one or more embodiments in any suitable manner. In the following description, many specific details are provided to provide a full understanding of the embodiments of the present invention. However, it will be appreciated by those skilled in the art that the technical solutions of the present invention can be practiced without one or more of the specific details, or other methods, components, devices, steps, etc. may be adopted. In other cases, known methods, devices, implementations or operations are not shown or described in detail to avoid blurring various aspects of the present invention.
[0028] The block diagrams shown in the accompanying drawings are merely functional entities and do not necessarily correspond to physically separate entities. That is, these functional entities may be implemented in software, in one or more hardware modules or integrated circuits, or in different networks and / or processor devices and / or microcontroller devices.
[0029] The flowcharts shown in the accompanying drawings are for illustrative purposes only and do not necessarily include all contents and operations / steps, nor must they be executed in the order described. For example, some operations / steps may be decomposed, while others may be combined or partially combined. Therefore, the actual execution order may vary depending on the actual situation.
[0030] Before describing the embodiments of the present invention in detail, some of the terms used in the present invention are explained as follows:
[0031] A salesperson, also known as a salesperson, refers to an insurance sales agent in the insurance industry.
[0032] A dedicated policy refers to the policy to be handed over after the salesperson who originally sold or followed up on the customer's policy leaves the company.
[0033] A full-time single customer refers to a customer to be connected after the original salesperson who connected to the customer leaves the company.
[0034] Figure 1 A block diagram of a data processing system for reallocating sales representatives to an insurance company customer, according to one embodiment of the present invention, is shown. Specifically, the system includes the following devices 101-105:
[0035] The data query device 101 is used to find the most recently effective policy among all the insurance policies under the customer's name, determine all the active salesmen in the team to which the resigned salesman corresponding to the most recently effective policy belongs, and send the information of the determined active salesmen to the salesman scoring device 102.
[0036] The salesperson scoring device 102 is used to calculate the score of each of the determined salespersons for the customer's attributes based on the indicators of each of the determined policy types for all policy types, and output the information of the salesperson with the highest score to assign to the customer; wherein the customer's attributes are determined based on the policy types of all policies under the customer's name. Policy types include but are not limited to: pending renewal policies, expired policies, and lapsed policies; indicators include but are not limited to: pending renewal policy processing capability indicators, expired policy processing capability indicators, and lapsed policy processing capability indicators. In one embodiment of the present invention, the salesperson scoring device 102 may include the following units:
[0037] - A weight setting unit, used to set the weight of the indicator for each policy type based on the customer's attributes and send it to the calculation unit.
[0038] - A calculation unit, configured to perform a weighted summation of the indicators of each determined in-service salesperson for all insurance policy types based on the weights of the indicators set for each insurance policy type, so as to obtain a score of each determined in-service salesperson for the customer's attributes.
[0039] The display device 103 is used to display the information of the on-the-job salesmen output by the salesman scoring device 102.
[0040] The index management device 104 is used to receive the processing feedback of the on-the-job salesperson on the insurance policies of each policy type in all insurance policies under the customer's name, and update the on-the-job salesperson's index for the corresponding insurance policy type in response to the processing feedback.
[0041] The customer attribute determination device 105 is used to determine the customer's attributes based on the policy types of all insurance policies under the customer's name. In one embodiment of the present invention, the customer attribute determination device 105 includes:
[0042] -Policy type determination unit, used to determine the policy types of all policies under the customer's name.
[0043] - A customer attribute identification unit, configured to identify the customer as a renewal customer if it is determined that among all the policies under the customer's name there are one or more policies to be renewed; to identify the customer as an expired customer if it is determined that among all the policies under the customer's name there are expired policies and no policies to be renewed; and to identify the customer as an expired customer if it is determined that all the policies under the customer's name are expired policies.
[0044] Based on the data processing system for reallocating salespersons to customers of an insurance company provided in the above embodiment, according to one embodiment of the present invention, a data processing method for reallocating salespersons to customers of an insurance company is also provided.
[0045] Figure 2 A flowchart of a data processing method for reallocating salespersons to customers of an insurance company according to an embodiment of the present invention is schematically shown. The execution subject of the method may be a server, a terminal device, or a combination thereof.
[0046] like Figure 2 As shown, a data processing method for reallocating salespersons to customers of an insurance company according to one embodiment of the present invention includes the following steps S210-S250. There is no corresponding salesperson for all insurance policies under the name of the customer. The following is a detailed description:
[0047] In step S210, the data query device 101 searches for the most recently effective policy among all the insurance policies under the customer's name.
[0048] In one embodiment of the present invention, searching for the most recently effective policy among all the policies under the name of a customer can be performed by selecting the most recently effective policy from all the policies under the name of the customer based on the customer's consumption records. The most recently effective policy refers to the policy with the shortest time difference between the effective date and the current time. The effective date of the policy is based on the effective date stated in the policy. For example, it is generally the day after the payment or the day after the policy receipt date. By searching for the most recently effective policy, the influence of some earlier insurance policies on the subsequent selection of salespersons can be eliminated, so that customers can be better assigned to salespersons and the user experience can be improved.
[0049] In step S220 , the data query device 101 determines all the incumbent salespeople in the team to which the resigned salesperson corresponding to the most recently effective insurance policy belongs, and sends the information of the determined incumbent salespeople to the salesperson scoring device 102 .
[0050] In one embodiment of the present invention, determining all the current salespeople in the team to which the resigned salesperson corresponding to the most recently effective insurance policy belonged can be done by obtaining the resigned salesperson corresponding to the most recently effective insurance policy, querying the team to which the resigned salesperson belonged before leaving, and determining all the current salespeople in the team to which the resigned salesperson belonged. The present invention makes good use of the blood relationship of the team by determining all the current salespeople in the team to which the resigned salesperson corresponding to the most recently effective insurance policy belonged. Since the team to which the resigned salesperson belonged before leaving is the team corresponding to the customer's most recently effective insurance policy, it can be seen that this team is the team that currently knows the customer's recent insurance policy situation best. Selecting a salesperson to connect with from this team can provide better services to customers and improve user experience.
[0051] In step S230, the salesperson scoring device 102 calculates the score of each determined salesperson for the customer's attributes based on the indicators of each determined salesperson for each policy type among all policy types, and outputs the information of the salesperson with the highest score to assign to the customer; wherein the customer's attributes are determined according to the policy types of all policies under the customer's name.
[0052] In one embodiment of the present invention, step S230 includes the following sub-steps:
[0053] Step S2301. The customer attribute determination device 105 determines the customer's attributes based on the policy types of all insurance policies under the customer's name.
[0054] According to one embodiment of the present invention, the policy type may include: one or more of: pending renewal policies, expired policies, and lapsed policies; the customer's attributes may include: one or more of: renewal customers, expired customers, and lapsed customers. Determining the customer's attributes based on the policy types of all policies under the customer's name includes: the policy type determination unit in the customer attribute determination device 105 determines the policy types of all policies under the customer's name; and the customer attribute discrimination unit in the customer attribute determination device 105 performs the following: if there are one or more pending renewal policies among all policies under the customer's name, then the customer's attributes are determined as a renewal customer; if there are expired policies among all policies under the customer's name and there are no pending renewal policies, then the customer's attributes are determined as an expired customer; if all policies under the customer's name are lapsed policies, then the customer's attributes are determined as an lapsed customer.
[0055] Step S2302. The salesperson scoring device 102 calculates the score of each determined salesperson for the customer's attributes based on the determined indicators of each insurance policy type for all insurance policy types.
[0056] In one embodiment of the present invention, the indicators may include one or more of: a pending renewal policy processing capability indicator, an expired policy processing capability indicator, and a lapsed policy processing capability indicator. In the insurance industry, the pending renewal policy processing capability indicator is also commonly referred to as a renewal bonus indicator. The expired policy processing capability indicator is also commonly referred to as a second-opening bonus indicator, where a second-opening bonus refers to issuing a policy after expiration. The lapsed policy processing capability indicator is also commonly referred to as a reinstatement bonus indicator. The pending renewal policy processing capability indicator (i.e., an indicator for active sales representatives regarding pending renewal policies) may indicate an active sales representative's ability to collect outstanding fees from renewal policies. The higher the success rate of collection for pending renewal policies handled by an active sales representative within the evaluation period used by the current indicator, the higher the active sales representative's pending renewal policy processing capability indicator. The expired policy processing capability indicator (i.e., an indicator for active sales representatives regarding expired policies) may indicate an active sales representative's ability to issue a second policy for expired policies. The higher the re-issuance rate of expired policies handled by a salesperson during the current evaluation period, the higher the salesperson's expired policy handling capability index. The lapsed policy handling capability index (i.e., the salesperson's indicator for lapsed policies) can be an indicator of the salesperson's ability to reinstate lapsed policies. The higher the reinstatement success rate of lapsed policies handled by a salesperson during the current evaluation period, the higher the salesperson's lapsed policy handling capability index.
[0057] The following describes how each indicator is calculated:
[0058] After a customer is assigned a current salesperson, all of the customer's policies will be assigned to that salesperson. This may include one or more dedicated policies among pending renewal policies, expired policies, and lapsed policies. A pending renewal policy is a dedicated policy for which premiums have been paid in installments during the insurance contract period but are currently in the mid-term renewal stage. An expired policy is a dedicated policy for which all premiums have been paid for the contract period and the contract is about to expire. An expired policy is a dedicated policy for which the contract has expired. For example, the processing capacity indicator for pending renewal policies can be that after a customer's pending renewal policies that are payable but not expired are assigned to a current salesperson, that salesperson will contact the customer to whom the policy belongs for collection. After the customer completes the collection task, the salesperson will receive feedback from the current salesperson regarding the successful collection of the pending renewal policy and remove the policy from the renewal allocation pool. The calculation of the processing capacity index of pending renewal policies can be characterized by the continuation rate. The specific calculation rule can be, for example, to divide the actual paid premium of the month due under the name of the active salesperson by the premium payable under the name of the salesperson for the month, which are the continuation rates of the previous month, the current month, and the next month respectively. Then, the continuation rates of the previous month, the current month, and the next month are multiplied by the inverse of the corresponding policy year, and the sum is averaged to obtain the processing capacity index of pending renewal policies. Since the younger the policy payment year, the easier it is for the policy to expire, the processing capacity index of pending renewal policies calculated in the above manner can take into account the impact of data with younger policy payment years on the index. For example, for the processing capacity index of expired policies, policies that have expired or are due to expire (expiring soon, for example, within one month, two months, or three months) can be regarded as expired policies. In this embodiment, the pending renewal policies that are payable but not expired under the name of the customer can be assigned to the active salesperson, and the active salesperson can then issue the second policy. Before calculating the matured policy handling capacity index, one can first determine whether the matured policy corresponding to the secondary issuance was previously assigned to the current salesperson. If so, the feedback received on the secondary issuance can be used to evaluate the matured policy handling capacity index. For example, the secondary issuance rate of matured policies handled by the current salesperson within the last one, two, or three months can be used as the matured policy handling capacity index. For example, for the lapsed policy handling capacity index, the lapsed policy under a customer's name can be assigned to the current salesperson, who then reinstates the policy. If the current salesperson successfully reinstates the policy, the customer's lapsed policy can be successfully reinstated. The feedback received on the successful reinstatement of the customer's lapsed policy can be used to evaluate the lapsed policy handling capacity index. For example, the cumulative number of reinstated policies of the current salesperson within the current month, the last one, two, or three months can be multiplied by a corresponding coefficient (e.g., an empirical value of 0.01). The coefficient can then be normalized to the minimum percentage within the same institution to obtain the lapsed policy handling capacity index.
[0059] Based on the determined indicators of each active salesperson for each policy type among all policy types, according to one embodiment of the present invention, step S2302 includes:
[0060] First, the weight setting unit in the salesperson scoring device 102 sets the weight of the indicator for each policy type based on the customer's attributes and sends it to the calculation unit in the salesperson scoring device 102. The weight of the same indicator can be set to different values according to the attributes of different customers.
[0061] In one example, refer to Table 1, which schematically shows a relationship table of on-the-job salespersons and their corresponding indicators. In this example, the first indicator can be an indicator indicating the on-the-job salesperson's ability to collect unpaid fees for renewal policies, that is, the first indicator can be an indicator of the ability to handle renewal policies. The second indicator can be an indicator indicating the on-the-job salesperson's ability to re-issue expired policies, that is, the second indicator can be an indicator of the ability to handle expired policies. The third indicator can be an indicator indicating the on-the-job salesperson's ability to reinstate expired policies, that is, the third indicator can be an indicator of the ability to handle expired policies. In the present invention, the weight of the same indicator allows different values to be set for different customer attributes, thereby assigning a on-the-job salesperson who is more suitable for the customer's attributes to the customer. For example, when a customer's customer attributes are determined to be a renewal customer, the weights of the first, second, and third indicators can be set to 0.5, 0.3, and 0.3, respectively, for the customer's attributes. For another example, when a customer's attributes are determined to be an expired customer, the weights of the first, second, and third indicators can be set to 0.3, 0.5, and 0.3, respectively. For another example, when a customer's attributes are determined to be an expired customer, the weights of the first, second, and third indicators can be set to 0.3, 0.3, and 0.5, respectively.
[0062] First indicator Second indicator The third indicator The first salesperson <![CDATA[a 1,1 ]]> <![CDATA[a 1,2 ]]> <![CDATA[a 1,3 ]]> The second salesperson <![CDATA[a 2,1 ]]> <![CDATA[a 2,2 ]]> <![CDATA[a 2,3 ]]> The third salesperson <![CDATA[a 3,1 ]]> <![CDATA[a 3,2 ]]> <![CDATA[a 3,3 ]]> …… …… …… …… The i-th active salesperson <![CDATA[a i,1 ]]> <![CDATA[a i,2 ]]> <![CDATA[a i,3 ]]> …… …… …… ……
[0063] Table 1
[0064] Next, the calculation unit in the salesperson scoring device 102 performs a weighted summation of the indicators for all policy types for each determined salesperson based on the weights set for the indicators for each policy type, to obtain a score for each determined salesperson for the customer's attributes. In one embodiment of the present invention, the score for each determined salesperson for the customer's attributes is calculated according to the following formula:
[0065]
[0066] Among them, j indicates that the customer's attribute is the jth attribute, i indicates the i-th active salesperson among all active salespeople, Score j,i represents the score of the i-th salesperson for the j-th attribute, w j,k represents the weight of the indicator for the kth type of insurance policy when the customer's attribute is the jth type of attribute, n represents the number of all insurance policy types, a i,k Represents the indicator of the i-th active salesperson for the k-th policy type.
[0067] Since the weights of various indicators can be set differently according to the attributes of different customers, customers can be assigned on-the-job salespeople who are more suitable for their attributes, thereby improving user experience.
[0068] Step S2303. The salesperson scoring device 102 outputs the information of the current salesperson with the highest score, so as to assign the current salesperson with the highest score to the customer.
[0069] After the in-service salesperson with the highest score is assigned to the customer, he or she will be responsible for or manage all insurance policies under the customer's name.
[0070] Step S240: The display device 103 displays the information of the on-the-job salespersons output by the salesperson scoring device 102.
[0071] Step S250. The indicator management device 104 updates the on-the-job salesperson's indicators for each policy type among all the insurance policies under the customer's name in response to the on-the-job salesperson's processing feedback on the insurance policies of each policy type among all the insurance policies under the customer's name.
[0072] In one embodiment of the present invention, the processing feedback of the on-the-job salesperson on the insurance policies of each policy type among all the insurance policies under the name of the customer may, for example, refer to whether the renewal of the renewal policy has been completed, whether the second issuance of the expired policy has been completed, and whether the reinstatement of the expired policy has been completed.
[0073] Updating the metrics for each active agent for the corresponding policy type based on their feedback allows the metrics to better reflect each agent's recent handling capabilities for the corresponding policy type. Furthermore, when assigning an active agent to a customer, all of the customer's policies are assigned to that agent. This is equivalent to assigning dedicated single customers at a customer-level granularity. This prevents multiple active agents from handling different policy types after a customer becomes a dedicated single customer, which could degrade the customer experience. However, each metric is evaluated at the dedicated single-policy granularity, rather than incorporating the agent's feedback on all policies for the entire customer into a single metric. This allows each metric to truly and intuitively reflect the agent's handling capabilities for the corresponding policy type. The next time an active agent is assigned to a customer, these metrics are combined to prioritize the appropriate active agent for each customer, based on their attributes determined by their policy type. This improves the accuracy and efficiency of assignments, ultimately enhancing the user experience.
[0074] In the above embodiment, if one or more policies are pending renewal among all the policies under the customer's name, the customer's attribute is determined to be a renewal customer; if there are expired policies and no policies pending renewal among all the policies under the customer's name, the customer's attribute is determined to be an expired customer; if all the policies under the customer's name are lapsed, the customer's attribute is determined to be a lapsed customer. In other embodiments, the customer's attribute can also be determined according to one of the following two methods:
[0075] Method 1: If the customer has the largest number of policies awaiting renewal among all policies under his name, the customer is determined to be a renewal customer; if the customer has the largest number of expired policies among all policies under his name, the customer is determined to be an expired customer; if the customer has the largest number of expired policies among all policies under his name, the customer is determined to be an expired customer.
[0076] Method 2: If the total premiums of the policies to be renewed are the highest among all the policies under the customer's name, the customer's attribute is determined to be a renewal customer; if the total premiums of the policies due to maturity are the highest among all the policies under the customer's name, the customer's attribute is determined to be a maturity customer; if the total premiums of the policies expired are the highest among all the policies under the customer's name, the customer's attribute is determined to be a lapsed customer.
[0077] It should be understood that, inspired by the present invention, other methods for determining customer attributes are conceivable. This document does not impose any limitations on the feasible methods for determining customer attributes based on the type of insurance policy held by the customer; this is merely an example. This technical solution can achieve at least the following beneficial technical effects: the present invention determines customer attributes based on the type of insurance policy held by the customer, combines the indicators of each in-service agent for each policy type, and selectively assigns in-service agents to customers with specific customer attributes, thereby improving the user experience.
[0078] In the above embodiment, the description is expanded based on three indicators (i.e., the processing capacity index of policies to be renewed, the processing capacity index of expired policies, and the processing capacity index of expired policies). It should be understood that with the development of the insurance industry, other policy types and indicators for the policy types may appear, or some policy types may no longer be applicable. In view of this, in a preferred embodiment, the method for reallocating salesmen to customers of an insurance company may also include: receiving a user's request, adding or deleting the corresponding policy type and / or indicators for the policy type. For example, referring to Table 2, Table 2 schematically shows another relationship table of on-the-job salesmen and their corresponding indicators. The number of indicators can be adjusted as needed. Therefore, when adding a new policy type, the present invention can add the corresponding policy type and indicators, so that the present invention can quickly adjust the policy type and indicators according to the changes in the actual business, can better connect with customers with different customer attributes, and improve the user experience.
[0079] First indicator Second indicator The third indicator …… The nth index The first salesperson <![CDATA[a 1,1 ]]> <![CDATA[a 1,2 ]]> <![CDATA[a 1,3 ]]> …… <![CDATA[a 1,n ]]> The second salesperson <![CDATA[a 2,1 ]]> <![CDATA[a 2,2 ]]> <![CDATA[a 2,3 ]]> …… <![CDATA[a 2,n ]]> The third salesperson <![CDATA[a 3,1 ]]> <![CDATA[a 3,2 ]]> <![CDATA[a 3,3 ]]> …… <![CDATA[a 3,n ]]> …… …… …… …… …… …… The i-th active salesperson <![CDATA[a i,1 ]]> <![CDATA[a i,2 ]]> <![CDATA[a i,3 ]]> …… <![CDATA[a i,n ]]> …… …… …… …… …… ……
[0080] Table 2
[0081] Reference below Figure 3 , which shows a schematic structural diagram of a computer system 300 of an electronic device suitable for implementing an embodiment of the present invention. Figure 3 The computer system 300 of the electronic device shown is only an example and should not limit the functions and scope of use of the embodiments of the present invention.
[0082] like Figure 3 As shown, the computer system 300 includes a central processing unit (CPU) 301, which can perform various appropriate actions and processes according to the program stored in the read-only memory (ROM) 302 or the program loaded from the storage unit 308 to the random access memory (RAM) 303. Various programs and data required for system operation are also stored in the RAM 303. The CPU 301, ROM 302, and RAM 303 are connected to each other via a bus 304. An input / output (I / O) interface 305 is also connected to the bus 304.
[0083] The following components are connected to the I / O interface 305: an input section 306 including a keyboard, a mouse, and the like; an output section 307 including devices such as a cathode ray tube (CRT), a liquid crystal display (LCD), and a speaker; a storage section 308 including a hard disk; and a communication section 309 including a network interface card such as a LAN card or a modem. The communication section 309 performs communication processing via a network such as the Internet. A drive 310 is also connected to the I / O interface 305 as needed. Removable media 311, such as a magnetic disk, an optical disk, a magneto-optical disk, or a semiconductor memory, is installed in the drive 310 as needed, so that computer programs read therefrom can be installed into the storage section 308 as needed.
[0084] In particular, according to an embodiment of the present invention, the process described above with reference to the flowchart can be implemented as a computer software program. For example, an embodiment of the present invention includes a computer program product comprising a computer program carried on a computer-readable medium, the computer program comprising program code for executing the method shown in the flowchart. In such an embodiment, the computer program can be downloaded and installed from a network via the communication section 309 and / or installed from a removable medium 311. When the computer program is executed by the central processing unit (CPU) 301, the above-mentioned functions defined in the system of the present application are performed.
[0085] It should be noted that the computer-readable medium described in the present invention can be a computer-readable signal medium or a computer-readable storage medium, or any combination thereof. A computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of computer-readable storage media can include, but are not limited to, an electrical connection having one or more conductors, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In the present invention, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. In the present invention, a computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. This propagated data signal can take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. A computer-readable signal medium may also be any computer-readable medium other than a computer-readable storage medium that can transmit, propagate, or transport a program for use by or in conjunction with an instruction execution system, apparatus, or device. Program code embodied on a computer-readable medium may be transmitted using any suitable medium, including but not limited to wireless, wireline, optical fiber cable, RF, or any suitable combination thereof.
[0086] The flowcharts and block diagrams in the accompanying drawings illustrate the possible implementation architecture, functions and operations of the systems, methods and computer program products according to various embodiments of the present invention. In this regard, each box in the flowchart or block diagram can represent a module, program segment, or a part of code, and the above-mentioned module, program segment, or a part of code contains one or more executable instructions for implementing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in an order different from that marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flowchart, and the combination of boxes in the block diagram or flowchart, can be implemented with a dedicated hardware-based system that performs the specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.
[0087] The units involved in the embodiments of the present invention may be implemented in software or hardware, and the units described may also be provided in a processor. In some cases, the names of these units do not limit the units themselves.
[0088] As another aspect, the present application further provides a computer-readable medium, which may be included in the electronic device described in the above embodiments, or may exist independently and not incorporated into the electronic device. The computer-readable medium carries one or more programs, and when executed by the electronic device, the electronic device implements the data processing method for reallocating sales representatives to insurance company customers as described in the above embodiments.
[0089] It should be noted that, although several modules or units of the device for action execution are mentioned in the above detailed description, this division is not mandatory. In fact, according to an embodiment of the present invention, the features and functions of two or more modules or units described above can be concretized in one module or unit. Conversely, the features and functions of one module or unit described above can be further divided into multiple modules or units to be concretized.
[0090] Through the description of the above embodiments, it is easy for those skilled in the art to understand that the example embodiments described herein can be implemented by software or by combining software with necessary hardware. Therefore, the technical solution according to the embodiments of the present invention can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (which can be a CD-ROM, a USB flash drive, a mobile hard disk, etc.) or on a network, and includes a number of instructions to enable a computing device (which can be a personal computer, a server, a touch terminal, or a network device, etc.) to execute the method according to the embodiments of the present invention.
[0091] Other embodiments of the present invention will readily occur to those skilled in the art after considering the specification and practicing the invention disclosed herein. This application is intended to cover any variations, uses, or adaptations of the present invention that follow the general principles of the invention and include common knowledge or customary techniques in the art not disclosed herein. The description and examples are to be considered as exemplary only, with the true scope and spirit of the invention being indicated by the following claims.
[0092] It should be understood that the present invention is not limited to the exact construction described above and shown in the drawings, and that various modifications and changes may be made without departing from the scope thereof. The scope of the present invention is limited only by the appended claims.
Claims
1. A data processing system for reallocating salespersons to customers of an insurance company, wherein none of the insurance policies under the name of the customer have a corresponding salesperson in service, characterized in that: The system comprises: Data query device, salesperson scoring device and display device; The data query device is used to search for the most recently effective policy among all the policies under the name of the customer, determine all the incumbent salesmen in the team to which the resigned salesman corresponding to the most recently effective policy belongs, and send the information of the determined incumbent salesmen to the salesman scoring device; The salesperson scoring device is used to calculate the score of each determined salesperson for the attribute of the customer based on the determined index of each of the determined insurance policy types, and output the information of the salesperson with the highest score to assign to the customer; wherein the attribute of the customer is determined according to the insurance policy types of all insurance policies under the name of the customer; The display device is used to display the information of the on-the-job salespersons output by the salesperson scoring device. The salesman scoring device includes: a weight setting unit, which is used to set the weight of the index for each insurance policy type based on the attributes of the customer and send it to the calculation unit; A calculation unit is used to perform weighted summation of the indicators of all insurance policy types for each determined incumbent salesperson based on the weight of the indicator set for each insurance policy type, so as to obtain a score of each determined incumbent salesperson for the attribute of the customer.
2. The system according to claim 1, characterized in that The calculation unit is used to calculate the score of each active salesperson for the attribute of the customer according to the following formula: Among them, j indicates that the customer's attribute is the jth attribute, i indicates the i-th active salesperson among all active salespeople determined, and Score j,i represents the score of the i-th salesperson for the j-th attribute, w j,k represents the weight of the indicator for the kth policy type when the customer's attribute is the jth attribute, n represents the number of all policy types, a i,k Represents the indicator of the i-th active salesperson for the k-th policy type.
3. The system according to claim 1 or 2, characterized in that: The system further comprises: The index management device is used to receive the processing feedback of the in-service salesperson on the policies of each policy type among all the policies under the customer, and update the in-service salesperson's index for the corresponding policy type in response to the processing feedback.
4. The system according to claim 1 or 2, characterized in that: The policy types include: pending renewal policies, matured policies and lapsed policies; the indicators include: pending renewal policy processing capacity indicator, matured policy processing capacity indicator and lapsed policy processing capacity indicator.
5. The system according to claim 1 or 2, characterized in that: The system further comprises: The customer attribute determination device is used to determine the attributes of the customer based on the policy types of all insurance policies under the name of the customer.
6. The system according to claim 5, characterized in that The customer attribute determination device comprises: A policy type determination unit, used to determine the policy types of all policies under the name of the customer; The customer attribute identification unit is used to determine the customer's attribute as a renewal customer when it is determined that there are one or more policies to be renewed among all the policies under the customer's name; to determine the customer's attribute as an expired customer when it is determined that there are expired policies among all the policies under the customer's name and there are no policies to be renewed; and to determine the customer's attribute as an expired customer when it is determined that all the policies under the customer's name are expired policies.
7. A data processing method for reallocating salespersons for customers of an insurance company, wherein none of the insurance policies under the name of the customer have corresponding salespersons in service, characterized in that: The method comprises: The data query device searches for the most recently effective policy among all the policies under the name of the customer, determines all the incumbent salesmen of the team to which the resigned salesman corresponding to the most recently effective policy belongs, and sends the information of the determined incumbent salesmen to the salesman scoring device; The salesperson scoring device calculates the score of each determined salesperson for the attribute of the customer based on the index of each determined salesperson for each policy type among all policy types, and outputs the information of the salesperson with the highest score to allocate to the customer, including: setting the weight of the index for each policy type based on the attribute of the customer; and for each determined salesperson, weighted summing the index of the salesperson for all policy types based on the set weight of the index for each policy type to obtain the score of each determined salesperson for the attribute of the customer; wherein the attribute of the customer is determined according to the policy types of all policies under the name of the customer; The display device displays the information of the on-the-job salesmen output by the salesmen scoring device.
8. An electronic device, characterized in that: include: A processor and a memory, wherein the memory is used to store executable instructions; the processor is configured to implement, by executing the executable instructions: Find the most recently effective policy among all the policies under the customer's name, determine all the incumbent salespersons in the team to which the resigned salesperson corresponding to the most recently effective policy belongs, and send the information of the determined incumbent salespersons; Based on the determined index of each in-service salesperson for each policy type among all policy types, the score of each in-service salesperson for the attribute of the customer is calculated, and the information of the in-service salesperson with the highest score is output to be assigned to the customer, including: setting the weight of the index for each policy type based on the attribute of the customer; and for each in-service salesperson determined, weighted summing the index of the in-service salesperson for all policy types based on the set weight of the index for each policy type to obtain the score of each in-service salesperson for the attribute of the customer; wherein the attribute of the customer is determined according to the policy types of all policies under the name of the customer; Display the information of the active salespersons.
