CN110647569A - Marketing customer label management method - Google Patents
Marketing customer label management method Download PDFInfo
- Publication number
- CN110647569A CN110647569A CN201910878870.1A CN201910878870A CN110647569A CN 110647569 A CN110647569 A CN 110647569A CN 201910878870 A CN201910878870 A CN 201910878870A CN 110647569 A CN110647569 A CN 110647569A
- Authority
- CN
- China
- Prior art keywords
- customer
- label
- client
- data
- information
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0201—Market modelling; Market analysis; Collecting market data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
Abstract
The invention relates to a marketing customer label management method, which comprises the following steps: s10, acquiring customer data; s20, storing the customer data; s30, establishing a customer database, and establishing a customer database of a relation model taking a customer number as a main key; s40, establishing a client label library; s50, label management; s60, displaying and applying the label. The beneficial effects are that: 1. a system and a complete customer database are established, so that the management of customer data is facilitated; 2. on the basis of a customer database, a customer tag library is established according to a customized customer tag and a customer tag marking rule, so that customer marking is carried out on customers based on different customer data, and power grid enterprise workers can quickly know the customers and form comprehensive images for the customers conveniently, so that accurate, quick and better service is provided for each customer; 3. the label inquiry, analysis, evaluation and push services are utilized to reasonably distribute limited resources and actively push potential demand services to customers.
Description
Technical Field
The invention relates to the technical field of label management, in particular to a marketing client label management method.
Background
With the development of technologies such as big data and intelligent power supply, a label management system needs to be established on the basis of a customer database in order to accurately market and provide better service for customers by a power grid enterprise, the label management level of the existing power grid enterprise facing the customers is still in a backward level, the management of all the customers is basically consistent, the existing power grid enterprise is free of pertinence, limited resources cannot be reasonably distributed and utilized, the requirements of different customers cannot be met, and the service level cannot be improved.
Disclosure of Invention
The invention aims to overcome the problems in the prior art and provides a marketing customer label management method.
In order to achieve the technical purpose and achieve the technical effect, the invention is realized by the following technical scheme:
a marketing customer label management method comprises the following steps:
s10, acquiring customer data including customer basic information, business work order information, electric charge recording information, channel contact record and electricity utilization information;
s20, storing client data, and storing the client data of each client in a folder named by the client number;
s30, establishing a customer database, and establishing a customer database of a relation model taking a customer number as a main key;
s40, establishing a client label library: editing a client label and a client label marking rule, marking the client label on client data in a client database according to the edited client label marking rule, and forming a client label library of a relation model taking a client number as a main key on the basis of the client database;
s50, label management: providing label inquiry, analysis, evaluation and push services based on a client label library;
s60, display application of the label: and displaying the client label according to the client label library, and providing the label application for the original service system.
Further, the types of the client tags are divided into single item tags and comprehensive tags.
Furthermore, the single label is frequently overdue payment, high load, large capacity, high voltage non-living, complaint type, telephone dislike, progress promotion type, sensitive type, seasonal outgoing, WeChat arriving person and electric vehicle owner; the comprehensive labels comprise large customers, important customers and high-value customers.
Further, the client tag labeling rule is defined by writing an SQL statement.
Further, the manner of acquiring the customer data in step S10 includes data entry, data link configuration, and ETL manner, and the customer basic information and the service order information are acquired in the data entry manner, the electricity charge record information and the channel contact record are acquired in the data link configuration manner, and the electricity consumption information is acquired in the ETL manner.
Further, in step S10, the customer basic information includes industry, age, sex, school calendar, town/country; the electricity utilization information comprises load, power restoration and power failure records; the channel contact record comprises a web hall, a short hall, WeChat, 95598 and a business hall; the electric charge record information comprises payment, account information, arrearage and an electric charge notice.
Further, in step S60, the application of displaying the label is divided into:
and (3) data display: through the combination of the label and the source data, the detailed data information and the statistical information related to the label are directly displayed through configuration;
and (4) analyzing the report form: the method comprises the following steps of performing customized development aiming at a specific service scene, and displaying the result of a label in the form of an analysis report;
data export: exporting result data of the label in a text mode through front-end operation;
a system interface: through the development of the defined interface, the data interaction with other systems is realized, and the tag data is transmitted to other systems.
The invention has the beneficial effects that: 1. a system and a complete customer database are established, so that the management of customer data is facilitated; 2. on the basis of a customer database, a customer tag library is established according to a customized customer tag and a customer tag marking rule, so that customer marking is carried out on customers based on different customer data, and power grid enterprise workers can quickly know the customers and form comprehensive images for the customers conveniently, so that accurate, quick and better service is provided for each customer; 3. the label inquiry, analysis, evaluation and pushing services are utilized to reasonably distribute limited resources and actively push potential demand services to customers, so that the overall service level is improved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
fig. 1 is a flow chart of a marketing customer tag management method in an embodiment of the present invention.
Detailed Description
The present invention will be described in detail below with reference to the accompanying drawings in conjunction with embodiments.
In the description of the present invention, it is to be understood that the terms "opening," "upper," "lower," "thickness," "top," "middle," "length," "inner," "peripheral," and the like are used in an orientation or positional relationship that is merely for convenience in describing and simplifying the description, and do not indicate or imply that the referenced component or element must have a particular orientation, be constructed and operated in a particular orientation, and thus should not be considered as limiting the present invention.
As shown in fig. 1, a marketing customer label management method includes the following steps:
s10, acquiring customer data including customer basic information, business work order information, electric charge recording information, channel contact record and electricity utilization information;
s20, storing client data, and storing the client data of each client in a folder named by the client number;
s30, establishing a customer database, and establishing a customer database of a relation model taking a customer number as a main key;
s40, establishing a client label library: editing a client label and a client label marking rule, marking the client label on client data in a client database according to the edited client label marking rule, and forming a client label library of a relation model taking a client number as a main key on the basis of the client database;
s50, label management: providing label inquiry, analysis, evaluation and push services based on a client label library;
s60, display application of the label: and displaying the client label according to the client label library, and providing the label application for the original service system.
The types of the client tags are classified into a single item tag and a comprehensive tag.
The single label is frequently overdue payment, high load, large capacity, high voltage non-living, complaint type, telephone dislike, progress promotion type, sensitive type, seasonal outgoing, WeChat arriving person and electric vehicle owner; the comprehensive labels comprise large customers, important customers and high-value customers.
The client tag labeling rule is defined by writing SQL statements.
The manner of acquiring the customer data in step S10 includes data entry, data link configuration, and ETL manner, and the customer basic information and the business order information are acquired by the data entry manner, the electricity charge record information and the channel contact record are acquired by the data link configuration, and the electricity consumption information is acquired by the ETL manner.
In step S10, the customer basic information includes industry, age, sex, school calendar, town/country; the electricity utilization information comprises load, power restoration and power failure records; the channel contact record comprises a web hall, a short hall, WeChat, 95598 and a business hall; the electric charge record information comprises payment, account information, arrearage and an electric charge notice.
In step S60, the application of the tag display is divided into:
and (3) data display: through the combination of the label and the source data, the detailed data information and the statistical information related to the label are directly displayed through configuration;
and (4) analyzing the report form: the method comprises the following steps of performing customized development aiming at a specific service scene, and displaying the result of a label in the form of an analysis report;
data export: exporting result data of the label in a text mode through front-end operation;
a system interface: through the development of the defined interface, the data interaction with other systems is realized, and the tag data is transmitted to other systems.
1. A system and a complete customer database are established, so that the management of customer data is facilitated; 2. on the basis of a customer database, a customer tag library is established according to a customized customer tag and a customer tag marking rule, so that customer marking is carried out on customers based on different customer data, and power grid enterprise workers can quickly know the customers and form comprehensive images for the customers conveniently, so that accurate, quick and better service is provided for each customer; 3. the label inquiry, analysis, evaluation and pushing services are utilized to reasonably distribute limited resources and actively push potential demand services to customers, so that the overall service level is improved.
In the description herein, references to the description of "one embodiment," "an example," "a specific example" or the like are intended to mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
The foregoing shows and describes the general principles, essential features, and advantages of the invention. 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.
Claims (7)
1. A marketing customer label management method is characterized by comprising the following steps:
s10, acquiring customer data including customer basic information, business work order information, electric charge recording information, channel contact record and electricity utilization information;
s20, storing client data, and storing the client data of each client in a folder named by the client number;
s30, establishing a customer database, and establishing a customer database of a relation model taking a customer number as a main key;
s40, establishing a client label library: editing a client label and a client label marking rule, marking the client label on client data in a client database according to the edited client label marking rule, and forming a client label library of a relation model taking a client number as a main key on the basis of the client database;
s50, label management: providing label inquiry, analysis, evaluation and push services based on a client label library;
s60, display application of the label: and displaying the client label according to the client label library, and providing the label application for the original service system.
2. The marketing customer tag management method of claim 1, wherein: the types of the client tags are divided into single tags and comprehensive tags.
3. The marketing customer tag management method of claim 2, wherein: the single label is frequently overdue payment, high load, large capacity, high voltage non-living, complaint type, telephone dislike, progress promotion type, sensitive type, seasonal outgoing, WeChat arriving person and electric vehicle owner; the comprehensive labels comprise large customers, important customers and high-value customers.
4. The marketing customer tag management method of claim 1, wherein: the client tag labeling rule is defined by writing SQL sentences.
5. The marketing customer tag management method of claim 1, wherein: the manner of acquiring the customer data in step S10 includes data entry, data link configuration, and ETL manner, and the customer basic information and the business order information are acquired by the data entry manner, the electricity charge record information and the channel contact record are acquired by the data link configuration, and the electricity consumption information is acquired by the ETL manner.
6. The marketing customer tag management method of claim 1, wherein: in step S10, the customer basic information includes industry, age, sex, school calendar, town/country; the electricity utilization information comprises load, power restoration and power failure records; the channel contact record comprises a web hall, a short hall, WeChat, 95598 and a business hall; the electric charge record information comprises payment, account information, arrearage and an electric charge notice.
7. The marketing customer tag management method of claim 1, wherein: in step S60, the application of the tag display is divided into:
and (3) data display: through the combination of the label and the source data, the detailed data information and the statistical information related to the label are directly displayed through configuration;
and (4) analyzing the report form: the method comprises the following steps of performing customized development aiming at a specific service scene, and displaying the result of a label in the form of an analysis report;
data export: exporting result data of the label in a text mode through front-end operation;
a system interface: through the development of the defined interface, the data interaction with other systems is realized, and the tag data is transmitted to other systems.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910878870.1A CN110647569A (en) | 2019-09-18 | 2019-09-18 | Marketing customer label management method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910878870.1A CN110647569A (en) | 2019-09-18 | 2019-09-18 | Marketing customer label management method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110647569A true CN110647569A (en) | 2020-01-03 |
Family
ID=69010717
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910878870.1A Pending CN110647569A (en) | 2019-09-18 | 2019-09-18 | Marketing customer label management method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110647569A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111652757A (en) * | 2020-04-22 | 2020-09-11 | 国网江苏省电力有限公司营销服务中心 | Method and device for analyzing customer behaviors in electric power business hall |
| CN111866292A (en) * | 2020-07-20 | 2020-10-30 | 普强信息技术（北京）有限公司 | Application method of customer label based on voice data |
| CN111949654A (en) * | 2020-07-20 | 2020-11-17 | 上海淇馥信息技术有限公司 | User label-based quick query method and system and electronic equipment |
| CN112365281A (en) * | 2020-10-28 | 2021-02-12 | 国网冀北电力有限公司计量中心 | Power customer service demand analysis method and device |
| CN113377833A (en) * | 2021-06-08 | 2021-09-10 | 中电福富信息科技有限公司 | Construction method of unsatisfactory service label based on telecommunication big data |
| CN112365281B (en) * | 2020-10-28 | 2024-05-14 | 国网冀北电力有限公司计量中心 | Power customer service demand analysis method and device |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106296445A (en) * | 2016-08-01 | 2017-01-04 | 国网浙江省电力公司 | A kind of power customer label construction method |
| CN108764663A (en) * | 2018-05-15 | 2018-11-06 | 广东电网有限责任公司信息中心 | A kind of power customer portrait generates the method and system of management |
-
2019
- 2019-09-18 CN CN201910878870.1A patent/CN110647569A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106296445A (en) * | 2016-08-01 | 2017-01-04 | 国网浙江省电力公司 | A kind of power customer label construction method |
| CN108764663A (en) * | 2018-05-15 | 2018-11-06 | 广东电网有限责任公司信息中心 | A kind of power customer portrait generates the method and system of management |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111652757A (en) * | 2020-04-22 | 2020-09-11 | 国网江苏省电力有限公司营销服务中心 | Method and device for analyzing customer behaviors in electric power business hall |
| CN111866292A (en) * | 2020-07-20 | 2020-10-30 | 普强信息技术（北京）有限公司 | Application method of customer label based on voice data |
| CN111949654A (en) * | 2020-07-20 | 2020-11-17 | 上海淇馥信息技术有限公司 | User label-based quick query method and system and electronic equipment |
| CN112365281A (en) * | 2020-10-28 | 2021-02-12 | 国网冀北电力有限公司计量中心 | Power customer service demand analysis method and device |
| CN112365281B (en) * | 2020-10-28 | 2024-05-14 | 国网冀北电力有限公司计量中心 | Power customer service demand analysis method and device |
| CN113377833A (en) * | 2021-06-08 | 2021-09-10 | 中电福富信息科技有限公司 | Construction method of unsatisfactory service label based on telecommunication big data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110647569A (en) | Marketing customer label management method | |
| US7457807B2 (en) | Data migration and analysis | |
| CN111915366B (en) | User portrait construction method, device, computer equipment and storage medium | |
| Ishaya et al. | A service oriented approach to Business Intelligence in Telecoms industry | |
| US20070157229A1 (en) | Analytic advertising system and method of employing the same | |
| CN108257025B (en) | Orphan's declaration form distribution method and device | |
| CN110689385A (en) | Power customer service user portrait construction method based on knowledge graph | |
| US20060178928A1 (en) | Innovation capture system | |
| CN111708589B (en) | Information processing system, method, device and readable storage medium | |
| CN110147286B (en) | Custom information sending method, device and system based on message queue and recording medium | |
| CN109325850A (en) | Consumer finance reference management platform system | |
| CN112100181A (en) | Data resource management method based on sand table | |
| Boyle | Using CRM software effectively | |
| CN114187014A (en) | Marketing customer label management system and management method based on electric power field | |
| CN114218291A (en) | Portrait generation method, apparatus, device and storage medium based on target object | |
| TW200530881A (en) | Resume management system, method, and computer-readable medium | |
| CN107767156A (en) | A kind of information input method, apparatus and system | |
| CN107580305B (en) | Customer member purity analysis method and system | |
| Ali et al. | An application tool to support the implementation of integrated software process improvement for Malaysia's SME | |
| CN111815453B (en) | Electric power transaction operation system | |
| Limsarun et al. | The Different Perspective of Managerial and Operational Level toward Customer Relationship Management Practice in Thailand | |
| JP3976500B2 (en) | Reception support system | |
| CN108960763A (en) | A kind of multiple task management of calendar mode and allocating method | |
| Habjan et al. | Achieving business process change with improved business intelligence systems: A case of Slovenian company | |
| Xu et al. | Analysis on Impact of Marketing Dynamic Capabilities' Against the Value of Stakeholders-A Case Study Based on Huawei1 |
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 |