Back to showcase

Marketing dashboard for a SaaS

Power BI

About this project

  • Paid acquisition across web, iOS and Android: 6 channels, 8 networks, 19 campaigns
  • Vitals: spend, new clients, conversion into paid, time to activation, CAC, 90-day ROAS, each vs last year
  • Daily dynamics per vital, against the same days last year
  • Period: last 7 or 30 days, month or quarter to date, custom range; vs previous period, last year or plan
  • Filters: platform, market, sales tier, channel, network, campaign, attribution model
  • Overview: acquisition funnel, guardrails, anomalies, top movers by ROAS change, spend vs plan with paid CAC
  • Channels: spend, CAC, ROAS, pacing, web vs app funnel, down to platform
  • Campaigns: pacing, CPA, ROAS, CTR trend, frequency, fatigue flags; keywords and placements; churn and refunds
  • Journey and cohorts: landing pages, onboarding steps, activation; payback, retention, LTV:CAC by channel
  • Complex ETL under the hood and data prep