JP2003288464A - Marketing data providing system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a marketing data providing system in which customer data are mutually utilized while protecting the customer data of respective companies among a plurality of the companies. <P>SOLUTION: The marketing data providing system for providing marketing data for a plurality of the companies on the basis of gathered data comprises: a customer data gathering means for gathering the customer data including the customer information of the respective companies from the customer databases of a plurality of the companies; a computer-aided name identification processing means for performing computer-aided name identification to the provided customer data; a database management means for managing the customer database containing the customer data after the computer-aided name identification is made; a general management code imparting means for imparting a unified management code to the customer data after the computer-aided name identification is made; and a utilization code imparting means for indicating a utilization section for the customer data after the computer-aided name identification is made. <P>COPYRIGHT: (C)2004,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a marketing data providing system capable of integrating and utilizing customer data among a plurality of companies, and more particularly to a marketing data providing system which also protects customer data for each company.

[0002]

2. Description of the Related Art Companies and various organizations use a database of data about these customers to keep track of daily services for customers such as various information, invoicing of bills, warranty work, and customer trends. It is used for marketing activities such as research. There are also companies that provide the information necessary for marketing to these companies. Regarding this customer data,
Due to the diversification of corporate activities and the subdivision of subsidiaries, it has become more common for multiple customers to have the same customer data within the company. In addition, the same situation will occur in situations such as cooperation and merger between companies.

However, in these situations, regarding a plurality of customer data for the same customer, for example, data such as name and address, different data expressions or descriptions are generated between the customer data, and when the customer data is used, they are the same. There has been a problem of sending multiple guides to customers.

To solve this problem, a method of registering a customer as a member in advance in the same customer database and sharing it, or as shown in JP 2001-266056 A, stores customer data. A method to be used after the name identification when integrating is being studied. In addition, JP-A-200
Like 1-325494, name-mastered data is created in advance, and orders from the same ordering party and different ordering sources are collectively processed, and the name-matched data is used at the time of processing. , Applied methods have also been studied.

[0005]

[Problems to be Solved by the Invention] However, in recent years, the business cooperation of companies and various organizations is carried out between different industries or in the same industry which is partially competitive. It is becoming more and more difficult, and it is becoming difficult to completely share customer data held by companies and organizations. In particular, in the case of companies that share the same business type or activity base, even if they have a cooperative relationship, it may be difficult to even specify a customer and share data. For this reason, it is possible to assume that the data that provides the marketing data collectively may not be sufficient, or that the data itself cannot be cooperated.

[0006] For example, when considering the housing industry as an example, a plurality of companies and contractors (construction companies, equipment contractors, contractors, etc.) are involved in the property of one house and its customers. come. Each company and trader will convert the customer information and the customer's housing and equipment information into the same customer, and register it in the customer database.
If each company or trader is in the same area, there is a competitive relationship, and it is difficult for them to use customer data as they are, and it is also difficult to provide marketing data to each company or trader.

[0007] Further, as the side providing the marketing data, when providing the marketing data to each company,
There is also a problem that a system that considers the handling of the confidentiality of the original customer data and the provision of data based on this must be premised.

The present invention has been made to solve the above problems, and the present invention relates to a marketing data providing system capable of integrating and utilizing customer data among a plurality of companies, and particularly to a customer data of each company. It is an object of the present invention to provide a marketing data providing system that enables mutual use of customer data while protecting it.

[0009]

In order to solve the above problems, according to claim 1 of the present invention, in a marketing data providing system for providing marketing data to a plurality of companies based on collected data, a customer database of a plurality of companies is used. Customer data collection means for collecting customer data including customer information of each company, Nayoro processing means for performing name identification on the provided customer data, database management means for managing a customer database including customer data after name identification, The integrated management code assigning means for assigning a unified management code to the customer data after name identification and the utilization code assigning means for indicating the utilization category for the customer data after name identification are provided. With respect to customer data owned by a plurality of companies or organizations, data regarding the same customer is identified and a uniform code is attached, so that it is possible to provide marketing data that utilizes the customer data in an integrated manner. Furthermore, by giving a usage code indicating a usage classification, it is possible to make it easier to use the customer data after the name identification, for example, to specify in advance the purpose of use of the customer data after the name identification. .

Further, in claim 2, in the customer databases of a plurality of companies, the utilization code assigning means is provided such that the utilization code is assigned to each company before the collection by the customer data collecting means. By defining the utilization classification for each company in advance, it becomes possible to provide the marketing data that matches the purpose of each company for the customer data after the name identification.

Further, in claim 3, the utilization code is a disclosure classification of customer data after name identification. Specifically, by defining the specification of disclosure contents, it is possible to provide marketing data, and at the same time, to keep secret of specific customer data. The disclosure category may be disclosure or non-disclosure on a customer database basis. In this case, it becomes possible to specify easily. It may also be set for each customer data. By setting for each customer registered in the customer database owned by each company, it is possible to utilize the personalized customer data while protecting the customer's own convenience and privacy. Further, not only the necessity of disclosure but also the disclosure target may be designated and defined. Further, disclosure of customer data may be designated for each item.
For example, it is possible to provide marketing data in consideration of the relationship between companies by setting general information such as address and name as disclosure and information such as customer purchase history as non-disclosure.

Further, in claim 4, the utilization code assigning means is a target of disclosure of the customer data after the utilization classification and the utilization code is collected by the customer data collecting means to collect customer data including customer information of each company. It was given at times. As a result, it is not necessary for each company to set in advance, and it becomes easy to set only the data about the customer for each company.

Further, in claims 5 and 6, the analyzing means is provided for analyzing the customer data after the name identification under predetermined conditions. It is possible to provide marketing data that is analyzed based on customer data that has been sorted by name. When providing the marketing data, only the analysis result by the analysis means may be provided.
In this case, while protecting the customer data of each company,
It becomes possible to provide marketing data. This is particularly effective in the case where the companies that provide the customer data cannot provide detailed mutual data.

Further, in claim 7, a reference database provided separately from the customer database and associated with the customer data after the name identification is provided. When providing marketing data based on customer data after name identification, the data in the reference database can be added and provided. Further, by including in the reference database contents that assist in performing name identification such as general-purpose address data and a name list, accurate and efficient name identification can be performed.

Further, in claim 8, a customer data collecting section for collecting customer data including customer information of each company from a client terminal provided with a plurality of companies through a communication means,
The Nayoro processing section that performs name identification on the provided customer data, the database management section that manages the customer database containing the customer data after name identification, and the integrated management code that gives a unified management code to the customer data after name identification. In addition to the assigning unit and the utilization code assigning unit indicating the utilization classification for the customer data after name identification, a marketing data providing system server for providing data in response to a request from a client terminal is provided. By performing processing on the server via communication means, not only efficient name identification and analysis processing can be performed, but also the customer data of each company is up to date in real time as compared to when it is provided offline. By obtaining and using accurate customer data after name identification, more accurate and up-to-date marketing data can be provided. The customer data after name identification may be constructed as a database integrated as an entity or may be constructed as a virtual database.

Further, in claim 9, a customer data providing unit provided in a plurality of companies for providing the customer data including the customer information of each company to the marketing data providing server via the communication means, and the marketing data. A client terminal for a marketing data providing system having a data providing requesting unit for requesting data providing via a communication means to a providing server and acquiring data according to the requested content is provided. By providing customer data from the end of each company side via communication means,
It becomes possible for the server side to obtain marketing data that has been identified and analyzed, and by meeting communication means, it is possible to update data at any time.

Further, in claim 10, based on the data acquired from the server for the marketing data providing system,
A customer data updating unit for updating the customer data of the company is provided in the client terminal for the marketing data providing system. It is possible to update the customer database owned by each company while referring to the customer data after name identification. In particular, if the customer data provided by each company is provided with some items missing, it is possible to update the customer database of each company on the server side using the customer data after name identification. If it is difficult, each company can do it.

[0018]

BEST MODE FOR CARRYING OUT THE INVENTION In order to make the contents of the present invention easier to understand, a detailed description will be given below with reference to embodiments.

[0019]

EXAMPLE FIG. 1 is a block diagram showing this embodiment.
Reference numeral 2 in the drawing is a server, and the server has 1 input device, 3 display device, and 4 data storage device. 9 is a terminal of company A, and 14 is a terminal of company B. The terminals of company A and company B are connected to the Internet 7 via a communication device. The server is connected to the Internet 7 via a communication device, and directly exchanges data with a customer database of a plurality of companies such as Company A and Company B connected to the Internet. It should be noted that although the figures show examples of company A and company B, any number of terminals of companies connected to the Internet may be used.

A procedure for integrating customer data of a plurality of companies will be described with reference to FIG. The server 2 in FIG. 1 requests the terminal of company A of 9 to transmit the customer data stored in the data storage device of company A of 11 to the server via the communication device and the Internet. The customer data is composed of one record in which customer information is stored. The server receives the record in which the customer information is stored from the data storage device of the company A together with a file indicating the meaning of individual fields constituting the record such as name, telephone number, and address, for example, an XML file. S1 in FIG.
Then, the server associates the individual fields of each received record of the company A with customer information such as name, telephone number, and address in the order of data definition of the XML file. Each record having a field associated with the meaning of this data definition is written as an intermediate file in the work database assigned to Company A in the 11 data storage device. The server performs this series of processing for all customer records of all companies that provide customer data.

In S4 of FIG. 2, the server attaches the intermediate code for the data integration work to the customer data of the intermediate file stored in the work database for each record. The customer data fields include the customer's "name", "name", "phone number", "prefecture name", "city name", "street address", etc.
For example, the code conversion is performed on this "Mr." and "Name" using the code conversion table shown in FIG.

An example of code conversion will be described with reference to FIG. The customer's name "Taro Toto" is divided into two designated fields: his "Toto" and his name "Taro". "Toto"
“Taro” is converted into name codes “d5a3d5a3” and “d1i5a3” shown by 33 in FIG. 4 according to the pseudonyms of “Toto” and “Taro” using the code conversion table of FIG.

The code conversion table of FIG. 3 shows an example of 23 hiragana notation, but the notation may be katakana or romaji, and full-width or half-width display. Well, if it is the same phonetic character, it will be converted to the same code. For this reason, the same code can be converted into the same code even if each company has a different notation method for the reading kana. This code-converted name, name code, and telephone number, and the same name and serial number in the case of the same telephone number are given, and the intermediate code “d5a3d5a3 d1i5a3 012345 shown in 39 is given.
6789 0001 ”is generated and added to the record. As a result, persons with the same surname and different names are identified by phone numbers, and serial numbers are added when there is a possibility of the same person with the same surname but the same person, so the intermediate code is always the only code for one record. Becomes

In S5 of FIG. 2, the server writes the customer record to which the intermediate code is added in the data storage device 4 managed by the server 2 in FIG. The group of records stored in this data storage device is tentatively called an integrated customer database.
After writing all customer records of all companies that have agreed to integrate the customer database into the integrated customer database, the server rearranges all records according to the order of the intermediate code in S7 of FIG.

In S8 of FIG. 2, the server collects one record having the same "name + telephone number" code among the records rearranged with the intermediate code ending in "0002" or more among all the rearranged records. And write it to the duplicate candidate list file.

In step S9 of FIG. 2, a record having the latest update date is set as a "regular" record from the set of records written in the duplication candidate list, and a code indicating "regular" is added. In step S10, the duplicate candidate record without the "regular" code is deleted, and the serial number at the end of the intermediate code of the "regular" record is changed to "0001". Extracting one "regular" record from the duplicate candidate list is called "name identification". As a result, the respective customer databases owned by a plurality of companies are integrated, and the integrated customer database of one record for each customer, in which duplicate data is removed by "name identification", is stored in the data storage device of the server.

The server assigns the utilization code of FIG. 5 to the customer data stored in the four data storage device of FIG. 1 by the above-described procedure for each field such as “Mr.”, “Name”, “Telephone number”. For example, the usage code "1" for "Mr." and "Name"
If the utilization code "0" is assigned to the customer, the customer's "Mr."
Is disclosed to the company and the "name" is disclosed only to the company that owns the customer data. At the time of the first integration processing of the customer database, all codes of "0" are given by default, but at the time of the second and subsequent updates, the utilization code inputted by each company at each terminal is given.

The server assigns a management code as a management serial number to all customer data in the integrated customer database for which the above processing has been completed.

If there is customer data changed by the customer data integration process, the server transmits the changed contents and the information of the field to the terminal of each company as update data via the Internet. The terminal of each company matches the content of the received update data with the customer data stored in its own data storage device and updates the customer data.

Note that the customer information change data input from the company A input device 8 in FIG. 1 is transmitted to the server 2 via the Internet 7 together with the serial number assigned by the server, and is assigned by the server. After updating the customer data corresponding to the serial number, the data is stored in the four data storage device. The update data may be input from the terminal of each company or from the input device of the server that manages the integrated customer database.

According to the above-described method and the like, the customer databases owned by a plurality of companies are collected via the Internet by the above-mentioned procedure and integrated into one database so that the marketing data can be provided.

For example, in the case of integrating customer data relating to housing, it is necessary to integrate customer data of a plurality of construction companies and customer data of a plurality of housing equipment manufacturers for one customer ( Construction company or housing equipment manufacturer may be affiliated companies, or they may not have a management capital relationship or have a business relationship with each other) Management and provision of marketing data are possible by installing a server in a third-party organization that manages and services the customer database of a company, a housing equipment manufacturer, or a plurality of companies.

Next, the handling of customer data, which is the source of marketing data, will be described.

A company must not disclose its own customer information from the viewpoint of personal information protection, but in the present invention, each company can see only the customer data that each company previously possessed, and that of other companies. Usage restrictions can be set on individual customer data so that customer information cannot be known. In addition to this, for the purpose of preventing unauthorized attack and information leakage to the database, the database user is individually authenticated using the ID and password. This will allow each company to participate in the integration of the customer database,
Customer information, which is the property of each company, is protected safely, is not infringed by other companies, and can be a system in which mutual customer information cannot be known.

Next, regarding the system of the present invention, provision and use of marketing data will be described.

The customer data of each company provided through the client terminal is processed as a name identification process and analyzed on the server side and is organized as marketing data. At the request of the client terminal, the customer data of each company is initially provided. Marketing data related to is provided. The marketing data provided can be used for analysis of purchase trends, analysis data itself, or the like based on the customer's address or product purchase history. For example, application to customer guidance or services is conceivable.

For example, in the form of a joint campaign or a joint event, each company can approach its customers at the same time, but based on the utilization code described above,
Direct mail, e-mail, etc. can be restricted so that they can be sent only to customers of each company. When actually sending / sending direct mail, etc., it is possible to give a sending function to the server side and restrict sending / sending based on the utilization code. Also, this may be done on the client terminal side of each company.

Further, prior to sending / sending direct mail or the like, it is confirmed that the registered customer is in the same family from the information of the telephone number or the address, and a code representing "family" is given to When the husband is registered in the customer database of the company B and the wife is registered in the customer database of the company B, the duplicate sending of the direct mail may be avoided by extracting the code that the family is the same.

In the case where direct mails, services, etc. are narrowed down based on marketing data, a direct mail destination is selected under conditions such as region, age, family structure, past product purchase record, etc. Can be analyzed and narrowed down in ways it could not find with its limited number of customer data.

Furthermore, when sending direct mail, etc.,
More effective extraction can be performed based on marketing data. For example, on the server side, individual customer data after name identification is subjected to, for example, aging simulation work, and extraction combined with data related to life events such as entrance and graduation registered in the reference database is performed. To do. By not only targeting the information at the time of registration but also by searching the server while calculating what is associated with a change in time such as aging, it is possible to extract more realistic customer data.

Further, in the reference database, the customer's living environment and data related thereto (such as sales of weather conditions in the place of residence, distance to the route, influence of exhaust gas and noise, etc.), data related to the equipment owned by the customer By registering (device configuration, device life, consumables, etc.) and filtering seasonal events due to weather changes, effects of living environment such as exhaust gas and noise, etc. Customers, etc. suitable for the planned campaign can be narrowed down. Since not only registration information but also data related to registration information is used for searching, it is possible to extract from different points of view, such as launching a soundproof construction campaign for customers along the main trunk line, or changing weather conditions by region. Can be used to strike a tailored campaign.

Next, the provision and use of marketing data when a plurality of companies have the same customer data will be described.

For example, when a plurality of companies have the same customer data, the server confirms that there are companies having duplicate customers, and narrows down the direct mail sending company to, for example, one company near the customer address. . This allows you to tailor your approach to the customer in advance. this is,
From the customer's perspective, it is possible to prevent multiple companies from sending duplicate direct mails with the same content. .

Further, the server extracts a group of customers who have the same conditions such as age and family structure based on the integrated customer database. Based on the extracted data, we will send direct mail etc. to the group. As a result, it is possible to contribute to the support of sales promotion activities of participating companies, etc., for the campaigns to be guided by direct mail.

Further, the server introduces on-site case introductions, proposals, quotations, etc. created by a third party organization, such as those which are guided by direct mail, to the company that provided the customer data via the Internet. Can be sent.

Further, if there is a home page of the company that provides the customer data, the server sends the home page introduction guidance to each customer of the integrated customer database by direct mail or e-mail to increase the number of accesses to the home page. Can be made. The home page is open to the public on the Internet, so general users who are not guided may see it. The home page of the company may be created by the company individually, or may be created by a third party managing the unified customer database on behalf of the company.

The server uses the above-mentioned home page as shown in FIG.
It is posted on the portal site on the Internet of reference number 7,
The visitor data that has accessed the site can be accumulated, and if requested, the actual data of access to the site can be transmitted to the company providing the home page. Moreover, the access record can be aggregated not only for the access record for the entire site but also for each individual home page posted on the site.

Furthermore, the server collects the construction schedule and actual date data managed by each company via the Internet, and registers it in the reference database to obtain the customer data provided by each company and name-matched. A function for performing construction management may be provided by associating.

[0049]

As described above, according to the present invention, a plurality of companies can integrate and grasp customer data collected by different channels, so that the parameter of the data can be efficiently increased. The comprehensiveness as is expanded. In addition, by integrating customer data from multiple companies, the population of the data will increase, and the age group, residential area,
The accuracy of analysis of customer trends based on the purchase history of products and services improves.

Further, by increasing the customer information in a business area of a certain company, it is possible to analyze the trends and tastes of the customer in more detail. Therefore, it is necessary to formulate and take effective measures and joint measures that cannot be done only with a single customer database of the company. For example, by integrating and analyzing customer databases of multiple companies, it is possible to propose new services and the time when the services are provided to the companies.

Further, by reflecting the results of the services performed by a plurality of companies to the customers in the integrated database,
It is possible to create more effective services.

Furthermore, by integrating customer databases of a plurality of companies, when customers purchase products or request construction from companies participating in the integrated database, accumulated points that can be used mutually can be accumulated and participation can be made. Different companies' services can be selected and customer incentives can be improved.

[Brief description of drawings]

FIG. 1 is a block diagram showing this embodiment.

FIG. 2 is an explanatory diagram of an integrated procedure of customer data of a plurality of companies in this embodiment.

FIG. 3 is an example of a code conversion table in this embodiment.

FIG. 4 is an example of code conversion in this embodiment.

[Fig. 5] Example of utilization code in this embodiment

[Explanation of symbols]

1 ... Input device, 2 ... Server, 3 ... Display device, 4 ... Data storage device, 7 ... Internet 8 ... Company A input device, 9 ... Company A terminal, 11 ... Company A data storage device, 13 ... Company B Input device, 14 ... Terminal of company B,
15 ... Data storage device of company B, 23 ... Example of Hiragana notation, 33 ... Name code, 39 ... Intermediate code shown

   ─────────────────────────────────────────────────── ─── Continued front page    (72) Inventor Hiroshi Sugiyama             2-1-1 Nakajima, Kokurakita-ku, Kitakyushu City, Fukuoka Prefecture             No. Totoki Equipment Co., Ltd. F-term (reference) 5B017 AA03 BA06 BB06

Claims (10)

[Claims] 1. A marketing data providing system for providing marketing data to a plurality of companies based on the collected data, a customer data collecting means for collecting customer data including customer information of each company from a customer database of the plurality of companies, and Nayoro processing means for performing name identification on the provided customer data, database management means for managing a customer database including the customer data after the name identification, and integration for giving a unified management code to the customer data after the name identification A marketing data providing system comprising: a management code assigning unit; and a utilization code assigning unit indicating a utilization classification for the customer data after the name identification. 2. The utilization code assigning means assigns an utilization code for each company in the customer database of the plurality of companies before the collection by the customer data collecting means. Marketing data provision system. 3. The marketing data providing system according to claim 2, wherein the utilization code is a disclosure classification of customer data after name identification. 4. The utilization code assigning means is a subject of disclosure of customer data after the utilization classification is grouped,
4. The marketing data providing system according to claim 1, wherein the utilization code is added when collecting customer data including customer information of each company by the customer data collecting means. 5. The marketing data providing system according to claim 1, further comprising analysis means for analyzing the customer data after the name identification under a predetermined condition. 6. The marketing data providing system according to claim 6, further comprising analysis result providing means for providing each company with the analysis result by the analysis means. 7. The marketing data providing system according to claim 1, further comprising a reference database provided separately from the customer database and associated with the customer data after the name identification. 8. A customer data collecting unit that collects customer data including customer information of each company from client terminals provided by a plurality of companies through communication means, and a Nayoro process for performing name identification on the provided customer data. Department, a database management unit that manages a customer database including the customer data after the name identification, an integrated management code assigning unit that assigns a unified management code to the customer data after the name identification, and the customer data after the name identification. A marketing data providing system server, which has a usage code assigning section for indicating a usage classification and provides data in response to a request from the client terminal. 9. A customer data providing unit which is provided in a plurality of companies and provides customer data including customer information of each company to the marketing data providing server via a communication means, and the marketing data providing server. Request for data via communication means,
A client terminal for a marketing data providing system, comprising a data providing requesting unit for acquiring data according to a request content. 10. The client terminal for a marketing data providing system according to claim 9, further comprising a customer data updating unit for updating customer data of the company based on the data acquired from the server for the marketing data providing system.