This is the window on which you specify the data that should be collected for the report that you will define on later windows and tabs. It displays (persists) the choices from your most recent collection. To use the most recent collection, check Previous Collection check box then click the Next icon button at the top of the window.
Defining a New Ad Hoc Collection
The Saved Criteria field at the top of the window enables you to save the selections on the Request window and use them again in the future. It is different from the Previous Collection check box (lower on the window) in that you might be working with multiple different sets of criteria, not necessarily the same collection.
Select a View from the drop down menu. These are defined in the Options | Data Layout | Ordered View Formats tab, and may be saved as Standard, Personal (teal), Office (purple) or Corporate (yellow) views.
On this Detailed Request window fill in the required fields and consider what you may want filter to not include in this collection.
You may use <Ctrl + Click> to select Actual Data Streams from the Additional Options section. However, you must use these with a report that shows multiple actual data streams, in a cross-tab report. See Ad Hoc Multiple Data Streams topic.
Click Include Data Streams if you are requesting multiple data streams.
Among the Additional Options for Bonus, ADU, Missed Units, Preempts, Unallocated, and Makegoods, choose from Include, Exclude and Only.
Click Stored Ratings to use the rating associated with the unit. Else, unchecked enables you to use calculated ratings created in the Options | Calculated Columns and later selected in the Data Layout tab.
Click the Include Traffic Rotation check box to show all the ISCIs that are eligible to be run for a unit from the ISCI Rotation definition. If the unit is assigned an ISCI, it shows the assigned ISCI. If not, and if a rotation def exists that would be for that unit, ISCIs from the rotation def for the product and length and date display.
Caution: Once you check this in a collection, it defaults to checked for all other inquiries, even when you exit and later re-enter this option.
Click the NTI Program Name check box to display the Nielsen Program Name.
If you need the Nielsen Program Name: Keep in mind that in order to be able to display the Nielsen Program Name, the unit must have been posted by Program Summary. It will have the NTI Code (numerical program code), the Post Method code (PS or PG), and the Matched code (T, I, or Y) assigned in the Buy Module Worksheet. All three codes must be defined for each unit.
If you don't need the Nielsen Program Name: Keep in mind that you can leave the NTI Program Name check box blank and speed up the collection process considerably.
You may click the check box to use the Previous Collection. Otherwise, if you have done other collections, you might want to specify Saved Criteria at the top of the window.
If you check any of the ”All” fields, leave the specific fields and groups blank.
You must specify a Start/End Date range if estimate and/or package is blank or use these dates to limit your collection..
You must key at least one demo.
Equivalency fields are optional. Fill in information to have the Ad Hoc do this equivalization.
The Broadcast calendar defaults. Use lookup to select another type of Calendar if desired..
You may key an Universe code for the Goals view.
Either click the <Submit> button at the top of the window to have Ad Hoc collect the data while you use any other option to do your work or click the Next icon to retrieve the previous collection or begin the new collection.
If you use <Submit>, when the Messages window pops up and/or the Messages icon at the top of your window begins spinning, return to this Ad Hoc option, click the Previous Collection check box and click the Next icon to display the View Tab.
Click <Messages> button to display the list of received system and personal server message. To delete any message, click to select, the click the Trash icon.
You may also send a brief message to any other UserID using this server by keying the UserID and a few words for the message. Click <Send>.
Ad Hoc Window Tabs
The View tab is the first one that displays your raw data. See the list of the next topics. Each of these tabs has its own explanation; choose one of these hyperlinks.
View is your raw data as collected. You may need to take further steps using the additional tabs and features to create the report you want to use in Print View.
Filters enables you to filter the data that displays. Advanced filters enables you to add color to highlight sorted data areas.
Options Offers four additional tabs (Data Layout, Image Pool, PDF Layout, Calculated Columns) for formatting and displaying your collection for a report. Each of these tabs has its own link below. Also, these options work the same as for several other Network options so they may become familiar to you.
Print View displays the final report as it would look printed. It is the result of all the changes you make on any/all of these tabs. You may print, save, and e-mail the displayed PDF of the report.