Low/High/Avg. Rate Report

Use this report to show the Lowest, Highest, and Average Unit Rate for a specified date range, regardless of billing frequency, by spot length.

Information Gathering

This report pulls spots from online log days for current and future log dates as well as current and historical invoices for any logs that are accepted for the specified date range. Be sure that if the report is run for future dates, that those logs dates are indeed online in VT Log Maintenance; otherwise, no spots will show up on the report for those days. This is an INCOME based report. Non-Spot Dollars will show up in the Other Column based on the "run date" or "billing date" of the item. Bumped Spots are included. A common grouping or filter for this report is by Daypart. The daypart info used on this report is found in VT by selecting the System Menu then Edit Stations. Then go to the Station Daypart Setup Tab. Be sure this section is set up correctly for each station when running this report by daypart.

 FYI - The report will show daypart information based on Spot Placement rather than the schedule target of the order.

Important Information

The report will also print an advertiser name associated with the Lowest/Highest/Average Rate found. Keep in my mind that there could be multiple advertisers that have that rate, and the report is only printing one occurrence. If the report is grouped by Schedule Target it will look at the spot's order to determine what absolute time or log event it is targeting.

Report Options

Grouping Options Filter Options Other Options
A/R Account
Date Scheduled
Daypart
Income Account
Primary Product Code
Salesperson
Schedule Target
Spot Type
Station
A/R Account
Advertiser
Daypart
Income Account
Primary Product Code
Salesperson
Spot Type
Schedule Target
Station
Include/Exclude Non-Commercial Spot
Include/Exclude Network Spots
Include/Exclude Zero Rate Spots
Include/Exclude Non-Spots
Gross/Net

Sample Report