Selangkah Trip - Data-Driven Marketing Campaign Analysis
Comprehensive marketing campaign performance analysis using PostgreSQL database analytics, tracking booking conversions and revenue growth from November to December 2025, achieving 170% booking increase and 79% revenue growth through data-driven optimization.
Project Overview
Objective
Analyze marketing campaign performance through database analytics to measure booking conversions, revenue growth, and customer behavior patterns, providing data-driven insights for optimization
My Role
Digital Marketing Analyst - performed database analysis, conversion tracking, revenue attribution, and generated actionable insights from booking data
Timeline
2-month campaign analysis (Nov-Dec 2025)
Tech Stack
PostgreSQL, SQL Analytics, Python
Key Results
- ✓Revenue Growth: 79% increase from November (Rp 36.6M) to December (Rp 65.5M), total Rp 102M in 2 months
- ✓Booking Conversion: 170% growth with 17 additional bookings in December (10 → 27 bookings)
- ✓Additional Revenue: Generated extra Rp 28.9M in December through optimized campaigns
- ✓Database Analytics: PostgreSQL queries for conversion tracking, revenue attribution, customer segmentation, and performance metrics
Visual Documentation
Client Testimonial
The data-driven approach to our marketing campaigns delivered exceptional results. The detailed analytics helped us understand what works, and the 170% booking growth speaks for itself. This analysis became our blueprint for scaling.