JP2005208835A - Advertisement medium managing database system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a database system managing information useful to produce an advertisement medium promoting sales on the basis of information about a conventional advertisement medium. <P>SOLUTION: In this database system, sales performance information about sales of a commodity placed in medium information assigned with a plurality of pieces of commodity information and produced on demand from user terminals 24, 26, 28 having displays is managed, and a management screen including result totaling information about the commodity is displayed on the display. In the database system 10, when producing the medium information on demand from the user terminals 24, 26, 28, input of schedule information about sales schedule and the plurality of commodities placed in the medium information is requested, and input of the sales result information about the placed commodity is requested after advertisement medium distribution. Thereafter, on demand from the user terminal, the performance totaling information is produced from the schedule information and the sales performance information, and the management screen is produced. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to an advertisement medium management database system that displays, in an easy-to-understand manner, the sales effect of an advertisement medium such as a catalog or flyer on which a plurality of products are posted, and particularly to an advertisement medium support system used in a non-store business.

  Conventionally, in order to promote sales, advertising media such as leaflets on which sales products are posted from retail stores are issued and distributed to customers. Advertising media is important for sales promotion. Especially in supermarkets and storeless stores, information on a wide variety of products is posted on advertising media, and product images are laid out appropriately to appeal to customers' vision. Such an advertising medium is issued, for example, every week.

  Such publications require the cooperation of many people, from planning to publication. Planning (for example, Christmas special feature) is handled by, for example, the sales promotion department, and the planner of the sales promotion department makes a plan for the publication. The planner decides the theme, and sets the number of listed products and the corresponding frame for each sales department. Each department decides the product to be posted accordingly and submits the information (including explanation and product image). Accordingly, the page layout is instructed, and the manuscripts from many persons in charge are edited accordingly. This creates an electronic publication that is printed on paper.

  Here, as the number of products to be posted on the flyer increases, the product selection and medium layout determination operations become troublesome. Also, if it is issued each week, multiple projects will proceed in parallel. Further, even in the same series of stores, for example, an advertising medium may be issued as a medium with various titles that are different for each product handled (for example, food, household goods, clothing, etc.). Therefore, it is desirable to facilitate publication planning and progress management.

Conventionally, since such information has been transmitted using paper manuscripts, enormous effort has been required to grasp the progress, including management of manuscript excess / deficiency / correction instructions. As a method to reduce the effort in creating flyers / catalogs, a network connecting a product distribution business entity such as a supermarket and a product supply business entity such as a manufacturer and a printing business entity that undertakes the production of a flyer / catalog via a network, Each department in the company uses the computer terminal from the merchandise distribution company side to lay out the layout, present this layout data to the computer terminal of the printing company, perform DTP processing on the printing company side, and create a calibration screen. In summary, a system for efficiently creating a flyer / catalog on a network that is presented on a computer terminal of a merchandise distributor is proposed (Patent Document 1).
Japanese Patent Laid-Open No. 11-195023

  However, when paper manuscripts were shared by many departments in this way, information such as the creation of advertisement plans, contributions to product sales by advertisements, and sales can be further promoted. Information such as the layout of advertisements could not be managed, and it was only based on previous experience by the people involved in each department. Further, as proposed in the above-mentioned Patent Document 1, a plurality of business units involved in flyer / catalog creation and departments of each business unit are connected by various networks including an intranet and the Internet, and flyers are made using each computer terminal.・ Using a system to create a catalog can reduce labor compared to the method using paper manuscripts, but the information transmission medium has only been replaced by sending and receiving data via a network from paper manuscripts. Is superior in terms of speed, but the parties involved in each department of merchandise distributors such as supermarkets who are involved in the creation of flyers and catalogs using this system will promote sales based on previous experience. In terms of determining the layout that seems to be effective, it is not much different from the conventional case, and at the very least, The same flyer will be adopted this year as well, ”he decided without objective support and searched the past data using the system. Is about to call.

  Therefore, the technical problem to be solved by the present invention is to provide a database system that manages information useful for creating an advertising medium that promotes sales based on information of an advertising medium that has been created in the past. That is.

  In order to solve the above technical problem, the present invention provides a database system having the following configuration.

According to a first aspect of the present invention, sales performance information relating to sales of a product posted in medium information created by assigning a plurality of product information for a plurality of products in response to a request from a user terminal having a display. A database system for managing and displaying on the display a management screen including the result total information of the product,
A product information database for storing product information related to the product and media information on a medium on which a plurality of the products are posted, and a management screen is created from the product information database upon receiving a request from the user terminal via a network Management means to
When creating the medium information in response to a request from the user terminal, the management means requests input of schedule information regarding a plurality of products and sales schedules posted in the medium information, and stores the information in the product information database. Manage,
Seeking the input of the sales performance information related to the product posted on the advertising medium related to the media information, managing in the product information database,
In accordance with a request from the user terminal, an advertisement medium management database system is provided that creates a management screen by creating performance summary information from the schedule information and sales performance information.

  In the above-described configuration, the advertisement medium management database system, for example, provides the operator of the user terminal with an easy-to-understand understanding of the results of the previously created advertisement medium and the sales of the products posted on the advertisement medium. This database system for advertising media management, for example, considers the results of the same month last year, supports the creation of the advertising media planned this time, or confirms the results of sales of products, etc., as a material for product selection etc. Used.

  Specifically, media information is created by linking product information of products posted on advertising media and media information related to advertising media on which multiple products are posted, and sales plans for products posted on the media information are created. The schedule information is stored in the medium information. As the schedule information, for example, the number of sales planned for the period in which the advertisement is posted and the sales amount are exemplified. In addition, after the distribution of the advertising medium corresponding to the medium information, the sales result information related to the sales of the posted product at the distribution time is also stored in the product information database. The management means creates record total information using the schedule information and the sales record information and displays it on the display of the user terminal.

  Specifically, the database system for advertisement medium management of the present invention can be configured in various ways as follows.

  According to a second aspect of the present invention, the medium information stores a product posted on the advertisement medium in association with an allocation position thereof, and the management unit is a product posted on a page of a specific advertisement medium. A database system for managing advertising media is provided, which is characterized in that the result total information is created by searching for.

  In the above configuration, the management unit creates the result total information for only the products posted on the predetermined page of the advertisement based on the allocation position of the products posted on the advertising medium stored in the medium information. In general, the sales of products are affected by where they are placed on the advertising medium and how large they are placed. By using the total information, it is possible to facilitate the creation of the advertising medium.

  According to a third aspect of the present invention, the management means includes a medium display area for displaying an advertising medium, and product information, sales result information, and result totals for products displayed in the medium displayed in the medium display area. An advertisement medium management database system according to a second aspect is provided, wherein a management screen including a product area on which information is posted is created.

  In the above configuration, the management means creates a management screen including a medium display area for displaying an advertising medium, and a product area for posting information about a product displayed on the medium displayed in the medium display area. Therefore, product planning and selection can be performed in consideration of the placement frame size, placement position, and placement page while referring to the actual advertisement medium.

  According to a fourth aspect of the present invention, the product information includes information related to a division that handles the product, and the management unit is a division in which sales performance information and performance total information about all products belonging to a specific division are posted. Provided is a database system for managing an advertising medium, characterized in that a management screen having another performance display area is created.

  Generally, there are cases where it is desirable to perform performance evaluation separately for each department, because methods such as purchasing goods differ for each department that handles products. In the above-described configuration, it is possible to evaluate the superiority of each department by looking at the results of the goods for each department among the goods posted on a certain advertising medium. Further, by adding the results for each medium, it is possible to confirm the results for each medium, such as which medium has the highest performance in which department.

  In a fifth aspect of the present invention, the product information includes information related to a department classification that handles the product, and the management means posts sales performance information and performance summary information about individual products belonging to a specific department. Provided is a database system for managing an advertising medium, characterized in that a management screen having a product-specific result display area is created.

  In the above configuration, the results of individual products for each department are displayed. By performing such a result display, a product can be selected for each department.

  According to a sixth aspect of the present invention, the sales performance information includes time information related to sales date and time, and the management means is a time zone in which the sales performance information and the performance total information having a temporal transition for a specific product are posted. Provided is a database system for managing an advertising medium, characterized in that a management screen having another performance display area is created.

  In a seventh aspect of the present invention, the sales performance information includes information on the number of supplies, the amount of supply, and the gross profit, and the management means is any of the number of supplies, the amount of supply, and the gross profit for each product. Creating a management screen having a graph area with a plot with different display forms according to the value of the remaining third item on a graph with the two items as axes. Provide a database system.

  In the above-described configuration, it is possible to analyze profits from sales of products by grasping the relationship between the number of supplies, the amount of supply, and the gross profit for each product. For example, even if the supply number is large and a large amount of goods can be supplied within a predetermined period, if the supply amount is small, the profit is small. Thus, by selecting a product according to the situation of the seller, it is possible to easily select a product to be placed in the advertisement.

  According to an eighth aspect of the present invention, there is provided the advertising medium management database system according to the seventh aspect, wherein the management screen displays the plot color differently according to the value of the third item.

  In a ninth aspect of the present invention, the management means determines the attribute of the user who uses the user terminal from the user identifier, and displays the attribute on the management screen according to the determined attribute of the user. Provided is a database system for managing advertising media, characterized by varying the amount of information.

  According to the first aspect of the present invention, since the products posted on each advertising medium are linked with the product information database, it is easy to create the result total information using the sales result information and the schedule information. Can set up new plans, decide on products to be posted, and submit various manuscripts, etc. by using the advertising media and the results aggregate information corresponding to the products posted on the media as materials. , Can facilitate the work of the people concerned.

  According to the second aspect of the present invention, by creating the performance summary information based on the information on the placement position on the advertising medium that affects the sales of the product, the placement frame size, the placement position, and the placement page are taken into consideration. Product planning and selection can be performed.

  According to the third aspect of the present invention, product planning / selection can be performed in consideration of a placement frame size, a placement position, and a placement page while referring to an actual advertisement medium.

  According to the fourth aspect of the present invention, it is possible to display the results for each department of the product, and it is possible to evaluate which department has the achievement among all departments and the superiority of the department. In addition, since the results are displayed for each medium, it is possible to evaluate the superiority of the medium in each department.

  According to the fifth aspect of the present invention, the superiority of each medium can be evaluated for each product in each department.

  According to the sixth aspect of the present invention, it is possible to perform performance evaluation over time for individual commodities. Specifically, it is possible to grasp the best selling time for each season and the sales tendency for each product, easily grasp the results of seasonal products, etc., and easily plan.

  According to the seventh aspect of the present invention, by selecting a product according to the characteristics of the product and the situation of the seller, it is possible to easily select the product to be posted in the advertisement.

  According to the eighth aspect of the present invention, the third item that is not selected as the axis of the graph can be analyzed by judging the color of the plot.

  Hereinafter, an advertisement medium management database system according to an embodiment of the present invention will be described with reference to the drawings.

  FIG. 1 shows the overall configuration of an advertisement medium creation system, and FIG. 2 shows the flow of information in the system of FIG. In the present embodiment, the advertisement medium to be created is used in non-store sales in which a catalog or the like is periodically sent to a customer, and an order from the customer is received to sell a product.

  In this system, a database system 10 and a store side system 20 are connected via a network 5. The systems 10 and 20 are connected to each other via a local network. The store side system 20 includes a store side server 22 and a plurality of store side terminals 24, 26, and 28. There is not necessarily a plurality of store side terminals, but for convenience of explanation, it is assumed that each store side terminal is provided for each department.

  The store-side departments in which the store-side terminals 24, 26, and 28 are arranged are a media planning department, a sales supervision department, and a sales department. The media planning department plans the entire advertising media and makes strategic decisions. The sales management department selects the products of each department and provides department-wide operational support. The department in charge of sales actually purchases products for each department and performs product planning and selection work. In the system of FIG. 1, each department is clearly divided, but actually, a person in charge of a plurality of departments, for example, a media planning department, may also serve as a person in charge of the sales management department. This system handles a plurality of advertising media (publications published under different titles), and four advertising media with different titles for each regular period (media 1 to 4 as titles, respectively). )).

  The store-side server 22 of the store-side system transmits sales result information regarding the selection of products at the time of creating the advertisement medium, the supply schedule, and the sales results of the entire tempo to the management server 14 of the database system. The store-side terminals 24, 26, and 28 are operated by users of the respective departments that are arranged, access the database system 10, and cause the management server 12 to perform performance aggregation using the GUI of the web browser, thereby creating performance aggregation information. Display the results tabulated results on the screen.

  The database system 10 includes a management server 12 and a product information database 14. The product information database stores the master information, which is information related to all products handled by the store, and the layout of the advertising media for each advertising medium (that is, for each advertising medium title and publication date) and the published products in association with each other. Media information. The management server 12 includes a multi-dimensional aggregation database for aggregating performance aggregation information based on information from the product information database 14 and the store-side server 22. The management server 12 is also a web server, and communicates with the store side system 20 via the network 5.

  As shown in FIG. 3, the management server has a configuration similar to that of a normal computer and includes a CPU 40 that performs overall control. The CPU 40 includes a ROM 45 for storing programs and data, a RAM 46 as a work area, a storage device 47 such as a hard disk drive, an input device 48 such as a keyboard and a mouse, an output device 41 such as a printer, and a display device 42 for performing various displays. And a communication device 43 for communication with the outside. The storage device 47 (for example, a hard disk of a hard disk device) stores the above-described total database software and web server software having a function of totaling information stored in the total database.

  As illustrated in FIG. 4, the aggregation database 12 a of the management server 12 receives supply schedule information and sales performance information from the store-side server 22. Supply schedule information and sales performance information received from the store-side server 22 are respectively stored in a total database. In this specification, both pieces of information are used as performance information. On the other hand, master information and medium information are received from the product information database. The master information includes product information related to the product such as purchase price, sales price, and image, department information related to the department to which the product belongs, buyer information related to the buyer handling the product, user information related to the user who uses this system, and the like. The master information and the medium information do not necessarily need to be stored in the aggregation DB, and it is preferable that only information necessary for the aggregation is taken from the product information DB. The user information is information for distinguishing the position of the buyer, planner, etc. of the user who uses the system, and defines the status of the user on this system, and will be described later. Depending on the status, the information displayed on the user's terminal screen is different, so that the appropriate information is output to the appropriate user (the information disclosed to some users is limited). It will be.

  The track record information, master information, and medium information stored in the total database are used as a multi-dimensional database by the multi-dimensional editing unit at the time of totalization. The web server 12b edits the information stored in the summary database 12a in a multidimensional manner and displays the information on the user terminal by an operation from the user terminal. In the present embodiment, since the displayed screens differ depending on the user's department, the web server 12b is provided with a media planning department totaling unit, a sales management department, and a sales representative. It is divided into a sales department total department used for totalization by department staff.

  The web server 12b receives an operation from the user terminals 24, 26, and 28 and displays the following screen on the user terminal that has received the operation. FIG. 5 is a transition diagram of screens displayed on the user terminal.

  When the user terminal is operated to access the management server 12, first, a main menu is displayed. In the main menu, a display requesting input of a user identifier and a password is made. When the user inputs an identifier and a password and transmits them to the management server 12, the management server determines the department to which the user belongs and displays a predetermined login screen.

  On the login screen, a list of total screens that can be viewed is displayed, and the user can select an arbitrary total screen as necessary. In this embodiment, the person in charge of the media planning department can view the total of all departments individually or as a list. In addition, the person in charge of the sales supervision department can view only the aggregation for the department in charge. In addition, the person in charge of the sales department can view the totals of the products for which he is in charge.

  The summary screens that can be viewed are the results summary screen by department / weekly, the cross results summary screen by department / medium, the product results summary screen by media, the single product time series results summary screen, the media / flyer results summary screen, and by media. It is each screen of a page performance totaling screen and the performance portfolio screen according to goods. Hereinafter, each aggregation screen will be described.

  FIG. 6 is a screen display example of a result tabulation screen by department / weekly displayed on the user terminal of the media planning department. This department / weekly performance summary screen is not displayed on the user terminals of the sales supervision department and sales department. On the department-by-department / week-by-week performance totaling screen, the results are displayed for the total of all products belonging to each department in any given weekly time.

  The department / weekly result totaling screen includes a first frame 50 for displaying a screen name, a comparison target item, a display period, a second frame 51 for displaying a supply number and a supply amount for each department, A third frame 52 that displays the number of supplies and the amount of supply for each medium is displayed.

  In the first frame 50, the comparison target item can be selected from a pull-down menu. The selected comparison target item is displayed in the comparison target column 51 a of the second frame 51 for comparison with the previous comparison and the previous year comparison. The information of the display period selected in the first frame 50 is used as a search item for information on the number of supplies and the amount of supply in the second frame 51, and only the performance information of the selected display organization is obtained from the product information database. The data is taken into the total database 12a and totaled.

  The second frame 51 displays the number of buyers, the number of products, the number of supplies (sales number), and the amount of supply (sales amount) for each department (clothes, confectionery, residence, etc. in FIG. 6). About these items, the sum total of the information in the display period about all the goods which belong to each department is displayed. The items displayed in the supply number include the planned sales number entered when the advertisement medium was created, the actual number of products actually sold, the achievement rate calculated by the actual number / scheduled number, and the actual number / It is the number of supply per person calculated by the number of buyers. Similarly, regarding the supply amount, the planned amount of sales, the actual amount, the achievement rate, and the supply amount per person (calculated by the actual amount / the number of buyers) input at the time of creating the advertisement medium are displayed.

  The third frame shows the number of copies issued for each medium, the number of published products, the number of supplies, the supply amount, the usage rate (calculated by the number of applications / the number of media distributions), and the profit rate ((supply amount-purchase amount) / supply amount. Is calculated).

  According to the results tabulation screen for each department / week, the results of each medium can be compared every week, the results of each department every week, the previous week, and the same week as the previous year. Can be evaluated.

  FIG. 7 is a screen display example of a cross result totaling screen by department / medium displayed on the user terminal of the medium planning department. The cross results tabulation screen for each department / medium is not displayed on the user terminals of the sales management department and sales department. On the cross record summary screen for each department / medium, a record of the total of all products belonging to each department for each medium in any given week is displayed.

  On the cross result totaling screen for each department / medium, the first frame 50 for displaying the screen name, the comparison target item, the display period, and the second frame 53 for displaying the number of supplies and the amount of supply for each medium for each department, A third frame 54 that displays the total of the entire medium is displayed.

  In the first frame 50, the totaling result item can be selected from the pull-down menu. The selected total performance item is displayed in the second frame 53 and the third frame 54. Further, the information of the display period selected in the first frame 50 is used as a search item for information displayed in the second frame 53 and the third frame 54, and the performance information of the selected display institution from the product information database. Only are taken into the total database 12a and totaled.

  The second frame 53 displays performance information of 55 for each department and a total of all departments 56 for each medium. As described above, the displayed result information is an item selected by the total result item of the first frame 50 and is a total value of all the products belonging to each department. In the frame, when the achievement rate is higher than a predetermined value or low, each cell of the table is highlighted, for example, discolored.

  The third frame 54 displays performance information of 57 for each department and 58 for all departments for all media. As described above, the displayed result information is an item selected by the total result item of the first frame 50 and is a total value of all the products belonging to each department.

  According to the cross results tabulation screen for each department / medium, it is possible to evaluate the medium performance and grasp the balance for each department.

  FIG. 8 is a screen display example of the product-by-medium result totaling screen. This divisional / weekly results tabulation screen is displayed on all user terminals in the media planning department, sales supervision department, and sales department. In the divisional / weekly results tabulation screen, the media planning department displays all products in all departments, but the sales management department and sales departments have products in the department in charge of the sales management department. Only the products for which the user is in charge of sales are displayed in the sales department.

  The medium-by-medium product result totaling screen includes a first frame 50 for selecting and displaying a screen name, medium name, department name, buyer name, result totaling item, comparison value, and display period, and a second frame for displaying result information for each product. A frame 59 and a graph 60 showing the comparison value are displayed.

  Information on the media name, department name, buyer name, performance summary item (supply amount, supply number, gross margin only), comparison value, and display period that can be selected in the first frame 50 are stored in the product information database and the summary database. Used to retrieve information. The Media Planning Department can select all of the above information, but the Sales Management Department has fixed values so that the Department Name item cannot be selected, and the Sales Department department cannot select the Department Name and Buyer Name items. ing. These fixed values are determined based on the user's affiliation and name information from the user identifier input at the time of login.

  In the second frame, the performance information regarding the performance summary item for the department and the buyer's handling product selected in the first frame 50 is displayed. The graph 60 displays a graph displayed as a percentage based on the comparison value selected in the first frame 50.

  According to the medium-by-medium product result totaling screen, the results are displayed for each product posted on each medium, so the sales situation for each product can be grasped.

  FIG. 9 is a screen display example of a single item time-series result totaling screen. This single item time-series result totaling screen is displayed on all user terminals in the media planning department, sales management department, and sales department. The single product time series results tabulation screen is selectively displayed for all products in the media planning department, but only the products in the department in charge of the sales management department are available in the sales management department and sales department. In the sales department, only the products for which the user is in charge of sales are selectively displayed.

  On the single item time-series result totaling screen, a first frame 50 for selecting and displaying a screen name, a medium name, a result totaling item, and a display period, and a graph 61 for displaying result information for each product over time are displayed.

  Information about the media name, the result total item (only the supply amount, the supply number, and the gross profit amount) that can be selected in the first frame 50, and the display period are used to search information in the product information database and the total database. In the media planning department, all the above information can be selected, but in the sales supervision department, products other than the own department can be selected, and in the sales department, products other than those handled by the user cannot be selected. These selection restrictions are determined based on the user's affiliation and name information from the user identifier input at the time of login.

  In the graph 61, the performance information regarding the performance summary item for the product selected in the first frame 50 is displayed over time.

  According to the single item time-series result totaling screen, the time-series results for each product can be displayed, and the results can be compared with the previous week. Thereby, it is possible to grasp seasonal products, grasp the best selling time for each item, and grasp the sales trend for each item.

  FIG. 10 is a screen display example of a medium / flyer result totaling screen. This media / flyer result totaling screen is displayed on all user terminals in the media planning department, sales management department, and sales department. The media / flyer results tabulation screen is selectively displayed for all products in the media planning department, but only the products in the department in charge of the sales management department are available in the sales management department and sales department. In the sales department, only the products for which the user is in charge of sales are selectively displayed.

  The medium / flyer record totaling screen includes a first frame 50 for selecting and displaying a screen name, medium name (page designation), record totaling item, and display period, a second frame 62 for displaying an advertisement medium image, and a second frame. And a third frame 63 for displaying the performance items for the products posted on the screen.

  Information on the media name (page designation) selectable in the first frame 50, results totaling items (supply amount, number of supplies, gross margin only), and display period are for searching information in the product information database and the totaling database. Used for.

  In the second frame, a page of the medium in the display period selected in the first frame is displayed. In the third frame, a list of products posted in the second frame and a totaling result item are displayed. In the third frame, in the media planning department, performance information on all the above information is posted, but in the sales supervision department, products other than their own department, and in the sales department, other than products handled by themselves The performance information of is not displayed. These selection restrictions are determined based on the user's affiliation and name information from the user identifier input at the time of login.

  According to the media / flyer result totaling screen, the planning result can be grasped in consideration of the posting page, the posting position in the page, and the frame size.

  FIG. 11 is a screen display example of the medium-specific page result totaling screen. This medium-by-medium page result totaling screen is displayed on all user terminals in the medium planning department, sales management department, and sales department. The media page performance summary screen is selectively displayed for all products in the media planning department, but only the products in the department in charge of the sales management department are available in the sales management department and sales department. In the sales department, only the products for which the user is in charge of sales are selectively displayed.

  The first frame 50 for selecting and displaying a screen name, a medium name (page designation), a result totaling item, a display period, and a sort target (in the order of product numbers in the page or the order of totaling result items) on the medium-based page result totaling screen. And the 2nd frame 64 which displays the performance item about the goods published in the advertising medium selected by the 1st frame is displayed.

  Information on the media name (page designation) selectable in the first frame 50, results totaling items (supply amount, number of supplies, gross margin only), and display period are for searching information in the product information database and the totaling database. Used for.

  In the second frame 64, a list of products posted on the page of the advertising medium selected in the first frame and a totaling result item are displayed. In the second frame 64, in the media planning section, performance information on all the above information is posted, but in the sales management section, products other than the own section are listed, and in the sales department, products other than the products handled by the section are displayed. The performance information about is not displayed. These selection restrictions are determined based on the user's affiliation and name information from the user identifier input at the time of login.

  According to the media / flyer result totaling screen, the planning result can be grasped in consideration of the posting page, the posting position in the page, and the frame size.

  FIG. 12 is a screen display example of a product-specific result portfolio screen. This product-specific performance portfolio screen is displayed on all user terminals in the media planning department, sales management department, and sales department. The product-specific results portfolio screen is selectively displayed for all products in the media planning department, but only the products in the department in charge of the sales management department are displayed in the sales management department and sales department. In the sales department, only products for which the user is in charge of sales are selectively displayed.

  The product-specific result portfolio screen includes a first frame 50 that selectively displays a screen name, a medium name, a result total item, and a display period, and a graph 65 that represents an evaluation for each product with respect to the result total item selected in the first frame. Is displayed.

  Media name selectable in the first frame 50, results totaling item (supplied amount, supplied number, gross profit amount, any combination of two, ie, supplied amount x supplied number, supplied number x gross profit amount, supplied amount x The information on the gross profit amount) and the display period is used for searching information in the product information database and the aggregation database.

  In the second frame, a graph having the result total item selected in the first frame as the XY axes and a position on the graph for each product are plotted. The plots on the graph are ranked for each item value not selected in the first frame, and are displayed in different colors.

  Further, when a plot on the graph is selected with, for example, a mouse cursor, detailed information of the selected product is displayed on the right side of the graph.

  According to the product portfolio screen, you can determine the characteristics of each product by media, department, and buyer as one measurement axis for track results and media effects, and select products when creating advertising media. Can be used as a guide.

  As described above, according to the database system for advertising media management according to the present embodiment, confirmation of past sales promotion effects can be performed using information on sales schedules, information on advertising media, and information on sales results from store terminals. It can be easily performed, and an advertisement can be easily created based on past results.

  In addition, this invention is not limited to the said embodiment, It can implement in another various aspect.

1 is an overall configuration diagram of an advertisement medium creation system according to the present embodiment. It is a figure which shows the flow of the information in the system of FIG. It is a block diagram of the management server of the system of FIG. It is a figure which shows the flow of the information in a management server. It is a transition diagram of the screen displayed on a user terminal. It is the example of a screen display of the division | segmentation and weekly result totaling screen displayed on the user terminal of a media planning department. It is the example of a screen display of the cross results totaling screen classified by department and medium displayed on the user terminal of a medium planning department. It is an example of a screen display of a product result summary screen according to medium. It is an example of a screen display of a single item time series results totaling screen. It is an example of a screen display of a medium / flyer result totaling screen. It is the example of a screen display of the page results totaling screen according to medium. It is a screen display example of the performance portfolio screen classified by product.

Explanation of symbols

1 Advertising media creation system 5 Network (Internet)
DESCRIPTION OF SYMBOLS 10 Database system 12 Management server 14 Merchandise information database 20 Store side system 22 Store side server 24, 26, 28 Store side terminal

Claims (9)

In response to a request from a user terminal having a display, it manages sales performance information related to sales of products posted on medium information created by assigning multiple product information for multiple products, and aggregates the results of the products A database system for displaying a management screen including information on the display,
A product information database for storing product information related to the product and media information on a medium on which a plurality of the products are posted, and a management screen is created from the product information database upon receiving a request from the user terminal via a network Management means to
When creating the medium information in response to a request from the user terminal, the management means requests input of schedule information regarding a plurality of products and sales schedules posted in the medium information, and stores the information in the product information database. Manage,
Seeking the input of the sales performance information related to the product posted on the advertising medium related to the media information, managing in the product information database,
An advertisement medium management database system, wherein a management screen is created by creating performance summary information from the schedule information and sales performance information in response to a request from the user terminal.   The medium information stores a product posted on the advertisement medium in association with an allocation position thereof, and the management means searches for a product posted on a page of a specific advertisement medium and obtains the result total information. The database system for advertisement medium management according to claim 1, wherein the database system is created.   The management means includes a medium display area for displaying an advertising medium, and a product area for displaying product information, sales performance information, and performance summary information about a product posted on the medium displayed in the medium display area. 3. The advertisement medium management database system according to claim 2, wherein a management screen is prepared.   The product information includes information related to a division that handles the product, and the management means includes a department-specific result display area that displays sales result information and result total information for all products belonging to a specific department. The advertisement medium management database system according to any one of claims 1 to 3, wherein the advertisement medium management database system is created.   The product information includes information related to a division that handles the product, and the management means includes a product-by-product result display area for posting sales performance information and performance summary information about individual products belonging to a specific department. The advertisement media management database system according to any one of claims 1 to 4, wherein a screen is created.   The sales performance information includes time information related to the sales date and time, and the management means has a time-based performance display area for posting the sales performance information having a temporal transition of the specific product and the performance total information. The advertisement medium management database system according to any one of claims 1 to 5, wherein the database system is created.   The sales performance information includes information on the number of supplies, the amount of supply, and the gross margin, and the management means sets any two items of the number of supplies, the amount of supply, and the gross margin for each product on the vertical axis and 7. A management screen having a graph area with a plot with different display forms according to the value of the remaining third item is created on the graph with the horizontal axis. The database system for advertising media management as described in any one.   8. The advertisement medium management database system according to claim 7, wherein the management screen displays the plot color differently according to the value of the third item. The management means determines an attribute of a user who uses a user terminal from a user identifier, and varies the amount of information displayed on the management screen according to the determined attribute of the user. The advertising media management database system according to any one of claims 1 to 8.

Images