Paid Social Dashboard

Problem

The paid-social team judged creative performance by hand — scrubbing videos, eyeballing metrics across spreadsheets — while paying for expensive creative-reporting tools like Motion and Foreplay just to see what was working. Two subscriptions, and still no fast way to ask "which hooks, personas or styles actually drive ROAS?"

What I built

A Next.js bento-grid dashboard backed by an AI pipeline: every ad video is transcribed with Whisper, frames are OCR'd, then each ad is classified by hook, persona, style, voiceover and creator — all joined to live spend and revenue. The reporting those paid tools charge for, built in-house and tailored to how we actually work.

How it works

• Pulls creative and performance data from the Meta API and Google Sheets.
• A transcription pipeline (Whisper + frame OCR) extracts spoken hooks and on-screen text.
• A classifier tags every ad; metrics aggregate with weighted totals (ROAS = Σrevenue / Σspend).
• The dashboard slices performance by any tag in a fast bento layout.

Impact

Creative reviews that took hours became minutes — and it replaced our Motion and Foreplay subscriptions, putting that spend back in the budget. The tagging runs automatically every day.

(Screenshots redacted and figures mocked for confidentiality.)