Selangkah Travel - Facebook Ads Performance Analysis
Comprehensive data-driven marketing analysis of Facebook Ads campaigns (Rp 1.8M spend, 346 conversions) with actionable insights on demographics, geographic performance, platform optimization, and 30/60/90-day scaling roadmap achieving 18:1 ROAS.
Project Overview
Objective
Analyze 38 days of Facebook Ads data to identify winning campaigns, optimize budget allocation, and provide data-driven scaling strategy
My Role
Data Analyst & Marketing Strategist - performed deep-dive analysis, created visualizations, and developed actionable recommendations
Timeline
3 days analysis + comprehensive report
Tech Stack
Python, Pandas, Facebook Ads API
Key Results
- ✓18 data-driven insights: Trip Bromo = 77% conversions (CPC Rp 3,838), Age 45-54 = 37% conversions (sweet spot), 65+ = lowest CPC (Rp 2,746)
- ✓Platform insights: Facebook Reels = 48% of all conversions (CPC Rp 3,924), Instagram Feed strong secondary (CPC Rp 5,014)
- ✓Geographic intelligence: Jakarta 44.6% share (0.81% conversion), Banten highest efficiency (0.96% conversion rate)
- ✓30/60/90-day roadmap: Scale from 116 to 400+ conversations/month, projected Rp 324M annual revenue from ads
Visual Documentation
Client Testimonial
Hanif's analysis was eye-opening. The data-driven insights helped us double down on what works and cut what doesn't. The scaling roadmap is practical and the ROI projections are exciting!