Campaign analytics
I built daily reports to help the team compare campaign performance.
- Looker
- SQL
- Google Sheets
- Klaviyo
- Message Media
- OneSignal
Read the approach & limitations
I planned and ran campaigns through Klaviyo, Message Media, and OneSignal. As the campaign audience grew from 10,000 to 30,000, daily leads increased from 100 to 3,000.
I built a Looker dashboard with a daily refresh to give the team a consistent view of conversion rate, revenue per lead, and revenue per click. Breakdowns by account, landing page, creative, and audience helped connect campaign decisions to their results.
Campaign ROAS increased from 5× to 7×.For each unit of advertising cost we incurred on a campaign, the associated revenue increased from five to seven units. ROAS measures revenue relative to campaign advertising spend.
Campaign audience
Leads a day
Bars are drawn to scale.
The dashboard idea, rebuilt with invented data
Every number below is made up for this demo. It shows the layout, the daily refresh idea, and the breakdowns I built: overall, by account, by landing page, by creative, and by audience.
Hover or tap the chart to read a day.