Weekly Promotional Performance Analysis

Track and analyze the effectiveness of promotional campaigns across channels, focusing on revenue generation, discount strategy impact, and channel performance to optimize promotional ROI and customer engagement.

Report Objective

Monitor and evaluate the performance of promotional campaigns on a weekly basis, analyzing revenue impact, discount effectiveness, and channel-specific metrics to optimize promotional strategy and maximize return on investment.

Revenue and Discount Impact

Line chart showing weekly promotional revenue trends with discount rates

Questions to Consider:

2024-10-012024-11-012024-12-01week_date$220,000$240,000$260,000sum(promotional_revenue)How is Promotional Revenue Trending Weekly?Track promotional revenue performance with week-over-week comparison
  • What is the week-over-week change in promotional revenue?

  • Are there any seasonal patterns in promotional performance?

  • How do current revenue levels compare to previous periods?

  • Which promotion types generate the highest revenue?

  • How do discount rates affect revenue by promotion type?

  • What is the optimal discount rate for each promotion type?

Percentage OffBOGODollar OffFlash Salepromotion_type$0$2,000,000$4,000,000$6,000,000sum(promotional_revenue)What is the Impact of Different Promotion Types?Compare revenue generation across promotion types

Channel Performance Analysis

Bar chart comparing channel conversion rates and ROAS

Questions to Consider:

EmailSocial MediaDisplay AdsSearchchannel0.0%20.0%40.0%60.0%80.0%sum(conversion_rate)How are Different Channels Converting?Analysis of conversion rates across promotional channels
  • Which channels show the highest conversion rates?

  • How do conversion rates vary by promotion type?

  • Are there opportunities to optimize underperforming channels?

  • Which channels deliver the highest return on ad spend?

  • How has ROAS evolved over time for each channel?

  • What factors contribute to channel-specific ROAS performance?

EmailSocial MediaDisplay AdsSearchchannel0.020.040.060.080.0100.0sum(roas)What is the Return on Ad Spend by Channel?Compare ROAS across promotional channels

Areas for Optimization