System and method for aggregating advertising and viewership data

A method for presenting advertising data from a plurality of data sources, comprising:

• loading advertisement revenue data and viewership data from the plurality of data sources retrieved from a supply-side platform and/or a demand-side platform, by logging-into or accessing each of the plurality of data sources, entering at least one parameter for data retrieval, and storing the advertisement revenue and viewership data in a key-value pair;
• normalizing the advertisement revenue and viewership data into core data by:
• extracting a plurality of common metrics common to two or more of the data sources, the common metrics comprising a show and episode identifier, a time period, a client identifier, and a date;
• combining the advertisement revenue and viewership data from the two or more data sources based on the common metrics,
• storing 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;
• applying one or more business rules to the core data;
• and
• presenting the core data retrieved from the SQL code based on the applied business rules.