Method of relating multiple independent databases
A method for relating multiple independent databases uses a graphical interface allowing market researchers to conveniently model different prototype forecast scenarios based on specific choices for ad campaign portfolio distributions among specific types of advertising vehicles, media vehicles or advertising media such as television or magazine print, for example. The method solves the classic regression-to-mean problem associated with the prior art fusion approach and requires less computer processing time and/or user expertise.
1. A method for correlating media vehicles from different databases, the method comprising:
creating a linkage system between a first media vehicle database associated with a first media vehicle and a second media vehicle database associated with a second media vehicle different than the first media vehicle, the linkage system associating the first and the second databases together based on comparable and inter-relatable demographic variables common to each of the databases and the first and the second databases relating to different media entities, the first media vehicle database and the second media vehicle database being independent of each other;
tabulating first market rating data associated with the first media vehicle database for at least one of the demographic variables, the first market rating data including media vehicle viewing levels and audience demographic data;
tabulating surrogate market rating data associated with the second media vehicle database for the at least one demographic variables, the second market rating data including media vehicle viewing levels and audience demographic data;
determining target group populations for the at least one demographic variables for the second media vehicle database;
calculating a projected vehicle audience for the first media vehicle database based on the first market rating data associated with the first media vehicle database and the determined target group populations;
calculating a projected surrogate audience for the second media vehicle database based on the surrogate market rating data associated with the second media vehicle database and the determined target group populations;
determining an actual surrogate audience; and
providing an output of an actual vehicle audience for the first media vehicle represented by the first media database based on the projected vehicle audience for the first media vehicle database, the projected surrogate audience for the second media vehicle database, and the actual surrogate audience.
2. The method of claim 1 , wherein the first database includes Nielsen Ratings.
3. The method of claim 1 , wherein the second database includes MRI Ratings.
4. The method of claim 1 , wherein the actual vehicle audience is calculated according to the following equation:
Actual
Vehicle
Audience
=
Projected
Vehicle
Audience
Projected
Surrogate
Audience
×
Actual
Surrogate
Audience
.
5. The method of claim 1 , further comprising:
comparing the projected vehicle audience for the first media vehicle database, the projected surrogate audience for the second media vehicle database, and the actual surrogate audience; and
determining a viewing tendency related to the target group populations based on the comparison.
6. The method of claim 1 , wherein the linkage system using default settings to determine the demographic variables.
7. The method of claim 6 , wherein the demographic variables of the linkage system are periodically updated.
8. The method of claim 1 , wherein the demographic variables of the linkage system are selectively determined by a user.
9. The method of claim 1 , wherein the first media vehicle and second vehicle are selected from the group of: television media, radio media, and print media.