Marketing Campaigns Analysis
The client struggled to measure the true effectiveness and efficiency of campaigns across Meta platforms, lacking visibility into success drivers, platform comparisons, and seasonal spend variants.
Built an advanced Power BI marketing analytics platform featuring a Star Schema model with transaction data. Developed DAX formulas to calculate precise KPIs (CPA, ROAS, CTR, Conversion & Engagement rates) for Regular and High-Value segments.
Identified Pinterest as the highest ROI driver despite lower engagement, and Facebook excelled at brand awareness. Revealed winter campaign inefficiencies, enabling highly optimized, data-driven seasonal ad allocation.
Note: If the Microsoft Power BI service is blocked on your network, use the media tabs above.