MediaOcean/Prisma Print/OOH Data Definitions

advertiser_code

advertiser_code

The unique, alphanumeric code for the advertiser (client), or owner of the product being advertised.

advertiser_name

advertiser_name

The alphanumeric name for the advertiser (client), or owner of the product being advertised.

advertiser_short_name

advertiser_short_name

The unique, alphanumeric short name for the advertiser (client), or owner of the product being advertised.

buy_amount

buy_amount

The amount sent to the financial system for the buy line item. Primary metric, can be summed.

buy_detail_id

buy_detail_id

The buy detail's identification number assigned by Mediaocean.

buy_type

buy_type

This identifies the type of buy (submedia) the placement is for. This is also referred to as the media buy type to differentiate it from the financial buy type. The availability of individual buy types is controlled by the agency.

campaign_advertiser_code

campaign_advertiser_code

The code for the advertiser at campaign level.

campaign_advertiser_name

campaign_advertiser_name

The name of the advertiser at campaign level.

campaign_creation_date

campaign_creation_date

YYYY/MM/DD. The date the campaign was created.

campaign_end_date

campaign_end_date

YYYY/MM/DD Campaign end date.

campaign_id

campaign_id

The unique, alphanumeric public identifier for the campaign. This identifier is sent to the ad server, and appears in the campaign's URL. This is generated by Mediaocean.

campaign_name

campaign_name

This is sent to the ad server and is displayed on all documents.

campaign_planned_amount

campaign_planned_amount

The sum of the planned spend for all of the campaign's placements. This can be the same, greater, or less than, the campaign's budget. Can only be summed if you select distinct campaign IDs.

campaign_start_date

campaign_start_date

YYYY/MM/DD Campaign start date.

copy_deadline

copy_deadline

Print only. YYYY/MM/DD The date by which the media outlet needs to receive the print ad to ensure that it appears in the designated issue.

creative_due_date

creative_due_date

YYYY/MM/DD Creative due date. The date by which any creative materials must be delivered for the campaign.

cycle

cycle

OOH only. The ad size for the out-of-home (OOH) buy, such as a two or four-week cycle.

estimate_code

estimate_code

The three character numeric code used to identify the buy line item's estimate in the financial system for billing purposes.

geopath_id

geopath_id

OOH only. The unique, alphanumeric identifier for an out-of-home (OOH) unit, involved in performance measurement.

illuminated_panels

illuminated_panels

OOH only. The number of illuminated panels for OOH buys, such as on a billboard.

io_amount

io_amount

The monetary amount displayed for the accepted order on the order details and the order PDF in our buy system. This is available from when the order is created (so it's not only available for accepted orders). Can only be summed if you select distinct IO IDs.

io_id

io_id

The unique, alphanumeric public identifier for the order. This includes the revision number where appropriate.

io_status

io_status

The status of the order. Values: Accepted: The supplier has approved the order. AgencyAccepted: The agency has accepted the order.

month

month

MMM-YYYY The month and year the details are for.

ooh_end_date

ooh_end_date

OOH only. The end date for the out-of-home (OOH) buy.

placement_dimension

placement_dimension

Placement ad size.

placement_id

placement_id

The identifier for the placement, generated by Mediaocean. This is populated for line item-level buys and blank for supplier-level buys.

placement_market

placement_market

The name of the placement's geographic buying market.

placement_name

placement_name

Placement name.

placement_unit_type

placement_unit_type

The unit counted for billing purposes: For example, Clicks for a CPC cost method.

product_code

product_code

The unique, alphanumeric code that identifies the product.

regular_panels

regular_panels

OOH only. The number of regular (non-illuminated) outdoor panels. For example, billboards.

supplier_code

supplier_code

The code for the supplier the order was sent to. This is set to NULL for unassigned placements. It is defined in the associated financial system.

supplier_name

supplier_name

This is from the financial system. It is set to NULL for unassigned placements.

unit_no

unit_no

OOH only. The unique, alphanumeric identifier for the out-of-home (OOH) unit for tracking purposes. This is also referred to as the media outlet ID.