Multi-Platform Ads Data Platform

Project Overview

Built a comprehensive multi-platform data platform that ingests Meta and TikTok marketing data (ads, campaigns, insights, and creative assets) into a unified medallion architecture on BigQuery. The system provides cross-platform performance signals, benchmarking, and automated weekly Slack reports for marketing teams.

Key Challenges

• Multi-platform data ingestion with unified architecture
• Cross-platform performance benchmarking and comparison
• Complex medallion architecture implementation
• Real-time performance monitoring and alerting
• Automated reporting and signal generation

Results & Impact

• Fresh data available within ≤2 hours of change across both platforms
• Cross-platform performance insights and benchmarking
• Automatic Slack signals caught under-performing ads 24-48h faster
• Unified 7d/60d KPI comparisons across platforms and accounts
• BigQuery cost optimization via partitions and clustering