Take-out order delivery data analysis method and device, electronic equipment and storage medium

Abstract

The invention relates to the field of data request processing, and discloses a take-out order delivery data analysis method, which comprises the following steps: when it is monitored that the actual completion time of a target order is greater than a preset overtime threshold, obtaining the actual meal delivery time, the actual shop arrival time and the actual delivery time according to the order data of the target order; obtaining standard meal delivery time, standard shop arrival time and standard delivery time; calculating reasonable delay time of the deliveryman; calculating the meal delivery timeout time of the merchant, calculating the shop arrival timeout time of the deliveryman, and calculating the delivery timeout time of the deliveryman according to the actual delivery time, the standard delivery time and the reasonable delay time; and analyzing the target order according to the meal delivery timeout time of the merchant, the store arrival timeout time of the deliveryman and the delivery timeout time of the deliveryman to obtain an analysis result of generation timeout of the target order. According to the method, which link is a main delay source is analyzed, and the timeout reason analysis report is generated, so that the accuracy of analyzing the distribution data is improved.

Description

Technical Field

[0001] The present invention relates to the field of data request processing, and in particular to a method, device, electronic device and storage medium for analyzing takeaway order delivery data. Background Art

[0002] In recent years, the takeaway order delivery service has grown rapidly with the development of e-commerce and mobile Internet. Consumers can easily place orders through mobile applications and choose their favorite restaurants and dishes.

[0003] Traditional analysis of takeaway order delivery data usually relies on the statistics of the overall delivery time and lacks a detailed analysis of each specific link in the delivery process. This method is difficult to accurately point out which link causes the timeout. For example, it is impossible to clearly distinguish whether the timeout is caused by the slow meal preparation of the merchant, the late arrival of the deliveryman to pick up the meal, or external factors (such as weather conditions, road construction, etc.), reducing the accuracy of analyzing delivery timeouts.

[0004] Therefore, how to accurately identify which links in the delivery data are delayed to improve the accuracy of analyzing delivery data has become an urgent technical problem to be solved. Summary of the Invention

[0005] In view of the above, it is necessary to provide a method for analyzing takeaway order delivery data. The purpose is to decompose the entire delivery process into multiple stages (such as merchant meal preparation, deliveryman arriving at the store, deliveryman delivering), record the actual time of each stage respectively, and establish a reasonable standard time for each stage. By comparing the actual time with the standard time, determine the contribution ratio of each stage to the timeout of the target order, so as to improve the accuracy of analyzing delivery data.

[0006] The method for analyzing takeaway order delivery data provided by the present invention includes:

[0007] When it is monitored that the actual completion time of the target order is greater than the preset timeout threshold, obtain the order data of the target order, and obtain the actual meal delivery time when the merchant accepts the target order, the actual arrival time of the deliveryman at the merchant's location, and the actual delivery time when the deliveryman delivers the target order from the merchant's location to the receiving location from the order data;

[0008] Obtain the standard meal delivery time of the merchant from the preset database, obtain the standard arrival time of the deliveryman at the merchant's location, and obtain the standard delivery time when the deliveryman delivers the target order from the merchant's location to the receiving location;

[0009] Determine the actual delivery time period of the target order according to the actual delivery time, query the road condition information and weather information of the area where the target order belongs during the actual delivery time period, and calculate the reasonable delay time for the delivery person to travel from the merchant location to the receiving location of the target order according to the road condition information and the weather information;

[0010] Calculate the merchant's meal preparation overtime according to the actual meal preparation time and the standard meal preparation time, calculate the delivery person's arrival at the store overtime according to the actual arrival time at the store and the standard arrival time at the store, and calculate the delivery person's delivery overtime according to the actual delivery time, the standard delivery time, and the reasonable delay time;

[0011] Analyze the target order according to the merchant's meal preparation overtime, the delivery person's arrival at the store overtime, and the delivery person's delivery overtime, and obtain the analysis result of the target order's overtime.

[0012] Optionally, the obtaining the standard meal preparation time of the merchant from the preset database includes:

[0013] Obtain the meal preparation schedule of the merchant for each dish preset with a meal preparation time from the preset database;

[0014] Query the meal preparation schedule according to the identifier of the target order to obtain the standard meal preparation time of the target order.

[0015] Optionally, the obtaining the standard arrival time at the store for the delivery person to reach the merchant location includes:

[0016] Obtain the pick-up location when the delivery person accepts the order;

[0017] Calculate the estimated driving time from the pick-up location to the merchant location, and use the estimated driving time as the standard arrival time at the store for the delivery person.

[0018] Optionally, the obtaining the standard delivery time for the delivery person to deliver the target order from the merchant location to the receiving location includes:

[0019] Obtain historical orders with the same path as the target order from the preset database;

[0020] Calculate the average delivery time of all historical orders with the same path as the standard delivery time of the target order.

[0021] Optionally, the method further includes:

[0022] Calculate the first difference between the actual meal preparation time and the standard meal preparation time to obtain the merchant's meal preparation delay time;

[0023] When the meal delivery delay time of the merchant is a positive number, it is determined that the actual meal delivery time is slower than the standard meal delivery time. When the meal delivery delay time of the merchant is a negative number or zero, it is determined that the merchant has completed the meal delivery on time or in advance.

[0024] Optionally, the method further includes:

[0025] Calculate the second difference between the actual arrival time and the standard arrival time to obtain the delivery person's arrival overtime time;

[0026] When the delivery person's arrival overtime time is a positive number, it is determined that the actual arrival time of the delivery person is later than the standard arrival time. When the delivery person's arrival overtime time is a negative number or zero, it is determined that the delivery person has arrived at the merchant's location on time or in advance.

[0027] Optionally, the method further includes:

[0028] Add the standard delivery time and the reasonable delay time to obtain the integrated time;

[0029] Calculate the third difference between the actual delivery time and the integrated time to obtain the delivery person's delivery delay time;

[0030] When the delivery person's delivery delay time is a positive number, it is determined that the actual delivery time of the delivery person is later than the integrated time. When the delivery person's delivery delay time is a negative number or zero, it is determined that the delivery person has completed the delivery of the target order on time or in advance.

[0031] To solve the above problems, the present invention also provides an analysis device for takeaway order delivery data, and the device includes:

[0032] A monitoring module, configured to obtain the order data of the target order when it is monitored that the actual completion time of the target order is greater than a preset overtime threshold, and obtain the actual meal delivery time when the merchant accepts the target order, the actual arrival time when the delivery person arrives at the merchant's location, and the actual delivery time when the delivery person delivers the target order from the merchant's location to the receiving location from the order data;

[0033] An obtaining module, configured to obtain the standard meal delivery time of the merchant from a preset database, obtain the standard arrival time when the delivery person arrives at the merchant's location, and obtain the standard delivery time when the delivery person delivers the target order from the merchant's location to the receiving location;

[0034] A query module, configured to determine the actual delivery time period of the target order according to the actual delivery time, query the road condition information and weather information in the actual delivery time period of the area to which the target order belongs, and calculate the reasonable delay time for the delivery person to travel from the merchant's location to the receiving location of the target order according to the road condition information and the weather information;

[0035] A calculation module, configured to calculate the merchant's meal delivery overtime based on the actual meal delivery time and the standard meal delivery time, calculate the deliveryman's arrival overtime based on the actual arrival time and the standard arrival time, and calculate the deliveryman's delivery overtime based on the actual delivery time, the standard delivery time, and the reasonable delay time;

[0036] An analysis module, configured to analyze the target order based on the merchant's meal delivery overtime, the deliveryman's arrival overtime, and the deliveryman's delivery overtime, and obtain the analysis result of the target order's overtime.

[0037] To solve the above problems, the present invention also provides an electronic device, which includes:

[0038] At least one processor; and,

[0039] A memory communicatively connected to the at least one processor; wherein,

[0040] The memory stores a takeaway order delivery data analysis program executable by the at least one processor. When the takeaway order delivery data analysis program is executed by the at least one processor, the at least one processor can execute the above-mentioned takeaway order delivery data analysis method.

[0041] To solve the above problems, the present invention also provides a computer-readable storage medium, on which a takeaway order delivery data analysis program is stored. The takeaway order delivery data analysis program can be executed by one or more processors to implement the above-mentioned takeaway order delivery data analysis method.

[0042] Compared with the prior art, the present invention decomposes the delivery process into multiple specific stages. When it is monitored that the actual completion time of the target order exceeds the preset overtime threshold, the detailed time information of the target order during the entire delivery process is automatically obtained, and the actual time and the standard time of each stage from the merchant receiving the order to delivering the meal, from the deliveryman receiving the order to the merchant's location, and from the merchant's location to the receiving location of the target order are analyzed and calculated.

[0043] Calculate the difference between the actual time and the standard time of each stage, calculate the contribution ratio of the overtime of each stage to the total delay time, and clearly analyze which link is the main source of delay, and generate an overtime cause analysis report, thereby improving the accuracy of analyzing delivery data. BRIEF DESCRIPTION OF THE DRAWINGS

[0044] Figure 1 It is a flowchart of the takeaway order delivery data analysis method provided by an embodiment of the present invention;

[0045] Figure 2Schematic diagram of modules of a food delivery order distribution data analysis device provided by an embodiment of the present invention;

[0046] Figure 3 Schematic diagram of the structure of an electronic device for implementing a food delivery order distribution data analysis method provided by an embodiment of the present invention;

[0047] The implementation, functional features and advantages of the present invention will be further described with reference to the embodiments and the accompanying drawings. Detailed implementation manners

[0048] In order to make the objectives, technical solutions and advantages of the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention, but not to limit the present invention. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present invention without creative efforts shall fall within the protection scope of the present invention.

[0049] It should be noted that the descriptions involving "first", "second", etc. in the present invention are only for descriptive purposes, and cannot be understood as indicating or implying their relative importance or implicitly indicating the quantity of the indicated technical features. Thus, the features defined with "first", "second" may explicitly or implicitly include at least one of such features. In addition, the technical solutions between various embodiments may be combined with each other, but it must be based on the fact that those of ordinary skill in the art can implement them. When the combination of technical solutions is contradictory or cannot be implemented, it should be considered that such a combination of technical solutions does not exist and is not within the protection scope required by the present invention.

[0050] Refer to Figure 1 As shown, it is a flowchart of a food delivery order distribution data analysis method provided by an embodiment of the present invention. This method is executed by an electronic device.

[0051] In this embodiment, the food delivery order distribution data analysis method includes:

[0052] S1. When it is monitored that the actual completion time of a target order is greater than a preset overtime threshold, obtain the order data of the target order, and obtain the actual meal preparation time when the merchant accepts the target order, the actual arrival time when the delivery person arrives at the merchant's location, and the actual delivery time when the delivery person delivers the target order from the merchant's location to the receiving location from the order data.

[0053] In this embodiment, the background management system of the food delivery platform monitors the actual completion time of each order. For example, each time point of each order (such as the merchant confirms receiving the order, the merchant marks as ready, the delivery person clicks to pick up the meal, etc.) will be recorded by the background management system and stored in the database, thus forming a complete delivery timeline.

[0054] After detecting that the actual completion time of the target order exceeds the preset maximum allowed time (i.e., the timeout threshold), the analysis of the delivery data of the target order is automatically triggered. According to the identifier of the target order (such as the order number), the order data of the target order is obtained from the database of the background management system. The order data refers to all information related to the target order, which is stored in the database and is used to track, manage, and analyze the status and process of the order.

[0055] The actual completion time refers to the time required as recorded by the background management system of the food delivery platform from the user placing an order to the user receiving the order.

[0056] The order data includes order basic information (order number, order placement time, estimated delivery time), customer information (customer name, delivery address, contact information), merchant information (merchant name, merchant address, merchant order receiving time), product details (product list, special requirements), delivery information (delivery person ID, actual arrival time at the store, actual meal preparation completion time, actual delivery time), and status records (status at each stage of the order, status update time).

[0057] From the order data, obtain the actual meal preparation completion time when the merchant accepts the target order, the actual arrival time at the merchant's location by the delivery person, and the actual delivery time when the delivery person delivers the target order from the merchant's location to the delivery location.

[0058] The actual meal preparation completion time refers to the time period from when the merchant receives the target order and starts preparing the food until the meal preparation is completed and the delivery person is notified that they can pick up the meal. Simply put, it is the actual time taken by the merchant for meal preparation.

[0059] The actual arrival time at the store refers to the time period from when the delivery person receives the target order, departs from the current location and goes to the merchant's location, and successfully arrives at the merchant's place to prepare to pick up the meal. In other words, it is the actual time taken by the delivery person from receiving the order to arriving at the merchant's door.

[0060] The actual delivery time refers to the time period from when the delivery person picks up the meal from the merchant and delivers the meal to the customer's designated delivery location. That is, the actual delivery time from the merchant to the customer.

[0061] In step S1, by separately recording and analyzing the actual meal preparation completion time, the actual arrival time at the store, and the actual delivery time, the specific link causing the timeout of the target order can be accurately located. The traditional overall delivery time statistical method is difficult to distinguish the impacts of different stages. After decomposing the entire process into multiple specific links, the present invention can more accurately evaluate the performance of each stage and accordingly establish a more reasonable standard time model.

[0062] S2. Obtain the standard meal preparation time of the merchant from a preset database, obtain the standard arrival time of the delivery person at the merchant's location, and obtain the standard delivery time for the delivery person to deliver the target order from the merchant's location to the receiving location.

[0063] In this embodiment, in order to calculate whether each stage in the delivery process of the target order meets the expectations, a "standard time" is set for each stage. These standard times are determined based on historical data, industry experience, and best practices under specific conditions.

[0064] The standard meal preparation time for a merchant from receiving an order to preparing the meal refers to the ideal required time from starting to prepare the meal for the target order until the meal is ready to be picked up. The standard meal preparation time is obtained in the following ways:

[0065] 1. Obtain the historical orders of the merchant from a preset database, screen out the orders of the same similar type as the current target order (such as the same dish combination, the same or similar time period) from the historical orders within a preset time period (such as the most recent 3 months), and then calculate the average value of the actual meal preparation times of all similar type orders as the standard meal preparation time.

[0066] 2. The food delivery platform allows merchants to set the estimated meal preparation time for each dish according to their own operation conditions and form a meal preparation time schedule. When there is a target order, the corresponding standard meal preparation time can be obtained by querying the meal preparation time schedule according to the content of the target order.

[0067] The standard arrival time of the delivery person from receiving the order to the merchant's location refers to the ideal required time for the delivery person to depart from their current location and arrive at the merchant's place to prepare for picking up the meal after receiving the target order. The standard arrival time is obtained in the following way: Use the preset Geographic Information System (GIS) technology combined with real-time traffic information to calculate the time required for the shortest and fastest route for the delivery person from the current location to the merchant.

[0068] The standard delivery time for the delivery person from the merchant's location to the receiving location of the target order refers to the ideal required time for the delivery person to deliver the meal from the merchant to the customer. The standard delivery time is obtained in the following ways:

[0069] 1. Use a preset map service provider to calculate the distance between the merchant's location and the receiving location and the distance of the actual driving route, and obtain the standard delivery time based on the calculation results.

[0070] 2. Obtain the historical orders with the same route as the target order from a preset database, and calculate the average delivery time of all historical orders with the same route as the standard delivery time of the target order.

[0071] In one embodiment, obtaining the standard meal preparation time of the merchant from a preset database includes:

[0072] Obtain the historical orders of the merchant in a preset time period from a preset database, and obtain similar type orders to the target order from the historical orders;

[0073] Calculate the average meal preparation time of all similar type orders, and use the average meal preparation time as the standard meal preparation time of the target order.

[0074] Obtain all order records of the merchant within a preset time period (such as within 3 months) from the database of the food delivery platform, and then screen out historical orders with similar types (similar features) to the currently processed target order. Determine the standard meal preparation time of the target order by calculating the average value of the actual meal preparation times of the historical orders of similar types.

[0075] The database stores all the details of the completed orders of the merchant in the past period (such as the past 3 months or longer). Screen the historical orders with similar types (similar features) to the currently processed target order to find those orders similar to the target order to be processed. Similar type orders can be defined based on multiple dimensions, such as the types and quantities of goods included in the order, the time period of placing the order (such as the lunch peak period), and even the location of the customer, etc.

[0076] Having similar types includes but is not limited to: product combination, order size, time period, and geographical location.

[0077] Product combination: If the dishes in two orders are almost the same, they are similar. Order size: The preparation time may be different between large orders and small orders. Time period: Different time periods (such as weekday lunch time vs dinner time) may also have different impacts on the merchant. Geographical location: The demand patterns in certain regions may affect the meal preparation speed.

[0078] After determining which historical orders are similar, then calculate the actual meal preparation times of the historical orders of similar types (that is, the time from receiving the order to completing the meal preparation). By averaging these actual meal preparation times, a representative value can be obtained, and this value is used as the standard meal preparation time of the target order. The advantage of this calculation method is that it can automatically adjust the standard using historical data to adapt to the changing operating conditions of the merchant over time, thereby providing a scientific basis for setting a reasonable timeout threshold for each target order, ensuring that the timeout threshold is closer to the actual operating situation. Avoid misjudgment caused by unreasonable setting of the timeout threshold, and can more accurately judge the specific links of the delay (such as slow meal preparation by the merchant, delayed pick-up by the delivery person, or problems in the delivery link), providing a more powerful basis for determining the cause of the delivery delay.

[0079] In one embodiment, obtaining the standard meal preparation time of the merchant from a preset database includes:

[0080] Obtain the meal preparation schedule of the merchant for each dish preset with a meal preparation time from the preset database;

[0081] Query the meal preparation schedule according to the identifier of the target order to obtain the standard meal preparation time of the target order.

[0082] The database stores the meal preparation schedule separately set by the merchant for each dish. These preset meal preparation times reflect the average time estimated by the merchant for each dish from the start of preparation to completion based on its own kitchen operation process, cooking complexity, and past experience.

[0083] The meal preparation schedule includes the dish ID or name and the standard preparation time set by the merchant for each dish. To obtain the merchant's meal preparation schedule, the unique identifier of the target order (such as the order number) will be used to find all the dishes included in the target order, and the corresponding preset meal preparation time will be extracted from the meal preparation schedule. Then, according to the specific dish combination and quantity in the target order, calculate the standard meal preparation time of the entire target order.

[0084] Using the detailed meal preparation time information provided by the merchant to provide a more personalized and accurate standard meal preparation time for the target order can provide more powerful persuasion when investigating which node caused the delay.

[0085] In one embodiment, obtaining the standard arrival time of the delivery person at the merchant's location includes:

[0086] Obtain the pick-up location of the delivery person when receiving the order;

[0087] Calculate the estimated driving time from the pick-up location to the merchant's location, and use the estimated driving time as the standard arrival time of the delivery person.

[0088] When the delivery person accepts the target order, the food delivery platform will record the geographical location where the delivery person is at this time through the delivery person's order-receiving device (such as the GPS positioning function on the mobile terminal), so as to obtain the pick-up location.

[0089] After obtaining the pick-up location of the delivery person, calculate the estimated driving time between the pick-up location and the merchant's location, which is obtained by the following method: Use the preset geographic information system (GIS) technology or map service API (such as Google Maps API, Amap API, etc.) to calculate the best driving route according to the pick-up location and the merchant's location, and obtain the standard arrival time of the delivery person according to the time required for the best driving route.

[0090] In one embodiment, obtaining the standard delivery time for the delivery staff to deliver the target order from the merchant location to the receiving location includes:

[0091] Obtain historical orders with the same route as the target order from a preset database;

[0092] Calculate the average delivery time of all historical orders with the same route as the standard delivery time of the target order.

[0093] Obtain historical orders with the same route as the target order from a preset database. The same route includes the starting point and the ending point, the driving route, and the geographical area. Among them, the starting point and the ending point refer to ensuring that the merchant location (starting point) and the receiving location (ending point) of the historical order are basically the same as those of the target order. The driving route refers to considering whether the actual driving routes are the same or similar, which is achieved by comparing the shortest path or the common path between two locations. The geographical area refers to selecting orders within the same geographical area and with similar route characteristics.

[0094] After determining the historical orders with the same route as the target order, then calculate the actual delivery time of the historical orders with the same route (that is, the total time from the delivery staff arriving at the merchant to pick up the meal to delivering the meal to the customer). By averaging these actual delivery times, a representative average value is obtained, and this average value is used as the standard delivery time of the target order.

[0095] In step S2, calculating the three standard times of the standard meal preparation time, the standard arrival time at the store, and the standard delivery time is to provide a reasonable baseline for measuring and comparing each stage in the actual delivery process. If the actual time consumed in a certain stage significantly exceeds the standard time, it indicates that there may be inefficiencies or other problems, providing a more powerful basis for determining the reasons for delivery delays.

[0096] S3. Determine the actual delivery time period of the target order according to the actual delivery time, query the road condition information and weather information in the area where the target order is located during the actual delivery time period, and calculate the reasonable delay time for the delivery staff to travel from the merchant location to the receiving location of the target order according to the road condition information and the weather information.

[0097] In this embodiment, the actual delivery time period of the target order is determined according to the actual delivery time of the delivery person. For example, if the target order is being delivered between 11 - 12 am on December 1, 2024, then the time period between 11 - 12 am on December 1, 2024 is the actual delivery time period. Based on the actual delivery time period of the target order, combined with real-time road conditions information and weather information, a reasonable delay time is calculated to more accurately predict the total delivery time of the delivery person from the merchant location to the target order receiving location. Specifically:

[0098] There will be different traffic conditions and weather conditions in different time periods. According to the actual delivery time period of the target order (such as 11 - 12 am on December 1, 2024), real-time road conditions information and weather information of the area where the target order is located during the above time period (such as 11 - 12 am on December 1, 2024) are obtained from a third-party service provider or public data source, so as to restore the external environment during the delivery at that time and more accurately calculate a reasonable delay time.

[0099] It can be obtained by integrating with map service APIs (such as Google Maps, AutoNavi Maps, etc.). The map service APIs provide information such as historical / real-time traffic flow, accident reports, road construction, etc., so as to obtain road conditions information.

[0100] Weather information can be obtained from weather service APIs (such as AccuWeather, China Meteorological Administration, etc.). The weather information includes weather forecast data such as temperature, precipitation probability, wind speed, etc.

[0101] The influencing information of road conditions information and weather information includes: whether there is serious traffic congestion on the road section from the merchant location to the target order receiving location, whether there is road closure or diversion caused by emergencies, whether there is rainfall, snowfall, strong wind and other bad weather affecting the driving speed in the area where the merchant location to the target order receiving location is located, and whether there is temporary traffic control or increased pedestrian flow caused by large-scale events, holidays, etc.

[0102] According to the influencing information queried from road conditions information and weather information, calculate the potential impact of the influencing information on the delivery speed, and calculate a reasonable delay time. If there is obvious traffic congestion or an accident, it may increase the additional driving time as the delay time. For peak hours, even without special accidents, a certain amount of additional waiting time may be estimated. If there are bad weather conditions (such as rain, snow, strong wind, etc.), the vehicle driving speed usually decreases, so the estimated driving time needs to be extended accordingly.

[0103] In step S3, by introducing a reasonable delay time, the actual delivery time of each order can be predicted more accurately. Traditional delivery time estimations often rely on historical averages or fixed standard times, and these calculation methods may not fully consider the impact of dynamic factors such as real-time road conditions and weather. By calculating the reasonable delay time, the system can dynamically adjust the estimated delivery time, providing a more realistic estimate and reducing delays caused by unexpected situations.

[0104] S4. Calculate the merchant's meal preparation overtime based on the actual meal preparation time and the standard meal preparation time, calculate the delivery person's arrival at the store overtime based on the actual arrival time at the store and the standard arrival time at the store, and calculate the delivery person's delivery overtime based on the actual delivery time, the standard delivery time, and the reasonable delay time.

[0105] In this embodiment, the overtime situation at each stage is calculated by comparing the actual time that occurred with the preset standard time. Specifically, it is to calculate whether the merchant's meal preparation is overtime, whether the delivery person's arrival at the store is overtime, and whether the delivery person's delivery is overtime.

[0106] In one embodiment, the calculating the merchant's meal preparation overtime based on the actual meal preparation time and the standard meal preparation time includes:

[0107] Calculate the first difference between the actual meal preparation time and the standard meal preparation time to obtain the merchant's meal preparation delay time;

[0108] When the merchant's meal preparation delay time is positive, it is determined that the actual meal preparation time is slower than the standard meal preparation time. When the merchant's meal preparation delay time is negative or zero, it is determined that the merchant has completed the meal preparation on time or in advance.

[0109] The formula for calculating the merchant's meal preparation overtime (ΔT):

[0110] ΔT = T1 - T0

[0111] Where ΔT is the merchant's meal preparation overtime, T1 is the actual meal preparation time, and T0 is the standard meal preparation time. If ΔT > 0, it means that the merchant's actual meal preparation time exceeds the standard meal preparation time, that is, there is meal preparation overtime. If ΔT ≤ 0, it means that the merchant has completed the meal preparation task in advance.

[0112] In one embodiment, the calculating the delivery person's arrival at the store overtime based on the actual arrival time at the store and the standard arrival time at the store includes:

[0113] Calculate the second difference between the actual arrival time at the store and the standard arrival time at the store to obtain the delivery person's arrival at the store overtime;

[0114] When the delivery person's in-store overtime is a positive number, it is determined that the actual in-store time of the delivery person is later than the standard in-store time. When the delivery person's in-store overtime is a negative number or zero, it is determined that the delivery person has arrived at the merchant's location on time or in advance.

[0115] The formula for calculating the delivery person's in-store overtime (Δt):

[0116] Δt = t1 - t0

[0117] Where Δt is the delivery person's in-store overtime, t1 is the actual in-store time, and t0 is the standard in-store time. If Δt > 0, it means the actual in-store time of the delivery person is later than expected, that is, there is in-store overtime. If Δt ≤ 0, it means the delivery person has arrived in advance.

[0118] In one embodiment, the method further includes:

[0119] Adding the standard delivery time and the reasonable delay time to obtain the integrated time;

[0120] Calculating the third difference between the actual delivery time and the integrated time to obtain the delivery person's delivery delay time;

[0121] When the delivery person's delivery delay time is a positive number, it is determined that the actual delivery time of the delivery person is later than the integrated time. When the delivery person's delivery delay time is a negative number or zero, it is determined that the delivery person has completed the target delivery order on time or in advance.

[0122] The formula for calculating the delivery person's delivery overtime (ΔH):

[0123] ΔH = H1 - (H0 + H2)

[0124] Where ΔH is the delivery person's delivery overtime, H1 is the actual delivery time, H0 is the standard delivery time, and H2 is the reasonable delay time. If ΔH > 0, it means the actual delivery time of the delivery person exceeds the standard delivery time considering the reasonable delay, that is, there is delivery overtime. If ΔH ≤ 0, it means the delivery person has completed the delivery in advance.

[0125] In step S4, by calculating the actual and standard time differences in each stage, it can be determined which stages have delays or overtime. Based on the statistical analysis of these overtime times, more scientific and reasonable operation strategies can be formulated.

[0126] S5. Analyze the target order according to the merchant's meal preparation overtime, the delivery person's in-store overtime, and the delivery person's delivery overtime to obtain the analysis result of the target order's overtime.

[0127] In one embodiment, analyzing the target order based on the merchant's meal delivery overtime, the delivery person's arrival at the store overtime, and the delivery person's delivery overtime to obtain the analysis result of the target order's overtime includes:

[0128] Adding the merchant's meal delivery overtime, the delivery person's arrival at the store overtime, and the delivery person's delivery overtime to obtain the total delay time;

[0129] Calculating the contribution ratio of the merchant's meal delivery overtime, the delivery person's arrival at the store overtime, and the delivery person's delivery overtime to the total delay time respectively;

[0130] Generating the analysis result of the target order's overtime according to each contribution ratio.

[0131] Adding the overtime of each stage to obtain the total delay time (Total_Delay) in the entire target order process. Calculation formula:

[0132] Total_Delay = ΔT + Δt + ΔH

[0133] Calculating the contribution ratio of the overtime of each stage to the total delay time respectively helps to understand which stage has the greatest impact on the overall delay, thus providing a direction for optimization.

[0134] For any overtime ΔX, its contribution ratio P to the total delay time X , formula for calculating the contribution ratio:

[0135]

[0136] Generating a detailed analysis report according to the contribution ratios calculated from each overtime, and the report should include but not be limited to the following content:

[0137] 1. Overview of the total delay time: Briefly describe the total delay time generated by the order in the entire process, and the impact of this delay on the user experience and platform operation.

[0138] 2. List the specific contribution ratios of each stage (merchant's meal delivery, delivery person's arrival at the store, delivery person's delivery) to the total delay time, intuitively showing which links are the main causes of the delay, and providing a scientific basis when holding the object causing the delay accountable.

[0139] 3. Propose targeted improvement suggestions based on the contribution ratios. For example, if the merchant's meal delivery delay accounts for a large proportion, it is recommended that the merchant optimize the meal preparation process or appropriately control the order acceptance volume during peak periods. If the delivery person's arrival at the store or delivery delay accounts for a large proportion, it is recommended to strengthen the training of the delivery person, optimize the dispatching strategy, or provide more accurate route planning.

[0140] In other embodiments, different amounts of soothing coupons are automatically issued to consumers according to the timeout duration of the target order. The cost of the soothing coupons can also be allocated to each contributing party according to the respective contribution ratios in the analysis results. Through such a mechanism, not only can the inconvenience of consumers be compensated in a timely manner, but also merchants and delivery personnel can be incentivized to improve efficiency and service quality. At the same time, reasonable cost allocation helps to maintain fairness and the willingness to cooperate among all participating parties, thereby overall enhancing the operation level and user experience of the food delivery service platform.

[0141] Finally, the present invention is illustrated by examples, and no limitation is made to the application scenarios of the present invention:

[0142] User A placed an order for a fast food (target order) through a food delivery platform during the dinner peak period, selected a nearby Chinese restaurant B, and the order was assigned to delivery personnel C.

[0143] The food delivery platform detected that the total delivery time of the order exceeded the preset threshold of 30 minutes. Among them, the actual food preparation time (T1): Merchant B took 25 minutes to complete food preparation. The actual arrival time at the store (t1): Delivery personnel C took 10 minutes to arrive at merchant B. The actual delivery time (H1): Delivery personnel C took 20 minutes to deliver the meal to user A.

[0144] Obtain the standard times for each stage of the target order. Among them, the standard food preparation time (T0): Historical data shows that the average food preparation time is 15 minutes. The standard arrival time at the store (t0): The calculated standard arrival time at the store is 8 minutes. The standard delivery time (H0): The standard delivery time shown in the database is 15 minutes.

[0145] Calculate the reasonable delay time (H2). Among them, considering the traffic conditions and the impact of rain at that time, the additional delay time is 5 minutes.

[0146] Calculate the delay times for each stage. Among them, the merchant's food preparation overtime (ΔT) = 25 - 15 = 10 minutes, the delivery personnel's arrival at the store overtime (Δt) = 10 - 8 = 2 minutes, and the delivery personnel's delivery overtime (ΔH) = 20 - 15 - 5 = 0 minutes.

[0147] Generate an analysis result based on the above calculations. It can be analyzed that the food preparation process of merchant B caused a 10-minute delay, which is one of the main reasons for the timeout of this order. Delivery personnel C had a 2-minute delay during the process of arriving at the merchant. Delivery personnel C did not exceed the expected time during the delivery process. Considering the reasonable delay time, the delivery link did not actually cause additional delays.

[0148] In steps S1 - S4, the present invention decomposes the delivery process into multiple specific stages. When it is monitored that the actual completion time of the target order exceeds the preset timeout threshold, the detailed time information of the target order during the entire delivery process is automatically obtained, and the actual time and standard time of each stage from when the merchant receives the order to delivering the meal, from when the delivery person receives the order to the merchant's location, and from the merchant's location to the receiving location of the target order are analyzed and calculated.

[0149] Calculate the difference between the actual time and the standard time of each stage, calculate the contribution ratio of the overtime time of each stage to the total delay time, which can clearly indicate which link is the main source of delay, and generate an analysis report on the reasons for overtime, thereby improving the accuracy of analyzing delivery data.

[0150] As Figure 2 shown, it is a schematic diagram of the modules of the food delivery order delivery data analysis device provided by an embodiment of the present invention.

[0151] The food delivery order delivery data analysis device 100 of the present invention can be installed in an electronic device. According to the functions achieved, the food delivery order delivery data analysis device 100 can include a monitoring module 110, an acquisition module 120, a query module 130, a calculation module 140, and an analysis module 150. The modules of the present invention can also be referred to as units, which refer to a series of computer program segments that can be executed by the processor of the electronic device and can complete fixed functions, and are stored in the memory of the electronic device.

[0152] In this embodiment, the functions of each module / unit are as follows:

[0153] The monitoring module is used to obtain the order data of the target order when it is monitored that the actual completion time of the target order is greater than the preset timeout threshold, and obtain the actual meal delivery time when the merchant accepts the target order, the actual arrival time at the merchant's location of the delivery person, and the actual delivery time when the delivery person delivers the target order from the merchant's location to the receiving location from the order data;

[0154] The acquisition module is used to obtain the standard meal delivery time of the merchant from a preset database, obtain the standard arrival time at the merchant's location of the delivery person, and obtain the standard delivery time when the delivery person delivers the target order from the merchant's location to the receiving location;

[0155] The query module is used to determine the actual delivery time period of the target order according to the actual delivery time, query the road condition information and weather information of the area where the target order belongs during the actual delivery time period, and calculate the reasonable delay time for the delivery person to deliver the target order from the merchant's location to the receiving location according to the road condition information and the weather information;

[0156] A calculation module, configured to calculate the merchant's meal delivery overtime based on the actual meal delivery time and the standard meal delivery time, calculate the deliveryman's arrival overtime based on the actual arrival time and the standard arrival time, and calculate the deliveryman's delivery overtime based on the actual delivery time, the standard delivery time, and the reasonable delay time;

[0157] An analysis module, configured to analyze the target order based on the merchant's meal delivery overtime, the deliveryman's arrival overtime, and the deliveryman's delivery overtime, to obtain the analysis result of the target order's overtime.

[0158] In one embodiment, obtaining the standard meal delivery time of the merchant from a preset database includes:

[0159] Obtaining the meal delivery schedule of the merchant's preset meal delivery time for each dish from a preset database;

[0160] Querying the meal delivery schedule according to the identifier of the target order to obtain the standard meal delivery time of the target order.

[0161] In one embodiment, obtaining the standard arrival time for the deliveryman to reach the merchant's location includes:

[0162] Obtaining the pick-up location when the deliveryman receives the order;

[0163] Calculating the estimated driving time from the pick-up location to the merchant's location, and taking the estimated driving time as the standard arrival time of the deliveryman.

[0164] In one embodiment, and obtaining the standard delivery time for the deliveryman to deliver the target order from the merchant's location to the receiving location includes:

[0165] Obtaining historical orders with the same path as the target order from a preset database;

[0166] Calculating the average delivery time of all historical orders with the same path as the standard delivery time of the target order.

[0167] In one embodiment, the method further includes:

[0168] Calculating the first difference between the actual meal delivery time and the standard meal delivery time to obtain the merchant's meal delivery delay time;

[0169] When the merchant's meal delivery delay time is positive, it is determined that the actual meal delivery time is slower than the standard meal delivery time. When the merchant's meal delivery delay time is negative or zero, it is determined that the merchant has completed the meal delivery on time or in advance.

[0170] In one embodiment, the method further includes:

[0171] Calculate a second difference between the actual arrival time at the store and the standard arrival time at the store to obtain the delivery person's overtime arrival time at the store;

[0172] When the delivery person's overtime arrival time at the store is a positive number, it is determined that the delivery person's actual arrival time at the store is later than the standard arrival time. When the delivery person's overtime arrival time at the store is a negative number or zero, it is determined that the delivery person has arrived at the merchant's location on time or in advance.

[0173] In one embodiment, the method further includes:

[0174] Add the standard delivery time and the reasonable delay time to obtain an integrated time;

[0175] Calculate a third difference between the actual delivery time and the integrated time to obtain the delivery person's delivery delay time;

[0176] When the delivery person's delivery delay time is a positive number, it is determined that the delivery person's actual delivery time is later than the integrated time. When the delivery person's delivery delay time is a negative number or zero, it is determined that the delivery person has completed the delivery target order on time or in advance.

[0177] As Figure 3 shown, it is a schematic structural diagram of an electronic device for implementing the analysis method of takeaway order delivery data provided by an embodiment of the present invention.

[0178] In this embodiment, the electronic device 1 includes, but is not limited to, a memory 11, a processor 12, and a network interface 13 that can communicate with each other through a system bus. The memory 11 stores a takeaway order delivery data analysis program 10, and the takeaway order delivery data analysis program 10 can be executed by the processor 12. Figure 3 Only the electronic device 1 with components 11-13 and the takeaway order delivery data analysis program 10 is shown. Those skilled in the art can understand that Figure 3 the shown structure does not limit the electronic device 1, and it may include fewer or more components than shown, or combine certain components, or have different component arrangements.

[0179] Among them, the memory 11 includes a memory and at least one type of readable storage medium. The memory provides a cache for the operation of the electronic device 1; the readable storage medium can be a non-volatile storage medium such as flash memory, hard disk, multimedia card, card-type memory (for example, SD or DX memory, etc.), random access memory (RAM), static random access memory (SRAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), programmable read-only memory (PROM), magnetic memory, magnetic disk, optical disc, etc. In some embodiments, the readable storage medium can be an internal storage unit of the electronic device 1; in other embodiments, the non-volatile storage medium can also be an external storage device of the electronic device 1, such as a plug-in hard disk equipped on the electronic device 1, a Smart Media Card (SMC), a Secure Digital (SD) card, a Flash Card, etc. In this embodiment, the readable storage medium of the memory 11 is generally used to store the operating system and various application software installed on the electronic device 1, such as storing the code of the takeaway order delivery data analysis program 10 in an embodiment of the present invention. In addition, the memory 11 can also be used to temporarily store various types of data that have been output or will be output.

[0180] In some embodiments, the processor 12 can be a central processing unit (CPU), a controller, a microcontroller, a microprocessor, or other data processing chips. The processor 12 is generally used to control the overall operation of the electronic device 1, such as performing control and processing related to data interaction or communication with other devices. In this embodiment, the processor 12 is used to run the program code stored in the memory 11 or process data, such as running the takeaway order delivery data analysis program 10.

[0181] The network interface 13 can include a wireless network interface or a wired network interface, and this network interface 13 is used to establish a communication connection between the electronic device 1 and a terminal (not shown in the figure).

[0182] Optionally, the electronic device 1 can further include a user interface. The user interface can include a display, an input unit such as a keyboard. Optionally, the user interface can further include a standard wired interface and a wireless interface. Optionally, in some embodiments, the display can be an LED display, a liquid crystal display, a touch liquid crystal display, and an OLED (Organic Light-Emitting Diode) toucher, etc. Among them, the display can also be appropriately referred to as a display screen or a display unit, and is used to display the information processed in the electronic device 1 and to display a visual user interface.

[0183] It should be understood that the above embodiments are for illustrative purposes only, and the scope of the patent application is not limited by this structure.

[0184] The food delivery order distribution data analysis program 10 stored in the memory 11 of the electronic device 1 is a combination of multiple instructions. When running in the processor 12, it can achieve:

[0185] When it is monitored that the actual completion time of the target order is greater than the preset timeout threshold, obtain the order data of the target order, and obtain the actual meal preparation time when the merchant accepts the target order, the actual arrival time of the delivery person at the merchant's location, and the actual delivery time when the delivery person delivers the target order from the merchant's location to the receiving location from the order data;

[0186] Obtain the standard meal preparation time of the merchant from the preset database, obtain the standard arrival time of the delivery person at the merchant's location, and obtain the standard delivery time when the delivery person delivers the target order from the merchant's location to the receiving location;

[0187] Determine the actual delivery time period of the target order according to the actual delivery time, query the road condition information and weather information of the area where the target order belongs during the actual delivery time period, and calculate the reasonable delay time for the delivery person to travel from the merchant's location to the receiving location of the target order according to the road condition information and the weather information;

[0188] Calculate the merchant's meal preparation overtime according to the actual meal preparation time and the standard meal preparation time, calculate the delivery person's arrival overtime according to the actual arrival time and the standard arrival time, and calculate the delivery person's delivery overtime according to the actual delivery time, the standard delivery time and the reasonable delay time;

[0189] Analyze the target order according to the merchant's meal preparation overtime, the delivery person's arrival overtime and the delivery person's delivery overtime to obtain the analysis result of the target order's overtime.

[0190] Specifically, for the specific implementation method of the above food delivery order distribution data analysis program 10 by the processor 12, reference can be made to Figure 1 the description of the relevant steps in the corresponding embodiments, which will not be elaborated here.

[0191] Furthermore, if the modules / units integrated in the electronic device 1 are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. The computer-readable medium can be non-volatile or volatile. The computer-readable medium can include: any entity or device capable of carrying the computer program code, a recording medium, a USB flash drive, a mobile hard disk, a magnetic disk, an optical disk, a computer memory, a read-only memory (ROM, Read-Only Memory).

[0192] A food delivery order distribution data analysis program 10 is stored on the computer-readable storage medium. The food delivery order distribution data analysis program 10 can be executed by one or more processors. The specific implementation manner of the computer-readable storage medium of the present invention is basically the same as that of the various embodiments of the above food delivery order distribution data analysis method, and will not be elaborated herein.

[0193] In several embodiments provided by the present invention, it should be understood that the disclosed devices, apparatuses and methods can be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative. For example, the division of the modules is only a logical function division, and there may be other division methods in actual implementation.

[0194] The modules described as separate components may or may not be physically separated. The components shown as modules may or may not be physical units, that is, they may be located in one place, or may be distributed to multiple network units. Some or all of the modules can be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0195] In addition, in each embodiment of the present invention, the various functional modules can be integrated in a processing unit, or each unit can exist physically alone, or two or more units can be integrated in one unit. The above integrated unit can be implemented in the form of hardware, or in the form of hardware plus software functional modules.

[0196] For those skilled in the art, it is obvious that the present invention is not limited to the details of the above exemplary embodiments, and can be implemented in other specific forms without departing from the spirit or basic characteristics of the present invention.

[0197] Therefore, from any point of view, the embodiments should be regarded as exemplary and non-limiting. The scope of the present invention is defined by the appended claims rather than the above description. Therefore, it is intended to cover all changes falling within the meaning and scope of the equivalent elements of the claims in the present invention. Any reference signs attached to the claims should not be regarded as limiting the claimed rights.

[0198] In addition, it is obvious that the term "comprising" does not exclude other units or steps, and the singular form does not exclude the plural form. A plurality of units or devices stated in the system claims may also be implemented by one unit or device through software or hardware. The terms such as "second" are used to denote names and do not denote any particular order.

[0199] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and not to limit them. Although the present invention has been described in detail with reference to the preferred embodiments, those of ordinary skill in the art should understand that the technical solutions of the present invention can be modified or equivalently replaced without departing from the spirit and scope of the technical solutions of the present invention.

Claims

1. A method for analyzing takeout order delivery data, characterized in that: The method comprises: When it is monitored that the actual completion time of the target order is greater than a preset timeout threshold, the order data of the target order is obtained, and the actual meal delivery time when the merchant accepts the target order, the actual arrival time when the delivery person arrives at the merchant location, and the actual delivery time when the delivery person delivers the target order from the merchant location to the receiving location are obtained from the order data; Obtaining from a preset database the standard meal delivery time of the merchant, the standard store arrival time of the delivery person at the merchant location, and the standard delivery time of the delivery person delivering the target order from the merchant location to the receiving location; Determine the actual delivery time period of the target order according to the actual delivery time, query the traffic information and weather information of the area to which the target order belongs during the actual delivery time period, and calculate the reasonable delay time of the delivery person from the merchant location to the delivery location of the target order according to the traffic information and the weather information; The merchant's meal preparation overtime is calculated based on the actual meal preparation time and the standard meal preparation time. The delivery person's store arrival overtime is calculated based on the actual store arrival time and the standard store arrival time. The delivery person's delivery overtime is calculated based on the actual delivery time, the standard delivery time and the reasonable delay time. The target order is analyzed according to the merchant's meal delivery timeout, the deliveryman's store arrival timeout and the deliveryman's delivery timeout to obtain an analysis result of the target order's timeout.

2. The takeaway order delivery data analysis method according to claim 1, characterized in that: The step of obtaining the standard meal delivery time of the merchant from a preset database includes: Obtaining a meal delivery schedule for each dish preset by the merchant from a preset database; The meal delivery schedule is queried according to the identifier of the target order to obtain the standard meal delivery time of the target order.

3. The takeaway order delivery data analysis method according to claim 1, characterized in that: The obtaining of the standard arrival time of the delivery person at the merchant location includes: Obtain the order receiving location of the delivery person when receiving the order; The estimated driving time from the order receiving location to the merchant location is calculated, and the estimated driving time is used as the standard arrival time of the delivery person.

4. The method for analyzing takeout order delivery data according to claim 1, characterized in that: The step of obtaining the standard delivery time for the courier to deliver the target order from the merchant location to the receiving location includes: Obtain historical orders with the same path as the target order from the preset database; The average delivery time of all historical orders with the same route is calculated as the standard delivery time of the target order.

5. The takeaway order delivery data analysis method according to claim 1, characterized in that: The method further comprises: Calculate the first difference between the actual meal delivery time and the standard meal delivery time to obtain the meal delivery delay time of the merchant; When the merchant's meal delivery delay time is a positive number, it is judged that the actual meal delivery time is slower than the standard meal delivery time. When the merchant's meal delivery delay time is a negative number or zero, it is judged that the merchant has completed the meal delivery on time or ahead of schedule.

6. The takeaway order delivery data analysis method according to claim 1, characterized in that: The method further comprises: Calculate the second difference between the actual store arrival time and the standard store arrival time to obtain the delivery person's store arrival timeout time; When the deliveryman's arrival timeout is a positive number, it is judged that the deliveryman's actual arrival time is later than the standard arrival time. When the deliveryman's arrival timeout is a negative number or zero, it is judged that the deliveryman arrived at the merchant's location on time or ahead of schedule.

7. The method for analyzing takeout order delivery data according to claim 1, characterized in that: The method further comprises: Add the standard delivery time and the reasonable delay time to get the integrated time; Calculate the third difference between the actual delivery time and the integration time to obtain the delivery delay time of the delivery person; When the delivery delay time of the courier is a positive number, it is judged that the actual delivery time of the courier is later than the integration time. When the delivery delay time of the courier is a negative number or zero, it is judged that the courier has completed the delivery target order on time or ahead of schedule.

8. A takeaway order delivery data analysis device, characterized in that: The device comprises: A monitoring module is used to obtain order data of the target order when it is monitored that the actual completion time of the target order is greater than a preset timeout threshold, and obtain from the order data the actual meal delivery time when the merchant accepts the target order, the actual arrival time when the delivery person arrives at the merchant location, and the actual delivery time when the delivery person delivers the target order from the merchant location to the receiving location; An acquisition module is used to acquire the standard meal delivery time of the merchant from a preset database, acquire the standard store arrival time of the delivery person at the merchant location, and acquire the standard delivery time of the delivery person delivering the target order from the merchant location to the receiving location; A query module, used to determine the actual delivery time period of the target order according to the actual delivery time, query the traffic information and weather information of the area to which the target order belongs during the actual delivery time period, and calculate the reasonable delay time of the delivery person from the merchant location to the delivery location of the target order according to the traffic information and the weather information; A calculation module is used to calculate the merchant's meal delivery overtime based on the actual meal delivery time and the standard meal delivery time, calculate the delivery person's store arrival overtime based on the actual store arrival time and the standard store arrival time, and calculate the delivery person's delivery overtime based on the actual delivery time, the standard delivery time and the reasonable delay time; The analysis module is used to analyze the target order according to the merchant's meal delivery timeout, the deliveryman's store arrival timeout and the deliveryman's delivery timeout to obtain the analysis result of the target order timeout.

9. An electronic device, characterized in that: The electronic device comprises: at least one processor; and, a memory communicatively connected to the at least one processor; wherein, The memory stores a takeout order delivery data analysis program that can be executed by the at least one processor, and the takeout order delivery data analysis program is executed by the at least one processor so that the at least one processor can execute the takeout order delivery data analysis method as described in any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a takeout order delivery data analysis program, which can be executed by one or more processors to implement the takeout order delivery data analysis method as described in any one of claims 1 to 7.

Images