High-quality medicine retail terminal screening method and device and storage medium
By obtaining and analyzing the static and dynamic attributes of terminal institutions, calculating marketing guidance value indicators and conducting comprehensive evaluation, the problem of pharmaceutical companies being difficult for pharmaceutical companies to determine suitable for promotion of terminal institutions is solved, and terminal recommendations for precise marketing and maximizing economic benefits are achieved.
Patent Information
- Application Number
- CN202410969355.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-19
- Publication Date
- 2024-11-15
- Estimated Expiration
- Not applicable · inactive patent
AI Technical Summary
It is difficult for pharmaceutical companies to determine terminal institutions suitable for promotion, resulting in limited market expansion.
By obtaining the static and dynamic attributes of terminal institutions, analyzing the marketing guidance value indicators, comprehensively assessing the terminal institutions in combination with the scoring and evaluation rules, and recommending the most suitable terminal institutions to drug delivery companies.
It realizes the quick finding the most suitable terminal organization in the shortest time and lowest cost, achieving precise marketing and maximizing unit marketing costs and benefits.
Smart Images

Figure CN118967236A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of computer data processing technology, and in particular to a method, device and storage medium for identifying high-quality pharmaceutical retail terminals. Background Art
[0002] In the field of drug consumption, drug production and sales companies are facing challenges. How to effectively promote products to terminal institutions (referring to pharmacies and medical institutions, not intermediate wholesalers, the same below) is an important task for market expansion. There are a large number of terminal institutions across the country, but the coverage of each pharmaceutical company is limited, and each pharmaceutical company has a strong demand to expand the terminal market. Therefore, finding and locating terminal institutions suitable for promotion has become the key. Traditional marketing methods can no longer meet the needs, and professional technology and data analysis are needed to achieve precision marketing.
[0003] Currently, high-quality terminal institutions are mainly identified through analysis of data such as terminal institution behavior, purchase history and preferences through methods such as artificial intelligence, data analysis and machine learning, as well as the use of visual recognition technology and equipment such as sensors to collect information.
[0004] For example, the invention patent with publication number: CN105808743A discloses a terminal recommendation method and a terminal recommendation system, wherein the terminal recommendation method includes: generating interest scores of each type of terminal for each preset application according to the average total Internet access time and the average total Internet traffic of each type of terminal users in a preset time period; generating feature portraits corresponding to each type of terminal according to the interest scores of each type of terminal for each preset application; clustering each type of terminal according to the feature portraits corresponding to each type of terminal using a preset clustering algorithm to obtain a plurality of classification groups; and recommending other types of terminals belonging to the same classification group to each type of terminal according to the clustering results.
[0005] For example, the invention patent with publication number: CN107526811A discloses an information recommendation method, apparatus, terminal device and storage medium, including: the method obtains user information uploaded by the terminal device, the user information includes user operation data and local data of the terminal device; based on the user operation data and the local data of the terminal device, the recommended information in the recommended information set is filtered to obtain recommended content, the recommended information set consists of at least two pieces of recommended information; and the recommended content is sent to the terminal device.
[0006] However, in the process of implementing the technical solution of the invention in the embodiments of the present application, the present application found that the above technology has at least the following technical problems:
[0007] At present, there are a large number of terminal institutions across the country, but the coverage of each pharmaceutical company is limited, and each pharmaceutical company has a strong demand to expand the market. Therefore, it is difficult for pharmaceutical companies to find and locate terminal institutions suitable for promotion. Summary of the invention
[0008] The embodiments of the present application solve the problem that it is difficult for Chinese medicine companies to determine terminal organizations suitable for promotion in the prior art by providing a method, device and storage medium for identifying high-quality pharmaceutical retail terminals. Through multiple data integration operations, the target terminal organizations are found to achieve precision marketing.
[0009] The embodiment of the present application provides a method for identifying high-quality pharmaceutical retail terminals, comprising the following steps: obtaining static attributes of terminal institutions, and analyzing static analysis attributes based on the static attributes; obtaining transaction behavior data of each terminal institution, and analyzing dynamic analysis attributes from the transaction behavior data; obtaining marketing guidance value indicators based on the static analysis attributes and the dynamic analysis attributes; combining the marketing guidance value indicators, comprehensively evaluating the terminal institutions according to the scoring and evaluation rules, and obtaining a comprehensive evaluation result for each terminal institution; determining a terminal screening result based on the comprehensive evaluation result of each terminal institution, and recommending the terminal screening result to pharmaceutical companies.
[0010] Furthermore, the static attributes include: the detailed address of the terminal institution, the level of the city where it is located, the medical insurance acceptance status, the level of the medical institution, the registration scale index, the drug business license number, and the business scope; the static analysis attributes include: the level of the city where the terminal institution is located, the hospital-side store, the Chinese patent medicine business license status, the top 100 chain status, and credit data; the dynamic analysis attributes include: the market activity of the terminal institution, the market contribution index, the variety coverage index, the superior-subordinate relationship, the recent transaction time, and the data source.
[0011] Furthermore, the marketing guidance value indicator includes a market contribution index, and the analysis process of the market contribution index is: through the data capture interface, the terminal annual transaction amount and the total amount of collected samples of the terminal institution are obtained from the data source; referring to the ratio of the total amount of collected samples to the market medical consumption scale announced by the state, the weighting coefficient of the terminal annual transaction amount is obtained; the collected samples are multiplied by the weighting coefficient as the market contribution index of the terminal institution.
[0012] Furthermore, the marketing guidance value indicators include market activity, and the analysis process of the market activity is: through the data capture interface, the actual hierarchical relationship of the commercial sales flow of the terminal organization in the past M cycles is obtained from the data source, where M is a natural number; through artificial intelligence matching and recommendation, the mapping relationship between the commercial master data of the terminal organization and the standard master data of the pharmaceutical company is established in combination with the hierarchical relationship; according to the mapping relationship, the total number of transaction behaviors that have occurred in the past M cycles is statistically obtained from the transaction relationship, and if a transaction behavior occurs in each cycle, it is recorded as one transaction behavior; and the market activity is obtained based on the number of transaction behaviors.
[0013] Furthermore, the marketing guidance value indicator includes a variety coverage indicator, and the method for obtaining the variety coverage indicator is as follows: obtain the barcode scanning information of the terminal agency on the purchased drugs, and at the same time obtain the purchase order image information of the terminal agency, and obtain the drug varieties according to the comparison results of the barcode scanning information and the purchase order image information, and store the drug varieties in the data source; obtain the number of different drug varieties that have appeared in the terminal agency in the past M cycles from the data source through the data capture interface, that is, the terminal variety coverage number; and obtain the variety coverage indicator according to the terminal variety coverage number.
[0014] Furthermore, the marketing guidance value indicator also includes a registration scale indicator, and the method for obtaining the registration scale indicator is: obtaining the registered capital amount of the terminal institution and the currency type corresponding to the registered capital; judging whether the currency type corresponding to the registered capital complies with the target currency type registration; if it complies, no conversion is performed; if it does not comply, the registered capital amount of the non-target currency type is converted into the target currency type according to the target currency type exchange rate as the registered capital amount; and obtaining the registration scale indicator based on the registered capital amount of the target currency type.
[0015] Furthermore, the marketing guidance value indicator also includes standardizing the marketing guidance value indicator; the standardizing the marketing guidance value indicator specifically refers to: converting the original value of each marketing guidance value indicator into a common measurement standard to obtain the marketing guidance value indicator on the same scale.
[0016] Furthermore, the scoring and evaluation rules include: numbering the marketing guidance value indicators; obtaining the weights corresponding to the marketing guidance value indicators obtained by the Delphi method; obtaining the participation in scoring of each marketing guidance value indicator, and obtaining a comprehensive evaluation result through a comprehensive evaluation result expression; the comprehensive evaluation result expression is:
[0017]
[0018] In the formula, Sx is the comprehensive evaluation result, n is the marketing guidance value indicator number, n = 1, 2, ..., n 0 , n0 is the total number of scoring items, Vn is the nth marketing guidance value indicator, Pn is the weight value of the nth marketing guidance value indicator for the comprehensive evaluation result, Rn is the participation of the nth marketing guidance value indicator in scoring, Rn=0,1. When Rn=0, it means that the nth marketing guidance value indicator does not participate in scoring. When Rn=1, it means that the nth marketing guidance value indicator participates in scoring. e is a natural constant.
[0019] The embodiment of the present application provides a high-quality pharmaceutical retail terminal identification device, including: a static attribute acquisition module, a dynamic attribute acquisition module, an index acquisition module, a comprehensive evaluation module and a terminal recommendation module: the static attribute acquisition module is used to acquire the static attributes of the terminal organization, and analyze the static analysis attributes based on the static attributes; the dynamic attribute acquisition module is used to acquire the transaction behavior data of each terminal organization, and analyze the dynamic analysis attributes from the transaction behavior data; the index acquisition module is used to derive a marketing guidance value index based on the static analysis attributes and the dynamic analysis attributes; the comprehensive evaluation module is used to combine the marketing guidance value index, conduct a comprehensive evaluation on the terminal organization according to the scoring and evaluation rules, and obtain a comprehensive evaluation result for each terminal organization; the terminal recommendation module is used to determine the terminal screening result according to the comprehensive evaluation result of each terminal organization, and recommend the terminal screening result to the pharmaceutical company.
[0020] An embodiment of the present application provides a computer-readable storage medium for storing a program, which, when executed by a processor, implements a method for identifying high-quality pharmaceutical retail terminals.
[0021] One or more technical solutions provided in the embodiments of the present application have at least the following technical effects or advantages:
[0022] 1. By combining the static analysis attributes and dynamic analysis attributes of the terminal organizations, the marketing guidance value index is obtained. The comprehensive evaluation results of each terminal organization are obtained through the analysis of the marketing guidance value index, the terminal screening results are determined, and the terminal screening results are recommended to pharmaceutical companies, so as to quickly find the terminal organizations that are most suitable for the company's products in the shortest time and at the lowest cost, thereby achieving precision marketing and effectively solving the problem that it is difficult for Chinese medicine companies to determine terminal organizations suitable for promotion in the existing technology.
[0023] 2. By providing pharmaceutical company managers with methods such as selecting regional scope, terminal type, key indicator combination, and weight adjustment, we can adapt to the needs of different types of companies and ensure that the selected terminal organization is the one that can bring greater or maximum economic benefits in the surrounding area.
[0024] 3. When pharmaceutical companies have screened out the target terminal organizations that they should expand their business to, they have pointed out the terminal organizations that are worth expanding their business to guide the sales team members to give priority to business communications with these terminal organizations, and then spend the marketing expenses on the most effective terminals to maximize the benefits of unit marketing costs. BRIEF DESCRIPTION OF THE DRAWINGS
[0025] Figure 1 A flow chart of a method for identifying high-quality pharmaceutical retail terminals provided in an embodiment of the present application;
[0026] Figure 2 Recommend a flow chart for the target terminal organization;
[0027] Figure 3 This is a structural diagram of a high-quality pharmaceutical retail terminal identification device provided in an embodiment of the present application. DETAILED DESCRIPTION
[0028] The embodiments of the present application solve the problem that it is difficult for Chinese medicine companies to determine terminal organizations suitable for promotion in the prior art by providing a method, device and storage medium for identifying high-quality pharmaceutical retail terminals. Through multiple data integration operations, the target terminal organizations are found to achieve precision marketing.
[0029] The technical solution in the embodiment of the present application is to solve the problem that it is difficult for the above-mentioned pharmaceutical companies to determine the terminal institutions suitable for promotion. The overall idea is as follows:
[0030] By obtaining transaction data from commercial transaction platforms and partners and standardizing the transaction data, we can obtain the detailed data of standardized indicators of big data. Based on the standardized detailed data of big data, we can obtain the static indicator values and dynamic indicator values of medical institutions. We can obtain basic data from cooperative suppliers or official websites, and obtain the standard institution information of the medical distribution industry based on the list of medical retail standard institutions. We can obtain the initialization dictionary of high-quality terminal screening indicators and the definition of preferred terminal projects, and combine the static indicator values of medical institutions, the dynamic indicator values of medical institutions, and the standard institution information of the medical distribution industry to obtain the information of preferred terminal screening projects, the information of indicator projects involved in the preferred terminal screening projects, and the list of overall institutions participating in the settlement and their attribute lists. We can specify and adjust the weights of the indicator project information involved in the preferred terminal screening projects based on the experience of industry experts. Based on the indicator project information involved in the preferred terminal screening projects, the list of overall institutions participating in the settlement and their attribute lists, we can perform weighted calculation and analysis of terminal indicators and obtain the comprehensive evaluation results of terminal indicators, so as to find the target terminal institutions through multiple data integration operations and realize precision marketing.
[0031] In order to better understand the above technical solution, the above technical solution will be described in detail below in conjunction with the accompanying drawings and specific implementation methods.
[0032] like Figure 1As shown, it is a flow chart of the high-quality pharmaceutical retail terminal identification method provided in an embodiment of the present application. The method is applied to a high-quality pharmaceutical retail terminal identification device, and the method includes the following steps: obtaining the static attributes of the terminal mechanism, and analyzing the static analysis attributes based on the static attributes; obtaining the transaction behavior data of each terminal mechanism, and analyzing the dynamic analysis attributes from the transaction behavior data; obtaining the marketing guidance value index based on the static analysis attributes and the dynamic analysis attributes; combining the marketing guidance value index, comprehensively evaluating the terminal mechanism according to the scoring and evaluation rules, and obtaining the comprehensive evaluation results of each terminal mechanism; determining the terminal screening results according to the comprehensive evaluation results of each terminal mechanism, and recommending the terminal screening results to pharmaceutical companies.
[0033] In this embodiment, if Figure 2 As shown in the figure, it is a recommended flow chart for the target terminal institution. The transaction behavior data collected above cannot be used directly. First, some data of the data source should be benchmarked (mapped) to the main data of the pharmaceutical company, so as to calculate the dynamic analysis attributes of the main data of the pharmaceutical company, such as activity, market contribution index, last transaction time, supply relationship, variety coverage, etc. Among them, the benchmarking implementation method of business and customers can be achieved by combining the methods and steps of word splitting, fuzzy matching recommendation, scoring sorting, and manual review to achieve the benchmarking of external institution data. Terminal institutions include pharmaceutical retail terminals, pharmacies, etc. Static attributes refer to relatively fixed institutional attributes that are directly captured or manually collected through various channels and will not change due to transaction behavior, such as address geographic information, registered scale of pharmacies, etc. Static analysis attributes are more intuitive and guiding analysis indicators calculated based on static attribute analysis, such as whether it is a hospital-side store (a pharmacy near certain medical institutions), the distance from the city center, whether it is in a business district, whether there is a graded hospital nearby (using calculations about GPS coordinates), etc. Dynamic analysis attributes are analytical indicators obtained and calculated based on transaction behaviors, which have marketing guidance significance, such as market contribution index, market activity (frequency of transactions), etc. Pharmaceutical companies adjust the selection of terminal institutions according to the evaluation results of each terminal, and can replace selected terminal institutions with poor comprehensive evaluation results with terminal institutions with better comprehensive evaluation results.
[0034] Furthermore, static attributes include: the detailed address of the terminal institution, the level of the city where it is located, the medical insurance acceptance status, the level of the medical institution, the registration scale index, the drug business license number, and the business scope; static analysis attributes include: the city level where the terminal institution is located, the hospital-side store, the Chinese patent medicine business license status, the top 100 chain status, and credit data; dynamic analysis attributes include: the market activity of the terminal institution, the market contribution index, the variety coverage index, the superior-subordinate relationship, the recent transaction time, and the data source.
[0035] In this embodiment, the detailed address can be used as a reference address when the target promotion is actually visited. The city level refers to a predefined city level indicator with population, output value, and consumption capacity as parameters, such as special level 100, first level 90, second level 80, third level 70, fourth level 60, fifth level 50, etc., which are digitally represented city indicators; since megacities have higher consumption capacity than small and medium-sized cities, the city level can be used as an analysis indicator in cross-regional analysis; cities of different levels have different transportation conveniences and population densities, which also have different degrees of impact on marketing costs and sales convenience. Generally, megacities or first-tier cities have good transportation convenience, low distribution costs, and relatively low price sensitivity. Since whether a pharmacy can accept medical insurance card swiping has a certain impact on the operation of the pharmacy, the acceptance of medical insurance can be used as one of the investigation items for target selection. The level of medical institutions is divided into three levels, two levels, one level, and no level. A high level indicates a large scale and a strong overall drug digestion capacity, which can be used as an important indicator when analyzing the RX-prescription drug market of large medical institutions. The drug business license number is used to reflect the regulatory risk of the terminal institution, because the drug business license that can be queried on the official website of the State Food and Drug Administration is relatively standardized and has low operating risks. The business scope is used to reflect the degree of association between the terminal institution and the enterprise. Hospital-side stores refer to the list of pharmacies within a certain range (500 meters) calculated based on longitude and latitude. The business license of Chinese patent medicines is retrieved and analyzed from the business scope to determine whether the business license of Chinese patent medicines is covered. Since some pharmaceutical companies focus on Chinese patent medicines, all those that cover Chinese patent medicines should be included in the assessment indicators for market target selection. The top 100 chain situations are obtained through the list of chain companies of the top 100 chains or the list of subordinate stores of the top 100 chain companies announced by the market; if the terminal institution is a top 100 chain, it should be the key promotion target. If only the branch is not covered, it should be included in the coverage target. Credit data includes abnormal business conditions, administrative penalties, court default reports, etc. Credit abnormalities will bring uncertain cooperation risks to partners, such as untimely repayment, joint and several liability, etc. The abnormal operation situation is obtained by counting from the local market supervision bureau where the terminal institution operates whether there is any abnormal operation record within 5 years. If so, the number of abnormal operation occurrences and the time when the abnormal operation occurred are recorded. If the number of abnormal operation occurrences exceeds 20 times, only the most recent 20 times are counted. Once there is a recent abnormal operation, it may imply risks: poor management, irregular transactions, failure to submit annual reports on time, etc. If the customer is not this pharmaceutical company's customer, the attention should be reduced; if it is this pharmaceutical company's customer, attention should be paid to delivery and payment, relocation address changes, and possible cancellation in the future.Administrative penalties are obtained by counting from the data of the Food and Drug Administration whether there have been any administrative penalties within 5 years. If so, the number of administrative penalties and the last time the administrative penalty occurred are recorded. If the number of administrative penalties exceeds 20 times, only the most recent 20 times are counted. Once there is a recent administrative penalty (including selling counterfeit goods, violating regulations, deceiving consumers, tax evasion, operating without a license, operating beyond the scope of business, etc.), there may be transaction risks. If the company is a customer of this pharmaceutical company, more attention should be paid to find out the specific reasons and analyze the degree of risk. If the company is not a customer of this pharmaceutical company, development expectations should be lowered. Most of the administrative penalty information is concentrated on counterfeit drugs, substandard drugs, and illegal operations. It is an important credit indicator. Once it occurs, it will have a significant impact on the integrity of pharmacies. Informed consumers will try to stay away from such companies, thereby reducing the marketing share of such companies. A court default report is an execution of a court judgment that has not been completed by an operating enterprise within a certain period of time. It is an enterprise with "unsettled lawsuits" and the main punishment subjects come from the People's Courts at all levels. Enterprises with unsettled lawsuits will bring major risks or uncertainties to the future survival and operation of the enterprise. Market development should try to avoid such enterprises; the court default report can be obtained by reporting whether there has been a court default report within 5 years. If so, the publication time of the last court default report is recorded; if it exceeds 20 times, only the most recent 20 reports are counted; once there is a default report in the recent period, if it is a pharmaceutical company client, the level of attention should be absolutely increased to avoid joint losses of the pharmaceutical company; if it is not a client of this pharmaceutical company, it should not be included in the development target in the recent period. The superior-subordinate relationship is determined by indicating the upstream suppliers from which the pharmacy has purchased goods according to the transaction relationship obtained from the flow of the pharmaceutical company, and finding the mapping relationship with the standard organization, so as to clarify the superior-subordinate relationship; once the superior supplier of the terminal organization is included in the market promotion target, it can be promoted to its superior supplier first; or, if its superior supplier is already a customer of the pharmaceutical company, it should consider measures such as adding products; if the superior supplier is a group customer, it can consider cooperating with the group to promote together and reduce the difficulty of market promotion. The recent transaction time is obtained by obtaining the most recent transaction time (only to the month) from the records of the collected pharmacy transaction big data; if the time is close, it means that the operation is normal and should be included in the target scope. The data source is a list of pharmaceutical companies involved in a terminal organization or the main source mark, such as CHC, BAIY, XJP, SHLYS, etc. Whenever a pharmaceutical company is compared with the standard data, the pharmaceutical company mark is added; the more data sources, the higher the data credibility, the greater the possibility of actual transactions, and the more it should be included in the promotion target.
[0036] Specifically, the attributes of terminal institutions are derived from the following aspects: data provided by business partners, data published on the national government official website, the national unified social credit code public inquiry platform for organizations, and various self-supplemented institutional attributes (including on-site surveys, public data from various websites, etc.).
[0037] Among them, the method of marking the top 100 chain stores includes: downloading the "Top 100 Chain Stores" directory to the Oracle database; then grabbing the branches of the top 100 chain stores; according to the relationship between the branches, the upper attribute is updated to "Top 100-Level 1", and the lower attribute is updated to "Top 100-Level 2". Oracle database can not only realize data storage, but also realize the processing and calculation of conventional data (strings, values, dates), and can also realize data exchange with multiple data sources. Through its BDL INS / ETL and other database links, data mutual access can be realized, and through its own stored procedures and functions, data processing and calculation can be realized. Based on the integration of data storage, processing, and calculation, the processing and analysis of the attributes of drug distribution terminals are realized. Based on Oracle data resident memory technology, temporary table technology (cache) and other technical methods, sufficient IO and computing performance can be guaranteed under large data volumes.
[0038] Furthermore, the marketing guidance value indicators include the market contribution index. The analysis process of the market contribution index is as follows: through the data capture interface, the terminal annual transaction amount and the total amount of collected samples of the terminal institution are obtained from the data source; referring to the ratio of the total amount of collected samples to the market medical consumption scale announced by the state, the weighted coefficient of the terminal annual transaction amount is obtained; the collected samples are multiplied by the weighted coefficient as the market contribution index of the terminal institution.
[0039] In this embodiment, the calculation formula of the market contribution index of the terminal institution is:
[0040]
[0041] In the formula, Tm is the market contribution index, Sn is the annual transaction amount of the terminal, Px is the weighting coefficient, PG is the location of the terminal institution, and min(ΔPG) is the location of the nearest medical store to the terminal institution. Medical stores refer to medical institutions within 500 meters around the terminal institution according to longitude and latitude. Each time one is found, the name of the medical institution and the distance from the terminal institution are marked, and the location of the medical store is stored. If there is no medical institution within 500 meters, min(ΔPG) is recorded as 0.
[0042] The weighting coefficient Px is obtained as follows:
[0043]
[0044] Where Gm is the annual medical consumption scale announced by the country, Sm is the total amount of collected samples, Qu is the store area of the terminal institution, and max(ΔQu) is the largest store area of the terminal institution in the same city.
[0045] Specifically, referring to the experience of experts, due to the limitation of the scope of sample collection of transaction behavior data, for example: market activity, market contribution index, and variety coverage index will be affected, while the registration scale index is relatively stable and real, and the deviation from the actual industrial and commercial registration value is not large, so the weight is higher among the four indicators, reaching 30%; more transaction varieties do not necessarily mean a large business scale, and pharmacies that sell commonly used drugs may not have many varieties, but the transaction volume may be large, so compared with activity and contribution index, the weight of variety coverage is slightly lower, so there are the above-mentioned weight settings of 30, 25, 25, and 20. As shown in the following table:
[0046]
[0047] Among them, the indicator data type N is a numeric value, and the indicator data type E is an enumeration value.
[0048] Furthermore, the marketing guidance value indicators include market activity. The analysis process of market activity is as follows: through the data capture interface, the actual hierarchical relationship of the commercial sales flow of the terminal organization in the past M cycles is obtained from the data source, where M is a natural number. For example, the user can set one month as a cycle, and set M=12 to obtain the actual hierarchical relationship of the commercial sales flow in the past 12 months; through artificial intelligence matching and recommendation, the mapping relationship between the commercial master data of the terminal organization and the standard master data of the pharmaceutical company is established in combination with the hierarchical relationship; according to the mapping relationship, the total number of transaction behaviors that have occurred in the past M cycles is obtained from the transaction relationship. If a transaction behavior occurs in each cycle, it is recorded as one transaction behavior; and the market activity is obtained based on the number of transaction behaviors.
[0049] In this embodiment, even if multiple transactions occur within one cycle, they are recorded as one transaction.
[0050] Furthermore, the marketing guidance value indicators include variety coverage indicators. The method for obtaining the variety coverage indicators is as follows: obtain the barcode scanning information of the terminal agency on the purchased drugs, and at the same time obtain the purchase order image information of the terminal agency, and obtain the drug varieties according to the comparison results of the barcode scanning information and the purchase order image information, and store the drug varieties in the data source; obtain the number of different drug varieties that have appeared in the terminal agency in the past M cycles from the data source through the data capture interface, that is, the terminal variety coverage number; and obtain the variety coverage indicator according to the terminal variety coverage number.
[0051] In this embodiment, the indicators involved in the evaluation are divided into qualitative indicators and quantitative indicators. Qualitative indicators: Qualitative indicators such as whether medical insurance, hospital grade, can be converted into measurable scores, such as whether it is a medical insurance indicator, if it is "yes", it is considered to be 1 point, if it is "no", it is 0 points; Quantitative indicators: such as the amount of registered capital, annual transaction volume (market contribution index), market activity, number of varieties covered, etc., which can be expressed in numbers. The quantitative indicators involved in the evaluation must be assigned values through big data calculation.
[0052] Specifically, the specific process of obtaining drug varieties is as follows: the terminal institution uses a barcode scanning device to scan the barcode of the incoming drug, the scanning device decodes the barcode in the image of the purchase order, converts the barcode information into text or digital format, obtains the drug information represented by the barcode, and stores it in a database or file; the terminal institution uses a camera or scanner to take or scan the image of the purchase order, performs optical character recognition (OCR) on the purchase order image to extract text information, including drug name, specification, quantity, etc., and counts the drug varieties according to the drug name and specification. Compare the drug information extracted from the barcode scanning information and the purchase order image information to check whether they are consistent. If the information is consistent, the drug variety is stored in the data source; if it is inconsistent, the abnormal situation is recorded in a special abnormal log file or database, including abnormal drug information, abnormal type, timestamp and other information, for subsequent analysis and tracking, and at the same time, the relevant personnel are notified by email, SMS, instant messaging tools, etc., so that they can take timely action.
[0053] Furthermore, the marketing guidance value indicators also include registration scale indicators. The method for obtaining the registration scale indicators is as follows: obtain the registered capital amount of the terminal institution and the currency type corresponding to the registered capital; determine whether the currency type corresponding to the registered capital complies with the target currency type registration; if it complies, do not convert; if it does not comply, convert the registered capital amount of the non-target currency type into the target currency type according to the target currency type exchange rate as the registered capital amount; and derive the registration scale indicator based on the registered capital amount of the target currency type.
[0054] In this embodiment, the registration scale index is also affected by the size of the staff, business area, types of drug coverage, storage and transportation capabilities, etc., and can be used to reflect that a terminal organization is more valuable for cooperation than a small-scale pharmacy.
[0055] Furthermore, the marketing guidance value indicators also include standardization of the marketing guidance value indicators; standardization of the marketing guidance value indicators specifically refers to: converting the original value of each marketing guidance value indicator into a common measurement standard to obtain marketing guidance value indicators on the same scale.
[0056] In this embodiment, since different indicators may have different units and ranges (the market contribution index unit is RMB "yuan", and the market activity unit is "times"), it may be inaccurate to compare them directly. The process of converting the raw value of each metric into a common metric, usually between 0 and 100, allows all metrics to be compared on the same scale.
[0057] Normalization can be done in a variety of ways, such as min-max normalization:
[0058]
[0059] in, is the standardized value of the index of the i-th pharmacy on the j-th marketing guidance value index, is the original value of the i-th pharmacy on the j-th marketing guidance value indicator, min(Xj) and max(Xj) are the minimum and maximum values of the j-th indicator in all pharmacies, respectively.
[0060] Furthermore, the scoring and evaluation rules include: numbering the marketing guidance value indicators; obtaining the weights corresponding to the marketing guidance value indicators obtained by the Delphi method; obtaining the participation scoring of each marketing guidance value indicator, and obtaining the comprehensive evaluation result through the comprehensive evaluation result expression; the comprehensive evaluation result expression is:
[0061]
[0062] In the formula, Sx is the comprehensive evaluation result, n is the marketing guidance value indicator number, n = 1, 2, ..., n 0 , n 0 is the total number of marketing guidance value indicators, Vn is the nth marketing guidance value indicator, Pn is the weight value of the nth marketing guidance value indicator for the comprehensive evaluation result, Rn is the participation of the nth marketing guidance value indicator in scoring, Rn=0,1. When Rn=0, it means that the nth marketing guidance value indicator does not participate in scoring. When Rn=1, it means that the nth marketing guidance value indicator participates in scoring. e is a natural constant.
[0063] In this embodiment, if the original numerical value of the marketing guidance value indicator participating in the evaluation is a number, it is converted into the size of the score item according to the numerical value, and then it can be weighted with the weight to obtain the score of the item. Different numerical types have different methods for converting component values. Taking the market contribution index as an example, first obtain the maximum and minimum values participating in the calculation, the maximum value is set to 100 points, and the minimum value is set to 0 points. The values are sorted from large to small and compared with the maximum value. The proportion of 100 is converted to 100 points, and the proportion of 99% of the maximum value is converted to 99 points, and so on. If the original numerical value of the marketing guidance value indicator participating in the evaluation is an enumeration value, it is finally converted into the size of the score item according to the level ladder, and then it can be weighted with the weight to obtain the score of the item. Assume that the enumeration value has N ladders, and the corresponding score of each level ladder is 100 / N.
[0064] Specifically, in the high-quality terminal identification results, pharmaceutical companies should be informed of which high-quality terminals in the recommended calculation results are already covered by the pharmaceutical company's drugs (covered), and which high-quality terminals have not yet sold the pharmaceutical company's drugs (not covered). Therefore, the sales data of the pharmaceutical companies that need to be served (mainly including upstream business, downstream customers, and transaction years and months) should be imported into the target database, and the benchmarking of the pharmaceutical companies and institutions involved should be completed according to the processing method of the "other pharmaceutical company data interface". When screening the target terminals, which are the existing terminals of the pharmaceutical company, and which terminals were once customers of the pharmaceutical company and were lost this year or last year. The final results are as follows:
[0065]
[0066] like Figure 2 As shown, it is a structural diagram of the high-quality pharmaceutical retail terminal identification device provided in the embodiment of the present application. The high-quality pharmaceutical retail terminal identification device provided in the embodiment of the present application includes: a static attribute acquisition module, a dynamic attribute acquisition module, an index acquisition module, a comprehensive evaluation module and a terminal recommendation module: Static attribute acquisition module: used to obtain the static attributes of the terminal organization, and analyze the static analysis attributes based on the static attributes; Dynamic attribute acquisition module: used to obtain the transaction behavior data of each terminal organization, and analyze the dynamic analysis attributes from the transaction behavior data; Index acquisition module: used to derive marketing guidance value indicators based on static analysis attributes and dynamic analysis attributes; Comprehensive evaluation module: used to combine the marketing guidance value indicators, conduct a comprehensive evaluation of the terminal organization according to the scoring and evaluation rules, and obtain a comprehensive evaluation result of each terminal organization; Terminal recommendation module: used to determine the terminal screening result according to the comprehensive evaluation result of each terminal organization, and recommend the terminal screening result to the pharmaceutical company.
[0067] In this embodiment, the terminal institutions can be sorted in descending order according to the calculated comprehensive evaluation results to generate a ranking list. This list can be used to determine which pharmacies perform best in the comprehensive evaluation (the pharmacies ranked higher have the best potential).
[0068] Among them, the embodiment of the present application also provides a computer-readable storage medium for storing a program, which implements a method for identifying high-quality pharmaceutical retail terminals when the program is executed by a processor.
[0069] The technical solutions in the above-mentioned embodiments of the present application have at least the following technical effects or advantages: relative to the terminal recommendation method and terminal recommendation system disclosed in the invention patent with publication number: CN105808743A, the embodiments of the present application provide pharmaceutical company managers with solutions and methods such as selecting regional scope, selecting terminal type, selecting key indicator combinations, and adjusting weights to adapt to the needs of different types of enterprises, thereby ensuring that the selected terminal organization is the most capable of bringing greater or maximum economic benefits in the surrounding area; relative to the information recommendation method, device, terminal equipment and storage medium disclosed in the invention patent with publication number: CN107526811A, the embodiments of the present application, when screening out the target terminal organizations that pharmaceutical companies should expand, point out the terminal organizations that are worthy of business expansion, so as to guide the sales team personnel to give priority to business communication with these terminal organizations, and then spend the marketing expenses on the most effective terminals in terms of marketing promotion costs, so as to maximize the unit marketing cost benefits.
[0070] Those skilled in the art will appreciate that embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.
[0071] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.
[0072] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.
[0073] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process in the computer or other programmable device. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.
[0074] Although the preferred embodiments of the present invention have been described, those skilled in the art may make other changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the present invention.
[0075] Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include these modifications and variations.
Claims
1. A method for identifying high-quality pharmaceutical retail terminals. It is characterized in that The following steps are involved: Obtaining static properties of the terminal mechanism, and analyzing static analysis properties based on the static properties; Obtain the transaction behavior data of each terminal institution, and analyze the dynamic analysis attributes from the transaction behavior data; Derive marketing guidance value indicators based on static analysis attributes and dynamic analysis attributes; Combined with the marketing guidance value indicators, the terminal institutions are comprehensively evaluated according to the scoring and evaluation rules to obtain the comprehensive evaluation results of each terminal institution; The terminal screening results are determined based on the comprehensive evaluation results of each terminal institution, and the terminal screening results are recommended to pharmaceutical companies.
2. The method for identifying high-quality pharmaceutical retail terminals according to claim 1, It is characterized in that The static attributes include: the detailed address of the terminal institution, the level of the city where it is located, the medical insurance acceptance situation, the level of the medical institution, the registration scale index, the drug business license number, and the business scope; The static analysis attributes include: the city level of the terminal institution, hospital-adjacent stores, Chinese patent medicine business license status, top 100 chain status, and credit data; The dynamic analysis attributes include: market activity of the terminal institution, market contribution index, product coverage index, superior-subordinate relationship, recent transaction time, and data source.
3. The method for identifying high-quality pharmaceutical retail terminals according to claim 1, It is characterized in that The marketing guidance value index includes a market contribution index, and the analysis process of the market contribution index is as follows: Obtain the annual transaction amount and total sample amount of the terminal institution from the data source through the data capture interface; The weighted coefficient of the annual terminal transaction amount is obtained by referring to the ratio of the total amount of collected samples to the market pharmaceutical consumption scale announced by the state; The collected sample is multiplied by the weighting coefficient as the market contribution index of the terminal institution.
4. The method for identifying high-quality pharmaceutical retail terminals according to claim 1, It is characterized in that The marketing guidance value index includes market activity, and the analysis process of the market activity is as follows: Through the data capture interface, the actual superior-subordinate relationship of the commercial sales flow of the terminal organization in the past M cycles is obtained from the data source, where M is a natural number; Through artificial intelligence matching and recommendation, the mapping relationship between the commercial master data of the terminal organization and the standard master data of the pharmaceutical company is established in combination with the superior-subordinate relationship; According to the mapping relationship, the total number of transactions in the past M cycles is obtained from the transaction relationship. If a transaction occurs in each cycle, it is recorded as one transaction. The market activity is derived based on the number of transactions.
5. The method for identifying high-quality pharmaceutical retail terminals according to claim 1, It is characterized in that The marketing guidance value index includes a variety coverage index, and the method for obtaining the variety coverage index is: Obtain the barcode scanning information of the purchased drugs from the terminal institution, and at the same time obtain the image information of the purchase order of the terminal institution, obtain the drug variety according to the comparison result of the barcode scanning information and the purchase order image information, and store the drug variety in the data source; Through the data capture interface, the number of different drug varieties that have appeared in the terminal institution in the past M cycles is obtained from the data source, that is, the terminal variety coverage number; The variety coverage index is obtained based on the number of terminal variety coverage.
6. The method for identifying high-quality pharmaceutical retail terminals according to claim 1, It is characterized in that The marketing guidance value indicator also includes a registration scale indicator, and the method for obtaining the registration scale indicator is: Obtain the registered capital amount of the terminal institution and the currency type corresponding to the registered capital; Determine whether the currency type corresponding to the registered capital meets the target currency type registration; If the match is met, no conversion will be made. If the match is not met, the registered capital amount in the non-target currency type will be converted into the target currency type according to the target currency type exchange rate as the registered capital amount; The registration scale indicator is obtained based on the registered capital amount of the target currency type.
7. The method for identifying high-quality pharmaceutical retail terminals according to claim 1, Features: The marketing guidance value indicator also includes standardizing the marketing guidance value indicator; The standardization of the marketing guidance value indicators specifically refers to: converting the original value of each marketing guidance value indicator into a common measurement standard to obtain marketing guidance value indicators on the same scale.
8. The method for identifying high-quality pharmaceutical retail terminals according to claim 7, It is characterized in that The scoring and evaluation rules include: Numbering of marketing guidance value indicators; Obtain the weights corresponding to the marketing guidance value indicators obtained by the Delphi method; Obtain the participation score of each marketing guidance value indicator, and obtain the comprehensive evaluation result through the comprehensive evaluation result expression; The comprehensive evaluation result expression is: In the formula, Sx is the comprehensive evaluation result, n is the marketing guidance value indicator number, n = 1, 2, ..., n 0 , n 0 is the total number of scoring items, Vn is the nth marketing guidance value indicator, Pn is the weight value of the nth marketing guidance value indicator for the comprehensive evaluation result, Rn is the participation of the nth marketing guidance value indicator in scoring, Rn=0,1. When Rn=0, it means that the nth marketing guidance value indicator does not participate in scoring. When Rn=1, it means that the nth marketing guidance value indicator participates in scoring. e is a natural constant.
9. A high-quality pharmaceutical retail terminal identification device, It is characterized in that It includes static attribute acquisition module, dynamic attribute acquisition module, indicator acquisition module, comprehensive evaluation module and terminal recommendation module: The static attribute acquisition module is used to acquire the static attributes of the terminal mechanism and analyze the static analysis attributes according to the static attributes; The dynamic attribute acquisition module is used to acquire the transaction behavior data of each terminal institution, and analyze the transaction behavior data to obtain dynamic analysis attributes; The indicator acquisition module is used to obtain the marketing guidance value indicator according to the static analysis attributes and the dynamic analysis attributes; The comprehensive evaluation module is used to combine the marketing guidance value indicators and conduct a comprehensive evaluation of the terminal institutions according to the scoring and evaluation rules to obtain a comprehensive evaluation result of each terminal institution; The terminal recommendation module is used to determine the terminal screening results according to the comprehensive evaluation results of each terminal institution, and recommend the terminal screening results to pharmaceutical companies.
10. A computer-readable storage medium for storing a program, It is characterized in that When the program is executed by a processor, the method for identifying high-quality pharmaceutical retail terminals as described in any one of claims 1 to 8 is implemented.
