A marketing resource intelligent scheduling and financial accounting method and system

Abstract

The application discloses a marketing resource intelligent scheduling and financial accounting method and system, the method comprises the following steps: acquiring project demand parameters and financial constraint information; based on the project demand parameters, the marketing resources in the preset marketing resource library are preliminarily screened to obtain a candidate resource set; the adaptation weight of each marketing resource in the candidate resource set is calculated, and the maximum adaptation weight is taken as a target function; in combination with the budget constraint information, the optimal resource combination is obtained from the candidate resource set through a preset optimization algorithm; based on the project demand parameters, the project contract total price and the optimal resource combination, a project execution node graph is constructed; the completion state of each delivery node is monitored in real time, when the completion state of any delivery node is changed to completed and the trigger condition is met, the financial profit and loss is accounted, and the current dynamic profit is obtained. Through the budget-driven resource scheduling and the dynamic accounting triggered by the node, the marketing project real-time profit and loss management and control of the integration of business and finance are realized.

Description

Technical Field

[0001] This application relates to the field of marketing decision management technology, and in particular to a method for intelligent scheduling and financial accounting of marketing resources. Background Technology

[0002] With the rapid development of digital marketing and social e-commerce, brands and marketing service providers usually need to use marketing resource management platforms to screen influencers, schedule projects, and calculate costs when collaborating with KOLs.

[0003] In existing marketing resource management systems, the influencer selection module typically uses methods such as content tag matching and fan profile similarity calculation to select a list of influencers from the influencer resource library that match the project requirements in terms of content tone and audience profile. The project management module is used to record the project's execution progress and expense details, while the financial accounting module performs periodic settlements based on contractual agreements and actual expenditures after the project is completed.

[0004] However, existing marketing resource management systems operate independently of each other, with business data and financial data being fragmented. On the one hand, the influencer selection process does not incorporate project budget constraints into the selection algorithm, often resulting in selection results exceeding the budget and requiring repeated manual adjustments, leading to low selection efficiency. On the other hand, project execution progress information is maintained offline by project personnel, while financial personnel need to perform delayed accounting based on contracts and invoices after the project ends. There is a significant time lag between business progress and financial accounting, which can easily lead to project profits not being visible in real time and high financial verification costs.

[0005] Therefore, there is an urgent need for a systematic technical solution that can deeply integrate marketing resource selection, project progress control, and financial profit and loss accounting. Summary of the Invention

[0006] The purpose of this application is to provide a method for intelligent scheduling and financial accounting of marketing resources, in order to solve the technical problems of low project scheduling efficiency and asynchronous project progress and financial accounting caused by the disconnect between marketing resource selection and budget constraints and the asynchrony between project execution progress and financial data.

[0007] Firstly, this application provides a method for intelligent scheduling and financial accounting of marketing resources, employing the following technical solution: Obtain project requirement parameters and financial constraint information. The project requirement parameters include project target tags, target audience tags, content characteristic tags, and distribution channel tags. The financial constraint information includes the total project contract price and budget constraint information. Based on project requirements parameters, a preliminary screening of marketing resources in the preset marketing resource library is conducted to obtain a set of candidate resources. Calculate the fit weight of each marketing resource in the candidate resource set, and use the maximization of the fit weight as the objective function. Combined with budget constraint information, obtain the optimal resource combination from the candidate resource set through a preset optimization algorithm. Based on project requirements parameters, total project contract price, and optimal resource combination, a project execution node diagram is constructed. The project execution node diagram includes several sequentially related delivery nodes. Each delivery node is bound to node attribute information, which includes completion status, planned completion time, cost information, revenue information, and triggering conditions. The system monitors the completion status of each delivery node in real time. When the completion status of any delivery node changes to "completed" and the triggering conditions are met, the system calculates the financial profit and loss to obtain the current dynamic profit.

[0008] The above technical solution uses an optimization algorithm under budget constraints to select resource combinations, ensuring that projects prioritize resource combinations with the highest overall suitability within the budget. During project execution, business deliverables are broken down into discrete delivery nodes, and financial profit and loss accounting is automatically triggered based on the node completion status, so that financial data is updated in real time with business progress, effectively solving the problem of asynchronous project business execution progress and financial data accounting.

[0009] Optionally, the marketing resources include resource identifiers and resource attributes. The resource attributes include platform information, audience profiles, and content tags. The preliminary screening of marketing resources in a pre-set marketing resource library based on project requirement parameters to obtain a candidate resource set includes: Marketing resources that match platform information with advertising channel tags are categorized as optional marketing resources. All optional marketing resources in the preset marketing resource library are extracted to form an optional marketing resource set. Iterate through the set of available marketing resources, and for each available marketing resource, calculate the resource matching score based on the project requirement parameters, audience profile, and content tags; After the traversal is complete, a set of candidate resources is generated for the available marketing resources whose resource matching scores exceed the preset scoring threshold.

[0010] Optionally, for each optional marketing resource, a resource matching score is calculated based on project requirement parameters, audience profiles, and content tags, including: Calculate the audience matching score based on audience profiles and target audience tags; Calculate the content matching score based on content tags and content feature tags; Based on content matching score and audience matching score, resource matching score is calculated using preset weighting coefficients.

[0011] Optionally, the resource attributes also include business costs and historical performance data, and the calculation of the adaptation weight of each marketing resource in the candidate resource set includes: Based on resource identifiers, the commercial cost and historical performance data of each marketing resource are extracted from the preset marketing resource library. The historical performance data includes historical average exposure, historical average interaction, historical average conversion, historical number of collaborations, and number of collaboration anomalies. The commercial value score of each marketing resource is calculated based on commercial costs and historical average exposure, historical average interaction, and historical average conversion. Calculate the reliability score for each marketing resource based on the number of historical collaborations and the number of collaboration anomalies. Based on the project's target tags, the corresponding weight coefficients are obtained through a pre-defined weight coefficient mapping library; Based on the resource matching score, business value score, and reliability score of each marketing resource, the suitability weight of each marketing resource is calculated through weighting coefficients.

[0012] Optionally, the step of constructing a project execution node diagram based on project requirement parameters, total project contract price, and optimal resource combination includes: Based on project requirement parameters, a corresponding standard node sequence template is matched through a preset project template library. The standard node sequence template includes a list of node names, the prerequisite dependencies between each node, the planned time consumption percentage of each node, the revenue distribution ratio of each node, the cost distribution ratio of each node, and the triggering conditions of each node. Based on the preset project deployment cycle and the planned time consumption ratio of each node, calculate the planned start date and planned completion time for each node; Based on the commercial cost of marketing resources, calculate the total cost of the optimal resource combination, and combine the cost allocation ratio of each node to calculate the cost information of each node; Calculate the revenue information for each node based on the total project contract price and the revenue distribution ratio for each node; Each node is designated as a delivery node. The completion status of each delivery node is initialized to incomplete. Sequential associations are established based on the prerequisite dependencies of each node. The directed acyclic graph generated by all delivery nodes is designated as the project execution node graph.

[0013] Optionally, when the completion status of any delivery node changes to "completed" and the triggering condition is met, the financial profit and loss is calculated to obtain the current dynamic profit, including: Deliverable nodes with a completion status of "completed" are marked as "completed nodes". Based on the revenue information of the completed nodes, the realized revenue is calculated. Calculate the cumulative execution cost based on the cost information of completed nodes; Calculate the current dynamic profit based on realized revenue and cumulative execution costs.

[0014] Optionally, when the completion status of any delivery node changes to "completed" and the triggering condition is met, the method further includes: Obtain the actual completion time of the delivery node and compare it with the planned completion time of the delivery node. If the actual completion time is later than the planned completion time, calculate the delay duration. Based on the delay duration, the planned start and completion times of delivery nodes that have preceding dependencies after this delivery node will be adjusted; Update the adjusted planned start and finish times to the node attribute information of the corresponding delivery nodes in the project execution node diagram.

[0015] Optionally, in addition to real-time monitoring of the completion status of each delivery node, the method also includes: Real-time monitoring of project requirement parameters; when changes are detected in project requirement parameters, the changes are converted into disturbance factors, which include at least a change type identifier and the changed parameter value. Based on the changed parameter values ​​in the disturbance factor, replace the corresponding original parameter values ​​in the project requirement parameters, and use the changed project requirement parameters to calculate and obtain the simulated resource combination scheme and the corresponding simulated total cost. The simulated total cost is compared with the original total cost calculated based on the optimal resource combination to calculate the additional cost rate; If the additional cost rate exceeds a preset threshold, an early warning message will be generated to indicate the extent to which the change will impact project costs.

[0016] Secondly, this application provides a marketing resource intelligent scheduling and financial accounting system, comprising: Data acquisition module 101 is used to acquire project requirement parameters and financial constraint information. The project requirement parameters include project target tags, target audience tags, content characteristic tags and distribution channel tags. The financial constraint information includes the total project contract price and budget constraint information. The candidate resource acquisition module 102 is used to perform preliminary screening of marketing resources in the preset marketing resource library based on project requirement parameters, and to obtain a set of candidate resources. The resource combination determination module 103 is used to calculate the adaptation weight of each marketing resource in the candidate resource set, and to take maximizing the adaptation weight as the objective function. Combined with budget constraint information, it obtains the optimal resource combination from the candidate resource set through a preset optimization algorithm. The execution node diagram construction module 104 is used to construct a project execution node diagram based on project requirement parameters, total project contract price, and preferred resource combination. The project execution node diagram includes several sequentially related delivery nodes. Each delivery node is bound to node attribute information, which includes completion status, planned completion time, cost information, revenue information, and triggering conditions. The dynamic profit calculation module 105 is used to monitor the completion status of each delivery node in real time. When the completion status of any delivery node changes to "completed" and the triggering conditions are met, the financial profit and loss is calculated to obtain the current dynamic profit.

[0017] Thirdly, this application provides a computer-readable storage medium storing a computer program that can be loaded by a processor and executed as described above for a marketing resource intelligent scheduling and financial accounting method.

[0018] In summary, this application firstly selects resource combinations through an optimization algorithm under budget constraints, prioritizing the use of resource combinations with the highest overall suitability within the budget, thus significantly improving resource selection efficiency. Secondly, by breaking down the project execution process into discrete delivery nodes, financial profit and loss accounting is automatically triggered based on the node completion status, achieving real-time synchronization of business progress and financial data, which reduces financial verification costs and shortens the accounting cycle. Furthermore, through the perturbation factor transmission and additional cost rate calculation mechanism, the impact of demand changes on project costs is quantitatively assessed and real-time early warning is provided. Through the automatic linkage scheduling mechanism for node delays, the deviation between planned time and actual completion time is automatically transmitted and adjusted, maintaining the continuity and feasibility of the project plan throughout the entire execution cycle. Attached Figure Description

[0019] Figure 1 This is a flowchart of a marketing resource intelligent scheduling and financial accounting method provided in an embodiment of this application; Figure 2 This is a flowchart provided in this application embodiment of a process for preliminary screening of marketing resources in a preset marketing resource library based on project requirement parameters to obtain a candidate resource set; Figure 3 This is a flowchart illustrating the adaptation weights of each marketing resource in the candidate resource set provided in this application embodiment; Figure 4 This is a flowchart provided in this application embodiment for constructing a project execution node diagram based on project requirement parameters, total project contract price, and preferred resource combination; Figure 5 This is a schematic diagram of a marketing resource intelligent scheduling and financial accounting system provided in the embodiments of this application. Detailed Implementation

[0020] The following is in conjunction with the appendix Figure 1 - Appendix Figure 5 This application will be described in further detail below.

[0021] This application provides a method for intelligent scheduling and financial accounting of marketing resources. See [link to relevant documentation] Figure 1 This includes the following steps: S100. Obtain project requirement parameters and financial constraint information.

[0022] S200. Based on project requirement parameters, conduct preliminary screening of marketing resources in the preset marketing resource library to obtain a set of candidate resources.

[0023] S300. Calculate the adaptation weight of each marketing resource in the candidate resource set, and use the maximization of the adaptation weight as the objective function. Combined with budget constraint information, obtain the optimal resource combination from the candidate resource set through a preset optimization algorithm.

[0024] S400: Based on project requirement parameters, total project contract price, and optimal resource combination, construct a project execution node diagram.

[0025] S500 monitors the completion status of each delivery node in real time. When the completion status of any delivery node changes to "completed" and the triggering conditions are met, the financial profit and loss are calculated to obtain the current dynamic profit.

[0026] In this embodiment, the project requirement parameters and financial constraint information are first obtained. The project requirement parameters can be entered or selected by project personnel in the CRM system interface. Specifically, the project requirement parameters include project target tags, target audience tags, content characteristic tags, and distribution channel tags. The project target tags are preset enumeration types, such as including three values: "brand exposure," "deep seeding," and "direct conversion," which are used to indicate the core performance indicators of this marketing campaign. The target audience tags include age group, gender, city level, and interest tags. The content characteristic tags include preset styles such as professional evaluation, drama and humor, emotional resonance, visual aesthetics, knowledge popularization, and lifestyle. The distribution channel tags include the project application platform or channel, such as preset platforms such as Douyin, Xiaohongshu, Weibo, Bilibili, and Kuaishou.

[0027] Financial constraint information includes the total project contract price and budget constraint information. The total project contract price is the total amount charged by the marketing service provider to the client (brand). The budget constraint information is the maximum cost limit that can be used to pay for marketing resources.

[0028] Then, based on the project requirements parameters, the marketing resources in the preset marketing resource library are initially screened to obtain a set of candidate resources. The preset marketing resource library is used to manage the marketing resource information in the library. The marketing resources here are the KOLs that cooperate. In the marketing and advertising industry, KOLs refer to individuals who have high influence and voice in a specific field or community, such as influencers / bloggers / live streamers, etc.

[0029] Marketing resources include resource identifiers and resource attributes. Resource identifiers are equivalent to resource names or resource IDs. Resource attributes include platform information, audience profiles, and content tags. Platform information indicates the social media platforms on which the resource is active. Audience profiles include the age distribution, gender ratio, city tier distribution, and interest tag weights of the fans. Content tags include the content areas and style tags that the resource excels in.

[0030] In addition, resource attributes also include business costs and historical performance data. Business costs are the current cooperation price of the resource; historical performance data include historical average exposure, historical average interaction, historical average conversion, historical number of cooperations, and number of cooperation exceptions (delivery delays or financial disputes).

[0031] Specifically, see Figure 2 Based on project requirement parameters, a preliminary screening of marketing resources in the pre-set marketing resource library is conducted to obtain a candidate resource set, including the following steps: S210. Marketing resources that match platform information with advertising channel tags are recorded as optional marketing resources. All optional marketing resources in the preset marketing resource library are extracted to form an optional marketing resource set.

[0032] S220. Traverse the set of available marketing resources. For each available marketing resource, calculate the resource matching score based on the project requirement parameters, audience profile, and content tags.

[0033] S230. After the traversal is completed, a candidate resource set is generated for the available marketing resources whose resource matching score exceeds the preset score threshold.

[0034] First, marketing resources are initially screened based on platform information. Marketing resources that match the platform information with the advertising channel tags are recorded as optional marketing resources. For example, if the active platform of a marketing resource contains the advertising channel tag, it means that the two match. Then, all optional marketing resources in the preset marketing resource library are extracted to form an optional marketing resource set.

[0035] Next, the set of available marketing resources is traversed, and for each available marketing resource, a resource matching score is calculated based on the project requirement parameters, audience profiles, and content tags.

[0036] Specifically, for each available marketing resource, a resource matching score is calculated based on project requirement parameters, audience profiles, and content tags, including the following steps: S221. Calculate the audience matching score based on the audience profile and target audience tags.

[0037] S222. Calculate the content matching score based on content tags and content feature tags.

[0038] S223. Based on the content matching score and the audience matching score, calculate the resource matching score using preset weight coefficients.

[0039] Resource matching score is calculated from two dimensions: audience matching and content matching. First, based on audience profiles and target audience tags, the audience matching score is calculated. This involves converting the age distribution, gender ratio, city tier distribution, and interest tag weights of the audience profile into a numerical vector R, and converting the corresponding information from the target audience tags into a numerical vector T. The audience matching score is then calculated using the cosine similarity between the vectors. ,Right now .

[0040] Then, based on content tags and content feature tags, a content matching score can be calculated. Unlike audience matching, the objects of content matching (content tags and content feature tags) are mostly discrete sets of data. Therefore, the Jaccard similarity coefficient can be used for calculation. That is, the degree of overlap of tag types is measured by calculating the ratio of the intersection to the union of two tag sets. Let the set formed by content tags be denoted as... The set formed by content feature tags is Then the content matching score It can be represented as:

[0041] Finally, based on the content matching score and the audience matching score, and by using preset weighting coefficients, the resource matching score can be calculated, denoted as [missing information]. , can be represented as: ,in, , These are the weighting coefficients. ,For example, =0.6, =0.4, which can be flexibly set according to actual application needs.

[0042] After the traversal is complete, a set of candidate resources is generated for the available marketing resources whose resource matching score exceeds the preset scoring threshold. The preset scoring threshold is a pre-set numerical constant used to determine whether the matching degree between the marketing resources and the project requirements meets the minimum standard for participating in the current project. Its value range can be set from 0.5 to 0.8, and can be flexibly set according to the number of resources in the marketing resource library.

[0043] After determining the candidate resource set, it is necessary to further determine the final selected marketing resources. In addition to considering the matching degree of resources, budget constraints will also be used as a constraint to select the resource combination with the highest overall suitability within the budget.

[0044] Therefore, in this embodiment of the application, after obtaining the candidate resource set, the adaptation weight of each marketing resource in the candidate resource set is calculated, and the maximum adaptation weight is used as the objective function. Combined with budget constraint information, the preferred resource combination is obtained from the candidate resource set through a preset optimization algorithm.

[0045] First, calculate the suitability weight of each marketing resource in the candidate resource set. For details, see [link to relevant documentation]. Figure 3 It includes the following steps: S310. Based on resource identifiers, extract the business cost and historical performance data of each marketing resource from the preset marketing resource library.

[0046] S320: Calculate the commercial value score of each marketing resource based on commercial costs and historical average exposure, historical average interaction, and historical average conversion.

[0047] S330. Calculate the reliability score of each marketing resource based on the number of historical collaborations and the number of collaboration anomalies.

[0048] S340. Based on the project target tags, obtain the corresponding weight coefficients through a preset weight coefficient mapping library.

[0049] S350: Based on the resource matching score, business value score, and reliability score of each marketing resource, the adaptation weight of each marketing resource is calculated through weighting coefficients.

[0050] First, based on resource identifiers, the commercial cost and historical performance data of each marketing resource are extracted from the pre-set marketing resource library. The historical performance data includes historical average exposure, historical average interaction, historical average conversion, historical number of collaborations, and number of collaboration anomalies.

[0051] Then, based on business costs and historical average impressions, historical average interactions, and historical average conversions, the business value score of each marketing resource can be calculated, and the candidate resource set is recorded as follows: The business cost of each marketing resource is Historical average exposure is Historical average interaction volume Historical average conversion rate Commercial value score It can be represented as:

[0052] in, The cost per thousand exposures can be expressed as: ; The cost of a single interaction can be expressed as: ; The output converted from unit cost can be expressed as: ; 、 and These are the preset industry benchmark values ​​corresponding to each performance indicator; , and These are the weighting coefficients corresponding to each performance indicator. Business Value Score This can be understood as the result of weighted fusion of three intermediate performance indicators after normalizing them to industry benchmarks and then applying preset weighting coefficients.

[0053] Next, based on the number of historical collaborations and the number of collaboration anomalies, the reliability score of each marketing resource is calculated, and the candidate resource set is recorded as follows: The number of historical collaborations for each marketing resource is The number of cooperation anomalies was The reliability score can then be expressed as: .

[0054] Obtain Business Value Score and reliability score Then, combined with the previously obtained resource matching score This allows for the calculation of the appropriate weights for each marketing resource. However, it is important to consider that different project objectives have different degrees of dependence on each scoring indicator. For example, if the project objective is labeled "brand exposure," it will depend more on resource matching, while if it is labeled "direct conversion," it will depend more on commercial value.

[0055] Therefore, based on the project target tags, the corresponding weight coefficients will be obtained through a preset weight coefficient mapping library. This preset weight coefficient mapping library stores the corresponding weight coefficients for different project target tags, as shown in Table 1.

[0056] Table 1

[0057] After obtaining the weight coefficients corresponding to each scoring indicator, the suitability weight of each marketing resource can be calculated based on its resource matching score, business value score, and reliability score, using the weight coefficients. This suitability weight is denoted as... ,but It can be represented as:

[0058] After determining the suitability weights of each marketing resource, maximizing these weights can be used as the objective function. Combined with budget constraints, a pre-defined optimization algorithm is employed to obtain the optimal resource combination from the candidate resource set. This pre-defined optimization algorithm uses a multi-dimensional knapsack model, where the objective function can be defined as: , For the first The matching weight of each marketing resource For the first Decision variables for marketing resources ,when =1 indicates that the resource has been selected for the final combination scheme. =0 indicates that the resource was not selected; let the budget constraint information be B, then the constraint condition can be expressed as: .

[0059] Then, by using the branch and bound method or dynamic programming, the optimal resource combination can be obtained, denoted as the preferred resource combination.

[0060] After obtaining the optimal resource combination, a project execution node diagram will be constructed based on the project requirement parameters, the total project contract price, and the optimal resource combination. The project execution node diagram includes several sequentially related delivery nodes. Each delivery node is bound to node attribute information, which includes completion status, planned completion time, cost information, revenue information, and triggering conditions.

[0061] Specifically, see Figure 4 Based on project requirements parameters, total project contract price, and optimal resource combination, a project execution node diagram is constructed, including the following steps: S410. Based on project requirement parameters, match the corresponding standard node sequence template through the preset project template library.

[0062] S420. Based on the preset project deployment cycle and the planned time consumption ratio of each node, calculate the planned start date and planned completion time for each node.

[0063] S430. Based on the commercial cost of marketing resources, calculate the total cost of the optimal resource combination, and calculate the cost information of each node by combining the cost allocation ratio of each node.

[0064] S440. Calculate the revenue information for each node based on the total project contract price and the revenue distribution ratio of each node.

[0065] S450. Denote each node as a delivery node, initialize the completion status of each delivery node to incomplete, establish sequential associations based on the prerequisite dependencies of each node, and denote the directed acyclic graph generated by all delivery nodes as the project execution node graph.

[0066] First, based on the project requirements parameters, the system will match the corresponding standard node sequence template through a preset project template library. The standard node sequence template includes a list of node names, the prerequisite dependencies between each node, the planned time consumption percentage of each node, the revenue distribution ratio of each node, the cost distribution ratio of each node, and the triggering conditions of each node.

[0067] The preset project template library stores several node sequence templates. Each template uses the project target tag and the distribution channel tag as a joint index. For example, the node sequence corresponding to the "Douyin - Deep Seeding" template is: Project approval → Script creation confirmation → Content shooting and production → Content release → Data achievement confirmation → Case closure and settlement.

[0068] Next, based on the preset project deployment cycle and the planned time percentage of each node, the planned start date and planned completion time of each node are calculated. The preset project deployment cycle includes the project start time and end time. Based on the project start time and end time, and combined with the prerequisite dependencies between each node, the planned start date and planned completion time of each node can be determined in sequence.

[0069] Based on the commercial cost of marketing resources, the total cost of the optimal resource combination can be calculated. Then, by combining the cost allocation ratio of each node, the cost information of each node can be calculated.

[0070] Similarly, the revenue information for each node can be calculated based on the total contract price of the project and the revenue distribution ratio of each node.

[0071] Finally, each node is designated as a delivery node, and the completion status of each delivery node is initialized to "not started". Sequential associations are established based on the prerequisite dependencies of each node. In this way, the delivery nodes form a directed acyclic graph, which is the project execution node graph. Each delivery node includes a node name, planned start date, planned completion date, a list of prerequisite nodes, completion status (not started / in progress / completed), cost information, benefit information, and triggering conditions.

[0072] Once the project is launched, the completion status of each delivery node can be monitored in real time. When the completion status of any delivery node changes to "completed" and the triggering conditions are met, the financial profit and loss can be calculated to obtain the current dynamic profit.

[0073] For example, the system background running status monitoring service continuously obtains the completion status change logs of each delivery node through polling or message queue. When the completion status of any delivery node is detected to have changed to "completed", the system generates a financial accounting event and pushes the associated node name and change timestamp to the financial accounting module to calculate financial profit and loss and obtain the current dynamic profit.

[0074] The triggering conditions here include two types: manual confirmation and data compliance. The two types are logically related by "OR", meaning that if the triggering condition of either type is met, it is considered that the triggering condition of that node has been met. Among them, the manual confirmation triggering condition is, for example, when a project staff member clicks the confirm delivery button in the system interface, the system captures the click event and records the operator and the operation time. The data compliance triggering condition is, for example, when the system periodically scrapes publicly available data from a third-party platform through an API interface, it automatically confirms when the scraped data reaches the preset numerical threshold of that node.

[0075] Specifically, when the completion status of any delivery node changes to "completed" and the triggering conditions are met, the financial profit and loss is calculated to obtain the current dynamic profit, including the following steps: S510. Record the delivery nodes with the completion status as completed as completed nodes, and calculate the realized revenue based on the revenue information of the completed nodes.

[0076] S520. Calculate the cumulative execution cost based on the cost information of completed nodes.

[0077] S530. Calculate the current dynamic profit based on realized revenue and cumulative execution costs.

[0078] First, the delivery nodes with a completed status are marked as completed nodes. The revenue information, i.e. the revenue amount, of all completed nodes is accumulated to obtain the realized revenue.

[0079] Then, based on the cost information of the completed nodes, the cumulative execution cost can be calculated. Based on the realized revenue and the cumulative execution cost, the current dynamic profit can be calculated, that is, dynamic profit = realized revenue - cumulative execution cost.

[0080] Dynamic profit is recalculated as the completion status of delivery nodes changes to "completed". In this way, the unstructured project execution progress (node ​​completion status) is transformed into structured financial data (revenue collection, cost transfer, profit update) in real time, realizing data integration between the business system and the financial system.

[0081] In addition, considering that node delays will inevitably affect the financial confirmation progress of subsequent nodes, the planned start and completion times of subsequent delivery nodes can be updated in real time based on the actual completion time of completed nodes. If a delay occurs, an early warning can also be issued, providing advance information on the time dimension for financial accounting delays and helping financial personnel to anticipate changes in the settlement cycle in advance.

[0082] Therefore, in this embodiment of the application, when the completion status of any delivery node changes to "completed" and the triggering condition is met, the following steps are also included: S610. Obtain the actual completion time of the delivery node and compare the actual completion time with the planned completion time of the delivery node. If the actual completion time is later than the planned completion time, calculate the delay duration.

[0083] S620. Based on the delay duration, adjust the planned start and planned completion times of delivery nodes that have prerequisite dependencies after the current delivery node.

[0084] S630. Update the adjusted planned start time and planned completion time to the node attribute information of the corresponding delivery node in the project execution node diagram.

[0085] When the completion status of any delivery node changes to "completed" and the triggering conditions are met, the actual completion time of the delivery node will be obtained and compared with the planned completion time of the delivery node. If the actual completion time is later than the planned completion time, it indicates that a time delay has occurred, and the delay duration can be calculated based on the actual completion time and the planned completion time.

[0086] After obtaining the delay duration, corresponding early warning information can be generated based on the node name, planned completion time, actual completion time, and delay duration of the delivery node. This facilitates the analysis of the reasons for the delay by relevant staff and helps finance personnel to predict the direction and magnitude of changes in the project settlement cycle in advance.

[0087] At the same time, the planned start and completion times of delivery nodes that have prerequisite dependencies after the current delivery node will be adjusted according to the delay duration, that is, postponed. And the node attribute information of the delivery nodes associated with the project execution node diagram will be updated according to the adjusted planned start and completion times.

[0088] Furthermore, considering that customer needs change extremely frequently and are difficult to predict in actual marketing project execution, and that each change may have a chain reaction impact on project costs, it is also necessary to conduct an impact assessment on project costs for customers’ immediate changing needs in order to respond to risks and make adjustments in a timely manner.

[0089] Therefore, in this embodiment of the application, while monitoring the completion status of each delivery node in real time, the following steps are also included: S710: Monitor project requirement parameters in real time. When changes in project requirement parameters are detected, convert the changes into disturbance factors.

[0090] S720. Based on the changed parameter values ​​in the disturbance factor, replace the corresponding original parameter values ​​in the project requirement parameters, and use the changed project requirement parameters to calculate and obtain the simulated resource combination scheme and the corresponding simulated total cost.

[0091] S730. Compare the simulated total cost with the original total cost calculated based on the optimal resource combination, and calculate the additional cost rate.

[0092] S740. If the additional cost rate exceeds the preset threshold, an early warning message will be generated to indicate the extent to which this change will impact project costs.

[0093] First, when a change in project requirement parameters is detected, the changed content will be transformed into a disturbance factor. Here, the disturbance factor refers to the structured numerical expression of the changed content, so as to transform the unstructured description of change requirements (such as "the client expressed that he / she wants to add Xiaohongshu channel") into a standardized data object that the system can identify, calculate and transmit. The disturbance factor includes at least a change type identifier and a parameter value after the change. The change type identifier is used to indicate the type of parameter that has changed, including changes in project objectives, target audience, content tone, or distribution channels.

[0094] Then, based on the changed parameter values ​​in the disturbance factor, the corresponding original parameter values ​​in the project requirement parameters are replaced, and the simulated resource combination scheme and the corresponding simulated total cost are calculated and obtained in the above manner using the changed project requirement parameters; the simulated resource combination scheme is the optimal resource combination calculated and obtained in the above manner based on the changed project requirement parameters, and the simulated total cost is the sum of the commercial costs of each marketing resource in the simulated resource combination scheme.

[0095] The simulated total cost calculated using the simulated resource combination scheme is compared with the original total cost calculated based on the current preferred resource combination. The additional cost rate is then calculated. The additional cost rate refers to the proportion of the additional cost resulting from adjustments to the resource combination scheme due to changes in project requirements, relative to the original total cost. Let the simulated total cost calculated using the simulated resource combination scheme be denoted as... The original total cost calculated using the current optimal resource combination is: Then the additional cost rate It can be represented as: .

[0096] If the additional cost rate exceeds a preset threshold, such as 10%, a first alert message will be generated to indicate the extent to which the change will impact project costs. This will serve as a warning signal so that relevant staff can take timely action, such as assessing the impact of the change on project profits and timelines, determining whether to proceed with the change, and freezing the project approval process to prevent the change from being implemented blindly.

[0097] This application also provides a marketing resource intelligent scheduling and financial accounting system, see [link to relevant documentation]. Figure 5 The system includes: a data acquisition module 101, a candidate resource acquisition module 102, a resource combination determination module 103, an execution node graph construction module 104, and a dynamic profit calculation module 105.

[0098] The data acquisition module 101 is used to acquire project requirement parameters and financial constraint information.

[0099] The candidate resource acquisition module 102 is used to perform preliminary screening of marketing resources in the preset marketing resource library based on project requirement parameters, and to obtain a set of candidate resources.

[0100] The resource combination determination module 103 is used to calculate the adaptation weight of each marketing resource in the candidate resource set, and to take maximizing the adaptation weight as the objective function. Combined with budget constraint information, it obtains the optimal resource combination from the candidate resource set through a preset optimization algorithm.

[0101] The execution node diagram construction module 104 is used to construct the project execution node diagram based on project requirement parameters, total project contract price, and optimal resource combination.

[0102] The dynamic profit calculation module 105 is used to monitor the completion status of each delivery node in real time. When the completion status of any delivery node changes to "completed" and the triggering conditions are met, the financial profit and loss is calculated to obtain the current dynamic profit.

[0103] In this embodiment of the application, the data acquisition module 101 is specifically used to acquire project requirement parameters and financial constraint information. The project requirement parameters include project target tags, target audience tags, content characteristic tags, and distribution channel tags. The financial constraint information includes the total project contract price and budget constraint information.

[0104] The candidate resource acquisition module 102 is specifically used to perform preliminary screening of marketing resources in the preset marketing resource library based on the project requirement parameters obtained by the data acquisition module 101, and to obtain a set of candidate resources.

[0105] The resource combination determination module 103 is specifically used to calculate the adaptation weight of each marketing resource in the candidate resource set obtained by the candidate resource acquisition module 102, and to take maximizing the adaptation weight as the objective function. Combined with budget constraint information, it uses a preset optimization algorithm to obtain the optimal resource combination from the candidate resource set.

[0106] The execution node diagram construction module 104 is specifically used to construct a project execution node diagram based on project requirement parameters, total project contract price, and optimal resource combination. The project execution node diagram includes several sequentially related delivery nodes. Each delivery node is bound to node attribute information, which includes completion status, planned completion time, cost information, revenue information, and triggering conditions.

[0107] The dynamic profit calculation module 105 is specifically used to monitor the completion status of each delivery node in real time. When the completion status of any delivery node changes to "completed" and the triggering conditions are met, the financial profit and loss is calculated to obtain the current dynamic profit.

[0108] This application also provides a computer-readable storage medium storing a computer program that can be loaded by a processor and executed as described above for a marketing resource intelligent scheduling and financial accounting method.

[0109] The embodiments described in this application are preferred embodiments of this application and are not intended to limit the scope of protection of this application. Therefore, all equivalent changes made in accordance with the principles of this application should be included within the scope of protection of this application.

Claims

1. A method for intelligent scheduling and financial accounting of marketing resources, characterized in that, include: Obtain project requirement parameters and financial constraint information. The project requirement parameters include project target tags, target audience tags, content characteristic tags, and distribution channel tags. The financial constraint information includes the total project contract price and budget constraint information. Based on project requirements parameters, a preliminary screening of marketing resources in the preset marketing resource library is conducted to obtain a set of candidate resources. Calculate the fit weight of each marketing resource in the candidate resource set, and use the maximization of the fit weight as the objective function. Combined with budget constraint information, obtain the optimal resource combination from the candidate resource set through a preset optimization algorithm. Based on project requirements parameters, total project contract price, and optimal resource combination, a project execution node diagram is constructed. The project execution node diagram includes several sequentially related delivery nodes. Each delivery node is bound to node attribute information, which includes completion status, planned completion time, cost information, revenue information, and triggering conditions. The system monitors the completion status of each delivery node in real time. When the completion status of any delivery node changes to "completed" and the triggering conditions are met, the system calculates the financial profit and loss to obtain the current dynamic profit.

2. The intelligent scheduling and financial accounting method for marketing resources according to claim 1, characterized in that, The marketing resources include resource identifiers and resource attributes. The resource attributes include platform information, audience profiles, and content tags. Based on project requirement parameters, a preliminary screening of marketing resources in a pre-set marketing resource library is performed to obtain a candidate resource set, including: Marketing resources that match platform information with advertising channel tags are categorized as optional marketing resources. All optional marketing resources in the preset marketing resource library are extracted to form an optional marketing resource set. Iterate through the set of available marketing resources, and for each available marketing resource, calculate the resource matching score based on the project requirement parameters, audience profile, and content tags; After the traversal is complete, a set of candidate resources is generated for the available marketing resources whose resource matching scores exceed the preset scoring threshold.

3. The intelligent scheduling and financial accounting method for marketing resources according to claim 2, characterized in that, For each available marketing resource, a resource matching score is calculated based on project requirement parameters, audience profiles, and content tags, including: Calculate the audience matching score based on audience profiles and target audience tags; Calculate the content matching score based on content tags and content feature tags; Based on content matching score and audience matching score, resource matching score is calculated using preset weighting coefficients.

4. The intelligent scheduling and financial accounting method for marketing resources according to claim 2, characterized in that, The resource attributes also include business costs and historical performance data. The calculation of the adaptation weight of each marketing resource in the candidate resource set includes: Based on resource identifiers, the commercial cost and historical performance data of each marketing resource are extracted from the preset marketing resource library. The historical performance data includes historical average exposure, historical average interaction, historical average conversion, historical number of collaborations, and number of collaboration anomalies. The commercial value score of each marketing resource is calculated based on commercial costs and historical average exposure, historical average interaction, and historical average conversion. Calculate the reliability score for each marketing resource based on the number of historical collaborations and the number of collaboration anomalies. Based on the project's target tags, the corresponding weight coefficients are obtained through a pre-defined weight coefficient mapping library; Based on the resource matching score, business value score, and reliability score of each marketing resource, the suitability weight of each marketing resource is calculated through weighting coefficients.

5. The intelligent scheduling and financial accounting method for marketing resources according to claim 1, characterized in that, The process of constructing a project execution node diagram based on project requirement parameters, total project contract price, and optimal resource combination includes: Based on project requirement parameters, a standard node sequence template is matched with a preset project template library. The standard node sequence template includes a list of node names, the prerequisite dependencies between each node, the planned time consumption percentage of each node, the revenue distribution ratio of each node, the cost distribution ratio of each node, and the triggering conditions of each node. Based on the preset project deployment cycle and the planned time consumption ratio of each node, calculate the planned start date and planned completion time for each node; Based on the commercial cost of marketing resources, calculate the total cost of the optimal resource combination, and combine the cost allocation ratio of each node to calculate the cost information of each node; Calculate the revenue information for each node based on the total project contract price and the revenue distribution ratio for each node; Each node is designated as a delivery node. The completion status of each delivery node is initialized to incomplete. Sequential associations are established based on the prerequisite dependencies of each node. The directed acyclic graph generated by all delivery nodes is designated as the project execution node graph.

6. The intelligent scheduling and financial accounting method for marketing resources according to claim 1, characterized in that, When the completion status of any delivery node changes to "completed" and the triggering condition is met, the financial profit and loss is calculated to obtain the current dynamic profit, including: Deliverable nodes with a completion status of "completed" are marked as "completed nodes". Based on the revenue information of the completed nodes, the realized revenue is calculated. Calculate the cumulative execution cost based on the cost information of completed nodes; Calculate the current dynamic profit based on realized revenue and cumulative execution costs.

7. The intelligent scheduling and financial accounting method for marketing resources according to claim 1, characterized in that, The step of changing the completion status of any delivery node to "completed" and meeting the triggering conditions further includes: Obtain the actual completion time of the delivery node and compare it with the planned completion time of the delivery node. If the actual completion time is later than the planned completion time, calculate the delay duration. Based on the delay duration, the planned start and completion times of delivery nodes that have preceding dependencies after this delivery node will be adjusted; Update the adjusted planned start and finish times to the node attribute information of the corresponding delivery nodes in the project execution node diagram.

8. The intelligent scheduling and financial accounting method for marketing resources according to claim 1, characterized in that, The real-time monitoring of the completion status of each delivery node also includes: Real-time monitoring of project requirement parameters; when changes are detected in project requirement parameters, the changes are converted into disturbance factors, which include at least a change type identifier and the changed parameter value. Based on the changed parameter values ​​in the disturbance factor, replace the corresponding original parameter values ​​in the project requirement parameters, and use the changed project requirement parameters to calculate and obtain the simulated resource combination scheme and the corresponding simulated total cost. The simulated total cost is compared with the original total cost calculated based on the optimal resource combination to calculate the additional cost rate; If the additional cost rate exceeds a preset threshold, an early warning message will be generated to indicate the extent to which the change will impact project costs.

9. A marketing resource intelligent scheduling and financial accounting system, characterized in that, include: The data acquisition module (101) is used to acquire project requirement parameters and financial constraint information. The project requirement parameters include project target tags, target audience tags, content characteristic tags and distribution channel tags. The financial constraint information includes the total project contract price and budget constraint information. The candidate resource acquisition module (102) is used to perform preliminary screening of marketing resources in the preset marketing resource library based on project requirement parameters and obtain a set of candidate resources; The resource combination determination module (103) is used to calculate the adaptation weight of each marketing resource in the candidate resource set, and to take the maximization of the adaptation weight as the objective function. Combined with budget constraint information, the module obtains the optimal resource combination from the candidate resource set through a preset optimization algorithm. The execution node diagram construction module (104) is used to construct a project execution node diagram based on project requirement parameters, total project contract price and preferred resource combination. The project execution node diagram includes several sequentially related delivery nodes. Each delivery node is bound to node attribute information, which includes completion status, planned completion time, cost information, revenue information and triggering conditions. The dynamic profit calculation module (105) is used to monitor the completion status of each delivery node in real time. When the completion status of any delivery node changes to "completed" and the triggering condition is met, the financial profit and loss is calculated to obtain the current dynamic profit.

10. A computer-readable storage medium storing a computer program capable of being loaded by a processor and executing a marketing resource intelligent scheduling and financial accounting method as described in any one of claims 1 to 8.

Images