CN111105255A - Method for realizing store multi-channel member centralized management based on Internet platform - Google Patents
Method for realizing store multi-channel member centralized management based on Internet platform Download PDFInfo
- Publication number
- CN111105255A CN111105255A CN201811265035.2A CN201811265035A CN111105255A CN 111105255 A CN111105255 A CN 111105255A CN 201811265035 A CN201811265035 A CN 201811265035A CN 111105255 A CN111105255 A CN 111105255A
- Authority
- CN
- China
- Prior art keywords
- data
- channel
- members
- centralized management
- 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.)
- Withdrawn
Links
Images
Classifications
-
- 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
Landscapes
- Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Finance (AREA)
- Entrepreneurship & Innovation (AREA)
- Game Theory and Decision Science (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to the field of Internet retail industry, in particular to a method for realizing store multi-channel member centralized management based on an Internet platform. The method comprises the following steps: 1. determining and setting a member channel source; 2. collecting and independently storing member original data of each channel; 3. carrying out structural processing and summarizing on member data of each channel; 4. and inquiring the member data after the summary processing and displaying the unified management. The invention solves the problems that the information of the members in the multi-channel of the store is scattered and cannot be uniformly and centrally managed, and can be widely applied to the Internet retail industry.
Description
Technical Field
The invention relates to the field of Internet retail industry, in particular to a method for realizing store multi-channel member centralized management based on an Internet platform.
Background
Data structuring is a fundamental distinction between database systems and file systems. In a file system, data within individual files is typically structured, but there is no relationship between the files. The data structuring process is to convert the file data which is not related into the data of the database which is related with each other.
The data cleaning is to "wash out" dirty data according to a certain rule and filter the data which do not meet the requirement.
In general, channels to which store members belong are distributed sporadically, including store system members, WeChat store members, self-service e-commerce members, third-party e-commerce platform members and members in other channels, and members in various channels are distributed sporadically and have inconsistent information. The workload is large during maintenance, the operation of switching multiple platforms back and forth is complicated, and directional searching cannot be realized. The invention collects, structurizes, cleans, summarizes and uniformly manages member data of each channel, and solves the problems that member information of shops and multiple channels is scattered and cannot be uniformly and centrally managed.
Disclosure of Invention
The invention solves the technical problem of providing a method for realizing store multi-channel member centralized management based on an internet platform; the problem of store multi-channel member information distribution scattered, can't unified centralized management is solved.
The technical scheme for solving the technical problems is as follows:
the method comprises the following steps:
step one, determining and setting a member channel source;
collecting and independently storing member original data of each channel;
step three, structuring and summarizing member data of each channel;
and step four, inquiring the member data after the summary processing and displaying the unified management.
The method for realizing the centralized management of the store multi-channel members based on the Internet platform comprises the step one of determining the sources of the store member channels, wherein the sources of the store member channels comprise members generated in a POS (point of sale) cashier system of the store, WeChao mall members, self-operated e-commerce platform members, third-party e-commerce platform members (such as Taobao, Jingdong, Teddy and the like) and members of other channels.
Interface information data for reading member data of each channel, including interface address, interface login, verification information and the like, are stored in the database, and can be dynamically set and managed.
In the second step, according to the member data reading interface of each channel in the first step, the relevant data of each channel member is automatically collected through a program, and the relevant data comprises member basic information data (member account number, name, mobile phone, contact address, micro signal, identity card number, sex, registration time and the like), member consumption data (consumption time, name of purchased medicine, specification, unit, quantity, unit price, amount and the like), member point data (member account number, total points, used points, available points, exchange details and the like), member activity data (activity time, activity name, activity remark and the like), communication data (communication subject, content, time, result and the like) and member health data (member height, weight, sex, blood pressure, blood type, eyesight, medical history and the like).
The acquired original data is written into a data acquisition table of a database in a standard json character string mode, and the written data also comprises information such as data acquisition time, channel source, data category, data content and processing state. And for the operation of automatically acquiring data, the operation is regularly executed in a system task mode, and incremental member data is captured according to time nodes. For the member data which cannot be automatically acquired, the member data are manually input into the system one by one, so that the integrity of the member data is ensured.
And in the third step, the various member original data captured in the second step are subjected to structured processing and analysis, the member data of different types are stored in an independent table in an original field format after being analyzed, and key fields in the original data are selected and written into a summary table.
The member basic information summary table takes a mobile phone number or an identity card number as a main key, the same mobile phone number or the same identity card number is taken as the same member in the summary principle, newly analyzed member basic information is based on the mobile phone number or the identity card number, if the summary data exists, the member basic information is updated, otherwise, the member basic information is directly newly added, and other member auxiliary information is newly added and inserted in the auxiliary summary table in a new data mode.
And in the fourth step, the member summary information of each channel after structured processing is inquired and displayed, and unified maintenance and management are carried out. And inquiring member auxiliary information of different channel sources according to the member summary basic information, such as consumption summary data, point summary data, activity summary data, communication summary data, health summary data and the like.
And (4) performing statistical analysis on the summarized data related to all members from different channel sources, analyzing member characteristics, consumption behaviors and the like, and further mining the value of the members.
The invention solves the problems that the information of the members in the channels of the stores is scattered and can not be uniformly and centrally managed, and can effectively perform uniform management and maintenance on the members in each channel of the stores.
Drawings
The invention is further described below with reference to the accompanying drawings:
FIG. 1 is a block flow diagram of the method of the present invention.
Detailed Description
As shown in fig. 1, the present invention specifically comprises the following steps:
step one, determining and setting a member channel source;
collecting and independently storing member original data of each channel;
step three, structuring and summarizing member data of each channel;
and step four, inquiring the member data after the summary processing and displaying the unified management.
In the first step, the channel sources of the store members are determined, wherein the channel sources include members generated in a POS cashier system of the store, WeChat store members, self-operated e-commerce platform members, third-party e-commerce platform members (such as Taobao, Jingdong, Teddy and the like) and members of other channels.
Interface information data for reading member data of each channel, including interface address, interface login, verification information and the like, are stored in the database, and can be dynamically set and managed.
In the second step, according to the member data reading interface of each channel in the first step, the relevant data of the members of each channel is automatically collected through a program, and the relevant data comprises member basic information data (member account, name, mobile phone, contact address, micro signal, identity card number, sex, registration time and the like), member consumption data (consumption time, name of purchased medicine, specification, unit, quantity, unit price, amount and the like), member point data (member account, total points, used points, available points, exchange details and the like), member activity data (activity time, activity name, activity remark and the like), communication data (communication subject, content, time, result and the like) and member health data (member height, weight, sex, blood pressure, blood type, eyesight, medical history and the like).
The acquired original data is written into a data acquisition table of a database in a standard json character string mode, and the written data also comprises information such as data acquisition time, channel source, data category, data content and processing state. And for the operation of automatically acquiring data, the operation is regularly executed in a system task mode, and incremental member data is captured according to time nodes. For the member data which cannot be automatically acquired, the member data are manually input into the system one by one, so that the integrity of the member data is ensured.
And in the third step, carrying out structuralization processing and analysis on various member original data captured in the second step, storing the different types of member data in an independent table in an original field format after the different types of member data are analyzed, selecting key fields in the original data, and writing the key fields into a summary table.
The member basic information summary table takes a mobile phone number or an identity card number as a main key, the same mobile phone number or the same identity card number is taken as the same member in the summary principle, newly analyzed member basic information is based on the mobile phone number or the identity card number, if the summary data exists, the member basic information is updated, otherwise, the member basic information is directly newly added, and other member auxiliary information is newly added and inserted in the auxiliary summary table in a new data mode.
And in the fourth step, the member summary information of each channel after structured processing is inquired and displayed, and unified maintenance and management are carried out. And inquiring member auxiliary information of different channel sources according to the member summary basic information, such as consumption summary data, point summary data, activity summary data, communication summary data, health summary data and the like.
And (4) performing statistical analysis on the summarized data related to all members from different channel sources, analyzing member characteristics, consumption behaviors and the like, and further mining the value of the members.
Claims (9)
1. A method for realizing store multi-channel member centralized management based on an Internet platform is characterized by comprising the following steps: the method comprises the following steps:
step one, determining and setting a member channel source;
collecting and independently storing member original data of each channel;
step three, structuring and summarizing member data of each channel;
and step four, inquiring the member data after the summary processing and displaying the unified management.
2. The method for realizing member centralized management of shops and channels based on the internet platform as claimed in claim 1, wherein the method comprises the following steps: in the first step, the channel sources of the store members are determined, wherein the channel sources include members generated in a POS cashier system of the store, WeChat store members, self-operated e-commerce platform members, third-party e-commerce platform members (such as Taobao, Jingdong, Teddy and the like) and members of other channels.
3. The method as claimed in claim 2, wherein the database stores interface information data for reading member data of each channel, including interface address, interface login, authentication information, etc., and can be dynamically set and managed.
4. The method for realizing member centralized management of shops and channels based on the internet platform as claimed in claim 1, wherein the method comprises the following steps: in the second step, according to the member data reading interface of each channel in the first step, the relevant data of each channel member is automatically collected through a program, and the relevant data comprises member basic information data (member account number, name, mobile phone, contact address, micro signal, identity card number, sex, registration time and the like), member consumption data (consumption time, name of purchased medicine, specification, unit, quantity, unit price, amount and the like), member point data (member account number, total points, used points, available points, exchange details and the like), member activity data (activity time, activity name, activity remark and the like), communication data (communication subject, content, time, result and the like) and member health data (member height, weight, sex, blood pressure, blood type, eyesight, medical history and the like).
5. The method for realizing the centralized management of members in shops and channels based on the internet platform as claimed in claim 4, wherein the collected original data is written into a data collection table of the database in a standard json character string form, and the written data further comprises information such as data collection time, channel source, data category, data content and processing state; for the operation of automatically acquiring data, the operation is executed regularly in a system task mode, and incremental member data are captured according to time nodes; for the member data which cannot be automatically acquired, the member data are manually input into the system one by one, so that the integrity of the member data is ensured.
6. The method for realizing member centralized management of shops and channels based on the internet platform as claimed in claim 1, wherein the method comprises the following steps: and in the third step, the various member original data captured in the second step are subjected to structured processing and analysis, the member data of different types are stored in an independent table in an original field format after being analyzed, and key fields in the original data are selected and written into a summary table.
7. The method as claimed in claim 6, wherein the member basic information summary table uses a mobile phone number or an identity card number as a main key, the same mobile phone number or the same identity card number is regarded as the same member according to the summary principle, the newly analyzed member basic information is based on the mobile phone number or the identity card number, if the summary data exists, the member basic information is updated, otherwise, the member basic information is directly added, and other member auxiliary information is newly added and inserted in the auxiliary summary table in a new data form.
8. The method for realizing member centralized management of shops and channels based on the internet platform as claimed in claim 1, wherein the method comprises the following steps: in the fourth step, the member summary information of each channel after structured processing is inquired and displayed, and unified maintenance and management are carried out;
and inquiring member auxiliary information of different channel sources according to the member summary basic information, such as consumption summary data, point summary data, activity summary data, communication summary data, health summary data and the like.
9. The method as claimed in claim 8, wherein the method for implementing member centralized management in shops via multiple channels based on internet platform further comprises analyzing member characteristics, consumption behavior, etc. by statistical analysis of the summarized data related to all members from different channels, and further mining the value of members.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811265035.2A CN111105255A (en) | 2018-10-29 | 2018-10-29 | Method for realizing store multi-channel member centralized management based on Internet platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811265035.2A CN111105255A (en) | 2018-10-29 | 2018-10-29 | Method for realizing store multi-channel member centralized management based on Internet platform |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111105255A true CN111105255A (en) | 2020-05-05 |
Family
ID=70420112
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811265035.2A Withdrawn CN111105255A (en) | 2018-10-29 | 2018-10-29 | Method for realizing store multi-channel member centralized management based on Internet platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111105255A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111681039A (en) * | 2020-05-24 | 2020-09-18 | 杭州云徙科技有限公司 | Global member management application system, global member management system and method |
| CN114840113A (en) * | 2022-05-12 | 2022-08-02 | 维沃移动通信有限公司 | Application management method and device |
-
2018
- 2018-10-29 CN CN201811265035.2A patent/CN111105255A/en not_active Withdrawn
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111681039A (en) * | 2020-05-24 | 2020-09-18 | 杭州云徙科技有限公司 | Global member management application system, global member management system and method |
| CN114840113A (en) * | 2022-05-12 | 2022-08-02 | 维沃移动通信有限公司 | Application management method and device |
| CN114840113B (en) * | 2022-05-12 | 2024-04-30 | 维沃移动通信有限公司 | Application management method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109697629B (en) | Product data pushing method and device, storage medium and computer equipment | |
| CN105074724B (en) | Effective query processing is carried out using the histogram in columnar database | |
| CN112613917A (en) | Information pushing method, device and equipment based on user portrait and storage medium | |
| JP6263634B2 (en) | Method and system for managing community information | |
| US10579589B2 (en) | Data filtering | |
| CN104462167A (en) | Data analysis support system | |
| US20170053206A1 (en) | Methods and systems for identifying and prioritizing insights from hidden patterns | |
| JP2011034457A (en) | Data mining system, data mining method and data mining program | |
| CN114942971B (en) | Extraction method and device of structured data | |
| CN108073707B (en) | Financial business data updating method and device and computer readable storage medium | |
| CN111105255A (en) | Method for realizing store multi-channel member centralized management based on Internet platform | |
| CN108428138B (en) | Customer survival rate analysis device and method based on customer clustering | |
| US20220215129A1 (en) | Information processing apparatus, information processing method and program | |
| JP5771476B2 (en) | Data management system and data management method | |
| CN111506564A (en) | Remote data management method and device based on CS (circuit switched) architecture, computer equipment and storage medium | |
| CN116166820A (en) | Visualized knowledge graph generation method and device based on provider data | |
| JP2017146633A (en) | Proposal assistance method, proposal assistance system, and program | |
| CN115794545A (en) | Automatic processing method of operation and maintenance data and related equipment thereof | |
| EP3591481B1 (en) | Device configuration management apparatus, system, and program | |
| US11954232B2 (en) | Information processing system, information processing apparatus, information processing method and program | |
| JP6716919B2 (en) | INFORMATION EXTRACTION DEVICE, EXTRACTION METHOD, AND EXTRACTION PROGRAM | |
| CN113139835A (en) | Data processing method, data processing device, nonvolatile storage medium and processor | |
| JP2019168760A (en) | Access method estimation system, and access method estimation method | |
| CN112579638B (en) | Behavior tag information processing method and device, computer equipment and storage medium | |
| KR20180080924A (en) | Apparatus and method for monitoring the processing result of big data processing server |
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 | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20200505 |
|
| WW01 | Invention patent application withdrawn after publication |