Analyzed 1,143 Facebook ads across 3 campaigns to identify wasted ad spend and high-performing audiences. Built CTR, CPC, CPA, and Conversion Rate metrics using Python, Pandas, and Matplotlib.
Key findings:
• Ages 45-49 used 35% of budget but generated only 19% of sales.
• Ages 30-34 produced 46% of sales with only 26% of budget.
• 25% of spend generated enquiries but no sales.
Recommendation: shift budget toward better-performing audiences and investigate low-converting leads.