US 12,205,141 B2
System and method for aggregating advertising and viewership data
Andrew Castin, Madison, NJ (US); Lou Giocondo, St. Petersburg, FL (US); and Scott Portugal, South Salem, NY (US)
Assigned to WAVEFRONT IP HOLDINGS, LLC, St. Petersburg, FL (US)
Filed by WAVEFRONT IP HOLDINGS, LLC, St. Petersburg, FL (US)
Filed on May 25, 2023, as Appl. No. 18/323,603.
Application 18/323,603 is a continuation of application No. 17/724,657, filed on Apr. 20, 2022, granted, now 11,699,168.
Claims priority of provisional application 63/178,069, filed on Apr. 22, 2021.
Prior Publication US 2023/0298067 A1, Sep. 21, 2023
This patent is subject to a terminal disclaimer.
Int. Cl. G06Q 30/00 (2023.01); G06Q 30/0241 (2023.01); G06Q 30/0242 (2023.01); G05B 19/418 (2006.01)
CPC G06Q 30/0246 (2013.01) [G06Q 30/0244 (2013.01); G06Q 30/0247 (2013.01)] 9 Claims
OG exemplary drawing
 
1. A method for presenting advertising data from a plurality of data sources, comprising:
Loading a plurality of non-standardized aggregated advertisement revenue and viewership data from the plurality of data sources by logging into a supply-side platform and/or a demand-side platform, entering at least one parameter for data retrieval, and storing the data as a key-value pair in a database;
normalizing the data from the plurality of data sources into standardized core data by:
extracting, by a processor, a plurality of common metrics common to two or more of the data sources, the common metrics comprising one or more of a show and episode identifier, a time period, a client identifier, and a date;
combining, by the processor, the data from the two or more data sources based on the common metrics,
storing, in the database, the combined advertisement revenue and viewership data as core data wherein the core data identifies the common metrics; and
presenting the core data by:
receiving a user query;
generating SQL code based on the user query;
executing the SQL code to query the core data;
presenting the core data retrieved from the SQL code;
wherein the aggregated advertisement revenue and viewership data includes a plurality of data points collected over a predetermined time period;
the supply side platform is a user interface configured to access content provider software; and
the demand side platform is a user interface configured to access content buyer software.