Processes to learn enterprise data matching

• US 8,356,037 B2
• Filed: 12/21/2009
• Issued: 01/15/2013
• Est. Priority Date: 12/21/2009
• Status: Active Grant

• Current Assignee: iHeartMedia Management Services, Inc. (iHeartMedia, Inc.)
• Original Assignee: Clear Channel Management Services LP (iHeartMedia, Inc.)
• Inventors: Basu, Kohinoor, Chua, Angel Barnachea, Ferry, Matthew M., Roberts, Scott Arthur
• Primary Examiner(s): Jalil, Neveen Abel
• Assistant Examiner(s): KINSAUL, DANIEL W
• Application Number:
  US12/642,858
• Publication Number:
  US 20110154230A1
• Time in Patent Office: 1,121 Days
• Field of Search: None
• US Class Current: 707/748
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/24578 using ranking
• CPC Class Codes: G06F 16/2468 Fuzzy queries
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 30/0201 Market modelling; Market analysis; Collecting market data
• CPC Class Codes: G06Q 30/0242 Determining effectiveness of advertisements
• CPC Class Codes: G06Q 30/0243 Comparative campaigns
• CPC Class Codes: G06Q 30/0277 Online advertisement

Abstract

A system and method for managing media advertising enterprise data including a process for learning enterprise data matching. An EDM (Enterprise Data Management) application module can be configured to include a set of rules at an enterprise level to manage disparate and disconnected records associated with an entity. A number of unmatched and enterprise entities that matches with respect to an active entity can be returned based on a fuzzy logic associated with various matching options stored in an EDM database. A matching process can then be performed to accurately match similar records regardless of manual input, location, and format of the records in a distributed system. Each unmatched record can then be assigned with a parent enterprise entity. Such an optimization mechanism can interactively manage and report records at the enterprise level in a simple and efficient manner.

Claims

1. A method for managing advertising data, comprising:

configuring a set of rules in order to manage a plurality of unmatched records, each individual record of the plurality of unmatched records is associated with a separate market entity of a plurality of market entities, each of the plurality of market entities is one of an advertiser and an agency, and managing the plurality of unmatched records includes scoring each of the plurality of unmatched records, by executing a program instruction in a data-processing system;

computing a scoring function, based on the set of rules, to assign a individual rank to each individual record based on one of revenue and market ranking associated with the separate market entity, by executing a program instruction in a data-processing system;

selecting a highest-ranking market entity from the plurality of market entities as the active entity, by executing a program instruction in a data-processing system;

performing a first matching process, using a fuzzy logic configured in association with a plurality of matching options, to match the active entity to at least one of a remaining plurality of market entities, by executing a program instruction in a data-processing system;

performing a second matching process, using the fuzzy logic, to match the active entity to a parent advertiser in order to manage and report records associated with the active entity at said enterprise level, by executing a program instruction in a data-processing system; and

storing the at least one of the remaining plurality of market entities and the parent advertiser, by executing a program instruction in a data-processing system.

2. The method of claim 1 further comprising storing said plurality of matching options in a database, by executing a program instruction in a data-processing system.

3. The method of claim 2 further comprising providing a plurality of unmatched entities and at least one parent advertiser that matches with respect to the active entity based on said fuzzy logic and said plurality of matching options stored in said database, by executing a program instruction in a data-processing system.

4. The method of claim 3 further comprising:

displaying said plurality of unmatched entities in an unmatched entity section, by executing a program instruction in a data-processing system; and

displaying said at least one parent advertiser in a parent advertiser section, by executing a program instruction in a data-processing system.

5. The method of claim 4 further comprising populating said unmatched entity section and said parent advertiser section with said plurality of records based on said fuzzy logic, by executing a program instruction in a data-processing system.

6. The method of claim 1 further comprising configuring said plurality of matching options to comprise an exact match, by executing a program instruction in a data-processing system.

7. The method of claim 1 further comprising configuring said plurality of matching options to comprise a like match, by executing a program instruction in a data-processing system.

8. The method of claim 1 further comprising configuring said plurality of matching options to comprise a Soundex match, by executing a program instruction in a data-processing system.

9. The method of claim 1 further comprising configuring said plurality of matching options to comprise at least one of the following, by executing a program instruction in a data-processing system:

an exact match;

a like match; and

a Soundex match.

10. The method of claim 1 further comprising creating a new parent advertiser if a user is unable to retrieve said at least one parent advertiser, by executing a program instruction in a data-processing system.

11. An advertising data management system, comprising

a processor;

a data bus coupled to said processor; and

a computer-usable medium embodying computer code, said computer-usable medium being coupled to said data bus, said computer program code comprising instructions executable by said processor and configured for;

configuring a set of rules order to manage a plurality of unmatched records, each individual record of the plurality of unmatched records is associated with a separate market entity of a plurality of market entities, each of the plurality of market entities is one of an advertiser and an agency, and managing the plurality of unmatched records includes scoring each of the plurality of unmatched records;

computing a scoring function, based on the set of rules, to assign a individual rank to each individual record based on one of revenue and market ranking associated with the separate market entity;

selecting a highest-ranking market entity from the plurality of market entities as the active entity;

performing a first matching process, using a fuzzy logic configured in association with a plurality of matching options, to match the active entity to at least one of a remaining plurality of market entities;

performing a second matching process, using the fuzzy logic, to match the active entity to a parent advertiser in order to manage and report records associated with the active entity; and

storing the at least one of the remaining plurality of market entities and the parent advertiser.

12. The advertising data management system of claim 11, wherein said instructions are further configured for storing said plurality of matching options in a database.

13. The advertising data management system of claim 12 wherein said instructions are further configured for providing a plurality of unmatched entities and at least one parent advertiser that matches with respect to the active entity based on said fuzzy logic and said plurality of matching options stored in said database.

14. The advertising data management system of claim 13 wherein said instructions are further configured for:

displaying said plurality of unmatched entities in an unmatched entity section; and

displaying said at least one parent advertiser in a parent advertiser section.

15. The advertising data management system of claim 14 wherein said instructions are further configured for populating said unmatched entity section and said parent advertiser section with said plurality of records based on said fuzzy logic.

16. The advertising data management system of claim 11 wherein said instructions are further configured for arranging said plurality of matching options to comprise at least one of the following:

an exact match;

a like match; and

a Soundex match.

17. The advertising data management system of claim 11 wherein said instructions are further configured for creating a new parent advertiser if a user is unable to retrieve said at least one parent advertiser.

18. An advertising data management system, comprising

a processor;

a data bus coupled to said processor; and

a computer-usable medium embodying computer code, said computer-usable medium being coupled to said data bus, said computer program code comprising instructions executable by said processor and configured for;

configuring a set of rules in order to manage a plurality of unmatched records, each individual record of the plurality of unmatched records is associated with a separate market entity of a plurality of market entities, each of the plurality of market entities is one of an advertiser and an agency, and managing the plurality of unmatched records includes scoring each of the plurality of unmatched records;

computing a scoring function, based on the set of rules, to assign a individual rank to each individual record based on one of revenue and market ranking associated with the separate market entity;

selecting a highest-ranking market entity from the plurality of market entities as the active entity;

performing a first matching process, using a fuzzy logic configured in association with a plurality of matching options, to match the active entity to at least one of a remaining plurality of market entities;

performing a second matching process, using the fuzzy logic, to match the active entity to a parent advertiser in order to manage and report records associated with the active entity;

storing said plurality of matching options in a database; and

storing the at least one of the remaining plurality of market entities and the parent advertiser.

19. The advertising data management system of claim 18 wherein said instructions are further configured for providing a plurality of unmatched entities and at least one parent advertiser that matches with respect to the active entity based on said fuzzy logic and said plurality of matching options stored in a database.

20. The advertising data management system of claim 19 wherein said instructions are further configured for:

displaying said plurality of unmatched entities in an unmatched entity section;

displaying said at least one parent advertiser in a parent advertiser section; and

populating said unmatched entity section and said parent advertiser section with said plurality of records based on said fuzzy logic.