Program, method, information processing device, and system
A system that analyzes user visit frequency and interval to predict campaign timing for repeat customers, enhancing marketing effectiveness by optimizing campaign timing and coupon expiration dates.
Patent Information
- Application Number
- JP2023083055
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-05-19
- Publication Date
- 2024-11-29
Smart Images

Figure 2024166740000001_ABST
Abstract
Description
[Technical field]
[0001] The present disclosure relates to a program, a method, an information processing device, and a system. [Background technology]
[0002] Recently, systems that analyze the behavior of shoppers have been developed. For example, Literature 1 discloses a system that displays the analysis results based on the frequency with which shoppers visit a specific commercial area and the duration of their stay. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] Special Publication No. 2015-197696 Summary of the Invention [Problem to be solved by the invention]
[0004] On the other hand, the above technology has room for improvement in considering campaigns targeting repeat customers who frequently visit a commercial area. For example, the above technology does not clarify the waiting period until the effectiveness of the advertising campaign is achieved, or the expiration date of the coupon that should be set to maximize the effect.
[0005] An object of the present disclosure is to provide a technology that can more precisely predict the timing of campaigns targeting repeat customers. [Means for solving the problem]
[0006] In the present disclosure, a program is provided that causes a computer having a processor to execute the steps of acquiring location information of a user, calculating a visit record to a specified store within a specified period from the acquired location information, and displaying the visit record in a two-dimensional table with visit frequency and visit interval as parameters. Effect of the Invention
[0007] According to the present disclosure, it becomes possible to more precisely predict the timing of campaigns targeting repeat customers. [Brief description of the drawings]
[0008] [Figure 1] FIG. 2 is a block diagram showing the hardware configuration of the system 1. [Diagram 2] 2 is a block diagram showing the functional configuration of the terminal device 10. FIG. [Diagram 3] FIG. 2 is a block diagram showing the functional configuration of the server 20. [Figure 4] 2 is a diagram showing a structure of a user position information database 221 stored in a storage unit 220 of a server 20. FIG. [Diagram 5] 2 is a diagram showing a structure of a store information database 222 stored in a storage unit 220 of a server 20. FIG. [Figure 6] 2 is a diagram showing a structure of a visit record database 223 stored in a storage unit 220 of the server 20. FIG. [Figure 7] FIG. 2 is a flow diagram illustrating an example of a processing flow of the system 1. [Figure 8] 11 is a flow diagram illustrating an example of the flow of a calculation process (S220) performed by the server 20. FIG. [Figure 9] FIG. 13 is a diagram showing an example of display of visit records. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0009] Hereinafter, an embodiment of the present disclosure will be described with reference to the drawings. In the following description, the same components are denoted by the same reference numerals. Their names and functions are also the same. Therefore, detailed description thereof will not be repeated.
[0010] <1. Embodiment> (1-1. Overview of System 1) An overview of functions provided by the system 1 in this embodiment will be described below. As shown in Fig. 1, the system 1 includes a terminal device 10 used by a user, and a server 20. The terminal device 10 acquires information related to the location of the user.
[0011] The server calculates the frequency and interval of visits to a specified store during a specified period (e.g., one month) based on information about the user's location acquired from the terminal device 10, and displays the user's visit record to the store in a two-dimensional table using the calculated frequency and interval as parameters.
[0012] In this way, the system 1 displays the visit record using the visit frequency and visit interval as parameters, so it becomes possible to more precisely predict the timing of a campaign targeting repeat customers. Details will be described below.
[0013] (1-2. Hardware configuration of System 1) Fig. 1 is a block diagram showing an example of a hardware configuration of a system 1. The system 1 includes a terminal device 10 and a server 20. The terminal device 10 and the server 20 are communicatively connected via a network 30. Note that in Fig. 2, the system 1 is illustrated as including one terminal device 10 from the viewpoint of visibility, but the number of terminal devices 10 is not limited to this example, and may be two or more.
[0014] In this embodiment, a collection of multiple devices may be one server 20. The method of allocating multiple functions required to realize the server 20 according to this embodiment to one or multiple pieces of hardware can be appropriately determined in consideration of the processing capacity of each piece of hardware and / or the specifications required for the server 20.
[0015] The terminal device 10 is realized as a mobile terminal such as a smartphone or a tablet terminal. The terminal device 10 includes a communication IF (Interface) 12, an input device 13, an output device 14, a memory 15, a storage 16, and a processor 19.
[0016] The communication IF 12 is an interface for inputting and outputting signals so that the terminal device 10 can communicate with an external device.
[0017] The input device 13 is a device (for example, a touch panel, a microphone, etc.) for receiving an input operation from a user.
[0018] The output device 14 is a device (such as a display and a speaker) for presenting information to a user.
[0019] The memory 15 is for temporarily storing programs and data to be processed by the programs, and is a volatile memory such as a DRAM (Dynamic Random Access Memory).
[0020] The storage 16 is for storing data, and is, for example, a flash memory or a hard disk drive (HDD).
[0021] The processor 19 is hardware for executing an instruction set written in a program, and is composed of an arithmetic unit, a register, peripheral circuits, and the like.
[0022] The server 20 is a computer capable of communicating with the terminal device 10 via a network 30 such as the Internet, and may be realized as a so-called cloud server, or may be realized as an on-premise server installed in a specific facility, etc. The server 20 includes a communication IF 22, an input / output IF 24, a memory 25, a storage 26, and a processor 29.
[0023] The input / output IF 24 is an interface for connecting an input / output device when performing some input operation on the server 20 or when outputting information from the server 20. As an example, the input / output IF 24 is connected to a keyboard as an input / output device and / or a display as an output device.
[0024] The communication IF 22, memory 25, storage 26 and processor 29 are configured similarly to the communication IF 12, memory 15, storage 16 and processor 19 of the terminal device 10, and therefore description thereof will not be repeated.
[0025] (1-3. Functional configuration of terminal device 10) Fig. 2 is a block diagram showing an example of a functional configuration of the terminal device 10. As shown in Fig. 2, the terminal device 10 includes an input device 13, an output device 14, a communication unit 150, an imaging unit 160, an audio processing unit 170, a storage unit 180, and a control unit 200. The blocks included in the terminal device 10 in Fig. 3 are electrically connected to each other, for example, by a bus or the like.
[0026] The communication unit 150 performs processing such as modulation and demodulation processing for the terminal device 10 to communicate with other devices. The communication unit 150 performs transmission processing on a signal generated by the control unit 200 and transmits the signal to the outside (for example, another terminal device 10). The communication unit 150 performs reception processing on a signal received from the outside and outputs the signal to the control unit 200.
[0027] The input device 13 is a device for inputting instructions or information by a user who operates the terminal device 10. The input device 13 is realized, for example, by a touch-sensitive device 131 or the like in which instructions are input by touching an operation surface. The input device 13 may include a keyboard or a mouse. The input device 13 converts instructions or information input by a user into an electrical signal, and outputs the electrical signal to the control unit 200. The input device 13 may include, for example, a receiving port that receives an electrical signal input from an external input device.
[0028] The output device 14 is a device for presenting information to a user who operates the terminal device 10. The output device 14 is realized, for example, by a display 141 or the like. The display 141 displays data according to the control of the control unit 200. The display 141 is realized, for example, by an LCD (Liquid Crystal Display) or an organic EL (Electro-Luminescence) display or the like.
[0029] The imaging unit 160 includes a camera, receives light with a light receiving element, and inputs the received light as an imaging signal to capture an image of the surroundings of the terminal device 10.
[0030] The audio processing unit 170 performs, for example, digital-analog conversion processing of an audio signal. The audio processing unit 170 converts a signal provided from the microphone 171 into a digital signal and provides the converted signal to the control unit 200. The audio processing unit 170 also provides the audio signal to the speaker 172. The audio processing unit 170 is realized, for example, by a processor for audio processing. The microphone 171 accepts audio input and provides an audio signal corresponding to the audio input to the audio processing unit 170. The speaker 172 converts the audio signal provided from the audio processing unit 170 into audio and outputs the audio to the outside of the terminal device 10.
[0031] The storage unit 180 is realized by, for example, the memory 15, the storage 16, etc., and stores data and programs used by the terminal device 10.
[0032] The position information sensor 190 is a sensor that detects the position of the terminal device 10, and includes, for example, a GPS (Global Positioning System) module. The GPS module functions as a receiving device used in a satellite positioning system. In the satellite positioning system, signals are received from at least three or four satellites, and the current position of the terminal device 10 equipped with the GPS module is detected based on the received signals. The position information sensor 190 may use a GNSS (Global Navigation Satellite System) system other than GPS. Examples of GNSS other than GPS include GLONASS, Galileo, QZSS, and BeiDou. The position information sensor 190 may also be configured using other position detection technologies such as WiFi and Bluetooth beacons.
[0033] The control unit 200 is realized by the processor 19 reading a program stored in the storage unit 180 and executing instructions included in the program. The control unit 200 controls the operation of the terminal device 10. The control unit 200 performs the functions of an operation reception unit 201, a transmission / reception unit 202, and a display control unit 203 by operating according to the program.
[0034] The operation reception unit 201 performs processing for receiving instructions or information input from the input device 13. Specifically, for example, the operation reception unit 201 receives information based on instructions input from the touch-sensitive device 131 or the like.
[0035] The transmitting / receiving unit 202 performs processing for the terminal device 10 to transmit and receive data to and from an external device in accordance with a communication protocol.
[0036] The display control unit 203 controls the display on the display 141 of information to be notified to the user.
[0037] (1-4. Functional configuration of server 20) 3, the server 20 includes a communication unit 210, a storage unit 220, and a control unit 230. The blocks included in the server 20 in FIG 3 are electrically connected to each other via a bus or the like, for example.
[0038] The communication unit 210 performs processing for the server 20 to communicate with external devices.
[0039] The storage unit 220 is realized by, for example, the memory 25 and the storage 26, and stores data and programs used by the server 20. As shown in Fig. 4, the storage unit 220 stores, for example, a user position information database (Data Base / DB) 221, a store information database 222, and a visit record database 223.
[0040] The user position information database 221 is a database that stores data related to the positions of users (hereinafter also referred to as registered users) registered in the system 1. As an example, the user position information database 221 acquires information related to the user's position received from the terminal device 10. The data structure of the user position information database 221 will be described later.
[0041] The store information database 222 is a database that stores data related to stores. As an example, the store information database 222 stores information on the locations of stores (hereinafter also referred to as registered stores) registered in the system 1. The data structure of the store information database 222 will be described later.
[0042] The visit record database 223 is a database that stores data on the record of a user's visit to a registered store (hereinafter, simply referred to as visit record). As an example, the visit record database 223 stores the visit record calculated by a calculation module of the control unit 230. The data structure of the visit record database 223 will be described later.
[0043] The control unit 230 is realized by the processor 29 reading a program stored in the storage unit 220 and executing instructions included in the program. As an example, the control unit 230 performs functions as a transmission / reception module 231, a calculation module 232, and a display module 233 by operating according to the program.
[0044] The transmission / reception module 231 performs processing for the server 20 to transmit and receive data to and from external devices in accordance with a communication protocol.
[0045] The calculation module 232 calculates the visit record of the registered user to the registered store based on the data stored in the user position information database 221 and the store information database 222. The process of the calculation module 232 will be described in detail later.
[0046] The display module 233 displays the visit record calculated by the calculation module 232 on a display connected to the input / output IF 24. The process of the display module 233 will be described in detail later.
[0047] (1-5. Data Structure) 4 to 6, the data structure of the database used in the system 1 will be described. Note that the data structure described below is merely an example, and does not exclude the possession of other databases and data items.
[0048] FIG. 4 is a diagram showing an example of the data structure of the user position information database 221 stored in the storage unit 220 of the server 20. As shown in FIG.
[0049] As shown in FIG. 4, a record of the user position information database 221 includes an item "position information ID", an item "user ID", an item "date", an item "time", an item "latitude", an item "longitude", and the like.
[0050] The item “location information ID” is identification information for identifying location information, and is a primary key for uniquely identifying a record in the user location information database 221 .
[0051] The item "user ID" is identification information for identifying a registered user.
[0052] The item "Date" is information about the date when the location information was acquired.
[0053] The item "time" is information about the time when the location information was acquired.
[0054] The item "latitude" is information about the latitude of the user's location at the time the location information was acquired.
[0055] The item "longitude" is information on the longitude of the user's location at the time the location information was acquired.
[0056] The user position information database 221 may be configured such that, at the timing when position information is received from the terminal device 10, a record corresponding to the position information is added to the user position information database 221.
[0057] FIG. 5 is a diagram showing an example of a data structure of the store information database 222 stored in the storage unit 220 of the server 20. As shown in FIG.
[0058] As shown in FIG. 5, a record of the store information database 222 includes an item "store ID", an item "store name", an item "type", an item "latitude", an item "longitude", and the like.
[0059] The item “store ID” is identification information for identifying a store registered in the system 1, and is a primary key for uniquely identifying a record in the store information database 222.
[0060] The item "store name" is information about the name of the store.
[0061] The item "type" is information about the type of the store, and as an example, information about the type of store, such as "supermarket," "shopping mall," and "restaurant," is stored.
[0062] The item "latitude" is information on the latitude of the location of the store.
[0063] The item "longitude" is information on the longitude of the location of the store.
[0064] The store information database 222 may be configured such that records are added when a store is registered in the system 1.
[0065] FIG. 6 is a diagram showing an example of the data structure of the visit record database 223 stored in the storage unit 220 of the server 20. As shown in FIG.
[0066] As shown in FIG. 6, a record of the visit history database 223 includes an item "visit ID", an item "store ID", an item "target month", an item "user ID", an item "number of visits", an item "visit interval", etc.
[0067] The item “visit ID” is identification information for identifying a visit record, and is a primary key for uniquely identifying a record in the visit record database 223 .
[0068] The item "store ID" is an identifier for identifying a registered store in the visit record.
[0069] The item "target month" is information about the month that is the target period for the visit record.
[0070] The item "user ID" is an identifier for identifying a user in the visit record.
[0071] The item "number of visits" is information about the number of times a registered user visited a registered store during a target period.
[0072] The item "visit interval" is information about the interval at which a registered user visited a registered store during a target period.
[0073] The visit record database 223 may be configured such that a record is added when the calculation module 232 calculates the visit record.
[0074] (1-6. Processing flow) An example of the processing flow of the system 1 will be described below with reference to Figures 7 to 9. In the following example, the server 20 acquires location information from two terminal devices 10 (terminal device 10A and terminal device 10B), but the number of terminal devices 10 is merely an example and is not limited to this number.
[0075] 7, the position information sensor 190 of the terminal device 10A acquires the user's position information. In step S120A, the transmitting / receiving unit 202 of the terminal device 10A transmits the acquired position information to the server 20.
[0076] In step S110B, the position information sensor 190 of the terminal device 10B acquires the user's position information. In step S120B, the transmitting / receiving unit 202 of the terminal device 10B transmits the acquired position information to the server 20.
[0077] In step S210A, the transmitting / receiving module 231 of the server 20 receives the location information from the terminal device 10A. In step S210B, the transmitting / receiving module 231 of the server 20 receives the location information from the terminal device 10B.
[0078] In step S220, the calculation module 232 of the server 20 executes a visit record calculation process. As shown in Fig. 8, in the visit record calculation process (S220), steps S221 and S222 are executed.
[0079] In step S221 of FIG. 8, the calculation module 232 refers to the user position information database 221 and the store information database 222 to calculate the visit frequency (number of visits) of the registered user to each registered store in a predetermined period (for example, one month).
[0080] In step S222, the calculation module 232 refers to the user location information database 221 and the store information database 222 to calculate the visit interval of the registered user to each registered store during a predetermined period.
[0081] 9, when the visit record calculation process (S220) is completed, in step S230, the display module 233 of the server 20 displays the visit record calculated by the calculation module on a display connected to the input / output IF 24. The display module 233 displays the visit record in a two-dimensional table with the visit frequency and the visit interval as parameters. As an example, when displaying the visit record in a two-dimensional table, the display module 233 displays the visit record with one parameter being the number of visits and the other parameter being the visit interval.
[0082] 9 is a diagram showing visit record table 300 as a two-dimensional table displayed by display module 233. In visit record table 300, vertical axis P1 represents the number of times that a user registered in system 1 visited a specific store as a registered store for the second or subsequent time in a target month, and horizontal axis P2 represents the number of days that have passed since a user registered in system 1 last visited the store in question in the target month.
[0083] For example, area D1 indicates that there are users who visited the store nine times in the target month, and two users who visited eight days after their previous visit. Area D2 indicates that there are users who visited the store five times in the target month, and one user who visited 20 days after their previous visit. By displaying the visit record in this way using visit intervals and visit counts, it is possible to grasp the visit trends of repeat customers who visit many times and those who visit infrequently, and this can be used as material for considering sales measures tailored to the characteristics of repeat customers.
[0084] In the visit record table 300, if a value in the table satisfies a predetermined condition, it may be displayed in an identifiable manner. Specifically, as shown in FIG. 9, if a value in the visit record table 300 exceeds a predetermined threshold, it may be displayed as a heat map in which the background color becomes darker as the value increases. Preferably, a plurality of predetermined thresholds may be set, and the background color may be displayed in multiple shades according to the value in the visit record table 300. With such specifications, differences in the tendencies of visiting customers can be easily identified by the shade of the background color, making it possible to distinguish singular points where visiting tendencies differ and consider effective measures.
[0085] (1-7.Summary) As described above, in this embodiment, the system 1 executes the steps of acquiring user location information, calculating the visit record to a specified store within a specified period from the acquired location information, and displaying the visit record in a two-dimensional table with the visit frequency and visit interval as parameters. With this configuration, it is possible to estimate the waiting period until the effectiveness of an advertisement as a campaign is achieved and the expiration date of a coupon to achieve the maximum effect based on the customer's visit record, and therefore it is possible to more precisely predict the timing of a campaign targeting repeat customers.
[0086] <2 Other embodiments> Although the embodiment and its modified examples of the present invention have been described above, the application of the present disclosure is not limited to the above. For example, the system 1 in the present embodiment calculates the visit record for a target month as the predetermined period, but is not limited to this aspect. For example, the visit record for a few months, half a year, one year, etc. may be calculated as the predetermined period.
[0087] The terminal device 10 may be a tablet terminal, a mobile terminal such as a smartphone, or may be realized by a desktop PC, a laptop PC, etc. In this case, the terminal device 10 may be realized by installing software on a home PC or the like, and may be configured to accept operations of a mouse or the like.
[0088] In addition, sharing of specific information via communication lines is mainly performed via a WAN such as the Internet, but between information processing devices, communication may also be performed only via short-range wireless communication such as Bluetooth (registered trademark) and infrared communication without using a WAN.
[0089] In addition, in the above embodiment, an example of a form in which each function is provided by the terminal device 10 or the server 20 is described, but this is not limited to this form, and some or all of the functions may be provided by the terminal device 10, the server 20, or both the terminal device 10 and the server 20 in a form different from the above embodiment.
[0090] In addition, in the above embodiment, each step described as being executed by the terminal device 10 may be executed by the server 20, and each step described as being executed by the server 20 may be executed by the server 20.
[0091] In the above embodiment, a part or all of the database stored in the storage unit 220 of the server 20 may be stored in the terminal device 10. Alternatively, a part or all of the database may be stored in another storage medium such as an external hard disk, and the control unit 230 of the server 20 may refer to it as necessary.
[0092] Furthermore, the present invention may be realized as a program that causes an information processing device to execute the functions of the above-mentioned terminal device 10 or server 20, or as a computer-readable non-transitory recording medium that stores the program.
[0093] <Additional Notes> The matters described in the above embodiments will be supplemented below. (Appendix 1) acquiring user location information in a computer having a processor; A program that executes the steps of: calculating the number of visits to a specified store within a specified period from the acquired location information; and displaying the number of visits in a two-dimensional table using the visit frequency and visit interval as parameters. (Appendix 2) The program according to claim 1, wherein in the displaying step, the visit record is displayed with one parameter being the number of visits and the other parameter being the visit interval. (Appendix 3) 3. The program of claim 2, wherein one parameter is the number of subsequent visits in a given period and the other parameter is the number of days since a previous visit in a given period. (Appendix 4) The program according to claim 1, wherein in the displaying step, if a value in the two-dimensional table satisfies a predetermined condition, the value is displayed in an identifiable manner. (Appendix 5) The program according to claim 4, which displays the two-dimensional table in a heat map by changing the background color shade when the values in the table exceed a predetermined threshold.
[0094] Although several embodiments of the present disclosure have been described above, these embodiments can be implemented in various other forms, and various omissions, substitutions, and modifications can be made without departing from the spirit of the invention. These embodiments and modifications are within the scope of the invention and its equivalents as described in the claims, as well as the scope and spirit of the invention. [Explanation of symbols]
[0095] 1: system, 10: terminal device, 13: input device, 14: output device, 15: memory, 16: storage, 19: processor, 20: server, 25: memory, 26: storage, 29: processor, 30: network, 131: touch-sensitive device, 141: display, 150: communication unit, 160: imaging unit, 170: audio processing unit, 171: microphone, 172: speaker, 180: memory unit, 190: position information sensor, 200: control unit, 201: operation reception unit, 202: transmission / reception unit, 203: display control unit, 210: communication unit, 220: memory unit, 221: user position information database, 222: store information database, 223: visit history database, 230: control unit, 231: transmission / reception module, 232: calculation module, 233: display module, 300: visit history table.
Claims
1. A computer having a processor, acquiring location information of a user; A step of calculating a visit record to a predetermined store within a predetermined period from the acquired location information; and displaying the visit record in a two-dimensional table using visit frequency and visit interval as parameters.
2. In the displaying step, 2. The program according to claim 1, wherein the visit record is displayed using one parameter as the number of visits and the other parameter as the visit interval.
3. The one parameter is the number of second or subsequent visits in the predetermined period, 3. The program of claim 2, wherein the other parameter is the number of days since a previous visit during the predetermined period.
4. 2. The program according to claim 1, wherein in said displaying step, when a value in said two-dimensional table satisfies a predetermined condition, said value is displayed in a distinguishable manner.
5. 5. The program according to claim 4, wherein when a value in the two-dimensional table exceeds a predetermined threshold, the table is displayed as a heat map in which the background color is changed to a lighter shade.
6. A computer implemented method comprising a processor and a memory, the processor performing all of the steps performed in the invention according to claim 1.
7. A program for execution on a computer having a processor and a memory, the program causing the processor to execute all of the steps executed in the invention according to claim 1.
8. A system comprising means for executing all the steps performed in the invention according to claim 1.
Citation Information
Patent Citations
Trade area analysis system
JP2015197696A
