CASE STUDY
Marketing Campaign ROI Analytics
- Category
- Digital Marketing
- Year
- 2026
- Stack
- Meta Ads · Excel · Power BI
The Problem
Unclear return on ad spend across multiple social media marketing platforms.
The Solution & Value
Engineered a marketing analytics Star Schema using Power BI. Created dynamic dashboards mapping the full marketing funnel, utilizing DAX to measure CPA, ROAS, and conversion trends across seasons.
Sales Funnel Impact
Discovered Pinterest drove the highest ROI despite lower engagement, and Facebook excelled at brand awareness. Revealed winter campaign inefficiencies, enabling highly optimized, data-driven seasonal ad allocation.
Want to achieve similar results for your business?
Connect directly with Amr Mousa to discuss your project requirements.