Create a New Worksheet

Buys are entered into Broadcast using a worksheet format in the Buy Module. All worksheets are accessed using the Start Up tab.  

To create a new worksheet from the Start Up tab.

  1. Select the New Worksheet option.

Start Up Tab - New Worksheet

  1. The Company and Office fields are automatically filled in based on the codes you entered when you logged in to Mediaocean A|V. However, you can change the Company and Office codes if you have the authority to make buys for another company within your agency.

  2. If you have defined a Campaign ID for a product/estimate, you can use it as a shortcut on the Start Up tab. Just fill in the Campaign ID field and the Media, Client, Product, and Estimate fields will be filled in automatically.

  3. If you haven't defined a Campaign ID, key in the Media, Client, Product, and Estimate fields. (The Client, Product and Estimate are not required for a new worksheet but must be entered before the buy can be made active/approved.)

  4. You can enter a Market code or a Station/BC code.

  5. You must identify your worksheet by specifying a 1-12 character name in the Worksheet Code field. You can then enter a 1-29 character description in the Worksheet Description field.

(Keep in mind that the Worksheet Code lookup is sorted by Worksheet Description and numbers display before letters.)

  1. The Daily and Weekly radio buttons indicate the schedule type that was selected for the estimate via the Estimate Definition.

  2. The Flight Dates fields are automatically filled when you enter an Estimate code or a Campaign ID. Otherwise they can be left blank.

  3. Select an appropriate Rating Service option:

  4. Key an Estimated Book code to retrieve estimated ratings an display them the worksheet.

Estimated Ratings for Television

Estimated Ratings for Radio

      • Enter at least one Actual Book to retrieve audience figures. If you enter multiple Actual Books, you can create a multi-book average.

Notes:

ü If you entered a Campaign ID, you may leave the books fields blank and any books already defined for the Campaign
    ID will be retrieved.

If you are working in an unrated market, you will leave the books fields blank.

  1. The Demo fields are automatically filled in when you enter an Estimate code or a Campaign ID using the demo codes assigned in the estimate definition. They cannot be changed.

  2. Click OK to create the worksheet and activate the other tabs in the Buy Module. If books display you may change them if necessary.

  3. To continue:

Related Topics:

Defining a Campaign ID  

Estimate Definition