JP5074688B2 - Sales support method, sales support system, and computer program - Google Patents

Description

  The present invention relates to a customer database (DB) for storing customer information including information / identification information for identifying the location of a customer of a business operator and identification information of a sales office in charge of the customer, and a transaction database for storing transaction information for each customer. The present invention relates to a sales support method executed by a computer system in which a host computer provided with (DB) and a sales terminal are connected via a communication network, a sales support system, and a computer program for causing a computer system to execute the sales support method. .

  Conventionally, sales representatives of various businesses have been engaged in daily sales activities in order to develop new customers, secure existing customers, and increase sales. For example, in a financial institution having a large number of sales offices (branches), a customer who is an influential target of sales is extracted based on transaction information stored on a host computer (accounting system) of the information management center every day. The information is sent daily to sales offices in charge of transaction information. Each store distributes the transmitted information to each sales representative according to the area in charge. Each sales representative performs daily sales activities by coloring or marking on the map so that the location of the assigned customer can be seen, and carrying it with a brochure of financial products to be introduced.

  In order to perform such sales activities more efficiently, for example, a plurality of customer addresses (including corporate addresses) and customer information are displayed on a map of a salesperson's mobile communication terminal (Patent Literature). 1) Different displays on the map image so that the number of visits and sales representatives can be identified for multiple customers (Patent Document 2), and the customers extracted under predetermined conditions such as product purchase results are identified on the map Various sales support mechanisms have been proposed, such as displaying in a possible manner (Patent Documents 3 to 5).

JP 2003-76834 A JP 2003-288469 A JP 2004-30563 A JP 2004-227531 A JP 2002-215879 A

  By the way, in the conventional sales support mechanism, the branch office uniquely determines the conditions for narrowing down the customers. For this reason, in the case of a business operator having a large number of sales offices such as financial institutions, it is necessary for each sales office to have the latest transaction information for narrowing down the sales target. Since customer transaction information is highly confidential personal information, it is transmitted and received through a dedicated line within a financial institution. However, sending all transaction information to many sales offices is time-consuming and costly. A big burden. In addition, the branch office also needs facilities and security measures for storing transaction information sent from the host computer.

  On the other hand, as described above, in a financial institution, the host computer narrows down the customers for each sales office and transmits only minimum transaction information and customer information through a dedicated line. However, at the sales office, the received information is printed on paper and distributed to multiple sales representatives. Each sales representative processes the information independently, which increases the burden on the manager and manager and improves sales efficiency. There is a demand for a mechanism to make it happen.

  The present invention has been made to solve such a problem, and can efficiently extract a customer who is a candidate for a business activity of a business operator so that the business activity at the business office can be efficiently performed. An object is to provide a sales support method, a sales support system, and a computer program.

  According to the first main aspect of the present invention, a customer database (DB) for storing customer information including information / identification information for identifying the location of a customer of a business operator and identification information of a sales office in charge of the customer, and the customer A sales support method executed by a computer system in which a host computer including a transaction database (DB) for storing transaction information for each transaction and a sales terminal are connected via a communication network, A transaction information extraction step for extracting the corresponding transaction information from the transaction DB based on the set predetermined extraction condition, and the customer information and responsible sales based on the customer identification information associated with the extracted transaction information A customer information search process for searching for store identification information from the customer DB, and the location information included in the searched transaction information and customer information. A document generation process for generating a sales support document by combining information and a document output process for outputting the generated sales support document in association with sales branch identification information or customer identification information are performed. A method is provided.

  Here, in the present invention, the host computer may execute all the steps, or the sales terminal may execute a part of the steps. In addition, the sales terminal is equipped with a computer system (sales office server, etc.) that is installed in the sales office and connected to the host computer through a dedicated line, and each sales representative carries it and directly through the sales office server or the public line. This includes sales communication terminals and mobile phones that can be connected to the host computer. Furthermore, the location identification information is included in the electronic map data associated with the address information notified from the customer at the start of the transaction, etc., the address code provided by the business with reference to this address information, and the customer identification information. House information (link code) etc.

  In addition, according to the second main aspect of the present invention, a customer database (DB) for storing customer information including information / identification information for identifying the location of a business customer and the identification information of the sales office in charge of the customer A transaction database (DB) for storing transaction information for each customer, transaction information extraction means for extracting corresponding transaction information from the transaction DB based on a predetermined extraction condition set in advance, and extracted transaction information Based on the customer identification information associated with the customer information retrieval means for retrieving the customer information and the identification information of the sales branch from the customer DB, the searched transaction information and the location specifying information included in the customer information, Generating a sales support document by synthesizing the data, and associating the generated sales support document with the sales branch identification information or customer identification information Sales support system characterized by comprising a document output means for outputting is provided.

  According to a third main aspect of the present invention, there is provided a computer-readable computer program comprising information / identification information for identifying a business customer's location and identification information for a sales office in charge of the customer. In a computer system in which a host computer including a customer database (DB) for storing customer information including a transaction database (DB) for storing transaction information for each customer and a sales terminal are connected via a communication network The procedure for extracting the corresponding transaction information from the transaction DB based on the predetermined extraction condition, and the customer identification information associated with the extracted transaction information based on the customer identification information associated with the extracted transaction information By combining the searched transaction information with the location specifying information included in the customer information. A procedure for generating a work support for the document, the computer program characterized by the generated sales support for documents in association with the identification information or the customer identification information of the office to perform the procedure for output is provided.

  According to the present invention, since the transaction information extracted under the predetermined conditions and the customer location are combined to generate the sales support document for each sales branch in charge, the individual sales stores individually according to the transaction information etc. There is no need to select and select customers for sales. As a result, it is possible to efficiently extract customers who are candidates for the sales activities of the business operators and to efficiently perform the sales activities at the sales offices.

  Hereinafter, embodiments in which the present invention is applied to a financial institution such as a bank will be described with reference to the drawings.

(First embodiment)
FIG. 1 is a network configuration diagram and a functional block diagram showing an outline of a sales support system according to the first embodiment of the present invention. In this figure, the sales support system denoted by reference numeral 1 includes a host computer 4 installed in the information management center 3 of the financial institution 2 and sales office terminals 6 and 6 installed in a plurality of sales offices 5 and 5, respectively. Connected through a dedicated line (communication network). The host computer 4 is constituted by one or more computer systems called a known account system, information system, analysis server, database server, etc., or a dedicated computer system. The sales office 5 includes a head office, a branch, a branch office, and the like.

  Each sales office 5 has a plurality of sales representatives, and performs various sales activities for customers 8a, 8b,... In charge by using a sales support map 7 described later created by the sales support system 1. Here, in FIG. 1, a frame surrounding a plurality of customers 8 a, 8 b... Indicates an area in charge of the sales office 5, and an arrow extending from the sales offices 5, 5 indicates a customer in charge of the sales office 5. The customer 8c in this example has a location (address, etc.) in the area in charge of the store B, but is currently a customer in charge of the store A. In addition to administrative divisions, the area in charge is arbitrarily set by the financial institution 2, each sales office 5, an area manager who supervises a plurality of sales offices, or the like. Here, the customers 8 include existing customers who have a transaction experience with any sales office 5 of the financial institution 2 and potential customers who have no transaction experience. As for potential customers, the sales office 5 or the head office from which the customer 8 is extracted based on external information or the like, the fictional sales office indicating that the customer is undecided, etc. are registered as the sales office.

  The host computer 4 includes a CPU, a RAM, a storage device such as an HDD and a ROM (not shown), an input device such as a mouse and a keyboard, an output device such as an LED display and a printer, a communication device such as a modem, and various drives connected via a communication bus. It has a well-known physical configuration. As shown in FIG. 1, the storage device stores a customer database (DB) 10, a transaction information database (DB) 11, a map data storage unit 12, and a sales support map 7 generated by a sales support map generation unit 19 described later. A sales support map storage unit 13, a sales store table 14, and a program storage unit 15 are provided.

  The customer DB 10 is an integrated customer database file (MCIF: Marketing Customer Information File) that is being introduced by various types of businesses in recent years. The customer DB 10 includes master data of personal information such as information for identifying the location of the customer 8 and name. The customer information including the identification information (sales office code) of the sales office 5 in charge of the customer is stored in association with the unique customer identification information (ID). Here, the location identification information is based on the address (master data) reported by the customer and the contact information (workplace, residence, etc.) of the customer other than the address obtained when the sales representative visited the customer. Link code (household information etc.) specified on the electronic map. For example, a customer ID is associated with this link code, and the customer location can be specified on the electronic map as will be described later. The link code is information used for the business support system of the present invention, and the master data is referred to for other processing (printing of various shipping documents, etc.).

  In this embodiment, the sales person in charge of each sales office 5 visits the customer 8, the contents of the sales activity, the visit history information such as the scheduled visit date, etc. The information is stored in association with the code of the sales office 5 in which this sales representative is present. This makes it easier to plan and change the sales activity schedule of each sales representative and to extract sales candidates.

  The transaction DB 11 is generally referred to as an account ledger, and the daily transaction information for each customer includes the code (identification information), the transaction date and time, the transaction type code, and the transaction amount of the sales store 5 in charge of the customer and the sales store 5 in charge of the transaction. Are stored as one record per transaction. Note that the transaction DB 11 may be generated by extracting only data necessary for sales support from an existing account system.

  The map data storage unit 12 introduces and stores digital map data (house map information) created in a vector format, a bitmap format, or the like from an external vendor (not shown). The latest map data is provided from the vendor as needed, and is updated each time.

  The store table 14 stores the address information (prefecture name, city name, town name code, zip code, etc.) of each store 5 and the extraction condition and type code for each store 5 as the store code. Are stored together. In this embodiment, as will be described later, each sales office 5 is limited to a specific extraction condition or can add an original extraction condition. Register in association with the store code of the store 5.

  The program storage unit 15 stores a computer software program that implements the functions of the present invention. When an operator of the financial institution 2 (information management center 3) operates an input device such as a mouse or a keyboard to input various commands (commands), the software program is called on the RAM by the CPU and executed. Thus, the functions of the present invention are achieved in cooperation with the OS (operation system) of the host computer 4.

  Specifically, this computer software program includes a transaction information extraction unit 16 (extraction condition selection reception unit and second extraction condition reception unit), customer information search unit 17, and sales office identification unit 18 in addition to a main program (not shown). , Sales support map generation unit 19 (document output means), customer information update processing unit 20 (customer information update reception unit, customer information update unit), and various kinds of data transmitted / transmitted from the outside such as HDD (each A data registration unit 21 for storing and updating in the DB and storage units 10 to 13) is provided.

  The transaction information extraction unit 16 refers to the default extraction condition set in advance and the sales office table 14, and corresponds to the transaction DB 11 based on the additional extraction conditions associated with the code of the specific sales office 5. Transaction information is extracted. For example, for existing customers, contracts / cancellations of financial products made with any of the sales offices 5 or changes in contract details, application for loans, opening of accounts, deposits and withdrawals to accounts over a predetermined amount, customers The corresponding transaction information is extracted on the condition of at least one of notification of information change, request for estimation of various transactions, request for data, and history information negotiated with one of the sales offices 5. Extraction of transaction information itself can employ a conventional search method. As for potential customers, relevant transaction information is extracted on the condition of at least one of request for estimation of various transactions, request for materials, and history information negotiated with the customer by one of the sales offices 5. It should be noted that the conditions added by a specific sales store 5 are preferably limited to the customer 8 who is in charge of the sales store 5 or the customer 8 who has a location in the assigned area, and the transaction information is preferably extracted. As a result, rapid processing becomes possible, and even when this transaction information is mistakenly distributed to another branch 5, it can be instantly identified based on the customer information.

  The transaction information extraction unit 16 of the present embodiment selects one or more extraction conditions from a plurality of transaction information extraction conditions set by default from any of the branch terminals 6, and is different from the default extraction conditions. When the two extraction conditions are received through a dedicated line, the type code of these extraction conditions is associated with the identification information (code) of the sales office 5 or the sales office terminal 6 and registered in the sales office table 14.

  Among the plurality of extraction conditions set as default, there are some extraction conditions that are almost unnecessary for a specific sales office 5. On the other hand, the specific sales office 5 wants to set its own extraction conditions depending on the characteristics of the area in charge. There are many cases. For example, in a sales office in charge of a commercial district, extraction conditions based on an individual's location such as “high taxpayer” are not familiar. On the other hand, for example, in a new residential area or an area where rental housing for young people is densely populated, or in a sales office that is in charge of a residential area where many wealthy people live, the “new account opening destination” or “investment trusts” There are cases where customers are desired to be extracted under conditions such as “business partners”. It is preferable that the transaction information and the like are stored and extracted independently on the side of the sales office because the burden on the computer system and the operator of the sales office is large and the cost is high.

  The customer information search unit 17 searches the customer DB 10 for basic information such as the location of the customer 8 and the code of the sales office 5 based on the customer ID associated with the extracted transaction information. Here, the customer information search unit 17 also has a function of referring to the visit history information of the customer DB 10 and specifying the customer 8 that has passed a predetermined period from the previous visit date. Information on this unvisited customer is also distributed as transaction information to the terminal 6 of the sales office in charge. Thereby, unvisited destination information can be added to the extracted transaction information, and information useful for narrowing down the priority sales partners can be provided.

  In addition, the customer information search unit 17 of the present embodiment is aggregated from the transaction DB 11 with a function of totaling the transaction amount (the number of transactions and the transaction amount) within a predetermined period (within the latest six months, etc.) for each customer. And a function of extracting customers whose transaction volume is a predetermined value or more. As the “predetermined value” as the extraction condition, for example, there are 100 or more deposits, withdrawals or transfers in 6 months, and the total deposit amount is 10 million yen or more.

  Further, the customer information search unit 17 of the present embodiment refers to the customer DB 10, and when the sales person in charge of the customer 8 related to the extracted transaction information is a specific person, the transaction information is transferred to other transactions. Information that identifies the information (such as a flag or a transaction identification code different from normal) is included. For example, considering the sales results, years of experience, job title, etc., it is possible to register the attributes of customers who want / not want to be assigned to specific sales representatives at each sales office, and such customers are extracted. In such a case, it is preferable from the viewpoint of sales efficiency that it is immediately visible at the sales office in charge.

  The store specifying unit 18 refers to the customer DB 10 for the sales candidate customer 8 (customer who has made a specific transaction, unvisited customer and customer with a large transaction volume) searched by the customer information search unit 17. The sales office 5 is specified. The sales support map 7 is distributed to the sales office 5 specified in this way.

  Here, the store identification unit 18 aggregates the amount of transactions (number of cases, amount of money, ratio thereof, etc.) performed by the sales candidate customer 8 within a predetermined period (for the past 6 months, etc.) It also has a function of specifying another branch 5 whose processing amount is equal to or greater than a set value. As the “set value”, the number of transactions processed for 6 months is 100, the total transaction amount is 10 million yen, or the ratio of the number of transactions is 80% for customers with 100 transactions or more. .

  For example, the customer 8 has opened an account at the sales office 5 near his / her home, but transactions such as deposits and withdrawals are performed at other sales offices 5 of the office or due to moving, the initial sales office 5 will no longer perform transactions. There is a case. When such a customer 8 is extracted as a sales candidate, the transaction information and the like are provided to another sales office 5 having a large transaction volume with the customer 8 separately from the sales office 5 that manages the account. Is preferred. Therefore, in the present embodiment, after a specific customer 8 is extracted from the transaction information, another branch 5 having a large transaction volume is searched from the transaction history of the customer 8. The sales support map 7 incorporating the transaction information of the customer 8 is distributed to the other sales offices 5 thus searched as described later. It should be noted that the other sales offices 5 to be specified are not limited to one, and if it is considered appropriate as a sales representative, two or more “other sales shops” may be searched.

  Further, the sales office specifying unit 18 specifies the area in charge of the sales office 5 with reference to the sales office table 14 based on the sales office code in charge, and determines whether the location of the customer 8 is included in the area in charge. It also has a function to discriminate. If it is out of the assigned area (customer 8c in FIG. 1), the other store 5 including the location of the customer 8 in the assigned area is searched from the store table 14 and the terminal 6 of the other store 5 is searched. Also deliver customer information and transaction information. By extracting other sales offices other than the sales office in charge based on the area in charge and the transaction volume described above, it is possible to extract more appropriate sales offices as sales representatives and further improve sales efficiency. .

  The sales support map generation unit 19 includes the transaction information and location specifying information (in the present embodiment, the link code) of the customer 8 stored in the customer DB 10 or the transaction DB 11 and the location acquired from the map data storage unit 12. A sales support map 7 (sales support document) is generated by synthesizing with the digital map data of the included areas, and a customer basic information display screen (see FIG. 3) described later is generated and related via an in-line dedicated line. To be distributed to the sales office 5. As a delivery method, it may be attached to an e-mail, transmitted, uploaded to an FTP server, or printed on a conventional paper and sent by FAX or mail.

  Specifically, as shown in FIGS. 2 (A) to 2 (C), the sales support map generation unit 19 visually shows hatching corresponding to a plurality of extraction conditions of the customer on the coordinates of the customer location. The displayed image format layers a to c are generated, and the layers a to c are superimposed on the digital map data to generate a sales support map 7 shown in FIG. As an example, layer a shows customers with large deposits of 5 million yen or more within the last week, layer b shows customers who have not visited for more than 6 months, and layer c shows customers with foreign currency deposits. . Thereby, it is possible to easily visually recognize which customer is extracted under which condition. By sending the sales support map 7 created in this way via the terminal 6 of each sales store or directly to the mobile terminal 9 of the sales representative, an efficient sales schedule can be formulated, Customer information and transaction information can be easily confirmed.

  In FIG. 2, for ease of understanding, roads are indicated by alternate long and short dash lines, and all buildings are indicated by broken lines. However, only the locations of customer locations that match the extraction conditions are actually displayed by hatching. . In buildings where multiple people (natural persons / corporations) such as condominiums, apartments, and office buildings are occupying, the entire building is displayed as hatched. A list of a plurality of target customers having locations is displayed on a pop-up screen or a pull-down menu is displayed, and the customer for displaying the customer basic information in FIG. 3 is selected from the branch terminal 6 or the mobile terminal 9 of the sales representative. Is preferred.

  In the present embodiment, one or more of the plurality of layers a, b... N generated for each of the plurality of transaction information are selected and input by the input means of the host computer 4 or the branch terminal 6. The sales support map 7 is generated by superimposing the transaction information layer relating to the extraction condition on the electronic map data. Specifically, the “display layer selection screen” shown in FIG. 4 is displayed on the display (output means) of the branch office terminal 6 or the host computer 4, and only the layer checked in the check box on this screen is combined with the map data. I can do it. Here, the number of the layer number indicates the layer related to the uniform extraction condition set by default in the host computer 4, and the layer number of the alphabet (A, B) indicates that the specific store 5 The layer related to the extraction condition set uniquely is shown.

  In the plurality of layers, a link with the storage area of the sales support map storage unit 13 is set. When the customer position displayed by hatching on the sales support map 7 is clicked with a pointer, the basic information shown in FIG. A screen is generated with a predetermined layout and displayed in a pop-up. In this example, the customer basic information 40 such as the customer's name / location / profession, the information 41 of the sales representative or sales representative, the latest transaction information 42, the visit history 43 of the sales representative, and the information selected from these information. Topics related to the sales activities and fixed messages 44 are displayed. As an example of topics, in addition to the transaction information that is the condition for extracting this customer (payment and withdrawal over 3 million yen, non-visit period, etc.), other business information held in the customer DB 10 is displayed. The

  Further, a “map display” button 50 is also prepared so that the sales support map 7 can be referred to from the customer basic information display screen. Create a document file that visually lists the extracted customer name, location, transaction information topics, etc., and link it to the storage area of the storage device in this file. A button such as “information display” may be set, or a link may be set to a character string or the like to enable mutual reference display.

  Furthermore, a button 51 is set on the basic information display screen for a salesperson who visits the customer to update the customer information. When the sales representative clicks on this button 51 while looking at the branch terminal 6 on which the basic information display screen is displayed, a customer information update request unit 26 described later of the branch terminal 6 is activated, and a customer information update screen (not shown) is displayed. To input customer information addition / modification. The input information is transmitted to the host computer 4 by the customer information update request unit 26.

  The customer information update processing unit 20 inputs the customer information addition / correction information to the sales office terminal 6 or the mobile terminal 9 and requests the customer information to be updated when the sales representative who visits the customer 8 requests the customer information update. The target customer ID and addition / correction information are acquired from the terminal 6 or the like through the in-line dedicated line, and the customer DB 10 is updated. For example, if the customer's address arrives in a postal form but is not accurate (unregistered or different in room number or building name, difference in the last digit of the address, etc.), the visiting sales representative confirms at the site. It is preferable to update to accurate information.

  Here, since the master data of the location specifying information registered in the customer DB 10 is personal information of the customer notified from the customer, it is not preferable to correct it by the judgment of the financial institution 2. On the other hand, in sales activities, information that matches the actual situation of the customer is required, so it is preferable to update the information to the latest information and accurate information as needed. Therefore, the host computer 4 that has acquired the addition / correction information updates only the link code field without updating the master data of the customer DB 10.

  The sales office terminal 6 is a general-purpose computer (sales office server) installed at least one in each sales office 5, and includes a storage device such as a CPU, RAM, HDD, and ROM (not shown), an input device, an output device, and communication. It has a well-known physical configuration in which devices and various drives are connected by a communication bus. The sales office terminal 6 includes a database 22 that stores basic information of customers in charge of the sales office 6, and stores a sales support map 7 periodically transmitted from the host computer 4. 9 and a function of outputting to a printer (not shown). When transferring the sales support map 7 to the mobile terminal 9 of the salesperson, the salesperson can check the customer information and transaction information on the pop-up screen (see FIG. 3) even when away from home.

  The store terminal 6 can be replaced with a mobile terminal 9 owned by a sales representative. That is, the sales support map 7 and customer information may be received directly from the host computer 4 using the communication function of the portable terminal 9. Such centralized processing is efficient when the number of sales offices 5 and terminals 9 is not large. In addition, since it becomes easy for the sales office 5 to set detailed extraction conditions in advance or narrow down (select) a small number of extraction conditions, sales activities are not uniform throughout the country, This can be done flexibly according to the attributes, characteristics, events, etc. of the area in charge of the store. In this case, it is preferable that the sales support map 7 is individually generated based on the salesperson ID or the ID of the mobile terminal 9 and transmitted to each person in charge (mobile terminal 9).

  Alternatively, the mobile terminal 9 may be connected to the branch terminal 6 or the host computer 4 through a public line after taking a predetermined security measure. As a result, the latest sales information and additional information can be provided to the sales staff, and customer information and transaction information can be transmitted to the mobile terminal 9 in real time.

Hereinafter, detailed functions of this embodiment will be described together with actual operations with reference to the flowchart of FIG.
The processing steps of this embodiment include transaction data extraction performed by the transaction information extraction unit 16 (step S1), identification of a customer as a sales candidate performed by the customer information search unit 17 (step S2), and the sales Identification of a sales office candidate as a sales representative candidate performed by the store specifying unit 18 (step S3), generation of a sales support map 7 performed by the sales support map generation unit 27, and distribution to a sales store as a sales representative candidate (step S4) ). Hereinafter, each processing step will be described.

  First, in the transaction data extraction process (step S1), when a predetermined time outside business hours (nighttime or the like) arrives, the transaction information extraction unit 16 is started and the transaction DB 11 is activated according to a plurality of preset extraction conditions. Extraction of transaction information is started (steps S1-1 and S1-2). The extraction condition in this case includes both a uniform condition set by default in the country and a condition additionally set by a specific sales office 5. The transaction information extracted by the additionally set conditions is associated with the code of the sales office 5. When the extraction of transaction information is completed under all conditions (No in step S1-2), the process proceeds to a customer information specifying process.

  In the customer information specifying process (step S2), the customer information search unit 17 specifies a customer ID for all the extracted transaction information (step S2-1). In addition, the number of transactions for each customer and the transaction amount (transaction amount) for all the transaction information for the most recent 6 months are tabulated (step S2-2), and the customer whose either the transaction number or transaction amount has reached a predetermined value or more. Is specified (step S2-3). Even if a conspicuous transaction that satisfies the extraction condition of the transaction information is not performed, a customer with a large transaction volume for a certain period is also a promising business candidate. Furthermore, referring to the visit history field of the customer information DB 11, customers who have not visited for a predetermined period or longer are also extracted (step S2-4).

  In the next step S3, the sales office 5 that is a sales candidate is specified for the customer 8 of the sales candidate that is specified in this way. In this processing step, first, the sales office identification unit 18 searches for the code of the sales office A in charge registered in the customer DB 10 for all the identified customers 8 (step S3-1).

  Here, the sales staff area is identified by referring to the sales office table 14 based on the retrieved sales office code of the responsible sales office A, and the customer location is identified by referring to the customer DB 10 based on the customer ID. The two are compared (step S3-2). If the customer location is outside the responsible sales area of the responsible sales office (No in step S3-2), the sales office identifying unit 18 refers to the responsible area information in the sales office table 14 and includes the customer location in the responsible area. The store B is searched (step S3-3).

  Further, the transaction information for a predetermined period (the last six months, etc.) is aggregated for all the customers specified in the step S2, and the sales store C having the highest number or the processing ratio of processing the transactions of these customers is specified. (Step S3-4). Note that the aggregation period and the criteria for higher order extraction (how many, what percentage, etc.) can be adjusted as appropriate.

  All the branch offices A, B and C identified as described above are registered (updated) in the customer DB 10 as sales representative candidates for each customer (step S3-5).

  Next, the sales support map generating unit 19 is activated to generate a sales support map to be distributed to each store (A to C) (step S4). That is, the sales support map generation unit 19 reads out map data of an area including the locations of all customers specified as sales candidates from the map data storage unit 12 and temporarily stores them in the memory (step S4-1). Next, an image format layer (see FIGS. 2A to 2C) is generated for each of a plurality of extraction conditions (step S4-2), and the sales support map 7 is created by combining with the read map data. (Step S4-3). The sales support map 7 is distributed to all the sales offices A to C of the sales representative candidates specified in step S3 via a dedicated line in the row (step S4-4). The sales support map 7 distributed to the sales offices A to C is transferred to the sales portable terminal 9 or printed on paper by a printer.

  Part or all of the above-described processes from S1 to S4 are executed by the host computer 4 in a batch process outside business hours such as at night. Depending on the amount of information processing, the processing capacity of the host computer, the communication speed of the in-line dedicated line, etc., it is possible to process in real time during business hours. In addition, based on batch processing, when an instruction is issued from a sales office, sales candidate maps are extracted in real time based on the latest transaction information according to the extraction conditions selected from the sales office, and a sales support map is distributed. You may make it do.

  (Second Embodiment)

  Next, a second embodiment of the present invention will be described with reference to FIG. In addition, about the structure which is the same as that of 1st Embodiment mentioned above, or equivalent, the same code | symbol is attached | subjected and duplication description is abbreviate | omitted.

  The sales support system 60 of this embodiment is characterized in that the sales office terminal 62 generates the sales support map 7 based on the transaction information and customer information extracted by the host computer 61. Therefore, the store terminal 62 in this embodiment stores the function of registering transaction information and customer information periodically transmitted from the host computer 61, and digital map data (housing map information) purchased from an external vendor. A function and a function for generating and outputting a sales support map 7 for a sales staff member belonging to the sales office 5 based on the information and the information. Other functions are the same as those in the first embodiment. Further, the host computer 61 similarly executes S1 to S3 of the processing steps described in FIG.

  In this way, by performing distributed processing between the host computer 61 and the branch office terminal 62, the amount of data communication can be reduced, and the load on the in-line line can be minimized. Therefore, the latest transaction information and the like can be distributed to the sales office terminal 62 by increasing the data update frequency. Thereby, the map generation timing and the like can be determined flexibly on the side of the sales office according to the processing capability of the sales office terminal 62, the attendance status of the sales representative, the local event, and the like.

  In addition, this invention is not limited to said embodiment, A various deformation | transformation is possible in the range which does not change the summary of invention.

  For example, in the above-described embodiment, the image format (hatching) is different for each of the plurality of layers and is combined with the map data and displayed, but can be identified in a text format such as numbers, symbols, and character strings. It may be displayed. For example, the characters “1” and “Large” are displayed at the corresponding location of the customer location extracted under the first extraction condition (large deposit destination). In this case, it is preferable to assign a position for marking a number or the like for each layer so that numbers and character strings do not overlap each other when a plurality of layers are displayed in an overlapping manner.

  Alternatively, a specific computer system may be integrated with the host computer 4 as a sales office server, and a plurality of sales office terminals 6 and portable terminals 9 may be connected to this server.

  Further, customer information included (displayed) in the sales support document can be changed according to the user authentication level or the like. Specifically, the reference level of customer information is determined in advance based on personnel data or the like, and the reference level of the user is determined based on login information to the system. For example, sales representatives only have customer information for their branches, managers such as branch managers have customer information for other branches adjacent to their branches, and area managers have multiple branches in other areas adjacent to their branches. The customer information of the branch office, the department in charge of management at the head office, and the manager at the executive level can refer to the customer information of all branches. Thereby, customer information can be managed strictly.

  Moreover, you may make it extract a potential customer based on the house shape information contained in an electronic map. For example, it is possible to extract wealthy customers by calculating the land area from the house shape information, or by calculating the estimated price of the owned real estate by referring to this and the surrounding route price. Thereby, the potential customers in the specific area can be automatically extracted as compared with the case where the prospective customer candidates are extracted based on the telephone directory or the like.

FIG. 1 is a network configuration diagram and a functional block diagram for explaining the outline of the sales support system according to the first embodiment of the present invention. FIG. 2 is a diagram illustrating an example of a plurality of layers and a sales support map. FIG. 3 is a diagram illustrating an example of a pop-up screen of customer information and transaction information. FIG. 4 is a diagram illustrating an example of a display layer selection screen. FIG. 5 is a flowchart showing the processing steps of the present invention. FIG. 6 is a network configuration diagram and a functional block diagram for explaining the outline of the sales support system according to the second embodiment of the present invention.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1,60 ... Sales support system 2 ... Financial institution 3 ... Information management center 4, 61 ... Host computer 5 ... Sales store 6, 62 ... Sales store terminal 7 ... Sales support map 8 (8a-8c) ... Customer 9 ... Mobile terminal 10 ... Customer database (DB)
11 ... Transaction database (DB)
DESCRIPTION OF SYMBOLS 12 ... Map data storage part 13 ... Sales support map storage part 14 ... Sales store table 15 ... Program storage part 16 ... Transaction information extraction part 17 ... Customer information search part 18 ... Sales shop specific part 19 ... Sales support map generation part 20 ... Customer information update processing unit 21 ... Data registration unit 22 ... Basic information database (DB)
26 ... Customer information update request unit 27 ... Sales support map generation unit 40 ... Basic customer information 41 ... Sales office information 42 ... Transaction information 43 ... Visit history information 44 ... Topics message 50 ... Map display button 51 ... Information update button

Claims (12)

A customer DB that manages customer information of financial institutions in association with customer IDs;
The transaction information between the customer and the financial institution is stored in association with the customer ID stored in the customer DB, and the definition of the area in charge of each branch of the financial institution is stored in association with each branch ID. A sales office table,
A sales support method executed by a sales support system having
The customer DB stores master data of personal information including an address reported to a bank by a customer, and a link code for displaying a customer sales visit location and its house shape information on an electronic map. ,
The transaction DB is a transaction information contract / cancellation or change of contract contents, application for financing, opening an account, depositing / withdrawing to an account over a predetermined amount, notification of changes in customer information, various transaction estimates request, obtain information, the information of the negotiation history with the customer, which are stored in association with the customer's customer ID been branch office of the office ID and the transaction was performed the transaction,
The sales support system is connected so as to be able to communicate with a branch terminal provided in each branch,
This sales support method
Computer accepts the input of the extraction condition related transaction information from a specific office terminal, charge from the transaction D B, among the transaction information that matches the extraction condition, the branches on the basis of the customer DB and branches table to extract the transaction information of the customer with a business visited location within the definition of the area and the (0024) customer transaction information extraction process,
Computer, on the basis of the customer ID associated with the extracted transaction information removed link code of the customer from the customer DB, the transaction information and the customer operating a visited location and the synthesis to the visited home A sales support map generation process to display on the electronic map together with the shape;
The computer receives correction / addition information of the customer sales visit location from the branch terminal , and among the customer information associated with each customer of the customer DB based on the received addition / correction information (the master And a customer information update step of updating only the link code ( without updating the data) . The method of claim 1, wherein
The transaction DB stores transaction information including transaction amount and transaction date and time,
This method further
A step in which the computer totals, for each customer ID associated with the transaction information extracted in the customer transaction information extraction step, a transaction amount including either the number of transactions or the transaction amount within a predetermined period from the transaction DB; , before Symbol aggregated transaction volume has a customer information searching process for executing the steps of extracting a customer than a predetermined value,
The sales support map generation unit is configured to extract a link code of the customer from the customer DB based on a customer ID of a customer whose extracted transaction volume is equal to or greater than a predetermined value. A sales support map that is displayed on an electronic map together with the house shape of the visited place is synthesized . The method of claim 1, wherein
The customer DB stores visit history information including a date on which the sales representative visited the customer,
This method further
Customer computer searches for customer information that has passed the customer transaction information extraction process by referring to the access history information of the customer ID and customer DB associated with the extracted transaction information in a predetermined period or more from the previous visit date An information retrieval process,
The sales support map generation unit extracts a link code of the customer from the customer DB based on the customer ID of the customer searched in the customer information search process, and synthesizes the transaction information and the customer location And generating a sales support map to be displayed on the electronic map together with the house shape of the visited place . The method of claim 1, wherein
In the sales support map generation step, the computer generates a text or image format layer visually displaying the transaction information of the customer on the coordinates of the customer location, and overlays the layer on the electronic map data. A method of generating a sales support map. The method of claim 4, wherein
The sales support map generation step, the computer, transaction information generated respectively layers for each transaction information extracted by the plurality of extraction conditions, according to one or more extraction conditions selected by the input means of the office terminal A method for generating a sales support map by superimposing a layer on the electronic map data. The method of claim 1, wherein
Furthermore, the computer, what Re of acceptance through the communications network a selection of one or more extraction condition from a preset plurality of transaction information extraction condition from the office terminal, in association with the sales store ID of the branches (0021) comprising an extraction condition selection receiving step for registering in the sales office table
The顧Kyakuto discount information extraction step, the computer, as the extraction condition, taken out by referring to the one or more extraction condition the sales office selects branches table, the transaction information that matches the extraction condition Among them, based on the customer DB and the sales office table, the transaction information of the customer having the business visiting location is extracted within the definition of the area in charge of the sales office . The method of claim 1, wherein
Further, the computer receives a second extraction condition different from a plurality of transaction information extraction conditions set in advance from the branch terminal via the communication network, and registers it in the branch table in association with the branch ID of the branch. Including a second extraction condition receiving step,
The顧Kyakuto discount information extraction step, the computer, as the extraction condition, with reference to the sales shop table removed the second extraction condition to which the branches are transmitted, among the transaction information that matches the extraction condition, Based on the customer DB and the sales office table, transaction information of a customer who has a business visit location in the definition of the area in charge of the sales office is extracted. The method of claim 1, wherein
The computer refers to the sales office table to determine whether the location specifying information included in the customer information retrieved from the customer DB is within the definition of the area in charge of the sales office in charge, and is outside the definition of the area in charge. In this case, the sales office table includes a sales office specifying process for searching for another sales office that includes the location of the customer in the definition of the area in charge.
In the sales support map generation step, the computer distributes customer information and transaction information to the terminal of the responsible sales store searched from the customer DB and the terminal of the other sales store via the communication network, respectively. A method characterized by. The method of claim 1, wherein
The transaction DB stores transaction information including a store ID of a store in charge of the transaction,
The method further includes a step in which the computer searches the customer DB for information on the customer based on the customer ID associated with the extracted transaction information, and the transaction information within the predetermined period of the searched customer is the transaction. A step of searching from the DB, and a step of counting the number of cases in charge, the total processing amount or the charge ratio for each store within a predetermined period based on the store ID of the store in charge of the transaction included in the searched transaction information. Prepared,
In the sales support map generation step, the computer distributes the sales support map via a communication network to sales offices of sales offices and sales office terminals of one or more sales offices with the highest number of responsible sales. A method characterized in that The method of claim 1, wherein
The sales support map generation process, the computer, and the index file is displayed visually list of customer information and / or the transaction information that has been extracted, and the information display screen that displays the details of the customer information and / or transaction information The index file and the information display screen are generated, and can be referred to each other by a predetermined selection button. A customer DB that manages customer information of financial institutions in association with customer IDs;
The transaction information between the customer and the financial institution is stored in association with the customer ID stored in the customer DB, and the definition of the area in charge of each branch of the financial institution is stored in association with each branch ID. A sales office table,
A sales support system having
The customer DB stores master data of personal information including an address reported to a bank by a customer, and a link code for displaying a customer sales visit location and its house shape information on an electronic map. ,
The transaction DB is a transaction information contract / cancellation or change of contract contents, application for financing, opening an account, depositing / withdrawing to an account over a predetermined amount, notification of changes in customer information, various transaction estimates request, obtain information, the information of the negotiation history with the customer, which are stored in association with the customer's customer ID been branch office of the office ID and the transaction was performed the transaction,
The sales support system is connected so as to be able to communicate with a branch terminal provided in each branch,
This sales support system
Computer accepts the input of the extraction condition related transaction information from a specific office terminal, charge from the transaction D B, among the transaction information that matches the extraction condition, the branches on the basis of the customer DB and branches table to extract the customer transaction information with the business visited location area and the (0024) customer transaction information extraction means,
Computer, on the basis of the customer ID associated with the extracted transaction information removed link code of the customer from the customer DB, the transaction information and the customer operating a visited location and the synthesis to the visited home A sales support map generating means for displaying on the electronic map together with the shape;
The computer receives correction / addition information of the customer sales visit location from the branch terminal , and among the customer information associated with each customer of the customer DB based on the received addition / correction information (the master And a customer information updating means for updating only the link code ( without updating the data) . A customer DB that manages customer information of financial institutions in association with customer IDs;
The transaction information between the customer and the financial institution is stored in association with the customer ID stored in the customer DB, and the definition of the area in charge of each branch of the financial institution is stored in association with each branch ID. A sales office table,
A computer program executed by a sales support system having
The customer DB stores master data of personal information including an address reported to a bank by a customer, and a link code for displaying a customer sales visit location and its house shape information on an electronic map. ,
The transaction DB is a transaction information contract / cancellation or change of contract contents, application for financing, opening an account, depositing / withdrawing to an account over a predetermined amount, notification of changes in customer information, various transaction estimates request, obtain information, the information of the negotiation history with the customer, which are stored in association with the customer's customer ID been branch office of the office ID and the transaction was performed the transaction,
The sales support system is connected so as to be able to communicate with a branch terminal provided in each branch,
This computer program
Computer accepts the input of the extraction condition related transaction information from a specific office terminal, charge from the transaction D B, among the transaction information that matches the extraction condition, the branches on the basis of the customer DB and branches table A customer transaction information extraction instruction to extract the transaction information of customers who have sales offices in the area;
Computer, on the basis of the customer ID associated with the extracted transaction information removed link code of the customer from the customer DB, the transaction information and the customer operating a visited location and the synthesis to the visited home Sales support map generation command to be displayed on the electronic map along with the shape,
The computer receives correction / addition information of the customer sales visit location from the branch terminal , and among the customer information associated with each customer of the customer DB based on the received addition / correction information (the master And a customer information update command for updating only the link code ( without updating the data) .

Images