Monthly Broadcast Ad Sales Performance Report

Comprehensive analysis of broadcast advertising spot performance focusing on revenue generation, inventory utilization, and performance across dayparts and advertiser categories. This report tracks key metrics including sell-through rates, ratings delivery, and category distribution to support strategic sales planning and inventory optimization.

Report Objective

Monitor and analyze monthly broadcast advertising spot performance across revenue, inventory utilization, and audience delivery metrics. Identify trends in advertiser category mix and daypart performance to optimize pricing and inventory allocation strategies.

Revenue and Inventory Performance

Track monthly revenue trends and inventory utilization metrics

Questions to Consider:

Mar 2024Apr 2024May 2024month$1,400,000$1,500,000$1,600,000revenuerevenueHow is Monthly Revenue Trending?Revenue performance shows typical seasonal patterns with peak in Q4
  • What is the month-over-month revenue growth rate?

  • How does current performance compare to seasonal expectations?

  • Are there any notable trends in revenue patterns?

  • How efficiently are we selling our available inventory?

  • Are there specific months where sell-through drops significantly?

  • What is the relationship between sell-through and revenue?

Mar 2024Apr 2024May 2024month0.0%20.0%40.0%60.0%80.0%sellthrough_ratesellthrough_rateWhat is Our Inventory Utilization?Sell-through rates indicate strong demand across most months

Daypart Analysis

Analyze performance metrics across different dayparts

Questions to Consider:

PrimeEveningDaytimeMorningdaypart0.0%200.0%400.0%600.0%sum(revenue_share)PrimeEveningDaytimeMorningHow are Different Dayparts Performing?Prime time continues to deliver strongest revenue share with consistent ratings
  • Which dayparts are exceeding or falling short of expectations?

  • How does revenue share align with ratings delivery?

  • Are there opportunities to optimize pricing in specific dayparts?

Advertiser Category Mix

Examine revenue distribution across advertiser categories

Questions to Consider:

  • How concentrated is our revenue across categories?

  • Which categories show the most growth potential?

  • Are there seasonal patterns in category performance?

RetailAutomotiveHealthcareEntertainmentFinancialcategory$0$1,000,000$2,000,000$3,000,000$4,000,000$5,000,000sum(category_revenue)RetailAutomotiveHealthcareEntertainmentFinancialWhat is the Distribution of Revenue Across Categories?Retail and Automotive remain top revenue contributors