A method and system for evaluating the acceptance of new products in drugstores

Abstract

The present invention discloses a method and system for evaluating the acceptance of new products in drugstores. The method comprises the following steps: 1) obtaining order data of various drugs in a target drugstore; the order data comprises the sales time, sales quantity and customer information of the drugs; 2) performing desensitization processing on the data; 3) determining the shelf time of new drug A in the target drugstore according to the order data, and then slicing the data with a period of 30 days to obtain monthly distribution data; 4) calculating the new product acceptance period of new drug A; 5) judging the new product acceptance status of new drug A of each order according to the new product acceptance period of new drug A, and assigning points; 6) counting the scores of each new product acceptance status of new drugs in all customer orders, determining the new product acceptance of drug A in the drugstore; and determining the new product acceptance evaluation level of drug A in retail drugstores. The present invention proposes a quantitative evaluation method for the acceptance of new products in drugstores.

Description

Technical Field

[0001] The present invention relates to big data technology, and in particular to a method and system for evaluating the acceptance of new products in pharmacies. Background Art

[0002] As living habits and social environment gradually change, in order to proactively respond to corresponding changes in the disease spectrum, pharmaceutical companies are actively developing new drugs to prepare for emergencies and reduce dependence on foreign new drugs.

[0003] However, the launch of new drugs faces many risks and challenges. It takes a process for new drugs to penetrate the market, and pharmaceutical companies generally stock the drugs in drugstores. In order to reduce the distribution cost of new drugs and shorten the conversion cycle of new drugs, pharmaceutical companies hope to find drugstores with high acceptance of new products. If they do not understand the customer's acceptance of new drugs, pharmaceutical companies may blindly invest a lot of resources in drug development and promotion, but it is difficult to obtain the expected market returns. Therefore, calculating the customer's acceptance of new drugs has become an important basis for pharmaceutical companies to make wise decisions in the fierce market competition.

[0004] In the era of big data, pharmaceutical companies are increasingly relying on data to make decisions. By collecting and analyzing data on customer acceptance of new drugs, pharmaceutical companies can obtain important information about market demand, patient behavior, and drug performance. This information can help pharmaceutical companies improve the effectiveness and reliability of their decisions. Summary of the invention

[0005] The technical problem to be solved by the present invention is to provide a method and system for evaluating the acceptance of new products in pharmacies in view of the defects in the prior art.

[0006] The technical solution adopted by the present invention to solve the technical problem is: a method for evaluating the acceptance of new products in pharmacies, comprising the following steps:

[0007] 1) Obtaining order data of various drugs in the target pharmacy; the order data includes the sales time, sales quantity and customer information of the drugs;

[0008] 2) Desensitize the data;

[0009] 3) Determine the time when new drug A is put on the shelves in the target pharmacy, and then slice the data with a 30-day period to obtain monthly distribution data;

[0010] 4) Calculate the new product acceptance period of new drug A; the new product acceptance period of drug A is the difference between the date when the number of purchasers of drug A reaches the threshold number within the acceptance period and the date of listing of drug A;

[0011] 4.1) Calculate the cumulative distribution percentage of drug A's monthly sales based on the monthly sales volume of drug A and the total sales volume of drug A;

[0012] 4.2) Perform a second-order difference on the cumulative distribution proportion of drug A, find the points where the sign of the second-order difference changes, take the first value of these points as the inflection point value of drug A, and if there is no inflection point, record the inflection point value of drug A as 0;

[0013] 4.3) Calculate the number of people during the acceptance period:

[0014] n = f*N;

[0015] Among them, f is the inflection point value of product A, N is the number of customers who purchase drug A; n is the threshold number of people in the acceptance period;

[0016] 4.4) After obtaining the threshold number of people within the acceptance period of drug A, the orders are grouped by drug code, sorted by payment date, and duplicate customer IDs in each group are deleted. The payment time of the first order with a number of people greater than or equal to the threshold number of people within the acceptance period of drug A is found, which is the date when the number of people who purchased drug A reached the threshold number of people within the acceptance period;

[0017] 4.5) Obtain the new product acceptance period of drug A based on the date when the number of purchasers of drug A reaches the threshold number of purchasers within the acceptance period and the date of A’s launch;

[0018] 5) Determine the new product acceptance status of new drug A for each order based on the new product acceptance period of new drug A and assign points;

[0019] 6) Counting the scores of the new product acceptance statuses of all new drugs in customer orders to determine the new product acceptance of drug A in the pharmacy; and based on the new product acceptance of drug A in the retail pharmacy, determining the new product acceptance evaluation level of drug A in the retail pharmacy;

[0020] Among them, the new product acceptance degree is the ratio of the sum of the scores of each acceptance status of new products of new drugs in all customer orders to the total number of orders.

[0021] According to the above scheme, in step 4.1), the calculation formula is as follows:

[0022] P = m / M;

[0023] Among them, P is the cumulative distribution share of drug A, m is the monthly sales quantity of drug A, and M is the total sales volume of drug A.

[0024] According to the above scheme, in step 4.3), the calculation formula is as follows:

[0025] n = f*N;

[0026] Among them, f is the inflection point value of product A, N is the number of customers who purchase drug A; and n is the threshold number of people within the acceptance period.

[0027] According to the above scheme, in step 5), the new product acceptance status of the new drug A of each order is determined and scored, as follows:

[0028] If the difference between the payment date of new drug A in the order and the shelf date of the purchased new drug is less than the acceptance period of new drug A, the status of the order is recorded as high acceptance status and is assigned a score of 2;

[0029] If the difference between the payment date of the ordered new drug A and the shelf date of the purchased new drug is between the acceptance period of the new drug A and twice the historical average acceptance period of new drugs, the new product acceptance status of the order is recorded as medium acceptance status and is assigned a score of 1;

[0030] Otherwise, the new product acceptance status of the order is recorded as low acceptance status and is assigned a score of 0.

[0031] A drugstore new product acceptance evaluation system, comprising:

[0032] A data collection module is used to obtain order data of various drugs in the target pharmacy; the order data includes the sales time and sales quantity of the drugs and customer information;

[0033] Data desensitization module, used to desensitize data;

[0034] The data slicing module is used to determine the time when new drug A is put on the shelves in the target pharmacy, and then slice the data in a 30-day period to obtain monthly distribution data;

[0035] The new product acceptance period determination module is used to calculate the new product acceptance period of new drug A; the new product acceptance period of drug A is the difference between the date when the number of purchasers of drug A reaches the threshold number within the acceptance period and the date of listing of drug A; the specific process is as follows:

[0036] 1) Based on the monthly sales volume of drug A and the total sales volume of drug A, calculate the cumulative distribution percentage of drug A's monthly sales;

[0037] P = m / M;

[0038] Where P is the cumulative distribution share of drug A, m is the monthly sales volume of drug A, and M is the total sales volume of drug A;

[0039] 2) Perform a second-order difference on the cumulative distribution proportion of drug A, find the points where the sign of the second-order difference changes, take the first value of these points as the inflection point value f of drug A, and if there is no inflection point, record the inflection point value of drug A as 0;

[0040] 3) Calculate the number of people during the acceptance period:

[0041] n = f*N;

[0042] Among them, f is the inflection point value of product A, N is the number of customers who purchase drug A; n is the threshold number of people in the acceptance period;

[0043] 4) After obtaining the threshold number of people within the acceptance period of drug A, the orders are grouped by drug code, sorted by payment date, and duplicate customer IDs in each group are deleted (only the customer's first purchase is counted). The payment time of the first order with a number of people greater than or equal to the threshold number of people within the acceptance period of drug A is found, which is the date when the number of people who purchased drug A reached the threshold number of people within the acceptance period;

[0044] 5) Obtain the new product acceptance period of drug A based on the date when the number of purchasers of drug A reaches the threshold number of purchasers within the acceptance period and the date of A’s launch;

[0045] A new product acceptance status determination module is used to determine the new product acceptance status of the new drug A of each order according to the new product acceptance period of the new drug A;

[0046] If the difference between the payment date of new drug A in the order and the shelf date of the purchased new drug is less than the acceptance period of new drug A, the status of the order is recorded as high acceptance status and is assigned a score of 2;

[0047] If the difference between the payment date of the ordered new drug A and the shelf date of the purchased new drug is between the acceptance period of the new drug A and twice the historical average acceptance period of new drugs (or 365 days), the new product acceptance status of the order is recorded as medium acceptance status and is assigned a score of 1;

[0048] Otherwise, the new product acceptance status of the order is recorded as low acceptance status and assigned a score of 0;

[0049] A new product acceptance evaluation module is used to count the scores of the new product acceptance statuses of new drugs in all customer orders to determine the new product acceptance of drug A in the pharmacy; and based on the new product acceptance of drug A in the retail pharmacy, determine the new product acceptance evaluation level of drug A in the retail pharmacy;

[0050] Among them, the new product acceptance degree is the ratio of the sum of the scores of each acceptance status of new products of new drugs in all customer orders to the total number of orders.

[0051] The beneficial effects produced by the present invention are:

[0052] The present invention proposes a quantitative evaluation method for the acceptance of new products in pharmacies, which aims to understand the acceptance of the characteristics, functions and advantages of new products by corresponding consumers in the pharmacy operating area. It can help companies predict and evaluate the market penetration rate and conversion cycle of their new drugs, which can serve as a basis for marketing strategies or product upgrades, thereby improving the operating conditions of pharmacies and consumer satisfaction. BRIEF DESCRIPTION OF THE DRAWINGS

[0053] The present invention will be further described below with reference to the accompanying drawings and embodiments, in which:

[0054] Figure 1 It is a flow chart of a method according to an embodiment of the present invention. DETAILED DESCRIPTION

[0055] In order to make the purpose, technical solution and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.

[0056] like Figure 1 As shown, a method for evaluating the acceptance of new products in pharmacies includes the following steps:

[0057] 1) Obtaining order data of various drugs in the target pharmacy; the order data includes the sales time and sales quantity of the drugs and customer information;

[0058] 2) Desensitize the data;

[0059] If there is missing data, the missing data needs to be filled.

[0060] The operation is as follows: First, divide the orders by drug: divide the drug data set into k groups by drug code; then, assign the orders corresponding to each drug to its corresponding group, and divide the order data into k groups; then, divide the k groups of order data into two groups: divide by date, and divide all order data within one month into one group, for example, from August 2020 to January 2024, there are 43 months, and all order data are divided into 43 parts by month. In this way, when filling in the missing values ​​of the data, you only need to loop through these 43 groups, which can reduce the running memory.

[0061] 3) Determine the time when new drug A is put on the shelves in the target pharmacy, and then slice the data with a 30-day period to obtain monthly distribution data;

[0062] 4) Calculate the new product acceptance period of new drug A; the new product acceptance period of drug A is the difference between the date when the number of purchasers of drug A reaches the threshold number within the acceptance period and the date of listing of drug A;

[0063] 4.1) Calculate the cumulative distribution percentage of drug A's monthly sales based on the monthly sales volume of drug A and the total sales volume of drug A;

[0064] P = m / M;

[0065] Where P is the cumulative distribution share of drug A, m is the monthly sales volume of drug A, and M is the total sales volume of drug A;

[0066] 4.2) Perform a second-order difference on the cumulative distribution proportion of drug A, find the points where the sign of the second-order difference changes, take the first value of these points as the inflection point value of drug A, and if there is no inflection point, record the inflection point value of drug A as 0;

[0067] 4.3) Calculate the number of people during the acceptance period:

[0068] n = f*N;

[0069] Among them, f is the inflection point value of product A, N is the number of customers who purchase drug A; n is the threshold number of people in the acceptance period;

[0070] 4.4) After obtaining the threshold number of people within the acceptance period of drug A, group the orders by drug code, sort by payment date, and delete the duplicate customer IDs in each group (only the customer's first purchase is counted). Find the payment time of the first order with a number of people greater than or equal to the threshold number of people within the acceptance period of drug A, which is the date when the number of people who purchased drug A reached the threshold number of people within the acceptance period;

[0071] 4.5) Obtain the new product acceptance period of drug A based on the date when the number of purchasers of drug A reaches the threshold number of purchasers within the acceptance period and the date of A’s launch;

[0072] 5) Determine the new product acceptance status of new drug A for each order based on the new product acceptance period of new drug A;

[0073] If the difference between the payment date of new drug A in the order and the shelf date of the purchased new drug is less than the acceptance period of the new drug, the status of the order is recorded as high acceptance status and is assigned a score of 2;

[0074] If the difference between the payment date of the ordered new drug A and the shelf date of the purchased new drug is between the acceptance period of the new drug and twice the historical average acceptance period of the new drug (or 365 days), the new drug acceptance status of the order is recorded as medium acceptance status and is assigned a score of 1;

[0075] Otherwise, the new product acceptance status of the order is recorded as low acceptance status and assigned a score of 0;

[0076] 6) Counting the scores of the new product acceptance statuses of all new drugs in customer orders, determining the new product acceptance of drug A in the pharmacy; and determining the new product acceptance evaluation level of drug A in the retail pharmacy based on the new product acceptance of drug A in the retail pharmacy;

[0077] Among them, the new product acceptance degree is the ratio of the sum of the scores of each acceptance status of new products of new drugs in all customer orders to the total number of orders.

[0078] Set thresholds based on actual conditions and grade new product acceptance assessment. For example, if the new product acceptance rate is >= 80%, the new product acceptance assessment grade is high; if 80%> new product acceptance rate>= 50%, the new product acceptance assessment grade is medium; if the new product acceptance rate is < 50%, the new product acceptance assessment grade is low.

[0079] The present invention also includes a drugstore new product acceptance evaluation system, comprising:

[0080] A data collection module is used to obtain order data of various drugs in the target pharmacy; the order data includes the sales time and sales quantity of the drugs and customer information;

[0081] Data desensitization module, used to desensitize data;

[0082] The data slicing module is used to determine the time when new drug A is put on the shelves in the target pharmacy, and then slice the data in a 30-day period to obtain monthly distribution data;

[0083] The new product acceptance period determination module is used to calculate the new product acceptance period of new drug A; the new product acceptance period of drug A is the difference between the date when the number of purchasers of drug A reaches the threshold number within the acceptance period and the date of listing of drug A; the specific process is as follows:

[0084] 1) Based on the monthly sales volume of drug A and the total sales volume of drug A, calculate the cumulative distribution percentage of drug A's monthly sales;

[0085] P = m / M;

[0086] Where P is the cumulative distribution share of drug A, m is the monthly sales volume of drug A, and M is the total sales volume of drug A;

[0087] 2) Perform a second-order difference on the cumulative distribution proportion of drug A, find the points where the sign of the second-order difference changes, take the first value of these points as the inflection point value f of drug A, and if there is no inflection point, record the inflection point value of drug A as 0;

[0088] 3) Calculate the number of people during the acceptance period:

[0089] n = f*N;

[0090] Among them, f is the inflection point value of product A, N is the number of customers who purchase drug A; n is the threshold number of people in the acceptance period;

[0091] 4) After obtaining the threshold number of people within the acceptance period of drug A, the orders are grouped by drug code, sorted by payment date, and duplicate customer IDs in each group are deleted (only the customer's first purchase is counted). The payment time of the first order with a number of people greater than or equal to the threshold number of people within the acceptance period of drug A is found, which is the date when the number of people who purchased drug A reached the threshold number of people within the acceptance period;

[0092] 5) Obtain the new product acceptance period of drug A based on the date when the number of purchasers of drug A reaches the threshold number of purchasers within the acceptance period and the date of A’s launch;

[0093] A new product acceptance status determination module is used to determine the new product acceptance status of the new drug A of each order according to the new product acceptance period of the new drug A;

[0094] If the difference between the payment date of new drug A in the order and the shelf date of the purchased new drug is less than the acceptance period of the new drug, the status of the order is recorded as high acceptance status and is assigned a score of 2;

[0095] If the difference between the payment date of the ordered new drug A and the shelf date of the purchased new drug is between the acceptance period of the new drug and twice the historical average acceptance period of the new drug (or 365 days), the new drug acceptance status of the order is recorded as medium acceptance status and is assigned a score of 1;

[0096] Otherwise, the new product acceptance status of the order is recorded as low acceptance status and assigned a score of 0;

[0097] The new product acceptance evaluation module is used to count the scores of the new product acceptance status of the new drugs in all customer orders to determine the new product acceptance of drug A in the pharmacy; and based on the new product acceptance of drug A by the retail pharmacy, determine the new product acceptance evaluation level of drug A in the retail pharmacy;

[0098] Among them, the new product acceptance degree is the ratio of the sum of the scores of each acceptance status of new products of new drugs in all customer orders to the total number of orders.

[0099] Set thresholds based on actual conditions and grade new product acceptance assessment. For example, if the new product acceptance rate is >= 80%, the new product acceptance assessment grade is high; if 80%> new product acceptance rate>= 50%, the new product acceptance assessment grade is medium; if the new product acceptance rate is < 50%, the new product acceptance assessment grade is low.

[0100] It should be understood that those skilled in the art can make improvements or changes based on the above description, and all these improvements and changes should fall within the scope of protection of the appended claims of the present invention.

Claims

1. A method for evaluating the acceptance of new products in drugstores, characterized in that: The following steps are involved: 1) Obtaining order data of various drugs in the target pharmacy; the order data includes the sales time, sales quantity and customer information of the drugs; 2) Desensitize the data; 3) Determine the time when new drug A is put on the shelves in the target pharmacy, and then slice the data with a 30-day period to obtain monthly distribution data; 4) Calculate the new product acceptance period of new drug A; the new product acceptance period of drug A is the difference between the date when the number of purchasers of drug A reaches the threshold number within the acceptance period and the date of listing of drug A; 4.1) Calculate the cumulative distribution percentage of drug A's monthly sales based on the monthly sales volume of drug A and the total sales volume of drug A; 4.2) Perform a second-order difference on the cumulative distribution proportion of drug A, find the points where the sign of the second-order difference changes, take the first value of these points as the inflection point value of drug A, and if there is no inflection point, record the inflection point value of drug A as 0; 4.3) Calculate the number of people during the acceptance period: 4.4) After obtaining the threshold number of people within the acceptance period of drug A, the orders are grouped by drug code, sorted by payment date, and duplicate customer IDs in each group are deleted. The payment time of the first order with a number of people greater than or equal to the threshold number of people within the acceptance period of drug A is found, which is the date when the number of people who purchased drug A reached the threshold number of people within the acceptance period; 4.5) Obtain the new product acceptance period of drug A based on the date when the number of purchasers of drug A reaches the threshold number of purchasers within the acceptance period and the date of A’s launch; 5) Determine the new product acceptance status of new drug A for each order based on the new product acceptance period of new drug A and assign points; 6) Counting the scores of the new product acceptance statuses of all new drugs in customer orders to determine the new product acceptance of drug A in the pharmacy; and based on the new product acceptance of drug A in the retail pharmacy, determining the new product acceptance evaluation level of drug A in the retail pharmacy; Among them, the new product acceptance degree is the ratio of the sum of the scores of each acceptance status of new products of new drugs in all customer orders to the total number of orders.

2. The method for evaluating the acceptance of new products in drugstores according to claim 1, characterized in that: In step 4.1), the cumulative distribution percentage of drug A's monthly sales is calculated as follows: P = m / M; Among them, P is the cumulative distribution share of drug A, m is the monthly sales quantity of drug A, and M is the total sales volume of drug A.

3. The method for evaluating the acceptance of new products in drugstores according to claim 1, characterized in that: In step 4.3), the number threshold within the acceptance period is calculated as follows: n = f*N; Among them, f is the inflection point value of product A, N is the number of customers who purchase drug A; and n is the threshold number of people within the acceptance period.

4. The method for evaluating the acceptance of new products in drugstores according to claim 1, characterized in that: In step 5), the new product acceptance status of the new drug A of each order is determined and scored, as follows: If the difference between the payment date of new drug A in the order and the shelf date of the purchased new drug is less than the acceptance period of new drug A, the status of the order is recorded as high acceptance status and is assigned a score of 2; If the difference between the payment date of the ordered new drug A and the shelf date of the purchased new drug is between the acceptance period of the new drug A and twice the historical average acceptance period of new drugs, the new product acceptance status of the order is recorded as medium acceptance status and is assigned a score of 1; Otherwise, the new product acceptance status of the order is recorded as low acceptance status and is assigned a score of 0.

5. A drugstore new product acceptance evaluation system, characterized in that: include: Data collection module, used to obtain order data of various drugs in target pharmacies; The order data includes the sales time and sales quantity of the drug and customer information; Data desensitization module, used to desensitize data; The data slicing module is used to determine the time when new drug A is put on the shelves in the target pharmacy, and then slice the data in a 30-day period to obtain monthly distribution data; The new product acceptance period determination module is used to calculate the new product acceptance period of new drug A; the new product acceptance period of drug A is the difference between the date when the number of purchasers of drug A reaches the threshold number within the acceptance period and the date of listing of drug A; the specific process is as follows: 1) Based on the monthly sales volume of drug A and the total sales volume of drug A, calculate the cumulative distribution percentage of drug A's monthly sales; 2) Perform a second-order difference on the cumulative distribution proportion of drug A, find the points where the sign of the second-order difference changes, take the first value of these points as the inflection point value f of drug A, and if there is no inflection point, record the inflection point value of drug A as 0; 3) Calculate the number of people during the acceptance period: 4) After obtaining the threshold number of people within the acceptance period of drug A, the orders are grouped by drug code, sorted by payment date, and duplicate customer IDs in each group are deleted. The payment time of the first order with a number of people greater than or equal to the threshold number of people within the acceptance period of drug A is found, which is the date when the number of people who purchased drug A reached the threshold number of people within the acceptance period; 5) Obtain the new product acceptance period of drug A based on the date when the number of purchasers of drug A reaches the threshold number of purchasers within the acceptance period and the date of A’s launch; A new product acceptance status determination module is used to determine the new product acceptance status of the new drug A of each order according to the new product acceptance period of the new drug A; If the difference between the payment date of new drug A in the order and the shelf date of the purchased new drug is less than the acceptance period of new drug A, the status of the order is recorded as high acceptance status and is assigned a score of 2; If the difference between the payment date of the ordered new drug A and the shelf date of the purchased new drug is between the acceptance period of the new drug A and twice the historical average acceptance period of new drugs, the new product acceptance status of the order is recorded as medium acceptance status and is assigned a score of 1; Otherwise, the new product acceptance status of the order is recorded as low acceptance status and assigned a score of 0; A new product acceptance evaluation module is used to count the scores of the new product acceptance statuses of new drugs in all customer orders to determine the new product acceptance of drug A in the pharmacy; and based on the new product acceptance of drug A in the retail pharmacy, determine the new product acceptance evaluation level of drug A in the retail pharmacy; Among them, the new product acceptance degree is the ratio of the sum of the scores of each acceptance status of new products of new drugs in all customer orders to the total number of orders.

6. The drugstore new product acceptance evaluation system according to claim 5, characterized in that: The cumulative distribution percentage of drug A's monthly sales is calculated as follows: P = m / M; Among them, P is the cumulative distribution share of drug A, m is the monthly sales quantity of drug A, and M is the total sales volume of drug A.

7. The drugstore new product acceptance evaluation system according to claim 5, characterized in that: The headcount threshold during the acceptance period is calculated as follows: n = f*N; Among them, f is the inflection point value of product A, N is the number of customers who purchase drug A; and n is the threshold number of people within the acceptance period.

8. A device for evaluating the acceptance of new products in drug stores, characterized in that: A drugstore new product acceptance evaluation system according to any one of claims 1 to 8 is provided.

9. An electronic device, characterized in that: include: one or more processors; as well as a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors are caused to execute the method according to any one of claims 1 to 5.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the method according to any one of claims 1 to 5 is implemented.

Images