Amazon PPC optimization project focused on reducing wasted ad spend and improving advertising efficiency.
Before vs. After:
• Ad Spend: $106,128 → $32,130
• ACOS: 55% → 21%
• Sales: $192,960 → $153,000
• Purchases: 8,973 → 7,118
I analyzed campaign performance, optimized targeting and budgets, refined keyword strategy, and continuously monitored PPC metrics to improve overall campaign efficiency. The comparison highlights the measurable impact of the optimization work.
I created an interactive Excel dashboard to analyze sales performance across different business dimensions.
Key Insights & Features:
• Total Orders, Sales & Profit KPIs
• Sales & Profit by Region
• Sales by City
• Category-wise Sales, Profit & Profit %
• Weekly Sales Analysis
• Interactive Slicers for Week, Category & Region
• Start Date & End Date tracking
• PivotTable-based analysis
This dashboard is designed to turn raw sales data into clear and actionable business insights using Excel.