Method and system for reconciling advertising invoices and for providing prompt payment therefor

• US 8,589,227 B1
• Filed: 10/18/2005
• Issued: 11/19/2013
• Est. Priority Date: 03/26/2004
• Status: Active Grant

• Current Assignee: Media Management Incorporated
• Original Assignee: Media Management Incorporated
• Inventors: Bridge, Thomas E., Vache, Steven L.
• Primary Examiner(s): Hamilton, Matthew L
• Application Number:
  US11/253,040
• Time in Patent Office: 2,954 Days
• Field of Search: 705/14
• US Class Current: 705/14.41
• CPC Class Codes: G06Q 30/0241 Advertisements
• CPC Class Codes: G06Q 30/0246 Traffic
• CPC Class Codes: G06Q 30/04 Billing or invoicing

Abstract

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. Based on this comparison, an electronic fund transfer of the appropriate amount of money can be made from a financial account to the media property. Further still, GUIs for exception handling can be presented to a user to identifying any actions that should be taken on invoice items that trigger an exception handling condition. Corresponding systems and software are also disclosed herein.

Claims

1. 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 advertisement spot for which the media property requests payment, the method comprising:

receiving the invoice data, the invoice data comprising a plurality of data fields representative of a plurality of advertisement spots for which the media property requests payment;

receiving final buy data in a plurality of different formats from a plurality of advertising agencies, the received final buy data comprising a plurality of final buy items, each final buy item corresponding to an advertisement spot request that was placed by an advertising agency with the media property;

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

comparing the invoice data with the commonly formatted data representative of the final buy items;

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

generating report data based on the generated data resulting from the comparing step, the generated report data being indicative of an extent to which the invoiced advertisement spots correspond to the advertisement spot requests that were placed by the advertising agencies with the media property; and

wherein the method steps are performed by a processor.

2. The method of claim 1 further comprising:

receiving the media property invoice data in a second format, wherein the common format is the second format; and

storing the received invoice data and the converted final buy data in a database for subsequent processing during the comparing step.

5. The method of claim 1 wherein each of at least a plurality of the final buy items present in the received final buy data comprises a data field pertaining to an aspect of the final buy item and populated with coded data, the final buy data received from 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 final buy items to coded data of a standardized coding format.

6. The method of claim 5 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 final 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 final buy items to the coded data of the standardized coding format based on the data table.

7. The method of claim 6 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 final buy data;

a second field for data representative of a data value for the coded data in the data field of the received final 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 final buy items for that mapping record; and

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

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

searching the data table;

determining whether a mapping record therein corresponding to the determined software package and the coded data in the data field for that final buy item is present in the data table based on the searching step; 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 final buy item with the data value from the third field of that mapping record.

8. The method of claim 7 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 final 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 final buy item;

replacing the coded data in the data field for that final 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 final buy item with the coded data in the data field for that final buy item and the data value of the received user input.

9. The method of claim 5 wherein the data field comprises a daypart code field.

10. The method of claim 5 further comprising:

the processor receiving raw invoice data in a plurality of different formats from a plurality of media properties; and

the processor generating commonly formatted data representative of the invoice items by converting raw invoice data to the common format; and

wherein the comparing step comprises comparing the commonly formatted data representative of the invoice items with the commonly formatted data representative of the final buy items.

11. The method of claim 10 further comprising:

the processor generating a database by storing the commonly formatted data representative of the invoice items and the commonly formatted data representative of the final buy items in a memory, the generated database comprising invoice item records and final buy item records corresponding to invoiced advertisement spots and advertisement spot requests that were placed by the advertising agencies with the media properties, the invoice item records and the final buy item records comprising a plurality of data fields populated with data that is coded in a standardized coding format; and

the processor performing the comparing step on the invoice item records and the final buy item records in the database by executing programming logic in response to user input.

12. The method of claim 11 further comprising:

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

the processor storing the received advertising plan data in the database;

the processor comparing the invoice item records in the database with the advertising plan data in the database; and

the processor generating data for the report indicative of an extent to which the invoiced advertisement spots satisfy the advertising plan data based on the step of comparing the invoice item records in the database with the advertising plan data in the database.

13. The method of claim 12 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 associating the invoice item records with ratings data for the invoiced advertisement spots;

the processor comparing the ratings data associated with the invoice item records with the advertising plan data; and

the processor generating data for the report indicative of an extent to which the invoiced advertisement spots for the company satisfied the target amount of exposure for the advertising campaign defined in the advertising plan data based on the step of comparing the ratings data associated with the invoice item records with the advertising plan data.

14. The method of claim 13 further comprising:

the processor comparing the final buy item records in the database with the advertising plan data in the database; and

the processor generating data for the report indicative of an extent to which the advertisement spot requests that were placed by the advertising agency with the media properties satisfy the advertising plan data based on the step of comparing the final buy item records in the database with the advertising plan data in the database.

3. A nontransitory computer-readable storage medium for 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 advertisement spot for which the media property requests payment, the nontransitory computer-readable storage medium comprising:

encoded executable program code resident on the nontransitory computer-readable storage medium, the executable program code comprising a plurality of code segments executable by a processor, the code segments configured to;

receive the invoice data, the invoice data comprising a plurality of data fields representative of a plurality of advertisement spots for which the media property requests payment;

receive final buy data in a plurality of different formats from a plurality of advertising agencies, the received 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;

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

compare the invoice data with the commonly formatted data representative of the final buy items;

generate data indicative of an extent to which a plurality of the fields of the invoice data match up with a plurality of the fields of the commonly formatted data based on the comparison; and

generate report data based on the generated data resulting from the comparison, the generated report data being indicative of an extent to which the invoiced advertisement spots correspond to the advertisement spot requests that were placed by the advertising agencies with the media property.

15. The nontransitory computer-readable storage medium of claim 3 wherein each of at least a plurality of the final buy items present in the received final buy data comprises a data field pertaining to an aspect of the final buy item and populated with coded data, the final buy data received from at least two of the advertising agencies having coded data for the data field that are coded in different formats, and wherein the code segments are further configured to perform the conversion operation by converting the coded data for each of the received final buy items to coded data of a standardized coding format.

4. A system for 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 advertisement spot for which the media property requests payment, the system comprising:

a processor; and

a memory; and

wherein the processor and memory are configured to;

receive the invoice data, the invoice data comprising a plurality of data fields representative of a plurality of advertisement spots for which the media property requests payment;

receive final buy data in a plurality of different formats from a plurality of advertising agencies, 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;

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

compare the invoice data with the commonly formatted data representative of the final buy items;

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

generate report data based on the generated data resulting from the comparison operation, the generated report data being indicative of an extent to which the invoiced advertisement spots correspond to the advertisement spot requests that were placed by the advertising agencies with the media property.

16. The system of claim 4 wherein each of at least a plurality of the final buy items present in the received final buy data comprises a data field pertaining to an aspect of the final buy item and populated with coded data, the final buy data received from 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 perform the conversion operation by converting the coded data for each of the received final buy items to coded data of a standardized coding format.

17. The system of claim 16 wherein the processor and memory are further configured to (1) store a data table in the memory, the data table defining a mapping between coded data present in the data field of the received final 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 final buy items to the coded data of the standardized coding format based on the data table.

18. The system of claim 17 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 final buy data;

a second field for data representative of a data value for the coded data in the data field of the received final 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 final 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 final buy items in the received final data;

determining a software package used by the advertising agency to generate the data for that final 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 final buy item is present in the data table based on the search operation;

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 final buy item with the data value from the third field of that mapping record.

19. The system of claim 18 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 final 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 final buy item;

replacing the coded data in the data field for that final 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 final buy item with the coded data in the data field for that final buy item and the data value of the received user input.

20. The system of claim 18 wherein the data field comprises a daypart code field.

21. The system of claim 17 wherein the data field comprises a daypart code field.

22. The system of claim 16 wherein the data field comprises a daypart code field.

23. The system of claim 16 wherein each of at least a plurality of the final buy items present in the received final buy data comprises a plurality of data fields pertaining to a plurality of aspects of the final buy item and populated with coded data, and wherein the processor and memory are further configured to perform the conversion operation for a plurality of the data fields.

24. The system of claim 16 wherein the processor and memory are further configured to perform the comparison operation by executing programming logic to compare the invoice data with the commonly formatted data representative of the final buy items received from a first advertising agency as is executed to compare the invoice data with the commonly formatted data representative of the final buy items received from a second advertising agency.

25. The system of claim 16 wherein the processor and memory are further configured to:

receive raw invoice data in a plurality of different formats from a plurality of media properties; and

generate commonly formatted data representative of the invoice items by converting the raw invoice data to the common format.

26. The system of claim 25 wherein the processor and memory are further configured to:

generate a database by storing the commonly formatted data representative of the invoice items and the commonly formatted data representative of the final buy items in a memory, the generated database comprising invoice item records and final buy item records corresponding to invoiced advertisement spots and advertisement spot requests that were placed by the advertising agencies with the media properties, the invoice item records and the final buy item records comprising a plurality of data fields populated with data that is coded in a standardized coding format; and

perform the comparison operation on the invoice item records and the final buy item records in the database by executing programming logic in response to user input.

27. The system of claim 26 wherein the processor and memory are further configured to:

receive data describing an advertising plan for a company;

store the received advertising plan data in the database;

compare the invoice item records in the database with the advertising plan data in the database; and

generate data for the report indicative of an extent to which the invoiced advertisement spots satisfy the advertising plan data based on the comparison of the invoice item records in the database with the advertising plan data in the database.

28. The system of claim 27 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:

associate the invoice item records with ratings data for the invoiced advertisement spots;

compare the ratings data associated with the invoice item records with the advertising plan data; and

generate data for the report indicative of an extent to which the invoiced advertisement spots for the company satisfied the target amount of exposure for the advertising campaign defined in the advertising plan data based on the comparison of the ratings data associated with the invoice item records with the advertising plan data.

29. The system of claim 28 wherein the processor and memory are further configured to compare the final buy item records in the database with the advertising plan data in the database to thereby generate data for the report indicative of an extent to which the advertisement spot requests that were placed by the advertising agency with the media properties satisfy the advertising plan data.

30. The system of claim 4 wherein the common format is one of the formats for the received final buy data.