JP4972574B2 - Providing content linkage information to railway users - Google Patents

Description

  The present invention relates to a technique for distributing information to railway users. In particular, identify content such as advertisements that rail users may have contacted in spaces managed by railway operators (stations such as ticket gates, concourses, and platforms, and trains). It relates to technology that provides related information.

  Conventionally, a technique disclosed in Patent Document 1 has been proposed as a technique related to an information distribution apparatus for railway users. In Patent Document 1, the information distribution apparatus previously extracts distribution information to be distributed for each user and stores it in the extracted information storage means. Therefore, when the identification code transmitted from the identification code reading apparatus is received. The distribution information can be sent to the user immediately. Therefore, it is possible to shorten the time until the distribution information is transmitted to the user. For example, the distribution information can be distributed to the user who enters the station before the user gets on the train.

International Publication WO2002 / 033609 Pamphlet

  However, in Patent Document 1, only information distribution based on the time of entering and exiting a station is considered. Therefore, based on the travel route of the railway user, content such as advertisements that the railroad user may have contacted in the space managed by the railway operator (stations such as ticket gates, concourses, platforms, and trains) And providing information related to the identified content was not considered.

  Therefore, in the present invention, based on the entrance / exit information of the ticket gate stored in the IC card ticket of the railway user, the purchase information of the product etc. in the station, and the standard travel time in the station stored in the database, Identify the user's travel route. For this purpose, first, the candidates for the movement route are narrowed down based on the entry / exit information of the ticket gate of the IC card ticket from a plurality of candidates for the movement route specified from the entry station and the entry station. Next, based on the purchase information of the IC card ticket, the candidates for the movement route are further narrowed down. Further, the travel route of the railroad user is estimated by narrowing down the travel route candidates based on the standard transfer time within the station on the travel route, and the estimated route is specified as the travel route of the railroad user.

  Then, based on the stay time specified from the specified travel route and the display schedule of the content such as advertisements installed in the station, the content that the rail user may have contacted is specified, and the specified content is Provide relevant information. Or the content which the user contacted is estimated.

More specifically,
An information distribution method for distributing information of content that a user of a railway line touches while moving to a terminal of the user, wherein a movement route is determined based on information on an entry station and a departure station of the railway line. Route information database storing route information including information for calculating and getting on and off the railway, and entry time when the user passes the ticket gate using an IC card And an entry / exit record information database storing entry / exit record information including the entry time, and a money entry / exit storing purchase record information including the station and time at which the user purchased the product using the IC card. A gold record database, a standard travel time information database in the station where standard travel time information including the standard travel time in the station is stored, and content stored in the station In an information distribution method using an information distribution system connected to a content display history database in which display history information including display time is stored,
The information distribution system includes:
A first movement route pattern that is route information that is a candidate for the user's movement route by searching the route information database based on the user's entry / exit record information stored in the entry / exit record database To calculate
When the number of the first movement route patterns is 1 or more and a predetermined number or less, the first movement route pattern is specified as a confirmed movement route pattern indicating the movement route of the user,
When the calculated first movement path pattern is more than the predetermined number and the purchase record information of the user is stored in the money deposit / withdrawal record information database, a plurality of the first movement path patterns are stored. A second travel route pattern including the station and time of the purchase record information is identified,
When the number of the second movement route patterns is not less than 1 and not more than a predetermined number, the second movement route pattern is specified as the fixed movement route pattern,
When there are more specified second movement path patterns than the predetermined number, the entry of the entry / exit record information stored in the entry / exit record information database from among the plurality of second movement path patterns Within a time shorter than the standard travel time stored in the standard travel time information database, the travel time in the station calculated based on the time and the entry time and the boarding time and the departure time included in the second travel route pattern Identify a third travel route pattern that is
When the number of the third movement route patterns is not less than the predetermined number and not less than 1, the third movement route pattern is specified as the fixed movement route pattern,
A part of the stay time in the station calculated based on the boarding time and the getting off time of the identified fixed movement route pattern and the standard travel time, and the display time of the display history information stored in the content display history database Identify content that overlaps at least part of
The present invention includes an information distribution method that distributes information relating to the identified content to the terminal of the user.

  Further, when the third movement route pattern is larger than the predetermined number, the movement route pattern including the boarding time closest to the entry time of the entry / exit record information among the third movement route patterns is determined. An information distribution method characterized by specifying as a movement route pattern is also included in the present invention.

  Further, when the second movement route pattern cannot be specified, the movement route pattern including the boarding time closest to the entry time of the entry record information among the first movement route patterns is determined. An information distribution method characterized by specifying as a route pattern is also included in the present invention.

  Further, when the third movement route pattern cannot be specified, the movement route pattern including the boarding time closest to the entry time of the entry / exit record information among the second movement route patterns is determined. An information distribution method characterized by specifying as a route pattern is also included in the present invention.

  According to the present invention, a record in which a railway user has passed through an IC card ticket gate (entrance / entry record) and a deposit / withdrawal of money with an IC card settlement machine such as a store in a station premises (product purchase record, money charge) By using records, together with cash deposit / withdrawal records), railway users (ie viewers) in spaces managed by railway operators (stations such as ticket gates, concourses, platforms, and trains) ) Can estimate content such as advertisements that may have been viewed in the space, so that information related to the content can be provided efficiently.

  Hereinafter, embodiments of the present invention will be described in detail. In the present embodiment, the distribution of information related to the advertisement content distributed to the display device in the station premises will be described as an example, but the present invention is not limited to this.

  FIG. 1 is a block diagram showing an overall system configuration of an advertisement content linkage information providing apparatus and related peripheral systems / apparatuses according to the present embodiment. The advertising content linkage information providing device is information related to the identified contact content that identifies the contact content that the rail user may have contacted based on the travel route of the railroad user and the display schedule of the advertising content. This is an apparatus for distributing certain advertising content linkage information to a mobile terminal of a railroad user. Here, “possibility of contact” refers to the possibility that a railroad user has viewed, and “contact content” refers to the space in which the railroad user is staying in a space such as a specific station. It points to the content displayed on the display device installed in. For this reason, this content includes physical items such as signs other than so-called digital data. The output content is also included in other information such as audio.

  2A to 2D are data configuration diagrams showing a data configuration of each piece of information necessary for processing in the advertisement content linkage information providing apparatus according to the present embodiment.

  3 (a) and 3 (b) show an embodiment of the processing procedure of the moving route and the contact content analysis function, the contact content cooperation information mail delivery function, and the advertisement effect analysis function of the advertisement content cooperation information providing device in this embodiment. It is a flowchart to show.

  In FIG. 1 and FIGS. 2A to 2D, an IC card ticket 1101 includes an IC card ticket ID for identifying the IC card ticket 1101 and an e-mail address or data management of the data management center 1200. A homepage address (URL) for accessing the linked personal information registration function 1211 of the ID management device 1210 of the center 1200 is assigned in advance.

  These e-mail addresses and homepage addresses (URLs) are information necessary for rail users to access the IC card ticket data management center 1200. In this example, as a method of giving such information to an IC card ticket, a two-dimensional built-in mobile phone 1102 or the like is provided so that railway users can easily read the information and easily access a homepage address (URL). A method for giving an IC card ticket with a two-dimensional barcode that can be read by a barcode reader will be described as an example.

  First, the railroad user reads the homepage address (URL) of the data management center 1200 given to the IC card boarding ticket 1101 with a two-dimensional barcode reader using the mobile phone 1102, and cooperates with the personal information of the ID management device 1210. The registration function 1211 is accessed, and each data is registered in the IC card boarding ticket cooperation personal information database 1212 of the ID management device 1210.

  The IC card boarding ticket cooperation personal information database 1212 is configured by an IC card boarding ticket cooperation personal information data table 121200 shown in FIG. The IC card ticket linkage personal information database 1212 includes at least an IC card ticket ID 121201 and a registered email address 121202 of a person who can receive mail using a mobile terminal or PC that can be connected to the Internet by a railway user. Registration is required as personal information.

  In the IC card ticket cooperation personal information database 1212, personal information such as sex 121203, age 121204, and occupation 121205 can be additionally registered as personal information that can be used for advertisement effect analysis.

  The IC card ticket cooperation personal information database 1212 is used in the contact content cooperation information mail distribution function 1430 in the advertisement content cooperation information providing apparatus 1400 according to the present invention, and details will be described later.

  An IC card ticket gate (entrance station) 1103 that passes when a railway user enters the ticket gate using the IC card ticket 1101 reads the IC card ticket ID 122301 from the IC card ticket 1101 and the IC card. In the ticket gate (entrance station) 1103, the entrance station 122302, the entrance ticket gate 122312, and the entrance date and time 122303 are acquired as information, and transmitted to the entrance registration function 1221 of the usage data management device 1220 of the IC card ticket data management center 1200 for entry and exit. Each data is recorded in the recording database 1223.

  The entrance / exit record database 1223 includes an entrance / exit record data table 122300 shown in FIG.

  As described above, when passing through the IC card ticket gate (entrance station) 1103, the IC card ticket ID column 122301, the entrance station column 122302, and the entrance date / time column are newly added records in the entrance / exit record database 1223 shown in FIG. 122303 is recorded.

  An IC card ticket gate (participating station) 1104 that passes when a railroad user enters from the ticket gate using the IC card ticket 1101 reads the IC card ticket ID 122301 from the IC card ticket 1101 and the IC card. In the ticket gate (participating station) 1104, the participating station 122304, the participating ticket gate 122314, and the participating date 122305 are acquired as information and transmitted to the participation registration function 1222 of the usage data management device 1220 of the IC card ticket data management center 1200. The entry registration function 1222 searches the entry record database 1223 with the transmitted IC card ticket ID 122301, and among the searched entry record records, the entry station column 122304 of the entry record record with the latest entry date and time, entry Information transmitted to the ticket gate column 122314 and the entry date / time column 122305 is recorded.

  The entrance / exit record database 1223 is used in the moving route and contact content analysis function 1410 in the advertisement content cooperation information providing apparatus 1400 according to the present invention, details of which will be described later.

  The IC card settlement machine (within the ticket gate) 1105 reads the IC card ticket ID 122501 from the IC card ticket 1101, acquires information such as deposit / withdrawal station information, and uses the data management device of the IC card ticket data management center 1200. The data is sent to the cash deposit / withdrawal registration function 1224 and recorded as each data in the cash deposit / withdrawal record database 1225.

  The money deposit / withdrawal record database 1225 includes a money deposit / withdrawal record data table 122500 shown in FIG.

  Here, the IC card settlement machine (inside the ticket gate) 1105 uses the IC card ticket 1101 for the railway user to settle the price of goods purchased at a station shop, etc. A device used to charge a ticket.

  As described above, when the IC card settlement machine (inside the ticket gate) 1105 is used, the IC card ticket ID column 1222501 and the deposit / withdrawal station column 122502, as the newly added record of the money deposit / withdrawal record database 1225 shown in FIG. A gold area 122503, a deposit / withdrawal location 122504, a deposit / withdrawal date / time 122505, and a deposit / withdrawal amount 122506 are recorded.

  The money deposit / withdrawal record database 1225 is used in the movement route and contact content analysis function 1410 in the advertisement content cooperation information providing apparatus 1400 according to the present invention, and details will be described later.

  On the other hand, in the advertisement content distribution management center 1300, the service provider registers the advertisement content 1312 and the advertisement distribution schedule 1311 in the advertisement display device 1310. In the present embodiment, digital signage such as a video monitor is assumed as the display device, but the display device in the present invention is not limited thereto. Even in the case of paper media advertisements and video screenings, any device in which the content is replaced every time corresponds to the display device.

  Here, the advertisement content distribution management center 1300 is an advertisement content for a display device such as a video monitor installed in a space managed by a railway operator (such as a ticket gate, a concourse, a platform such as a platform, or a train). It is a management center that is responsible for delivering

  In accordance with the advertisement distribution schedule 1311, the advertisement display device 1310 provides advertisement content to a display device such as a video monitor installed in a space managed by a railway operator (such as a ticket gate, a concourse, a platform such as a platform, or a train). 1312 is distributed and the display history of the advertising content is recorded in the advertising content display history database 1314.

  The advertisement content display history database 1314 is configured by an advertisement content display history data table 131400 shown in FIG. In this embodiment, history information on which advertisement content is displayed is stored, but schedule information for displaying advertisement content may be stored instead of history information.

  The advertisement content display history database 1314 is used in the movement route and contact content analysis function 1410 in the advertisement content cooperation information providing apparatus 1400 according to the present invention, and details will be described later.

  In the advertisement content distribution management center 1300, the service provider registers the advertisement-linked WEB content 1321 and the linked WEB content URL information database 1322 linked to the advertisement content 1312 in the advertisement-linked WEB device 1320.

  The cooperative WEB content URL information database 1322 is configured by the cooperative WEB content URL information data table 132200 shown in FIG.

  The cooperative WEB content URL information database 1322 is used in the contact content cooperative information mail distribution function 1430 in the advertising content cooperative information providing apparatus 1400 according to the present invention, details of which will be described later.

  Next, the advertising content linkage information providing apparatus 1400 according to the present invention described in FIG. 1 will be described.

  In the advertising content linkage information providing apparatus 1400 of FIG. 1, the travel route and contact content analysis function 1410 first uses the entry / exit record database 1223 and the money deposit / withdrawal record database 1225 of the use data management apparatus 1220 to change the Based on the data obtained from the advertisement content display history database 1314 of the advertisement display device 1310, the facility / service use information in the station premises is obtained, the travel route of the railway user is estimated using the information as the original data. The contact content is specified and output to the contact content list database 1420.

  Here, the contact content list 1420 is a contact between the contact advertisement posting ID 14202, the contact advertisement content ID 142005, and the advertisement content that the railway user may have contacted, using the IC card ticket ID of the railway user as a key item. It is composed of a contact content data table 1420 in which advertisement display start date and time 142003 and contact advertisement display end date and time 142004 are recorded.

  Next, it is assumed that the contact content cooperation information mail distribution function 1430 has contacted the advertisement content based on the output contact content list database 1420 and the data acquired from the cooperation web content URL information database 1322 of the advertisement cooperation web device 1320. Create an email text that describes the linked WEB content URL of the advertising content that you think has been contacted by each potential rail user.

  The created mail text is the contact content cooperation information mail 1470 addressed to the registered mail address recorded in the record extracted from the IC card ticket cooperation personal information database 1212 of the ID management device 1210 as the key item. As mail delivery. The result of mail distribution is recorded in the contact content cooperation information mail distribution history database 1440.

  The transmitted contact content cooperation information mail 1470 is received by the railway user's mobile terminal / PC (railway user) 1600 via the Internet 1500.

  The railroad user browses the contact content linkage information mail 1470 received by the mobile terminal / PC (railway user) 1600, and further accesses the linkage web content URL of any advertisement content linkage information via the Internet 1500 to The linked web content 1321 can be browsed.

  When the railway user browses the advertisement-linked WEB content 1321, the WEB access history generation function 1323 in the advertisement-linked WEB apparatus 1320 generates and records the WEB access history database 1324.

  Finally, based on the contact content cooperation information mail distribution history database 1440 recorded by the contact content cooperation information mail distribution function 1430 and the WEB access history database 1324 recorded by the advertisement cooperation WEB device 1320 by the advertisement effect analysis function 1450, The advertisement effect of the advertisement content is analyzed by the analysis method, and the advertisement effect analysis result 1460 is output.

  Next, the operation of each unit of the advertisement content linkage information providing apparatus 1400 in FIG. 1 will be described based on the flowcharts in FIGS.

  The advertising content linkage information providing apparatus 1400 sets a processing date and time for performing a scheduled processing in advance, and performs a scheduled processing for each railroad user as a processing target period from the previous processing date to the current processing date and time. To do. For example, if the regular processing date and time is 3:00 am on every day of the week, the processing target period of 3:00 am on Sunday, October 7, 2007 is from 3:00 am on Sunday, September 30, 2007 to Sunday, October 7, 2007. Until 3 o'clock.

  In the travel route and contact content analysis function 1410 of FIG. 1, the travel route of the railroad user is estimated, and based on the estimated travel route, the advertisement content that is estimated to have been touched during travel is specified. Process.

  The operation of the movement route and contact content analysis function 1410 will be described below based on the flowcharts of FIGS. 3 (a) and 3 (b).

  First, in order to acquire the railway use status in the processing target period for each railway user, both the entry date 122302 and the entry date 122305 are entered from the entry record database 1223 of the use data management device 1220 using the IC card ticket ID 122301 as a key. However, an entrance / exit record record included in the processing target period is acquired (step 4020).

  In step 4020, it is expected that a plurality of entrance / exit record records included in the processing target period are acquired for one IC card ticket ID 122301. In the subsequent steps, it is assumed that each of the acquired plurality of entry / exit record records is individually processed. The following description of the flowchart describes the flow of processing for one entry / exit record record among the plurality of entry / exit record records acquired in step 4020.

  Next, based on the entry station 122302, the entry date and time 122303, the entry station 122304, and the entry date and time 122305 of the entry record record acquired in step 4020, the railway user of the IC card ticket ID 122301 of the entry record record is All the available travel route patterns 2102 are extracted from the route information (transfer information) database 2101 to create a travel route pattern data table 210200. (Step 4030).

  Here, the route information (transfer information) database 2101 is a route shown in FIG. 2 such as a boarding station 21010101, a boarding time 21010105, a boarding station 21010301, a boarding station 21010401, a boarding time 21010405, etc. when moving from a certain station to a certain station. This refers to a database in which movement route patterns configured from an information (transfer information) data table 210100 are accumulated.

  The next processing content differs depending on the number of movement route patterns extracted in step 4030.

  When the movement route pattern 2102 extracted in step 4030 is 1 or more and a predetermined number or less, it is specified as a matching pattern, and the process proceeds to step 6010 described later. In this embodiment, the case where the predetermined number is 1 will be described as an example, but the predetermined number may be other than 1. If there is no movement route pattern 2102 extracted in step 4030, it is determined that there is no matching pattern, and the subsequent processing ends. If there are two or more movement route patterns 2102 extracted in step 4030, it is necessary to further narrow down the movement route pattern 2102, and the process proceeds to step 5010 (step 4040).

  Here, when there is no matching pattern, there is no travel route pattern that is considered to have been used by the railway user, and the estimated travel route information used in the subsequent processing cannot be created, so the subsequent processing ends. In this case, a comment indicating that there is no matching pattern is output so as to be visible to the operator.

  Here, the matching pattern refers to a movement route pattern estimated to be used by a railroad user.

  Next, in order to narrow down a plurality of travel route patterns 2102 that are considered to be used by the railway user, reference information is acquired from the railway user's cash deposit / withdrawal record database 1225. First, the cash deposit / withdrawal record database 1225 is searched with the IC card ticket ID 122301 of the entry / exit record record to be processed, and the deposit / withdrawal date / time 12252 of the found cash deposit / withdrawal record is the processing target entry / exit record. A money deposit / withdrawal record record is acquired that is between the entry date 122303 and the entry date 122305 of the record 1223 and the deposit / withdrawal area 122503 is in the ticket gate (step 5010).

  In the example of the money deposit / withdrawal record data table 122500 shown in FIG. 2A, the record in the second row is acquired.

  If there is no money deposit / withdrawal record record acquired in step 5010, the subsequent processing shifts to step 5050 to be described later. If there is a money deposit / withdrawal record record acquired in step 5010, the process proceeds to step 5030 to be described later. Transition is made (step 5020).

  In steps 5031, 5032, and 5033, based on the money deposit / withdrawal record record acquired in step 5010, a movement route pattern that cannot be used by the railway user from among the plurality of movement route patterns 2102 extracted in step 4030 is obtained. Delete and narrow down the travel route patterns that the railway users think are used.

  As a narrowing down method, first, at the boarding station 21020101 of the movement route pattern data table 210200, the money deposit / withdrawal record record acquired in step 5010 is searched. The deposit / withdrawal date and time 122250 of the retrieved cash deposit / withdrawal record record indicates the date and time when the railroad user was not on the train and was somewhere in the ticket gate of the boarding station. Based on the record deposit / withdrawal date and time 122505, the travel route pattern 2102 of the travel date and time 21010105 of the travel route pattern 2102 is a pattern that cannot be used by the railroad user, so it is determined that the pattern is not a matching pattern. It deletes from the pattern 2102 (step 5031). If there is no search result, proceed to the next step.

  Next, at the alighting station 21010401 of the movement route pattern 2102, the money deposit / withdrawal record record acquired in step 5010 is searched. The deposit / withdrawal date / time 122505 of the retrieved cash deposit / withdrawal record record 1225 indicates the time when the railroad user got off the train and was somewhere in the exit station ticket gate. From the deposit / withdrawal date and time 122505, the movement route pattern 2102 with the future date and time of the departure time 21010405 of the movement route pattern 2102 is a pattern that cannot be used by the railway user. (Step 5032). If there is no search result, proceed to the next step.

  Finally, if there is a record including “transfer present” data in the transfer presence / absence column 210102 of the movement route pattern 2102, the money transfer record record 1225 acquired in step 5010 is searched at the transfer station 21010301 of the record. . The deposit / withdrawal date and time 122505 of the retrieved cash deposit / withdrawal record record 1225 indicates the time when the railway user got off the train and was somewhere at the transfer station. From date and time 122505, the movement route pattern 2102 in which the transfer station departure time 21010305 of the movement route pattern 2102 is the future date and the movement route pattern 2102 in which the transfer station departure time 21010309 is the past date and time are patterns that are not available to railway users. Therefore, it is determined that the pattern is not a matching pattern target, and the pattern is deleted from the movement route pattern 2102 (step 5033). If there is no search result, proceed to the next step.

  The next processing contents differ depending on the number of remaining movement route patterns as a result of narrowing down in steps 5031, 5032, and 5033.

  When the remaining movement path pattern 2102 is 1 or more and a predetermined number or less, the pattern is specified as a matching pattern, and the process proceeds to Step 6010 described later. In this embodiment, the case where the predetermined number is 1 will be described as an example, but the predetermined number may be other than 1. If there is no narrowed movement path pattern 2102, no matching pattern is set, and the subsequent processing is terminated. If there are two or more narrowed movement path patterns 2102, the process proceeds to step 5050 (step 5040).

  In Steps 5031 to 5033, the travel route pattern 2102 could not be narrowed down to one. Therefore, in Step 5050, a pattern that is unlikely to be an actual behavior of the railway user is deleted from the plurality of travel route patterns 2102. To go. Here, in order to narrow down the pattern, the station campus standard travel time information database 2201 is used. The station yard standard travel time information database 2201 defines the standard walking time based on the route length between the IC card ticket gates of each station and the major bases such as the stores and platforms in the station premises. This is a database of standard travel times between major bases, and is composed of a station internal standard travel time information data table 220100 shown in FIG.

  First, the standard travel time 220104 from the disembarking platform 21010406 of the travel route pattern 2102 to the exit ticket gate 122314 of the entry record record processed in step 4020 is extracted from the station standard travel time information database 2201. The time obtained by adding the extracted standard travel time 220104 to the departure time 21010405 of the travel route pattern 2102 is the time estimated to pass through the ticket gate of the participating station when the train user moves without running after getting off the participating station. Become. Accordingly, the movement route pattern 2102 in which the time obtained by adding the extracted standard movement time 220104 to the getting-off time 21010405 of the movement route pattern 2102 becomes the future date and time from the entry date and time 122305 of the entry / exit record record processed in Step 4020 is It is determined that the pattern is not a matching pattern target, and the record is deleted from the movement route pattern 2102 (step 5050).

  As a result of step 5050, when the remaining movement route pattern 2102 is 1 or more and a predetermined number or less, the pattern is specified as a matching pattern, and the process proceeds to step 6010 described later. In this embodiment, the case where the predetermined number is 1 will be described as an example, but the predetermined number may be other than 1. If there is no remaining movement path pattern 2102, no matching pattern is set, and the subsequent processing is terminated. If there are two or more remaining movement path patterns 2102, the process proceeds to step 5070 (step 5060).

  In step 5070, the plurality of remaining movement route patterns 2102 obtained by the processing before step 5070 are further narrowed down based on the station internal standard movement time of the entrance station.

  First, the standard travel time 220104 from the entrance station ticket gate 121212 to the boarding station platform 21010106 of the travel route pattern 2102 in the entrance / exit record record to be processed in step 4020 is extracted from the station premise standard travel time information data table 2201. The time obtained by adding the extracted standard travel time 220104 to the entry date and time 122303 of the entry record record to be processed is estimated to arrive at the boarding platform when the train user moves without running after entering the boarding station. It becomes. Therefore, it is determined that the travel route pattern 2102 of the past date / time is not subject to the matching pattern from the time when the boarding time 21010105 of the travel route pattern 2102 adds the extracted standard travel time 220104 to the entrance date / time 122303 of the entry / exit record record. Then, the record is deleted from the movement route pattern 2102 (step 5070).

  As a result of step 5070, if there is one remaining movement route pattern 2102, the pattern is specified as a matching pattern, and the process proceeds to step 6010 described later. If there is no remaining movement route pattern 2102, it is determined that there is no matching pattern. When the subsequent processing is finished and there are two or more remaining movement route patterns 2102, the matching pattern cannot be specified, and the process proceeds to step 6020 described later (step 5080).

  Through the processing so far, based on the narrowed travel route pattern 2102, the estimated travel route information database 2302 is created for the entrance station, transfer station, departure station, and boarding train that the railroad user seems to have used. The estimated travel route information database 2302 includes an estimated entry station information data table 300100, an estimated transfer station information data table 300200, an estimated departure station information data table 300300, and an estimated boarding train information data table 300400 shown in FIG.

  First, the case where the movement route pattern 2102 is narrowed down to one and the matching pattern can be specified as a result of the processing so far will be described.

  The estimated entrance station information data table 300100 acquires the data of each column as follows. The IC card ticket ID 300101, the entrance station 300102, and the entrance station ticket gate 300103 entrance date / time 300105 acquire the data of the same column name from the entry record record to be processed.

  As the station internal standard travel time 300106, the standard travel time 220104 from the entrance ticket gate 300103 of the entrance station 300102 to the boarding platform 300113 is acquired from the station internal standard travel time information database 2201. The transit location 220112 is also acquired from the same record.

  The estimated station stay date and time 300107 is the time when the station campus standard travel time 300106 has elapsed since the admission date and time 300105.

  The use route 1 300109, the direction 300110, the boarding date and time 300111, and the boarding platform 300113 acquire the data of the same column name of the movement route pattern 2102 narrowed down to one by the processing so far.

  The estimated home stay date and time 300112 is from the estimated station stay date and time 300107 to the boarding date and time 300111. The estimated home stay date and time 300112 is an upper limit of 10 minutes, and if more than 10 minutes remain, it is added to the estimated station stay date and time 300107. To do.

  The ticket gate advertisement posting destination ID 300104, the concourse advertisement posting destination ID 300108, and the home advertisement posting destination ID 300114 are searched by the station name of the place where the advertisement posting destination ID is to be obtained from the station premises information database 2301, and the searched records are further displayed at the advertisement posting place. The search is performed, and the advertisement posting destination ID of the retrieved record is acquired (step 6011).

  Here, the station premises information database 2301 includes a station premises information data table 230100 shown in FIG.

  The estimated transfer station information data table 300200 acquires data of each column as follows.

  As for the column of the IC card ticket ID 300201, data of the same column name is acquired from the entry / exit record record 1223 to be processed. Transfer station 300202, use route 1300103, direction 300204, get-off date and time 300205, get-off platform 300206, use route 300210, direction 300211, ride date and time 300212, and get-off platform 300214 are travel route patterns 2102 that have been narrowed down to one by the above processing. Get the data of the same column name. As the station internal standard travel time 300207, the standard travel time 220104 and the transit location 220112 from the platform 300206 to the boarding platform 300214 at the transfer station are acquired from the station internal standard travel time information data table 2201. The estimated station stay date and time is the time when the station campus standard travel time 300207 has elapsed since the departure date and time 300205. The estimated home stay date and time 300213 is from the estimated station stay date and time 300208 to the boarding date and time 300212. The concourse advertisement posting destination ID 300209 and the home advertisement posting destination ID 300215 are searched from the station premises information database 2301 by the station name of the place where the advertisement posting destination ID is to be obtained, and the searched records are further searched by the advertisement posting place. The advertisement posting destination ID 230103 of the record is acquired (step 6012).

  The estimated participation station information data table 300300 acquires the data of each column as follows. For the columns of IC card ticket ID 300101, entry station 300302, entry station ticket gate 300303, and entry date / time 300305, data of the same column name is acquired from the entry / exit record record 1223 to be processed. As the station internal standard travel time 300306, the estimated travel time from the entry ticket gate 300303 of the participating station 300302 to the getting-off platform 300312 is acquired from the station internal standard travel time information data table 2201. The estimated station premises stay date and time 300307 is the time when the station premises standard travel time 300306 has elapsed from the time of the getting off date and time 3003111. The use route 2 300309, the direction 300310, the getting-off date and time 300311, and the getting-off platform 30031 acquire data of the same column name of the moving route pattern 2102 narrowed down to one by the processing so far. The ticket gate advertisement posting destination ID 300304, the concourse advertisement posting destination ID 300308, and the home advertisement posting destination ID 300313 are searched by the station name of the place where the advertisement posting destination ID is to be obtained from the station premises information database 2301, and the searched records are further displayed at the advertisement posting place. The search is performed, and the advertisement posting destination ID 230103 of the retrieved record is acquired (step 6013).

  The estimated boarding train information data table 300400 acquires the data of each column as follows. The IC card ticket ID 300401 acquires data with the same column name from the entry / exit record record to be processed. Use route 300402, direction 300403, boarding station 300404, boarding date and time 300405, boarding station 300406, and boarding date and time 300407 acquire the data of the same column name of the movement route pattern 2102 narrowed down to one by the above processing. When transfer data is included in the movement route pattern 2102 narrowed down to one, a record is created for each boarding train. The estimated in-vehicle stay time 300408 is assumed to be from the boarding date / time 300405 to the getting-off date / time 300407. The in-car advertisement posting destination ID is searched from the in-train information database 2401 by the name of the line for which the advertisement posting destination ID is to be acquired, the searched record is further searched, and the advertisement posting destination ID 240103 of the searched record is acquired ( Step 6014).

  Here, the in-train information database 2401 includes an in-train information data table 240100 shown in FIG.

  Next, a case where a plurality of movement route patterns 2102 exist as a result of the processing so far and a matching pattern cannot be specified will be described.

  In this case, the estimated travel route information database 2302 creates an estimated entry station information data table 3001 and an estimated entry station information data table 3003.

  First, a movement route pattern 2102 serving as reference information for creating the estimated entrance station information data table 300100 is determined. Among the plurality of travel route patterns 2102, the travel route pattern 2102 having the boarding time 21010105 having the boarding time 21010105 closest to the entry date and time 122304 of the entry record to be processed is used as reference information.

  The estimated entrance station information data table 3001 acquires the data of each column as follows. The IC card ticket ID 300101, the entrance station 300102, the entrance station ticket gate 300103, and the entrance date / time 300105 acquire the data of the same column name from the entry record record to be processed. As the station internal standard travel time 300106, the estimated travel time from the entrance ticket gate 300103 of the entrance station 300102 to the boarding platform 300113 is acquired from the station internal standard travel time information database 2201. Here, it is assumed that the boarding home 300113 is the boarding home 21010106 of the movement route pattern 2102 that is determined as reference information in advance. The estimated station stay date and time 300107 is the time when the station campus standard travel time 300106 has elapsed since the admission date and time 300105. The use route 1 300109, the direction 300110, the boarding date and time 300111, and the boarding platform 300113 acquire the data of the same column name of the movement route pattern 2102 that is set as reference information in advance. The estimated home stay date and time 300112 is from the estimated station stay date and time 300107 to the boarding date and time 300111. The ticket gate advertisement posting destination ID 300104, the concourse advertisement posting destination ID 300108, and the home advertisement posting destination ID 300114 are searched by the station name of the place where the advertisement posting destination ID is to be obtained from the station premises information database 2301, and the searched records are further displayed at the advertisement posting place. The search is performed, and the advertisement posting destination ID 230103 of the retrieved record is acquired (step 6021).

  Next, an estimated participation station information data table 300300 is created. First, a movement route pattern 2102 serving as reference information for creating the estimated participation station information data table 300300 is determined. Among the plurality of moving route patterns 2102, the moving route pattern 2102 having the getting-off time 21010405 closest to the entry date / time 122305 of the entry / exit record record 1223 to be processed is used as reference information.

  The estimated participation station information data table 300300 acquires the data of each column as follows. For the columns of IC card ticket ID 300101, entry station 300302, entry station ticket gate 300303, and entry date / time 300305, data of the same column name is acquired from the entry record record to be processed. As the station internal standard travel time 300306, the estimated travel time from the entry ticket gate 300303 of the participating station 300302 to the getting-off platform 300312 is acquired from the station internal standard travel time information database 2201. Here, the getting-off platform 300312 is assumed to be the boarding platform 21010405 of the movement route pattern 2102 that is determined as reference information in advance.

  The estimated station premises stay date and time 300307 is the time when the station premises standard travel time 300306 has elapsed from the time of the getting off date and time 3003111. The use route 2 300309, the direction 300310, the getting-off date / time 300311, and the getting-off home 300312 acquire the data of the same column name of the moving route pattern 2102 decided to be the reference information in advance. The ticket gate advertisement posting destination ID 300304, the concourse advertisement posting destination ID 300308, and the home advertisement posting destination ID 300313 are searched by the station name of the place where the advertisement posting destination ID is to be obtained from the station premises information database 2301, and the searched records are further displayed at the advertisement posting place. The search is performed, and the advertisement posting destination ID 230103 of the retrieved record is acquired (step 6022).

  The estimated entrance station information data table 300100, the estimated transfer station information data table 300200, the estimated departure station information data table 300300, and the estimated boarding train information 300400 of the estimated travel route information database 2302 are each a ticket gate / passage where a railroad user has passed or stayed. It includes the advertisement posting destination ID of the video monitor etc. that displays the advertising content set in the concourse home, etc., and the date and time when the railroad user passed or stayed through the advertising posting destination of the video monitor etc. It can be considered that the user sees the advertising content displayed on the video monitor or the like installed there when passing or staying through the ticket gate, concourse, home, etc. On the other hand, the advertisement content display history database 1314 is a database including the advertisement content displayed on the advertisement posting destination such as a video monitor installed in the ticket gate, concourse, home, etc. and the display date and time of the advertisement content. Therefore, using the estimated travel route information database 2302 and the advertisement content display history database 1314, it is possible to specify the advertisement content that the railroad user seems to have contacted while moving. The advertisement content that seems to have been contacted is assumed to be a contact content list database 1420 using an IC card ticket ID for identifying a railroad user as a key. The contact content list database 1420 includes a contact content list data table 142000 shown in FIG.

  Specifically, the advertisement posting destination ID included in each of the estimated entry station information data table 300100, the estimated transfer station information data table 300200, the estimated departure station information data table 300300, and the estimated ride train information 300400 of the estimated travel route information database 2302 The advertisement content display history record of the same advertisement posting destination ID is extracted from the advertisement content display history database 1314 (step 7010).

  Next, an admission date / time 300105, an admission date / time 300305, the estimated date / time of the estimated station premises / estimated home / estimated vehicle and the extracted advertisement content display history record indicating the date and time when the railroad user passed or stayed at the advertisement posting destination. Records with duplicate dates and times from the display start date and time 131404 to the display end date and time 131405 are extracted (step 7020).

  The advertisement content display history record extracted in step 7020 is an advertisement content that is considered to have been contacted at each place such as a ticket gate, a concourse, a home, etc. that the railway user has passed or stayed while moving. The contact content list database 1420 is created using the IC card ticket ID for identifying the railroad user as a key (step 7030).

  In the contact content cooperation information mail distribution function 1430, the link information of the advertisement content that the rail user identified in step 7030 is considered to have contacted while moving is distributed to the rail user by mail.

  First, the following processing is performed for each IC card ticket ID 142001 in the contact content list database 1420 in order to create a mail text to be distributed to each railroad user who seems to have contacted the advertising content. Based on the contact advertisement content ID 142005 of the contact content list database 1420, the cooperative WEB content URL information database 1322 of the advertisement cooperative WEB device 1320 is searched, the cooperative WEB content URL 132202 and the cooperative WEB content related message 132203 of the searched record are extracted, and mail A body is created (step 8010).

  Here, the contact advertisement content ID 142005 of the contact content list 1420 may include a plurality of the same contact advertisement content IDs 142005 having different contact advertisement display destinations or different display dates and times, and therefore, the step of one IC card ticket ID 142001. In the processing of 8010, the contact advertisement content ID 142005 that has been searched once in the linked WEB content URL information database 1322 is not searched thereafter.

  In addition, a mail body format is prepared in advance for the mail body, and by copying the linked WEB content URL 132202 and the linked WEB content related message 132203 to a predetermined position, it may be devised to make the mail body easier to read. Although it seems to be possible, how to display the body of the email depends on the service and will not be mentioned here.

  Next, the mail address of the railway user of the IC card ticket ID 142001 that created the mail text is acquired. As for the mail address of the railroad user, the IC card ticket linkage personal information database 1212 is searched with the IC card ticket ID 142001, and the registered mail address 121202 of the searched record is extracted (step 8020).

  A mail is created and distributed from the mail text created in step 8010 and the mail address extracted in step 8020 (step 8030).

  After the mail distribution, the mail distribution date / time 1444003 and the like are recorded as the contact content cooperation information mail distribution history database 1440 (step 8040). The contact content cooperation information mail distribution history database 1440 includes a contact content cooperation information mail distribution history data table 144000 shown in FIG.

  Finally, based on the contact content cooperation information mail distribution history database 1440 recorded by the contact content cooperation information mail distribution function 1430 and the WEB access history database 1324 recorded by the advertisement cooperation WEB device 1320 by the advertisement effect analysis function 1450, The advertisement effect of the advertisement content is analyzed by the analysis method, and the advertisement effect analysis result 1460 is output (step 9010).

  The predetermined analysis method used here is, for example, to analyze how many advertisement users can access to the advertisement-linked WEB content by delivering the contact content-linked information mail to how many railway users There are methods.

  Specifically, when variable A is the total number of linked WEB content URLs calculated from contact content cooperation information mail distribution history 1440, and variable B is the total number of accessed WEB content URLs calculated from WEB access history 1324 By calculating the ratio of the variable A and the variable B, it is possible to derive the ratio that leads to the web access from the contact with the advertising content.

  As described above, the method for measuring the advertisement effect or analyzing the advertisement effect can be devised in various ways by reviewing the data items of the IC card ticket cooperation personal information database 1212 and the WEB access history database 1324. However, in the present invention, only the above-described example is presented.

  Next, the operation of each step of the advertisement content linkage information providing apparatus 1400 described so far will be described based on specific examples shown in the data configuration diagrams of FIGS.

  In the following description, the IC card ticket ID 122301 of the railway user to be processed is “12-34-56-78”, and the processing period is “Sunday, September 30, 2007 from 3 am to 2007 Monday, 7th of March at 3am. "

  First, in the operation of Step 4020, the IC card ticket ID 122301 to be processed is “12-34-56-78”, and the processing target period is “Sunday September 30, 2007 from 3:00 am to October 7, 2007. “3 am on Sunday”, the IC card ticket ID 122301 is “12-34-56-78” and the entry date 122303 and the entry date 122305 are the processing target period from the entry record data table 122300 shown in FIG. The record in the second line that is not present is acquired.

  Next, in step 4030, all travel route patterns 2102 that can be used by the railway user of the IC card ticket ID 122301 of the entry / exit record record based on the entry / exit record record acquired in step 4020 are displayed as route information ( 2) Since the information is extracted from the database 2101, the extraction condition in the example shown in FIG. 2A is that the entry time 21010105 of the entrance station 122302 “Ueno Station” is the entrance date and time 122303 “2007/10/01 16:30” or later. The departure time 21010405 at the entry station 122304 “Totsuka Station” becomes the travel route pattern before the entry date 122305 “2007/10/01 18:15”. Records whose columns 210111 are “102”, “103”, “121”, and “122” are extracted, and No. of the movement route pattern data table 210200 is extracted. Records of columns 210211 “001” “002” “021” “022” are created.

  In step 4040, since there are two or more movement route patterns 2102 extracted in step 4030, the process proceeds to step 5010.

  In step 5010, from the money deposit / withdrawal record data table 122500 shown in FIG. 2 (a), the deposit / withdrawal date / time 122505 is entered as the entry date / time 122303 “2007/10/01 16:30” of the entry / exit record record 1223 to be processed. A record on the second line that is a date and time between date and time 122305 “2007/10/01 18:15” and whose deposit / withdrawal area 122503 is in the ticket gate is acquired.

  In step 5020, since there is one money deposit / withdrawal record acquired in step 5010, the process proceeds to step 5031.

  In step 5031, since the boarding station 21020101 of the travel route pattern data table 210200 shown in FIG. 2C is “Ueno station”, the record in the second line of the money deposit / withdrawal record data table 122500 is searched. The deposit / withdrawal date and time of 122505 “2007/10/01 17:00” indicates the date and time when the railroad user was at Ueno Station. The records in the columns 210211, “001”, “002”, and “021” are determined to be out of the matching pattern target because the boarding time 21010105 is before “17:00”, and are deleted from the movement route pattern data table 210200.

  In step 5032, the exit station 21010401 of the travel route pattern data table 210200 shown in FIG. 2C is “Totsuka station”, but the record of the deposit / withdrawal station 122502 of the money deposit / withdrawal record data table 122500 is “Totsuka station”. Since there is no, go to the next step.

  In step 5033, the transfer station 21010301 of the travel route pattern data table 210200 shown in FIG. 2C is “Tokyo station”, but the record of the deposit / withdrawal station 122502 of the money deposit / withdrawal record data table 122500 is “Tokyo station”. Since there is no, go to the next step.

  Since the record of the movement route pattern data table 210200 narrowed down by the processing so far is one pattern, the process proceeds to step 6010.

  In subsequent steps 6011, 6012, 6013, and 6014, No. of the movement route pattern data table 210200 shown in FIG. Each data table is created based on the record in the column 210211 “022”.

  In step 6011, the data of each column of the estimated entrance station information data table 300100 is acquired and recorded as follows.

  Since the IC card ticket ID 300101, the entrance station 300102, the entrance station ticket gate 300103 and the entrance date / time 300105 acquire the data of the same column name from the entry / exit record record to be processed, the entrance / exit record data table 122300 shown in FIG. From the second row record, IC card ticket ID 122301 “12-34-56-78”, admission station 122302 “Ueno station”, admission station ticket gate 122122 “entrance ticket gate”, admission date and time 122303 “2007/10/01 16 : 30 ”and recorded in the IC card ticket ID column 300101, the entrance station column 300102, the entrance ticket gate column 300103, and the entrance date / time column 300105 of the estimated entrance station information data table 300100.

  The station standard travel time 300106 includes the standard travel time 220104 “00:05” and the transit location 220102 “park entrance passage” from the record in the first row of the station standard travel time information data table 220100 shown in FIG. It is acquired, and “00:05” is recorded in the station premises standard travel time column 300106 of the estimated entrance station information data table 300100, and “park entrance passage” is recorded in the transit location column 300117.

  The estimated station stay date and time 300107 is “2007/10/01 16:30 to 16:35” when the station campus standard travel time 300106 “00:05” has elapsed from the admission date and time 300105 “2007/10/01 16:30”. It becomes.

  Use route 1 300109, direction 300110, boarding date and time 300111, boarding platform 300113, No. of the movement route pattern data table 210200. Use route 1 21010102 “Yamanote line”, direction 21010103 “outward”, boarding date 21010105 “17:10”, boarding platform 21010106 “line 3” of column 210211 “022”, and estimated entrance station information data table 300100 Use route 1 column 300109, direction column 300110, boarding date / time column 300111, and boarding home column 300113 are recorded.

  The estimated home stay date and time 300112 is “2007/10/01 16: 35-17” from the estimated station stay date and time 300107 “2007/10/01 16:35” to the boarding date and time 300111 “2007/10/01 17:10”. : 10 ", but 35 minutes, which exceeds the upper limit of 10 minutes of the estimated home stay date and time 300112, the estimated home stay date and time 300112 is" 2007/10/01 17: 0 to 17:10 The remaining 25 minutes is added to the estimated station stay date and time 300107 “2007/10/01 16:30 to 16:35”, and the estimated station stay date and time 300107 is “2007/10/01 16:30 to 17”. : 00 ".

  The ticket gate advertisement posting destination ID 300104 searches the station 230101 of the station premises information database 2301 by “Ueno Station”, and searches the advertisement posting place 230102 from the searched records by “Iriya ticket gate”. In the example of FIG. 2C, since the record in the first line is searched, the advertisement posting destination ID “UEN-K-I-001” is acquired, and the ticket gate advertisement posting destination ID of the estimated entrance station information data table 300100 is acquired. Record in column 300104. The concourse advertisement posting ID 300108 and the home advertisement posting ID 300114 are searched for “park entrance passage” and “No. 3 home” in the same procedure, and the acquired advertisement posting ID is the concourse advertisement posting ID column 300108 and the home advertisement. Recorded in the posting destination ID column 300114.

  In step 6012, data of each column of the estimated transfer station information data table 300200 is acquired and recorded as follows.

  Since the IC card ticket ID column 300201 acquires the data of the same column name from the entry / exit record record to be processed, the IC card ticket ID column 300201 is obtained from the record in the second row of the entry / exit record data table 122300 shown in FIG. The ticket ID 122301 “12-34-56-78” is acquired and recorded in the IC card ticket ID column 300201 of the estimated transfer station information data table 300200.

  Transfer station 300202, route 1 300103, direction 300204, getting off date 300205, getting off platform 300206, route 2 300210, direction 300211, boarding date 300212, boarding platform 300214, travel route pattern data table 210200 shown in FIG. No. Data of the same column name of each column recorded in the record of the column 210211 “022” is acquired and recorded.

  The station internal standard travel time 300207 and the transit location 300218 are defined as the departure place and the boarding platform 300214 “from the departure platform 300206“ Line 5 ”of the transfer station 300202“ Tokyo Station ”in the estimated transfer station information data table 300200 shown in FIG. Search the station precinct standard travel time information data table 2201 with “8th line” as the arrival location, and obtain the standard travel time 220104 “00:05” and the transit location 220112 “north passage” from the record in the second row to be searched, Record.

  Since the estimated station stay date and time 300208 is the time when the station campus standard travel time 300207 “00:05” has elapsed from the alighting date and time 300205 “2007/10/0117: 20” shown in FIG. 10/01 17: 20-17: 25 ".

  The estimated home stay date and time 300213 is from the estimated station stay date and time 300208 “2007/10/01 17:20 to 17:25” to the boarding date and time 300212 “2007/10/01 17:30” shown in FIG. Therefore, “2007/10/01 17:25 to 17:30” is obtained.

  The concourse advertisement posting destination ID 300209 searches the station 230101 of the station premises information database 2301 for “Tokyo Station”, and searches the advertisement posting place 230102 for “North Passage” from the searched records. In the example of FIG. 2D, since the record in the second row is searched, the advertisement posting destination ID “TKY-CN-001” is acquired, and the concourse advertisement posting destination of the estimated transfer station information data table 300200 is acquired. Record in ID column 300209. The home advertisement posting destination ID 300215 is searched for “8th line home” in the same procedure, and the acquired advertisement posting destination ID is recorded in the home advertisement posting destination ID column 300215.

  In step 6013, the data of each column of the estimated participation station information data table 300300 is acquired and recorded as follows.

  From the record in the second row of the entry / exit record data table 122300 shown in FIG. 2A, the IC card ticket ID 122301 “12-34-56-78”, the entry station 122304 “Totsuka Station”, the entry ticket gate 122314 “the underground ticket gate” ”, The participation date 122305“ 2007/10/01 18:15 ”is acquired, and the IC card ticket ID column 300301, the entry station column 300302, the entry ticket gate column 300303, and the entry date column 300305 in the estimated entry station information data table 300300 are acquired. Record.

  The use route 300309, the direction 300310, the getting-off date and time 300311, and the getting-off platform 300312 are shown in No. 3 of the moving route pattern data table 210200 shown in FIG. Data having the same column name as each column recorded in the record of the column 210211 “022” is acquired and recorded.

  As for the standard movement time 300306 in the station yard and the transit place 300317, the departure station 30031 “Line 3 platform” of the departure station 300302 “Totsuka station” in the estimated transfer station information data table 300300 shown in FIG. The station internal standard travel time information data table 2201 is searched with “underground ticket gate” as the arrival location, and the standard travel time 220104 “00:03” and the via location 220112 “underground passage” are acquired from the record in the third row to be searched. ,Record.

  The estimated station premises stay date 300307 is the time when the station premises standard travel time 300306 “00:03” has elapsed from the alighting date 30012 “2007/10/01 18:10” shown in FIG. / 10/01 18: 10-18: 13 ".

  The ticket gate advertisement posting destination ID 300304 searches the station 230101 of the station premises information database 2301 for “Totsuka Station”, and searches for the advertisement posting location 230102 for “underground ticket gate” from the searched records. In the example of FIG. 2D, since the record in the third line is searched, the advertisement posting destination ID “TTK-K-T-001” is acquired, and the ticket gate advertisement posting destination ID of the estimated entrance station information data table 300300 is acquired. Record in column 300304.

  The concourse advertisement display destination ID 300308 and the home advertisement display destination ID 300313 are searched for “underground passage” and “No. 3 home” in the same procedure, and the acquired advertisement display destination ID is the concourse advertisement display destination ID column 300308 and the home advertisement display. Recorded in the destination ID column 300313.

  In step 6014, data in each column of the estimated boarding train information data table 300400 is acquired and recorded as follows.

  Since the IC card ticket ID 300401 acquires the data of the same column name from the entry / exit record record to be processed, the IC card ticket from the second row record of the entry / exit record data table 122300 shown in FIG. The ID 122301 “12-34-56-78” is acquired, and “12-34-56-78” is recorded in the IC card ticket ID column 300401 of the estimated boarding train information data table 300400.

  The use route 300402, the direction 300403, the boarding station 300404, the boarding date and time 300405, the getting-off station 300406, and the boarding date and time 300407 are the No. of the moving route pattern data table 210200 shown in FIG. Data of the same column name of each column recorded in the record of the column 210211 “022” is acquired and recorded, but No. of the movement route pattern 210200 data table shown in FIG. Since the record including “022” in the column 210211 includes transfer data, a record is created for each train.

  First, the train route 21010102 “Yamanote Line”, the direction 21010103 “outward”, the boarding station 21010101 “Ueno Station”, the boarding time 21010105 “17:10”, the transfer station 21010301 “Tokyo Station” Get-off time 21010305 “17:20” is obtained, “Yamanote Line” is used as the use route 300402 of the estimated boarding train information data table 300400, “outside” is displayed in the direction 300403, “Ueno Station” is used as the boarding station 300404, and “ “2007/10/01 17:10”, “Tokyo Station” at the getting-off station 300406, and “2007/10/01 17:20” at the getting-off date and time 300407 are recorded.

  Since the estimated in-vehicle stay time 300408 is from the boarding date / time 300405 to the getting-off date / time 300407, the boarding date / time 300405 “2007/10/01 17:10” in the estimated boarding train information data table 300400 is 300400 “2007/10/01”. “2007/10/01 17:10 to 17:20” up to “17:20” is recorded in the estimated in-vehicle stay time 300408.

  The in-car advertisement posting destination ID 300409 searches for the advertisement posting destination ID from the in-train information database 2401 by the name of the route for which it is desired to search, and further searches the searched record to acquire the advertisement posting destination ID 240103 of the searched record. In the in-train information data table 240100 shown in FIG. 2 (c), the record in the first row is searched, so the advertisement posting destination ID 240103 “YMT-D-0-001” is acquired and recorded in the in-car advertisement posting destination ID 300409. To do.

  Furthermore, the data of the estimated ride train information data table 300400 of the train that seems to be used for transfer is acquired and recorded in the same procedure as described above.

  In Step 7010, the advertisement posting destination IDs included in the estimated entrance station information data table 300100, the estimated transfer station information data table 300200, the estimated departure station information data table 300300, and the estimated boarding train information 300400 of the estimated travel route information database 2302 and Since the advertisement content display history record of the same advertisement posting destination ID is extracted from the advertisement content display history database 1314, the concourse advertisement of the estimated transfer station information data table is used in the 131400 advertisement content display history data table shown in FIG. Records in the first, second, and third lines having the same advertisement posting destination ID 131401 as the posting destination ID “TKY-CN-001” are extracted.

  In Step 7020, since the date and time when the railway user passes or stays at the advertisement posting destination and the date and time from the display start date and time 131404 to the display end date and time 131405 of the extracted advertisement content display history record are extracted. In the advertisement content display history data table 131400 shown in FIG. 2 (a), the estimated station stay date / time indicating the stay date / time of the concourse advertisement posting destination ID 300209 “TKY-CN-001” in the estimated transfer station information data table 300200. 300208 “2007/10/01 17:20 to 17:25” and the records in the second and third rows are extracted with the same date and time from the display start date and time 131404 to the display end date and time 131405.

  In Step 7030, the contact content list database 1420 is created by using the IC card ticket ID for identifying the railway user based on the advertisement content display history record extracted in Step 7020 as a key. A contact content list data table 142000 is created from the records in the second and third rows of the advertisement content display history data table 131400 with the IC card ticket ID 142001 “12-34-56-78” as a key.

  In step 8010, the linked WEB content URL information database 1322 is searched by the contact advertisement content ID 142005 of the contact content list database 1420, the linked WEB content URL 132202 and the linked WEB content related message 132203 of the searched record are extracted, and the mail text is extracted. Since it is created, the cooperative WEB content URL information data table 132200 is searched with the contact advertisement content IDs 142005 “GH-IJ-KL” and “MN-OP-QR” in the contact content list data table 142000 shown in FIG. The retrieved linked WEB content URL 132202 and the linked WEB content related message 132203 in the second and third lines are extracted to create a mail text.

  In step 8020, since the mail address of the rail user of the IC card ticket ID 142001 that created the mail text is acquired, the IC card ticket link personal information data table 121200 shown in FIG. 2B is stored in the IC card ticket ID 142001. Search for “12-34-56-78”, extract the registered mail address 121202 “12-34-56-78@aaa.ne.jp” of the searched record in the first line, and deliver the mail in step 8030 To do.

  In step 8040, since the mail delivery date 144003 is recorded as the contact content cooperation information mail delivery history database 1440 after mail delivery, it is recorded in the contact content cooperation information mail delivery history data table 1440000 shown in FIG.

It is a block diagram which shows the whole system structure of the advertising content cooperation information provision apparatus which concerns on this invention, and the peripheral system and apparatus related to it. It is a data block diagram which shows the data structure of each information required for the process in the advertising content cooperation information provision apparatus which concerns on this invention. (1/4) It is a data block diagram which shows the data structure of each information required for the process in the advertising content cooperation information provision apparatus which concerns on this invention. (2/4) It is a data block diagram which shows the data structure of each information required for the process in the advertising content cooperation information provision apparatus which concerns on this invention. (3/4) It is a data block diagram which shows the data structure of each information required for the process in the advertising content cooperation information provision apparatus which concerns on this invention. (4/4) It is a flowchart which shows embodiment of the process sequence of the movement path | route of the advertisement content cooperation information provision apparatus which concerns on this invention, a contact content analysis function, a contact content cooperation information mail delivery function, and an advertisement effect analysis function. (1/2) It is a flowchart which shows embodiment of the process sequence of the movement path | route of the advertisement content cooperation information provision apparatus which concerns on this invention, a contact content analysis function, a contact content cooperation information mail delivery function, and an advertisement effect analysis function. (2/2)

Explanation of symbols

1101 IC card ticket 1102 Mobile phone 1103 IC card ticket gate (entrance station)
1104 IC card ticket gate (participating station)
1105 IC card settlement machine (within the ticket gate)
1106 Two-dimensional barcode 1200 IC card ticket data management center 1210 ID management device 1211 Cooperation personal information registration function 1212 IC card ticket cooperation personal information database 1220 Usage data management device 1221 Entrance registration function 1222 Entrance registration function 1223 Entrance / exit record database 1224 Cash deposit / withdrawal registration function 1225 Money deposit / withdrawal record database 1300 Advertising content distribution management center 1310 Advertising display device 1311 Advertising distribution schedule 1312 Advertising content display history database 131400 Advertising content display history data table 131404 Display start date / time 131405 Display end date / time 1320 Advertising Linked Web Device 1321 Advertising Linked Web Content 1322 Linked Web Content URL Information Data Database 1323 WEB access history generation function 1324 WEB access history database 1400 Advertising content cooperation information providing device 1410 Travel route and contact content analysis function 1420 Contact content list 1430 Contact content cooperation information mail distribution function 1440 Contact content cooperation information mail distribution history database 1440 Contact Content cooperation information mail distribution history database 1450 Advertisement effect analysis function 1460 Advertisement effect analysis result 1470 Contact content cooperation information mail 1500 Internet 1600 Mobile terminal / PC (railway user)

Claims (4)

An information distribution method for distributing information of content that a user of a railway line touches while moving to a terminal of the user, wherein a movement route is determined based on information on an entry station and a departure station of the railway line. Route information database storing route information including information for calculating and getting on and off the railway, and entry time when the user passes the ticket gate using an IC card And an entry / exit record information database storing entry / exit record information including the entry time, and a money entry / exit storing purchase record information including the station and time at which the user purchased the product using the IC card. A gold record database, a standard travel time information database in the station where standard travel time information including the standard travel time in the station is stored, and content stored in the station In an information distribution method using an information distribution system connected to a content display history database in which display history information including display time is stored,
The information distribution system includes:
A first movement route pattern that is route information that is a candidate for the user's movement route by searching the route information database based on the user's entry / exit record information stored in the entry / exit record database To calculate
When the number of the first movement route patterns is 1 or more and a predetermined number or less, the first movement route pattern is specified as a confirmed movement route pattern indicating the movement route of the user,
When the calculated first movement path pattern is more than the predetermined number and the purchase record information of the user is stored in the money deposit / withdrawal record information database, a plurality of the first movement path patterns are stored. A second travel route pattern including the station and time of the purchase record information is identified,
When the number of the second movement route patterns is not less than 1 and not more than a predetermined number, the second movement route pattern is specified as the fixed movement route pattern,
When there are more specified second movement path patterns than the predetermined number, the entry of the entry / exit record information stored in the entry / exit record information database from among the plurality of second movement path patterns Within a time shorter than the standard travel time stored in the standard travel time information database, the travel time in the station calculated based on the time and the entry time and the boarding time and the departure time included in the second travel route pattern Identify a third travel route pattern that is
When the number of the third movement route patterns is not less than the predetermined number and not less than 1, the third movement route pattern is specified as the fixed movement route pattern,
A part of the stay time in the station calculated based on the boarding time and the getting off time of the identified fixed movement route pattern and the standard travel time, and the display time of the display history information stored in the content display history database Identify content that overlaps at least part of
An information delivery method comprising delivering information relating to the specified content to the terminal of the user. The information distribution method according to claim 1,
If the number of the third movement route patterns is greater than the predetermined number, the movement route pattern including the boarding time closest to the entry time of the entry record information is selected from the third movement route patterns. An information distribution method characterized by specifying as a pattern. The information distribution method according to claim 1,
When the second movement route pattern cannot be specified, the movement route pattern including the boarding time closest to the entry time of the entry record information is selected from the first movement route patterns. An information distribution method characterized by specifying as follows. The information distribution method according to claim 1,
If the third travel route pattern cannot be specified, the travel route pattern including the boarding time closest to the entrance time of the entrance record information is selected from the second travel route patterns. An information distribution method characterized by specifying as follows.

Images