JP2004234508A - Advertising composite system, advertising composite program, and computer-readable storage medium recording the program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an advertising composite system, advertising composite program, or the like excellent in the capability of gathering customers. <P>SOLUTION: A center personal computer 24 performs editing of an insert flier based on an operator's input instruction (S5). When printing is instructed (S6), transmitting information is set (S7), and the insert flier is printed by a printer (S8). The insert flier is delivered to each home on an advertisement insert day (e.g., Thursday) via a newspaper store. Advertising information is transmitted to a predetermined transmission address by e-mail in interlocking with the advertisement insert day (S9). For a specified commodity, discount information or cooking recipe information is transmitted by e-mail during a special sales period. If Thursday is set to the advertisement insert day, advertisement information common to all commodities is transmitted to all customers on Thursday, and if Thursday to Saturday are set as special sales days, information of a special sales commodity corresponding to the day concerned is transmitted to a specified customer. <P>COPYRIGHT: (C)2004,JPO&NCIPI

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a combined advertising system, a combined advertising program, and a computer-readable recording medium on which the combined program is recorded. More specifically, the present invention relates to linking the transmission of an e-mail with a flyer of a paper medium such as a newspaper or a direct mail. Accordingly, the present invention relates to an advertising / combined composite system, an advertising / combined advertising program, and a computer-readable recording medium on which such an advertising / compositing composite program is recorded, which has excellent ability to attract customers, enabling an advertising activity not only for a local unit but also for a customer segment.
[0002]
[Prior art]
Speaking of advertisements, flyers of paper media such as newspapers and direct mails have been widely used. However, such a flyer of a paper medium requires time for preliminary meetings and preparation of a manuscript by a printing company before it is completed, and also costs such as labor costs. On the other hand, in recent years, advertisements using the Internet or e-mail have become widespread, and if these are used, advertisements can be made to many people at low cost. By the way, even if e-mail is sent to 10,000 people at a time, it costs only a few yen to several tens of yen. In addition, the Internet and e-mail have the advantage that different information can be automatically transmitted for each group by grouping by gender, age, preference, and the like.
[0003]
On the other hand, in the case of a paper leaflet, the cost is high as described above, and only the same information is provided in units of a certain area. As a result, the demand for paper leaflets has declined, and printing companies have been forced to reduce prices to stop the decline. In fact, the cost of a leaflet was 2.5 yen per sheet 15 years ago, but has recently been reduced to 1.5 yen per sheet. In the case of flyers made of paper media, hundreds of thousands or millions of costs are required even if the cost is reduced.
Therefore, it is considered that the cost problem and the problem of the customer group can be solved all at once by conducting the advertisement by e-mail or the Internet alone.
[0004]
[Problems to be solved by the invention]
However, in e-mail and the Internet, simply sending an e-mail is not sufficiently effective because the person receiving the advertisement must independently operate the mobile phone or computer to obtain information. Also, because the screen size is limited, it is not suitable for displaying large images and characters, but rather suitable for detailed descriptions in product texts, providing personal information and video description of products. .
[0005]
On the other hand, even if the person receiving the advertisement does not want to see it voluntarily, the flyer or direct mail of the paper medium will always be noticed by someone from the habit of looking at the mailbox and it is only placed at the entrance or in the living room. Sometimes it comes as information without knowing it. In addition, a flyer of a paper medium can take a large space, and a lot of product information can be posted at a time. For this reason, paper flyers are effective advertisements in industries that have a short product cycle, such as supermarkets that handle food items necessary for daily life, drug stores that handle daily necessities, etc., and in the real estate industry that is subject to prompt information. It can be said to be a means of advertising.
[0006]
Therefore, the present inventor can make an advertisement with more excellent ability to attract customers while compensating for each disadvantage by systematizing the system by combining the advertisement means of paper medium and the advertisement means by e-mail or the Internet. I came to the conclusion.
[0007]
Here, as this kind of conventionally known technology, there is an Internet advertising method disclosed in Patent Document 1, and the like, but the technology disclosed in Patent Document 1 does not utilize a newspaper insert leaflet. It is not a motive or cause of the invention.
[0008]
[Patent Document 1] JP-A-2002-352131
[0009]
SUMMARY OF THE INVENTION An object of the present invention is to provide an advertising / combination composite system excellent in attracting customers, an advertising / combination composite program, and a computer-readable recording medium recording the program.
[0010]
[Means for Solving the Problems]
In order to solve the above-mentioned problems, an advertisement information system according to the present invention includes: a product information input unit configured to input product information including at least a product identifier; and advertisement information for e-mail, the product information and the advertisement information. Product information storage means for storing customer information including at least an e-mail address; customer information storage means for storing the customer information; and product information input by the product information input means. A flyer production instruction unit for issuing an instruction to edit and print a flyer based on the instruction, a flyer production unit for editing and printing the flyer, and an instruction to transmit an e-mail to the e-mail address in response to detecting the editing or printing. And transmission means for transmitting the advertisement information to the e-mail address by e-mail. It is an.
[0011]
Here, the “product identifier” may be information for identifying what kind of product, and for example, a product name or a product number can be used.
The “product information” may be, for example, a product type, price information, sales date and time information, or a target customer class in addition to the product identifier. Here, the “product form” refers to a still image or a moving image representing the form of the product. The “sale date and time information” refers to a sale date and time and a time and date of a time service. "Eligible customers" are based on whether they have made a purchase before, whether they have come to a special sale on x month x day, and whether they have come on a regular sale. Means the target.
[0012]
The “e-mail advertisement information” is advertisement information transmitted by e-mail, and includes, for example, “time service from 3:00”, “W point service from tomorrow”, “on sale on a rainy day!”, “ This is today's dinner menu. This includes text information such as "This is now in stock! Nagami's carefully selected, vibrant hamachi", cooking recipes using special sale items, and still / moving image information taken with cameras and videos.
[0013]
According to the advertisement / combination system having the above configuration, the product information input unit inputs at least the product information including the product identifier and the e-mail advertisement information, and these are stored by the product information storage unit. Further, customer information including at least an e-mail address is input by the customer information input means, and the address is stored by the customer information storage means. The flyer production instructing unit issues an instruction to edit and print the flyer based on the product information input by the product information input unit, and the flyer is edited and printed by the flyer production unit based on the instruction. Further, the transmission instructing unit issues an instruction for transmitting an e-mail to the e-mail address in conjunction with detection of editing or printing by the handbill preparing unit. Transmission means transmits the advertisement information to the mail address by e-mail. Therefore, only by inputting the product information and the advertisement information for e-mail by the product information input means, a flyer on a paper medium is automatically created and the e-mail advertisement is automatically transmitted to the customer.
[0014]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, preferred embodiments of the present invention will be described with reference to the drawings. FIG. 1 is a configuration diagram of an advertising / combination complex system according to an embodiment of the present invention. FIGS. 2 to 5 show examples of tables stored in a database server, and FIG. 6 is executed by the system. FIG. 7 is a diagram showing a flow of processing to be performed.
[0015]
As shown in FIG. 1, the advertising / combination system 10 includes a customer information acquisition device 12 (12a, 12b), a center system 14, a store system 16, and a customer's mobile phone 18 (hereinafter simply "mobile phone 18"). ). These are connected to a communication network 20 such as the Internet as shown in FIG. Access is restricted as necessary to prevent information leakage.
[0016]
Personal computers are installed in the center system 14 and the store system 16 as appropriate. Each personal computer reads out a control program and controls each unit of the apparatus, a read-only memory storing a control program, an execution program and various data. Random access memory for storing characters, input devices such as a keyboard and mouse for inputting and editing characters and images, display devices for visually recognizing input characters and images, CPU for image processing, CPU for numerical calculation, communication It is equipped with devices and the like. Since these can use a well-known thing, the detail is abbreviate | omitted.
[0017]
First, the customer information acquisition device 12 will be described. The customer information acquisition device 12 is a device for acquiring an “e-mail address”, a “mobile phone number”, a “store number”, a “checkout number”, a “date of visit”, and a “time”. For example, M3 Corporation "Xnavi2" can be used. The customer information acquisition device 12 attaches the “store number” and “checkout number” to the mobile phone 18 in a state where the “store number” and “checkout number” are registered in advance, and causes the mobile phone 18 to transmit an e-mail to the center system 14. Things. A store number and a cash register number are added to the transmitted e-mail as transmission information. Therefore, by receiving the e-mail, the center system 14 can acquire the “e-mail address”, the “mobile phone number”, the “date of visit”, the “time”, the “store number” and the “checkout number”. . The date and time of sending the e-mail is the date and time of visit.
[0018]
The customer information acquisition device 12 is provided with two types, a new customer registration device 12a and a visit history registration device 12b. The e-mail transmitted from the mobile phone 18 to which the customer information acquisition device 12 (12a, 12b) is attached is stored in the customer database server 22 of the center system 14. Regardless of whether the customer is a new customer or a regular customer, the customer information that can be obtained includes “e-mail address”, “mobile phone number”, “date of visit”, “time”, and “store number”. "Checkout number". This acquired information can be added, changed, and deleted as needed.
[0019]
When the customer wants to cancel the registration of the e-mail, the customer information registration device 12a attaches the mobile phone 18 and causes the center system 14 to transmit the e-mail of the registration cancellation request from the mobile phone. Therefore, the customer can arbitrarily register or cancel registration. If the registration is canceled, information to that effect is added to the e-mail.
[0020]
Next, the mobile phone 18 will be described. The mobile phone 18 constitutes the advertisement system 10 through registration using the customer information acquisition device 12 after obtaining the consent of the customer. The reason why only the mobile phone 18 that has obtained the customer's consent is targeted is that even if the customer does not want to receive the sales promotion e-mail, the customer does not transmit the sales promotion e-mail, thereby preventing unsolicited e-mail. .
[0021]
The transmission of the e-mail from the center system 14 to the mobile phone 18 is linked to the distribution of the newspaper insert flyer, as described later. The link is expected to increase the advertising effect due to the mutual advantages of the insert flyer and the e-mail. Because you can. In other words, in the insert flyer, you can expect to see the information just by putting it in the house without going to see it yourself, and you can put a lot of product information on a large piece of paper at once . In addition, if an e-mail is linked to the insert flyer, it is expected that a customer who has seen the insert flyer will try to confirm whether a sales promotion e-mail has arrived by using the mobile phone 18 or not. It's easier to motivate customers to view emails than to advertise. Further, a sales promotion e-mail can be transmitted as product information to a customer who previously purchased the same product. It is attractive to customers because detailed information can be obtained in a timely manner.
[0022]
As will be described later, the e-mail is transmitted from the center system 14 to the mobile phone 18. As a result, the store system 16 can save the trouble of transmitting data for each customer. As will be described later, since the center flyer is also produced by the center system 14, the store system 16 only has to request the center system 14 for the advertising function and manage the request status, and plan the future information strategy. Can spend a lot of time with people.
[0023]
Next, the center system 14 will be described. The center system 14 includes a center personal computer 24, a printing device 26, a product information DB server 28, a customer information DB server 22, and a transmission information DB server 30, which are connected to a LAN and can communicate via a communication network 20. In addition, these are subjected to access restrictions as necessary, thereby preventing information leakage. The center system 14 generally receives information transmitted from a mobile phone 18 equipped with the customer information acquisition device 12 or a store personal computer 32 described later via a communication network 20, and receives the received information or electronic information. Set customer information based on email, create customer information DB for each store based on customer information, create promotional e-mail, allow access to each DB server by each store, automatic unsubscribe It has functions such as taking procedures.
[0024]
First, the center personal computer 24 receives the merchandise information (see FIG. 2) transmitted from the store personal computer 32 via the communication network 20, and folds the newspaper using the merchandise information based on the input instruction by the operator. Make a flyer. The product information is stored in the product information DB server 28. When a printing instruction is given by the operator, the center personal computer 24 creates a transmission information table (see FIG. 4) in conjunction with the printing of the newspaper insert flyer, and transmits this transmission information table to the transmission information DB server 30. Store.
[0025]
Here, the product information will be described with reference to FIG. The merchandise information is stored in the merchandise information DB server 28. Each merchandise information table T1 in which merchandise information is collected for each merchandise as shown in FIG. It is composed of an all-item information table T2 in which item information common to all items is collected, and a customer list table T7 indicating which customer purchased a certain item as shown in FIG.
[0026]
Although the drawing is an example, each record constituting each product information table T1 is composed of “product name”, “product type”, “unit price”, “sale day”, “sale day”, “advertisement date”, “ Product-specific advertising information "," Email sending date ", and" Target customer segment ". The “product name” is data including a product identifier such as a product code, but may be data including the product name itself. The “product form” is data composed of a video, an image, and a moving image of the product. The “unit price” is data indicating a price for each sales unit, such as for each unit or each pack. The “sale date”, “sale day”, and “advertising date” are data indicating the respective scheduled dates. The “product-specific advertisement information” is, for example, product-specific data such as “this is today's dinner menu” or “cooking recipe of each product”. The “mail transmission date” is data indicating the date when the sales promotion e-mail is transmitted to the customer, and is automatically set by default on the same day as the special sale date. Although the transmission time is not shown, it is automatically set at, for example, 10 am in the initial setting. The “target customer layer” is data indicating an attribute for specifically specifying a transmission destination of a sales promotion email regarding the product. Each of these data can be arbitrarily changed.
[0027]
Further, each record configuring the all-product information table T2 includes data of “advertisement posting date”, “all-product advertising information”, and “mail transmission date”. "Email sending date" is automatically set by default on the same day as the date of advertisement. It can be changed arbitrarily. “All product advertising information” is data that is not dependent on the product for all customers, for example, data such as “time service from 3:00”, “W point service from tomorrow”, “lottery held today!”, Etc. Good.
Further, each record constituting the customer list table T7 is composed of data of "product name" and "transmission address". As the “product name”, the product name of each product information table T1 is set in principle, and as the “transmission address”, data extracted based on the visit history table T4 and the sales information table T6 described later is set.
[0028]
The center personal computer 24 further analyzes the e-mail received from the mobile phone 18 equipped with the customer information acquisition device 12 to determine whether the registration is a new customer registration or a visit history registration, and stores the received customer information in the customer information DB server 22. It has the function of storing in. In addition, in the case of new customer registration, a function of immediately returning a questionnaire mail to the mobile phone 18 to which the new customer registration mail has been sent is provided. The questionnaire mail returned to the mobile phone 18 is a content that allows the customer to answer “name”, “age”, “birthday”, “sex”, “favorite food”, and the like in an interactive manner. When responding to this questionnaire mail, the customer may operate the mobile phone 18 to answer these questionnaires and then perform a reply operation. When receiving the questionnaire mail, the center personal computer 24 determines that a new customer has been registered, and the newly obtained customer information stores the customer information in the database stored in the customer information DB server 22. Is added to the existing record.
[0029]
Here, the customer information will be described with reference to FIG. The customer information is stored in the customer information DB server 22, and includes a new customer table T3 shown in FIG. 7A and a visit history table T4 for each store number and cash register number shown in FIG. In the form of
[0030]
Although the drawing is an example, the records constituting the new customer table T3 are “customer's e-mail address”, “customer's mobile phone number”, “store number”, “checkout number”, “date of visit”, “ It consists of data of “time”, “name”, “age”, “birthday”, “sex”, and “favorite food”. The data of “name”, “age”, “birthday”, “sex”, and “favorite food” were recorded for the customer when the reply to the questionnaire mail was sent from the customer's mobile phone 18. Data is recorded in the same record as the record. The store visit history table T4 is created for each store number / checkout number, and the records constituting the table are “customer's e-mail address”, “customer's mobile phone number”, “store number”, “checkout number”. , “Date of visit” and “time”.
[0031]
The center personal computer 24 further edits the original of the folding flyer based on an input instruction by the operator using a keyboard or a mouse, and sends a print instruction to the printing device 26. In the center personal computer 24, the insert flyer is edited based on the product information (see FIG. 2) stored in the product information DB server 28.
After giving the print instruction, the center personal computer 24 creates the transmission information table T5 in FIG. Each record configuring the transmission information table T5 includes data of “mail transmission date”, “transmission address”, and “transmission information”. As the “mail transmission date”, the “mail transmission date” of the corresponding record in each product information table T1 or the all product information table T2 is set, and the “transmission address” is extracted from the customer information (see FIG. 3). For example, when each product information table T1 is referred to, the e-mail address of the customer corresponding to the target customer layer is extracted from the new customer table T3, set as the "transmission address", and the all product information table T2 is referred. In this case, the e-mail addresses of all customers are extracted from the new customer table T3 and set as "transmission addresses". However, when the target customer class is a person who has experienced purchasing, the e-mail address in the customer list table T7 sent from the store personal computer 32 is set as the “transmission address” (the procedure will be described later). The "transmission information" is set to "commodity-specific advertisement information" of the corresponding record constituting each product information table T1, "all-product advertisement information" of the corresponding record constituting the all product information table T2, and other arbitrary information. Is done. In this way, the center personal computer 24 creates a new record to be added to the transmission information table T5 and stores it in the transmission information DB server 30.
[0032]
Note that a menu that allows the transmission information to be changed is displayed on the screen while the folding flyer is being made on the center personal computer 24. Therefore, when changing the transmission information, it is sufficient to operate according to the menu. .
[0033]
The transmission information DB server 30 simultaneously transmits a sales promotion e-mail to the customer's mobile phone 18 at a predetermined time on the set transmission date according to the contents of each record constituting the transmission information table T5.
[0034]
The printing device 26 prints an insertion leaflet of a newspaper, an advertisement enclosed in a direct mail, and a distribution leaflet based on an instruction from the center personal computer 24. Printed leaflets are carried to newspaper stores and delivered to local residents. The dotted line in FIG. 1 shows the flow of the flyer of the paper medium. In addition, the simple flyer shown in the figure is a flyer for store distribution that is simply created by the store system 16.
[0035]
Next, the store system 16 will be described. The store system 16 includes a store personal computer 32, a microphone 34 for recording sound for advertisement, various camera devices 36 such as a digital camera and a video device for capturing products for advertisement and images of the store, and sales information. The sales information table T6 of the store is connected to the tallying POS system 38 and can be arbitrarily extracted from the POS database (not shown) (see FIG. 5). As the sales information table T6, a table sorted for each store number / checkout number is used, and each record constituting this table is composed of “product name”, “quantity”, “unit price” as shown in FIG. , "Amount", "store number", "checkout number", "date of visit", and "time". Since a known POS system 38 can be used, a detailed description thereof will be omitted.
[0036]
The store personal computer 32 having such a configuration requests the center system 14 to produce a folded leaflet for a newspaper or the like by e-mail attached with product information, etc., based on an input instruction from the operator, or the product information DB server 28 To access product information, and to newly send product information to the center system 14 by e-mail.
[0037]
The store personal computer 32 has a function of transmitting merchandise information for sales promotion. That is, it has a function of editing various sales promotion information for each store based on an input instruction of the operator and transmitting the edited information to the center personal computer 24 by e-mail.
[0038]
Further, various analyzes can be performed using the store personal computer 32. For example, if a gift such as "Present an e-mail delivered to your mobile phone at the cash register and receive a prize gift, you can receive a point service" Is stored in the customer information DB server 22, the transmission information DB server 30, and the product information DB server 28 as to how many customers have visited the store and how many of those customers have transmitted the e-mail. The data can be analyzed by arbitrarily extracting and using the data. By trying this out with various contents of e-mail, it is possible to use the contents of e-mails to determine the contents of the e-mails that will be effective in attracting customers, etc., and to use the information in formulating a sales strategy.
[0039]
In the following, with reference to FIG. 6, a description will be given of how an advertisement is performed by the advertisement and promotion complex system 10.
[0040]
(1) New customer registration will be described with reference to FIG.
In S1, with the customer's approval, the new customer registration device 12a provided at each cash register in the supermarket is attached to the mobile phone 18 before hitting the cash register. As a result, an e-mail including the “store number” and “checkout number” registered in the new customer registration device 12a as customer information is sent from the mobile phone to the center system 14. The e-mail includes the “e-mail address”, “mobile phone number”, “date of visit”, and “time” of the mobile phone as customer information.
[0041]
In S2, a new customer is registered. In S2, the center personal computer 24 first determines the source of the e-mail. Then, when it is determined that the information is transmitted from the new customer registration device 12a, information is extracted from the e-mail, and a new record is added to the new customer table T3. Further, a new record is added to the store visit history table T4 for each store number and cash register number. When a new customer is registered, a questionnaire mail is immediately sent to the customer.
[0042]
(2) Visit history registration will be described with reference to FIG.
In S1, with the consent of the visitor, before hitting the cash register, the visit history registration device 12b provided at each cash register of the supermarket is attached to the mobile phone 18. As a result, an e-mail including the same information as the above (1) is transmitted to the center system 14.
[0043]
Next, in S2, a store visit history is added for each store number / checkout number. In S2, the center personal computer 24 first determines the source of the e-mail. When it is determined that the information has been transmitted from the store visit history registration device 12b, information is extracted from the e-mail, and a new record is added to the store visit history table T4.
[0044]
(3) The production and delivery of a newspaper insert flyer and the transmission of a sales promotion e-mail associated therewith will be described with reference to FIG. Here, a newspaper insert flyer (three-day special sale from Thursday to Saturday) is issued on Thursday, a promotional e-mail is sent to all customers on that day, and a purchase experienced person (formerly A case in which a sales promotion email is transmitted only to a customer who has purchased the product) will be described.
[0045]
First, in S3, the shop personal computer 32 requests “preparation and delivery of a newspaper insert flyer and transmission of a promotional e-mail in conjunction therewith” based on the input instruction of the operator. At this time, the information for creating the sales promotion e-mail is transmitted to the center personal computer 24 by e-mail in the form of each product information table T1, all product information table T2, and customer list table T7. The product information to be posted on the insert flyer is included in each product information table T1. Here, since the sales promotion e-mail is also sent to the purchaser, the customer list table T7 is also created by the store personal computer 32 and transmitted to the center personal computer 24. Therefore, the customer list table T7 becomes unnecessary when the sales promotion e-mail is not sent to the purchaser. Here, a procedure for creating the customer list table T7 will be described with reference to S10 to S12.
[0046]
In S10, the store personal computer 32 takes out the store visit history table T4 sorted in chronological order for each store number / checkout number from the customer information DB server 22 based on the input instruction of the operator.
[0047]
Next, in step S11, the store personal computer 32 uses the sales information DB server (not shown) of the POS system 38 to sort the sales information table of FIG. Remove T6.
Then, in S12, a customer list table T7 is created. In S12, first, for example, "apple" is set as the "product name". Then, the "date of visit / time" of each record of the store visit history table T4 sorted in order of time by store number / checkout number, and the "record of each record of the sales information table T6 sorted in order of time by store number / checkout number" Visit date / time ”. After attaching the mobile phone 18 to the customer information acquisition device 12, a cashier operation is performed, and data is registered in the POS system 38. Therefore, each record of the store visit history table T4 and a record of the sales information table T6 having the “store visit date / time” corresponding to the latest date and time immediately after the “store visit date / time” of each record of the table T4 are Correspond as if by the same customer. Then, an e-mail address is specified from the record, and a product purchased by the customer having the e-mail address is extracted from the sales information table T6. If "apple", the e-mail address is stored in the customer list table T7. Set to "Send address". This is performed for all products in each product information table T1. In this way, the store personal computer 32 creates the customer list table T7. For example, it is determined that the customer who visited the store at 10:25 recorded in the visit history table T4 and the customer who entered the cash register at 10:26 recorded in the sales information table T6 are the same customer. From there, the email address is hi @ sp. co. jp and that the customer bought an apple. Therefore, the e-mail address is set to the “transmission address” of the same record as the record including “apple” in the customer list table T7. In this way, the customer list table T7 is created as needed, and is included in the e-mail transmitted to the center personal computer 24.
[0048]
Next, in S4, when the center personal computer 24 receives the e-mail and determines that the content is “creation and delivery of a newspaper insert flyer and transmission of a promotional electronic mail associated therewith”, the center personal computer 24 outputs the insert flyer. The request information is displayed and the received product information is stored in the product information DB server 28.
[0049]
Next, in S5, the center personal computer 24 edits the insert flyer based on the input instruction of the operator. A folding leaflet is displayed on the PC screen in the same color scheme and layout as the printed state. In the insert flyer, for example, a product name, a product type, a unit price, a special sale date, and the like are posted for each advertisement-posted product. While the insertion flyer is being edited, a setting menu for transmission information (see FIG. 4) is displayed on the personal computer screen, although not shown. In the initial setting, the “mail transmission date” of the tables T1 and T2 is set as the e-mail transmission date. After editing the insert flyer, the center personal computer 24 issues a print instruction based on an input instruction from the operator in S6.
[0050]
In S7, the center personal computer 24 transmits the transmission information table based on each of the product information tables T1, the all-product information table T2, and the customer list table T7, or reflects any change in the transmission information. T5 is created and stored in the transmission information DB server 30. For example, the center personal computer 24 reads information from the “mail transmission date” and the “all product advertisement information” in the all product information table T2, and includes the information “Large sale for three days!” On Thursday, January 9 (Thursday). A new record is added to the transmission information table T5 to transmit the e-mail to all customers (see FIG. 4). Also, the center PC 24 reads “mail transmission date”, “commodity-specific advertising information”, and “transmission address” from each product information table T1 having the same product name and the customer list table T7. On January 9 (Thursday), a promotional e-mail containing “Apple pie recipe” was sent. On January 10 (Friday), a promotional e-mail containing “discount coupon present” information was sent on January 11 (Saturday). ), A new record is added to the transmission information table T5 in order to transmit a sales promotion e-mail including the information “with mail member privilege” to the purchaser (here, a customer who has bought an apple). See figure).
[0051]
When a print instruction is issued (S6), a folding leaflet is printed by the printing device 26 as shown in S8. The printed insert flyer is delivered to a newspaper shop and delivered to each home on a predetermined advertisement posting date. In S9, the sales promotion e-mail is transmitted to the customer based on the transmission information table T5 in conjunction with the print instruction from the center personal computer 24. That is, on Thursday, January 9, a sales promotion e-mail containing information of "Large sale for three days!" Is sent to all customers, and from Thursday, January 9 to Saturday, January 11 (Saturday). ), A sales promotion e-mail containing information such as “Apple pie recipe”, “Discount coupon present”, and “with mail member privilege” is sent to purchasers every day.
[0052]
(5) When transmitting a promotion e-mail to the target customer group based on each product information table T1 and new customer table T3, the following is performed.
For example, when a sales promotion e-mail is sent to “customers over 30” for “Haccho miso” based on an instruction from the store personal computer 32, the center personal computer 24 sets “age” in the new customer table T3 to “age”. Hi @ sp. Grouped based on age 30 or older. co. jp, ad @ sp. co. jp, ay @ sp. co. jp is set as the “transmission address” of a new record to be added to the transmission information table T5. Further, the center personal computer 24 sets “mail member further 50 yen discount” of each product information table T1 as “transmission information” of a new record to be added to the transmission information table T5. The mail transmission date of each product information table T1 is set as the “mail transmission date”, and a record to be newly added to the transmission information table T5 is created. This record is added to the transmission information table T5 of the transmission information DB server 30, and an e-mail is transmitted to the customer at the designated date and time. The contents of the transmission information table T5 can be changed as appropriate.
[0053]
(6) When transmitting a promotional e-mail of any content to the visitor based on the purchase history table T4, the following is performed.
For example, when a sales promotion e-mail with the content "Every Saturday is a special sale day of Hatcho miso" is sent to a customer who came to the store on January 4, the store personal computer 32 transmits the e-mail on that day based on an input instruction from the operator. A request for transmitting a sales promotion e-mail to the customer who has visited the store is transmitted to the center personal computer 24 by e-mail together with the advertisement information. The center personal computer 24 sends the e-mail address (hi@sp.co.jp, gh@sp.co.jp, ay @ sp) of the customer who arrived on January 4 based on the "visit date" in the visit history table T4. .Co.jp, db@sp.co.jp), and sets this as the “transmission address” of the new record to be added to the transmission information table T5. In addition, the center personal computer 24 sets, as “transmission information” of the new record to be added to the transmission information table T5, the information “Every Saturday is a special sale day of Hatcho miso” sent from the store personal computer 32. Then, “Every Saturday” is set as the “mail transmission date”, and a record to be newly added to the transmission information table T5 is created. This record is added to the transmission information table T5 of the transmission information DB server 30, and an e-mail is transmitted to the customer at the designated date and time.
[0054]
Although the embodiment of the present invention has been described above, the present invention is not limited to the above embodiment. For example, in this embodiment, a supermarket has been described as an example, but the target to which the present invention is applied is not limited to a supermarket, and can be applied to various types of industries such as a cosmetics store, a drug store, a laundry store, and a real estate store. . The contents of the sales promotion e-mail are not limited to the present embodiment either, and are not limited as long as the contents can collect customers. Therefore, the specific contents of each product information table T1 to customer list table T7 may be in accordance with the products and services handled in each type of business.
[0055]
For example, in the new customer table T3, a column of "favorite food" is provided, but instead or additionally, a column for asking "women with infants" and "home with elementary school students" is provided. Is also good. Further, in the new customer table T3, a column for asking whether or not a member of the "Cosmetic Friends Club" is provided for a cosmetics shop, and a column for asking whether or not a member of the "Healthy Food Friends Club" is provided for a drugstore. Can be provided. Further, for example, if the cleaning shop is a cleaning shop, the advertisement information of "Stain removal cleaning 1 discount!" In this way, each table can be modified as needed.
[0056]
The merchandise information, customer information, and transmission information are created based on data exchanged by e-mail sent and received via a communication network, but these are stored on a storage medium (CD-ROM, magnetic disk, etc.). ) May be used as well as data created each time. Further, the creation of a new record to be added to the transmission information table T5 may be automatically performed by a personal computer or may be manually performed by an operator. Although details are omitted, measures are taken to prevent a large amount of sales promotion e-mails from being sent to the same customer at one time.
[0057]
【The invention's effect】
As described above, according to the present invention, the flyer production instruction means issues an instruction to edit and print a flyer based on the product information input by the product information input means, and based on the instruction, the flyer production means , The flyer is edited and printed. Further, the transmission instructing unit issues an instruction for transmitting an e-mail to the e-mail address in conjunction with detection of editing or printing by the handbill preparing unit. The transmitting means transmits the advertisement information to the mail address by e-mail. Therefore, only by inputting the product information and the advertisement information for e-mail using the product information input means, a flyer on a paper medium is automatically created and the e-mail is automatically transmitted to the customer. Therefore, the customer can be prompted to visit the store by e-mail in conjunction with the insert advertisement. Customers who don't want to visit just by looking at the insert ads can also come to the store. Therefore, there is an effect of being excellent in attracting customers. Further, there is an effect that a flyer of a paper medium is also effectively used.
[Brief description of the drawings]
FIG. 1 is a block diagram showing a configuration of an advertising / commercial complex system 10 according to an embodiment of the present invention.
FIG. 2 is a diagram showing the configurations of (a) each product information table T1, (b) all product information table T2, and (c) customer list table T7.
FIG. 3 is a diagram showing a configuration of (a) a new customer table T3 and (b) a visit history table T4.
FIG. 4 is a diagram showing a configuration of a transmission information table T5.
FIG. 5 is a diagram showing a configuration of a sales information table T6.
FIG. 6 is a flowchart showing an example of a processing procedure of the advertisement system 10 according to the embodiment of the present invention, where (a) is a procedure of a new customer / visit history registration flow, and (b) is a newspaper insert. It is the flowchart which showed the procedure of the preparation delivery of a flyer, and the transmission of the promotion electronic mail linked | linked with it.
[Explanation of symbols]
10. Advertisement and advertising complex system
12. Customer information acquisition device (12a new customer registration device, 12b visit history registration device)
14 Center system
16 store system
18 mobile phone
20 Communication Network
22 Customer information DB server
24 Center PC
26 Printer
28 Product information DB server
30 Transmission information DB server
32 PCs for stores
34 microphone
36 Camera equipment
38 POS system

Claims (3)

Product information input means for inputting product information including at least a product identifier, and advertising information for e-mail;
Product information storage means for storing the product information and the advertising information,
Customer information input means for inputting customer information including at least an email address,
Customer information storage means for storing the customer information,
A flyer production instructing unit that issues a command to edit and print a flyer based on the product information input by the product information input unit,
A flyer making means for editing and printing the flyer,
When the editing or printing is detected, transmission instruction means for issuing an electronic mail transmission instruction to the electronic mail address in conjunction therewith,
Transmitting means for transmitting the advertisement information to the mail address by e-mail. Computer
Product information input means for inputting product information including at least a product identifier, and advertising information for e-mail;
Product information storage means for storing the product information and the advertising information,
Customer information input means for inputting customer information including at least an email address,
Customer information storage means for storing the customer information,
A flyer production instructing unit that issues a command to edit and print a flyer based on the product information input by the product information input unit,
A flyer making means for editing and printing the flyer,
When the editing or printing is detected, transmission instruction means for issuing an electronic mail transmission instruction to the electronic mail address in conjunction therewith,
A program for functioning as transmission means for transmitting the advertisement information to the mail address by e-mail. Computer
Product information input means for inputting product information including at least a product identifier, and advertising information for e-mail;
Product information storage means for storing the product information and the advertising information,
Customer information input means for inputting customer information including at least an email address,
Customer information storage means for storing the customer information,
A flyer production instructing unit that issues a command to edit and print a flyer based on the product information input by the product information input unit,
A flyer making means for editing and printing the flyer,
When the editing or printing is detected, transmission instruction means for issuing an electronic mail transmission instruction to the electronic mail address in conjunction therewith,
A computer-readable recording medium recording a program for causing the advertisement information to function as a transmission unit that transmits the advertisement information to the e-mail address by e-mail.

Images