Estimated Audience Research Request

You'll use the various fields and controls on the Estimated Audience Research Request window to specify what data that you want to present in your report.

You can click the Available Data button to view a listing of the rating surveys that are currently available as described in the View Available Audience Data topic.

In the Output Type section, specify the type of report that you want to generate.

- - Select the Tab Delimited File check box to create a file that you can then import into a spreadsheet program.
    
    When you select the Tab Delimited File, you will need to fill in the File Name field of up to 10 characters. You can also specify a description.
  - Select the Standard Report check box to create a report that you can print.
    
    When you select the Standard Report option, keep in mind that may need to limit the amount of information you request due to the fact that the report format may not be able to fit all the information on the dimensions of a sheet of paper. If you choose too many items, Network displays an error message informing you of the exact number of spaces by which you exceeded the report dimensions.

The Available Networks list box displays the Nielsen networks that you can choose from to create your research report. To select networks, scroll through this list, choose the desired networks and click the right arrow to add them to the Selected Networks list box. To remove a selected network, click the left arrow.

Use the Date Type drop down menu to select one of the available options:

Weeks
Months
Quarter
Years

When you change the date type, Network will display a confirmation dialog box that prompts you to convert all date ranges. Click OK to continue.

Specify the Start/End Dates for the following fields using codes appropriate to the selected date type.

The Add icon at the end of the first row allows you to add more date records.

Fill in the Program Start/End Dates fields.

Fill in the Hut Start/End Dates fields.

Key or Lookup the Universe code and then fill in the Universe Start/End Dates fields.

You may specify the rotation Days of Week to limit the report data. The Add icon at the end first row allows you to add more times and/or day/time combinations.

Start and End Times are not valid for Syndication--no data will print.

Days of Week

Start Time

End Time

The Available Columns list box displays all of the columns that you can include in your report.

To select columns, scroll through this list, choose the desired columns, and click the right arrow to add them to the Selected Columns panel.

As you add columns, they are assigned a number that indicates the order that the columns will appear on the report. The number 10 is the first column, 20 is the second column, 30 the third and so on. You can change the order of the columns by changing the numbers and clicking the Refresh icon

To remove a column, select the adjacent Remove check box and click the left arrow.

You can select the Sub-Average check box to average a column on the report. Doing so will provide either a summary of statistics or sub-average, depending upon the type of information you are averaging, whenever the statistic changes.

You can choose up to 23 demo codes for reporting the audience statistics. The Add icon at the end first row allows you to add additional demos.

You'll use the controls in the Formula Selections panel to create custom statistics based on a formula you specify involving one or more existing demo ID codes. The Add icon at the end first row allows you to add additional rows for your custom statistics.

Formula

Formula Decimals

Formula Heading 1/2

If you wish to stack statistics on printed reports, use the Multiple Statistics per Demo fields to specify the multiple statistics for each of the demos you typed in the Demo Selections fields. For a tab-delimited report, this is an efficient way to request many statistics for demos, which may be exported in a very-wide spreadsheet format.

Key or select from the drop down menu the types of statistics that you want for each demo. These are: blank, Composition, HUT/PUT, Impression, Rating, Share, Universe, and VPVH.

Blank is used when statistics are stacked. One demo must have only blank for its statistics.

Stack Statistics in Export

Determine whether to include or exclude certain Program Selections. If you need additional criteria to include or exclude, click the Add icon to add one or more rows.

Criteria

Type

Exclude

Key or Lookup a Daypart code to limit the report to one daypart. Use Add icon to add more rows.

If you want to leave the specified dayparts out of the report, select the Exclude check box.

Key a Filter code that you assigned to the Program Profile Definition in order to limit this report to only those programs with this filter.

If you want to leave the programs specified by the filter code out of the report, select the Exclude check box.

You can use the Program Names section to either include or exclude specific program names on the report. Use Add icon to add more rows to the Program Names section.

When specifying Program Names you can leave the wildcard filter drop down blank and then enter the exact title in the Program Name field. Alternatively, you can use the drop down to choose one of the wildcard filters Starts With or Contains and then key a few characters or words in the Program Name field.

If you want to leave the specified program out of the report, select the Exclude check box.

Use the Rating Decimal Positions drop down to Indicate the number of decimal positions for rounding the rating values. You may select from 0 to 2 from the drop down.

Leave Program Status blank to report all programs, or select a Active or Suspended from the drop down menu to report only those programs..

To exclude programs with a duration less than or equal to a certain length, key the number of minutes, up to 999 in the Maximum Excluded Duration field.

In the Maximum Number of Records field, key the maximum number of records to print on the report. If you are using sub-averaging, this setting apples to each average break. Ties are included on the report.

For the first demo/stat (Demo ID A) combination that you selected in the Demo Sections section, use the Minimum/Maximum Audience fields to indicate the minimum and maximum value for that statistic a broadcast must have to be included on the report. You may key up to nine digits and two decimal positions. Records with a value less than the minimum or more than the maximum are excluded.

To specify a subtitle for the report, key up to 50 characters.

To export a tab-delimited file to a spreadsheet, select the check box adjacent to the file and click the Save as XLS icon.