CN113766071A - Call number circulation processing method based on call center - Google Patents
Call number circulation processing method based on call center Download PDFInfo
- Publication number
- CN113766071A CN113766071A CN202110790978.2A CN202110790978A CN113766071A CN 113766071 A CN113766071 A CN 113766071A CN 202110790978 A CN202110790978 A CN 202110790978A CN 113766071 A CN113766071 A CN 113766071A
- Authority
- CN
- China
- Prior art keywords
- cluster
- call
- library
- calling
- numbers
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04M—TELEPHONIC COMMUNICATION
- H04M3/00—Automatic or semi-automatic exchanges
- H04M3/42—Systems providing special services or facilities to subscribers
- H04M3/50—Centralised arrangements for answering calls; Centralised arrangements for recording messages for absent or busy subscribers ; Centralised arrangements for recording messages
- H04M3/51—Centralised call answering arrangements requiring operator intervention, e.g. call or contact centers for telemarketing
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/10—Protocols in which an application is distributed across nodes in the network
- H04L67/1095—Replication or mirroring of data, e.g. scheduling or transport for data synchronisation between network nodes
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04M—TELEPHONIC COMMUNICATION
- H04M3/00—Automatic or semi-automatic exchanges
- H04M3/42—Systems providing special services or facilities to subscribers
- H04M3/50—Centralised arrangements for answering calls; Centralised arrangements for recording messages for absent or busy subscribers ; Centralised arrangements for recording messages
- H04M3/51—Centralised call answering arrangements requiring operator intervention, e.g. call or contact centers for telemarketing
- H04M3/5175—Call or contact centers supervision arrangements
Landscapes
- Engineering & Computer Science (AREA)
- Signal Processing (AREA)
- Business, Economics & Management (AREA)
- Marketing (AREA)
- Computer Networks & Wireless Communication (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
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.
Description
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.
Claims (3)
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.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110790978.2A CN113766071A (en) | 2021-07-13 | 2021-07-13 | Call number circulation processing method based on call center |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110790978.2A CN113766071A (en) | 2021-07-13 | 2021-07-13 | Call number circulation processing method based on call center |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113766071A true CN113766071A (en) | 2021-12-07 |
Family
ID=78787628
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110790978.2A Pending CN113766071A (en) | 2021-07-13 | 2021-07-13 | Call number circulation processing method based on call center |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113766071A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5594791A (en) * | 1994-10-05 | 1997-01-14 | Inventions, Inc. | Method and apparatus for providing result-oriented customer service |
| CN109246321A (en) * | 2018-07-27 | 2019-01-18 | 平安科技（深圳）有限公司 | Call management-control method, system, computer equipment and its storage medium |
| CN111522880A (en) * | 2020-04-24 | 2020-08-11 | 桂林电子科技大学 | Method for improving data read-write performance based on mysql database cluster |
| WO2022208537A1 (en) * | 2021-03-27 | 2022-10-06 | Kumar Nangia Rajender | Method and system for providing smart calling platform |
-
2021
- 2021-07-13 CN CN202110790978.2A patent/CN113766071A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5594791A (en) * | 1994-10-05 | 1997-01-14 | Inventions, Inc. | Method and apparatus for providing result-oriented customer service |
| CN109246321A (en) * | 2018-07-27 | 2019-01-18 | 平安科技（深圳）有限公司 | Call management-control method, system, computer equipment and its storage medium |
| CN111522880A (en) * | 2020-04-24 | 2020-08-11 | 桂林电子科技大学 | Method for improving data read-write performance based on mysql database cluster |
| WO2022208537A1 (en) * | 2021-03-27 | 2022-10-06 | Kumar Nangia Rajender | Method and system for providing smart calling platform |
Non-Patent Citations (1)
| Title |
|---|
| 皮皮虾家的毛线: "客户拒绝了你下次该怎么还和客户联系", pages 1, Retrieved from the Internet <URL:https://zhidao.baidu.com/question/303432586263824004.html> * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104036001B (en) | Dynamic hotlist priority scheduling based quick data cleaning method | |
| CN101944114B (en) | Data synchronization method between memory database and physical database | |
| CN109783229A (en) | The method and device of thread resources distribution | |
| CN108804237A (en) | Data real-time statistical method, device, storage medium and electronic equipment | |
| CN104731799B (en) | Main memory DBM device | |
| CN101197694A (en) | Central statistics and processing system and method for communication system log | |
| CN106844558A (en) | Intelligent answer method and system | |
| CN101937474A (en) | Mass data query method and device | |
| CN104639775A (en) | Method and device for queuing routes in call center | |
| CN103853826B (en) | A kind of distributed performance data processing method | |
| CN106027596A (en) | Task distributing method and device | |
| CN106227782A (en) | A kind of method being inserted into data base based on multi-data source | |
| CN102546983A (en) | Call routing method and device for keeping session with the same seat | |
| CN102999525A (en) | Data-table processing method and system | |
| CN108563776A (en) | Off-line data acquisition methods and system, server and storage medium | |
| CN113766071A (en) | Call number circulation processing method based on call center | |
| CN102023899A (en) | Multithreaded data synchronization method and device | |
| CN112866025B (en) | Intelligent contract fragmentation processing method | |
| CN101094428A (en) | Statistical system and method of querying service database of intelligent network | |
| CN104378239A (en) | Rapid reliability index statistical system and method based on cluster frame | |
| CN105653654A (en) | Lucky draw qualification indexing system and method | |
| CN1567835A (en) | Distributed cluster service management system and service management method in intelligent network | |
| WO2010043138A1 (en) | Method for accessing magnanimity data of intelligent network service database and system and device thereof | |
| CN110472972A (en) | A kind of block chain storing data synchronisation snapshot method and system | |
| CN111107137B (en) | Communication data synchronization and processing method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |