Real-time Airing Value Tracking via Database Data Matching

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Current systems lack real-time tracking and valuation of media investments in Direct Response Television (DRTV) and direct-to-consumer advertising, failing to accurately assess the short and long-term value of airings and create buyer profiles for media sources.

Innovation Solution

A database-driven computer system with a specifically programmed server and non-transitory tagging database that periodically collects and verifies media data, call center data, and web tracking data, assigning identifiers and calculating the real-time value of airings by matching records across data tables and updating a master records database to display real-time graphical user interfaces for reporting.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Measurement precision

If real-time tracking and valuation of media investments is implemented, then measurement precision and productivity are improved, but device complexity and data processing requirements increase

Engineering Contradiction:

Improveaccuracy of airing value assessmentVSAvoidsystem complexity

Core Design Contradiction:

Measurement precisionVSDevice complexity

Solution Approach 1:

The system segments the complex measurement task into separate data collection modules (media data, web tracking data, call center data, fulfillment data) and processes them through distinct tables and procedures. Each segment handles specific aspects of tracking, allowing the system to achieve high measurement precision through modular processing of complex data

Inventive Principle:

Principle #1Segmentation

Solution Approach 2:

The database serves as an intermediary structure that mediates between multiple data sources and the final valuation output. It provides standardized schemas for storing and relating media data, web data, call center data, and fulfillment data, enabling precise cross-table matching and real-time value calculation without direct complex processing

Inventive Principle:

Principle #24Intermediary (Mediator)

2Productivity

If real-time data collection and processing is implemented, then productivity and responsiveness are improved, but loss of time in data verification and validation increases

Engineering Contradiction:

Improvereal-time tracking capabilityVSAvoidtime for data verification

Core Design Contradiction:

ProductivityVSLoss of time

Solution Approach 1:

The system performs preliminary verification of data schemas and validation rules when data is first collected and stored in the database. By verifying data structure and format at the point of entry through predefined schemas, the system eliminates the need for time-consuming verification during real-time processing, maintaining both high productivity and data accuracy

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The database schema itself provides self-verification capabilities through its structured design and constraints. The schema automatically validates incoming data against predefined formats and relationships, enabling the system to self-verify data integrity without requiring additional manual verification time during real-time operations

Inventive Principle:

Principle #25Self-service

3Loss of information

If comprehensive data collection from multiple sources is implemented, then measurement precision and completeness are improved, but device complexity and data management requirements increase

Engineering Contradiction:

Improvecompleteness of buyer profile dataVSAvoiddata management complexity

Core Design Contradiction:

Loss of informationVSDevice complexity

Solution Approach 1:

The database schema provides a universal framework that handles multiple data types (media data, web tracking data, call center data, fulfillment data) through a single integrated structure. This multi-functional design allows the system to collect and manage comprehensive buyer profile information from diverse sources without proportionally increasing complexity, as all data types follow the same organizational patterns

Inventive Principle:

Principle #6Universality (Multi-functionality)

Solution Approach 2:

The system implements nested data structures where buyer profiles contain embedded information from multiple data sources. The profile structure nests media data, web interaction data, call center data, and fulfillment data in a hierarchical manner, allowing comprehensive information to be organized in a compact, manageable way that reduces data management complexity

Inventive Principle:

Principle #7Nested doll (Nesting)

Data Source

PatentUS9159095B1Database driven computer systems providing real-time updatable graphical user interfaces to track real-time value of airings

Publication Date: 2015.10.13 I PREDICTUS

AI summary

In some embodiments, the present invention is directed to database driven computer systems providing real-time updatable graphical user interfaces to track real-time value of airings, including: a specifically programmed server; a database accessible by the server, where the server includes a plurality of modules configured to perform: electronically and periodically obtaining media data, web tracking transaction data, call center transaction data, and fulfillment transaction data; associating, in real time, media data records of airings of creatives to fulfillment transaction records by matching records among database tables having media data, web tracking transaction data, call center transaction data, and fulfillment transaction data; continuously calculating, in real-time, a current value of a particular airing of a particular creative; and displaying a graphical user interface, including real-time updated look-up items, outputting one or more real-time report based at least on the continuously calculating the current value of the particular airing.