Use this report to show the Lowest, Highest, and Average Unit Rate for a specified date range, regardless of billing frequency, by spot length.
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.
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.
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 |