Training course

Advertising queries and business objects

This article outlines the available Advertising business objects and where to find out-of-the-box queries related to Advertising.

Advertising business objects

Use the following business objects to query on Advertising data:

Returns the issue date for all media orders and includes the issue code, issue name, issue date, advertisement closing date, issue name, the last updated date, and more.

AdvertisingIssueDate business object

Returns information for each media asset defined, such as the code, name, product code, and more.

AdvertisingMediaAsset business object.

Returns information for media orders, such as the advertiser ID, advertisement type, issue date, media asset name, order status, proposal expiration date, and much more. Excludes representatives and territories.

AdvertisingMediaOrder business object.

Similar to AdvertisingMediaOrder, but also returns information for representatives and territories.

AdvertisingMediaOrderDetail business object.

Returns all inventory data associated with media orders.

AdvertisingMediaOrderInventory business object.

Returns media order sales with a display column for each month.

AdvertisingMediaOrderNetSalesByMonth business object.

Returns all data associated with media orders, including rate card details.

AdvertisingMediaOrderSummary bubiness object.

Advertising queries

Locate the out-of-the-box Advertising queries in the following locations:

  • $/Advertising - All out-of-the-box Advertising queries.
  • $/Samples/Dashboards/Advertising - The specific queries located on the Advertising dashboard.