JP5385071B2 - E-mail delivery system and e-mail delivery method in e-commerce - Google Patents

Description

  The present invention relates to an e-mail delivery system and e-mail delivery method in electronic commerce in which merchandise transactions are performed via a communication line network such as the Internet, and more particularly to efficiently deliver e-mails for merchandise sales guidance to users. The present invention relates to an electronic mail distribution system and electronic mail distribution method in electronic commerce.

  In recent years, with the development of communication networks such as the Internet and the development of personal computers, merchandise vendors have made many product advertisements using virtual stores (homepages) of websites on the Internet, and users who viewed them have preferred Electronic commerce to purchase products is actively conducted. In addition, when the user purchases a product, the virtual store stores customer information such as the user's email address and address in a customer information database or the like, and the product is similar to a product purchased by the user in the past. Product sales promotion that distributes the advertisement information to the user as an e-mail magazine is also performed. Note that the e-mail magazine and e-mail described in this specification are consents.

  As a document describing computer technology for conducting product sales promotion activities by e-mail to the user from the Web site, for example, the following Patent Document 1 is cited, and this Patent Document 1 is adapted to the user's preference. A technique for transmitting an e-mail including content information to a user is described.

JP 2009-181400 A

  The technology for sending e-mail magazines to customers according to the prior art is ignored because it is difficult for users to receive many e-mail magazines and read the details of all e-mail magazines, and it is difficult due to the large amount In many cases, there is a problem that it is difficult for the website side that conducts electronic commerce to efficiently provide product advertisement information to the user. On the other hand, even for the website side, even if the e-mail magazine is manually edited and transmitted to a large number of users, there is a problem that the e-mail magazine is unlikely to lead to product sales.

  Even when a large number of virtual stores are registered on one electronic commerce website, each virtual store uses an e-mail magazine based on a product that has been sold or browsed in its own virtual store. Is extracted, and based on this, the e-mail magazine of the corresponding product guide is issued, so the work in each virtual store is complicated, and for example, other virtual stores in the same Web site Even if there is a product that matches the user's preference, there is a problem that the virtual store product cannot be guided (advertised advertisement) to the user.

  An object of the present invention is to eliminate the above-mentioned problems, and to share a plurality of store user information in an electronic commerce site and efficiently distribute an e-mail magazine of product advertisements (product information provision) to users. An electronic mail distribution system and electronic mail distribution method in electronic commerce that can be performed.

In order to achieve the above object, the present invention provides a computer that uniquely assigns a product number to a plurality of products handled by a plurality of virtual stores and transmits the plurality of products to a plurality of user terminals via an Internet network by an e-mail magazine. An electronic mail distribution system for electronic commerce comprising:
A user information database storing user IDs and email addresses uniquely assigned to a plurality of users;
A merchandise related information table section between stores that assigns a unique preference ID to the preference and stores the merchandise numbers of the merchandise handled by a plurality of virtual stores included in the preference ID;
A user analysis information database storing a product number included in an e-mail magazine transmitted corresponding to a user ID, presence / absence of a response to the e-mail magazine, and preference information;
An electronic commerce product data section for storing information of a plurality of products to which the product number is assigned;
A mail pattern table storing a plurality of pieces of text information of the e-mail magazine;
An access log storage unit for storing response information indicating that the user has viewed the product information stored in the electronic commerce product data unit;
A mail transmission / reception unit for transmitting / receiving the mail magazine to / from a plurality of user terminals;
The computer is
A first step of extracting a product number of a product to be advertised from the electronic commerce data part;
Based on the product number extracted in the first step, product information is extracted from the electronic commerce product data part, and specified mail text information is extracted from the mail pattern table, and the extracted product is displayed in the extracted mail text. A second step of creating an e-mail magazine for a primary action combining information;
A third step in which the e-mail magazine created in the second step is transmitted to the e-mail address extracted from the user information database by the mail transmitting / receiving unit;
Among users who have sent an e-mail magazine in the third step with reference to the access log storage unit after a predetermined period of time has passed since the e-mail magazine was sent in the third step, no response information is stored A fourth step of extracting the ID;
The product information extracted in the first step and the mail text information specified from the mail pattern table are extracted, and an e-mail magazine for a secondary action is created by combining the extracted product information with the extracted mail text. And a fifth step to
A sixth step in which the e-mail magazine created in the fifth step is transmitted to the e-mail address of the user ID extracted in the fourth step by the mail transmitting / receiving unit;
Among users who have sent an e-mail magazine in the sixth step with reference to the access log storage unit after a predetermined period has passed since the e-mail magazine was sent in the sixth step, no response information is stored A seventh step of extracting an ID;
Based on the product number of the product information included in the e-mail magazine transmitted in the seventh step, another product number assigned with the same preference ID as the product number is extracted from the inter-shop product related information table unit. 8 steps,
Based on the other product number extracted in the eighth step, the other product information is extracted from the electronic commerce product data part, and the mail text information designated from the mail pattern table is extracted, and the extracted mail text includes the second product information. Creating an e-mail magazine combining the product information extracted in the seventh step, and executing the ninth step of transmitting the e-mail magazine to the mail address extracted in the seventh step by the mail transmitting / receiving unit. One feature.

Furthermore, the present invention provides
A merchandise related information table section between stores that assigns a unique preference ID to the preference and stores the merchandise numbers of the merchandise handled by a plurality of virtual stores included in the preference ID;
A user analysis information database storing a product number included in an e-mail magazine transmitted corresponding to a user ID, presence / absence of a response to the e-mail magazine, and preference information;
An electronic commerce product data section for storing information of a plurality of products to which the product number is assigned;
A mail pattern table storing a plurality of pieces of text information of the e-mail magazine;
An access log storage unit for storing response information indicating that the user has viewed the product information stored in the electronic commerce product data unit;
A mail transmission / reception unit for transmitting / receiving the mail magazine to / from a plurality of user terminals, and uniquely assigns a product number to a plurality of products handled by a plurality of virtual stores, and electronically transmits the plurality of products to the plurality of user terminals via the Internet network. An e-mail delivery method in an e-commerce computer comprising a computer for sending by e-mail magazine,
In the computer,
A first step of extracting a product number of a product to be advertised from the electronic commerce data part;
Based on the product number extracted in the first step, product information is extracted from the electronic commerce product data part, and specified mail text information is extracted from the mail pattern table, and the extracted product is displayed in the extracted mail text. A second step of creating an e-mail magazine for a primary action combining information;
A third step in which the e-mail magazine created in the second step is transmitted to the e-mail address extracted from the user information database by the mail transmitting / receiving unit;
Among users who have sent an e-mail magazine in the third step with reference to the access log storage unit after a predetermined period of time has passed since the e-mail magazine was sent in the third step, no response information is stored A fourth step of extracting the ID;
The product information extracted in the first step and the mail text information specified from the mail pattern table are extracted, and an e-mail magazine for a secondary action is created by combining the extracted product information with the extracted mail text. And a fifth step to
A sixth step in which the e-mail magazine created in the fifth step is transmitted to the e-mail address of the user ID extracted in the fourth step by the mail transmitting / receiving unit;
Among users who have sent an e-mail magazine in the sixth step with reference to the access log storage unit after a predetermined period has passed since the e-mail magazine was sent in the sixth step, no response information is stored A seventh step of extracting an ID;
Based on the product number of the product information included in the e-mail magazine transmitted in the seventh step, another product number assigned with the same preference ID as the product number is extracted from the inter-shop product related information table unit. 8 steps,
Based on the other product number extracted in the eighth step, the other product information is extracted from the electronic commerce product data part, and the mail text information designated from the mail pattern table is extracted, and the extracted mail text includes the second product information. Creating an e-mail magazine combining the product information extracted in the seventh step, and performing the ninth step of transmitting the e-mail magazine to the mail address extracted in the seventh step by the mail transmitting / receiving unit. Two features.

  An e-mail magazine distribution system and method according to the present invention uses an e-mail magazine to advertise products registered in an e-commerce product data section (EC data section) to a user who has already registered in an e-commerce transaction in which a plurality of virtual stores are registered. And analyzing the access status of the user who referred to the e-mail magazine, and re-sending a plurality of e-mail magazines to the user who has not responded with a change in the text based on the analyzed analysis information. When the user does not respond to the e-mail magazine, another product is searched from the inter-shop product related information table according to the user preference, and the searched other product is guided to the user by the e-mail magazine. By the operation, the products of a plurality of virtual stores registered in the electronic commerce product data part can be guided to the user.

1 is an overall configuration diagram of an electronic mail distribution system according to an embodiment of the present invention. The figure which shows the database structure of the user access log by this embodiment. The figure which shows the structure of the merchandise sales management database by this embodiment. The figure which shows the structure of the analyzed user analysis information database by this embodiment. The block diagram of the access log database for every user by this embodiment. The block diagram of the mail plan table which stores the mail plan by this embodiment. The block diagram of the goods related table between shops according to this embodiment by taste. Explanatory drawing of the email delivery operation | movement by this embodiment.

[overall structure]
As shown in FIG. 1, an electronic mail distribution system according to an embodiment of the present invention includes a mail server 100 to which a plurality of user terminals 10 are connected via an Internet network 20, and the mail server 100 and the Internet network 20. And an EC site system 200 that sells products at a plurality of virtual stores.

  The mail server 100 is a general electronic mail server, and includes an incoming mail database (DB) 103 for storing incoming electronic mail from the user terminal 10 and the like, and an outgoing mail base (DB) for storing outgoing electronic mail. ) 102 and a transmission / reception unit 101 that transmits / receives e-mails of the databases 102 and 103 via the Internet network 20.

  An EC site system 200, which is a feature of the present embodiment, includes an EC data unit 230 that stores product data (information) in a plurality of virtual stores, and product data stored in the EC data unit 230 on the Internet web. The website section 210 for publishing a website that introduces a large number of products, the user information DB 290 that stores personal information of users registered on the website, and the website of the website section 210 are accessed and registered as a member. An access log extraction unit 220 that extracts an access log such as a user who has logged on and browsed a product and information on the browsed product, and a mail pattern table (TB) that stores a plurality of draft data of an e-mail magazine to be transmitted to the user 245 and the mail pattern table (TB) 245. A mail creation unit 240 that creates an e-mail magazine based on the plan data, a mail transmission / reception unit 280 that controls transmission / reception of e-mails, and user access log information extracted by the access log extraction unit 220 A user information analysis unit 260 that analyzes user information such as an access pattern, a product sales management information database (DB) 250 that stores sales management information of products stored in the EC data unit 230, and a main control that controls each circuit. Part 270. Note that the functions described in this specification are configured by computer hardware or software.

  The user information analysis unit 260 includes an access log storage unit 261 that stores the access log information extracted by the access log extraction unit 220, and a user preference and access based on the access log information stored in the access log storage unit 261. A pattern analysis unit 262 that analyzes an access pattern such as time, a user analysis information database (DB) 263 that stores preference information for products for each user analyzed by the pattern analysis unit 262, and the EC data unit for each user preference By classifying a plurality of products of a plurality of stores stored in 230 for each preference, it is configured from an inter-store product related information table 267 storing the same or similar preference relationship between different virtual stores.

[Product Sales Management DB 250]
The merchandise sales management DB 250 is for managing the merchandise sales by storing the user's response to the issuance of the e-mail magazine (browsing and purchasing the merchandise on the website). And a plurality of e-mail magazine transmission and response status (transmission time / response presence / absence flags) fields for each user, and the response status includes the first primary action, When there is no response to the primary action (product access from the user), a secondary action of creating a mail with a changed text and sending a second e-mail magazine, and the secondary action When there is no response to the action, create a mail with a changed text, send a third e-mail magazine, and a third action. When there is no response to the Deployment, to create an email with changes introduced products, consisting of each column of the fourth-order action to send the fourth round of the e-mail magazine.

  In the example shown in FIG. 2, the primary action column sends an e-mail magazine for the advertisement of the product “M001” to a plurality of users at 3:00 am on 2009/10/01 for a predetermined period (for example, 3 Only users “A001” and “A123” browsed the corresponding product on the website (response flag “1”) and other users did not browse the corresponding product (response flag “0”) The second action column shows an e-mail magazine with a revised draft for a plurality of users who have not responded at 3:00 am 2009/10/10, and the user within a predetermined period (for example, 3 days) Only “A124” browsed the corresponding product on the website (response flag “1”), and other users did not browse the corresponding product (response flag “0”). Meet E-mail magazine, which has been corrected to introduce products to no were multiple users of the originating at the 10/10/2009 3 am, and represents that it has sent the e-mail magazine of the other products guide.

[Access log storage unit 261]
The access log storage unit 261 stores access histories (logs) to websites by a plurality of users who have registered personal information including e-mail addresses in advance, and corresponds to log numbers that are unique serial numbers. In the example illustrated (FIG. 3), each information of the user ID of the accessed user, the access date and time, the product number of the viewed product, and the user preference ID obtained by the analysis described later is stored. For example, the user with the user ID “A001” browses the product with the product number “M005” at 7:00 am on September 2, 2009, and the preference IDs analyzed by the user are “SA001” and “SB001”. ing.

[User analysis information database 263]
The user analysis information database 263 stores analysis information for analyzing user preferences based on products browsed and / or purchased by the user, and the date and time when the e-mail magazine is transmitted for each user ID. , The product number (ID) of the product introduced by the e-mail magazine, the response history (response or non-response) of the e-mail magazine, the total number of accesses by the e-mail magazine, and the flag when the product is purchased Each information of a purchase flag to be set up (“1” at the time of purchase, “0” at the time of non-purchase), preference first ID, and preference second ID is stored.

  In the example shown in FIG. 4, an e-mail magazine with a product number “M005” product guide is issued to the user with the user ID “A001” at 3:00 am on October 1, 2009, and the user is sent to this mail magazine. However, a response (product browsing) to the first action is performed, the product is purchased by accessing twice, and the preference information of the purchased product is “SA001” and “SB002”.

[Mail pattern table 245]
The mail pattern table 245 stores the mail magazine texts corresponding to the plurality of actions described above, and the patterns 01 to 03 are the same products that are sequentially adopted from the primary to the tertiary actions. When the user does not take an action for the product, the guidance text, pattern 4 represents the text when performing other product guidance based on the user preference.

[Inter-shop product related information table 267]
The inter-shop merchandise related information table 267 stores a merchandise ID of a merchandise handled by a plurality of virtual shops that are considered to be included in the preference ID. In the example of FIG. 6, in the DVD (registered trademark) of the genre “movie”, movies are classified into major categories: “drama (SA001)”, “fantasy (SA002)”, “horror (SA003)”, “action (SA004)”. Separately, the major categories are subdivided into “Japanese movies (SB001)”, “Western movies (SB002)” and “Asia movies (SB003)”. In the example shown in FIG. Products classified as “Drama” (preference first level ID “SA001”) and Japanese movies (preference second level ID “SB001”) are products “M001” at the store i. The handling, handling the product "N420" and others in the shop and Russia, handling the product "L123" and others in the shop Ha, in the shops two represent that you are dealing with goods "P155" and others.

  In other words, the inter-store product related information table 267 stores products IDs in a plurality of virtual stores to which products corresponding to user preferences are assigned with preference IDs and given preference IDs. Then, I gave a movie as an example, but it is not limited to this.

[User Information Database 290]
The user information database 290 stores a name / address / phone number / purchased product (ID / number) history / preference information (preference ID level) corresponding to a user ID, and the name / address / phone number. Is self-registered by the user, and the purchase product history and preference information are registered by the main control unit 270 by a process described later.
[Operation]
The overall operation of the e-mail delivery system according to the present embodiment is to advertise products registered in the EC data unit 230 to users who have already registered the EC site system 200 registering a plurality of virtual stores using an e-mail magazine. , Analyzing the access status of the user referring to this e-mail magazine, and changing the text of a plurality of e-mail magazines for users who have not responded based on the analyzed analysis information (whether Web browsing / product purchase) If the user does not respond to the e-mail magazine a predetermined number of times, another product is searched from the inter-shop product related information table 267 according to the user preference, and the searched other product is guided to the user by the e-mail magazine. Through such operations, the products of a plurality of virtual stores registered in the EC data unit 230 are used. It can be guided to.

  As shown in FIG. 8, the details of this operation are based on the condition that the EC site system 200 inputs the products of a plurality of virtual stores registered in the EC data unit 230 under the control of the main control unit 270 by the administrator. Step S01 in which the extracted product is set as an object to be advertised, advertisement product information extracted from the EC data unit 230, and user information registered in the user information database 290 (email address, preference information if there is preference information) ) To create an e-mail magazine with the text of pattern 01 in which the promotional text of the product is registered in the e-mail pattern table 245 for a plurality of users, and the e-mail magazine thus created is sent to the e-mail transmission / reception unit 280. Step S03 for executing the first action to be transmitted to the plurality of user terminals 10 using is performed. This first action information is stored in the merchandise sales management database 250, and the following operations are the same.

  Next, the e-mail delivery system according to the present embodiment determines whether or not there is a response (product browsing or purchase) from the user to the first action after elapse of a predetermined period (for example, 3 days), and the user for the step S04 When it is determined that there is no response (product browsing or purchase) from within a predetermined period (for example, 3 days), an e-mail magazine with a pattern 02 in which the promotional text of the product is registered in the mail pattern table 245 is created, Step S11 for performing a second action issued to a user who does not respond, Step S13 for determining whether or not there is a response from the user to the second action, and a response from the user to Step S11 is predetermined. When it is determined that it is not within the period, the promotional text of the product is displayed in the mail pattern table 245. An e-mail magazine with a registered pattern 03 text is created and a third action is issued to a user who does not respond, and whether or not there is a response from the user to the third action is determined after a predetermined period. By executing Step S17, when it is determined that the response from the user to the electronic mail magazine is not within a predetermined period, the mail magazine whose mail text is changed is reissued. Note that when it is determined in step S05, step S13, and step S17 that there is a response from the user, the electronic mail distribution system uses the response flag as a response flag in the product sales management database 250. Similarly to step S09 for storing, step S07 for storing in the merchandise sales management database 250 that there is no response when there is no user response is included.

  When the e-mail delivery system according to the present embodiment determines that there is no user response in step S17, in step S19, the inter-shop merchandise related information table 267 is referred to, and the preference of the merchandise guided to the user in the step. Step S19 in which IDs (first level and second level) are extracted, another product number in another virtual store that is the same as the extracted preference ID is searched, and the searched product is targeted for promotion, and step S19 If there is no response from the user to the same promotional product by issuing an e-mail magazine with the text of pattern 04 of the pattern table 245 and executing step S21 returning to step S01, preference is given Can advertise products from other stores that are similar.

  The delivery time of the mail magazine is analyzed based on the access log time, for example, the user's access pattern such as early morning / going home, lunch break, holiday, etc., and mail delivery is performed accordingly (probability during PC operation is It is desirable to deliver mail at a high time / day of the week.

10: User terminal, 20: Internet network, 100: Mail server, 101: Transmission / reception unit, 102: Database, 200: EC site system, 210: Web site unit, 220: Access log extraction unit, 230: EC data unit, 240 : Mail creation unit, 245: Mail pattern table, 250: Product sales management information database, 260: User information analysis unit, 261: Access log storage unit, 262: Pattern analysis unit, 263: User analysis information database, 267: Between stores Product related information table, 270: main control unit, 280: mail transmission / reception unit, 290: user information database.

Claims (2)

An e-mail distribution system in electronic commerce comprising a computer that uniquely assigns a product number to a plurality of products handled by a plurality of virtual stores and transmits the plurality of products to a plurality of user terminals via an Internet network by an e-mail magazine. ,
A user information database storing user IDs and email addresses uniquely assigned to a plurality of users;
A merchandise related information table section between stores that assigns a unique preference ID to the preference and stores the merchandise numbers of the merchandise handled by a plurality of virtual stores included in the preference ID;
A user analysis information database storing a product number included in an e-mail magazine transmitted corresponding to a user ID, presence / absence of a response to the e-mail magazine, and preference information;
An electronic commerce product data section for storing information of a plurality of products to which the product number is assigned;
A mail pattern table storing a plurality of pieces of text information of the e-mail magazine;
An access log storage unit for storing response information indicating that the user has viewed the product information stored in the electronic commerce product data unit;
A mail transmission / reception unit for transmitting / receiving the mail magazine to / from a plurality of user terminals;
The computer is
A first step of extracting a product number of a product to be advertised from the electronic commerce data part;
Based on the product number extracted in the first step, product information is extracted from the electronic commerce product data part, and specified mail text information is extracted from the mail pattern table, and the extracted product is displayed in the extracted mail text. A second step of creating an e-mail magazine for a primary action combining information;
A third step in which the e-mail magazine created in the second step is transmitted to the e-mail address extracted from the user information database by the mail transmitting / receiving unit;
Among users who have sent an e-mail magazine in the third step with reference to the access log storage unit after a predetermined period of time has passed since the e-mail magazine was sent in the third step, no response information is stored A fourth step of extracting the ID;
The product information extracted in the first step and the mail text information specified from the mail pattern table are extracted, and an e-mail magazine for a secondary action is created by combining the extracted product information with the extracted mail text. And a fifth step to
A sixth step in which the e-mail magazine created in the fifth step is transmitted to the e-mail address of the user ID extracted in the fourth step by the mail transmitting / receiving unit;
Among users who have sent an e-mail magazine in the sixth step with reference to the access log storage unit after a predetermined period has passed since the e-mail magazine was sent in the sixth step, no response information is stored A seventh step of extracting an ID;
Based on the product number of the product information included in the e-mail magazine transmitted in the seventh step, another product number assigned with the same preference ID as the product number is extracted from the inter-shop product related information table unit. 8 steps,
Based on the other product number extracted in the eighth step, the other product information is extracted from the electronic commerce product data part, and the mail text information designated from the mail pattern table is extracted, and the extracted mail text includes the second product information. In electronic commerce, an electronic mail magazine is created by combining the product information extracted in the seventh step, and the electronic mail magazine is transmitted to the mail address extracted in the seventh step by the mail transmitting / receiving unit. E-mail delivery system. A merchandise related information table section between stores that assigns a unique preference ID to the preference and stores the merchandise numbers of the merchandise handled by a plurality of virtual stores included in the preference ID;
A user analysis information database storing a product number included in an e-mail magazine transmitted corresponding to a user ID, presence / absence of a response to the e-mail magazine, and preference information;
An electronic commerce product data section for storing information of a plurality of products to which the product number is assigned;
A mail pattern table storing a plurality of pieces of text information of the e-mail magazine;
An access log storage unit for storing response information indicating that the user has viewed the product information stored in the electronic commerce product data unit;
A mail transmission / reception unit for transmitting / receiving the mail magazine to / from a plurality of user terminals, and uniquely assigns a product number to a plurality of products handled by a plurality of virtual stores, and electronically transmits the plurality of products to the plurality of user terminals via the Internet network. An e-mail delivery method in an e-commerce computer comprising a computer for sending by e-mail magazine,
In the computer,
A first step of extracting a product number of a product to be advertised from the electronic commerce data part;
Based on the product number extracted in the first step, product information is extracted from the electronic commerce product data part, and specified mail text information is extracted from the mail pattern table, and the extracted product is displayed in the extracted mail text. A second step of creating an e-mail magazine for a primary action combining information;
A third step in which the e-mail magazine created in the second step is transmitted to the e-mail address extracted from the user information database by the mail transmitting / receiving unit;
Among users who have sent an e-mail magazine in the third step with reference to the access log storage unit after a predetermined period of time has passed since the e-mail magazine was sent in the third step, no response information is stored A fourth step of extracting the ID;
The product information extracted in the first step and the mail text information specified from the mail pattern table are extracted, and an e-mail magazine for a secondary action is created by combining the extracted product information with the extracted mail text. And a fifth step to
A sixth step in which the e-mail magazine created in the fifth step is transmitted to the e-mail address of the user ID extracted in the fourth step by the mail transmitting / receiving unit;
Among users who have sent an e-mail magazine in the sixth step with reference to the access log storage unit after a predetermined period has passed since the e-mail magazine was sent in the sixth step, no response information is stored A seventh step of extracting an ID;
Based on the product number of the product information included in the e-mail magazine transmitted in the seventh step, another product number assigned with the same preference ID as the product number is extracted from the inter-shop product related information table unit. 8 steps,
Based on the other product number extracted in the eighth step, the other product information is extracted from the electronic commerce product data part, and the mail text information designated from the mail pattern table is extracted, and the extracted mail text includes the second product information. In electronic commerce, an electronic mail magazine is created by combining the product information extracted in step 7, and the electronic mail magazine is transmitted to the mail address extracted in step 7 by the mail transmitting / receiving unit. E-mail delivery method.

Images