US20130339134A1

US20130339134A1 - Method and System for Auditing Advertising Agency Performance

Info

Publication number: US20130339134A1
Application number: US13/967,744
Authority: US
Inventors: Thomas E. Bridge; Steven L. Vache
Original assignee: Media Management Inc
Current assignee: Media Management Inc
Priority date: 2004-03-26
Filing date: 2013-08-15
Publication date: 2013-12-19
Also published as: US8589227B1

Abstract

Computerized techniques are disclosed for automatically converting buy data from advertising agencies into a common format for storage in a database. The commonly formatted buy data can be automatically analyzed to assess advertising agency performance in executing advertising plans on behalf of their client companies. The buy data can be representative of original buys, final buys, and/or actual buys.

Description

CROSS-REFERENCE AND PRIORITY CLAIM TO RELATED APPLICATIONS

This application is a continuation of pending U.S. patent application Ser. No. 11/253,040, filed Oct. 18, 2005 and entitled “Method and System for Reconciling Advertising Invoices and for Providing Prompt Payment Therefor”, now U.S. Pat. No. _____, which is a continuation-in-part of U.S. patent application 10/810,466, filed Mar. 26, 2004 and entitled “Method and Apparatus for Auditing the Performance of Advertising Agencies on Behalf of Their Clients”, the entire disclosures of each of which are incorporated herein by reference.

FIELD OF THE INVENTION

The parent invention relates to a technique whereby advertising agencies are audited to analyze their performance in connection with executing advertising plans for their clients.
The present invention relates to a technique whereby advertising invoices can be promptly reconciled. The improved reconciliation also allows for prompt and accurate payment to media properties for advertising services that have been rendered.

BACKGROUND OF THE INVENTION

Companies typically utilize one or more advertising agencies to devise and implement one or more advertising plans on their behalf. In these plans, advertising agencies typically identify a number of goals and other information related to the plan. As used herein, the term advertising agency encompasses all business entities that engage in the practice of media buying.
For example, the plans will typically identify the media in which advertisements will run. Examples of media include but are not limited to television, radio, and print. The choice of the actual media properties, as well as the time and place in which the advertisements will run, is generally left to the discretion and expertise of the advertising agency. Examples of media properties include but are not limited to television networks, specific television stations, radio stations, newspapers, and magazines.
Further, the plans will typically identify the markets in which advertisements will run. Often, markets are identified in terms of designated market areas (DMAs). DMAs are well known in the field of advertising and typically encompass a core city and the surrounding area. Examples of DMAs include but are not limited to the St. Louis DMA (which would encompass the city of St. Louis, Mo. and nearby surrounding communities in Missouri and Illinois) and the Miami/Fort Lauderdale DMA (which would encompass the cities of Miami, Fla. and Fort Lauderdale, Fla. as well as their nearby surrounding communities). Depending upon the scope of the advertising plan, multiple DMAs may be targeted by an advertising agency when executing a client's advertising plan.
Further, advertising plans will typically identify a target demographic and a desired level of exposure for that target demographic. A common target demographic for companies engaged in mass market sales is the age 18-49 demographic. However, as would be understood, the target demographic can be particularized according to virtually any trait, including but not limited to different age classifications, gender, occupation, heritage, income level, political preference, etc. Exposure levels for television and radio advertising are typically expressed in terms of target rating points (TRPs). One TRP is well-known in the art to be one percentage point of the number of people estimated to be viewing a television/radio spot versus the number of people who could be viewing the television/radio spot. For example, if market A includes 100,000 people who could be watching television and an advertisement is run on a particular TV channel at a time when 50,000 people in market A are watching that channel, that advertisement will have achieved 50 TRPs. Exposure levels for print advertising are typically expressed in terms of circulation for the print item.
Advertising plans will typically identify a target number of total TRPs and/or a total amount of circulation desired for various advertisements during a specified time period (year, quarter, month, etc.). The budget for an advertising plan can then be expressed in terms of cost per TRP or cost per thousands of circulation (CPM), wherein a total cost for the advertising plan is expressed as the sum of (1) a total number of TRPs desired multiplied by the average cost of a TRP, and (2) a total amount of desired circulation (in the thousands) multiplied by an average CPM.
Once the expected cost for the advertising plan is calculated by the advertising agency and approved by the client, the advertising agency sets out to purchase the plan. Agencies execute clients' advertising plans by purchasing advertisement time/space with media properties. For TV/radio ads, advertisement times are usually requested in terms of dayparts. A daypart is a component of a day that relates to a specific time period. Dayparts are well known in the art, and common dayparts include, but are not limited to: morning, daytime, early fringe, early news, prime access, prime, late news, weekend, sports, etc. However, it should be noted that different entities may use different definitions for daypart components. For example, one media property may consider early fringe to begin at 4:30 pm CST and end at 5:00 pm CST, while a particular advertising agency may consider early fringe to extend from 4:00 pm CST to 5:00 pm CST. For print ads, advertisement placement is usually specified in terms of page placement.
The advertising agency's initial attempt to purchase advertisement time/space with media properties can be referred to as an original buy. Media properties generally have the final say on what gets aired, and media properties will often shuffle advertisement requests or fail to air advertisement requests included in the original buy for a variety of reasons (scheduling demands, better offers coming along, etc.).
After the shuffling settles following the original buy, the advertising agency places its final buy with the various media properties. Final buys correspond to final requests for advertisement spots placed with media properties by an agency. Once again, there is no guarantee that all elements of the final buy will be carried out as desired by the advertising agency because the media properties may make further alterations. The cost for a final buy is typically based on the cost per spot for the time at which the advertisement is to run.
Once the advertisements actually run, data corresponding to these actual advertisements are expressed in the actual buy. The actual buy TRP value for each actual advertisement can be determined from independent sources such as Nielsen TV ratings and Arbitron radio ratings, and represents the number of TRPs achieved by the airing.
As for costs, media properties typically bill advertising agencies for their clients' advertisements at the end of the standard broadcast month (based on a final Sunday per month cycle). The agencies typically receive their bills from the media properties by the 20^thof the month following the previous month's activity. Clients are typically pre-billed by the agencies throughout this process. Pre-billing to the client from the advertising agency typically occurs the first day of the month of the purchased activity, and the pre-bill is based on the estimated costs for the month billed. The portion of the client's payment to the agency that is to be applied to media property invoices is deposited in a financial account by the agency. As invoices are received from media properties and verified for accuracy by the agency, payments are made to media properties for their invoices from the financial account. Billed costs in media property invoices are typically based on unit costs as generated by the media property. Unit cost is typically a derivative of the estimated target rating point (TRP) multiplied by the cost per rating point.
It is believed by the inventors herein that a typical account receivable time period in the advertising industry for payment to media properties on media property invoices received by advertising agencies is around 90 days. During this lengthy account receivable period, the client's money (which was pre-billed by the agency) sits in the account maintained by the agency, where it earns interest. This interest is typically kept by the agency and represents a perk for agencies that creates a disincentive for prompt payment of media property invoices. It is believed by the inventors herein that the interest on these accounts amounts to a yearly boon to the advertising agency industry upward of $40 billion.
This interest is believed to represent a “hidden” cost to clients of advertising agencies. That is, due to the time value of money, the delay that media properties experience in connection with payment of their invoices effectively results in a loss of potential income to the media properties, which is believed to translate into higher advertising prices being passed on to clients.
Accordingly, the inventors herein believe that a need exists in the art for a new system that can decrease the delay experienced between the time a media property advertising invoice is received and the time that the media property advertising invoice is reconciled and paid.
Also, in the past, attempts to accurately audit the performance of advertising agencies in carrying out the advertising plans of their clients throughout the process described above have been difficult.
Often, the advertising agency would provide its client with a self-audit of its own performance. However, due to the conflicts of interest inherent in such self-audits, these audits have not proven valuable to clients as an objective measure of an agency's performance because, more often than not, the self-audits would inevitably establish a wonderful performance by the agency.
With respect to independent advertising agency audits conducted by unbiased third parties, the task of assembling an audit report has proven to be a gargantuan task requiring tedious efforts by teams of auditors. To perform such an audit, these auditors are required to pore through and make sense of volumes of paper documents that relate to advertisement postings by advertising agencies. Because of the massive manpower required for these efforts and because of the unsatisfactory lack of detail and flexibility in these conventional independent audit reports, the inventors felt there was a great need in the art for an improved method of objectively auditing advertising agencies to evaluate their performances in executing their clients' advertising plans.

SUMMARY OF THE INVENTION

To fill such needs, the inventors herein have designed a system whereby a repository of data relating to agencies' executions of clients' advertising plans is maintained. From this repository, audit reports can be automatically generated that detail the agencies' performances on behalf of their clients.
According to one aspect of the parent invention, disclosed herein is a method of auditing an advertising agency to evaluate how the agency performed in executing an advertising plan on behalf of a client, the method comprising: (1) storing data that describes the advertising plan; (2) storing data that describes a plurality of actual advertisements, each actual advertisement corresponding to at least one client advertisement placed by the agency that was run by at least one media property; and (3) processing the stored plan data and the stored actual advertisements data to generate data indicative of whether the actual advertisements satisfied the advertising plan. The processing step of the method preferably comprises obtaining exposure data for the actual advertisements data from an independent source such as Nielsen ratings or Arbitron ratings and then matching the actual advertisements data with the exposure data obtained therefor. Further still, the method preferably further comprises generating a report from the generated data for delivery to the client. Such reports include not only paper reports printed from the generated data but also visual displays of the generated data such as those displayed on a computer monitor. The level of detail and the flexibility in the level of detail available in the generated reports is set forth in greater detail below.
According to another aspect of the parent invention, disclosed herein is a method of creating a database of data for evaluating how a plurality of advertising agencies perform on behalf of their clients, each client having at least one advertising plan that at least one of the advertising agencies has attempted to implement, the method comprising: (1) receiving data describing a plurality of actual advertisements, actual advertisements being advertisements placed by agencies with a plurality of media properties on behalf of the clients that were actually run by the media properties, the actual advertisements data having a plurality of formats; (2) converting the received actual advertisements data to a common format; and (3) storing the converted actual advertisements data in a database for subsequent use in an audit of at least one advertising agency for at least one client.
The inventors herein further disclose a system for determining an amount of money to be transferred to a media property in satisfaction of an invoice from that media property, the system comprising: an invoice reconciliation system configured to automatically reconcile a plurality of invoice items with a plurality of final buy items to determine an amount of money to be transferred, preferably electronically, to the media property in satisfaction of the invoice items, each invoice item corresponding to an actual advertisement spot that was run and invoiced by the media property, each final buy item corresponding to an advertisement spot request that was placed by the advertising agency with the media property.
This invoice reconciliation system can be further configured to (1) identify a plurality of invoice items for which an exception handling condition applies, and (2) provide at least one graphical user interface (GUI) for display to a user, the at least one GUI being configured to interact with the user about at least one invoice item for which an exception handling condition has been identified, the interaction including receiving input from the user corresponding to an action to be taken on the at least one invoice item.
A significant challenge in developing an invoice reconciliation system for media property invoices in the advertising industry relates to the ability of such a reconciliation system to be cross-platform in terms of the different software packages that many advertising agencies and media properties use in connection with the final buy and invoice activities. Accordingly, the inventive system preferably also includes a conversion system and a database in communication with the conversion system and the invoice reconciliation system, wherein the conversion system is further configured to (1) receive the invoice items in a first format, (2) receive the final buy items in a second format, (3) convert at least the received final buy items to a format in common with the invoice items, and (4) store the invoice items and the converted final buy items in the database, and wherein the invoice reconciliation system is further configured to retrieve a plurality of the stored invoice items and a plurality of the stored final buy items prior to performing reconciliation.
Moreover, the invoice reconciliation system is preferably further configured to communicate money transfer authorization instructions to a computer system that controls the disbursement of funds to pay media property invoices, the money transfer authorization instructions identifying at least (1) the determined amount of money to be transferred to the media property and (2) the media property to which the determined money amount from the account is to be transferred.
According to another aspect of the present invention, the inventors herein disclose a computer-implemented method of reconciling media property invoice data for advertising services with advertising agency final buy data, the media property invoice data comprising a plurality of invoice items, each invoice item corresponding to an actual advertisement spot that was run by the media property, the final buy data comprising a plurality of final buy items, each final buy item corresponding to an advertisement spot request that was placed by the advertising agency with the media property, the method comprising: (a) comparing the invoice items with the final buy items, and (b) responsive to the comparing step, identifying the invoice items for which a payment to the media property is authorized. Corresponding software for performing this method is also disclosed herein.
According to yet another aspect of the present invention, the inventors herein disclose a computer-implemented method of creating commonly formatted media property invoice data for advertising services and advertising agency final buy data, to thereby allow reconciliation of the media property invoice data with the advertising agency final buy data, the media property invoice data comprising a plurality of invoice items, each invoice item corresponding to an actual advertisement spot that was run by the media property, the final buy data comprising a plurality of final buy items, each final buy item corresponding to an advertisement spot request that was placed by the advertising agency with the media property, the method comprising: (a) receiving the invoice items in a first format, (b) receiving the final buy items in a second format, and (c) performing at least one of the steps selected from the group consisting of (1) converting the received final buy data to a common format, (2) converting the received invoice data and the received final buy data to a common format, (3) converting the received invoice data to the second format, and (4) converting the received final buy data to the first format. Corresponding software for performing this method is also disclosed herein.
These and other features and advantages of the parent and present inventions will be in part apparent and in part pointed out in the following description, referenced figures, and appendices.

BRIEF DESCRIPTION OF THE DRAWINGS

FIG. 1 depicts an overview of the preferred embodiment of the present invention;

FIG. 2 depicts a preferred invoice reconciliation system;

FIG. 3 is a flowchart overview for creating a database of commonly formatted invoice data and final buy data;

FIG. 4 depicts an exemplary data format for raw final buy data;

FIG. 5 depicts an exemplary data format for invoice data;

FIG. 6 is a flowchart illustrating a preferred process for reconciling the invoice data with the converted final buy data;

FIG. 7 is a flowchart detailing step 604 of FIG. 6;

FIGS. 8( a)-(f) illustrate various preferred exception handling GUIs;

FIG. 9 depicts a preferred GUI for viewing a list of messages received by a media property user;

FIGS. 10( a) and (b) depict various preferred GUIs for a media property user to respond to a request submitted via the GUIs of FIGS. 8( a)-(f);

FIG. 11 depicts an overview of the preferred embodiment of the present invention;

FIG. 12 depicts a preferred user interface for entering plan data and original buy data into the database;

FIG. 13 depicts a preferred user interface for entering data relating to an analysis of costs per media property;

FIG. 14 is a flowchart overview for the auditing process for the preferred embodiment of the parent invention;

FIG. 15 depicts an exemplary data format for raw final buy data;

FIG. 16 depicts an exemplary data format for raw posted buy data;

FIG. 17 is a flowchart illustrating the processing for recoding raw daypart data;

FIGS. 18( a)-(c) depict an example of a mapping table for recoding raw daypart data;

FIG. 19 depicts a preferred user interface for overriding the independent exposure data for an advertisement posting;

FIG. 20( a)-(e) illustrate various preferred user interfaces for generating audit reports;

FIGS. 21( a)-(d) illustrate various preferred market analysis audit reports;

FIG. 22 illustrates a preferred average ratings audit report;

FIGS. 23( a)-(c) illustrate various preferred CPP audit reports;

FIGS. 24( a)-(d) illustrate various preferred under delivery tracking audit reports;

FIGS. 25( a)-(h) illustrate various other preferred audit reports;

FIGS. 26-68 illustrate a sample audit report for TV/radio; and

FIGS. 69-278 illustrate a sample audit report for print media.

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

Parent U.S. patent application Ser. No. 10/810,466

FIG. 11 depicts an overview of the preferred embodiment of the parent invention. The auditing system 1100 comprises a computer 1102 that receives raw data relating to advertisement buys for clients by advertising agencies 1108. This raw data is preferably received from the agencies electronically over a network such as the Internet. However, any known form of communication can be used to communicate the raw data to the auditor, including leased data lines and mailings from agencies to the auditor. However, transmission of the data to the auditor in the form of paper copies is not preferred as it requires intervention by the auditor to perform manual entry of the raw data into a database. It is believed that through various negotiations between agencies, agency clients, and the auditor, advertising agencies can be persuaded to utilize electronic transmission of the raw data to the auditor. Preferred transmission techniques include e-mail and file uploads over a network, such as http uploading over the Internet.
The auditor preferably maintains a computer 1102 and database 1104 to perform the auditing functions of the preferred embodiment of the parent invention. The computer is preferably a commercially-available Dell Poweredge 2650, and the database is preferably a commercially-available Microsoft MS SQL 2000. It should be understood that the computer 1102 and database 1104 can be implemented with other hardware, including an implementation as a personal computer, workstation, or server that can be accessed over a network such as the Internet. As will be explained in greater detail below, the database 1104 serves as a repository for the data used in the auditing process. The computer 1102 preferably provides the programming logic, or code segments executable by a processor, for performing the audit. This programming logic can reside on memory of computer 1102 or on a device such as a compact disc (CD) or the like to be accessed by computer 1102 from a disk drive or the like. Also, this programming logic preferably includes a code segment for displaying and controlling a graphical user interface 1106 that is configured to interact with a user to manage the auditing process and, if necessary, provide data entry functionality. Preferred tasks for the user interface 1106 are to provide the user with the ability to add data to the database 1104 as appropriate and to provide the user with control for generating the audit reports of the preferred embodiment.
The auditor for the preferred embodiment of the parent invention is preferably a party or entity independent from the advertising agencies being audited. By virtue of this independence, clients can be reassured as to the unbiased nature of the audit results. However, as should be understood by those of ordinary skill in the art, an advertising agency and/or an advertising agency client can also practice the invention by serving as the auditor themselves.
In one embodiment, access to the user interface 1106 is restricted to the independent auditor. However, in another embodiment, some or all tasks of the user interface can be implemented on a client's computer such that the client has remote access over a network such as the Internet to the computer 1102 and database 1104. This embodiment provides clients with the power to generate audit reports without going through a third party auditor. In such an embodiment, it is preferred that the computer 1102 or a server that controls access to computer 1102 implement conventional security measures to maintain the integrity of clients' data in the database 1104 by restricting a client's access to the database to its own data. Further still, in another embodiment, the user interface can also be implemented on an agency's computer such that the agency has remote access over a network such as the Internet to the computer 1102 and database 1104, thereby providing agencies with the power to generate audit reports of themselves. This embodiment also preferably involves the computer 1102, or a server that controls access to computer 1102, implementing conventional security measures that prevents an agency from gaining access to data unrelated to that agency.
Creating the Database of Audit Data:
One aspect of the preferred embodiment relates to storing data that describes the agency advertising plans in the database. The advertising plan, which is typically communicated by the agency to the client in writing, generally specifies on a quarterly basis: the markets in which ads are to run, a target demographic for the plan, a desired number of TRPs for each daypart in the market that are to be achieved by the plan, and a total cost for the plan. Once the auditor receives such plan data, the auditor preferably uses the interface 1350 of FIG. 12 to store the plan data in the database. However, as should be understood, the plan data can also be communicated to the computer 1102 electronically from either the client or the agency.
With reference to FIG. 12, the auditor preferably enters a client identifier such as a client's name in field 1222. Further, the auditor preferably enters an agency identifier such as an agency's name in field 1224. The DMA for the plan is preferably entered in field 1226, the duration for the plan (typically measured in terms of quarters, although other durations, such as monthly, can also be used) in field 1228, and the target demographic in field 1230. Further still, the auditor preferably enters an identifier for the advertising plan in field 1232 and a total cost for the plan in field 1234.
Row 1236 is set aside for entering TRP data for the plan by daypart, with each daypart corresponding to a different column 1240 a through 1240 o. If the agency (or client) does not provide TRP data for the plan that is broken down by daypart, the interface 1350 preferably includes an override control feature 1242. By checking box 1242 a and entering an aggregate sum of TRPs for all dayparts identified for the plan in field 1242 b, the auditor can directly enter the aggregate TRP sum in the database.
Once the auditor has completed entry of the plan data, the database includes an important point of reference for performing an audit on the advertising agency.
Another aspect of the preferred embodiment relates to storing original buy data in the database. Advertising agencies typically provide clients with original buy data on a quarterly basis. This original buy data is often communicated in paper form, thus requiring further data entry by the auditor to get the data into the database. However, as should be understood, the agency or the client can communicate the original buy data to the auditor electronically as explained below in connection with the final buy data and the actual buy data. The interface 1220 of FIG. 12 can also be used by the auditor to enter original buy data into the database. Row 1238 is set aside for entering TRP data for the original buy by daypart, with each daypart corresponding to a different column 1240 a through 1240 o. If the agency (or client) does not provide TRP data for the original buy that is broken down by daypart, the interface 1350 preferably includes the override control feature 1242 as described above. Once the auditor has completed entry of the original buy data, the database includes another point of reference for performing an audit on the advertising agency.
FIG. 13 corresponds to a user interface for entering data relating to an analysis of costs per media property. The auditor preferably enters data for the client, the agency, the
DMA, the target demographic, the time duration, and the plan in fields 1352, 1354, 1356, 1358, 1360, and 1362 respectively. Further, each row 1374 corresponds to data for a different media property identified by an identifier, such as station call letters, in column 1364. For each media property, the interface 1350 provides a field in column 1366 for a time duration (preferably by month, although other time periods can be used), a field in column 1368 for the total cost of the original buy for the plan, a field in column 1370 for the amount of money billed to the agency by the media property for the plan (affidavit data), and a field in column 1372 for the amount of money remitted by the agency to the media property for the plan (remittance data).
FIG. 14 is a flowchart overview for the auditing process for the preferred embodiment of the parent invention. At step 1400, the raw data relating agencies' final buys and actual buys are received from the agencies (preferably electronically). Each agency may store the final buy data and/or the actual buy data in different formats depending upon the software packages used by the agencies. Examples of industry-used formats for the final buy data and the actual buy data are the DDS format (1400 a) for media buy software from Donovan Data Systems, Inc., the Strata format (1400 b) for media buy software from Strata Marketing, Inc., the Adware (1400 c) format for software from AdWare Systems, Inc., and the SmartPlus format (1400 d) for software from the company Marketing Resources Plus. It should be noted that other data formats may also be used in the practice of the invention.
FIG. 15 illustrates a sample format for a final buy data file that would be received electronically from an advertising agency in the preferred embodiment of the parent invention. The final buy data can be provided as a flat file, as a relational database structure, or other known forms for maintaining data. In the example of FIG. 15, the final buy data is presented as a flat file through table 1500, with each table row corresponding to a different advertisement spot that was requested by the agency and each column including pertinent data for that advertisement spot.
With reference to FIG. 15, data in column 1502 identifies the media in which the advertisement spot is to run. The data in column 1504 identifies the client. The data in column 1506 provides an identifier for the product/service that corresponds to the advertisement. The data in column 1508 provides an identifier code for the plan corresponding to the advertisement spot, and the data in column 1510 provides the name of the plan corresponding to the advertisement spot.
Further, the data in column 1512 identifies the beginning and end dates for the final buy request (expressed by week). The data in column 1514 identifies the DMA in which the final buy was requested, the data in column 1516 identifies the media property with which the final buy request was placed, and the data in column 1518 identifies a line code for the media property. The line code serves as a reference to the advertising agency buy line, as is known in the art.
Further still, the data in column 1518 identifies the program during which the advertisement spot is to run, the data in column 1520 identifies the daypart code for the time during which the advertisement spot is to air, the data in column 1522 specifies the length (in seconds) for the advertisement spot, the data in column 1524 specifies the scheduling rotation by day for the program, and the data in column 1526 identifies the air time for the program. Moreover, the data in column 1528 identifies the cost for the advertisement spot, and the data in column 1530 identifies an estimation by the agency of the amount of exposure for the advertisement spot (in terms of a total number of TRPs that the agency thinks the advertisement spot will achieve if it runs during a commercial break for the program). Columns 1532, 1534, and 1536 each correspond to a particular week during the time period identified in column 1512. The data in each of these columns identifies the number of advertisement spots requested for that program during the specified week. Lastly, the data in column 1538 includes any comments that an agency may wish to include for the advertisement spot. For example, the agency may want to note as a comment that the spot was aired to make good on an earlier missed spot, that a spot's tardy airing was due to a sports program running long, or that a spot's airing was pre-empted by news war coverage.
It should be noted that the final buy data format of FIG. 15 is exemplary only. Different advertising agencies will often use different formats. As a result of this diversity, the final buy data received by a practitioner of the parent invention is expected to have a wide variety of formatting differences. For example, two agencies may use the same fields for their data, but provide those fields in a different sequential order. Also, some of the fields used by one agency may not be used by another agency (e.g., one agency provides a field for “line” data (column 1518 in FIG. 15, while another agency does not). Also, two or more agencies may use different formats for the data that populates the fields (e.g., Agency A codes dates numerically as mm/dd/yy (12/31/03) while Agency B codes dates alphanumerically as month name, month date, year (Dec. 31, 2003); Agency A codes dayparts with a two letter code, Agency B codes dayparts with a three letter code, and Agency C codes dayparts with a four letter code). Further still, when the final buy data is provided as electronic files, some agencies may provide the final buy data in a relational database format, while others may supply the data in a flat file format, while yet others may supply the data in other known electronic data structures.
FIG. 16 illustrates a sample format for an actual buy data file that would be received electronically from an advertising agency in the preferred embodiment of the parent invention. This actual buy data preferably arrives as invoices from the agencies, although this need not be the case. For example, some agencies could conceivably provide the actual buy information as a report separate from their invoices. As with the final buy data, the actual buy data can be provided as a flat file, as a relational database structure, or other known forms for maintaining data. In the example of FIG. 16, the actual buy data is presented as a flat file through table 1600, with each table row corresponding to a different advertisement spot that was run by a media property (an actual advertisement) and each column including pertinent data for that actual advertisement.
The data in columns 1602, 1604, 1606, 1608, 1610, 1612, and 1614 correspond, respectively, to the data in columns 1502, 1504, 1506, 1508, 1510, 1514, and 1516 in the final buy data of FIG. 15. The data in column 1616 identifies the date on which the actual advertisement ran, and the data in column 1618 identifies the day on which the actual advertisement ran. The data in column 1620 identifies the time at which the actual advertisement ran, and the data in column 1622 identifies the length (in seconds) for the actual advertisement. The invoiced cost for the actual advertisement is identified in column 1624 and the invoice number is identified in column 1626. Lastly, the data in column 1628 identifies the film code for the actual advertisement. The film code is preferably defined by industry standards as known in the art.
It should be noted that, as with the final buy data, the actual buy data format of FIG. 16 is exemplary only. Different advertising agencies will often use different formats, as explained above in connection with FIG. 15.
Because of the diversity in the final buy data and the actual buy data received from the agencies (this received data can be referred to as raw final buy data and raw actual buy data), the parent invention preferably converts the received raw data to a common format to greatly simplify the processing logic used to audit the data stored in the database. Accordingly, the programming logic for performing the audit need not account for each individual raw data file format, thereby enhancing the modularity of the auditing logic to provide for increased flexibility in the event the auditing logic is to be altered, or in the event that a new format for raw data is received.
A practitioner of the parent invention can select the common format for the conversion step 1402 of FIG. 14 as a design choice based on a personal evaluation of the facts and circumstances relating to the system. For example, the common format can be one created by the auditor. The common format can also be one of the existing “raw” formats (such as Strata or DDS), which would reduce the translational burden and allow other processing steps to utilize off-the-shelf software (such as steps 1410 and 1412 discussed below). However, as facts and circumstances may dictate, some practitioners of the parent invention who do not want to be limited to the use of such off-the-shelf software may find it more agreeable to develop their own common format. Further, the data structures for the common format may be selected to be structures for a relational database to facilitate storage using well-known database language techniques, or it can be a flat file format for practitioners of the parent invention who are less comfortable with relational databases.
Once the practitioner of the parent invention identifies the raw data formats and common data format involved in the conversion process, a mapping table for mapping raw data values for each of the fields in the raw data file records in the various exemplary file formats 1400 a through 1400 d into the common format can be generated using ordinary skill in the art. This mapping table can then be used in performing the conversion step 1402.
One preferred aspect of the raw data conversion is the enforcement of standardized coding for the data fields (step 1402 of FIG. 14). One of the data fields that is preferably standardized is the daypart code field for the raw data. Each file format often uses different daypart codes to express the same daypart.
FIG. 17 illustrates the process for daypart recoding. At step 1700, the format for the daypart code data for a buy record in a file is identified. Then, at step 1702, the process performs a look-up in a daypart mapping table for an entry that matches the daypart code of the identified format. FIG. 18 illustrates an exemplary daypart coding matching table 1800. The data in column 1802 identifies the format for the mapping table entry 1810, the data in column 1804 identifies a known daypart code for the format of column 1802, the data in column 1806 identifies the standardized daypart code for that entry, and the data in column 1808 identifies the media type for the entry.
If step 1704 finds a matching entry in column 1804 of the table 1800 for the format of column 1802, then at step 1706, the daypart code is replaced by the standardized code in column 1806 of the matching entry. Thereafter, at step 1708, the process moves on to the next daypart code in the raw data file and the process begins anew.
If step 1704 does not find a matching entry in the daypart mapping table, the process proceeds to step 1710. At step 1710, an auditor is preferably prompted with a user interface that requests manual entry of a replacement daypart code. To facilitate the auditor's task, the user interface preferably identifies the file format for the daypart code data, the actual daypart code, the program corresponding to the daypart code from the same buy record of raw data, the day(s) of the week and date(s) for the entry in the same row of raw data, and the time for the program. From this data, the auditor will be able to determine the appropriate replacement daypart code and enter that code through the interface. At step 1712, the replacement daypart code received from the auditor replaces the raw daypart code, and at step 1714, the mapping table 1800 is updated with the new replacement daypart code data. Accordingly, the mapping table 1800 is a “learning” table that is updated as new daypart code translations are needed. Over time, it would be expected that the route through the flow of FIG. 17 will follow more and more the automated path of steps 1700-1708, bypassing the auditor intervention steps of 1710-1714.
Further, it is preferable that other aspects of the raw data be standardized, such as the DMAs, media property identifiers, and demographic classifications. Likewise, the technique of FIG. 17 can be used for mapping data value of these data fields as well.
With reference to FIG. 14, the output of the conversion step 1402 will be an import/export file 1404 for the converted final buy data and the converted actual buy data. This file will be in the common format. Thereafter, at step 1406, this common format file 1404 is imported into a database to create a database 1408 of converted final buy and converted actual buy data.
Thereafter, at step 1410, the content of the database 1408 is processed to determine whether the advertisement spots in the final buy data match with the actual advertisements in the actual buy data. This step is performed by attempting to match entries in the final buy data with entries in the posted buy data and vice versa. Matching and non-matching entries are flagged accordingly.
Further, at step 1411, the data values of data fields in the database 1408 are recoded as necessary to provide uniform standards for data from different agencies. It is within the judgment of a practitioner of the invention as to which fields will have their data values standardized. However, it is preferred that the daypart codes assigned to the records in the final buy data and actual buy data be standardized at step 1411. As previously noted, different agencies often use different definitions for dayparts such that the time period covered by Agency A's “early fringe” daypart may be different than the time period covered by Agency B's “early fringe” daypart. Thus, at step 1411, it is preferred that the final buy and actual buy daypart records be substantively re-evaluated using a standard set of daypart definitions based at least in part on time of day, day, and date. This standard set of daypart definitions is preferably client-specified, although this need not be the case. In a current implementation, the auditor manually evaluates and recodes (if necessary) the dayparts assigned to the final buy and actual buy records. However, it should be noted that this step can also be automated.
Next, at step 1412, the process obtains exposure data for the actual advertisements from an independent source. This exposure data is preferably expressed in terms a number of TRPs achieved for an actual advertisement. There are a number of well-known commercial sources for independent exposure data, such as A.C. Nielsen for TV ratings data and Arbitron for radio ratings data. The entries for each actual advertisement are thereafter updated with the exposure data, thus creating database 1414 of advertisement postings data (or posted buy data).
Additionally, it is preferred that step 1412 also include obtaining Spot Quotation and Data (SQAD) data that pertains to TRP costs. SQAD data is well-known and commercially-available in the art. This SQAD data can be entered in the database manually, although as should be understood, this need not be the case. It is also preferred that step 1412 include obtaining NSI average ratings data, which is also commercially-available in the art. This NSI data can also be entered in the database manually, although this need not be the case. Further still, the obtaining of the SQAD data and the NSI data need not be limited to step 1412, as the SQAD and NSI data can also entered into the database at other times, unrelated to the flow of FIG. 14.
The creation of software code for steps 1410 and 1412 is within the skill of ordinary programmers. However, it should be noted that software is commercially available for performing these tasks. Suitable commercially-available software platforms for performing steps 1410 and 1412 are available from Strata Marketing, Inc., CORE, TvScan (formerly known as TAPSCAN, Inc., and now a part of Marketron International), Marketing Resources Plus, Donovan Data Systems, Inc., and AdWare Systems, Inc., as is known in the art.
In some cases, an advertising agency, a client, or a media property disagrees with the independent TRP value assigned to a particular actual advertisement. Typically, the TRP provided by the independent source represents a measure based at least in part on a ¼ TRP achieved by a program for a certain time period. Such ¼ hour TRPs may not take into account the special circumstances of a particular airing of the program. For example, if the program during which an actual advertisement ran was a baseball game for a team based in the applicable DMA, the ¼ hour TRP measure for that team's games may be much lower than a TRP achieved when a game with the team's archrival is aired. In such circumstances, the agency/client/media property may request that the independent TRP amount for the program be overridden with a different measure. To achieve this functionality, the preferred embodiment of the parent invention includes the interface 1900 of FIG. 19.
Through interface 1900, the auditor preferably can specify the applicable client, agency, DMA, target demographic, time duration, and media property in fields 1902, 1904, 1906, 1908, 1910, and 1912 respectively. In field 1914, the auditor can pull up the name of the program applicable to the inquiry (i.e., the name of the program during which the actual advertisement ran). Once the applicable program is identified, its estimated TRP value from the final buy data is preferably displayed in field 1918 and its “actual” TRP value from the independent source is preferably displayed in field 1920. Through field 1922, the auditor can provide an adjustment of the “actual” TRP value. Further, the auditor can provide the reason(s) for the adjustment in the “comments” field 1924. Further still, if the auditor would like to remove an adjustment made to the “actual” TRP value for an advertisement posting, he/she can do so using the “delete adjustment” button 1916.
Database 1414, together with the database(s) into which the plan data and the original buy data were stored, form the audit database 1104. Database 1104 can be implemented as a single database or can be implemented as several distributed databases according to the preference of a practitioner of the invention.
The database 1104 serves as a valuable repository for analyzing the performance of advertising agencies when executing the advertising plans of their clients. From the content of database 1104, audit reports detailing the agency performances from a variety of analytical perspectives can be generated. For example, the reports can identify the performance of multiple agencies for a single client (for those clients having multiple advertising agencies working on their behalf). Further, the reports can audit agency performance by DMA for advertising plans that stretch into more than one DMA. The audit reports can be particularized down to virtually any field in the content of database 1104.
Creating Audit Reports:
Step 1416 relates to the processing logic configured to generate such audit reports. The creation of the logic for generating audit reports from the database contents will be apparent to a programmer with ordinary skill in the art who follows the teachings herein with respect to the database and audit reports. The generation of audit reports is preferably initiated by the auditor through user interfaces as shown in FIGS. 20( a)-(e). However, it should be noted that the system can also be designed to generate each of the reports automatically, with the automatically generated reports being stored for subsequent retrieval. Also, the report generating logic can be implemented on either the computer 1102, a client computer that has access to the computer 1102, or some other computing device in communication with computer 1102.
FIG. 20( a) illustrates a preferred user interface 2000 for generating market analysis audit reports. Through selection of the “market analysis” tab 2002, the auditor is presented with fields 2012, 2014, and 2016 in which he/she is to specify the client, time period (preferably quarter, although other time durations may be used), and advertising agency for the audit. Further, the interface 2000 may preferably include field(s) (not shown) for specifying the applicable DMA and/or demographic group for the report. Preferably, each field can be populated through drop down menus that are pre-loaded with the clients, time durations, and agencies already present in the database. Further, as any fields are filled, it is preferred that the range of choices in the drop down menus be further limited based on the previous selection(s). For example, if Client A is selected in field 2012, then it is preferred that the drop down menu for the agency field 2016 be limited to agencies already associated with Client A in the database. Further still, it is preferred that if the auditor selects a report for which certain conditional qualifiers are not needed (e.g. with the Multi AOR DMA Delivery reports corresponding to options 2008 and 2010, the auditor need not specify an agency in field 2016), then the conditional fields of interface 2000 be restricted accordingly.
Further, the auditor can specify the type of market analysis audit report that is to be generated, with checkbox 2004 corresponding to a “Market Analysis (Intl)” report, checkbox 2006 corresponding to a “Market Analysis (DMA Delivery Recap) (Intl)” report, checkbox 2008 corresponding to a “Market Analysis (Multi AOR DMA Delivery—pcnt) (Intl)” report, and checkbox 2010 corresponding to a “Market Analysis (Multi AOR DMA Delivery—TRP (Intl)” report. Selection of the “generate report” button 2018 by the auditor causes the selected market analysis report for the selected client/quarter/agency to be generated.
FIG. 21( a) illustrates an exemplary market analysis report 2100 that corresponds to box 2004 of FIG. 20( a). The report identifies the client, advertising agency, DMA, target demographic, and time duration in fields 2102, 2104, 2106, 2108, and 2110 respectively to which the report is pertinent. This data corresponds to the selections made by the auditor through the user interface 2000.
The report preferably includes a daypart analysis for the advertising plan and plan execution that indicates whether the advertising agency satisfied the exposure goals for the plan. Each row 2112 a through 2112 o corresponds to a different daypart. Column 2114 includes the TRP values for each daypart from the plan data stored in the database, as described above in connection with FIG. 12. Column 2116 includes the TRP values for each daypart from the original buy data stored in the database, as also described above in connection with FIG. 12. Further, column 2118 includes the TRP values for each daypart from the final buy data. These TRP values are taken from entries in the received final buy files for the specified conditions 2102-2110, as converted and recoded by step 1402 of FIG. 14. As previously noted, the TRP values of column 2118 correspond to the agency's estimations of the amount of exposure expected for an advertisement. Further still, column 2120 includes the posted TRP values for each daypart obtained from an independent source including TRP value overrides (if any) provided by the auditor. The TRP values of column 2120 correspond to the actual TRP values assigned to the actual advertisements by an independent source.
With this base of TRP data, the report preferably also displays a plurality of indicators that identify how the agency's performance in executing the plan compares with the plan. Further, the report preferably displays an indicator of how closely the posted buy data matches with the final buy data.
Column 2122 preferably displays, for each daypart, an index comparing the amount of TRPs in the original buy with the amount of TRPs in the plan. This index is preferably displayed as a percentage and can be computed as 100 times the number of TRPs for that daypart in the original buy divided by the number of TRPs for that daypart in the plan.
Column 2124 preferably displays, for each daypart, an index comparing the amount of TRPs in the final buy with the amount of TRPs in the plan. This index is preferably displayed as a percentage and can be computed as 100 times the number of TRPs for that daypart in the final buy divided by the number of TRPs for that daypart in the plan.
Column 2126 preferably displays, for each daypart, an index comparing the amount of TRPs in the posted buy (the actual buy plus the third party exposure data, as possibly adjusted through an override) with the amount of TRPs in the plan. This index is preferably displayed as a percentage and can be computed as 100 times the number of TRPs for that daypart in the posted buy divided by the number of TRPs for that daypart in the plan.
Lastly, column 2128 preferably displays, for each daypart, an index comparing the amount of TRPs in the posted buy with the amount of TRPs in the final buy. This index is preferably displayed as a percentage and can be computed as 100 times the number of TRPs for that daypart in the posted buy divided by the number of TRPs for that daypart in the final buy.
2130 preferably includes the sum for each daypart TRP value of columns 2114, 2116, 2118, and 2120. Further, the total index values for columns 2122, 2124, 2126, and 2128 are preferably calculated from these summed values.
The audit report 2100 further preferably includes a stewardship analysis section 2132 that breaks down the financial data for the various buys by media property in the applicable DMA. Each row 2134 a through 2134 f corresponds to a different media property (identified by columns 2136 (call letters) and 2138 (network affiliation)) in the applicable DMA. The media property-specific original buy data in column 2142, affidavit data in column 2146, and remittance data in column 2150 is readily available in the database as described above in connection with FIG. 13. The media property-specific final buy data and posted data is readily available in the database as described above in connection with FIG. 14.
Further, it is preferred that the stewardship analysis section be displayed in terms of dollars. The dollar value for the total plan cost is available in the database as taught in connection with FIG. 12 (see field 1234 of FIG. 12). The dollar values for the original buys in column 2142, for the affidavit amounts in column 2146, and for the remitted amounts in column 2150 are available in the database as taught in connection with FIG. 13. The dollar values for the final buy column 2144 and posted buy column 2146 are preferably computed using the cumulative cost values in the final buy data and the posted buy data under the applicable client/agency/media property/DMA/time duration/demographic conditions.
Further, row 2154 preferably displays a percentage relating the total values for the original buy cost, the final buy cost, the affidavit cost, and the posted buy cost to the plan cost. Thereafter, row 2156 preferably displays the cost per TRP for each of the plan cost, the original buy cost, the final buy cost, and the posted buy cost. This value is preferably computed as 100 times the total cost in row 2154 divided by the total TRPs in row 2132 for the applicable category. Further still, it is preferred that row 2158 display a percentage that relates the cost per TRP for the original buy, the final buy, the posted buy to the cost per TRP for the plan. This value is computed as 100 times the appropriate cost per TRP in columns 2142, 2144, and 2148 divided by the planned cost per TRP.
FIG. 21( b) illustrates an exemplary market analysis report 2160 that corresponds to box 2006 of FIG. 20( a). The report identifies the client, advertising agency, target demographic, and time duration in fields 2164, 2166, 2168, and 2170 respectively to which the report is pertinent. This data corresponds to the selections made by the auditor through the user interface 2000. Report 2160 details the agency's performance per DMA. Each row 2162 corresponds to a DMA associated with the plan data for the specified conditions. Columns 2172, 2174, 2176, and 2178 identify the total number of TRPs for that row's DMA, respectively, in the plan, the original buy, the final buy, and the posted buy. These total values can be obtained as described above in connection with row 2130 of FIG. 21( a).
Column 2180 preferably displays, for each DMA, an index comparing the amount of TRPs in the original buy with the amount of TRPs in the plan. This index is preferably displayed as a percentage and can be computed as 100 times the number of TRPs for that DMA in the original buy divided by the number of TRPs for that DMA in the plan.
Column 2182 preferably displays, for each DMA, an index comparing the amount of TRPs in the final buy with the amount of TRPs in the plan. This index is preferably displayed as a percentage and can be computed as 100 times the number of TRPs for that DMA in the final buy divided by the number of TRPs for that DMA in the plan.
Column 2184 preferably displays, for each DMA, an index comparing the amount of TRPs in the posted buy with the amount of TRPs in the plan. This index is preferably displayed as a percentage and can be computed as 100 times the number of TRPs for that DMA in the posted buy divided by the number of TRPs for that DMA in the plan.
Lastly, column 2186 preferably displays, for each DMA, an index comparing the amount of TRPs in the posted buy with the amount of TRPs in the final buy. This index is preferably displayed as a percentage and can be computed as 100 times the number of TRPs for that DMA in the posted buy divided by the number of TRPs for that DMA in the final buy.
FIG. 21( c) illustrates an exemplary market analysis report 2190 that corresponds to box 2008 of FIG. 20( a). This report identifies various performance indices in percentage terms for multiple advertising agencies on behalf of a single client in multiple DMAs. The client for which the report 2190 was specified via field 2012 in FIG. 20( a) is identified in field 2191. The demographic group to which the report is applicable is preferably identified in field 2192.
The time period for which the report was specified via field 2014 of FIG. 20( a) is identified in field 2193. Each row of the report identifies index data for a different DMA/agency pair. The DMA is identified in column 2194 and the advertising agency is identified in column 2195. Columns 2196, 2197, and 2198 identify, for the DMA/agency pairs of columns 2194 and 2195, the percentage measure, relative to the planned number of TRPs, of the original buy TRPs, final buy TRPs, and posted buy TRPs, respectively. Column 2199 identifies the percentage measure of the TRPs in the posted buy versus the TRPs in the final buy for the DMA/agency pairs of columns 2194 and 2195. The data in these columns can be calculated as discussed in connection with the like columns in the report of FIG. 21( a).
FIG. 21( d) illustrates an exemplary market analysis report 2101 that corresponds to box 2010 of FIG. 20( a). This report identifies various performance indices in total TRP terms for multiple advertising agencies on behalf of a single client in multiple DMAs. The client for which the report 2101 was specified via field 2012 in FIG. 20( a) is identified in field 2103. The demographic group to which the report is applicable is preferably identified in field 2105. The time period for which the report was specified via field 2014 of FIG. 20( a) is identified in field 2107. Each row of the report identifies total TRP data for a different DMA/agency pair. The DMA is identified in column 2109 and the advertising agency is identified in column 2111. Columns 2113, 2115, 2117, and 2119 identify the total TRPs in the plan, original buy, final buy, and posted buy, respectively, for the DMA/agency pairs of columns 2109 and 2111.
FIG. 20( b) illustrates a preferred user interface 2020 for generating average ratings audit reports. Through selection of folder tab 2022, the auditor can control the creation of average ratings audit reports. Control conditions for the audit report are set through fields 2026 (for client), and 2028 (for time duration). Preferably, field 2030 (for advertising agency) is left unused because the report produced from interface 2020 is preferably agency independent. As with interface 2000 of FIG. 20( a), interface 2020 may also include field(s) (not shown) for specifying a DMA and/or a demographic group to which the report will be applicable. Checkbox 2024 corresponds to a selection of a “Daypart Average Ratings Analysis” audit report. The user can create such an audit report by selecting the “generate report” button 2032.
FIG. 22 illustrates an exemplary “Daypart Average Ratings Analysis” audit report 2200. The report preferably identifies the parameters for client, DMA, demographic, and time duration in fields 2202, 2204, 2206, and 2208, respectively. Table 2210 includes TRP data broken down by daypart (column 2218 a through column 2218 h) for the final buy TRP estimates, the posted TRP values received from a first independent source, and TRP values received from a second independent source. The second independent source TRP data is preferably NSI average rating data, which is well-known in the art. Each entry in row 2212 corresponds to an average estimated TRP value for the final buy entries per daypart. Each entry in row 2214 corresponds to the average posted ratings from the independent source for the actual advertisements in the posted buy data per daypart. Each entry in row 2216 corresponds to the NSI average rating value per daypart. From this data, the indexes of rows 2220 and 2222 are computed. Row 2220 displays, per daypart, a percentage relating the final ratings estimates of row 2212 to the NSI average ratings of column 2216 (for each daypart, 100 times the final ratings estimate divided by the NSI average rating). Row 2222 displays, per daypart, a percentage relating the posted ratings of row 2214 to the NSI average ratings of column 2216 (for each daypart, 100 times the posted ratings estimate divided by the NSI average rating). This audit report provides an accuracy measure for the agency's exposure estimates and further provides an accuracy measure for the independent exposure data used to analyze the posted buy data.
FIG. 20( c) illustrates a preferred user interface 2040 for generating audit reports detailing the cost per TRP. Through selection of folder tab 2042, the auditor can control the creation of these audit reports. Control conditions for the audit report are set through fields 2044 (for client), 2046 (for time duration), field 2048 (for advertising agency), and field 2050 (for average/low/high (ALH) cost per TRP levels within the SQAD data). Also, it should be noted that the interface 2040 may also include field(s) (not shown) for specifying a DMA and/or demographic group to which the report will be applicable. Checkbox 2052 corresponds to a selection of a “Daypart CPP Analysis” audit report, wherein CPP stands for cost per point (or cost per TRP). Checkbox 2054 corresponds to a selection of a “Daypart CPP Analysis (DMA Recap)” audit report. Checkbox 2056 corresponds to a selection of a “Daypart CPP Analysis (Multi AOR DMA Recap)” audit report. Lastly, checkbox 2058 corresponds to a selection of a “Daypart CPP Analysis International” audit report. The user can create the selected ones of these audit reports by selecting the “generate report” button 2059.
FIG. 23( a) illustrates an exemplary “Daypart CPP Analysis” audit report 2300. The control conditions for the report are displayed in field 2302 (which identifies the client), in field 2304 (which identifies the applicable DMA), in field 2306 (which identifies the applicable demographic), in field 2308 (which identifies the applicable time duration), and in field 2310 (which identifies the agency being audited). Further, field 2312 identifies the length of the actual advertisements that are the subject of the report, and field 2314 identifies the factor for the length, wherein the factor is a weighting scalar for the length that relates the length of an advertisement to its cost. Typically, a 15 second advertisement will have a factor of 0.7 for a 30 second length advertisement, and a 10 second advertisement will have a factor of 0.5 for a 30 second length advertisement. If the report 2300 is to include this length and factor data, it is preferred that interface 2040 of FIG. 20( c) include fields (not shown) through which the auditor can specify the length and factor.
Table 2315 includes rows corresponding to a cost for a TRP per daypart. Rows 2316 and 2318 correspond to the cost for a TRP in the final buy data per daypart and the cost for a TRP in the posted buy data per daypart, respectively, under the applicable client/agency/DMA conditions. The costs for a TRP in the final buy per daypart are computed by dividing the cumulative final buy costs for all of the final buy spots in a particular daypart by the cumulative TRPs for all of the final buy spots in that particular daypart. The costs for a TRP in the posted buy per daypart are computed by dividing the cumulative posted buy costs for all of the actual advertisements in a particular daypart by the cumulative TRPs for all of the actual advertisements in that particular daypart.
Row 2320 identifies the SQAD cost for a TRP per daypart. This SQAD data is known in the art and represents a commercially accepted average industry cost for a TRP point under the stated conditions of daypart, DMA, demographic, length, factor, and time duration. The entries in row 2324 provide an index relating the final buy cost per TRP for each daypart to the corresponding SQAD value. Lastly, the entries in row 2326 provide an index relating the posted buy cost per TRP for each daypart to the corresponding SQAD value. Thus, FIG. 23( a) provides an indication of whether the advertising agency has purchased media in an efficient manner relative to a relevant industry benchmark (such as SQAD).
The “Daypart CPP Analysis International” audit report (not shown) that corresponds to box 2058 of FIG. 20( c) is an international version of audit report 2300 of FIG. 23( a), albeit with some country-specific language changes. For example, if the Daypart CPP Analysis International report is for Canadian markets, the term TRP would be expressed as TVR, the term DMA would be expressed as EMA, and the term CPP would be expressed as CPR. Other than these nomenclature changes, the content of the report and its mode of generation remains the same.
FIG. 23( b) illustrates an exemplary “Daypart CPP Analysis (DMA Recap)” audit report 2330. Fields 2332 through 2342 correspond to the like fields in FIG. 23( a). Each row 2344 a and 2344 b corresponds to a different DMA that is the subject of the report. Column 2346 provides an index to the average/low/high SQAD value for each DMA, as specified in the ALH field 2050 of FIG. 20( c). Columns 2348 a through 2348 h provide percentages for each DMA by daypart that are indicative of the cost for one posted buy TRP versus the SQAD value for such a TRP. The values in rows 2344 a and 2344 b are computed in the same manner as those values in row 2326 of FIG. 23( a) for the applicable DMAs. The values in row 2350 are computed as the average of the percentages for each DMA in columns 2348 a through 2348 h, wherein inactive dayparts (dayparts for which no spots were purchased or ran) are not factored into the average.
FIG. 23( c) illustrates an exemplary “Multi AOR DMA Recap” audit report 2360 corresponding to box 2056 of FIG. 20( c). This audit report 2360 preferably displays the same content as that of audit report 2330 of FIG. 23( b), albeit for a plurality of different agencies 2362 a, 2362 b, . . . employed by the client.
FIG. 20( d) illustrates a preferred user interface 2060 for generating audit reports detailing under delivery (UD). Through selection of folder tab 2061, the auditor can control the creation of these audit reports. Control conditions for the audit report are set through fields 2062 (for client), 2063 (for start time), field 2064 (for end time), and field 2065 (for advertising agency). It should be noted that interface 2060 may also include field(s) (not shown) for specifying a demographic group and/or DMA applicable to the report. Because UD reports are most useful when they track multiple quarters (so the restitution owed for UD from a prior quarter can be tracked), it is preferred that multiple quarters be specified in the start and end time fields. However, if a single quarter's UD report is desired, a user can generate such a report by specifying the same time as the start time and the end time. Checkbox 2066 corresponds to a selection of a “Detailed UD Report (Intl)” audit report. Checkbox 2067 corresponds to a selection of a “Multi DMA UD Report” audit report. Checkbox 2068 corresponds to a selection of a “Multi AOR UD Report” audit report. Lastly, checkbox 2069 corresponds to a selection of a “Multi DMA AOR UD Report” audit report. The user can create the selected ones of these audit reports by selecting the “generate report” button 2070.
FIG. 24( a) illustrates an exemplary “Detailed UD Report” audit report 2400 corresponding to box 2066 of FIG. 20( d). An under delivery (UD) situation occurs when a media property fails to deliver in a given time period (preferably a quarter), through TRPs in the posted buy, at least a minimum threshold of the TRPs requested in the final buy. This minimum threshold is preferably 90%. The applicable control conditions for report 2400 are specified in fields 2402, 2404, 2406, and 2408, which identify client, demographic group, time duration, and advertising agency, respectively. Field 2410 identifies the date on which report 2400 was generated. Field 2412 identifies the DMA for which the report is pertinent. Row 2430 identifies the summed UD data for the media properties in DMA 2412. Each row 2414 a, 2414 b, . . . corresponds to a different media property within DMA 2412. Column 2416 identifies the total number of estimated TRPs for a media property in the final buy data. Column 2418 identifies the total number of posted TRPs for a media property in the posted buy data. Column 2420 is an index measure that identifies the posted-to-final percentage (100 times the column 2418 value divided by the column 2416 value). Column 2422 identifies the number of TRPs owed by a station, as determined per quarter, for under delivery. This value may be calculated on a media property specific basis for each quarter as: TRPs owed (by a media property) equals 0.9 multiplied by the number of TRPs in the final buy with that media property minus the number of TRPs in the posted buy with that media property. Thus, for a multi-quarter report such as report 2400, the TRPs owed by each media property would be the sum of TRPs owed for each quarter (quarters 1Q04 through 4Q04 in the example of FIG. 24( a)).
Column 2424 identifies the number of restitution TRPs that were posted for the applicable media property during the specified time period 2406 to make good on previously-owed UD TRPs. It is preferred that actual advertisements that ran as UD restitution be flagged accordingly in the actual buy data, thereby rendering their detection in the database much easier. Column 2426 identifies a revised index that takes into consideration the restitution TRPs of column 2424 (revised index=100*(column 2424 value+column 2418 value)/column 2416 value). Column 2428 identifies the balance of UD TRPs, which is preferably calculated, per quarter, as the difference between TRPs owed and restitution TRPs. Thus, for a multi-quarter report such as report 2400, the balances reflected in column 2428 reflects the sum of these quarterly differences between the TRPs owed and restitution TRPs.
Lastly, table 2432 identifies the UD data in monetary terms for all media properties in the DMA 2412. The monetary amount for value owed 2434 can be computed as the sum of TRPs owed (column 2422, row 2430) multiplied by the agency-purchased cost per TRP ascertained from the posted buy data. Value received 2436 can be computed as the sum of restitution TRPs (column 2424, row 2430) multiplied by the agency-purchased cost per TRP. Balance 2438 can be computed as the sum of balances in column 2428 multiplied by the agency-purchased cost per TRP ascertained from the posted buy data.
FIG. 24( b) illustrates an exemplary “Multi DMA UD Report” audit report 2440 corresponding to box 2067 of FIG. 20( d). This report provides UD data for multiple DMAs 2442 a, 2442 b, . . . under control conditions 2444. Column 2446 identifies the gross dollar amount spent in the posted buy data for the DMA. Columns 2448, 2450, 2452, 2454, 2456, and 2458 correspond to columns 2416, 2418, 2420, 2422, 2424, and 2426 respectively of FIG. 24( a), but for an entire DMA (row 2430 of FIG. 24( a)).
FIG. 24( c) illustrates an exemplary “Multi AOR UD Report” audit report 2460 corresponding to box 2068 of FIG. 20( d). This report provides UD data for multiple agencies. The control conditions for the report are identified in field 2462 (client-specific and time duration-specific). Each row 2464 a, 2464 b, . . . corresponds to a different agency employed by the client. The data in the columns corresponds to the number of DMAs in which the agency placed buys, the posted delivery index, TRPs owed, restitution TRPs owed, value owed, value received, and balance for each agency. These values may be computed as would be understood by a person of ordinary skill in the art in view of FIGS. 24( a) and (b) and the descriptions thereof.
FIG. 24( d) illustrates an exemplary “Multi DMA/AOR UD Report” audit report 2480 corresponding to box 2069 of FIG. 20( d). This report displays the content of UD report 2440 of FIG. 24( b), but for multiple agencies 2482, 2482 b, . . .
FIG. 20( e) illustrates a preferred user interface 2075 for generating various miscellaneous audit reports. Through selection of folder tab 2076, the auditor can control the creation of these audit reports. Through fields 2077, 2078, and 2079, the auditor can specify, respectively, the client, quarter, and advertising agency on which the audit report will be based.
Checkbox 2080 corresponds to an audit report that identifies whether any of the advertisement postings in the posted buy data aired during a program for which the client has requested no advertising. In some circumstances, a client will communicate to an agency that it does not want its advertisements to run during certain programs. If the posted buy data indicates that an actual advertisement did in fact run during such a prohibited program, then the preferred embodiment of the parent invention preferably detects such an occurrence. Preferably, a user interface is provided to the auditor so that such program restrictions can be entered in the database with the other plan data. FIG. 25( a) depicts a preferred Restricted Programming Report 2500. Report 2500 details the restricted program(s) in column 2502 and the DMA therefor in column 2504, and further provides data about the unauthorized advertisement, this data preferably including its invoiced cost and TRPs achieved.
Checkbox 2081 corresponds to an audit report that identifies unspecified dollars spent with each media property in the final buy data and or the posted buy data. As shown in FIG. 25(b), this audit report 2510 provides advertisement spot level detail per media property of those spots invoiced by the media property that do not match any spots that were placed by the agency with that media property, as reflected in the final buy data.
Checkbox 2082 corresponds to an audit report that identifies bonus advertisements by daypart, that is actual advertisements for which no charge was made by the media property. As shown in FIG. 25( c), such a report 2520 preferably identifies, per DMA, the dayparts in which the bonus spots ran, the posted ratings for the bonus spots in the dayparts, and the number of bonus spots that ran in each daypart.
Checkbox 2083 corresponds to an audit report that identifies daypart audience delivery/TRPs, which helps clients understand when and where they are receiving billboards. As shown in FIG. 25( d), this audit report 2530 preferably identifies, per DMA, the dayparts in which the billboards ran, the posted ratings therefor, and the number of billboard spots per daypart. It is preferred that the daypart codes assigned to the actual advertisements include a code for billboards (such as “BB” code).
Checkbox 2084 corresponds to an audit report that identifies market analysis data for a user-specified ISCI code. As shown in FIG. 25( e), report 2540 preferably identifies, per DMA, how many spots ran for each ISCI code, and the percentage total that each ISCI code took up among all the spots that ran in that DMA.
Checkbox 2085 corresponds to an audit report that identifies DMA data for a user-specified ISCI code. As shown in FIG. 25( f), this report 2550 preferably provides the details of report 2540 of FIG. 25( e) on a DMA level rather than on a per media property level.
Checkbox 2087 corresponds to an audit report that identifies whether any of the TRP estimates for the advertisement requests in the final buy data fall below a minimum threshold value. Some clients will request that no advertisements be requested for a time slot expected to generate a TRP below a minimum threshold level. Preferably, if such a situation exists, the user interface for entering plan data includes a field for entering the minimum threshold value for the final buy data. As shown in FIG. 25( g), this report 2560 preferably identifies, per DMA, pertinent data about these spots. The violation cost preferably identifies the cost for the actual advertisement that should not have been purchased pursuant to the minimum ratings threshold. The daypart cost column identifies the total costs for the actual advertisements placed by the agency in a DMA for each daypart. The index corresponding thereto is a percentage measure of the violation cost to the daypart cost, which thereby indicates how much of a daypart's cost was taken up with advertising that should not have been purchased. The remaining columns of this audit report 2360 preferably display this data in TRP terms.
Checkbox 2088 corresponds to an audit report that identifies whether any of the TRPs posted for the actual advertisements in the posted buy data fall below a minimum threshold value. This audit report (not shown) is similar in type to that of FIG. 25( g), but uses the posted buy data for analysis. As mentioned above in connection with the final buy, some clients will request that no advertisements be aired during a time slot that will generate a TRP below a minimum threshold level. Preferably, if such a situation exists, the user interface for entering plan data includes a field for entering the minimum threshold value for the posted buy data.
Checkbox 2089 corresponds to an audit report that identifies whether an appropriate degree of spacing (separation) between advertisements for the plan was achieved. Some clients desire that there be some minimum level of spacing between the client's advertisements. The posted buy data includes air time data that allows a separation determination to be made. Preferably, if such a minimum separation rule exists, the user interface for entering plan data includes a field for entering the parameters of the separation rule. As shown in FIG. 25( h), this report 2570 preferably identifies a separation rule 2572, such as a rule that the time separation between successive actual advertisements in a DMA be 20 minutes. The remainder of the report 2570 preferably identifies, per DMA, the successive actual advertisements 2574 and 2576, pertinent details therefor (such as the run time), and the actual separation 2578 between the spots. The detail of report 2570 is preferably limited to successive spots that violate the rule.
It is also worth noting that the audit reports generated by the preferred embodiment may also include summary paragraphs that describe salient aspects of the audit. For example, the report may include descriptive paragraphs that communicate to the client the amount of UD restitution owed to them, or the report may include descriptive paragraphs that communicate to the client the posted buy-to-plan index of total TRP values, or the report may include descriptive paragraphs that communicate to the client how the agency's cost per TRP measured against industry averages. A sample preferred audit report for TV/radio is included herein as FIGS. 26-68 (see also Appendix A of the incorporated parent '466 patent application).
While the parent invention has been described above in relation to its preferred embodiment, various modifications may be made thereto that still fall within the invention's scope, as would be recognized by those of ordinary skill in the art. For example, the techniques of the preferred embodiment can also be applied to advertising in print media. Corollaries to the original buy and the final buy for TV/radio ads are the original insertion orders and the revised insertion orders for print ads. Print advertising plans typically specify cost, circulation, and positioning. Exposure data for print media is typically measured in terms of circulation, and a suitable third party source for such circulation data is the Audit Bureau of Circulation (ABC), as is known in the art. A sample preferred audit report for print media is included herein as FIGS. 69-278 (see also Appendix B of the incorporated parent '466 patent application). Such modifications to the invention will be recognizable upon review of the teachings herein. Accordingly, the full scope of the parent invention is to be defined solely by the appended claims and their legal equivalents.

Present U.S. patent application Ser. No. 11/253,040

FIG. 1 depicts an overview of the preferred embodiment of the present invention. The system 100 comprises at least one media property 102, at least one advertising agency 104, an accounts payable (NP) computer system 108, and an invoice reconciliation system 110.
A computer system operated by the media property 102 preferably sends invoice data to the invoice reconciliation system 110. This invoice data corresponds to an invoice for advertisement spots that were run by that media property 102 for an advertising agency 104 on behalf of its client. These invoices are typically sent 15-20 days after the end of the standard broadcast month. However, with the present invention, this need not be the case, as invoices can just as easily be sent on a weekly, daily, bimonthly or other basis. This invoice data is preferably communicated by the media property 102 to the invoice reconciliation system 110 electronically over a network such as the Internet. Preferred transmission techniques include e-mail, publication on an electronic bulletin board, and file uploads over a network, such as http uploading over the Internet. However, any known form of communication can be used to communicate the invoice data to the invoice reconciliation system 110, including leased data lines and paper copy mailings from the media property 102 to an operator of the invoice reconciliation system 110. However, the transmission of invoice data to the operator of the invoice reconciliation system 110 in the form of paper copies is not preferred (at least in connection with the practice of the preferred embodiment of the present invention) as it requires intervention by data entry personnel to get the invoice data into a database.
A computer system operated by the advertising agency 104 preferably sends raw final buy data to the invoice reconciliation system 110. This raw final buy data corresponds to final requests placed by the agency 104 on behalf of its client for advertisement spots to be run by a media property 102. This raw final buy data is preferably communicated by the media property 102 to the invoice reconciliation system 110 electronically over a network such as the Internet. However, any known form of communication can be used to communicate the raw final buy data to the invoice reconciliation system 110, including leased data lines and paper copy mailings from the advertising agency 102 to an operator of the invoice reconciliation system 110. However, the transmission of raw final buy data to the operator of the invoice reconciliation system 110 in the form of paper copies is not preferred as it requires intervention by data entry personnel to get the invoice data into a database. It is believed that through various negotiations between agencies, agency clients, and operator(s) of the invoice reconciliation system, advertising agencies can be persuaded to utilize electronic transmission of the raw final buy data to the invoice reconciliation system. Preferred transmission techniques include e-mail, publication on an electronic bulletin board, and file uploads over a network, such as http uploading over the Internet.
The agency 104 typically prebills the client for the original buy, with billing adjustments being issued to the client as changes occur with the original buy. As such, the resultant pre-billing to the client typically approximates final buy billing. Thus, before the agency has been invoiced for the ad spots requested in the final buy, the client has paid the agency 104 some amount of funds that are to be applied toward invoices from media properties. The agency 104 typically deposits this payment amount in an account, wherein appropriate amounts of the deposited funds are later transferred from the account to the appropriate media property after reconciling an invoice from that media property. This account is typically an interest bearing account with the advertising agency 104 as the account holder, and the agency 104 typically collects the interest that accrues to the funds placed in the account. As such, the longer time that it takes the agency to reconcile media property invoices, the more interest money that the agency takes in.
The inventors herein believe that media properties and advertisers (clients) are desirous of significantly reducing the account receivable time period because prompter payment on invoices will allow the media properties to take advantage of the “time value of money”. Accordingly, the inventors herein further believe that strong market potential exists in the advertising industry for a system by which media property invoices can be more promptly reconciled. In turn, media properties can be expected to provide discounts to advertisers in exchange for prompt payment on invoices (e.g., a 2% discount for paying an invoice within 10 days). Toward this end, the invoice reconciliation system 110 is provided.
The primary task of the invoice reconciliation system is to reconcile invoices from media properties with final buys from advertising agencies to ensure that agencies (and their clients) are being properly billed for what they purchased. This reconciliation can be done in an automated fashion by computer software wherein matches between invoices and final buys (preferably on a per ad spot basis) are identified automatically. Invoice items that cannot be matched to a corresponding final buy item are preferably referred to an exception handling process within the invoice reconciliation system 110, wherein GUIs are preferably provided to seek human intervention to resolve invoice-to-final buy inconsistencies.
After reconciling the invoice data with the final buy data, the invoice reconciliation system 110 can preferably provide payment authorization instructions regarding reconciled invoices to the NP system 108 that enable the transfer of an amount of funds to the media property 102 that is consistent with invoiced items that were satisfactorily reconciled (via either the automatic matching process or the exception handling process) with the final buy items. These instructions are preferably provided directly to an automated financial system 108 that controls the account such that funds can be transferred electronically from the account to the media property 102.
FIG. 2 provides a block diagram overview of a preferred invoice reconciliation system 110, which preferably comprises a computer 200 and a database 202 in communication with the computer 200.
The computer 200 is preferably a commercially-available Dell Poweredge 2650 or a device of similar processing capabilities, and the database 202 is preferably a commercially-available Microsoft MS SQL 2000 or a newer version thereof. It should be understood that the computer 200 and database 202 can be implemented with other hardware, including an implementation as a personal computer, workstation, or server that can be accessed over a network such as the Internet. As will be explained in greater detail below, the database 202 serves as a repository for the data used in the invoice reconciliation process. The computer 200 preferably provides the programming logic, or code segments executable by a processor, for (1) converting the received raw final buy data into a common format for storage in the database 202 (conversion and storage software 204), (2) performing the invoice reconciliation, including the communication of payment instructions (reconciliation software 206), and (3) displaying and controlling a plurality of GUIs that are configured to interact with a user to manage the invoice reconciliation and payment process and, if necessary, provide data entry functionality (user interface software 208). This programming logic can reside on memory that is accessible to computer 200 or on a device such as a compact disc (CD) or the like to be accessed by computer 200 from a disk drive or the like.
Preferred tasks for the GUIs are to provide the user with the ability to perform exception handling tasks that arise during the invoice reconciliation process and to control the payment process. To operate the invoice reconciliation system, these GUIs can preferably be accessed by a user from a remote computer in communication with computer 200 over a network such as the Internet. However, this need not be the case. The users for system 110 can include employees of the client, advertising agency, or media property, or hired outside parties, as explained below in connection with FIGS. 8( a)-10(b). Conventional security techniques are preferably implemented on computer 200 to prevent users from gaining access to unauthorized data. For example, client users will preferably only be able to access their own final buy and invoice data, advertising agency users will preferably only be able to access final buy data and invoice data relating to advertising spots they have placed, and media property users will preferably only be able to access their own invoice data and the final buy data related to their invoices. Outside party users' access to data will be limited in accordance with the authority of the party (client, advertising agency or media property) that hired them.
Creating the Database of Converted Invoice and Final Buy Data:
One aspect of the preferred embodiment relates to storing invoice data and final buy data in the database 202. Preferably, the final buy data is stored in a common format to facilitate the reconciliation process of matching final buy items with invoice items. It is expected that the raw final buy data received from different advertising agencies will possess varying formats. In such cases, it is preferred that, prior to being stored in database 202, this raw final buy data be converted to a common format. However, as a less preferred alternative, the raw final buy data can be stored in the database 202 in its raw format, and the conversion can occur at the time of the matching process upon retrieval from the database. Another less preferred alternative is for the reconciliation logic to take on the burden of accounting for the different expected raw final buy data formats, with no final buy data conversion taking place. Further still, it is worth noting that the conversion step may be rendered unnecessary if the data formats for the media property's invoice data and advertising agency's raw final buy data are both the same or if the raw final buy formats for the different agencies are all the same. Such situations can conceivably exist if the media properties and advertising agencies use software on their respective computer systems that is configured to output the invoice data and final buy data in formats that allow for an apples to apples comparison without the need of a conversion step. However, at the current time, the inventors believe that it is highly likely that a conversion step will be needed to ensure a wide scope of potential use for the preferred embodiment of the present invention. The invoice data will preferably arrive in an XML format, from which the pertinent data can be readily extracted and stored in database 202 (step 308 of FIG. 3).
As mentioned above, the raw final buy data can be expected to arrive in a variety of different formats depending upon the platform used by each advertising agency. The conversion of raw final buy data to a common format preferably utilizes the techniques disclosed in pending U.S. patent application Ser. No. 10/810,466, filed Mar. 26, 2004 described above and entitled “Method and Apparatus for Auditing the Performance of Advertising Agencies on Behalf of Their Clients”, the entire disclosure of which has been incorporated herein by reference. That pending application discloses, among other things, a technique whereby final buy data and actual buy data are converted to a common format to enable an auditing process.
FIG. 3 is a flowchart overview for a preferred final buy data conversion process performed by computer 200. At step 300, the raw data relating agencies' final buys are received (preferably electronically). Each agency may store the final buy data in a different format depending upon the software packages used by the agencies. Examples of industry-used formats for the final buy data are the DDS format (300 a) for media buy software from Donovan Data Systems, Inc., the Strata format (300 b) for media buy software from Strata Marketing, Inc., the Adware (300 c) format for software from AdWare Systems, Inc., and the SmartPlus format (300 d) for software from the company Marketing Resources Plus. It should be noted that other data formats may also be used in the practice of the invention.
FIG. 4 illustrates a sample format for a raw final buy data file that would be received electronically from an advertising agency in the preferred embodiment of the present invention. The final buy data can be provided as a flat file, as a relational database structure, or other known forms for maintaining data. In the example of FIG. 4, the final buy data is presented as a flat file through table 400, with each table row corresponding to a different final buy item for an advertisement spot that was requested by the agency and each column including pertinent data for that advertisement spot.
With reference to FIG. 4, data in column 402 identifies the media in which the advertisement spot is to run. The data in column 404 identifies the client. The data in column 406 provides an identifier for the product/service that corresponds to the advertisement. The data in column 408 provides an identifier code for the estimate corresponding to the advertisement spot, and the data in column 410 provides the name of the estimate corresponding to the advertisement spot.
Further, the data in column 412 identifies the beginning and end dates for the final buy request (expressed by week). The data in column 414 identifies the DMA in which the final buy was requested, the data in column 416 identifies the media property with which the final buy request was placed, and the data in column 418 identifies a buy line code for the media property. The buy line code serves as a reference to the advertising agency buy line, as is known in the art.
Further still, the data in column 420 identifies the program during which the advertisement spot is to run, the data in column 422 identifies the daypart code for the time during which the advertisement spot is to air, the data in column 424 specifies the length (in seconds) for the advertisement spot, the data in column 426 specifies the scheduling rotation by day for the program, and the data in column 428 identifies the air time for the program. Moreover, the data in column 430 identifies the cost for the advertisement spot, and the data in column 432 identifies an estimation by the agency of the amount of exposure for the advertisement spot (in terms of a total number of TRPs that the agency thinks the advertisement spot will achieve if it runs during a commercial break for the program). Columns 434, 436, and 438 each correspond to a particular week during the time period identified in column 412. The data in each of these columns identifies the number of advertisement spots requested for that program during the specified week. Lastly, the data in column 440 includes any comments that an agency may wish to include for the advertisement spot. For example, the agency may want to note as a comment that the spot was aired to make good on an earlier missed spot, that a spot's tardy airing was due to a sports program running long, or that a spot's airing was pre-empted by news war coverage.
It should be noted that the final buy data format of FIG. 4 is exemplary only. Different advertising agencies will often use different formats. As a result of this diversity, the final buy data received by a practitioner of the present invention is expected to have a wide variety of formatting differences. For example, two agencies may use the same fields for their data, but provide those fields in a different sequential order. Also, some of the fields used by one agency may not be used by another agency (e.g., one agency provides a field for “line” data (column 418 in FIG. 4, while another agency does not). Also, two or more agencies may use different formats for the data that populates the fields (e.g., Agency A codes dates numerically as mm/dd/yy (12/31/03) while Agency B codes dates alphanumerically as month name, month date, year (Dec. 31, 2003); Agency A codes dayparts with a two letter code, Agency B codes dayparts with a three letter code, and Agency C codes dayparts with a four letter code). Further still, when the final buy data is provided as electronic files, some agencies may provide the final buy data in a relational database format, while others may supply the data in a flat file format, while yet others may supply the data in other known electronic data structures.
Moreover, any fields that are not needed to perform invoice reconciliation, may optionally be omitted from the final buy data transmitted from the agency 104, from the raw final buy data that is converted to the common format, or from the converted final buy data that is stored in database 202.
FIG. 5 illustrates a sample format for an invoice data file that would be received electronically from a media property in the preferred embodiment of the present invention. As with the final buy data, the invoice data can be provided as a flat file, as a relational database structure, or other known forms for maintaining data. In the example of FIG. 5, the invoice data is presented as a flat file through table 500, with each table row corresponding to a different invoice item for an advertisement spot that was run by a media property (an actual advertisement) and each column including pertinent data for that actual advertisement.
The data in column 502 identifies the client for whom the actual advertisement ran, and the data in column 504 identifies the advertising agency who placed that advertisement on the client's behalf. Columns 506 and 508 identify, respectively, the name of the estimate corresponding to the advertisement spot, and a code for the estimate corresponding to the advertisement spot. These fields effectively correspond to columns 410 and 408 of FIG. 4. Column 510 identifies an invoice number that is applicable to an actual advertisement. Columns 514, 516, and 518 identify, respectively, the date on which the actual advertisement ran, the time at which the actual advertisement ran (typically identified by the hour and minute that the actual advertisement began), and length for the actual advertisement. Column 520 identifies the gross cost for the actual advertisement and column 522 identifies the ad-ID or ISCI creative code for the actual advertisement, which is preferably defined by industry standards as known in the art.
It should be noted that, as with the final buy data, the invoice data format of FIG. 5 is exemplary only. It can be expected that most media properties electronic invoices will be in an XML format, in which the invoice data is tagged to facilitate the extraction of pertinent data therefrom (step 308). Also, in the event of disparities in the field formatting within invoice files from different media properties, the invoice data can also go through the conversion process of steps 300-306 of FIG. 3. Such conversion can be implemented in response to user interaction with a GUI-based export tool through which media properties submit their invoice data to the invoice reconciliation system 110. Using ordinary skill in the art, software to perform this extraction and/or format conversion can be readily created.
Because of the diversity in the received raw final buy data, the present invention preferably converts this received final buy data to a common format to greatly simplify the processing logic used to reconcile invoiced advertisements with advertisements requested in the final buy. Accordingly, the programming logic for performing the invoice reconciliation need not account for each individual raw final buy data file format, thereby enhancing the modularity of the reconciliation logic to provide for increased flexibility in the event the reconciliation logic is to be altered, or in the event that a new format for raw data is received.
A practitioner of the present invention can select the common format for the conversion step 302 of FIG. 3 as a design choice based on a personal evaluation of the facts and circumstances relating to the system. Preferably, the common format that is chosen is the XML format used by the media properties for the invoice data described in connection with FIG. 5. However, other common formats can be used. For example, the common format can also be one of the existing “raw” final buy data formats (such as Strata or DDS). However, as facts and circumstances may dictate, some practitioners of the present invention may find it more agreeable to develop their own common format. Further, the data structures for the common format may also be selected to be structures for a relational database to facilitate storage using well-known database language techniques, or it can be a flat file format for practitioners of the present invention who are less comfortable with relational databases. In the event that the common format is a format that is different than the invoice data format, then it is preferred that the conversion process described for the final buy data also be performed on the invoice data.
Once the practitioner of the present invention identifies the raw final buy data formats and common data format involved in the conversion process, a mapping table for mapping raw data values for each of the fields in the raw final buy data file records in the various exemplary file formats 300 a through 300 d into the common format can be generated using ordinary skill in the art. This mapping table can then be used in performing the conversion step 302.
The output of the conversion step 302 will be an import/export file 304 for the converted final buy data. The data in this file 304 will be in the common format. Thereafter, at step 306, this common format file 304 is imported into a database to create a database 202 of invoice data and converted final buy data. Preferably, the final buy data items are stored in the database 202 such that they are associated with appropriate identifiers for the advertising agencies that placed the final buys. Further still, the invoice items are preferably stored in the database 202 such that they are associated with appropriate identifiers for the media properties that ran the advertising spots. Database 202 can be implemented as a single database or can be implemented as several distributed databases according to the preference of a practitioner of the invention.
Reconciling Converted Invoice Data with Converted Final Buy Data:
From the data stored in database 202, media property invoices can be accurately and efficiently reconciled to determine appropriate payment amounts and identify invoice items that are in dispute. FIG. 6 illustrates a flowchart for a preferred reconciliation process that is executed by computer 200. It is worth noting that the computer 200 that performs the reconciliation process need not be the same computer that performed the conversion process of FIG. 3.
At step 600, the user selects the media property, client, and advertising agency that will be applicable to the reconciliation process. The user may also enter an invoice number or other criteria to identify the invoice against which the reconciliation process will run. These selections are preferably made by the user via one or more GUIs. If the user is the client, the client portion of this selection is preferably pre-set to only that client (to thereby avoid a client gaining access to the advertising data of another company). If the user is the advertising agency, (1) the advertising agency portion of this selection is preferably pre-set to only that advertising agency (to thereby avoid an advertising agency gaining access to the advertising data of another advertising agency), and (2) the client portion of this selection is configured to allow the advertising agency to select only clients that it represents (to thereby avoid an advertising agency gaining access to the advertising data of non-clients). Preferably, step 600 is initiated after receipt of a media property invoice, which are typically issued in accordance with the industry standard broadcast month.
Once the media property/client/advertising agency constraints have been selected, the process preferably retrieves from database 202 the pending extracted invoice items and pending converted final buy items that to which the media property/client/advertising agency constraints are applicable (step 602). An invoice item and final buy item can be said to be “pending” if not yet reconciled. Because the final buy data will be available well before the invoice data corresponding thereto is available, it can generally be expected that the appropriate final buy data will be available for retrieval from the database when a media property invoice is received.
Next, at step 604, the process attempts to pair retrieved invoice items with retrieved final buy items to thereby identify (1) full matches between invoice items and final buy items, (2) partial matches between invoice items and final buy items, and (3) invoice items and/or final buy items that cannot be paired with a counterpart. FIG. 7 illustrates step 604 in greater detail. At step 700, the retrieved final buy items are summed. At step 702, the retrieved invoice items are summed. At step 704, these sums are compared. If the invoice items sum and final buy items sum do not match, then this indicates that either one or more extra invoice items are present or one or more extra final buy items are present (step 708). Too many invoice items indicates that one or more of the invoiced advertising spots were not purchased (a “run but not purchased” exception handling condition). Too many final buy items indicates that one or of the requested advertising spots was not run (a “purchased but not run” exception handling condition). The value of the difference between the sums represents the number of such exception handling conditions that exist (step 710). If the sums are equal, the system will determine that no “run but not purchased” or “purchased but not run” exception handling conditions exist (step 706). This does not necessarily indicate that what was purchased was run and what was run was purchased (as it may mean that an equal number of “run but not purchased” and “purchased but not run” inconsistencies exist), but the system will detect these anomalies as a mismatched pair rather than an unmatched item. It is worth noting that techniques other than steps 700-708 may be used in connection with step 604. For example, a variety of matching metrics can be used to assess the degree of a match between an invoice item and a final buy item, wherein extremely low levels of matching (or complete mismatching) can result in “run but not purchased” and/or “purchased but not run” exception handling conditions being found.
At step 712, the retrieved final buy items and the retrieved invoice items are processed to find invoice item-to-final buy item pairs that match in the following fields (1) estimate name fields 410 and 506, (2) estimate number/ code fields 408 and 508, (3) times field 428 and spot time field 516, (4) length field 424 and spot length field 518, (5) cost per spot field 430 and gross spot cost field 520, and (6) buy dates field 412 and spot date 514. Invoice items that fully match final buy items in each of these fields are preferably identified as full matches, and the process flags those items accordingly (step 714). Fully matching items represent items that have been satisfactorily reconciled such that payment is approved therefor. A running total that represents the amount of money approved for payment on an invoice is preferably maintained as full matches are identified.
For invoice items and final buy items that do not fully match, step 716 operates to identify the appropriate exception handling conditions for the mismatches. To pair partially matching invoice items with final buy items, a variety of techniques can be used. Preferably, each invoice item is paired with the final buy item that it most closely matches. If one or more “purchased but not run” exception handling conditions are found to exist at step 710, the final buy item(s) with the least similarity to any of the invoice items can be designated with the “purchased but not run” exception handling condition. If one or more “run but not purchased” exception handling conditions are found to exist at step 710, the invoice item(s) with the least similarity to any of the final buy items can be designated with the “run but not purchased” exception handling condition. Additional examples of preferred exception handling conditions include (1) a spot cost inconsistency exception for pairs whose cost fields do not match, (2) a spot length inconsistency exception for pairs whose length fields do not match, (3) a spot time inconsistency exception for pairs whose time fields cannot be correlated, and (4) a spot date inconsistency exception for pairs whose date fields cannot be correlated. For pairs that mismatch in more than one field (e.g., a pair for which a spot cost inconsistency exception and a spot length inconsistency exception exists), more than one exception handling condition may apply. Furthermore, it should be understood that more or fewer exception handling conditions can be defined if desired by a practitioner of the present invention. For example, the Ad-ID/ISCI-related fields in the final buy and invoice data can also be reconciled to determine whether the appropriate advertisement was run, presuming appropriate final buy data is available to perform such reconciliation.
Preferably, steps 712-716 incorporate a tolerance (e.g., +/−2 minutes) into the time range for the final buy item when assessing whether the spot time for the invoice data matches what was requested. This tolerance may be defined by the user via a GUI. Through this tolerance, a time match can be found even if the media property ran the advertisement in question outside of the final buy's time range, so long as the advertisement still ran sufficiently close to the time range to fall within the tolerance. It is worth noting that this tolerance need not be user-specified; it can alternately be a predetermined built-in feature of the reconciliation system.
Returning to FIG. 6, at step 606, a determination is made as to whether all of the invoice items on the subject invoice have been found to be fully matching. If the answer is yes, then that invoice is approved for payment, and at step 608, the process operates to upload payment instructions to the accounts payable (NP) computer system 108 that enable the reconciled invoice to be paid. The amount of payment that is authorized via these instructions can include any discounts that have been negotiated with the media property for prompt payment of its invoices. For example, a media property may agree to provide some form of discount (e.g., 2%) on an invoice if payment is made on that invoice within a predetermined amount of time (e.g., 48 hours). These payments instructions will preferably interface with the NP software on computer system 108 to provide the NP software with an identifier for the applicable media property, an identifier for the applicable invoice, and the net amount of payment due on the invoice. These instructions may also include an identifier or other related data for an applicable campaign corresponding to the advertisements that are the subject of the invoice. The exact details of these instructions are expected to vary as a function of what NP software package is run by computer system 108. Examples of common NP software include the various NP software packages provided by companies such as Oracle/PeopleSoft, Microsoft, and SAP.
If step 606 results in a determination that less than all of the invoice items included in the subject invoice have been successfully reconciled, then the process preferably proceeds to step 610, where exception handling for the mismatched and unmatched items identified by step 716 occurs. FIGS. 8( a)-(f) depict exemplary GUIs through which users can handle the exceptions.
FIG. 8( a) depicts a preferred GUI 1000 for handling a “spot run but not purchased” exception which occurs when an invoice item cannot be paired with a final buy item. GUI 1000 preferably includes a display section 1002 that identifies the invoice item data for such a spot. This data preferably includes an identification of the media property, client, and advertising agency to which the invoice item is applicable. Further, this data preferably includes an identification of the estimate name, estimate number, invoice number, invoice date, spot date, spot time, spot length, spot cost, and ad-Id/ISCI/creative code. From this data and from any other guidelines that may be in place for processing such exceptions (e.g., instructions from a client such as agency buying guidelines as to how to handle such an exception), the user can choose to undertake any of a plurality of options. A first option is to pay the invoice item in full and update the buy line accordingly via button 1004. Upon selection of button 1004, that final buy item-invoice item pair is marked as reconciled and the running total that represents the amount to be paid to the media property is preferably increased by the spot cost amount that is displayed in section 1002. Also, updating the buy line following selection of button 1004 preferably results in the invoiced spot being added to the agency's buy line and a billing update being sent to the client. Another option is to reject payment on the invoice and update the buy line accordingly via button 1006. In this instance, updating the buy line preferably results in the spot being subtracted from the invoice and a billing update message being sent to the media property to inform the media property of the discrepancy. This message can be communicated to the media property in a variety of ways. For example, an email could be sent to the media property. Preferably, in an embodiment wherein the users access computer 200 of system 110 via a network such as the Internet, a message for a media property is placed in a mailbox associated with that media property, the messages in this mailbox being accessible via one or more GUIs as described in connection with FIGS. 10( a) and (b). Until the media property approves the rejection, payment on all or a portion of the subject invoice (identified by the invoice number field displayed in FIG. 8( a) will preferably be put on hold. A final option is to add a comment that is to be associated with the invoice item via button 1008.
FIG. 8( b) depicts a preferred GUI 1020 for handling a “spot purchased but not run” exception which occurs when a final buy item cannot be paired with an invoice item. GUI 1020 preferably includes a display section 1022 that identifies the final buy item data for such a spot. The final buy data fields that are displayed are preferably the same as those shown in FIG. 4. This data preferably also includes an identification of the media property, client, and advertising agency to which the invoice item is applicable. From this data and from any other guidelines that may be in place for processing such exceptions (e.g., instructions from a client as to how to handle such an exception), the user can choose to undertake any of a plurality of options. A first option is to pay the invoice amount in full, request a credit for the spot cost, and update the buy line accordingly, via button 1010. Upon selection of button 1010, (1) the running total that represents the amount to be paid to the media property is preferably increased by the invoice item's spot cost amount that is displayed in section 1032, and (2) a credit from the media property in the amount of that spot cost is requested. To communicate this credit request, a corresponding message is preferably electronically sent to the media property. Preferably, until the media property approves the credit request, payment on all or a portion of the subject invoice is put on hold.
If desired by a practitioner of the present invention, separate commands can be entered by the user to approve invoice payment and thereafter request a credit, for example by the inclusion of a separate “request credit” button on the GUI or by the inclusion of a second GUI through which the user can request a credit. Also, updating the buy line following selection of button 1010 preferably results in the invoiced spot being added to the agency's buy line and a billing update being sent to the client. Additional options that the user can choose are preferably those set forth in connection with buttons 1006 and 1008 described above.
FIG. 8( c) depicts a preferred GUI 1030 for handling a “spot cost inconsistency” exception which occurs when a final buy item's “cost per spot” data does not match the “spot cost” data in its counterpart invoice item. GUI 1030 preferably includes a display section 1032 that identifies the media property, client, and advertising agency to which the spot cost inconsistency is applicable. Section 1032 preferably also lists the pertinent data fields for the applicable final buy item and applicable invoice item (preferably the fields shown in FIGS. 4 and 5). Display section 1034 preferably identifies the difference in cost between the final buy item's “cost per spot” field and the invoice item's “spot cost” field. If the invoice item's cost is greater than the final buy item's cost, then this difference in section 1034 is preferably a positive number. If the final buy item's cost is greater than the invoice item's cost, then this difference in section 1034 is preferably a negative number. In situations where the invoice item cost is greater than the final buy item cost (or vice versa), from the data in sections 1032 and 1034 and from any other guidelines that may be in place for processing such exceptions (e.g., instructions from a client as to how to handle such an exception), the user can choose to undertake any of a plurality of options. A first option is to pay the invoice amount in full, request a credit for the difference in section 1034, and update the buy line accordingly, via button 1010. A second option is to pay the final buy amount and update the buy line accordingly, via button 1038. With this option, a message is preferably electronically sent to the media property requesting that the invoiced amount for the item be adjusted to the final buy amount. Until the media property consents to the requested change, payment on all or a portion of the subject invoice is preferably put on hold. Yet other options include rejecting payment via button 1006 and adding a comment via button 1008, as set forth in connection with FIGS. 8( a) and (b).
FIG. 8( d) depicts a preferred GUI 1040 for handling a “spot length inconsistency” exception which occurs when a final buy item's “length” data does not match the “spot length” data in its counterpart invoice item. GUI 1040 preferably includes a display section 1032 that identifies the media property, client, and advertising agency to which the spot length inconsistency is applicable. Section 1032 preferably also lists the pertinent data fields for the applicable final buy item and applicable invoice item (preferably the fields shown in FIGS. 4 and 5). Display section 1042 preferably identifies the difference in cost between the final buy item's “length” field and the invoice item's “spot length” field. If the invoice item's length is less than the final buy item's length, then this difference in section 1042 is preferably a negative number. If the final buy item's length is less than the invoice item's length, then this difference in section 1042 is preferably a positive number. In situations where the final buy item length is greater than the invoice item length (or vice versa), from the data in sections 1032 and 1042 and from any other guidelines that may be in place for processing such exceptions (e.g., instructions from a client as to how to handle such an exception), the user can choose to undertake any of a plurality of options, which preferably include the options set forth above in connection with buttons 1010, 1006, and 1008.
FIG. 8( e) depicts a preferred GUI 1050 for handling a “spot time inconsistency” exception which occurs when the invoice item's “spot time” data does not fall within the range of its counterpart final buy item's “times” data range (including any tolerance that may be built into this range as previously explained). GUI 1050 preferably includes a display section 1032 that identifies the media property, client, and advertising agency to which the spot time inconsistency is applicable. Section 1032 preferably also lists the pertinent data fields for the applicable final buy item and applicable invoice item (preferably the fields shown in FIGS. 4 and 5). Display section 1052 preferably identifies the tolerance (if any) that is built into the final buy item's time range, and section 1054 preferably identifies the time differential between the invoice item and the final buy item (taking into consideration the tolerance 1052). From this data and from any other guidelines that may be in place for processing such exceptions (e.g., instructions from a client as to how to handle such an exception), the user can choose to undertake any of a plurality of options, which preferably include the options set forth above in connection with buttons 1010, 1006, and 1008.
FIG. 8( f) depicts a preferred GUI 1060 for handling a “spot date inconsistency” exception which occurs when the invoice item's “spot date” data does not fall within the range of its counterpart final buy item's “buy dates” data range. GUI 1060 preferably includes a display section 1032 that identifies the media property, client, and advertising agency to which the spot time inconsistency is applicable. Section 1032 preferably also lists the pertinent data fields for the applicable final buy item and applicable invoice item (preferably the fields shown in FIGS. 4 and 5). Display section 1062 preferably identifies the date differential between the invoice item and the final buy item. From this data and from any other guidelines that may be in place for processing such exceptions (e.g., instructions from a client as to how to handle such an exception), the user can choose to undertake any of a plurality of options, which preferably include the options set forth above in connection with buttons 1010, 1006, and 1008.
It is worth noting that the GUIs of FIGS. 8( a)-(f) need not list only a single exception. A practitioner of the present invention can also design one or more of these GUIs such that a plurality of the applicable exception items for the selected media property/client/ advertising agency conditions are listed. It is also worth noting that the GUIs of FIGS. 8( a)-(f) may also include a user action button that is effective to allow the user to pay a user-specified amount for a spot that triggered an exception handling condition, thereby allowing for partial payments of disputed invoice items. In such a case, a field on the GUI or an additional GUI could be used through which the user could enter this partial payment amount. Upon entry of such a partial payment amount, the running total that represents the amount to be paid to the media property can preferably be increased by the partial payment amount that was entered by the user.
Returning to FIG. 6, at step 612, any items that were approved for full payment during the exception handling process and that do not require further action from the media property (such as to approve a credit request) are flagged as approved for full payment. At step 614, a determination is made as to whether all of the items listed in the subject invoice have been appropriately reconciled with final buy items (either exactly matched or approved for payment as a result of the exception handling process). If the answer to that question is yes, the process preferably proceeds to step 608. If the answer to that question is no, then at step 616, one or more messages are preferably electronically communicated to the media property to request action from the media property on the disputed invoice items, and payment on the subject invoice is placed on hold (step 618).
As a result of step 616, the media property can expect to receive one or more messages requesting action on a disputed invoice item. FIG. 9 depicts an exemplary GUI 900 that could be presented on the computer screen of a media property employee that lists received messages about disputed invoice items. Section 902 of GUI 900 serves as an inbox for such received messages. By way of example, each received message can be identified in a row 904 of section 902 by the date/time of receipt, the name of the applicable advertising agency for the disputed advertisement spot, the name of the applicable advertiser for the disputed advertisement spot, the invoice number for the disputed advertisement spot, the invoice date for the disputed advertisement spot, and a message code or short text section that briefly summarizes the nature of the dispute. To review a message that is listed in section 902, the user can select the review button 906 corresponding to that message.
Upon selection of a review button 906, a GUI such as the ones shown in FIGS. 10( a) and 10(b) will be displayed. FIG. 10( a) depicts a GUI 1000 that would be displayed after the user has selected a message relating to a credit request arising from an invoice item that is disputed due to a spot cost inconsistency. GUI 1000 preferably includes a section 1002 that identifies the applicable advertising agency and advertiser as well as the pertinent final buy and invoice data in dispute. Section 1004 preferably displays the cost differential between the final buy and the invoice and section 1006 preferably displays the requested credit amount. The user can then approve the requested credit via selection of button 1010 or reject the requested credit via selection of button 1012. If the user approves of the requested credit, then that final buy item-invoice item pair will be deemed reconciled. If not, alternative means will preferably be employed to resolve the dispute (such as telephone calls, etc.) as payment the subject invoice will remain on hold.
FIG. 10( b) depicts a GUI 1020 that would be displayed after the user has selected a message relating to a invoice item for which payment has been rejected due to a spot time inconsistency. GUI 1020 preferably includes a section 1002 that identifies the applicable advertising agency and advertiser as well as the pertinent final buy and invoice data in dispute. Section 1022 preferably displays the allowed tolerance between the final buy's time range and the spot time identified on the invoice. Section 1024 preferably displays the how far outside this tolerance the actual spot time on the invoice fell. The user can then approve the requested invoice item rejection via selection of button 1026 or refuse the invoice rejection via selection of button 1028. If the user approves of the rejection, then that final buy item-invoice item pair will be deemed reconciled. If not, alternative means will preferably be employed to resolve the dispute (such as telephone calls, etc.) as payment on the subject invoice will remain on hold. Returning to FIG. 6, at step 620, the process will check to see if the media property has agreed to all of the user actions requested as a result of the exception handling process for the subject invoice. Essentially, this step operates to determine whether all of the invoice items for the subject invoice have been appropriately reconciled. If the answer is no, then payment on the subject invoice will remain on hold (step 618). If the answer is yes, then at step 622, instructions for payment of the subject invoice for the approved amount are communicated to the NP system 108, less any applicable discounts for prompt payment. As with step 608, these payments instructions will preferably interface with the NP software on computer system 108 to effectuate payment from the account on the approved adjusted invoice.
Therefore, using the preferred embodiment, invoices from media properties for advertising services can be quickly and accurately reconciled. Furthermore, the account receivable time for such invoices can be drastically reduced because payment on such invoices can be delivered to media properties in near real-time after successful reconciliation, thereby benefiting media properties by providing media properties with money owed to them sooner rather than later.
While the present invention has been described above in relation to its preferred embodiment, various modifications may be made thereto that still fall within the invention's scope, as would be recognized by those of ordinary skill in the art. For example, while the preferred embodiment described in connection with FIG. 6 operates where payment is made on a monthly invoice-by-invoice basis, it should be noted that the system can also be configured to pay media properties on an invoice item by invoice item basis (wherein payment of a invoice that lists 100 spots would not be held up due to a dispute over 2 or 3 spots). With such an invoice item, as each invoice item is reconciled with a final buy item, payment can be authorized and remitted for the cost of that invoice item (less any applicable discounts). Further still, it is worth noting that the invoices need not be monthly; other invoicing intervals could be used such as weekly, daily, bimonthly, etc. Such modifications to the invention will be recognizable upon review of the teachings herein. As such, the full scope of the present invention is to be defined solely by the appended claims and their legal equivalents.

Claims

What is claimed is:

1. A system for auditing an advertising agency to evaluate how the agency performed in executing an advertising plan on behalf of a company, the system comprising:

a processor; and

a memory; and

wherein the processor and memory are configured to:

receive advertising plan data, the advertising plan data describing an advertising plan for a company;

receive buy data in a plurality of different formats, the received buy data comprising a plurality of buy items from a plurality of advertising agencies, each buy item corresponding to an advertisement spot request that was placed by an advertising agency with a media property on behalf of a company, wherein the received buy data comprises a member of the group consisting of (1) original buy data comprising a plurality of original buy items, (2) final buy data comprising a plurality of final buy items, and (3) actual buy data comprising a plurality of actual buy items;

generate commonly formatted data by converting the received buy data to a common format, the commonly formatted data comprising a plurality of data fields representative of the plurality of buy items;

compare the advertising plan data with the commonly formatted data representative of the buy items; and

generate report data indicative of an extent to which the buy items satisfy the advertising plan data based on the comparison operation.

2. The system of claim 1 wherein the received buy data comprises actual buy data, wherein the advertising plan data comprises data representative of a target amount of exposure for an advertising campaign by the company, and wherein the processor and memory are further configured to:

obtain exposure data for the actual buy items in the actual buy data;

perform the comparison operation by comparing the obtained exposure data with the target amount of exposure from the advertising plan data; and

perform the report data generation operation by generating the report data such that the report data is indicative of an extent to which the obtained exposure data for the actual buy items satisfied the target amount of exposure from the advertising plan data.

3. The system of claim 2 wherein the exposure data comprises a member of the group consisting of Nielsen television ratings and Arbitron radio ratings.

4. The system of 2 wherein the processor and memory are further configured to:

associate the actual buy items with the obtained exposure data corresponding thereto; and

store the commonly formatted data representative of the actual buy items associated with the obtained exposure data in a database as posted buy data.

5. The system of claim 4 wherein the received buy data further comprises final buy data, and wherein the processor and memory are further configured to:

compare the commonly formatted final buy data with the posted buy data;

generate data indicative of an extent to which a plurality of the fields of the posted buy data match up with a plurality of the fields of the commonly formatted final buy data based on the comparison operation between the final buy data and the posted buy data; and

generate posted buy-to-final buy report data based on the generated data resulting from the comparison operation between the final buy data and the posted buy data, the generated posted buy-to-final buy report data being indicative of an extent to which the advertisement spots of the posted buy data correspond to the advertisement spots of the final buy data.

6. The system of claim 5 wherein each of at least a plurality of the buy items present in the received buy data comprises a data field pertaining to an aspect of the buy item and populated with coded data, the buy data for at least two of the advertising agencies having coded data for the data field that are coded in different formats, and wherein the processor and memory are further configured to:

convert the coded data for each of the received buy items to coded data of a standardized coding format.

7. The system of claim 1 wherein each of at least a plurality of the buy items present in the received buy data comprises a data field pertaining to an aspect of the buy item and populated with coded data, the buy data for at least two of the advertising agencies having coded data for the data field that are coded in different formats, and wherein the processor and memory are further configured to:

8. The system of claim 7 wherein the processor and memory are further configured to:

store a data table in the memory, the data table defining a mapping between coded data present in the data field of the received buy items and the coded data of the standardized coding format; and

perform the conversion operation by converting the coded data for each of the received buy items to the coded data of the standardized coding format based on the data table.

9. The system of claim 8 wherein the data table comprises a plurality of mapping records, each mapping record comprising a plurality of data table fields, the data table fields comprising:

a first field for data representative of an identifier for a software package used by an advertising agency to generate buy data;

a second field for data representative of a data value for the coded data in the data field of the received buy items; and

a third field for data representative of a data value for the coded data of the standardized coding format corresponding to the data value for the coded data in the data field of the received buy items for that mapping record; and

wherein the processor and memory are further configured to perform the conversion operation by, for each of a plurality of buy items in the received buy data:

determining a software package used by the advertising agency to generate the data for that buy item;

searching the data table;

determining whether a mapping record corresponding to the determined software package and the coded data in the data field for that buy item is present in the data table based on the search operation; and

based at least in part on a determination that such a mapping record is present in the data table, replacing the coded data in the data field for that buy item with the data value from the third field of that mapping record.

10. The system of claim 9 wherein the processor and memory are further configured to perform the conversion operation by, based at least in part on a determination that a mapping record corresponding to the determined software package and the coded data in the data field for that buy item is not present in the data table:

providing a user interface for display to a user;

receiving user input through the user interface corresponding to the data value to be used as the coded data of the standardized format for that buy item;

replacing the coded data in the data field for that buy item with the data value of the received user input; and

updating the data table with a new mapping record that associates the determined software package for that buy item with the coded data in the data field for that buy item and the data value of the received user input.

11. The system of claim 7 wherein the data field comprises a daypart code field.

12. The system of claim 1 wherein the received buy data comprises original buy data.

13. The system of claim 1 wherein the received buy data comprises final buy data.

14. The system of claim 1 wherein the received buy data comprises actual buy data.

15. A computer-implemented method of auditing an advertising agency to evaluate how the agency performed in executing an advertising plan on behalf of a company, the method comprising:

receiving advertising plan data, the advertising plan data describing an advertising plan for a company;

receiving buy data in a plurality of different formats, the received buy data comprising a plurality of buy items from a plurality of advertising agencies, each buy item corresponding to an advertisement spot request that was placed by an advertising agency with a media property on behalf of a company, wherein the received buy data comprises a member of the group consisting of (1) original buy data comprising a plurality of original buy items, (2) final buy data comprising a plurality of final buy items, and (3) actual buy data comprising a plurality of actual buy items;

generating commonly formatted data by converting the received buy data to a common format, the commonly formatted data comprising a plurality of data fields representative of the plurality of buy items;

comparing the advertising plan data with the commonly formatted data representative of the buy items; and

generating report data indicative of an extent to which the buy items satisfy the advertising plan data based on the comparing step; and

wherein the method steps are performed by a processor.

16. The method of claim 15 wherein the received buy data comprises actual buy data, wherein the advertising plan data comprises data representative of a target amount of exposure for an advertising campaign by the company, the method further comprising:

the processor obtaining exposure data for the actual buy items in the actual buy data; and

wherein the comparing step comprises the processor comparing the obtained exposure data with the target amount of exposure from the advertising plan data; and

wherein the report data generating step comprises the processor generating the report data such that the report data is indicative of an extent to which the obtained exposure data for the actual buy items satisfied the target amount of exposure from the advertising plan data.

17. The method of claim 16 wherein the exposure data comprises a member of the group consisting of Nielsen television ratings and Arbitron radio ratings.

18. The method of 16 further comprising:

the processor associating the actual buy items with the obtained exposure data corresponding thereto; and

the processor storing the commonly formatted data representative of the actual buy items associated with the obtained exposure data in a database as posted buy data.

19. The method of claim 18 wherein the received buy data further comprises final buy data, the method further comprising:

the processor comparing the commonly formatted final buy data with the posted buy data;

generating data indicative of an extent to which a plurality of the fields of the posted buy data match up with a plurality of the fields of the commonly formatted final buy data based on the step of comparing the commonly formatted final buy data with the posted buy data; and

generating report data based on the generated data resulting from the step of comparing the commonly formatted final buy data with the posted buy data, the generated report data being indicative of an extent to which the advertisement spots of the posted buy data correspond to the advertisement spots of the final buy data.

20. The method of claim 19 wherein each of at least a plurality of the buy items present in the received buy data comprises a data field pertaining to an aspect of the buy item and populated with coded data, the buy data for at least two of the advertising agencies having coded data for the data field that are coded in different formats, the method further comprising:

the processor performing the converting step by converting the coded data for each of the received buy items to coded data of a standardized coding format.

21. The method of claim 15 wherein each of at least a plurality of the buy items present in the received buy data comprises a data field pertaining to an aspect of the buy item and populated with coded data, the buy data for at least two of the advertising agencies having coded data for the data field that are coded in different formats, the method further comprising:

22. The method of claim 21 further comprising:

the processor storing a data table in a memory, the data table defining a mapping between coded data present in the data field of the received buy items and the coded data of the standardized coding format; and

wherein the converting step comprises the processor converting the coded data for each of the received buy items to the coded data of the standardized coding format based on the data table.

23. The method of claim 22 wherein the data table comprises a plurality of mapping records, each mapping record comprising a plurality of data table fields, the data table fields comprising:

wherein the converting step further comprises the processor, for each of a plurality of buy items in the received buy data:

searching the data table;

determining whether a mapping record corresponding to the determined software package and the coded data in the data field for that buy item is present in the data table based on the searching step; and

24. The method of claim 23 wherein the converting step further comprises:

the processor, based at least in part on a determination that a mapping record corresponding to the determined software package and the coded data in the data field for that buy item is not present in the data table:

providing a user interface for display to a user;

25. The method of claim 21 wherein the data field comprises a daypart code field.

26. The method of claim 15 wherein the received buy data comprises original buy data.

27. The method of claim 15 wherein the received buy data comprises final buy data.

28. The method of claim 15 wherein the received buy data comprises actual buy data.

29. A computer program product for auditing an advertising agency to evaluate how the agency performed in executing an advertising plan on behalf of a company, the computer program product comprising:

executable program code resident on a non-transitory computer-readable storage medium, the executable program code comprising a plurality of code segments executable by a processor, the code segments configured to: