Are you running paid ads without clear profitability? In this project, I detail a strategy to optimize campaign budgets for maximum ROI. My primary goal was challenging: Reduce the Customer Acquisition Cost (CAC) by 10% using advanced tracking and reporting. Here is the essential logic I implemented to shift budget from poor-performing campaigns to profitable ones: 1. The Decision Metric (The Red/Green Light) My Looker Studio Dashboard isn't just a visualization tool; it’s a decision engine. The first metric visible is the Actual CAC vs. Target CAC. If the actual cost is higher than the target, the entire campaign is immediately flagged RED, demanding urgent review. 2. Profitability is Key (ROAS) We never scale based on clicks. We only look at ROAS (Return on Ad Spend). By segmenting every Ad Set, we instantly identify those performing above target (GREEN). 3. The Action Rule STOP: Any Ad Set that shows a RED CAC or a low/zero conversion rate is paused to protect the budget. SCAL...
Technical sandbox demonstrating performance marketing setups from end-to-end. From constructing live analytics systems using GTM and GA4 to improving my full-funnel marketing strategy optimization efforts, all experiments are recorded here.