Method, computer useable medium, and system for analyzing media exposure

• US 7,082,434 B2
• Filed: 04/17/2003
• Issued: 07/25/2006
• Est. Priority Date: 04/17/2003
• Status: Active Grant

• Current Assignee: Gregory P. Gosselin
• Original Assignee: Gregory P. Gosselin
• Inventors: Gosselin, Gregory P.
• Primary Examiner(s): Robinson, Greta
• Assistant Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US10/417,081
• Publication Number:
  US 20040210594A1
• Time in Patent Office: 1,195 Days
• Field of Search: 707 1- 5, 707/100, 707/104.1, 705/1, 705 26- 27
• US Class Current: 1/1
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A method, computer useable medium, and/or system for analyzing media exposure that generates databases of retail location parameters, generates databases of media parameters, generates databases of exposure factors associated with an entity, executes relational queries that correlate the exposure factors with the media parameters, and develops lists of retail locations from the executed relational queries. The retail location and/or media parameter databases may include a radio technical database, a radio zip code map database, a venue database, a venue zip code map database, a video technical database, a video zip code map database, a sales market database, a sales market zip code map database, a retail location database, or the like. The databases of exposure factors may include a key market database, a radio tracking database, a video tracking database, a tour database, a project database, or the like.

Claims

1. A computer implemented method for analyzing media exposure comprising steps of:

generating at least one database of retail locations;

generating at least one database of media parameters, said database of media parameters containing data associated with mediums of exposure employed in marketing an entity;

generating at least one database of exposure factors associated with the entity;

executing at least one relational query that correlates the exposure factors with the media parameters; and

developing at least one list of retail locations from said step of executing at least one relational query.

2. The method for analyzing media exposure according to claim 1, wherein said step of generating at least one database of media parameters includes the steps:

generating a radio technical database;

generating a radio zip code map database;

generating a venue database;

generating a venue zip code map database

generating a video technical database;

generating a video zip code map database;

generating a sales market database; and

generating a sales market zip code map database.

3. The method for analyzing media exposure according to claim 2, wherein said step of generating at least one database of exposure factors associated with the entity includes the steps:

generating a key market database;

generating a radio tracking database;

generating a video tracking database;

generating a tour database; and

generating a project database.

4. The method for analyzing media exposure according to claim 3, wherein said step of executing at least one relational query that correlates the exposure factors with the media parameters further comprises:

executing a media exposure relational query that correlates exposure factors from the radio tracking database and the project database, with media parameters from the radio zip code map database to create first correlations, calculates an impact score for each of the first correlations, and produces a first data file containing result records;

executing a tour exposure relational query that correlates exposure factors from the tour database and the project database, with media parameters from the venue zip code map database to create second correlations, assigns an impact score for each of the second correlations, and produces a second data file containing result records;

executing a video exposure relational query that correlates exposure factors from the video tracking database and the project database, with media parameters from the video zip code map database to create third correlations, calculates an impact score for each of the third correlations, and produces a third data file containing result records; and

executing a sales market relational query that correlates exposure factors from the key market database and the project database, with media parameters from the sales market zip code map database to create fourth correlations, assigns an impact score for each of the fourth correlations, and produces a fourth data file containing result records.

5. The method for analyzing media exposure according to claim 4, wherein said step of executing at least one relational query that correlates the exposure factors with the media parameters further comprises:

executing a totaling query for the result records from the first data file to produce a fifth data file containing result records for predetermined field combinations;

executing a totaling query for the result records from the second data file to produce a sixth data file containing result records for predetermined field combinations; and

executing a totaling query for the result records from the third data file to produce a seventh data file containing result records for predetermined field combinations.

6. The method for analyzing media exposure according to claim 5, wherein said step of executing at least one relational query that correlates the exposure factors with the media parameters further comprises:

combining the result records from the fourth, fifth, sixth, and seventh data files into an eighth data file containing result records; and

executing a totaling query for the result records from the eighth data file to produce a ninth data file containing result records for predetermined field combinations.

7. The method for analyzing media exposure according to claim 6, wherein said step of developing at least one list of retail locations from said step of executing at least one relational query further comprises:

executing a relational query that correlates the result records of the ninth data file with retail locations from the at least one database of retail locations to produce a tenth data file containing result records; and

calculating an indexed impact score for each of the result records of the tenth data file to produce a final data file.

8. A computer useable medium carrying media exposure analyzing software which, when executed by a processor, causes the processor to carry out steps comprising:

generating at least one database of retail locations;

generating at least one database of media parameters, said database of media parameters containing data associated with mediums of exposure employed in marketing an entity;

generating at least one database of exposure factors associated with the entity;

executing at least one relational query that correlates the exposure factors with the media parameters; and

developing at least one list of retail locations from said step of executing at least one relational query.

9. The computer useable medium according to claim 8, wherein said media exposure analyzing software, when executed by the processor, further causes the processor to carry out steps comprising:

generating a radio technical database;

generating a radio zip code map database;

generating a venue database;

generating a venue zip code map database;

generating a video technical database;

generating a video zip code map database;

generating a sales market database; and

generating a sales market zip code map database.

10. The computer useable medium according to claim 9, wherein said media exposure analyzing software, when executed by the processor, further causes the processor to carry out steps comprising:

generating a key market database;

generating a radio tracking database;

generating a video tracking database;

generating a tour database; and

generating a project database.

11. The computer useable medium according to claim 10, wherein said media exposure analyzing software, when executed by the processor, further causes the processor to carry out steps comprising:

executing a media exposure relational query that correlates exposure factors from the radio tracking database and the project database, with media parameters from the radio zip code map database to create first correlations, calculates an impact score for each of the first correlations, and produces a first data file containing result records;

executing a tour exposure relational query that correlates exposure factors from the tour database and the project database, with media parameters from the venue zip code map database to create second correlations, assigns an impact score for each of the second correlations, and produces a second data file containing result records;

executing a video exposure relational query that correlates exposure factors from the video tracking database and the project database, with media parameters from the video zip code map database to create third correlations, calculates an impact score for each of the third correlations, and produces a third data file containing result records; and

executing a sales market relational query that correlates exposure factors from the key market database and the project database, with media parameters from the sales market zip code map database to create fourth correlations, assigns an impact score for each of the fourth correlations, and produces a fourth data file containing result records.

12. The computer useable medium according to claim 11, wherein said media exposure analyzing software, when executed by the processor, further causes the processor to carry out steps comprising:

executing a totaling query for the result records from the first data file to produce a fifth data file containing result records for predetermined field combinations;

executing a totaling query for the result records from the second data file to produce a sixth data file containing result records for predetermined field combinations; and

executing a totaling query for the result records from the third data file to produce a seventh data file containing result records for predetermined field combinations.

13. The computer useable medium according to claim 12, wherein said media exposure analyzing software, when executed by the processor, further causes the processor to carry out steps comprising:

combining the result records from the fourth, fifth, sixth, and seventh data files into an eighth data file containing result records; and

executing a totaling query for the result records from the eighth data file to produce a ninth data file containing result records for predetermined field combinations.

14. The computer useable medium according to claim 13, wherein said media exposure analyzing software, when executed by the processor, further causes the processor to carry out steps comprising:

executing a relational query that correlates the result records of the ninth data file with retail locations from the at least one database of retail locations to produce a tenth data file containing result records; and

calculating an indexed impact score for each of the result records of the tenth data file to produce a final data file.

15. A media exposure analyzing system comprising:

a computer useable medium; and

a computer device having a processor;

wherein the computer useable medium carries thereon media exposure analyzing software which, when executed by the processor of the computer device, causes the processor to carry out steps comprising;

generating at least one database of retail locations;

generating at least one database of media parameters, said database of media parameters containing data associated with mediums of exposure employed in marketing an entity;

generating at least one database of exposure factors associated with entity;

executing at least one relational query that correlates the exposure factors with the media parameters; and

developing at least one list of retail locations from said step of executing at least one relational query.

16. The media exposure analyzing system according to claim 15, wherein said media exposure software, when executed by the processor of the computer device, further causes the processor to carry out steps comprising:

generating a radio technical database;

generating a radio zip code map database;

generating a venue database;

generating a venue zip code map database;

generating a video technical database;

generating a video zip code map database;

generating a sales market database; and

generating a sales market zip code map database.

17. The media exposure analyzing system according to claim 16, wherein said media exposure software, when executed by the processor of the computer device, further causes the processor to carry out steps comprising:

generating a key market database;

generating a radio tracking database;

generating a video tracking database;

generating a tour database; and

generating a project database.

18. The media exposure analyzing system according to claim 17, wherein said media exposure software, when executed by the processor of the computer device, further causes the processor to carry out steps comprising:

executing a media exposure relational query that correlates exposure factors from the radio tracking database and the project database, with media parameters from the radio zip code map database to create first correlations, calculates an impact score for each of the first correlations, and produces a first data file containing result records;

executing a tour exposure relational query that correlates exposure factors from the tour database and the project database, with media parameters from the venue zip code map database to create second correlations, assigns an impact score for each of the second correlations, and produces a second data file containing result records;

executing a video exposure relational query that correlates exposure factors from the video tracking database and the project database, with media parameters from the video zip code map database to create third correlations, calculates an impact score for each of the third correlations, and produces a third data file containing result records; and

executing a sales market relational query that correlates exposure factors from the key market database and the project database, with media parameters from the sales market zip code map database to create fourth correlations, assigns an impact score for each of the fourth correlations, and produces a fourth data file containing result records.

19. The media exposure analyzing system according to claim 18, wherein said media exposure software, when executed by the processor of the computer device, further causes the processor to carry out steps comprising:

executing a totaling query for the result records from the first data file to produce a fifth data file containing result records for predetermined field combinations;

executing a totaling query for the result records from the second data file to produce a sixth data file containing result records for predetermined field combinations;

executing a totaling query for the result records from the third data file to produce a seventh data file containing result records for predetermined field combinations.

20. The media exposure analyzing system according to claim 19, wherein said media exposure software, when executed by the processor of the computer device, further causes the processor to carry out steps comprising:

combining the result records from the fourth, fifth, sixth, and seventh data files into an eighth data file containing result records;

executing a totaling query for the result records from the eighth data file to produce a ninth data file containing result records for predetermined field combinations;

executing a relational query that correlates the result records of the ninth data file with retail locations from the at least one database of retail locations to produce a tenth data file containing result records; and

calculating an indexed impact score for each of the result records of the tenth data file to produce a final data file.