Weekly Advertising Revenue Report

Track and analyze advertising revenue performance across channels, monitor key advertiser relationships, and evaluate inventory utilization to optimize revenue generation and identify growth opportunities.

Report Objective

Monitor weekly advertising revenue performance across traditional spot and digital channels, analyze key advertiser trends, and evaluate inventory utilization to drive revenue growth and identify optimization opportunities.

Revenue Performance Overview

Analysis of total revenue trends across spot and digital channels

Questions to Consider:

Mar 2024Apr 2024May 2024week_date$1,200,000$1,300,000$1,400,000total_revenuetotal_revenueHow is Weekly Revenue Trending?Total revenue trend with spot and digital components

  • What is the week-over-week change in total revenue?

  • How does current performance compare to the same period last year?

  • Are there any notable trends or patterns in revenue fluctuation?

  • How is the balance between spot and digital revenue evolving?

  • Which channel is showing stronger growth?

  • Are there opportunities to optimize channel mix?

Mar 2024Apr 2024May 2024week_date$0$200,000$400,000$600,000$800,000$1,000,000spot_revenuespot_revenueWhat is the Revenue Mix by Channel?Distribution between spot and digital revenue sources

Top Advertiser Analysis

Evaluation of key advertiser performance and category trends

Questions to Consider:

ABC MotorsQuickMartTechGiantLocalBankHomeStoreadvertiser_name$0$500,000$1,000,000$1,500,000$2,000,000sum(weekly_spend)sum(weekly_spend)Who are the Top Performing Advertisers?Revenue contribution by top advertisers and YOY growth

  • Which advertisers represent the largest revenue sources?

  • How concentrated is our advertiser base?

  • Are there any concerning trends in key account spending?

  • Which categories are driving the most revenue?

  • Is there appropriate diversity across categories?

  • Are there underperforming categories that need attention?

RetailAutomotiveFinancialTechnologycategory$0$500,000$1,000,000$1,500,000$2,000,000$2,500,000sum(weekly_spend)sum(weekly_spend)How is Revenue Distributed Across Categories?Revenue distribution by advertising category

Inventory Utilization

Assessment of inventory sell-through rates and pricing metrics

Questions to Consider:

80.0%82.0%84.0%86.0%sellthrough_rate$1,000$1,100$1,200$1,300avg_spot_rateHow Efficient is Our Inventory Utilization?Weekly sell-through rates and average spot rates

  • What is the relationship between sell-through rates and pricing?

  • Are we maximizing revenue potential through optimal pricing?

  • How can we improve inventory utilization?