Subscription Campaign Optimization

Description

This analysis aims to optimize a telecommunication company's subscription drive through data-driven strategies. To do this, we analyzed and benchmarked campaign results across four categories: audience, location, creative, and inventory.

External Links

arrow

Tasks

  • Segmented 700+ audience records into 13 categories using Excel's regex, linking persona labels with VLOOKUP to ensure data integrity and accurate identification of top-performing personas.
  • Conducted A/B tests in R on various ad sizes and messaging variants to uncover statistically significant performance differences and inform creative strategy.
  • Built an interactive Tableau dashboard with to visualize 7 KPIs across personas and creatives, streamlining analysis while reducing visual clutter by 85%.

Tools

Microsoft Excel
Tableau
R

View Media

Report

Explore the Data!

For the best experience, please use a desktop to see the dashboard!

View Deliverables!

slide