阅读说明：本技术 一种基于呼叫中心的呼叫号码的流转处理方法 (Call number circulation processing method based on call center ) 是由 张勤学 颜继雄 于 2021-07-13 设计创作，主要内容包括：本发明提供一种基于呼叫中心的呼叫号码的流转处理方法,属于呼叫中心的呼叫号码流转处理技术领域,该方法使用数据库的分布式部署以及redis集群,对呼叫号码用mysql集群处理,redis集群异步查询和插入,以及梯队等级回收算法,一方面解决了话务员工作连贯性的问题,控制一个良好合适的呼叫速度,提升了话务员的工作积极性,提升了整体的号码流转效率；另一方面解决了手机号码利用率的问题,根据营销不成功中不同的情况,采取不同的算法,按梯度回收号码,隔相对应的梯度的天数后拨出,既避免了手机号码的浪费,又避免引起机主反感,增加了业务成功率。(The invention provides a call number flow processing method based on a call center, which belongs to the technical field of call number flow processing of the call center, and the method uses distributed deployment of a database and a redis cluster, processes the call number by a mysql cluster, asynchronously inquires and inserts the redis cluster, and adopts a echelon grade recovery algorithm, thereby solving the problem of the work continuity of telephone operators, controlling a good and proper call speed, improving the working enthusiasm of the telephone operators and improving the integral number flow efficiency; on the other hand, the problem of the utilization rate of the mobile phone number is solved, different algorithms are adopted according to different conditions in unsuccessful marketing, the number is recycled according to the gradient and is dialed out after days of the corresponding gradient, the waste of the mobile phone number is avoided, the discomfort of the owner is avoided, and the success rate of the service is increased.)

1. A method for processing the circulation of calling numbers based on a calling center is characterized in that: the method mainly has the technical points of a management method and a cooperative work flow of the mysql cluster and the redis cluster, and specifically comprises the following steps:

s1, building a mysql cluster according to the mysql official document inodb cluster;

s2, building a redis cluster according to the redis official document;

s3, managing the mysql cluster by using the mycat, and dividing the mysql cluster into a statistical library, a query library and a main library;

s4, uniformly distributing the database on a redis cluster by using a hash algorithm;

s5, comparing the numbers called out on the same day by using a timer at the time zero every day, extracting the numbers which are not called, putting the numbers into a call queue again, and calling again the next day; and for unsuccessful marketing, putting the calling queue corresponding to different days according to different marketing results and different services.

2. The call center-based call number circulation processing method according to claim 1, wherein: the statistical library and the master library in the S3 synchronize data with each other, and the query library synchronizes data of the master library.

3. The call center-based call number circulation processing method according to claim 1, wherein: and in the S5, dividing the mobile phone numbers which are communicated but have unsuccessful marketing into a plurality of grades according to the refused content of the owner, recovering the mobile phone numbers according to different grades, and calling after separating different days according to the grades.

Technical Field

The invention relates to the technical field of call number circulation processing of a call center, in particular to a call number circulation processing method based on the call center.

Background

At present, a call center on the market dials a user telephone, and has several problems:

1. the company is good and difficult to obtain the mobile phone number, if the call is unsuccessful or the marketing effect is not achieved, the number is wasted, and the cost is increased;

the efficiency of the capsule-carrying calling number is that the conventional circulation process of the general number of the call center is long, so that the condition that no number can be called frequently occurs or the condition that the call is frequent and the telephone operator is unworthy occurs.

Disclosure of Invention

The invention provides a call number circulation processing method based on a call center, aiming at solving the problems of the number utilization rate of the call center, the number calling efficiency and the like.

In order to achieve the purpose, the invention adopts the technical scheme that:

a method for processing circulation of calling numbers based on a calling center mainly technically features that a management method and a cooperative workflow of mysql cluster and redis cluster are specifically divided into the following steps:

s1, building a mysql cluster according to the mysql official document inodb cluster;

s2, building a redis cluster according to the redis official document;

s3, managing the mysql cluster by using the mycat, and dividing the mysql cluster into a statistical library, a query library and a main library;

s4, uniformly distributing the database on a redis cluster by using a hash algorithm;

s5, comparing the numbers called out on the same day by using a timer at the time zero every day, extracting the numbers which are not called, putting the numbers into a call queue again, and calling again the next day; and for unsuccessful marketing, putting the calling queue corresponding to different days according to different marketing results and different services.

Preferably, the statistical library and the master library in S3 synchronize data with each other, and the query library synchronizes data of the master library.

Preferably, in S5, the mobile phone number that has been connected but failed in marketing is classified into multiple grades according to the owner rejection content, recovered according to the different grades of the echelon, and then called after different days according to the echelon.

Compared with the prior art, the invention has the following beneficial effects: the distributed deployment of the database and the redis cluster are used, firstly, the mysql is distributed and deployed based on the performance consideration of the mysql under large data volume, and the mycat management is used, so that the number circulation speed is greatly accelerated; secondly, under the requirements on the timeliness of the submitting speed of the calling and the final marketing result and the consideration of the pressure of a database server, the redis cluster is used as cache storage before the mobile phone number is stored in the database, the numbers which are not connected and have no marketing success and are stored in the database are recovered according to a recovery algorithm, and the number circulation processing problem is well solved by the asynchronous number processing method.

Drawings

Fig. 1 is a schematic diagram illustrating a flow of processing for transferring a call number of a call center according to the present invention.

Detailed Description

In order to make the technical problems, technical solutions and advantages solved by the present invention more apparent, the present invention will be further described in detail with reference to the accompanying drawings and embodiments, and it is obvious that the described embodiments are some, but not all embodiments of the present invention. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.

Example 1:

as shown in fig. 1, the present invention provides a call number circulation processing method based on a call center, the method mainly has the technical points of a management method and a cooperative workflow of a mysql cluster and a redis cluster, and the specific steps are as follows:

s1, building a mysql cluster according to the mysql official document inodb cluster;

s2, building a redis cluster according to the redis official document;

s3, managing the mysql cluster by using the mycat, and dividing the mysql cluster into a statistical library, a query library and a main library;

s4, uniformly distributing the database on a redis cluster by using a hash algorithm;

s5, comparing the numbers called out on the same day by using a timer at the time zero every day, extracting the numbers which are not called, putting the numbers into a call queue again, and calling again the next day; and for unsuccessful marketing, putting the calling queue corresponding to different days according to different marketing results and different services.

The method includes that collected numbers are registered in an excel table, the table is led into a redis cluster, backup numbers are led into a mysql cluster, the mycat is used for managing the mysql cluster, the mycat is divided into a statistical library, an inquiry library, a main library, the mutual synchronous data of the statistical library and the main library, the data of the main library are synchronized by the inquiry library, the database is evenly distributed on the redis cluster through a hash algorithm to be called, if the database is not connected, the owner does not see the database, the owner can directly hang up the phone, but the phone is not suitable for being called again immediately, and therefore the strategy of recovering the numbers at night and calling again on the next day is adopted; and for the mobile phone number which is connected but failed in marketing, dividing into A, B, C three levels according to owner refusing content and refusing attitude, wherein A belongs to explication reason refusing by politeness, B belongs to refusing without reason, C belongs to directly refusing without hearing the content, respectively carrying out echelon recovery according to the three levels, and calling after different days of the echelon, wherein the A level interval is 1 day, the B level interval is 3 days, and the C level interval is 5-7 days.

The foregoing shows and describes the general principles and broad features of the present invention and advantages thereof. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are described in the specification and illustrated only to illustrate the principle of the present invention, but that various changes and modifications may be made therein without departing from the spirit and scope of the present invention, which fall within the scope of the invention as claimed. The scope of the invention is defined by the appended claims and equivalents thereof.