1. Project Overview

• This project evaluates the performance of three major advertising platforms: Google Ads, Microsoft Ads, and Meta Ads.
• Multiple bar graphs were created to compare key metrics across all platforms, providing insights for effective advertising strategies using Excel.

2. Metrics Analyzed

• Clicks: Total interactions with ads.
• CPC (Cost Per Click): Average cost per click.
• CTR (Click-Through Rate): Percentage of impressions that resulted in clicks.
• Cost: Total spending on each platform.
• Conversions: Number of desired actions taken by users.
• Revenue: Total income generated from conversions.
• CVR (Conversion Rate): Percentage of clicks leading to conversions.
• CPA (Cost Per Acquisition): Average cost to acquire a customer.
• RPC (Revenue Per Click): Revenue generated per click.
• ROI (Return on Investment): Measure of profitability.
• ROAS (Return on Advertising Spend): Revenue generated for every dollar spent.

3. Data Visualization

• Pivot Tables: Used to organize and summarize the data effectively.
• Bar Graphs: Multiple graphs were created to visually compare key metrics for all three advertising platforms.

4. Conclusion

• This analysis highlights the strengths and weaknesses of each platform, enabling marketers to make informed decisions for optimizing their advertising efforts.