📊 SunElectronics Ad Effectiveness Analysis

Project Overview

This project analyzes the performance of different Ads run by SunElectronics over the past year. The Ads were published on platforms like YouTube and Instagram with the goal of bringing customers to the website to purchase electronic items.

The analysis is focused on:

• Ad-wise performance using Cost Per Visit (CPV)
• Platform-wise performance using Cost Per Visit (CPV)

---

Objectives

1. Analyze each Ad to check how much was spent per visit (CPV).
2. Analyze each Ad Platform to see which one performed best in terms of CPV.

---

Business Questions

• Which Ad Platform had the lowest CPV?
• Which Ad Platform had the highest CPV?
• Which Ad had the lowest CPV?
• Which Ad had the highest CPV?

---

Key Findings

1. YouTube was the best-performing platform with the lowest CPV of ₹20.7.
2. Instagram had the highest CPV of ₹50.2 and did not perform as expected.
3. The "Holi Hungama" Ad had the best performance with a CPV of ₹20.9.
4. The "Summer Super Saver" Ad had the worst performance with a CPV of ₹121.1.

---

Summary Tables

Platform-wise CPV

Ad Platform	CPV (₹)
YouTube	20.7
Instagram	50.2

Ad-wise CPV

Ad Name	CPV (₹)
Holi Hungama	20.9
Summer Super Saver	121.1

---

Dashboard

-Dashboard Interaction View Dashboard