Automated Discrepancy Reporting for Digital Campaigns
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Managing discrepancies in digital media campaign delivery and billing across multiple vendors is cumbersome, manual, and prone to errors, leading to uncertainty in campaign pacing and disputes over billing records.
Innovation Solution
A system that automatically generates a discrepancy report by calculating and displaying delivery data from various vendors, allowing for real-time insight into discrepancies and enabling users to easily identify and address issues, thereby streamlining discrepancy management and campaign adjustments.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of time
If manual methods are used to manage discrepancies between vendors, then flexibility and adaptability are maintained, but time consumption and operational complexity increase significantly
Solution Approach 1:
The patent replaces manual mechanical processes with automated computational systems. Specifically, it uses computer algorithms to automatically retrieve data from multiple vendors, calculate discrepancies, and generate reports, substituting the manual mechanical process of comparing spreadsheets and performing calculations.
Solution Approach 2:
The system enables self-service by automatically performing data retrieval, comparison, and discrepancy calculation without requiring manual intervention. The automated report generation system serves itself by pulling data from vendor feeds, processing it through predefined algorithms, and producing discrepancy reports autonomously.
2Reliability
If multiple vendors track delivery independently with their own mechanisms, then each vendor maintains data accuracy according to their billing system of record, but discrepancies between systems increase and become harder to manage
Solution Approach 1:
The patent segments the complexity by creating a separate automated system that interfaces with multiple vendor systems independently. Each vendor's data is retrieved and processed separately through individual workflows, allowing each vendor to maintain their own data accuracy while the automated system manages the complexity of comparing them all together.
Solution Approach 2:
The automated discrepancy management system acts as an intermediary between multiple vendor systems. It retrieves data from each vendor independently, normalizes the data formats, and performs comparisons, serving as a mediating layer that handles the complexity of multi-system integration without requiring the vendors themselves to change their internal systems.
3Measurement precision
If manual discrepancy management processes are used, then operational procedures remain simple and easy to understand, but accuracy and precision of discrepancy identification decrease
Solution Approach 1:
The patent replaces manual mechanical processes with automated computational systems. Specifically, it uses computer algorithms to automatically retrieve data from multiple vendors, calculate discrepancies, and generate reports, substituting the manual mechanical process of comparing spreadsheets and performing calculations.
Solution Approach 2:
The system implements feedback by automatically generating discrepancy reports that provide precise measurements of differences between vendor data. The automated calculation and presentation of discrepant values with clear indicators provides immediate feedback on accuracy, allowing users to verify and address discrepancies systematically.
4Loss of information
If comprehensive data from all vendors is collected and analyzed, then complete visibility into campaign performance is achieved, but the time and resources required for processing increase
Solution Approach 1:
The patent applies preliminary action by setting up automated workflows that continuously retrieve and process vendor data in advance of when it is needed for analysis. The system proactively pulls data from vendor feeds, performs preliminary comparisons, and prepares discrepancy reports before users need to review them, eliminating the need for manual data collection at the point of analysis.
Solution Approach 2:
The system maintains continuity of useful action by implementing automated, continuous data retrieval and processing workflows. Instead of periodic manual checks, the system continuously monitors vendor feeds, automatically processes incoming data, and maintains up-to-date discrepancy reports, ensuring uninterrupted visibility into campaign performance across all vendors.
Data Source
AI summary
In accordance with embodiments of the present disclosure, each third party system of multiple third party systems can store files including datasets associated with one or more campaigns. A computing system can be in communication with the third party systems and including a first database and a second database. The computing system can be configured to receive the selection of the one or more third-party systems, store metadata associated with the at least one campaign in the first database, calculate at least one discrepant data value between the one or more third party systems, based on the datasets associated with the at least one campaign from each of the one or more third party systems.