Patent Application

App. No. 12/172,968

Abstract

Claims (96)

1 . A computer-implemented method for generating a unified advertising spot inventory database based on data existing in different formats stored on different systems, the method comprising:

gathering advertising inventory-related data existing in the different systems in different formats;

identifying various data elements in the gathered advertising inventory-related data; and

at least partly based on the identification, storing the gathered data in a plurality of records in a unified data store using a common set of schema.

2 . The method as defined in claim 1 , the method further comprising enabling a computer-based media market place system to access the unified data store.

3 . The method as defined in claim 1 , the method further comprising:

accessing radio inventory data from a first source in a first format;

using the common schema to store the radio inventory data in the unified data store;

accessing television inventory data from a second source in a second format; and

using the common schema to store the television inventory data in the unified data store.

4 . The method as defined in claim 1 , the method further comprising:

accessing out of home inventory data from a first source in a first format;

using the common schema to store the out of home inventory data in the unified data store;

accessing Web advertising inventory data from a second source in a second format; and

using the common schema to store the Web advertising inventory data in the unified data store.

5 . The method as defined in claim 1 , the method further comprising:

accessing data from a first source related to a first media inventory;

determining the type of media the first source data is associated with;

storing in a first record an indication as to the type of media the first source data is associated with;

accessing data from a second source related to a second media inventory;

determining the type of media a second source data is associated with, wherein the type of media the second source data is associated with is different than the type of media the first source data is associated with; and

storing in a second record an indication as to the type of media the second source data is associated with.

6 . The method as defined in claim 1 , the method further comprising:

accessing data from a first source related to a first media inventory of a first type;

identifying a first date range associated with the first media inventory;

storing the first data range in a first record;

identifying first days of the week associated with the first media inventory;

storing the first days of the week in the first record;

accessing data from a second source related to a second media inventory of a second type;

identifying a second date range associated with the second media inventory;

storing the second data range in a second record;

identifying second days of the week associated with the second media inventory; and

storing the second days of the week in the second record.

7 . The method as defined in claim 1 , the method further comprising:

accessing data from a first source related to a first media inventory of a first type;

identifying a first market identifier associated with the first media inventory;

storing the first market identifier in a first record;

accessing data from a second source related to a second media inventory of a second type;

identifying a second market identifier associated with the second media inventory; and

storing the second market identifier in a second record.

8 . The method as defined in claim 1 , the method further comprising:

accessing data from a first source related to a first media inventory of a first type;

identifying a first station identifier associated with the first media inventory;

storing the first station identifier in a first record;

accessing data from a second source related to a second media inventory of a second type;

identifying a second station identifier associated with the second media inventory; and

storing the second market identifier in a second record.

9 . A computerized method for encoding media related data for a plurality of media types from a plurality of data sources, the method comprising:

mapping data from a first source to a first schema using a first map and/or tags;

accessing data from the first source related to a first media spot;

determining the type of media the first source data is associated with;

storing in a first record an indication as to the type of media the first source data is associated with;

identifying a date range associated with the first media spot;

storing the data range in the first record;

identifying days of the week associated with the first media spot;

storing the days of the week in the first record;

identifying a market identifier associated with the first media spot;

storing the market identifier in the first record;

identifying a station identifier associated with the first media spot;

storing the station identifier in the first record;

identifying a demographic data associated with the first media spot;

storing the demographic data in the first record;

mapping data from a second source to a second schema using a second map and/or tags;

accessing data from the second source related to a second media spot;

determining the type of media the second source data is associated with, wherein the type of media the second source data is associated with is different than the type of media the first source data is associated with;

storing in a second record an indication as to the type of media the second source data is associated with;

identifying a date range associated with the second media spot;

storing the data range in the second record; and

enabling a computer-based media market place system to access the first record and the second record.

10 . The method as defined in claim 9 , wherein the first record and the second record are stored on the same system.

11 . The method as defined in claim 9 , wherein the first record and the second record are stored in unified database.

12 . The method as defined in claim 9 , wherein the data from the first source related to the first media spot is in a different format then the data from the second source related to a second media spot.

13 . The method as defined in claim 9 , wherein the first media spot is a radio advertising spot and the second media spot is a television media spot.

14 . The method as defined in claim 9 , the method further comprising:

identifying a price associated with the first media spot; and

storing the price in the first record.

15 . The method as defined in claim 14 , the method further comprising:

identifying a currency type associated with the price; and

storing the currency type in the first record.

16 . The method as defined in claim 14 , the method further comprising:

identifying a spot type associated with the first media spot; and

storing an indication as to the spot type in the first record.

17 . A system for integrating advertising inventory data from disparate data stores associated with disparate sources, comprising:

one or more network interfaces coupled to a plurality of disparate data stores associated with disparate sources, wherein the data stores supply advertising inventory data, wherein different data stores store data related to different types of advertising media in different formats;

a module that transforms the inventory data from the data stores into a common format;

a data store the stores the transformed advertising inventory data; and

an interface that provides access to the transformed advertising inventory data to a computer-based media transaction system.

18 . The system as defined in claim 17 , wherein the module is configured to transform advertising inventory data for radio spots and television spots into the common format.

19 . The system as defined in claim 17 , wherein the module is configured to transform inventory data for out of home advertising inventory into the common format.

20 . The system as defined in claim 17 , wherein the module is configured to map the following data elements to the common format:

media type;

spot type;

time period;

price;

ratings;

demographics.

Assignments (8)