JP2012078963A - Applicable campaign retrieval device, applicable campaign retrieval method, program and information recording medium - Google Patents

Abstract

An object of the present invention is to efficiently search for a suitable campaign for a plurality of orders.
A campaign information management device stores, for each of one or a plurality of purchase campaigns, a purchase condition related to a combination of a plurality of purchases to which the purchase campaign is associated, and stores a plurality of orders associated with the user. Obtaining identification information, obtaining purchased product information respectively associated with the plurality of order identification information, and indicating the plurality of order identification information based on the purchased product information respectively associated with the plurality of order identification information Search for purchase campaigns associated with purchase conditions that match multiple purchases.
[Selection] Figure 2

Description

  The present invention relates to a compatible campaign search device, a compatible campaign search method, a program, and an information recording medium.

  In order to encourage users to purchase products on e-commerce sites, such as increasing the number of points obtained at the time of product purchase, or reducing the delivery fee of products when purchasing products over a certain amount, etc. A campaign may be hit (see, for example, Patent Document 1 below). Conventionally, an administrator creates a search query according to the application conditions of a campaign, and uses the created search query to search for information on orders that match the campaign from a database in which a purchase history is accumulated.

Japanese Patent Laid-Open No. 2002-157489

  However, since the application conditions differ for each campaign, it takes time to create a search query for each campaign. In addition, when the conditions are set so that the user meets the campaign by multiple orders satisfying a given condition, the search becomes complicated, so the amount of purchase history data accumulated in the database is enormous. If so, the processing load becomes extremely large.

  The present invention has been made in view of the above problems, and an object of the present invention is to provide a compatible campaign search device, a compatible campaign search method, a program, and an information record that can efficiently search for a campaign that matches a plurality of orders. To provide a medium.

  In order to achieve the above object, the suitable campaign search device according to the present invention stores, for each one or a plurality of purchase campaigns, the purchase conditions relating to a combination of a plurality of purchases to which the purchase campaign is associated in association with each other. Order identification information acquisition means for acquiring a plurality of order identification information associated with the user, purchase product information acquisition means for acquiring purchase product information respectively associated with the plurality of order identification information, and the plurality of orders Search means for searching for a purchase campaign associated with purchase conditions suitable for a plurality of purchases indicated by the plurality of order identification information based on purchase product information respectively associated with the identification information. And

  In one aspect of the present invention, the storage unit further stores profit information applied by the purchase campaign for each of the one or more purchase campaigns, and the conforming campaign search device includes the plurality of order identification information. In addition, it further includes profit information storage means for associating and storing the application result of profit associated with the campaign searched by the search means.

  In one aspect of the present invention, the profit is information indicating a return ratio with respect to a purchase amount, and the conforming campaign search device is configured to purchase each piece of purchased product information associated with the order identification information for each of the plurality of order identification information. And calculating means for calculating a sum of points obtained by multiplying the purchase amount of money by a return ratio associated with the campaign searched by the search means, and the profit information storage means for each of the plurality of order identification information Assume that the sum of points calculated by the above is stored in association.

  In one aspect of the present invention, the profit information storage unit stores, for each of the plurality of order identification information, the calculated sum of points and an update date and time associated with each other, and the conforming campaign search device includes the plurality of order identification information. And adding means for giving the sum of points associated with the latest update date and time for each of the plurality of order information identification information in the profit information storage means to the user associated with the order identification information.

  In one aspect of the present invention, the purchase condition includes an effective period, and the granting unit is a user associated with the plurality of order identification information after the effective period included in the purchase condition has elapsed. In addition, a sum of points associated with the latest update date and time is assigned to each of the plurality of order information identification information in the profit information storage means.

  In one aspect of the present invention, the conforming campaign search device further includes accepting means for accepting purchase conditions of the one or more purchase campaigns, and the storage means stores the accepted purchase campaign and the purchase conditions in association with each other. I decided to.

  The conforming campaign search method according to the present invention relates to a step of associating and storing in a storage means purchase conditions relating to a combination of a plurality of purchases to which the purchase campaign matches for each one or a plurality of purchase campaigns, and linking to a user Order identification information acquisition step for acquiring a plurality of order identification information, purchase product information acquisition step for acquiring purchase product information respectively associated with the plurality of order identification information, and association with the plurality of order identification information, respectively. And a search step for searching for a purchase campaign associated with purchase conditions suitable for a plurality of purchases indicated by the plurality of order identification information based on the purchased product information.

  The program according to the present invention includes, for each one or a plurality of purchase campaigns, a storage unit that associates and stores purchase conditions related to a combination of a plurality of purchases to which the purchase campaign matches, and a plurality of order identifications associated with the user. Order identification information acquisition means for acquiring information, purchase product information acquisition means for acquiring purchase product information respectively associated with the plurality of order identification information, and purchase product information respectively associated with the plurality of order identification information A program for causing a computer to function as search means for searching for a purchase campaign associated with purchase conditions that match a plurality of purchases indicated by the plurality of order identification information.

  The information recording medium according to the present invention includes, for each of one or a plurality of purchase campaigns, a storage unit that associates and stores purchase conditions related to a combination of a plurality of purchases to which the purchase campaign matches, and a plurality of items associated with the user. Order identification information acquisition means for acquiring order identification information, purchase product information acquisition means for acquiring purchase product information associated with each of the plurality of order identification information, and purchase commodity associated with the plurality of order identification information An information recording medium recording a program for causing a computer to function as a search means for searching for a purchase campaign associated with purchase conditions suitable for a plurality of purchases indicated by the plurality of order identification information based on the information. .

  According to one aspect of the present invention, it is possible to efficiently search for a campaign that matches a plurality of orders.

It is a system configuration figure of a purchase information processing system. It is a functional block diagram of a campaign information management device. It is a figure which shows an example of the registration screen of campaign information. It is a figure which shows an example of the registration screen of campaign information. It is a figure which shows an example of the registration screen of campaign information. It is a figure which shows an example of a campaign condition table. It is a figure which shows an example of a campaign condition table. It is a figure which shows an example of a campaign profit table. It is a figure which shows an example of a purchase merchandise information table. It is a figure which shows an example of an order information table. It is a figure which shows an example of a suitable campaign information table. It is a figure which shows an example of the return profit information table. It is a flowchart explaining flows, such as a search process of a conformity campaign. It is a figure which shows an example of a purchase merchandise information table. It is a figure which shows an example of an order information table. It is a figure which shows an example of a suitable campaign information table. It is a figure which shows an example of the return profit information table. It is a figure which shows an example of a purchase merchandise information table. It is a figure which shows an example of an order information table. It is a figure which shows an example of a suitable campaign information table. It is a figure which shows an example of a suitable campaign information table. It is a figure which shows an example of the return profit information table.

  Hereinafter, embodiments for carrying out the present invention (hereinafter referred to as embodiments) will be described with reference to the drawings.

  In FIG. 1, the system block diagram of the purchase information processing system 1 which concerns on this embodiment was shown. As shown in FIG. 1, the purchase information processing system 1 according to the present embodiment includes a purchase information management device 3, a campaign information registration device 5, and a campaign information management device 10, and includes a purchase information management device 3, a campaign information registration device. 5. The campaign information management devices 10 are connected to each other via the network 7 so as to be able to communicate with each other.

  The purchase information management apparatus 3 is a database server that manages information (purchased product information) of products purchased by the user in online shopping performed via a virtual shopping mall server (not shown). For example, the purchased product information includes product information related to purchase (including product identification information and product price information), order identification information for identifying an order related to the purchase, store information for selling the product, and delivery of the product. Information, and the date of receipt of the order.

  The campaign information registration device 5 is a computer for registering information on a campaign (purchasing campaign) executed in the virtual shopping mall server. The campaign in the present embodiment is a sales promotion activity that provides a predetermined profit to the user when the purchase of the user matches a predetermined purchase condition. As an example of purchase conditions, shopping at a specified store within a specified period, buying a specified product within a specified period, and shopping over a specified amount within a specified period And so on. In addition, as an example of the profit of the campaign, the points given for the purchase amount related to the user's order are multiplied by N times as usual, the user is given a certain amount of points, For example, free shipping.

  The campaign information registration device 5 registers campaign information including the name of the campaign, purchase conditions for applying the campaign, profits of the campaign, and the like in the campaign information management device 10. The campaign information registration device 5 may be an information terminal handled by a provider of a service by a virtual shopping mall server or a store opening company that opens a store in the virtual shopping mall server.

  The campaign information management device 10 manages the campaign information registered by the campaign information registration device 5, acquires the purchase merchandise information managed by the purchase information management device 3, and searches for a campaign that matches each user order. Computer. Hereinafter, an example of functions provided in the campaign information management apparatus 10 will be described in detail.

  FIG. 2 shows a functional block diagram of the campaign information management apparatus 10. As shown in FIG. 2, the campaign information management apparatus 10 includes a campaign information receiving unit 100, a campaign information storage unit 102, a purchased product information acquisition unit 104, a purchased product information storage unit 106, an order information specifying unit 108, and an order information storage. Unit 110, suitable campaign search unit 112, suitable campaign information storage unit 114, return profit determination unit 116, return profit information storage unit 118, and return profit provision unit 120.

  The function of each unit provided in the campaign information management apparatus 10 is as follows. A computer including hardware such as a control unit such as a CPU, a storage unit such as a memory, and a communication unit such as a communication interface for transmitting and receiving data to and from an external device It may be realized by reading and executing a program stored in a readable information storage medium. The program may be supplied to the campaign information management apparatus 10 by an information storage medium such as an optical disk, a magnetic disk, a magnetic tape, a magneto-optical disk, a flash memory, or the campaign information via a data communication network such as the Internet. It may be supplied to the management apparatus 10.

  The campaign information receiving unit 100 receives campaign information including a campaign name, purchase conditions for applying the campaign, and profits of the campaign. For example, the campaign information receiving unit 100 may receive the campaign information transmitted from the campaign information registration device 5, or the campaign information based on an input from an input device such as a keyboard connected to the campaign information management device 10. It is good also as accepting. Specifically, the campaign information receiving unit 100 receives campaign information based on, for example, data input on the information registration screen shown below.

  FIG. 3A shows an example of a campaign information registration screen. In the example of the registration screen shown in FIG. 3A, the campaign name, the point return rate (profit information indicating the point return ratio with respect to the purchase amount), the number of return points (profit information indicating the number of points to be returned), and free shipping (free shipping) Profit information indicating whether or not to make free), fund bearer (information identifying the source of the fund of profit applied by the campaign), campaign period (condition information indicating the campaign implementation period), target store (campaign Condition information indicating the target store), target product ID (condition information indicating the target product of the campaign), application amount (condition information indicating the range of purchase amount necessary for applying the campaign), device (online shopping) Condition information specifying the conditions of the device used), payment method (condition information specifying the payment method), member rank ( It includes the input field of condition information) that specifies the member rank of Za. In order to increase the input fields for the campaign period and the target product, an additional button displayed on the right side of each item is pressed. An item for which all is entered in the input field indicates that no condition is set, and an item whose check box is checked indicates that the item is a condition.

  In the example shown in FIG. 3A, if the store shop 0030 purchases 2000 yen or more via a mobile (portable terminal) by 20:00 to 23:59 in the period 2010/8/23, points are given for the purchase price. This represents a campaign that applies a reduction rate of 5% (5 times the points). It should be noted that the share of the store clerk determined as the resource bearer may be the amount obtained by subtracting the normal point share (for example, 1%) of the service provider from 5% of the point return rate (for example, 4%). In the present embodiment, such a campaign that allows the user to satisfy the conditions with one order is managed using an identifier called SID (single order ID).

  FIG. 3B shows an example of a campaign information registration screen. In the example shown in FIG. 3B, on every Monday in August 2010, the target products item0010, item0011, item0012, item0020, and item0021 are credit cards via mobile (portable terminal) for 500 yen or more. Represents a campaign that applies a point return rate of 3% (three times the points) to the purchase amount. In addition, when the fund bearer is a service provider, 3% of the point return rate becomes the share as it is.

  FIG. 3C shows an example of a campaign information registration screen. In the example shown in FIG. 3C, if an arbitrary store and an arbitrary product are purchased from both a PC and a mobile terminal (mobile) for 6 days from 10:00 of 2010/8/24, This represents a campaign that applies a 4% point reduction rate (4 times the points). SID0003 defines conditions related to purchase with a PC, and SID0004 defines conditions related to purchase with a portable terminal, and the point return rate is set to 2% (point double). In the present embodiment, such a campaign that is conditional on the user placing multiple orders is managed using an identifier called MID (multi-order ID). When a plurality of SIDs are associated with a campaign identified by MID, a combination of orders satisfying the purchase conditions identified by each SID and an order satisfying the purchase conditions identified by MID are performed. Will be imposed as a condition. For example, in the example of FIG. 3C, in order to satisfy MID0001 for identifying the campaign registered in FIG. 3C, for example, an order satisfying SID0003 (order by PC) and an order satisfying SID0004 (order by portable terminal) Then, an order satisfying MID0001 is required (order of 100 yen or more for 6 days from 10:00 on 2010/8/24).

  The campaign information storage unit 102 stores the campaign information received by the campaign information receiving unit 100. 4A, 4B, and 5 show an example of data stored in the campaign information storage unit 102. FIG.

  FIG. 4A shows an example of a campaign condition table stored in the campaign information storage unit 102. FIG. 4A shows an example of a campaign condition table related to a single order. Each of the SID includes a campaign name, a campaign period, a target product, a target store, an applied amount, a (member) rank, a device, a payment method, and an update date and time. Items are stored in association with each other.

  FIG. 4B shows an example of a campaign condition table stored in the campaign information storage unit 102. FIG. 4B shows an example of a campaign condition table related to multi-order. MID includes a campaign name, (campaign) period, target product, target store, application amount, (member) rank, device, payment method, SID, Each item of update date is stored in association with each other. In the campaign condition table, the condition information included in the campaign information may be extracted and stored.

  FIG. 5 shows an example of the campaign profit table stored in the campaign information storage unit 102. As shown in FIG. 5, in the campaign profit table, items such as a point return rate (or point multiplying factor), the number of return points, free shipping, a fund bearer, and an update date are stored in association with the campaign identification information. . The profit related to the campaign is not limited to the contents described above, and may include other contents. In the campaign profit table, profit information included in the campaign information may be extracted and stored.

  The campaign information stored in the campaign information storage unit 102 may be updated. For example, an update may be accepted during the campaign validity period, or an update that extends the campaign validity period may be accepted. In addition, not all the campaign information can be updated, but information that is disadvantageous for the user, such as reducing the point return rate, may be restricted so that it cannot be updated.

  The purchased product information acquisition unit 104 acquires purchased product information related to each product purchased from the purchase information management device 3. For example, the purchase merchandise information acquisition unit 104 may designate a store and inquire the purchase information management apparatus 3 to obtain the purchase product information about the designated store. Further, the purchased product information acquisition unit 104 may refer to the update date and time of the already acquired purchased product information and acquire the purchased product information added or updated in the purchase information management device 3 after the update date and time.

  The purchased product information storage unit 106 stores the purchased product information acquired by the purchased product information acquisition unit 104.

  FIG. 6 shows an example of a purchased product information table stored in the purchased product information storage unit 106. The example of the purchased product information table shown in FIG. 6 includes product identification information (product ID), update date and time of an order related to the product, order identification information (order ID) for identifying an order related to the product, Stored shop information, order date and time, merchandise value, and purchase quantity related to the product are associated with each other.

  The order information specifying unit 108 specifies all the purchased product information linked to the order identification information based on the order identification information linked to the purchased product information acquired by the purchased product information acquiring unit 104. For example, the order information specifying unit 108 makes an inquiry to the purchase information management apparatus 3 using the order identification information associated with the purchase product information acquired by the purchase product information acquisition unit 104 as a key, and purchases associated with the order identification information. Product information may be acquired, or purchased product information associated with the order identification information may be acquired from the purchased product information storage unit 106.

  The order information storage unit 110 stores the order identification information specified by the order information specifying unit 108 in association with the information on the purchased product linked to the order identification information.

  FIG. 7 shows an example of an order information table stored in the order information storage unit 110. In the example of the order information table shown in FIG. 7, order identification information for identifying an order, identification information (user ID) of a user who has placed the order, update date and time of the order, and product identification information for identifying a purchased product (Product ID), order date and time for the product, and each item of the device (PC or mobile) that placed the order are associated and stored.

  The matching campaign search unit 112 searches for a matching campaign from the campaign information storage unit 102 based on each purchased product information associated with the order identification information specified by the order information specifying unit 108. In addition, the matching campaign search unit 112 may search for a matching campaign for each of the purchased product information acquired by the purchased product information acquisition unit 104. Hereinafter, the process performed by the suitable campaign search part 112 is demonstrated concretely.

  First, a process for searching for a suitable campaign from single-order campaigns based on each purchased product information associated with the order identification information specified by the order information specifying unit 108 will be described.

  The matching campaign search unit 112 searches for purchase conditions satisfied by each purchased product information linked to the order identification information from the purchase conditions for the single order campaign stored in the campaign information storage unit 102, Campaign identification information (SID) associated with the searched purchase condition is obtained. Searching for purchase conditions may be performed by searching for purchase conditions that are satisfied by any purchase product information, and by searching for purchase conditions that are satisfied by the accumulation of each purchase product information (for example, the sum of purchase amounts). For example, when searching for purchase conditions satisfying a given purchase product information (product information = ITEM1, store information = SHOP1, purchase date = TIME1,..., Etc.), “Product information includes ITEM1 and stores It can be realized by an SQL statement that searches for “Purchase conditions including SHOP1 in the information, TIME1 in the validity period, and including ...”, and the SQL statement is the purchase information in the template variable of the SQL statement generated in advance. Therefore, it is not necessary to generate an SQL sentence for each campaign.

  Next, a process for searching for a suitable campaign from among multi-order campaigns based on each purchased product information associated with the order identification information specified by the order information specifying unit 108 will be described. When searching for a multi-order campaign, each piece of purchased product information for a plurality of order identification information is required. Therefore, the order information specifying unit 108 identifies the user identification associated with the already specified order identification information. Using the information (user ID) as a key, from the purchased product information storage unit 106 or the purchase information management device 3, the order identification information having the same user identification information is acquired, and the purchased product information associated with each order identification information. To get.

  For each order identification information, the conforming campaign search unit 112 retrieves a conforming campaign (SID) from single order campaigns based on each purchased product information associated with the order identifying information. This process is as described above. Next, the matching campaign search unit 112 specifies an MID that includes the SID searched for each order identification information as a condition, and extracts a common MID from the specified MID. Then, the matching campaign search unit 112 determines whether or not the common MID condition is satisfied based on the order identification information from which the common MID is extracted, and obtains the MID satisfying the condition as a search result. The determination as to whether or not the MID condition is satisfied may be, for example, that all the SID conditions associated with the MID are satisfied, and that the condition defined in the MID is satisfied. With the above processing, the matching campaign search unit 112 searches for MIDs related to multi-order campaigns that satisfy the purchase of a given user.

  The compatible campaign information storage unit 114 stores information on the campaign searched by the compatible campaign search unit 112.

  FIG. 8 shows an example of the compatible campaign information table stored in the compatible campaign information storage unit 114. In the compatible campaign information table shown in FIG. 8, the identification information (product ID) of the purchased product is associated with the update date / time related to the product order, the corresponding campaign ID (SID, MID), and the campaign update date / time. Is done. In the example shown in FIG. 8, it is assumed that ITEM 5 is compatible with the SID0003 campaign.

  The return profit determination unit 116 determines the profit to be returned to the user associated with the order identification information based on the profit determined for the campaign that matches the order identification information. For example, the return profit determination unit 116 refers to the profit from the campaign profit table stored in the campaign information storage unit 102 for the campaign ID corresponding to each product stored in the conforming campaign information storage unit 114, and for each product. Determine the return to the user. Specifically, the return profit determination unit 116 calculates the points for the product as the sum of the purchase amount of the product and the point return rate determined for the campaign to which the product corresponds. Based on the examples of FIGS. 5, 6, and 8, since SID0003 has a point reduction rate of 2% (double points), the return profit to the user for PN-03 is 100 * 10 * 0.02 = 20 points. In addition, when there are a plurality of fund bearers of the campaign, the share for each fund bearer may be calculated.

  The return profit information storage unit 118 stores information on the return profit determined by the return profit determination unit 116 for each order identification information.

  FIG. 9 shows an example of the return profit information table stored in the return profit information storage unit 118. In the example of the return profit information table shown in FIG. 9, a campaign that identifies an order identification information (order ID) for identifying an order, an update date and time related to the order, points, whether or not free shipping, and a campaign that matches the order. Items such as ID are stored in association with each other.

  For each order identification information, the return profit giving unit 120 gives the return profit stored in the return profit information storage unit 118 for the order identification information to the user associated with the order identification information. For example, the return profit granting unit 120 updates the return profit (for example, points) stored for the order identification information of the order when the order is confirmed and the valid period of the applicable campaign for the order ends. The latest date may be given to the user associated with the order.

  Next, referring to the flowchart shown in FIG. 10, the flow of the matching campaign search process performed by the campaign information management apparatus 10 will be described. In the flow in FIG. 10, it is assumed that the processing is executed when the order content that has already been received (the state shown in FIGS. 6 and 7) is changed or added.

  As shown in FIG. 10, the campaign information management apparatus 10 accesses the purchase information management apparatus 3 and acquires the purchased product information updated from the purchased product information stored in the purchased product information storage unit 106 (S1001). ). The campaign information management apparatus 10 stores the acquired purchased product information in the purchased product information storage unit 106 (S1002). In the example of this flow, it is assumed that purchased product information related to ITEM06 is acquired and added to the purchased product information storage unit 106 and stored.

  FIG. 11 shows an example of the purchased product information table updated in S1002. As shown in FIG. 11, a record related to ITEM06 is added to the purchased merchandise information table, and for this record, ITEM06 is additionally ordered to 2010/8/26 for order identification information PN-03, and 2010/8 / 28 stores information indicating that the data has been updated.

  The campaign information management apparatus 10 aggregates and stores in the order information storage unit 110 the purchased product information that has the same order identification information associated with the acquired purchased product information (S1003).

  FIG. 12 shows an example of the order information table updated in S1003. As shown in FIG. 12, records of ITEM05 and ITEM06 associated with PN-03 are added to the order information table.

  The campaign information management device 10 searches for a suitable campaign for each purchased product information having common order identification information based on the purchase conditions stored in the campaign information storage unit 102 (S1004), and identifies the searched campaign. The identification information (SID) is stored in the compatible campaign information storage unit 114 (S1005).

  FIG. 13 shows an example of the compatible campaign information table updated in S1005. As shown in FIG. 13, a record of a campaign SID0003 that satisfies the purchase of ITEM06 is added to the compatible campaign information table.

  The campaign information management device 10 acquires the purchase amount stored for the product ID and the point return rate determined for the campaign ID using the product ID stored in the compatible campaign information storage unit 114 and the campaign ID as keys. The sum of the value obtained by multiplying the purchase amount and the point return rate is calculated to calculate the points for the order identification information (S1006). The campaign information management apparatus 10 stores the points calculated for the order identification information in the return profit information storage unit 118 (S1007).

  FIG. 14 shows an example of the return profit information table updated in S1007. As shown in FIG. 14, a record storing points newly calculated by adding ITEM06 to PN-03 is added to the return profit information table. The newly calculated point is (100 * 10 + 400 * 5) * 0.02 = 60 points. In the example shown in FIG. 14, a record for storing a newly calculated point for PN-03 is added, but the number of points in the record for an existing PN-03 is overwritten with the newly calculated point. You may do it. Also, here, the points are newly calculated by adding ITEM06, but 2010/8/25 which is the update date of PN-03 in FIG. 14 and the order of ITEM06 associated with PN-03 in FIG. The date may be newly calculated only when the date is compared with 2010/8/26 and the order date is later.

  Next, the campaign information management device 10 accesses the purchase information management device 3 and acquires purchase product information related to the newly added order from the purchase product information stored in the purchase product information storage unit 106 (S1008). ). The campaign information management apparatus 10 stores the acquired purchased product information in the purchased product information storage unit 106 (S1009). In the example of this flow, it is assumed that purchased product information related to ITEM07 purchased in a new order PN-04 is acquired and additionally stored in the purchased product information storage unit 106.

  FIG. 15 shows an example of the purchased product information table updated in S1009. As shown in FIG. 15, a record related to ITEM07 is added to the purchased merchandise information table, and ITEM07 is purchased on 2010/8/27 when the order identification information is PN-04, and 2010/8/29 Stores information indicating that the data has been registered.

  The campaign information management apparatus 10 aggregates and stores in the order information storage unit 110 the purchased product information having the same order identification information associated with the acquired purchased product information (S1010).

  FIG. 16 shows an example of the order information table updated in S1010. As shown in FIG. 16, an ITEM07 record linked to PN-04 is added to the order information table. Note that PN-04 is an order placed by a mobile (portable device) on 2010/8/29.

  The campaign information management device 10 searches for a suitable campaign for each purchased product information having common order identification information based on the purchase conditions stored in the campaign information storage unit 102 (S1011), and identifies the searched campaign. The identification information (SID) is stored in the compatible campaign information storage unit 114 (S1012).

  FIG. 17 shows an example of the compatible campaign information table updated in S1012. As shown in FIG. 17, a record of a campaign SID0004 that satisfies the purchase of ITEM07 is added to the compatible campaign information table.

  The campaign information management apparatus 10 is based on the identification information (SID) of a single-order campaign that satisfies each of a plurality of orders having the same user ID (PN-03 and PN-04 in the examples of FIGS. 15 to 17). The identification information (MID) of the included multi-order campaign is searched (S1013). Then, the campaign information management apparatus 10 determines whether or not a plurality of orders with a common user ID are satisfied for the searched MID condition (S1014), and if satisfied (S1014: Y), The retrieved MID is stored in the compatible campaign information storage unit 114 (S1015). If the MID condition is not satisfied (S1014: N), the process proceeds to S1018.

  FIG. 18 shows an example of the compatible campaign information table updated in S1015. As shown in FIG. 18, SID-03 satisfies SID0003 and PN04 satisfies SID0004, and PN-03 and PN-04 are orders within the campaign period of MID0001, and other conditions defined in MID0001 are satisfied. In order to satisfy, each product purchased in PN-03 and PN-04 is determined to satisfy the campaign MID0001. Therefore, a record of campaign MID0001 that satisfies the purchase of ITEM05, ITEM06, and ITEM07 is added to the compatible campaign information table.

  The campaign information management device 10 acquires the purchase amount stored for the product ID and the point return rate determined for the campaign ID using the product ID stored in the compatible campaign information storage unit 114 and the campaign ID as keys. The sum of the value obtained by multiplying the purchase amount and the point return rate is calculated to calculate the points for the order identification information (S1016). The campaign information management apparatus 10 stores the points calculated for the order identification information in the return profit information storage unit 118 (S1017).

  FIG. 19 shows an example of the return profit information table updated in S1017. As shown in FIG. 19, a record storing points newly calculated when PN-03 satisfies MID0001 is added to the return profit information table. Since the point reduction rate determined for MID0001 is 4%, the newly calculated point for PN-03 is (100 * 10 + 400 * 5) * 0.04 = 120 points. Furthermore, a record storing points newly calculated when PN-04 satisfies MID0001 is added to the return profit information table. The point calculated for PN-04 is 3000 * 1 * 0.04 = 120 points.

  When the campaign period defined for the campaign ends (S1018: Y), the campaign information management device 10 gives the user points calculated based on the campaign (S1019), and ends the process. For example, according to the example described in this flowchart, after the campaign period (2010/8/24, 10: 00 to 2010/8/30, 9:59) defined in the campaign MID0001 ends (for example, 2010/8). / 31,00: 00, etc.), 120 points based on PN-03 and 120 points based on PN-04 are given to user U0001.

  Although not shown in this flowchart, when an order is canceled before the points are given, a new record is created with 0 points for the identification information (order ID) of the canceled order and returned. It may be added to the profit information table. Hereinafter, a specific example will be described. The campaign information management apparatus 10 is, for example, after the campaign period defined in the campaign MID0001 has ended (for example, 2010/8/30, 12:00, etc.) and the order PN-04 is canceled before the points are given Then, a record with order ID = PN-04 in the return profit information table is specified. Next, the identified record and the record having the same campaign ID and update date (update date = 2010/8/29) are specified. Specifically, regarding the two records specified above, when a record that is the update date and time immediately before the latest is searched in the return profit information table, the order PN-03 and the update date and time = 2010/8/29 are obtained. Only certain records are extracted. Here, the extracted record is copied and added as a record in which the update date and time is rewritten to 2010/8/30, 12:00. For the order PN-04 for which there is no record that is the update date one before the latest, the record related to the order PN-04 is copied, the update date is 2010/8/30, 12:00, and the point is set to 0 Add as a rewritten record. In this way, when an order is canceled, information with an old update date and time is reused and registered as the latest information. Of course, the processing when an order is canceled is not limited to that described above, and a record including identification information (order ID) of the canceled order may be deleted from the return profit information table.

  According to the campaign information management device 10 described above, conditions are registered in advance for each campaign, and a search is made for a suitable campaign based on purchased product information linked to the order identification information. Compared with the case where a SQL is created based on this and the purchase history that matches the campaign is searched using the created SQL, it is possible to efficiently search for a campaign that matches each order. Also, it is possible to save the trouble of creating the SQL for each campaign.

  Further, according to the campaign information management device 10, order identification information associated with the purchase product information is obtained using one purchase product information as a key, and further associated with the order identification information using the order identification information as a key. Even if a large amount of data is stored in the database of purchased merchandise information by acquiring all purchased merchandise information and searching for a satisfying campaign based on the acquired purchased merchandise information. It is possible to quickly obtain campaign information that matches the purchased product information. Furthermore, by processing as described above, even if there are a plurality of campaigns that match the order, information on these campaigns can be quickly retrieved.

  Further, according to the campaign information management apparatus 10, even for a campaign that matches a plurality of orders, an SQL is created based on the campaign conditions, and a purchase history that matches the campaign is searched using the created SQL. , You can search efficiently.

  The present invention is not limited to the above embodiment. For example, in the above-described embodiment, one of a plurality of stores is selected, and campaign search processing and profit determination processing are not processed for the selected store based on purchase merchandise information about the selected one store. After sequentially executing until there is no purchased merchandise information, another store may be selected and the same processing may be repeated.

  The timing for starting a series of processes performed in each of the purchased product information acquisition unit 104, the order information identification unit 108, the matching campaign search unit 112, and the return profit determination unit 116 may be a predetermined timing. It may be the timing requested by the administrator or the like, or may be a timing according to a predetermined time interval, or the purchase information management apparatus 3 detects that the purchased product information has been updated. The timing may not be particularly limited. In addition, the processing of each part of the purchased product information acquisition unit 104, the order information identification unit 108, the conforming campaign search unit 112, and the return profit determination unit 116 does not necessarily have to be continuously executed, and the processing start timing is designated for each. It is good. For example, the matching campaign search unit 112 may execute a search at a timing after the order is confirmed, or may execute a search at a timing after the campaign information is updated, and is not particularly limited.

  Further, in the above embodiment, every time purchase product information is acquired by the purchase product information acquisition unit 104, a search for a suitable campaign for the purchase product information is performed, and purchase product information is aggregated based on the order identification information. In addition, it may be possible to search for a more suitable campaign based on the sum of purchase amounts based on the aggregated purchase merchandise information.

  DESCRIPTION OF SYMBOLS 1 Purchasing information processing system, 3 Purchasing information management apparatus, 5 Campaign information registration apparatus, 7 Network, 10 Campaign information management apparatus, 100 Campaign information reception part, 102 Campaign information storage part, 104 Purchasing merchandise information acquisition part, 106 Purchasing merchandise information Storage unit 108 Order information specifying unit 110 Order information storage unit 112 Matching campaign search unit 114 Matching campaign information storage unit 116 Return profit determination unit 118 Return profit information storage unit 120 Return profit granting unit

Claims (9)

Storage means for associating and storing, for each one or a plurality of purchase campaigns, purchase conditions relating to a combination of a plurality of purchases to which the purchase campaign matches;
Order identification information acquisition means for acquiring a plurality of order identification information linked to a user;
Purchased product information acquisition means for acquiring purchased product information associated with each of the plurality of order identification information,
Search means for searching for a purchase campaign associated with purchase conditions suitable for a plurality of purchases indicated in the plurality of order identification information, based on purchase product information respectively associated with the plurality of order identification information;
A conforming campaign search device comprising: The storage means further stores profit information applied by the purchasing campaign for each of the one or more purchasing campaigns,
The conforming campaign search device includes:
The conforming campaign search according to claim 1, further comprising profit information storage means for associating and storing a profit application result associated with the campaign searched by the search means for each of the plurality of order identification information. apparatus. The profit is information indicating a return ratio with respect to the purchase amount,
The conforming campaign search device includes:
A calculating means for calculating, for each of the plurality of order identification information, a sum of points obtained by multiplying a purchase amount of each purchased product information linked to the order identification information by a return ratio associated with the campaign searched by the search means; Including
The conformity campaign search device according to claim 2, wherein the profit information storage means stores a sum of points calculated by the calculation means in association with each of the plurality of order identification information. The profit information storage means stores, for each of the plurality of order identification information, the sum of the calculated points and an update date and time associated with each other,
The conforming campaign search device includes:
The information processing device further includes a granting unit for granting a user associated with the plurality of order identification information to a sum of points associated with the latest update date and time for each of the plurality of order information identification information in the profit information storage unit. The compatible campaign search device according to claim 3. The purchase conditions include a validity period,
The granting unit updates the latest information on each of the plurality of order information identification information in the profit information storage unit to a user associated with the plurality of order identification information after the validity period included in the purchase condition has elapsed. The conformity campaign search device according to claim 4, wherein a sum of points associated with date and time is given. Further comprising a receiving means for receiving the purchase conditions of the one or more purchase campaigns,
The conforming campaign search device according to claim 1, wherein the storage unit stores the accepted purchase campaign and purchase conditions in association with each other. Storing for each one or a plurality of purchase campaigns, in a storage means, the purchase conditions relating to a combination of a plurality of purchases to which the purchase campaign matches;
Order identification information acquisition step for acquiring a plurality of order identification information linked to the user;
A purchased product information acquisition step for acquiring purchased product information associated with each of the plurality of order identification information,
A search step of searching for a purchase campaign associated with purchase conditions that match a plurality of purchases indicated in the plurality of order identification information based on purchase product information respectively associated with the plurality of order identification information;
A conforming campaign search method characterized by including: Storage means for associating and storing, for each one or a plurality of purchase campaigns, purchase conditions relating to a combination of a plurality of purchases to which the purchase campaign matches;
Order identification information acquisition means for acquiring a plurality of order identification information linked to a user;
Purchased product information acquisition means for acquiring purchased product information associated with each of the plurality of order identification information,
A computer as a search means for searching for a purchase campaign associated with purchase conditions suitable for a plurality of purchases indicated by the plurality of order identification information based on purchase product information respectively associated with the plurality of order identification information. A program to make it work. Storage means for associating and storing, for each one or a plurality of purchase campaigns, purchase conditions relating to a combination of a plurality of purchases to which the purchase campaign matches;
Order identification information acquisition means for acquiring a plurality of order identification information linked to a user;
Purchased product information acquisition means for acquiring purchased product information associated with each of the plurality of order identification information,
A computer as a search means for searching for a purchase campaign associated with purchase conditions suitable for a plurality of purchases indicated by the plurality of order identification information based on purchase product information respectively associated with the plurality of order identification information. An information recording medium on which a program for functioning is recorded.

Images