OTT Campaign Dashboard

Automated multi-platform campaign tracking and optimization system

PROJECTS OVERVIEW

Built a comprehensive automated performance tracking system for a $35,000 OTT advertising campaign across four major streaming platforms (Hulu, Roku, Pluto TV, and Amazon Fire TV).

The dashboard provides real-time campaign monitoring, automated KPI calculations, platform comparison analysis, and visual performance reporting to support data-driven optimization decisions in programmatic advertising operations.

Link to excel

MY ROLE:

Campaign Analytics Developer (Solo Project)

Responsible for complete end-to-end development including:

  • Data structure design and workflow architecture

  • Formula implementation and automation logic

  • Visualization creation and dashboard UX design

  • Alert system configuration

  • Quality assurance and testing

Time Investment: 6 hours of focused development

Results/Insights:

Dashboard enables daily monitoring and identified Hulu as the most cost-efficient platform with lowest CPA.

Objective:

Create an automated dashboard system that:

  • Tracks key OTT advertising metrics in real-time

  • Identifies performance issues and opportunities automatically

  • Provides visual reporting for account management teams

  • Enables fast, data-driven campaign optimization decisions

  • Reduces daily reporting time from 30+ minutes to under 5 minutes

Key Features:

  • Automated performance calculations

  • Platform comparison analysis

  • Visual reporting with charts

  • Budget pacing alerts

TOOLS & SKILLS

Technical:

  • Google Sheets (Advanced formulas and functions)

  • Data analysis and aggregation (SUMIF, INDEX/MATCH, VLOOKUP)

  • Conditional formatting and alert systems

  • Data visualization (charts, graphs, visual dashboards)

  • Cross-sheet references and dynamic calculations

Industry Knowledge:

  • OTT/CTV advertising metrics (CPM, VCR, CTR, CPA)

  • Campaign pacing and budget management

  • Multi-platform performance analysis

  • DSP operations workflow understanding

Core Skills:

  • Analytical problem-solving

  • Data organization and structure

  • Process automation

  • Dashboard design principles

  • Quality assurance testing