JP2006099530A - Sales promotion project planning support system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a sales promotion project planning support system capable of planning an effective/statistical sales promotion project in a short time based on a data analysis result about a sales promotion project carried out in the past. <P>SOLUTION: This sales promotion project planning support system is provided with a sales promotion project data storage means storing data about the sales promotion project carried out in the past, a commodity sales data storage means storing data about sale of the sold commodities, a sales promotion project analysis data storage means storing data about the analysis result, an input receipt means receiving input of information about a sales promotion project to be planned, a support information acquisition means acquiring information for supporting the sales promotion project to be planned from the sales promotion project data storage means, the commodity sales data storage means, and the sales promotion project analysis data storage means according to the inputted information about the sales promotion project, and a support information display means displaying the support information acquired by the support information acquisition means. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a sales promotion planning support system useful when planning sales promotion represented by various types of sales.

  Conventionally, various sales promotion plans (for example, sales) have been performed in order to improve the sales performance of products.

  In the sales promotion plan, advertising printed matter (flyers), commercials using TV and radio as media, and decoration of the store are made. The current situation is that merchandise manufacturers, distributors, and even store owners are planning appropriately based on past experience and data.

  However, the contents of sales promotion plans greatly influence the sales of products, and more effective planning methods are being sought. In planning sales promotion plans, the same kind of sales promotion plans made in the past are often referred to, but information related to the sales promotion plans is related to the parties involved in the planning of the plans (for example, products (Manufacturers, distributors, store owners) often own each of them individually, so it is difficult to statistically summarize past information and use it for future planning. When trying to make a new plan collectively, it takes a lot of time and effort.

  The present invention has been made in view of such a situation, and easily obtains data relating to sales promotion plans conducted in the past, product sales data, and results analyzed by a person involved in the sales promotion plan. The main issue is to provide a sales promotion planning support system that can make effective and statistical sales promotion planning in a short time.

  The present invention for solving the above-mentioned problems is a system for supporting the planning of a sales promotion plan that is performed in order to promote the sale of a product, and stores a data related to a sales promotion plan that has been performed in the past. Data storage means, product sales data storage means for storing data relating to sales of products sold in past sales promotion plans, and sales promotion for storing data relating to analysis results of sales promotion plans made in the past Based on the plan analysis data storage means, the input reception means for accepting input of information related to the sales promotion plan to be planned, and the information for supporting the sales promotion plan to be planned based on the information on the input sales promotion plan, The sales promotion plan data storage means, the product sales data storage means, and the sales promotion plan analysis data storage means And having a supporting information obtaining means for al acquired and a support information display means for displaying the obtained support information by the support information obtaining means.

  In the present invention, the data related to the sales promotion plan made in the past may include data related to the advertisement printed matter created at the time of the past sales promotion plan.

  Further, in the present invention, the data related to the analysis result of the sales promotion plan made in the past includes the data related to the analysis result created by the person who drafted the past sales promotion plan, Data related to the analysis result created by the person who procured the sold product and data related to the analysis result created by the person in the store where the past sales promotion plan was performed may be included.

  Further, in the present invention, the information related to the sales promotion plan to be planned, which is input to the input means, is information related to the target product of the sales promotion plan, information about the timing of the sales promotion plan, and the region where the sales promotion plan is performed. 1 or 2 or more of the information regarding the information.

  According to the present invention, the user only has to input predetermined information related to the sales promotion plan, such as information related to the product to be sold in the sales promotion plan to be planned, and information related to the timing of the sales promotion plan. Various data such as data related to sales promotion plans made in the past, data related to sales of products sold in sales promotion plans made in the past, and data related to analysis results of sales promotion plans made in the past. Information can be acquired in a lump, and by using the acquired information, a more effective and comprehensive sales promotion plan can be made in a short time.

  DESCRIPTION OF EMBODIMENTS Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the drawings.

  FIG. 1 is a block diagram showing a schematic configuration example of the sales promotion planning support system according to the present embodiment.

  As shown in FIG. 1, the sales promotion plan planning support system 1 includes a sales promotion plan database 11A as sales promotion plan data storage means, a product sales database 11B as product sales data storage means, and sales promotion plan analysis data storage means. A sales promotion plan analysis database 11C (hereinafter, these three may be collectively referred to as “storage unit 11”), an operation unit 12 as an input receiving unit, a control unit 13 as a support information acquisition unit, And a display unit 14 as support information display means. Each component is connected to each other by a bus 15.

  The sales promotion plan database 11A as a sales promotion plan data storage means stores (registers) various data related to sales promotion plans performed in the past. Specifically, data related to the advertisement printed matter created during the sales promotion plan shown in FIG. 2 (for example, data such as characters, images, illustrations, logos, marks, etc. arranged on the advertisement printed matter), FIG. Data (for example, product name, manufacturer name, product specifications (size, weight, material, color, etc.), standard, product price (manufacturer's desired price, normal price) , Sales price), discount rate, product image, product catchphrase data), data related to the sales promotion plan itself (name of the sales promotion plan, period of the sales promotion plan, venue of the sales promotion plan), etc. Is stored (registered).

  Further, the data related to the sales promotion plan is sequentially updated and accumulated every time the sales promotion plan is performed. In other words, for example, at a certain store, a sales promotion plan that is “New Year's first sale” is held in January every year, a sales promotion plan that is “Summer big sale” is held in August, and “ When a sales promotion plan that is “sale” is performed, data related to all of these sales promotion plans is recorded in the sales promotion plan database 11A.

  The various data related to the sales promotion plan is not limited to the above-mentioned data, and it is preferable that the data is as detailed as the operational effects of the present invention are considered.

  The data stored (registered) in the sales promotion plan database 11A may be input in advance by the user of the sales promotion plan planning support system of the present invention. A computer used when an advertising agency or the like creates an advertisement may be linked to the database 11A so as to be acquired directly.

  In the product sales database 11B as the product sales data storage means, data related to sales of products sold in the past sales promotion plan is stored (registered) in association with the sales promotion plan. Specifically, when the sales promotion plan shown in FIG. 4 is performed at a plurality of locations (stores), sales data for each store, and when the sales promotion plan is performed over several days, every day Sales data, etc. are recorded. The merchandise sales data is also updated and accumulated every time a sales promotion plan is performed, as with the sales promotion plan data.

  The data stored (registered) in the sales database 11B may be input in advance by the user of the sales promotion planning support system of the present invention, and the POS cash register of the store where the sales promotion planning is implemented and The database 11B may be linked and acquired directly.

  The sales promotion plan analysis database 11C as the sales promotion plan analysis data storage means stores (registers) data related to the results of analyzing sales promotion plans made in the past from various angles. Specifically, the data analyzing the sales performance of the advertisement printed products for the same period of the previous year shown in FIG. 5, the data analyzing the relationship between the layout of the printed advertisement used in the sales promotion plan and the sales (which part of the printed advertisement) , Data that shows whether sales are promoted), data that analyzes the relationship between the region and the timing of sales promotion planning and sales, and data that summarizes customer feedback (so-called “customer Voice (customer feedback) data), and data analyzing sales promotion plans of the same type carried out by other companies in the same industry. The sales promotion plan analysis data is also updated and accumulated every time a sales promotion plan is performed, as in the case of the sales promotion plan data and the product sales data.

  Regarding the data stored (registered) in the sales promotion plan analysis database 11C, not only the users who actually make plans using the sales promotion plan planning support system of the present invention, but also the positions of each person involved in the sales promotion plan. It is preferable that the data is analyzed, and by registering such various analysis result data, the sales promotion planning support system of the present invention can be used more effectively.

  When the user of the sales promotion plan planning support system of the present invention intends to plan a new sales promotion plan, he / she inputs information related to the new sales promotion plan from the operation unit 12 (for example, a personal computer terminal) as input receiving means. To do.

  For the information input here, the present invention is not particularly limited. Specifically, for example, data relating to the date and time of a sales promotion plan to be planned, data relating to a product to be sold, and further sales promotion. Information about the store that implements the plan. That is, information that becomes a keyword for picking up related data from the enormous amount of data stored in the storage unit 11 may be arbitrarily selected and input.

  The control unit 13 as support information acquisition means in the sales promotion plan planning support system of the present invention, based on the input information related to the sales promotion plan, provides information for supporting the sales promotion plan to be planned in the future. Obtained from the storage unit 11 as the plan data storage means (11A), the product sales data storage means (11B), and the sales promotion plan analysis data storage means (11C). Examples of the control unit 13 include a CPU (Central Processing Unit) having an arithmetic function, various programs (programs for acquiring appropriate data), a ROM (Read Only Memory) for storing data, and a working memory. A RAM (Random Access Memory) or the like may be included.

  Specifically, for example, when the input information related to the sales promotion plan is the information that “the sale is performed mainly in food in Tokyo 23 wards in early January” (step S1 in FIG. 6), the control is performed. First, the section 13 selects data from the past sales promotion plans stored in the sales promotion planning database 11A for the past five years related to the “new spring first sale sale” which is a sales promotion plan implemented in early January ( At this time, not only data for the beginning of January is simply acquired (pickup), but data acquired before and after the period (for example, three weeks before and after) may be acquired (pickup) at the same time. Data (such as data) relating to the advertisement printed matter created at this time is acquired (pickup) (step S2 in FIG. 6). Next, the control unit 13 acquires (picks up) 20 types of product sales data in the order of highest sales in the beginning of January from the past product sales stored in the product sales database 11B (FIG. 6). Step S3). At this time, not only simply acquiring (pickup) a product with high sales, but also a product newly released from the same manufacturer as the product may be picked up at the same time. Moreover, you may pick up the goods of other makers of the same genre. Further, the control unit 13 analyzes the analysis result data on the sales promotion plan of the same company in the 23 wards of Tokyo in the beginning of January from the analysis results stored in the sales promotion plan analysis database 11C, and the advertisement created in the past. The analysis result data regarding the relationship between the catch phrase described in the printed matter and the product sales, and further the data regarding the “customer's voice” are acquired (pickup) (step 4 in FIG. 6). By acquiring data related to "customer feedback", information that cannot be understood only from the product sales data (for example, products that have been sold but were popular as a result of the product being sold out) is provided to users. can do.

  Further, the control unit 13 may process the information acquired (pickup). Specifically, for example, color-coded for each sales promotion plan that has been carried out in the past, based on the information acquired above, determine the products to be sold in the sales promotion plan to plan in advance, Alternatively, the size of the advertisement photo may be determined.

  The information acquired in this way and the information processed based on the acquired information are transmitted to the display unit 14 as support information display means (step S5 in FIG. 6). As an example, for products other than the standard products, the products posted last time are color-coded, so that the products posted last time can be seen at a glance, and the products posted this time can be easily selected. Further, the size of the product image posted last time can be used to determine the size of the current product image.

  The display unit 14 as the support information display unit in the sales promotion planning support system of the present invention displays the support information acquired by the control unit 13 as the support information acquisition unit to the user. As the display unit 14, for example, when a CPU of a personal computer is used as the support information acquisition means, a monitor of the personal computer may be used.

  A user who intends to create a new sales promotion plan actually performs a planning operation based on various support information displayed on the monitor. Specifically, if the “New Year's first sale sale” is planned, the new “New Year's first sale sale” is based on the data for the past five years and the data related to the advertisement printed matter. The overall image can be grasped, and in the case of creating an advertisement printed matter, the material serving as a starting point can be obtained instantaneously. In addition, based on the sales data of 20 kinds of products in the order of the highest sales in the beginning of January, it is possible to determine the featured products and service products of “New Year's first sale”, and also the daily products. Furthermore, analysis result data on sales promotion plans of competitors in the Tokyo 23 wards in early January, analysis result data on the relationship between catch phrase and product sales described in printed advertisements created in the past, and control Since detailed analysis results such as data automatically processed by the section 13 can be acquired at the same time, a more effective sales promotion plan can be made based on this result.

  As described above, according to the sales promotion plan planning support system of the present invention, the user can sell, for example, information related to a product to be sold in a sales promotion plan to be planned or information related to a timing for performing the sales promotion plan. For example, data related to sales promotion plans made in the past, data related to sales of products sold in sales promotion plans made in the past, and sales made in the past just by entering predetermined information related to promotion plans. Various information such as data related to analysis results of promotion plans can be acquired at once, and more effective and comprehensive sales promotion plans can be made in a short time by using the acquired information. it can.

It is a block diagram which shows the example of an outline structure of a sales promotion plan planning support system. It is a display example of the data memorize | stored in the sales promotion plan database. It is an example of other display of the data memorize | stored in the sales promotion plan database. It is a display example which shows an example of the data memorize | stored in the goods sales database. It is a display example which shows an example of the data memorize | stored in the sales promotion plan analysis database. It is a flowchart figure which shows the process of a support information acquisition means.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Sales promotion plan planning support system 11 ... Memory | storage part 11A ... Sales promotion plan database 11B ... Merchandise sales database 11C ... Sales promotion plan analysis database 12 ... Operation part 13 ... Control part 14 ... Display part 16 ... Bus

Claims (4)

A system that supports the planning of sales promotion plans to promote the sale of products,
Sales promotion plan data storage means for storing data related to sales promotion plans made in the past;
Product sales data storage means for storing data relating to sales of products sold in past sales promotion plans;
Sales promotion plan analysis data storage means for storing data related to the analysis results of sales promotion plans made in the past,
Input accepting means for accepting input of information related to a sales promotion plan to be planned;
Based on the input information related to the sales promotion plan, information for supporting a sales promotion plan to be planned is stored in the sales promotion plan data storage means, the product sales data storage means, and the sales promotion plan analysis data storage means. Support information acquisition means acquired from,
Support information display means for displaying the support information acquired by the support information acquisition means;
A sales promotion planning support system characterized by having   2. The sales promotion planning according to claim 1, wherein the data related to the sales promotion planning performed in the past includes data related to the advertisement printed matter created at the time of the past sales promotion planning. Support system.   The data related to the analysis result of the sales promotion plan made in the past includes the data related to the analysis result created by the person who drafted the past sales promotion plan, the person who procured the product sold in the past sales promotion plan The sales promotion plan planning according to claim 1 or 2, characterized in that data relating to the analysis result created by said person and data relating to the analysis result created by a store person where said past sales promotion plan has been made are included. Support system.   One of the information related to the sales promotion plan to be planned, which is input to the input means, is information about the target product of the sales promotion plan, information about the time when the sales promotion plan is performed, and information about the region where the sales promotion plan is executed, or The sales promotion planning support system according to any one of claims 1 to 3, wherein the information is two or more pieces of information.

Images