Method and system for automating advertising insertion and reconciliation

An ad extraction and reconciliation system comprising:

• an ad extraction manager module receiving an advertisement schedule for an advertisement from an ad source module;
• a controller module receiving broadcast channel schedule data for a broadcast channel from a broadcast channel system and generating an advertising content data request signal for advertising content data including an advertisement content identifier for the advertisement;
• said ad extraction manager module forming an advertisement insertion schedule having the advertisement content identifier and an advertising insertion spot associated with the advertisement content identifier from the broadcast channel schedule data and, when the advertisement is not available:
• retrieving a list of substitute advertisements suitable for use on every channel and for every age group;
• selecting one of the substitute advertisements from the list;
• and
• substituting the selected one of the substitute advertisements into the advertisement insertion schedule;
• said controller module communicating the advertisement insertion schedule to a broadcast scheduling system;
• and
• an as-run manager module receiving as-run data including the advertisement content identifier and a run time of the advertisement after the advertisement was inserted into a broadcast signal according to the broadcast scheduling system at an automation system, said as-run manager module forming reconciliation data using the as-run data and the advertisement schedule and communicating the reconciliation data to the ad source module.