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 PDF

Info

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
Application number
CN201811265035.2A
Other languages
Chinese (zh)
Inventor
丁继锋
张来卿
庞严冬
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Zhuhai Hengqin Shengda Zhaoye Technology Investment Co Ltd
Original Assignee
Zhuhai Hengqin Shengda Zhaoye Technology Investment Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Zhuhai Hengqin Shengda Zhaoye Technology Investment Co Ltd filed Critical Zhuhai Hengqin Shengda Zhaoye Technology Investment Co Ltd
Priority to CN201811265035.2A priority Critical patent/CN111105255A/en
Publication of CN111105255A publication Critical patent/CN111105255A/en
Withdrawn legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Commerce
    • G06Q30/02Marketing; Price estimation or determination; Fundraising
    • G06Q30/0201Market 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

Method for realizing store multi-channel member centralized management based on Internet platform
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.
CN201811265035.2A 2018-10-29 2018-10-29 Method for realizing store multi-channel member centralized management based on Internet platform Withdrawn CN111105255A (en)

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)

* Cited by examiner, † Cited by third party
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

Cited By (3)

* Cited by examiner, † Cited by third party
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
CN112613917B (en) Information pushing method, device, equipment and storage medium based on user portrait
JP6263634B2 (en) Method and system for managing community information
US10579589B2 (en) Data filtering
CN107133323A (en) Data model construction method, the implementation method of government affairs service business and device
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
US20220215129A1 (en) Information processing apparatus, information processing method and program
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
CN114942971A (en) Extraction method and device of structured data
JP2017146633A (en) Proposal assistance method, proposal assistance system, and program
CN113139835A (en) Data processing method, data processing device, nonvolatile storage medium and processor
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
CN115204978A (en) Multi-platform data processing method and device, electronic equipment and storage medium
EP3591481B1 (en) Device configuration management apparatus, system, and program
CN114997912A (en) Rights and interests issuing method, device, equipment and storage medium
JP7499597B2 (en) Learning model construction system and method
US11954232B2 (en) Information processing system, information processing apparatus, information processing method and program
JP6716919B2 (en) INFORMATION EXTRACTION DEVICE, EXTRACTION METHOD, AND EXTRACTION PROGRAM
JP2019168760A (en) Access method estimation system, and access method estimation method

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