JP2001319125A - Processing system dedicated to sales promotion, processing method of the same system, and medium stored with program for the same system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a sales-promotion dedicated processing system which has as members retailers and stores directly contacting general private customers. SOLUTION: This system is equipped with a member master database 55, a point transaction database 56 which stores addition points for purchased articles, gift exchange points, and point histories computed while related to member IDs, an article master database 57, a gift master database 58, an input means for campaign setting, an input means for member information, a member retrieving means, a main campaign function which has a 1st process for specifying members, a 2nd process for specifying articles, a 3rd process for specifying gifts, and a 4th process for automatically calculating points through the point transaction database and is constituted by performing at least 1st to 4th processes, and a subcampaign function which performs a 5th process for extracting members by specific purposes from member information processed by the main campaign function and performs at least the 1st to 4th processes for the members extracted by the 5th process.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a processing system for exclusive use of a sales promotion which can effectively utilize members (customers) database assets, a processing method of the system, and a medium storing a program for the system, and in particular, a general individual. The present invention relates to a sales promotion dedicated processing system in which a retail store or a store directly corresponding to a customer is a member, a processing method of the system, and a medium storing a program for the system.

[0002]

2. Description of the Related Art In recent years, attention has been paid particularly to the creation of a database of members (customers), and companies are working on data construction and maintenance. However, at present, most companies do not make full use of the property of member (customer) data, or do not make use of it at all. The main reason is that even if the member (customer) data is classified into attributes, it is mainly used for information distribution (new product information, etc.), and no further use is made.

[0003] In other words, even though they are referring to marketing, they are not directly used in marketing strategies.
The result is that members (customers) database assets cannot be used effectively. Until now, the potential demand for systems aimed at leveraging member (customer) databases has been quite high, but not present.

It is known that a member (customer) database is used for so-called "campaigns" for promoting sales to be purchased, while there are various methods for effectively utilizing the member (customer) database. Currently, new members (customers)
Campaigns, such as closed campaigns that are often implemented as a way to acquire members, point incentive campaigns that are implemented to fix and activate members (customers), and referral campaigns that aim to expand sales through word-of-mouth from existing members (customers) There is. Usually, a management database is required for each campaign, and campaigns are implemented.

[0005] Generally, when conducting a campaign, there are a system corresponding service and a non-system corresponding service. Examples of system-compatible operations include maintenance of member (customer) databases, campaign announcements, input of campaign application acceptance data, input of campaign application history data, construction and distribution of order data to prize suppliers that are exchangeable values, There is construction and distribution of prize delivery instruction data, total analysis of application status, and the like.

Examples of the services other than the system include a scrutiny of campaign application reception data, a telephone inquiry window for applicants, an individual applicant inquiry confirmation from a customer representative, an application document request, application Response to status inquiry telephone report, management of inspection work staff, management of input work staff, prize inventory management, prize out-of-stock telephone correspondence, planning and production of notice prints, planning and production of simple prints such as greeting cards, thank you postcards, etc. Book creation, printed matter sending business, and the like.

[0007]

As described above, in the implementation of a campaign as a sales promotion to be purchased, an appropriate member (customer) classification for securing human resources and improving customer satisfaction is required together with an enormous amount of work. Classification of members (customers) is required.

[0008] In other words, the implementation of the campaign requires a lot of time and labor costs for preparation and operation. In addition, the operation and processing are complicated, and the planning and operation manager needs extremely specialized know-how that is built on a wealth of experience and experience. Without such specialized know-how, even planning and implementation could lead to ridiculous or major problems that would not be cost-effective.

In particular, taking the example of a manufacturer (eg, a maker or a service provider, hereinafter simply referred to as a “manufacturer”), the manufacturer often does not have a means of selling the product by itself. Usually, products and the like are sold to retail stores and sales outlets through distributors (for example, agents and wholesalers). For this reason, if a customer is a retail store or a retail store in contact with an individual who directly purchases a product, customer information (retail store or retail store, etc.) must be provided between the customer and the manufacturer without a distributor. Could not get.

According to the present invention, it is possible to directly acquire customer information of a retail store, a store, and the like without going through a distributor, and to carry out a campaign which is a sales promotion targeted for purchase (for example, a service of a manufacturer or an aviation industry, etc.). Sales) that allows the (provider) to effectively utilize the existing member (customer) database of retailers and stores that sell products and services directly to individuals, and to carry out campaigns for sales promotion targeted for purchase. It aims to provide a dedicated processing system for promotion. In other words, a system is provided in which individual loyalty to customers with high royalties is provided for the purpose of increasing customer loyalty to manufacturers and the like, and thereby dramatically increasing customer purchases and sales. In addition, running a campaign with a small number of people and running multiple campaigns simultaneously or in parallel,
The purpose is to provide a system that enables management and processing by integrating a plurality of campaigns.

Further, according to the present invention, an agency company, which is requested by a company that implements a plurality of campaigns to carry out operations related to a plurality of campaigns, performs a centralized process of a plurality of campaigns and collectively processes each of the operations. It is an object of the present invention to provide a sales promotion-dedicated processing system capable of significantly reducing the amount of sales.

Further, in the present invention, by effectively utilizing the member (customer) database, the ties with the manufacturer and the like are deepened through the support of the member (customer) in acquiring the customer in the sales promotion activities, and the member (customer) is fixed, To provide a sales promotion exclusive processing system that can centrally manage and effectively manage sales promotion stories such as differentiating royalties, and automate the operation and processing form according to the basic plan of various campaigns With the goal.

Further, according to the present invention, even a company having no know-how or experience in conducting a campaign can easily carry out the campaign, and can reduce time, personnel costs, and operating costs. It is intended to provide a dedicated processing system for promotion.

Still another object of the present invention is to provide a sales promotion exclusive processing method suitable for performing each of the above systems, and a medium storing a program for the sales promotion exclusive processing system.

[0015]

According to the sales promotion exclusive processing system according to the first aspect of the present invention, there is provided a member master database for storing member information and a purchase target value of a member existing in the master database. A value transaction database that stores the corresponding value, a value that is worth the value of the value, a result of calculating the value of the value provided and the value of the value, and the value history associated with the member master database and the member identification number; A purchase value master database in which the value-added information set is stored, a value-added master database in which value information calculated for each value provided in exchange for the value is stored, and Input means and input means for inputting the member information into a member master database A member search unit for performing the member search, and a member is specified by searching by the member search unit when the member is present in the member master database; A first process for specifying, a second process for specifying the member specified in the first process and a purchase target purchased by the member from the purchase target master database, and a correspondence to the added value owned by the member A third process for specifying a redemption value to be performed from the redemption value master database, a member specified by the first process, and a purchase object and a redemption value specified in the second and third processes. A fourth process for automatically calculating the value added and the value exchanged in the value transaction database for information; A first purchase target sales promotion function provided by performing at least the first to fourth processing; and the member information and the respective values processed by the first purchase target sales promotion function. Fifth processing for collecting the history information for any purpose and extracting the members as a set for a specific purpose from a group collected for any purpose, and a member for the set of members extracted in the fifth processing The information and the value history information are solved by providing at least a second purchase target sales promotion function configured by performing the first to fourth processes.

At this time, the transportation company and the transportation company storing the information on the supply company and the transportation company of the exchange value are provided.
A supply company master database, exchange value ordering / shipping instructing means in which member information and value history information processed by the first purchase target sales promotion function are performed using the transportation company / supplier master database, Exchange value sending means executed by the order / shipping instruction means. Further, as described in claim 4, the purchase target sales promotion activity using the first purchase target sales promotion function and the purchase target sales promotion activity using the second purchase target sales promotion function are performed in parallel or in succession. It is preferable to configure so that Further, as described in claim 5, the purchase target promotion activity using the first purchase target promotion function is performed at least once, and the purchase target promotion activity using the second purchase target promotion function is optional. It is also possible to carry out the number of times and to carry out a plurality of purchase target sales promotion activities in parallel.

Further, according to a sales promotion exclusive processing method according to claim 6 of the present invention, a member data specifying unit, a storage unit for the member data, and a purchase target value data associated with the member data Specifying means, exchange target value data specifying means associated with the member data, automatic calculation processing means for the purchase object value data and the exchange object value data associated with the member data, An aggregation search unit that is performed on the data obtained by the automatic calculation process in association with the member data; and the purchase target value data that is performed again in association with the member data obtained by the aggregation search unit. An automatic calculation processing unit for the exchange target value data, and the automatic calculation processing associated with the member data. Storage means of the data obtained Ri, by providing at least be solved.

According to the present invention, by effectively utilizing the existing member (customer) database and sharing the data, the system including the unification of the system when a plurality of campaigns as the sales promotion to be purchased are implemented is included. Batch processing of various tasks, business processes related to sales promotion activities,
It is possible to reduce costs and improve profits of companies. In addition, it is possible to secure customer information and differentiated royalties of retail stores and retail stores that could only be obtained through a distributor in the past. Then, using the customer loyalty by the first purchase target sales promotion function and the customer loyalty by the second purchase target sales promotion function, each customer is reliably grasped for each royalty. It is now possible for manufacturers to obtain customer information and customer loyalty differentiation obtained only through distributors in the past,
It is possible to promote the purchase of sales to retailers and sales outlets, which are customers, as never before.

Specifically, a plurality of campaigns, which are sales promotions to be purchased, are simultaneously operated and managed, and it is possible to support new customers to retailers and dealers as customers, and to secure customers and differentiate royalties. In addition, it is possible to unify promotion stories such as sales expansion by word-of-mouth of existing customers, and to receive application and input application data and incentive products as a value exchange for added value when conducting various sales promotions (campaigns). Simplified and simplified operations such as purchasing and shipping, and the short-term period (2 to 3 months) of the spring admission / employment season, bonus sales, etc., in which the willingness and effect of participation varied depending on the size of the store targeted for the campaign. For each campaign, etc., a long-term promotion tailored to the size and needs of the customer's target store And it makes it possible to down operation and management.

In addition, by automatically processing the ordering / shipping of prizes as exchange values, it becomes possible to implement an approach to a new market at low cost and effectively, and to increase profits by motivating customers who are campaign participants. Can be planned. In particular, it is possible to freely set a point rule for each customer rank as an added value, and the flexibility of dealing with customers (retail stores, sales stores, etc.) such as manufacturers is improved without distributors. In addition, data sharing and input work via the Internet, intranet, etc.
Feedback of marketing data to promotional activities can also be enabled. Further, by performing the batch integration processing of the business through the communication line, it is possible to easily expand the system to the electronic commerce function.

[0021]

An embodiment of the present invention will be described below with reference to the drawings. Note that the processing steps, devices, and the like described below do not limit the present invention, but can be variously modified within the scope of the present invention.

FIGS. 1 to 18 show an embodiment of the present invention. FIG. 1 is a diagram showing an apparatus configuration in a sales promotion exclusive processing system, FIG. 2 is a business flow in a sales promotion exclusive processing system, and FIG. FIG. 4 is a block diagram showing the concept of the promotion-dedicated processing system, FIG. 4 is a data flow diagram processed in the sales promotion-dedicated processing system, and FIG. 5 is a work flow diagram performed by the secretariat in the sales promotion-dedicated processing system. 6 to 18 show management system operation screens of the sales promotion dedicated processing system. Further, examples of data files in each database are shown in FIGS. 19 is a relationship diagram between the point registration data file and each data file, FIG. 20 is a member (customer) data file, FIG. 21 is a product master file / prize master file, FIG. 22 is a transportation company master file / supply company master file, FIG. 23 shows valid point data files.

In this specification, “value” is “point”, “purchase target” is “product or service”, “replacement target” is “prize”, and “purchase target sales promotion activity” is “product”. Or, as a “campaign” of services, “manufacturing and manufacturing, so-called manufacturers and various service providers including aircraft transport services, franchise headquarters, etc.” are “manufacturers, etc.” , "Member"
"Customer" is defined as "a retail or retail store (including a mass retailer) that directly contacts the individual who purchases the actual product or service"
Each meaning is included.

First, the configuration of the apparatus shown in FIG. 1 will be described. In this example, a secretariat 20 (including an agency, hereinafter referred to as “secretariat”) that provides a sales promotion dedicated processing system, and a company 21 such as a manufacturer are connected to a communication network such as a dedicated line or the Internet. 9 and a dedicated sales promotion processing system can be performed. In addition,
In this example, an example is shown in which the computer on the side of the secretariat 20 itself is used as the main server. However, other examples include a case where a main server is provided between the secretariat 20 and the company 21, a WWW server of another provider, and other means. Thus, the company 21 may use the computer device as a server by itself, or may use some servers.

In this example, the computer of the secretariat 20 has a CPU 1 as a data processing and control processing device, and a RAM 3, ROM 4, HDD 5, and storage medium device 2 as storage devices. Further, the input device 6 and the output device 7 are connected to the computer. Further, a communication terminal device 8 for performing communication connection and transmitting and receiving file data related to a sales promotion dedicated processing system using a dedicated line, the Internet or the like is connected.

The computer on the company 21 side needs to include at least the CPU 1, the input device 6, and the output device 7. The computer configuration of the secretariat 20 may be the same. The computer on the company 21 side is connected to the main server via the communication terminal device 8 by communication means such as a dedicated line or the Internet.

In this case, the computer on the secretariat 20 side is used as a main server, and the computer on the company 21 side is connected to the main server (computer on the secretariat 20 side) to construct a network. Therefore, the member (customer) database of the sales promotion dedicated processing system stored in the main server can be shared. In this way,
The company 21 can access a database managed by the secretariat 20 and set a campaign, extract and search member (customer) data, and the like.

First, the computer 10 of the secretariat 20 will be described. Application software and a database group for executing the sales promotion dedicated processing system are stored in the ROM 4, the HDD 5, or the like in advance. Company 21
Application software for performing network communication with the side is stored in advance in the ROM 4, the HDD 5, or the like.

Member (customer) in program file data and database of these application software
The data is fetched into a predetermined area of the RAM 3 and arithmetic processing is performed with the CPU 1 to execute each function of the sales promotion exclusive processing system.

Next, the computer of the company 21 will be described. The company 21 accesses the main server installed in the secretariat 20 and executes the processing system exclusively for sales promotion. First, the network communication software for accessing the main server and the application software for executing the sales promotion dedicated processing system are stored in the ROM 4 in advance.
It is stored in the HDD 5 or the like.

Based on the program file data of the application software, the CPU 1 performs arithmetic processing, the computer on the company 21 side is connected to the computer on the office 20 side via a network, and members (customers) of the database are used.
Access data. These member (customer) data
By loading the data into a predetermined area of the AM 3 and performing arithmetic processing with the CPU 1, it is possible to perform campaign setting, member (customer) information input, and the like in the sales promotion dedicated processing system.

Here, the computer of the secretariat 20 is used as a main server, and the external computer is connected to the communication network 9.
Although the form of connection by the above is described as an example, a main server may be provided separately from the computer at the secretariat 20 side. Further, in this embodiment, a customer such as a retail store or a store is
In particular, an example is shown in which a connection is not made by a communication line or the like, but a PC owned by the company 21 or a branch, office, or store of the company 21 is shown.
15 and a so-called personal computer 15 on the customer side may be connected from the communication terminal device 8 via the server 12 (for example, a WWW server). Further, when the mobile computing 13 owned by the customer or the sales representative of the company 21 is connected via the server 12, the PC 11 owned by the company 21 is connected to the dedicated terminal (communication network) by the communication terminal device 8.
Various modes can be added, for example, when connected to the main server 20 via the secretariat 20 and a network is constructed.

Each PC constructs a network by each communication line network 9 to form one module, and the modules formed by these communication networks are connected to each other and connected to the main server on the side of the secretariat 20 by communication. It is, of course, possible.

Next, a business flow to which the present invention is applied will be described with reference to FIG. The secretariat 20 provides the company 21 with the right to use the sales promotion exclusive processing system 23 of the present invention. The secretariat 20 receives a campaign execution business request from the company 21 side, performs data processing consistently using each function in the sales promotion dedicated processing system,
The database management 25 is performed.

Further, the secretariat 20 performs, as a general business, an order 31 to a prize supply company / prize delivery company 34, for example.
To send out prizes 35, and to give each member (customer) 22
In response to this, a report 26 of the purchase price conversion point results and a response to inquiries regarding premiums are made. Each member (customer) 22 sends proof of product purchase to the secretariat 20 or the secretariat 2
From 0, a DM notifying that the campaign has been executed, a report on the amount of points converted to the purchase amount, and the like are sent. For example, at the destination of a dedicated postcard for sending proof of purchase or the source of a DM or the like, the name of the company is described, not the 20 secretariats, of course. That is, for each member (customer) 22, the “company name” is always
Will be recognized.

The company 21 pays a usage fee (hereinafter referred to as a “license fee 24”) for the usage right 23 of the sales promotion exclusive processing system of the present invention. On the other hand, member (customer) 22
To the individual customer (not a member but a purchaser of the actual product / service) through a store advertisement or the like, and the store sales 32 of the product etc. via the distribution 29 , To obtain sales by payment 33 from the customer.

Further, the company 21 requests the secretariat 20 for the campaign implementation work consistently. At this time, implementation of a plurality of campaigns is also possible. In this example, the company 2
The first side does not perform business processing associated with the execution of the campaign.

Since the computer on the company 21 side is connected to the main server on the side of the secretariat 20 by the communication line 9, the computer 21 can always access the database 27. The company 21 can access a database stored in the main server of the secretariat 20, transmit and receive member (customer) data, and search / extract member (customer) data 27.

Based on the output data of the search / extraction process, the company 21 can set and differentiate royalties for each member (customer). Determine the target members (customers) for marketing and other purposes. In this way, it is possible to easily find a customer group to be a sales target, and to make a sales strategy plan in accordance with the royalties of each member (customer).

Here, the main campaign is carried out for all members (customers) known by the manufacturer or the like, whereas the sub-campaign is for a group of customers targeted by the main campaign. From this, we extract the “customers who are expected to purchase the product or service A during the period of B and are likely to be able to mass-produce and expand sales”, and conduct a sales campaign targeting these customers. is there.

As described above, the company 21 obtains customer information from the member (customer) database, sets an effective sub-campaign, and requests the secretariat 20 for the campaign business in a lump. By following or running sub-campaigns in parallel,
The company 21 can efficiently increase profits. Here, a so-called BtoB (B
A business form called an Internet business 28 is established.

In addition to using a dedicated line for the communication network 9, the Internet can be used. Furthermore, if the Internet or the like is also used between members (customers), a net is constructed between the secretariat 20 and the company 21 and the members, and for example, work such as campaign application and order entry of prizes and products is performed. In addition to the server on the side of the secretariat 20, it can be performed by using mobile computing 13 such as a mobile phone, a game machine, a notebook personal computer, and a PDA (Personal Digital Assistant).

The above-mentioned business form is also established when the company 21 has branches and stores, or when there is a store opening under the franchise system.

When the branches and stores are connected by the intranet constructed by the company 21 itself, the database of the secretariat 20 can be accessed 27 by the intranet and the other communication network 9. Branch,
A member (customer) database can be searched and extracted from a store regardless of place and time.

Further, when the company 21 itself sells goods 30 on the Internet, the business form of the present example is applied, of course. At this time, the wholesale process 29 is omitted during the merchandise distribution process from the company 21 to the member (customer) 22, and the sales data is automatically digitized. If it is set to be transmitted 27 to the database of the server, that is, set to be automatically transferred, there is no need for the member (customer) to send purchase proof to the secretariat 20. Naturally, the computer of the company 21 does not manage the sales data, but only automatically transfers the sales data to the secretariat 20 database. Conversion points are automatically accumulated.

Further, the secretariat 20 side provides a prize supplier /
Of course, it is also possible to make an online order 33 to the prize shipping company 34 using a communication network. in this way,
Company 21-Member (customer) 22, Company 21-Secretariat 20
Since the number of business processes in between is even smaller than that in the present example, it is more effective for the company 21 in improving work efficiency, reducing costs, and improving profits.

Settlement business 27, 30 by electronic commerce
Can also be systematized at the same time. Further, when the company 21 itself sells goods 28 on the Internet, the settlement business with the member (customer) also requires the electronic commerce 3
By performing with 0, the number of business processes is greatly reduced.

Here, the member (customer) inputs the member (customer) number and name in the input form on the homepage operated by the secretariat 20 while looking as if the member (customer) is accessing the homepage of the company 21. Then, it is possible to confirm 31 the purchase price conversion point for the purchase price at any time.

Next, database management 2 performed by the secretariat 20
5 will be described. First, when the main campaign is carried out, the member master database 5 storing the member information from the input data 62 and 63 relating to the customer information.
Search for 5 and identify the member. In order to give the converted value to the purchase price for the product purchased by the member as a given value, or to subtract the subtracted point exchanged for a prize as a exchange value corresponding to the given value, the member is specified in the product master database 57 and the prize master database 58, respectively. I do.

Predetermined calculations are automatically performed on the specified goods and prizes, and the histories thereof are stored in the point transaction database 56 in association with the member master database by the member identification number. In other words, the assigned value corresponding to the purchase value of the member existing in the member master database, the exchange value corresponding to the assigned value, the calculated result of the assigned value and the exchange value, and the member master database are associated with the member identification number. Stored value history in the value transaction database.

The customer information data and the point history data are totaled / extracted 61 by the CPU 1 to segment the customer layer having royalties to be subjected to the sub-campaign. For example, a sub-campaign of “give bonus points” to customers who are easily expected to be able to sell beer at Christmas time is implemented. Here, the member (customer) database used in the main campaign is also used in the sub-campaign. As described above, the information utilized in the main campaign and the sub-campaign is fed back and stored in the member (customer) database, so that the history data of the customer is accumulated in a multiplexed manner and used as an important information source for customer management. You.

Next, the concept of the sales promotion exclusive processing system in this example will be described with reference to the block diagram of FIG. In this example, a case will be described in which a product is sold from a company 21 to a member (customer) via a distributor or the like and payment is made. Further, the relationship between the persons by the communication means is connected between the company 21 and the secretariat 20, but is connected between the member (customer) -the company 21 and the member (customer) -the secretariat 20. It may be configured to share customer data managed by the secretariat 20.

First, the company 21 requests the secretariat 20 for a campaign 40. The secretariat 20 receives the request and performs the database management 25. Secretariat 20
Informs the member (customer) 22 that the campaign will be performed 41. At the same time, the campaign notification 41 from the company 21 is performed (of course, the secretariat 20 may substitute the campaign notification 41). Next, campaign registration 4
2 is performed. At this time, the secretariat 20 inputs data of members (customers), prize delivery destinations, and the like.

If the member (customer) is a store or a branch, the purchaser / order 43 is placed on the distributor before the sale. When the company 21 performs direct sales without going through a distributor, the company 21 sells the product 44 to the member (customer). Stores and branches that purchase or purchase the product will provide evidence of that
The sales information is sent 45 to the secretariat 20.

As an example of a sending method, a postcard dedicated to sending is prepared. There is proof of purchase, such as point tickets,
Paste receipts and post. The address is described in advance in the dedicated postcard, the "company name" is specified in the address, and the address is, for example, a post office box.

The secretariat 20 inputs merchandise purchase / sales information to the member (customer) data, registers points for purchase price conversion, and records the results. The result is output 46 to the member (customer) as a purchase price conversion point report. The member (customer) applies 47 to the secretariat 20 for a desired prize in exchange for the accumulated points corresponding to the purchase price.

The secretariat 20 orders a prize to the prize supplier / prize distributor 34 based on the application data from the member (customer) and sends out the prize 48. At this time, the secretariat 20 automatically subtracts the purchase price conversion point. The secretariat 20 sets up a prize inquiry window 51 and responds 49 to inquiries from members (customers) as needed.

Next, the processing in the sales promotion exclusive processing system in this example will be described based on the data flow of FIG. First, campaign setting data is input 62 as input data. Main campaign settings,
Segment the member (customer) segment based on royalties according to sales time and products, and set up a sub-campaign based on the results.

There are various embodiments of the main campaign and the sub-campaign. For example, the main campaign A is executed every six months from January to June and from July to December.
It is assumed to be performed twice. The sub-campaign B is a new year campaign from March to April, and the sub-campaign C is a Christmas campaign from November to December. During the sub-campaign B, for example, when a school bag is purchased, bonus points are set to be doubled as usual.

As described above, the main campaign A and the sub-campaigns B and C are performed in such a manner that A and B are performed in parallel, A and C are performed in parallel, and A is followed again.
A campaign takes place. As described above, the main campaign and the sub-campaign are executed together with each other or in parallel.

The customer group targeted for the sub-campaign executed here is determined by analyzing data from the member (customer) database used in the main campaign.
By accumulating customer history data from campaign implementation in one member (customer) database and using it effectively as an information source, it becomes easy to find more accurate customer segments to be sold.

Next, member (customer) information data is input 63
I do. Member (customer) information registration of members (customers) participating in the campaign, that is, organization (organization where the member (customer) purchased the product, organization to which the member (customer) belongs) information / personal information, prize delivery destination information, Register distribution information.

Next, the member (customer) who has purchased the product sends the purchase proof to the secretariat 20 so that the secretary 20
Inputs the purchase price conversion point registration (product application). Here, for the input data, the corresponding member (customer) is specified from the database.

In this example, the purchase proof is sent to the secretariat 2
0, the secretariat 20 inputs registration of purchase price conversion points (product application). For example, a member (customer) enters a member registration screen on a home page published by the company 21 via the Internet. The registration work may be automatically performed by inputting a serial number or a barcode number serving as purchase proof on the page.

A member (customer) who wants to exchange a prize applies the desired prize to the secretariat 20 and the secretariat 2
0 inputs a prize application. Here, the member (customer) is specified from the database.

Further, it is possible to select either a method of directly inputting data to the system or a method of converting and inputting data input as, for example, Excel (trademark of Microsoft Corporation, the same hereafter) data. When the number of cases is small, direct input is used. When the data amount (number of cases) is large, outsourcing to an input agency may be performed.

When data such as Excel, which is externally input and substituted, is taken into the conversion system, new data, similar data, and matching data are automatically discriminated. Of the data recorded on the storage medium, new and matched data are taken into the system, and the matched data is added to the existing data. The similar data which cannot be determined by the computer remains, and is compared with the original data. The automatic data conversion function improves the history management of a large amount of data, improves the accuracy of the data, and enables speedy processing.

Also, during the campaign, the company 21
The search / extraction / inquiry data 64 is inputted from the side through a communication line network 9 such as a dedicated line or the Internet, or by operating the screen on a computer of the secretariat 20 side. The above is the description of the input data.

Next, the system internal processing section 52 will be described. The system internal processing unit 52 is provided with a database group that supports the main campaign function 53.
Member information (organization / personal information, product delivery / distribution information)
, A point transaction database 56 for recording the calculation result of the purchase price conversion points together with history information, a product master database 57, a premium master database 58, and the like.

The merchandise master database stores the points for conversion of the merchandise to be purchased. Depending on the campaign, the main commodities increase points for purchase price conversion, and may be, for example, doubled. The prize master database stores an exchange point amount for a prize when the customer's accumulated purchase price conversion point is exchanged for a prize worth the point amount.

In the member master database 55, the member (customer) is authenticated by the ID, and the authenticated member (customer) data is linked to the point transaction database 56 by the ID, and the CPU 1 causes the CPU 1 to convert the purchase price conversion points into points. Is performed.

The input data for the purchase price conversion point registration described above is first stored in the member master database 55.
Then, the corresponding member (customer) is specified, and the point for the corresponding product is specified from the specified member (customer) data and the product master database 57. Further, the specified member (customer) data and product data are subjected to calculation of a purchase price conversion point by the CPU 1 and stored in the point transaction database 56.

Also, the input data of the prize application specifies the member (customer) in the member master database 55, and corresponds to the point owned by the member in the prize master database database 58 corresponding to the specified member (customer) data. The prize group corresponding to is specified. Further, the specified member (customer) data and prize data are calculated by the CPU 1 for purchase price conversion points and stored in the point transaction database 56.

As described above, the main campaign function 53
Member (customer) information data corresponding to the input data and the purchase price conversion point history data 6
9 are stored in the sub-campaign function 54 or the transport company / supply company master database 59.

Further, during the campaign, the input data of the inquiry about the member (customer) data by the screen operation of the computer on the side of the secretariat 20 or the access by the dedicated line, the Internet, etc., is stored in the member master database 55.
After the member (customer) is specified, it is stored in the point transaction database 56. Note that the CPU 1
Calculates the actual points related to purchase price conversion points,
The calculated conversion points for the member (customer) data for the member (customer) data are output as output data 65 for search, extraction, and inquiry via the communication network 9 to the company 2.
The information is output by displaying the screen on the personal computer screen of one side or the computer of the secretariat 20 side.

The member (customer) information data and the purchase price conversion point history data 69, which are various data processed by the main campaign function 53, store and manage member (customer) application results for a long period of time. . That is, CRM (customer relationship management) is possible, and the “trend” of the member (customer) is determined from the history of the member (customer), so that it is possible to respond to the needs of the member (customer). It enables fine-grained member (customer) correspondence by tabulation (including cross-tabulation) of the application cycle, sales results by product, application prizes, member (customer) attributes, and goal management. As described above, the information that has conventionally been obtained by the distributor can be acquired by the company 21 and can be actively utilized.

Next, the sub-campaign function 54 provided in the system internal processing 52 will be described.
In the sub-campaign function, using the member (customer) information data and the purchase amount conversion point history data 69 stored in the point transaction database 56, the CPU 1 allows the information totaling function 60 and the optional member (customer) extraction function. Data processing such as 61 is performed.

Optional member (customer) extraction function 61 by CPU 1
After performing the data processing of, it is determined whether to execute the sub-campaign. In the optional member (customer) extraction function 61, the member (customer) layer is segmented under various conditions, and enclosing is performed according to various different royalty conditions. Here, the conditions include the accumulated points for purchase price conversion points, areas, commodities, premiums, and the like.

By using the optional member (customer) extraction function 61, members (customers) with high royalties (economic value) which are considered to contribute to the improvement of profit for the company 21
An arbitrary member (customer) layer is extracted in consideration of a layer, a regional characteristic, a sales period, and the like, and the company 21 examines and determines whether to perform an additional sales promotion act as a “sub-campaign”. Here, when it is determined that a sub-campaign is to be performed 6
6 is entered by the main campaign function,
The member (customer) information data and the purchase price conversion point history data are used again in the main campaign function.

By performing the tallying function 60 in the sub-campaign function 54, the company 21 is provided with a “member (customer) list”, a “total purchase point conversion point report”,
It outputs “various tabulation tables” 67 and the like. The “total purchase amount conversion point report” and the “cross tabulation table” enable the company 21 to analyze members (customers) from a diversified viewpoint. Further, a "report on purchase price conversion points" can be sent to the member (customer) to notify the point results.

Further, by the main campaign function, member (customer) information data and purchase price conversion point history data 69 are accumulated in a transport company / supply company master, and the accumulated data is processed to give a prize order. A shipping instruction 68 is issued.

In the transport company / supply company master database, the transport company / supply company linked to each prize is registered, the ordering / shipping of the prize is automated, and the prize is sent to the member (customer).

Next, a work flow performed by the secretariat 20 will be described. FIG. 5 shows a work flow of the secretariat 20 in the sales promotion exclusive processing system. First, the campaign participation data (D1) is input to the existing members. Here, if there is a member (customer) who newly participates in the campaign, the new member is registered (step S1) and the campaign participation data (D1) is input. As member information,
Enter organization information / personal information, prize destination information, and distribution information. Next, the member (customer) purchases the product, and converts the points corresponding to the purchase amount into point registration data (D
Confirm as 2) and perform registration data input (step S2).

The member (customer) is informed of the exchange for the premium in exchange for the accumulated points, and the application data is received (step S3). Next, the prize data (D3) from the member (customer) is examined and input (step S).
4). Here, the conversion points for the purchase amount held by the member (customer) are automatically calculated, and further, similarity / coincidence / new determination of the application data is performed a plurality of times. Next, a performance point report is issued (step S5). The result point report is output (step S9) and sent to the member (customer).

Next, the secretariat 20 issues an order and a shipping instruction to the prize supply company / shipping company (step S6), and the prize is sent to the member (customer) (step S10). Further, the member (customer) data is tabulated and processed in the database (step S7), and the data can be analyzed. Here, we segment our members (customers)
A sub-campaign implementation is examined by extracting a member (customer) class such as a member (customer) royalty and a regional characteristic (step S8).

When the sub-campaign is performed, the setting and processing of the payment of the sub-campaign incentive are performed (step S15), and the processing of receiving the application data (step S3).
Return to and repeat the process. When the sub-campaign is not performed, the campaign results are totaled (step S1).
1) A campaign report is output (step S1)
2) Further, the questionnaire is input and counted (Step S)
13), a questionnaire report is output (step S1)
4). In the questionnaire totaling function, for example, setting within 10 questions × 10 options is possible, and a free answer column is provided for the 11th question to perform tendency value classification. Based on the questionnaire results, services and information can be provided according to the loyalty level and needs of customers. The campaign report and the questionnaire report output here are submitted to the company 21 side. Secretariat 2 during the campaign
The operation on the 0 side is completed.

Here, an example of a management system of the sales promotion exclusive processing system in this example will be described. The system environment is the basic OS as server software,
Microsoft Windows (R) N
T Server 4.0, Windows 2000 S
server, database is Oracle8 Work
group Server, the development tool as development software is Visual Basic 5.0, and the basic OS as client software is Windows
95 & 98, Windows 2000. However, the present invention is not limited to this, JAVA (registered trademark),
It goes without saying that OSs including LINUX and TRON (registered trademark), various databases, and the like can be used.

The outline of the sales promotion exclusive processing system in this example will be described from another angle. This system, in addition to the efficiency processing of the short-term closed-type sales promotion strategy that has been implemented conventionally, adds points to the account of the target channel that is registered and managed in advance according to the results of purchase and sale of the target channel. Yes), and perform long-term promotion management such that the incentive corresponding to the accumulated points can be freely exchanged and withdrawn within the expiration date of the paid points. With this system, it is possible to support with the maximum budget effect when the target channel requires it, rather than one-sided sales promotion proposals from manufacturers.

Here, the points are obtained by converting the budget to be paid for the actual purchase / sales of the target channel into points and adding the points to the management account. In other words, the promotion budget, which is divided into small units according to the actual results, is transferred to the promotion budget bank account dedicated to each target channel, and the promotion budget is saved, and the target channel is used when necessary and within the predetermined period. Can be used freely.

The incentive corresponding to the point is freely determined by the point provider according to the budget. For example,
For stores, rebates, displays, display fixtures, PO
P, educational services, temporary staffing, etc. For individuals,
It is possible to freely set whether it is tangible, intangible, or money depending on the number of accumulated points, such as travel, favorite items, miscellaneous goods, home appliances, and personal computers.

The expiration date of a point needs to be set because the expiration of the budget cannot be predicted if the point is set to an indefinite period. The expiration date can be freely set by the provider.

Further, in the sales promotion dedicated processing system in this example, the following processing management is possible. Campaign setting, sub-campaign setting, member (customer) registration, point addition / subtraction processing, member (customer) search function (actual / specific product specification / each campaign), target management function, collective processing of prize order instruction / shipment instruction ( The secretariat 20 operates and manages the output of the residual point report, the output of the marketing data, and the like.

By using the processing management function described above, conventionally, for example, when seasonal campaigns such as Christmas sales are carried out as point campaigns alone, these are used as bonus points, and the points are used as normal point campaigns. Allows multiple campaigns to be added concurrently.

Next, in order to clarify the sales promotion exclusive processing system in this example, the operation screens shown in FIGS. 6 to 18 will be described as specific examples. 6 is a main menu screen, FIG. 7 is a customer basic information management function, FIG. 8 is a customer basic information management function, FIG. 9 is a customer basic information management function, FIG. 10 is a customer history information management function, and FIG. Member questionnaire information, Fig. 12 is a function to manage sales / purchase goals for each member / free choice of DM tack seal by destination, Fig. 13 is a function for simultaneous operation of multiple campaigns, Fig. 14 is a lottery / detailed rule setting function, and Fig. 15 is Target merchandise information registration management function, FIG. 16 shows exchange prize information registration management function / principal supply / delivery company designation function, FIG. 17 shows prize supply master / transportation company master, FIG.
Reference numeral 8 denotes a marketing data form output function.

FIG. 6 shows a main menu screen. From this screen, proceed to the registration / management / instruction screen for the campaign, such as member registration, point management / prize shipping, etc. In that case, a password and a login are required, and in the system of this example, the use authority is divided into six levels, security is ensured, and customer information management is thoroughly performed.

FIGS. 7 to 9 show customer basic information management functions 1 to 3. In this example, it is possible for each member to have four pieces of address information so that member information, which is the basis of all member databases, can be stored according to all needs.

[0097] The four pieces of address information per member include the applied organization (store, company, etc. to which the member belongs), the individual applicant (member's personal address information), the destination (destination of prizes, etc.), and the distribution (member's product specification). Destination).

FIG. 10 shows the customer history information management function. The purpose of this system is to promote the communication effect between the company 21 and the customer and promote the sales of the products of the company 21 through the mediation of points. By using the point management function for each member, the registration history information of the member (campaign participation time and introduction destination) It is possible to grasp the results of negotiations and royalties between the company 21 and members, such as application history information (product purchase and sales information) and premium exchange history information.

FIG. 11 shows the member search function / membership questionnaire information. In the conventional customer database, search by member number or phone number is common, whereas in this system, search by name or address is possible in addition to member number and phone number (one of name and address). You can also search for just the words in the section.)
At the same time, each member's questionnaire information can be called up immediately, so that the members to be searched can easily identify the evaluation and impression of the company 21 and the campaign.

FIG. 12 shows the function of managing the sales / purchase targets for each member / freely selecting the DM tack seal by destination. In order to manage loyalty ranks of members and implement strategic promotions, it is possible to set sales and purchase targets for each member. In this way, approaches to those who have achieved or have not achieved their goals can be effectively performed. In addition, when sending a DM to a member for various purposes, it is possible to individually set a tack seal output from a store, an individual member, and a prize destination in order to reflect the circumstances of the company 21 and the member.

FIG. 13 shows a function for simultaneously operating a plurality of campaigns. When running campaigns, it is possible to run multiple campaigns simultaneously in order to further expand and operate organically from the built database. In other words, based on a member database in a certain campaign, another campaign for further sales expansion and new customer acquisition measures is set and operated simultaneously.
More specifically, by diversifying tabulation and analysis during the operation of the original campaign, it is possible to operate spot campaigns in parallel with products and regions that require sales reinforcement measures or that are expected to increase sales. And In addition, as a measure to acquire new customers, an “introduction campaign” in which existing members introduce and register new members is one of the important functions.

FIG. 14 shows a lottery / all rules detailed setting function. When simultaneously operating a plurality of campaigns, a target member class is designated by an application date, a product, a region, a prize exchange result, etc. in the original member database. When incentives are provided to eligible members through a campaign, it is possible to set a combination of lottery and all items (solid) according to needs.

FIG. 15 shows the target product information registration management function. Up to 100 items can be registered as target products in the campaign. In addition, the expiration date of the set point can be specified for each product individually, and the points of the products whose expiration date has expired at the end of the campaign period or at the end of the campaign will be collectively and automatically subtracted on the system, Budget management is possible for each product.

FIG. 16 shows the exchange prize information registration management function / prize supply / delivery company designation function. FIG. 17 shows a prize supply master / transportation company master. Up to 100 items can be registered as exchange prizes in a campaign.
In addition, the information of the supplier or the shipping company is linked to each of the prizes, so that there is no need to input any trader designation when ordering / shipping the prizes. In addition, in order to prevent confusion due to a time lag between ordering instructions and shipping instructions, the present system outputs instructions simultaneously.

FIG. 18 shows the marketing data form output function. In the database system of the sales promotion exclusive processing system in this example, it is possible to output the member list, the member ledger, and the member list instructed to send out the prize not only at the end of the campaign but also at any time during the period. . Similarly, the system is capable of extracting all the data at the time of diversified tabulation / analysis and report creation, such as the sales status of each product or region at the end of the campaign or within the period, prize exchange information, and the like. Further, it is also possible to output a point report for members and a DM label for approaching members.

Next, examples of data files in each database in these sales promotion exclusive processing systems will be described with reference to FIGS. 7 to 9 showing operation screens of the management system, members (customers)
By performing registration, the member master database 55
20, a member (customer) data file 100 is stored. A member ID is assigned to each data, and for one member ID, the applicant name, application organization,
Date of birth, address, occupation, prize delivery address, etc. are registered.

FIG. 1 shows an operation screen of the management system.
At 0, points are registered for the purchase of goods and the exchange of prizes by the member (customer). The point data registered here is stored in the point transaction database 56 as a point data file 101 as shown in FIG.

A member ID is assigned to each data. For one member ID, an application date, a registration date, a product code, a product name, a quantity (for a product), a prize code, a prize name, a quantity (for a prize), and an addition Points, subtraction points, valid points, and the like are registered. Further, the point registration data file 101 is linked by the member ID in the member (customer) data file 100.

Therefore, the member (customer) data file 10
0 and the point registration data file 101 are member IDs
With this, the data (record) is linked to the relational format. Of course, a table format or a card format database format may be used here.

Here, for example, the member ID: ab in FIG.
c001 is from the member (customer) data file 100,
The identification 110 of the member ID: abc001 is performed. Next, as shown in FIG. 21, by inputting the applied product code 102 and the premium code 104 of the member ID: abc001, the product master database 5 corresponding to these is entered.
7. From the product master file 103 and the premium master file 105 stored in the premium master database 58, the product name and premium name, addition and subtraction points, point expiration date, shipping company code of the corresponding product code 102 and premium code 104 106, the supply company code 107 and the like are specified.

Further, as shown in FIG. 22, the transport company code 106 and the supply company code 10 which are registered items of the product master file 103 and the premium master file 105
7, the transportation company master file 10 stored in the transportation company / supply company master database 59.
8. From the supply company master file 109, the company name and address of the corresponding transportation company code 106 and supply company code 107 are specified.

When the member ID: abc001 is inputted, the point registration data (record) corresponding to the member ID: abc001 is identified from the member (customer) data file 100 and further linked to the point registration data file 101. Is extracted. Here, for example, FIG.
In the middle, a plurality of records corresponding to ID: abc001 are extracted. Further, the points are automatically calculated by linking the records by a relation, and the obtained point data is assigned to each member ID and recorded as an effective point data file 101. Here, as shown in FIG. 23, the valid point data file 101
It is stored in the point transaction database 56.

Further, the sales promotion exclusive processing system in this example aims to acquire a new customer, fix the customer as an in-house user, and further work on a new customer based on an existing customer. The sales promotion exclusive processing system in this example achieves these objects by effectively utilizing the member database.

An open campaign or a closed campaign is effective as a measure for acquiring a new customer, that is, for attracting a prospective customer or for using a favorite of another manufacturer as a customer of the company. In addition, in order to fix customers as in-house users, that is, to increase the number of loyal customers to members, and to increase the loyalty of customers through campaigns for giving points to members, in order to make them firm in-house users. Furthermore, sales promotion by word-of-mouth, that is, a referral campaign that takes in new customers by word-of-mouth among customers with their own loyalty customers as their greatest asset is effective.

Thus, it is possible for prospective customers to become customers, for customers to become fixed customers, and for new customers to be created. The sales promotion dedicated processing system in this example can be said to be an organic database for constructing a network between the company 21 and the customer. For all members (customers), member information and point history are managed by a database, and a "point report" is sent to the members.
The members who have earned points will be offered prizes. The sales promotion dedicated processing system in this example can centrally manage all of such a series of operations.

The following items can be considered as specific examples of database utilization. Implement campaigns by loyalty rank based on aggregation of customer histories, impartialize customers with campaigns targeting only unwinners, obtain customer needs in real time through direct surveys, implement fixed campaigns for VIP customers only, implement a direct sales system Build, efficiently acquire new customers, secure customers without the need for sales representatives, implement strategic area marketing,
Inexpensive test marketing, channel rank-based direct marketing, etc. can be considered.

Further, it is possible to manage the performance of the company 21 by using the sales promotion processing system according to the present embodiment. Specific examples include a personnel appraisal system, sales employee performance management, agency sales management, dispatch registered employee motivation raising program, retail store sales performance management, and repeat customer purchase performance management.

Specific examples of campaigns that can be handled by the sales promotion dedicated processing system in this example include open campaigns, closed campaigns, point incentive campaigns, point campaigns, introduction campaigns, new product sales campaigns, enhanced product sales campaigns, and specific channels. Campaign for VI
Campaigns for P customers, new customer acquisition campaigns,
A campaign for fixing customers, a campaign for exhibition visitors, a storefront display contest, and the like can be considered.

As described above, the present invention naturally includes various embodiments not described in the above description. Therefore, the technical scope of the present invention is defined only by the matters specifying the invention according to the claims that are appropriate from the above description.

[0120]

As described above, according to the present invention, by effectively utilizing an existing member (customer) database and sharing data, a system for executing a plurality of campaigns as sales targets for purchase is implemented. Including the unification of
It is possible to collectively process various tasks, reduce business processes related to sales promotion activities and reduce costs, and improve the profits of companies. In addition, it is possible to secure customer information and differentiated royalties of retail stores and sales stores, etc., which can be obtained only through a distributor in the past. Then, using the customer loyalty by the first purchase target sales promotion function and the customer loyalty by the second purchase target sales promotion function, each customer is reliably grasped for each royalty. It is now possible for manufacturers to obtain customer information and customer loyalty differentiation obtained only through distributors,
As a result, it becomes possible to promote the purchase of sales to retailers and dealers, which are customers, as never before.

Therefore, the company can arbitrarily search and extract member (customer) data from the database regardless of time and place, and easily obtain member (customer) information for sales promotion activities such as sub-campaigns. Is possible. The member (customer) can access the database at any time to obtain correspondence and information from the secretariat in response to inquiries regarding exchange prizes, inquiries about actual points, and the like.

Further, the present invention enables a company to obtain a very high profit as a sales promotion plan. In other words, by promoting the medium- and long-term purchase of members (customers) by utilizing the high level of awareness and awareness of the plan contents that points per purchase amount conversion points are accumulated each time a member (customer) purchases. Achieve high member (customer) continuity and fix members (customers). Further, various prizes and prize options are prepared with respect to the purchase price conversion points, and a wide range of members (customers) are motivated to purchase and participate in the campaign.

By clearly presenting the campaign merits, it is easy to differentiate the campaign from the campaigns conducted by competitors. In order to increase the market share, the company will acquire and fix members (customers). By achieving the objectives of various sales promotion plans with the unified system, the respective plans are linked to each other, thereby enabling an increase in profits due to a synergistic effect.

[0124] By storing and managing the application results of members (customers) over a long period of time, CRM (customer relationship management) is implemented. The questionnaire function of this system allows companies to easily conduct marketing research. Thus, it is possible to grasp the tendency of the members (customers) and to deal with the members (customers) according to the needs.

Further, according to the present invention, it is possible for a company to significantly reduce the cost caused by a sales promotion plan. In other words, in the introduction of the present system, the member (customer) database that has already been developed is customized and operated for the present system, so that the initial cost for introducing the system can be greatly reduced. In addition, after the member (customer) purchases the product, the purchase price conversion point is paid, so the cost-effectiveness is clearly understood, and the rebate rate of the premium conversion of the purchase price conversion point to the sales plan It is set by calculating the budget that can be invested. In addition, the target members (customers) will be segmented, and test marketing will be conducted by conducting sales planning as a small pilot, and losses will be estimated. In addition, expiration dates are set for purchase price conversion points to facilitate budget planning for sales promotion planning, thereby enabling significant cost reductions.

Further, according to the present invention, system operation is easy,
It is possible for a company to utilize member (customer) data effectively and easily. In other words, centralized database management
By running, it is easy to carry out multiple campaigns simultaneously. Further processing and processing of member (customer) data
Analyze, extract and search member (customer) data,
Further, by facilitating the refined search, it is easy to execute the campaign in parallel for each rank-based member (customer). In addition, the system operation in the parallel campaign is facilitated by a sufficient quantity of campaign products.

Further, according to the present invention, for a company,
Improved operability of the system. In other words, the secretariat performs batch processing up to ordering and sending out prizes, responds to members (customers) at the counter, and grasps the current accumulation status of conversion points for purchase prices by screen operations that are easy for companies. It is possible to greatly reduce the work of the company side.

Order of prize of prize as exchange value
By performing the batch processing up to the dispatch instruction, it is possible to reduce the number of processing operations and also to prevent an order error or an erroneous transmission that occurs in a manual operation. Furthermore, since the secretariat handles all the customer processing related to actual processing operations and campaigns at once, it is possible to reduce personnel costs on the company side.

[Brief description of the drawings]

FIG. 1 is an apparatus configuration diagram in a sales promotion dedicated processing system.

FIG. 2 is a business flow diagram in a sales promotion dedicated processing system.

FIG. 3 is a block diagram showing the concept of a sales promotion dedicated processing system.

FIG. 4 is a data flow diagram processed in a sales promotion dedicated processing system.

FIG. 5 is a work flow diagram performed by the secretariat in the sales promotion exclusive processing system.

FIG. 6 is a management system operation screen: a main menu screen.

FIG. 7 is a management system operation screen: customer basic information management function 1.

FIG. 8 shows a management system operation screen: customer basic information management function 2.

FIG. 9 shows a management system operation screen: customer basic information management function 3.

FIG. 10 is a management system operation screen: a customer history information management function.

FIG. 11 is a management system operation screen: member search function / membership questionnaire information.

FIG. 12 is a management system operation screen: a sales / purchase target management for each member / a DM sticker free selection function for each destination.

FIG. 13 is a management system operation screen: a function for simultaneously operating a plurality of campaigns.

FIG. 14 is a management system operation screen: a lottery / all rules detailed setting function.

FIG. 15 is a management system operation screen: a target product information registration management function.

FIG. 16 is a management system operation screen: an exchange premium information registration / management function / principal supply / delivery company designation function.

FIG. 17 is a management system operation screen: prize supply master / transportation company master.

FIG. 18 is a management system operation screen: a marketing data form output function.

FIG. 19 is a relationship diagram between a point registration data file and each data file.

FIG. 20 is a member (customer) data file.

FIG. 21 is a product master file / prize master file.

FIG. 22 shows a transport company master file and a supply company master file.

FIG. 23 is an effective point data file.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 CPU 2 Storage medium device 3 RAM 4 ROM 5 HDD 6 Input device 7 Output device 8 Communication terminal device 9 Communication line network 11 PC 12 Server 13 Mobile computing 20 Secretariat 21 Member organization (company) 22 Member (customer) 23 System Usage right 24 Payment of system usage fee 25 Database management 27 Transmission and reception of customer data, database search / extraction,
Electronic payment 28 BtoB Internet business 30 Internet sales, electronic payment 31 Point confirmation, prize inquiry 40 Campaign request 41 Campaign notification 42 Campaign registration 43 Purchase / order 44 Product sales 45 Product purchase / sales information 46 Purchase price conversion point report 47 Desired prize application 48 Premium delivery 49 Campaign summary report 51 Premium inquiry window 52 System internal processing 53 Main campaign function 54 Sub-campaign function 55 Member master database 56 Point transaction database 57 Product master database 58 Premium master database 59 Transport company / supply company master Database 60 Total function 61 Optional member extraction function 69 Member / point history information 100 Member (customer) data file 01 Point registration data file 102 Commodity code 103 Commodity master file 104 Premium code 105 Premium master file 106 Carrier code 107 Supplier code 108 Transport company master file 109 Supplier master file 110 Identification of member ID 111 Valid point data file S1 New member Registration S2 Registration data input S3 Application data reception S4 Prize application data inspection / input S5 Performance point report issuance S6 Prize ordering / shipping instruction S7 Data compilation / processing S8 Sub-campaign execution S9 Performance point report issuance S10 Premium delivery S11 Campaign result summary S12 Issuance of campaign report S13 Questionnaire input / aggregation S14 Issuance of questionnaire report S15 Payment setting and processing of sub-campaign incentive D Campaign participants setting data D2 point registration data D3 applicants premium data

Claims (7)

[Claims] 1. A member master database for storing member information, a grant value corresponding to a purchase target value of a member existing in the member master database, a exchange value worth the grant value, and the grant value and the exchange value. A value transaction database that stores the calculated result and the value history associated with the member master database and a member identification number; and a purchase value master database that stores the grant value information set for each purchase target. An exchange value master database storing value information calculated for each of the added value and exchange value, an input unit for the purchase target sales promotion activity setting information, and an input unit for inputting the member information to the member master database; Member search means for performing the member search; and the member master If the member is present in the database, the member is searched by the member search means to specify the member, and if not, the member is stored in the member master database and the member is specified. A second process of specifying the purchased member and a purchase target purchased by the member from the purchase target master database; and a third process of specifying a redemption value corresponding to the assigned value owned by the member from the redemption value master database.
And the member specified by the first process, and the information of the purchase object and the exchange value specified in the second and third processes, the value added and the exchange value in the value transaction database. A first purchase target sales promotion function comprising at least the first processing to the fourth processing; and a first purchase target sales promotion function. A fifth process of totalizing the member information and the value history information processed by the function for any purpose and extracting the members as a set for a specific purpose from a group collected for the arbitrary purpose; Regarding the member information and the value history information for the set of members extracted in the process of step 5, at least the first to fourth Promotion dedicated processing system characterized by comprising a second purchase target promotional features formed by performing sense. 2. The sales promotion-dedicated processing system according to claim 1, further comprising an output unit that outputs a result of summing up member information and value history information for each purpose in the fifth processing. 3. A transportation company / supply company master database storing information on the exchange value supply company and the transportation company, and the member information and value history information processed by the first purchase target sales promotion function. Claims characterized by comprising at least exchange value ordering / shipping instruction means performed by using a company / supply company master database, and exchange value sending means executed by the exchange value ordering / shipping instruction means. 3. The sales promotion dedicated processing system according to 1 or 2. 4. A purchase target sales promotion activity using the first purchase target sales promotion function and a purchase target sales promotion activity using the second purchase target sales promotion function are performed in parallel or in succession. The sales promotion dedicated processing system according to claim 1, wherein: 5. A purchase target promotion activity using the first purchase target promotion function is performed at least once, and a purchase target promotion activity using the second purchase target promotion function is performed an arbitrary number of times. 5. The sales promotion dedicated processing system according to claim 1, wherein a plurality of purchase target sales promotion activities are performed in parallel. 6. A member data specifying unit, a storage unit for the member data, a purchase target value data specifying unit associated with the member data, a redemption target value data specifying unit associated with the member data, Means for automatically calculating the purchase target value data and the exchange target value data associated with the member data; and executing the member data and the data obtained by the automatic calculation process in association with the member data. Tabulation search means to be executed; automatic calculation processing means for the purchase target value data and the exchange target value data to be performed again in association with the member data obtained by the tabulation search means; and Storage means for data obtained by the automatic calculation process. Sales promotion dedicated processing method. 7. A member data specifying unit, a storage unit for the member data, a purchase target value data specifying unit associated with the member data, a redemption target value data specifying unit associated with the member data, Means for automatically calculating the purchase target value data and the exchange target value data associated with the member data; and performing the member data and the data obtained by the automatic calculation process in association with the member data. Tabulation search means, automatic calculation processing means for the purchase target value data and the exchange target value data to be performed again in association with the member data obtained by the tabulation search means, and in association with the member data, Storage means for data obtained by automatic calculation processing. Medium storing a program for the promotion dedicated processing system sale.